Before you update Shopify
Some products never made it into the count file
The team has finished counting, but the returned spreadsheet has fewer rows than the Shopify inventory export. A scanner may have missed an item, a location may not have been counted, or the count was intentionally limited. Find out which before treating anything as zero.
Review uncounted inventory rows →
A missing count row is a question to resolve
If an item is present in the Shopify export but has no matching row in the external count file, the files alone cannot tell you whether staff missed it or deliberately left it outside the count. Do not infer a physical quantity from absence.
| Shopify row | Count-file row | What you know | Next check |
|---|---|---|---|
| TEE-BLK-S · Tokyo · 5 | No matching row | No count was supplied for this key | Check the count scope or recount the shelf |
| MUG-RED · Tokyo · 8 | MUG-RED · Tokyo · 0 | A count row reports zero | Confirm that the item was physically checked |
Find omissions without changing inventory
Keep the Shopify export as the complete comparison list. Build the same variant-and-location key in both sheets, then filter Shopify rows with no matching count key. This produces a recount list; it does not prove that every unmatched row was accidentally missed.
- Confirm which locations, product groups, and inventory states were included in the physical count.
- Compare each Shopify variant-location key with the count file and filter keys with no match.
- Ask the count owner to mark each one as out of scope, intentionally not counted, or needing a recount.
- Only prepare a zero after a person verifies that the item was counted and none were present.
=COUNTIFS(Counts[Key],[@Key])
What CountAlign can and cannot identify
CountAlign can show Shopify rows with no corresponding count result as uncounted, so they stay out of the prepared quantity changes. It cannot know why a row is absent, whether the physical count was complete, or whether the item was deliberately excluded. A person must resolve that scope question.