Reasoned adjustment audit
Shopify Inventory Adjustment Reason and Audit-Trail Worksheet
Make every inventory quantity change explainable: require a reason and note per adjustment, compute the delta, and export a reviewable audit trail before applying it in Shopify.
Browser-side scan
Drop an inventory adjustment CSV
No CSV selected
Merchants leaving Stocky lose the custom reason or note that made each inventory adjustment explainable. This worksheet reads a sanitized adjustment CSV with SKU, location, previous and new quantity, reason, note, operator, and timestamp, calculates the quantity delta, requires a reason on every change, and flags blank reasons, missing quantities, and duplicate events. It exports a review and audit-trail worksheet for manual Shopify adjustment and never reads or writes inventory through an API.
Import blockers
Common causes this scan checks
- Shopify's native adjustment flow does not require a custom reason or note like Stocky did.
- Damaged stock, cycle counts, receiving discrepancies, and transfers need to stay explainable in history.
- Adjustment rows arrive without a reason, making the inventory history hard to review later.
- Duplicate or contextless adjustment events slip in and need to be caught before applying.
Workflow
How to use the cleaned CSV
- Export or prepare an adjustment CSV with SKU, location, previous quantity, new quantity, reason, note, operator, and timestamp.
- Upload the CSV and review rows flagged for a missing reason, missing quantity, or duplicate event.
- Export the audit-trail worksheet with the calculated delta and review note per adjustment.
- Apply each reviewed adjustment manually in Shopify admin and keep the worksheet as a history record.
Auto-fix policy
What the export can safely change
- Detects SKU, variant ID, location, previous/new quantity, reason, note, operator, and timestamp columns.
- Calculates the quantity delta and requires a reason on every adjustment row.
- Flags blank reasons, non-numeric quantities, and duplicate adjustment events.
- Exports an audit-trail worksheet in the browser without calling Shopify APIs or storing data.
CSV example
CSV example: inventory adjustment audit-trail worksheet
The worksheet calculates the minus-3 delta, keeps the Damage reason and note attached, and flags any adjustment that arrives without a reason or duplicates an earlier event.
SKU,Location,Previous Quantity,New Quantity,Adjustment Reason,Note WIDGET-1,Main,10,7,Damage,Broken in transit
SKU,Variant ID,Location,Previous qty,New qty,Delta,Reason,Note,Review note WIDGET-1,,Main,10,7,-3,Damage,Broken in transit,Adjustment ready for review
FAQ
Shopify CSV questions
Does this apply inventory adjustments automatically?
No. It exports a local audit worksheet for review. Merchants still apply each adjustment manually in Shopify admin.
What columns does the audit need?
Use SKU or Variant ID, location, previous quantity, new quantity, and an adjustment reason, plus optional note, operator, and timestamp for a fuller audit trail.
How does it define a duplicate adjustment?
A row that repeats the same SKU, location, timestamp, reason, and quantities as an earlier row is flagged as a possible duplicate event.
Is operator or staff data uploaded anywhere?
No. The CSV is read locally in your browser with the File API. Keep the operator label non-personal; the tool never uploads or stores it.
Feedback
How is this tool working for you?
Found a bug, a false alarm, or a missing check? Tell me — a human reads every note.