Blog

COGS Calculator for Imported Products: From Purchase Order to Cost per Unit

By the LandedCostSKU team · updated 2026-11-15 · 6 min read

COGS — cost of goods sold — for an imported product starts with one question: what did one unit cost by the time it was ready to sell? Answer that correctly and the rest (period COGS, gross margin, pricing) is arithmetic. This article builds the number for one SKU, then shows what changes when the shipment has many.

1. Supplier price in your currency

A silicone spatula set at CNY 9.80. At the rate you paid — 0.1405 USD per CNY on the receipt day — that is 1.3769. If a deposit was paid earlier at a different rate, the effective rate is the blend of the two payments (see the landed cost article).

2. Packaging and components you buy separately

A retail box bought in packs of 50 at 18.00 is 0.36 per set. An insert card at 42.00 per 1,000 is 0.042. The formula is always pack price ÷ pack quantity × used per unit. These belong in COGS because the product is not saleable without them.

Running total: 1.3769 + 0.36 + 0.042 = 1.7789.

3. The per-unit share of the shipment's bills

Freight, duty, MPF, brokerage, insurance, agent commission, the domestic leg in China and the inspection visit all count — IAS 2 puts "costs of purchase" and "other costs incurred in bringing the inventories to their present location and condition" into cost. Recoverable import VAT or GST does not.

For a single SKU, divide each bill by the units. For the 1,200 spatula sets on PO-1042 the shares came to 0.42 freight, 0.19 duty and MPF, 0.07 agent, 0.11 inspection and brokerage — 0.79 per set. Running total: 2.5689.

That 0.79 is 46% of the supplier price. This is why "I buy at 1.38 and sell at 14.99" is not a margin.

Free allocator

Split your freight, duty and agent fee across the units you received — and download the Shopify CSV.

Allocate my shipment

4. Margin and price

At a selling price of 14.99: margin = (14.99 − 2.5689) ÷ 14.99 = 82.9%. If your target is 60%, the price that keeps it is cost ÷ (1 − 0.60) = 6.42. The COGS calculator page does these four steps live.

When the shipment has many SKUs

Dividing each bill by units only works when every unit is the same. With a spatula, a whisk and a cutting board in one container, the cutting board should carry more freight (it is 950 g and 2,240 cm³) but the same share of a flat broker fee, and more duty (it is worth more). That is allocation: each bill is split by the basis that caused it — value, quantity, weight or volume — and rounded so the column adds up to the bill. The allocator does it for the whole receipt and hands back a cost per SKU, plus the Shopify CSV.

From cost per unit to period COGS

Shopify copies Cost per item onto each order line at order time, so period COGS is units sold × the cost in force then. If you hold stock from an earlier receipt at a different cost, the value to write is the moving average of old and new, so that the period's COGS reflects the mix you actually sold. The cost history example shows one SKU moving through a seed cost, a receipt, a late duty bill and a correction.

Checklist

  • Supplier price × the rate you actually paid.
  • Packaging and components bought separately, per unit.
  • Every bill needed to bring the goods in — freight, duty, fees, agent, inspection, domestic leg — per unit, or allocated when SKUs differ.
  • Recoverable import tax recorded, not costed.
  • Blend with stock on hand before writing to Shopify.