Shopify CSV import error
“Inventory quantity is not a number / Inventory quantity can't be blank”: what it means and how to fix it
Why it happens
- Text such as “in stock” or “10+” in the quantity column.
- Decimals such as 4.5.
- An empty quantity for a variant whose Variant Inventory Tracker is set.
How to fix it
- Use whole numbers only: 0, 12, 140.
- If you don't track stock for a variant, leave Variant Inventory Tracker blank.
- For several locations, use Shopify's separate inventory CSV, or a per-location column in a bulk app.
How Bulkvane handles it
In Bulkvane, stock is one “Inventory: <location>” column per location. Values must be whole numbers (“Inventory at Main warehouse must be a whole number (found “ten”).”), and empty cells never change stock. If stock changed between the preview and the import, that variant is skipped rather than overwritten. See bulk updating inventory by location.
Every file is checked before anything changes, with problems named by row in plain words, and any import can be undone for 30 days. All of Bulkvane's messages are in Errors A–Z.
Questions
Does the export's inventory column import back?
In Bulkvane, Variant Inventory Qty is the total across locations, exported for reference only. Change the per-location columns instead.
Message, cause and fix from the Shopify Help Center: common product CSV import issues, checked . Still stuck? See Shopify CSV import not working? or ask us.
Preview every change.Undo any import for 30 days.
Install free