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.

Official Shopify Help rulesChecked 2 October 2026

How to validate a Shopify inventory CSV

  1. Choose the edited inventory CSV you plan to import.
  2. Optionally add the untouched Shopify export for a row-by-row comparison.
  3. Press Validate and compare.
  4. 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.

What is checked

Shopify inventory CSV rules, checked 2 October 2026
AreaCheck
FormatRecognises All states and Available exports; checks CSV quoting and row width.
Required identityAll states files need Handle, Location, and Option 1 Value to identify a variant and location.
QuantityWhole numbers only, including negative numbers and 0; not stocked and blank are accepted where Shopify documents them.
Safety validationWhen 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 dimensionsAll 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.
DiffLists 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.

Advertisement
Advertisement