Count variance and PO status
Shopify Stock Take Variance and PO Lifecycle Audit
Reconcile a physical stock count against system quantities and flag unpaid, overdue, or partially received purchase orders from a single CSV.
Browser-side scan
Drop a stock-count or PO status CSV
No CSV selected
When Stocky sunsets, merchants lose stock takes, purchase-order export, and invoice payment and due-date tracking. This audit reads a sanitized CSV with SKU, location, system and counted quantities, and optional PO number, payment status, due date, and receipt status. It calculates count variance per SKU, flags rows that need adjusting, and surfaces unpaid or incompletely received purchase orders. It exports a review worksheet for manual reconciliation and never reads or writes Shopify inventory through an API.
Import blockers
Common causes this scan checks
- Stocky's sunset removes stock takes, PO export, and invoice payment and due-date tracking.
- A physical count needs reconciling against system quantities before inventory is adjusted.
- Purchase orders need their paid, unpaid, overdue, and receipt status reviewed in one place.
- Merchants want count variances and PO lifecycle issues in a single reviewable worksheet.
Workflow
How to use the cleaned CSV
- Prepare a CSV with SKU, location, system quantity, and counted quantity, plus optional PO number, payment status, due date, and receipt status.
- Upload the CSV and review the count variances and the unpaid or incomplete purchase orders flagged.
- Export the audit worksheet with the calculated variance and a review note per row.
- Adjust inventory and settle or close purchase orders manually in Shopify or your supplier system.
Auto-fix policy
What the export can safely change
- Detects SKU, location, system and counted quantity, PO number, payment status, due date, and receipt status columns.
- Calculates the count variance between counted and system quantities.
- Flags unpaid or overdue purchase orders and partial or incomplete receipts.
- Exports a combined stock-take and PO lifecycle worksheet without calling Shopify APIs.
CSV example
CSV example: stock-take variance and PO lifecycle worksheet
The worksheet shows the minus-2 count variance and carries each purchase order's payment and receipt status, flagging unpaid or partially received POs for manual reconciliation.
SKU,Location,System Quantity,Counted Quantity,PO Number,Payment Status,Receipt Status WIDGET-1,Main,20,18,PO-100,Paid,Received
SKU,Location,System qty,Counted qty,Variance,PO Number,Payment status,Receipt status,Review note WIDGET-1,Main,20,18,-2,PO-100,Paid,Received,Count variance; verify before adjusting
FAQ
Shopify CSV questions
Does this adjust inventory or pay invoices automatically?
No. It exports a local review worksheet. Merchants still adjust stock and settle purchase orders manually in Shopify or their supplier system.
What columns does the audit need?
Use SKU and either system plus counted quantity for a stock take, or PO number, payment status, and receipt status for a PO lifecycle audit. Location and due date are optional context.
How does it decide a PO is unpaid or incomplete?
It reads your payment and receipt status text for words like unpaid, overdue, partial, or incomplete; it does not compute due dates or contact suppliers.
Is my inventory or supplier data uploaded?
No. The CSV is read locally in your browser with the File API. The audit never uploads your data or calls an API.
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.