Why does CSV product import to POS system keep failing?

Shopify Discussion
1

I am trying to import our csv file of products (we are switching from our old pos to shopify so a lot of products). These are the errors that keep occuring after I upload and I do not know how to fix them. I’m really not looking to hire someone to fix these problems, just wanted to know the fastest solution! I know these products do not have over 100 variants. Why is the file being read this way?

Capture.JPG
Capture.JPG836×749 114 KB

Thank you!
Line 2-43: Validation failed: The variant ‘14’ already exists.
Line 45-264: Validation failed: Exceeded maximum number of variants allowed
Line 277-292: Validation failed: The variant ‘Large’ already exists.
Line 294-303: Validation failed: The variant ‘small’ already exists.
Line 305-528: Validation failed: Exceeded maximum number of variants allowed
Line 531-662: Validation failed: Exceeded maximum number of variants allowed
Line 664-928: Validation failed: Exceeded maximum number of variants allowed
Line 933-941: Validation failed: The variant ‘XL/XXL’ already exists.
Line 943-994: Validation failed: The variant ‘Medium’ already exists.
Line 997-1005: Validation failed: The variant ‘Default Title’ already exists.
Line 1008-1026: Validation failed: The variant ‘Xlarge’ already exists.
Line 1028-1035: Validation failed: The variant ‘Small’ already exists.
Line 1043-1086: Validation failed: The variant ‘Default Title’ already exists.
Line 1094-1095: Validation failed: The variant ‘default Title’ already exists.
Line 1098-1147: Validation failed: The variant ‘Default Title’ already exists.
Line 1149-1150: Validation failed: The variant ‘Large’ already exists.
Line 1152-1153: Validation failed: The variant ‘Default Title’ already exists.
Line 1158-1164: Validation failed: The variant ‘Small’ already exists.
Line 1166-1216: Validation failed: The variant ‘XL’ already exists.
Line 1219-1298: Validation failed: The variant ‘XL’ already exists.
Line 1305-1339: Validation failed: The variant ‘Large’ already exists.
Line 1341-1484: Validation failed: Exceeded maximum number of variants allowed
Line 1487-1542: Validation failed: The variant ‘Small’ already exists.
Line 1544-1550: Validation failed: The variant ‘Default Title’ already exists.
Line 1552-1557: Validation failed: The variant ‘Small’ already exists.
Line 1559-1564: Validation failed: The variant ‘8’ already exists.
Line 1566-1579: Validation failed: The variant ‘Small’ already exists.
Line 1581-1640: Validation failed: The variant ‘Large’ already exists.
Line 1643-1730: Validation failed: The variant ‘Default Title’ already exists.
Line 1734-1735: Validation failed: The variant ‘Default Title’ already exists.
Line 1738-1748: Validation failed: The variant ‘Small’ already exists.
Line 1753-1762: Validation failed: The variant ‘Default Title’ already exists.
Line 1766-1777: Validation failed: The variant ‘Xlarge’ already exists.
Line 1801-1816: Validation failed: The variant ‘Default Title’ already exists.
Line 1843-1861: Validation failed: The variant ‘Default Title’ already exists.
Line 1873-1881: Validation failed: The variant ‘Large’ already exists.
Line 1884-2056: Validation failed: Exceeded maximum number of variants allowed
Line 2060-3708: Validation failed: Exceeded maximum number of variants allowed

2

If you’re adding a lot of products it can be difficult using the built in Shopify import tool as the errors just aren’t that easy to decipher/spot. Best bet is to use an app called Excelify ( https://apps.shopify.com/excel-export-import ). It gives you much clearer error messages and in the spreadsheet you have uploaded (use Google Sheets, you don’t have to convert to CSV with Excelify). Will cost you a few $$ but save you a lot of pain. And once you’re done with it you can end your subscription, so you’ll just get charged 1 month.

Failing that if you don’t want to use that app then you need to examine the CSV file you uploaded and then relate the CSV row number that the errors are referencing (you’ll need a text editor like http://brackets.io/ to open your CSV file with the row numbers shown) to the corresponding products in your spreadsheet. Then pick through and work out what you need to fix.

Hope that makes sense.

3

Hi @hollysinboone

I found this writing about Common Import Issues on Shopify and How to Fix Them on Avada’s website.

Hope it helps!

4

Verify that your handle is unique for each individual product, products with variants can have same handle