Solutions to common import problems

If you're having a problem uploading your product CSV file, then see if the problem is listed below with a solution. If you're still having problems, contact the Shopify Support team.

I tried to upload my CSV and a "Choose column headings" window appeared

This window appears when the headers of your CSV file are incorrect. You can choose the correct headers from the drop-down menu to help you import your CSV file to Shopify.

Invalid CSV Header: Missing headers

The first line of your CSV file should be:

Handle,Title,Body (HTML),Vendor,Type,Tags,Published,Option1 Name,Option1 Value,Option2 Name,Option2 Value,Option3 Name,Option3 Value,Variant SKU,Variant Grams,Variant Inventory Tracker,Variant Inventory Qty,Variant Inventory Policy,Variant Fulfillment Service,Variant Price,Variant Compare At Price,Variant Requires Shipping,Variant Taxable,Variant Barcode,Image Src,Image Alt Text

Remember to check for extra white spaces at the end of the first line.

Missing or stray quote on Line

This can be the result of Excel adding curly quotes (smart quotes). These need to be replaced with straight quotes. To resolve this issue, open the file using a text editor, and do a Search and Replace to change “ “ into quotes that look like this - " ".

Another possible cause is an extra quote has been added. Again open the file in Text and find the line causing the error. Once you're there check the fields for stray quotes.

Illegal quoting on line xxxx

This error is caused when there is an illegal character in the CSV file that you are trying to import. To rectify this, the most important thing to remember is that your CSV file must be UTF-8 encoded.

Sometimes, this error is caused by a missing or stray quote. Check out the solution (above) to see how to resolve this.

Line #-##: Validation failed: Options are not unique

This error is caused when a product has duplicate options. You might have set up a product with two variants with the same option values (for example, 2 Medium products, both in Black). If the option values are unique, a product could be duplicated else where in the CSV with the same handle.

Validation failed: getaddrinfo: nodename nor servname provided, or not known

This error is caused when there is a mistake in the image URL. The image URL has to have http:// in front of it. It also has to be a publicly accessible direct link to the image.

There are random characters in my export, do you handle international languages?

Shopify supports any language or characters that are included in the UTF-8 encoding. If you're seeing strange characters in your product descriptions, it probably means your CSV file isn't in the UTF-8 encoding. To fix it, open the file in Notepad. Save it again at once, making sure that you specify UTF-8 encoding in the Notepad Save dialog.

Validation failed: Price can't be blank

The price needs to be added to this line.

Inventory quantity can't be blank

The inventory quantity needs to be set. If your not tracking inventory make sure the Variant Inventory Tracker is left blank, otherwise Shopify will look for a inventory quantity.

Inventory quantity is not a number

You need to enter a number value for the quantity of items in stock.

Inventory policy is not included in the list

The inventory policy needs to be set to 'deny' or 'continue'.

Fulfillment service can't be blank

You need to enter the name of the fulfillment service you're using. If you're not using a fulfillment service this should be set to "manual".

Ignored line #-## because handle "example" already exists.

The handle is used to uniquely identify each individual product. Make sure you have a unique handle for each product in your CSV.

Line #: incorrect header check

Try removing the image from that line and try again. If that resolves the issue try hosting the image somewhere else.

Ignored line #-## because it did not contain product data.

This means that there is at least one product with a handle, but no product title.

Want to discuss this page?

Visit the Shopify Community

Ready to start selling online with Shopify?

Try it free