How to solve CSV import issue on an ecommerce platform?

Hey, @cloudata !

Lizzy here. I’m from Shopify.

Thank you for sharing that screenshot! With CSV imports there are a few details you need to make sure of for the import to complete correctly. What sort of changes are you looking to make to your products with the CSVs?

In general, the first thing I recommend, is downloading the sample CSV directly from this help page here. That way you can ensure you are using the correct template.

While working on a CSV, another thing to watch out for is that the program you are using on your computer will sometimes adjust the file. Do you mind if I ask which program you’ve been using? Excel in particular can cause these kinds of adjustments. Some alternative program options which won’t affect your CSVs are:

  • Numbers - By default installed on any mac.
  • Google Sheets - Free to anyone with a google account.
  • Open Office - Free to download and use.

You’ll also want to make sure the file is correctly encoded and exported as a .csv. Your CSV files must use UTF-8 encoding. If these steps aren’t followed correctly, our systems may not be able to read all of the information. This help doc explains a bit more about that.

Aside from this, I was also wondering how you’ve been finding running a business on Shopify so far? Is your store where you expected it to be at this time, why or why not?

Please feel free to continue the conversation and share any questions about what I’ve said!

Thank you,
Lizzy