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-02
    seedSeed from Stocky export
    Qty 140 on hand · average — → 1.9400 · stocky-averages-2026-09.csv · Mia
  • 2026-11-10
    receiptPO-1042 receipt: 1,200 units, landed 1.6377
    Qty +1,200 · unit 1.6377 · average 1.9400 → 1.6693 · PO-1042 · CI-2026-0917 · Mia
  • 2026-11-28
    late costLate duty bill 94.20 — 420 sold since receipt, 920 on hand
    Qty 920 on hand · unit +0.0570 · average 1.6693 → 1.7263 · Entry 7501 supplement · Mia
  • 2026-12-01
    correctionCorrection: whisk weight 120 g was 210 g — freight re-split
    Qty — · average 1.7263 → 1.7108 · PO-1042 re-saved · Tom
  • 2026-12-01
    undoUndo 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.

Each event is a row you can export. Receipts with late costs are closed to edits; changes become new events. Every event names its source document and operator.

Related

Where these events come from

Start the trail with your next receipt.Allocate my shipment