How to fix it
- Replace each listed value with a whole number, for example 1200.
- Spreadsheet programs sometimes reformat numbers; check the cell in a plain text editor if it looks right in the spreadsheet.
Example
A file with this problem
Title,URL handle,Status,Option1 name,Option1 value,Price,Inventory tracker,Inventory quantity,Continue selling when out of stock,Fulfillm... Cotton Tee,cotton-tee,active,Size,S,20.00,shopify,ten,deny,manual,
What the checker says about it
- Line 2: Inventory quantity "ten" is not a whole number ("Inventory quantity is not a number").
Once the listed rows are fixed, check the file again; the checker also looks for every other problem Shopify documents, so you do not trade one error for the next.
Questions
- What does "Inventory quantity is not a number" mean in Shopify?
- Inventory quantity holds something other than a whole number: a word such as "ten", a decimal such as 2.5, a thousands separator such as 1,200, or a note such as "in stock".
- How do I fix it?
- Replace each listed value with a whole number, for example 1200. Spreadsheet programs sometimes reformat numbers; check the cell in a plain text editor if it looks right in the spreadsheet.
Other Shopify import errors
- Validation failed: options are not unique
- Validation failed: price can't be blank
- Inventory quantity can't be blank
- Inventory policy is not included in the list
- Fulfillment service can't be blank
- Ignored line because handle already exists
- All checks
Sources
- Shopify Help Center: Solutions to common product CSV import problems: https://help.shopify.com/en/manual/products/import-export/common-import-issues
Based on Shopify's help pages for product CSV import. Not tested on a live store.