How to Solve Common Import Problems on Shopify

The fulfillment service you’re using should be entered in the right area. If you’ve not selected a fulfillment services, then you set this option to ‘Manual’.

This error will display when there is a product (or more than one) that has a handle but does not have a product title. You need to find that product and give it a title.

This will display when an illegal character has been used within the CSV file that you’re importing. To remedy this, encode your CSV file within UTF-8 encoded format. This error can sometimes be caused by a missing or stray quote.

This can happen when an image has an error. To solve this, try removing the image from the line and then try uploading again. If this has resolved the image, you might need to try hosting the image on another platform.

This is caused by the line of the CSV file being incorrect. To solve this, the first line of your CSV 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

Be sure that there are no extra white spaces at the end of the first line. This is a common mistake.

This happens when the inventory policy is not set to either ‘deny’ or ‘continue’. Ensure the correct settings are in place.

Within the numbers, you need to set an inventory quantity. If you’ve not been tracking inventory, then you need to check that Variant Inventory Tracker is also left blank.

When the inventory quantity has a letter or special character in it, you need to remove them otherwise you will get this error.

This is the result when Excel or another spreadsheet program adds a curly quote or more than one. These need to be replaced within the document with straight quotes.

Another possible problem is when there is an extra quote that has been added to the file. Find the error and remove this.

This means that there is an image file missing

This is what happens when there’s a mistake in the image’s URL. The uploaded image would require to have the http:// at the beginning. You should also ensure that the image is publicly accessible.

When a product has numerous options, they should all be unique. If there are any duplications within the variants you will see this. If there are only unique variants, then there could be a duplicate CSV.

A product doesn’t have a price within the CSV.

The image file size is too large. It needs to be reduced to 5760 x 5760 pixels or be less than 20 megapixels.