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.
Your shipment
Result
Enter your numbers and press Calculate.
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):
- Shopify Help Center: Using CSV files to import and export products ("Cost per item", plain number without a currency symbol, for example 9.99; existing products are matched by Handle)
- Shopify Help Center: Stocky (states the app will no longer be available after August 31st, 2026)
- IFRS Foundation: IAS 2 Inventories (paragraphs 10, 11, 25 to 27 and 34, read from a copy of the IFRS Foundation text; the standard's own page does not show the paragraphs without a login)
- 19 CFR 152.103 (US transaction value: international freight and insurance are not part of the price actually paid or payable)
What this does not cover
- Importing the file. Do it in Shopify admin, one product first.
- Variant option columns. The file has Handle, Variant SKU and Cost per item only, so it is best used to copy values into an export of your products.
- Currency conversion and tax-inclusive costs.
- Shopify features that may add or change in the future.
Common mix-ups
-
Often assumedThe cost per item I load into my store should include the import VAT or GST I paid at the border.
What the source saysIAS 2 paragraph 11 lists import duties and other taxes in the cost of purchase but excludes those the entity can later recover from the taxing authorities. If you reclaim the import tax, it is not part of inventory cost. [1]
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.