A CSV Check for Shopify Stock That Exists but Still Will Not Sell

Multi-location inventory can fail in a quiet way: the stock count looks positive, but the product still cannot sell from one location. In Shopify terms, quantity and location activation are separate checks.

Before changing the same quantity again, I would audit the rows in this order:

1. Confirm the row has a stable product identity: SKU or variant ID.
2. Compare On hand against Available for the same location.
3. Flag rows where On hand is above zero but Available is blank or zero.
4. Check whether the location is actually active for that variant.
5. Separate receiving problems from activation problems before importing another quantity change.
6. Test the fix on a small set of variants before doing a bulk edit.

A useful worksheet has one line per variant and location, with SKU, variant ID, location, On hand, Available, activation state, and a short recommended action. That keeps the decision visible before anyone touches live inventory.

For a local browser-side pass, this checker can turn an inventory or location CSV into that exception worksheet: Shopify inventory location activation audit

The important boundary is that this kind of CSV audit should not silently activate inventory or push changes through an API. It should show which variants need review, then let the merchant decide the bulk edit or manual activation path in Shopify.