COGS Reconciliation
Detects Shopify orders where a bundle parent SKU did not expand into its component variants, and creates $0.00 COGS orders to restore inventory parity.
1 kit parent SKU shipping with no bundle definition
These variants sit on a bundle product but have no components registered, so the reconciler cannot post for them — every unit ships without a cost-of-goods entry. Add each one on the Bundles tab.
| SKU | Orders | Units | Example | First seen |
|---|---|---|---|---|
| AO-BND-DUO | 4 | 4 | #4823 | Aug 14, 2026 |
Settings
COGS prefix (read-only)
Lookback (minutes)
Reconcile orders from
Orders placed before this date are never auto-reconciled.
Scan interval (minutes)
Checks the last 30 minutes of orders for unexpanded bundles, back to Nov 1, 2025 at the earliest.
Manual test
Run an order through the reconciliation engine to see whether it would be expanded, and why. Preview is read-only — nothing changes until Commit.
Why
- Order contains parent SKU AO-BND-WKD, a registered bundle.
- No existing reconciliation found for this order.
Order line items
| SKU | Title | Qty | Bundle parent? |
|---|---|---|---|
| AO-BND-WKD | Weekend Kit | 1 | Unbroken parent |
| ↳ AO-RL2-SAG | Ridgeline 2P Tent — Sage | 1 | child |
| ↳ AO-TSP-REG | Trail Sleeping Pad — Regular | 2 | child |
| ↳ AO-STK-8 | Aluminum Stakes — 8-pack | 1 | child |
Would create
COGS order COGS-4878 (tentative)
Reconciliation log
| COGS # | Original Order | Customer | Status | Detected | |
|---|---|---|---|---|---|
| COGS-4872 | #4872 | Ray Olsen |
Created
| Sep 23, 2026, 8:02 AM | |
| COGS-4873 | #4873 | Iris Tanaka |
Created
| Sep 23, 2026, 8:05 AM | |
| — | #4874 | Colette Byrne |
In progress
| Sep 23, 2026, 9:41 AM | |
| — | #4875 | Jonah Weller |
Pending
| Sep 23, 2026, 10:15 AM | |
| COGS-4876 | #4876 | Grace Okafor |
Failed
Shopify API rate limited (429) — retrying automatically.
Retrying automatically — next 11:24 AM
| Sep 23, 2026, 10:52 AM | |
| — | #4877 | Adrian Pike |
Failed
Component AO-TSP-WID has no inventory at any location — cannot create a $0.00 COGS order.
Needs a fix — will not retry on its own
| Sep 23, 2026, 11:03 AM | |
| — | #4879 | Theo Ramirez |
Skipped
| Sep 23, 2026, 11:10 AM |