Catalog Hold

Run this before you import a supplier file into your store.

Everything happens in your browser. Your files are never uploaded, and nothing here touches your Shopify store — you get a hold list to review, and you decide what to import.

Your files

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.

A few things to know about Shopify exports

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 gets held, and why

What the tool seesWhy it's held
The same SKU appears twice in your store fileSort out the duplicate before importing, or the wrong row wins.
The two files disagree on priceSomeone needs to decide which price is right.
The supplier quantity is blankImporting a blank would wipe the quantity you have now.
Inventory tracker is blank for the itemNot held — Shopify doesn't need a quantity when inventory isn't tracked.
A quantity isn't a numberShopify will reject it on import.
The two files disagree on quantitySomeone needs to decide which count is right.
Your store price is blankDon't let an import quietly fill in a price.
A price starts with =, +, or @, or a stray minusThat's a formula, not a price. It isn't evaluated.
A price has a dollar sign or other textNot a plain number, so it isn't used.
One file says 007, the other says 7Those aren't treated as the same SKU — check before merging.
A row has no SKUNothing to match it on.
A SKU is only in one of the filesListed so you know it's missing from the other side.

Starting templates

If you're building a file from scratch, this header works for both:

SKU,Title,Price,Inventory quantity

Sample run

Made-up rows so you can see what a hold list looks like.

SKUHoldStore priceSupplier priceStore qtySupplier qty
A1This SKU appears more than once in your store file. Sort out the duplicate first.10.0012.0044
A1The two files disagree on price. Pick the right one first.10.0012.0044
B2The supplier quantity is blank. Importing it would wipe your stock count.25.5025.501
C3Your store price is blank. Decide the price before importing.4.0022
D4Only in one of the two files.8.003
F6This value looks like a spreadsheet formula, not a number.=1+12.0011
007Looks like a leading-zero twin of another SKU. Check before merging.5.005.0011
E5Only in one of the two files.3.009