Shopify shows "Inventory policy is not included in the list" when a product CSV row has a value in the Continue selling when out of stock column (called Variant Inventory Policy in older files) that isn't one of the two words Shopify accepts: deny or continue, in lowercase. Blank cells on variant rows, "Deny" with a capital, "yes", "no", "TRUE" or a stray space all trigger it. Fix the column, save as CSV, and import again.
The short version
- The column accepts only deny (stop selling at zero, the default) or continue (keep selling).
- Use lowercase, no spaces, on every variant row.
- Older exports call the column Variant Inventory Policy. Same rule.
- Spreadsheets sometimes autocorrect "deny" to "Deny". Turn autocorrect off or fix it after.
- If you don't track quantities, set the column to deny anyway; it has no effect without tracking.
Step by step
- Open the CSV in a spreadsheet.
- Find the Continue selling when out of stock column (or Variant Inventory Policy).
- Filter it to see every distinct value. Anything other than deny or continue is the problem.
- Replace each wrong value:
- "Deny", "no", "FALSE", blank on a variant row: deny
- "Continue", "yes", "TRUE": continue
- Trim spaces: in a spare column,
=TRIM(LOWER(A2)), then paste the values back. - Save as CSV (UTF-8), and import again.
Why it happens
- Files from another platform. A CSV converted from another store uses that store's words, like "allow" or "backorder".
- Spreadsheet autocorrect capitalizes the first letter of a cell.
- Rows added by hand. A new variant row copied without the column filled in.
- Image rows. Extra rows that only add images have no variant, so the column should be empty there. If you've filled it on those rows, clear it.
A made-up example
Kauai Kettle Corn moves 46 products into Shopify from a supplier's spreadsheet. The import fails on 31 rows. Filtering the column shows three values: "deny", "Deny " (with a trailing space) and blank. The owner replaces all of them with deny, except the four seasonal tins sold as preorders, which get continue. The next import goes through. Shopify continue selling when out of stock explains when continue is right.
Other columns that cause the same kind of error
- Inventory tracker: must be shopify, or blank for untracked.
- Inventory quantity: a whole number, and only for single-location stores; for several locations use the inventory CSV.
- Cost per item: a number with no currency symbol.
- Barcodes: formatted as text, so leading zeros survive.
Shopify inventory CSV template covers the separate inventory file, and Shopify bulk update inventory covers the bulk editor.
Where this stops working
Getting the import through puts your products in Shopify. It doesn't put in what they're made from. A product CSV has no place for ingredients, recipes or batch costs, so a maker who imports 46 products still has the kettle corn kernels, oil, sugar and tins in a separate sheet. Shopify raw materials inventory covers where that sheet usually goes wrong.
How TaroStack does it
TaroStack for Shopify runs inside your Shopify admin, reads your Shopify products as they are, and adds the parts a CSV can't hold: ingredients and packaging with their suppliers, recipes that say what each product uses, and batches with lot codes. Its Smart Imports read your existing spreadsheets, so the separate sheet comes in too. Free for 14 days.
