Shopify’s newer inventory adjustment flow is more explicit about why stock changes. That is useful for reporting, but it also makes a quick “type -3 and move on” workflow easy to misunderstand.
A safer approach is to review the adjustment file before applying changes in the admin.
What to check first
Before changing a quantity, keep these fields together:
- SKU or Variant ID
- Location
- Previous quantity
- New quantity
- Adjustment reason
- Note, operator label, and timestamp when available
The previous and new quantities are more reliable than a bare positive or negative number. They let you calculate the actual delta and spot a row that would increase stock when you intended to remove it.
A practical review sequence
- Export a fresh inventory or adjustment report. Keep the original export unchanged so you have a reference copy.
- Confirm that every row has a SKU or Variant ID and a location. A quantity without an identifier is not safe to apply.
- Compare previous quantity with new quantity. For a removal, the new value should be lower; for a receipt or correction, it should be higher.
- Require a reason such as damaged, theft, cycle count, receiving discrepancy, or transfer. Add a short note when the reason alone is not enough context.
- Look for non-numeric quantities and duplicate rows. A duplicate adjustment can quietly double the intended change.
- Test one known SKU in Shopify first and read the preview. If the preview moves in the wrong direction, stop and fix the source row.
For a browser-side worksheet that calculates the delta, flags missing reasons or quantities, and highlights possible duplicate events, see the Shopify inventory adjustment reason audit.
Apply the reviewed change manually
In Shopify admin, open Products → Inventory, select the Available quantity, and use the adjustment flow for the relevant location and destination. Add the reason that matches the event, then confirm the preview before saving.
The worksheet is a review aid, not an API writer. Keep the exported audit trail with the original report so a later stock-take or accounting review can explain what changed and why.
Top comments (0)