SHOPIFY INVENTORY CSV CHECKER
Compare an original Shopify inventory export with your edited CSV. Find SKU, Location, On hand current/new, duplicate rows, and overwrite risks before importing.
Upload or paste the CSV you exported from Shopify before editing.
Paste the file you plan to import back into Shopify.
RISK REPORT
| Severity | Row | SKU | Location | Issue | Suggested fix |
|---|---|---|---|---|---|
| critical | 3 | TSHIRT-BLACK-M | Main Warehouse | On hand (current) changed from 80 to 70. | Use a fresh Shopify export or restore the original current quantity before import. |
| warning | 4 | MUG-WHITE | Main Warehouse | Large quantity change from 45 to 0. | Double-check this change before importing, especially if it sets stock close to zero. |
| critical | 6 | MUG-WHITE | Retail Store | Duplicate SKU + Location also appears on row 5. | Keep only one row per SKU and Location before importing. |
| warning | 7 | NEW-HAT | Main Warehouse | On hand (current) is blank while On hand (new) has a value. | Do not clear On hand (current) unless you intentionally want to skip overwrite protection. |
| warning | 7 | NEW-HAT | Main Warehouse | This SKU + Location is not in the original CSV. | Confirm that this is a new inventory row and that the Location name is exact. |
CHANGE REPORT
| SKU | Location | Old current | New current | New target | Delta |
|---|---|---|---|---|---|
| TSHIRT-BLACK-S | Main Warehouse | 120 | 120 | 95 | -25 |
| TSHIRT-BLACK-M | Main Warehouse | 80 | 70 | 70 | -10 |
| MUG-WHITE | Main Warehouse | 45 | 45 | 0 | -45 |
| MUG-WHITE | Retail Store | 18 | 18 | 18 | 0 |
| MUG-WHITE | Retail Store | 18 | 18 | 20 | +2 |
Shopify inventory CSV exports can include On hand (current)and On hand (new). The current value acts like a safety check: if real stock changed after export, importing an old file can overwrite newer inventory.
This checker compares your original export with the edited file so changed current values, blank current values, and large stock deltas are visible before import.
This is not a Shopify inventory app. It does not connect to your store, sync stock, or modify quantities. It is a preflight report for merchants who edit CSV files in spreadsheets.
Use it when you want a quick risk report before uploading a CSV to Shopify Admin.
FAQ
No. This site is not affiliated with Shopify. Always check Shopify's official documentation before importing important inventory data.
No. The checker runs in your browser. The first version does not send CSV content to a server.
No. It compares the CSV files you provide. It cannot read live store inventory because it does not use Shopify OAuth or API access.
No. The first version is intentionally focused on Shopify Inventory CSV import risk, not product catalog validation.