Purchase Order History by Variant
The Purchase Order History by Variant report answers one question: what has been ordered for this item, and how much of it has arrived. Open it from Reports → Inventory Reports → Purchase Order History by Variant. It appears once purchase orders are enabled for your organization.
Search
The report loads nothing until you search. Type at least three characters of a product title, variant title, SKU or barcode and press Enter. Results are grouped by variant in alphabetical order, with each variant's lines newest purchase order first.
Which lines appear
Lines from purchase orders in draft, ordered, partial, received, in transit, partially transferred and transferred status appear by default. Tick Include closed (committed, cancelled, archived) to add the rest.
| Filter | What it does |
|---|---|
| Supplier | One supplier. |
| Location | One location. A line's location is its own, or the purchase order's destination when the line has none. |
| Line status | Any of Not received, Partial, Received, Over-received. Applies when the picker closes. |
Reset clears the filters and keeps the search.
How quantities are counted
Received and Rejected count committed receipts only. Draft receipts do not count.
Remaining is ordered minus received minus rejected, never below zero.
Line status compares received plus rejected with ordered: Not received when nothing has arrived, Partial when less than ordered, Received when equal, Over-received when more.
Totals
- Variants matching: variants with at least one matching line.
- PO lines: matching lines, and how many purchase orders they sit on.
- Units remaining and Units received: summed across every matching line, not just the page on screen.
Columns
Each variant's group heading shows the product and variant title, SKU, line count, and its ordered, received and remaining totals. Click the title for the variant's cost history; the arrow opens it in Shopify.
Use the column picker above the table to show or hide columns. Your choice is saved per store. Product, SKU, Purchase order and Remaining are always shown.
| Column | What it shows |
|---|---|
| Product | |
| Variant title | Hidden by default. |
| SKU | |
| Barcode | Hidden by default. |
| Purchase order | Opens the purchase order at that line. |
| PO status | The purchase order's status, with an Archived badge where it applies. |
| Supplier | |
| Order placed | |
| Expected arrival | Red when the date has passed, units are still remaining, and the purchase order is open. |
| Location | |
| Ordered | |
| Received | |
| Rejected | |
| Remaining | |
| Line status |
The table shows 25 variants per page, with every line of each variant on the same page.
Export
Export CSV downloads every matching line for the current search and filters.
For stock levels and value by variant, see Inventory on Hand.