Trade & Shipping · Inventory costing

Shopify cost per item landed cost CSV.

Paste your SKUs and shared costs. The tool works out landed cost per unit for each SKU and gives you a CSV with Handle, Variant SKU and Cost per item, formatted as plain decimals.

Updated October 26, 2026Runs in your browser

Advertisement

Your shipment

Quantity and unit cost are required. Weight and duty rate are optional unless you pick that basis. Comma, tab or semicolon separated; a header row is ignored. Optional sixth column: the Shopify product handle.

Result

Enter your numbers and press Calculate.

Advertisement

Shopify cost per item landed cost CSV: what it does

Shopify's Stocky page says the app will no longer be available after August 31st, 2026. If you relied on it to carry landed costs, the numbers now live in a spreadsheet, and the last step is getting them back into Shopify as the Cost per item on each variant. This tool does the landed cost step and writes the file for that last step.

It uses the same allocation as the multi-SKU landed cost allocator: freight, entry fees and other costs shared by the basis you pick, duty at each SKU's own rate. Use the allocator if you want to see the full cost breakdown.

Worked example

With the three sample SKUs (300 tees at 5.00, 200 mugs at 3.00 and 100 caps at 4.00), 900.00 of freight split by weight, 180.00 of fees split by value, 60.00 of other costs split by units and duty at 16.5%, 3.5% and 7.5%, the landed costs per item come out at 7.40 for the tee, 5.92 for the mug and 5.35 for the cap. The file has three data rows: the SKU and those three values in the Cost per item column.

How it is calculated and sources

Landed cost per item = (goods + share of freight + share of entry fees + share of other costs + duty at the SKU's rate) / units, rounded to the cent for the file. Shares are whole-cent, largest-remainder splits on the basis you choose. Cost per item follows Shopify's CSV page: a plain number without a currency symbol. IAS 2 includes import duties, non-recoverable taxes and directly attributable transport in the cost of purchase; recoverable tax is left out. Shopify's page was read on 2026-10-26; whether your store accepts a given file is for Shopify to decide, so test one product first.

Amounts are in whatever single currency you enter. Sources checked on 2026-10-26 (as of that date):

What this does not cover

Advertisement

Common mix-ups

  1. IFRS Foundation: IAS 2 Inventories, paragraph 11 (costs of purchase)

Checked against these sources on .

Frequently asked questions

What is the Cost per item column in a Shopify CSV?

Shopify describes it as how much it costs you to make or acquire the product or variant. It is a plain number without a currency symbol, such as 9.99.

How do I get landed cost into Shopify cost per item?

Work out landed cost per unit for each SKU, then enter it in the variant's cost field or include it in a product CSV. This tool builds the values and a three-column CSV.

What happened to Stocky?

Shopify's Stocky page says the app will no longer be available after August 31st, 2026, and points merchants to built-in inventory tools.

Is it safe to import a CSV with only Handle, SKU and cost?

Treat it carefully. Shopify matches products by Handle and overwrites the columns in the file. Test one product and keep an export as a backup, or paste the cost column into an exported file.

Should import VAT or GST be in cost per item?

Only if you cannot recover it. Under IAS 2 recoverable taxes are excluded from the cost of inventories, so leave them out.

Disclaimer

TNAADO is not affiliated with Shopify, CBP or the IFRS Foundation. This is a planning calculation from the numbers you enter, not accounting, customs or tax advice; confirm treatment with your accountant or customs broker. Everything runs in your browser and nothing you enter is sent or stored.