Characters to avoid to fix missing products when importing CSV

Jason Chiu

07 Dec, 2012 01:51 AM

Hi CO Community,

Short Answer: Replace commas (from the name and description fields) and carriage returns from the description fields.

Long Answer:
Just wanted to share my workaround to a peculiar problem I've seen in this forum regarding product updates not importing properly. On a monthly basis, I export a dump of my products in CSV format to tweak my pricing strategy, add barcodes, etc which I then bulk-load back into Checkout. I hired a new assistant recently who spent a few days in Checkout populating the description fields of each product with racking information so that we can more efficiently locate our many SKUs.

Upon performing my monthly bulk-load this month, I noticed the importer showing a preview of only ~90 products (when my CSV has approximately 1,200 SKUs). By taking a closer-look at the products that did preview in the importer, we noticed that it did not like commas in both the name and description fields. Doing a simple search and replace for commas immediately resulted in the importer showing almost all the SKUs. What we found interesting is that although Checkout may not like commas in the description (which users can learn to omit), it is Checkout that auto-populates the name field value with commas when you create products with variations (e.g. a toothbrush SKU that has 2 variations: Toothbrush, soft, red).

Finally, there was about a dozen products which still wouldn't import, and we simply found that it was carriage-returns in the description fields.

Anyway, long-winded observation and troubleshooting that worked for me. Hope this may help some of you out there :)

Suggestion to the CO team: If the devs could add something in the manual or knowledge base on what special characters don't work well with the importer, that would be very helpful. I also have a sneaking suspicion something happens when opening and saving CSV/XLS files in different versions of Microsoft Excel (I'm using 14.2.5, MS Excel for Mac 2011) which might cause problems for different users.

  1. 2 Posted by Jonathan White on 07 Dec, 2012 07:59 PM

    Hi Jason

    Thanks for a very detailed posting. I'll refer back to it if the issue ever comes up with any of my Checkout customers

    Jonathan

  2. 3 Posted by Conor on 09 Dec, 2012 04:06 AM

    thanks for this post, this will greatly help in cleaning up our database. I noticed some funky stuff happening with export/imports and thought it might be carriage-returns but now this confirms it. At least I can see it in excel so I know what products to edit.

  3. CO Michele closed this discussion on 02 Apr, 2013 12:55 PM.

Comments are currently closed for this discussion. You can start a new one.