Common Error which you face while importing CSV:
Sometimes you’re having a problem uploading your product CSV file, then see if the problem is listed below with a solution.
1) INVALID CSV HEADER: MISSING HEADERS
The sequence 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.
2) MISSING OR STRAY QUOTE ONLINE
This can be the result of Excel or another spreadsheet program adding curly quotes (smart quotes). These need to be replaced with straight quotes. To resolve this issue, open the file using a text editor, do a search and replace change “ “ into quotes that look like this: ” “.
Another possible reason is an extra quote has been added. Again open the file in a text editor and find the line causing the error. Once you’re there check the fields for stray quotes.
3) LINE #-##: VALIDATION FAILED: OPTIONS ARE NOT UNIQUE
This error is caused when a product has duplicate(double) options. You might have set up a product with two variants with the same option values (for example, 2 small sizes of T-shirts, both in black color). If the option values are unique, a product could be duplicated elsewhere in the CSV with the same handle.
4) 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.
The Handle must be required when you want to add the variant.
5) VALIDATION FAILED: PRICE CAN’T BE BLANK
The price needs to be added to this line.
6) ILLEGAL QUOTING ONLINE
This is a coding error as you have an illegal character in your CSV file you’re trying to import into this task. In other words, the most important takeaway for your project is that your CSV should be UTF-8 encoded.
7) 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.
8) 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.
Sometimes, this error is caused by a missing or stray quote. Check out the solution (above) to see how to resolve this.
9) VALIDATION FAILED: GETADDRINFO: NODENAME NOR SURNAME PROVIDED, OR NOT KNOWN
This error is caused when there is a problem or 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.
10) INVENTORY QUANTITY IS NOT A NUMBER
You need to enter a numeric value for the quantity of items in stock.
11) INVENTORY QUANTITY CAN’T BE BLANK
The inventory quantity needs to be set. If you are not tracking inventory makes sure the Variant Inventory Tracker is left blank, otherwise, Shopify will look for an inventory quantity.
12) 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.
13) INVENTORY POLICY IS NOT INCLUDED IN THE LIST
The inventory policy needs to be set to ‘deny’ or ‘continue’.
