Cost history
One SKU, five events: why the cost is what it is
Shopify stores one cost per variant and no history. The web plan keeps the trail: every receipt, late bill, correction and undo, with the average before and after, the source document and who did it. Here is BW-SP-01 from the sample PO.
- 2026-09-02seedSeed from Stocky exportQty 140 on hand · average — → 1.9400 · stocky-averages-2026-09.csv · Mia
- 2026-11-10receiptPO-1042 receipt: 1,200 units, landed 1.6377Qty +1,200 · unit 1.6377 · average 1.9400 → 1.6693 · PO-1042 · CI-2026-0917 · Mia
- 2026-11-28late costLate duty bill 94.20 — 420 sold since receipt, 920 on handQty 920 on hand · unit +0.0570 · average 1.6693 → 1.7263 · Entry 7501 supplement · Mia
- 2026-12-01correctionCorrection: whisk weight 120 g was 210 g — freight re-splitQty — · average 1.7263 → 1.7108 · PO-1042 re-saved · Tom
- 2026-12-01undoUndo of correction (the 210 g was the carton, not the unit)Qty — · average 1.7108 → 1.7263 · PO-1042 · Mia
Reading the five lines
Seed. The 140 units on hand came in under Stocky at an average of 1.94. That number is imported once so the history has a starting point.
Receipt. PO-1042 lands 1,200 spatula sets at a landed unit cost of 1.6377 (goods 1.3769 + 0.2608 of freight, duty, MPF, broker, agent, domestic leg and inspection). Blended with the 140 at 1.94: (140 × 1.94 + 1,200 × 1.6377) ÷ 1,340 = 1.6693. That is the cost written to Shopify.
Late cost. Eighteen days later a duty supplement of 94.20 arrives for this line. 420 units have sold meanwhile, 920 are on hand. 420/1,340 of the bill (29.52) is a cost of November; 64.68 ÷ 920 raises the on-hand cost by 0.0703 — wait, that is the pure on-hand split; the history shows the average effect across all 1,340 units as 0.0570 because the expensed part never touches inventory. The report shows both numbers.
Correction and undo. Someone fixes a weight on the receipt; freight re-splits and the average moves. The next morning the fix turns out to be wrong — the 210 g was the carton. Undo writes a fifth event that restores the previous average; nothing is deleted, so the trail still shows what happened.
Related
Where these events come from
Partial receiving
Why only received units share a receipt’s bills.
Late costs
The sold / on-hand split behind the late-cost event.
Stocky alternative
Where the seed cost comes from.