Free to use · No signup
Already have your count file? Review it before updating Shopify.
Use this page after a physical count made outside Shopify. Compare the completed count CSV with a fresh All states Inventory CSV, review changed and uncounted rows, then inspect the file before you import.
Compare my count file with Shopify →
Keep uncounted items separate from counted zero
A count file records what staff actually checked. If an item has no count row, its physical quantity is unknown and its Shopify quantity should stay as it is. Enter zero only after counting and finding none.
A file check after the count is complete
Export a fresh Shopify All states Inventory CSV for the counted locations. Add the completed external count CSV, with one row per counted variant and location. Use the optional Product CSV only for barcode matching; review the prepared file and exceptions before importing.
Download a physical count sheet
Use one row for each variant at each counted location. The example has SKU, Barcode, Location, Counted, and Product columns; Product is for display only. SKU is optional when you map another supported identifier. Barcode matching needs Shopify’s optional Product CSV, and Location is still matched separately. Enter 0 for a counted zero; a missing row stays uncounted. Duplicate count rows are flagged for review, not added together.
Supported Shopify Inventory CSV format
Format checked: September 2026
This build was checked against Shopify’s documented All states Inventory CSV using English technical headers such as Handle, Location, On hand (current), and On hand (new). Whether live exports change those headers with the Shopify Admin language has not been verified. If required headers differ, the tool stops rather than guessing.
What the prepared file means
Only eligible, exact quantity differences are written to On hand (new). The source On hand (current) value is retained for Shopify's validation. Review the file yourself; Shopify's import checks remain authoritative.
No signup. No Shopify connection. No inventory writes. Files are processed locally in your browser.