Free landed cost allocator · China → Shopify

Your true cost per SKU, from the factory in China to your Shopify shelf.

Log the deposit and balance you paid your supplier, the agent fee, the freight bill and the customs entry. We split every dollar across the units you actually received — by value, quantity, weight or volume — and give you the new cost per item as a Shopify-ready CSV, with a cost history for every SKU. Moving off Stocky? Bring your receipts and start with the free allocator on your next shipment.

Runs in your browser. No account, nothing uploaded. Want to see the output first? Open the sample report

PI-2611Σ
01Receipt lines
02Payments & FX
03Costs
04Allocate & export

01Receipt lines

SKU
Product / variant
Received
Rejected
Unit cost (CNY)
Weight / unit (g)
Volume / unit (cm³)
Costs are shared only between lines with a received quantity. Rejected units take no share.

02Payments & exchange rate

Fetching the ECB reference rate for 2026-11-16…

03Costs to allocate

Each bill picks its own method. Defaults follow what moves the cost: freight by weight, duty by value, brokerage per unit.

Duty: use the amount on your customs entry (CBP 7501 line totals); this tool does not classify HS codes. MPF: use the amount printed on the entry — the prefill is the 0.3464% ad valorem part before the yearly minimum and maximum.

Landed total
—

Built for China imports

The four costs most calculators have no row for

Freight and duty are the easy part. Importing from China adds a deposit paid months earlier, an agent on a percentage, a domestic leg and an inspection — each needs its own line and its own method.

Deposit & balance FX

The 30% you wired in September keeps September’s rate; the balance takes the rate on the day the goods landed. Both from ECB reference rates, both editable.

Agent commission

Your sourcing agent’s 5% is a cost of getting the goods, so it lands in cost per item — by value, on the lines it was charged for.

Domestic freight in China

Factory → Ningbo CFS is a freight bill too. Allocate it by weight next to the ocean leg instead of losing it in “other”.

Sample & QC inspection

Pre-shipment inspection is a flat fee per visit — spread it per unit received, not per dollar.

How each China-side cost is treated →

How the numbers add up

Every bill closes to the cent. The stamp proves it.

A $100.00 clearance fee shared by three identical lines is 33.34 + 33.33 + 33.33 — not three cells of 33.33 that add to 99.99 under a total that still says 100.00. We round each cost line with the largest remainder method, then stamp the receipt Σ BALANCED only when every bill’s shares equal the bill.

01

Pick a basis per bill

Freight by weight, duty by value, brokerage per unit — set once per cost line, not once per shipment.

02

Share = bill × basis ÷ Σ basis

Computed exactly, then rounded so the column adds up. Hover any cell to see its arithmetic.

03

Landed unit = (line value + shares) ÷ received

Kept at four decimals internally, shown at two. Rejected and unreceived units take nothing.

Formulas B1–B8, rounding and FX sources →

Worked example
Clearance 100.00 over three equal lines
Σbalanced1/1
LineExactCell-roundedLargest remainder
S133.3333…33.3333.34
S233.3333…33.3333.33
S333.3333…33.3333.33
Σ100.0099.99100.00

Moving off Stocky?

Stocky is gone. Your receiving costs do not have to be.

Stocky closed on 31 August 2026 and historical purchase orders never moved into Shopify. Export your last average costs while you still have read access, seed them as the old cost, and run your next shipment through the allocator — the new cost per item blends the stock you hold with what just landed.

Also on this site

FAQ

Landed cost, answered

What is landed cost, in one sentence?
Landed cost is what one unit really cost you by the time it sat on your shelf: the factory price plus its share of freight, duty, brokerage, insurance, agent commission, inspection and the domestic leg in China, converted to your store currency at the rates you actually paid.
How does the allocator split one freight bill across many SKUs?
Each cost line picks its own basis — value, quantity, weight or volume. A line’s share is the bill × its basis ÷ the shipment’s total basis, rounded to the cent by the largest remainder method, so the shares of every bill add up to the bill exactly (100.00 split three ways is 33.34 + 33.33 + 33.33, never 99.99).
Why do you block the calculation when a weight is missing?
Because a blank weight would silently take a 0% share and push the whole freight bill onto the other lines. The allocator lists the SKUs that need a weight and offers a one-click switch of that cost to quantity instead.
Can I use the Shopify export so the CSV imports cleanly?
Yes. Attach your Shopify product export, tick the variants you received, and the Shopify CSV you download keeps Title, URL handle, the Option columns, SKU and every variant row of each touched product. Only Cost per item changes. Import it with “Overwrite products with matching handles”.
I paid a 30% deposit months ago at a different exchange rate. Which rate do you use?
The deposit stays at the rate of the day you paid it; only the balance takes the receipt-day rate. Both rates come from the European Central Bank reference rates via Frankfurter for the dates you enter, and you can overwrite either with the rate on your bank slip.
What happens with units I rejected or that have not arrived yet?
Only units you actually received share this shipment’s costs. Rejected units and lines still on the water take nothing; when the rest arrives, you run (or save) a second receipt against the same PO.
The freight invoice arrived three weeks after the goods. Now what?
On the web plan you add it to the saved receipt as a late cost. Its share for units you already sold is expensed in the period; the share for units still on hand adjusts their cost — instead of dividing the whole bill by whatever stock is left today.
Does anything leave my browser?
The free allocator runs entirely in your browser; the receipt, costs and Shopify export are never uploaded. Only the exchange-rate lookup calls Frankfurter (dates and currency codes). Saved receipts on the web plan are stored in your account and can be deleted at any time.

All questions →