Run this before you import a supplier file into your store.
Pick your Shopify product export and your supplier's CSV. Both need a SKU, a price, and a quantity column; a title is optional. Shopify's current export uses SKU, Price, and Inventory quantity — older exports used Variant SKU, Variant Price, and Variant Inventory Qty, and those work too. If a file has two price columns, the first one is used.
Inventory quantity is a single-location number. If Inventory tracker is blank for an item, a blank quantity isn't flagged — Shopify doesn't require one when inventory isn't tracked. Shopify's location-inventory and "Available inventory" exports have no price column and a location per column; use the product export instead.
Heads up: if a price starts with =, +, or @, the saved file quotes it so your spreadsheet treats it as text instead of running it as a formula.
| What the tool sees | Why it's held |
|---|---|
| The same SKU appears twice in your store file | Sort out the duplicate before importing, or the wrong row wins. |
| The two files disagree on price | Someone needs to decide which price is right. |
| The supplier quantity is blank | Importing a blank would wipe the quantity you have now. |
| Inventory tracker is blank for the item | Not held — Shopify doesn't need a quantity when inventory isn't tracked. |
| A quantity isn't a number | Shopify will reject it on import. |
| The two files disagree on quantity | Someone needs to decide which count is right. |
| Your store price is blank | Don't let an import quietly fill in a price. |
| A price starts with =, +, or @, or a stray minus | That's a formula, not a price. It isn't evaluated. |
| A price has a dollar sign or other text | Not a plain number, so it isn't used. |
| One file says 007, the other says 7 | Those aren't treated as the same SKU — check before merging. |
| A row has no SKU | Nothing to match it on. |
| A SKU is only in one of the files | Listed so you know it's missing from the other side. |
If you're building a file from scratch, this header works for both:
SKU,Title,Price,Inventory quantity
Made-up rows so you can see what a hold list looks like.
| SKU | Hold | Store price | Supplier price | Store qty | Supplier qty |
|---|---|---|---|---|---|
| A1 | This SKU appears more than once in your store file. Sort out the duplicate first. | 10.00 | 12.00 | 4 | 4 |
| A1 | The two files disagree on price. Pick the right one first. | 10.00 | 12.00 | 4 | 4 |
| B2 | The supplier quantity is blank. Importing it would wipe your stock count. | 25.50 | 25.50 | 1 | |
| C3 | Your store price is blank. Decide the price before importing. | 4.00 | 2 | 2 | |
| D4 | Only in one of the two files. | 8.00 | 3 | ||
| F6 | This value looks like a spreadsheet formula, not a number. | =1+1 | 2.00 | 1 | 1 |
| 007 | Looks like a leading-zero twin of another SKU. Check before merging. | 5.00 | 5.00 | 1 | 1 |
| E5 | Only in one of the two files. | 3.00 | 9 |