Ecommerce · inventory operations
Inventory CSV changes, made visible.
Validate a Shopify inventory CSV, then compare it with the untouched export to see exactly what will change. Both files stay in this browser tab.
Checks both Shopify formats: All states (recommended, with safety validation) and Available (location columns). Quantities must be whole numbers, 0, negative whole numbers, not stocked, or blank.
How to validate a Shopify inventory CSV
- Choose the edited inventory CSV you plan to import.
- Optionally add the untouched Shopify export for a row-by-row comparison.
- Press Validate and compare.
- Review the problems and download the diff as a CSV.
What is checked
The tool recognises the All states and Available inventory exports, checks CSV quoting and row width, and requires the Handle, Location and Option 1 Value columns that identify a variant at a location. Quantities must be whole numbers, including negative numbers and zero, and the values Shopify documents for not stocked and blank are accepted.
When you also provide the original export, the tool shows exactly which rows changed and warns about edits to columns that are snapshots rather than inputs. A visible diff is the best protection against importing a spreadsheet that quietly zeroed out stock because of a sorting mistake or a pasted formula.
Both files stay in this tab
The validator runs in your browser, inside an isolated frame on this page that has no network access. Your file is read and written back by your own device, so it is not uploaded to TNAADO or anyone else, and nothing is stored. The advertising on this page sits outside the frame and cannot see what you choose. Inventory and cost data are commercially sensitive and are not uploaded.
- Keep a copy of the original export until the import is confirmed.
- Rules were checked against Shopify's help centre; confirm current rules if an import is rejected.
What is checked
| Area | Check |
|---|---|
| Format | Recognises All states and Available exports; checks CSV quoting and row width. |
| Required identity | All states files need Handle, Location, and Option 1 Value to identify a variant and location. |
| Quantity | Whole numbers only, including negative numbers and 0; not stocked and blank are accepted where Shopify documents them. |
| Safety validation | When an original export is supplied, changes to On hand (current) and other read-only inventory-state columns are errors. Export fresh data instead of overwriting the snapshot. |
| Packed dimensions | All four packed columns must be filled or all blank. Dimensions are positive numbers, unit is cm or in, and every location/bin row for a variant must agree. |
| Diff | Lists changed quantity and metadata cells, added rows, and rows omitted from the edited file. |
Shopify recommends the All states export because On hand (current) acts as a safety snapshot. If live inventory changes after export, Shopify rejects affected rows rather than silently overwriting the newer count. Clearing that snapshot bypasses the protection and should be reserved for emergencies.
Official source: Shopify Help: Exporting and importing inventory with a CSV file. Shopify states the inventory CSV cannot exceed 15 MB.
Private by design
The files are read and compared locally. Nothing is uploaded, stored, logged, or sent to Shopify. Always review Shopify’s own import summary before starting the import.