Shopify’s newer inventory adjustment flow is fine for a one-off correction. It becomes harder to review when the file contains damaged stock, cycle counts, receiving discrepancies, or transfers across several locations.
A small CSV audit gives the change a reason before anyone applies it.
1. Start with a clean adjustment export
Prepare one row per adjustment with:
- SKU or Variant ID
- Location
- Previous quantity
- New quantity
- Reason
- Note
- Operator label
- Timestamp
Keep the operator label non-personal if the file will be shared. The goal is an explainable event, not a copy of every admin detail.
2. Calculate the quantity delta
For every row, calculate: delta = new quantity - previous quantity.
A negative delta may be damage, shrinkage, a count correction, or a transfer out. A positive delta may be receiving, a count correction, or a transfer in. The number alone does not explain the event, so do not throw away the reason column.
3. Flag missing context before import
Review rows where:
- SKU, Variant ID, or location is blank.
- Previous or new quantity is not numeric.
- The reason is empty or too generic.
- The timestamp is missing for a repeated adjustment.
- The same identity, quantities, reason, and timestamp appear more than once.
This catches the most expensive mistake: applying a valid-looking quantity twice because two rows had no useful context.
4. Keep the audit separate from the Shopify action
A browser-side worksheet should prepare and explain the adjustment. It should not silently write inventory through an API. After reviewing the exceptions, apply the approved changes manually in Shopify Admin and keep the exported worksheet with the stock-count or receiving record.
For a ready-made local worksheet, the Shopify inventory adjustment reason and audit-trail worksheet calculates the delta, flags missing reasons and duplicate events, and exports a review file without uploading the CSV.
Top comments (0)