Free tools

Shopify landed cost calculator

Free, no sign-up. Nothing you type or upload leaves your computer.

The price on a supplier's invoice isn't what a product really costs you once freight, duty and other charges are added. Enter every line of an invoice with multiple items, plus the freight, duty and other charges, and you'll get each product's landed cost per unit: the number that belongs in Shopify's Cost per item, so your margins and profit reports are right.

1Invoice lines

One row per line on the supplier's invoice. The SKU is only needed if you want to update Shopify in step 4.

SKUItemQuantityUnit cost

Copy the rows from Excel, Google Sheets or a CSV and paste them here. With a header row, the columns can be in any order (SKU, Description, Qty, Unit cost or Line total). Without one, use the order SKU, description, quantity, unit cost.

to get your store's currency.

2Extra costs

Charges on the invoice or billed separately, in your store's currency. Use a minus sign for a discount on the whole invoice.

ChargeAmountTypeShare it

3Landed cost per unit

Add at least one line with a quantity and a unit cost.

4Update Cost per item in Shopify(optional)

Add your product export (Products › Export › All products › CSV) and you'll get an import file that changes only Cost per item, matched by SKU.

Everything is worked out in this browser tab. Nothing is uploaded.

How to calculate landed cost per unit (the formula)

Landed cost is what a product costs once it's on your shelf: the supplier's price plus its share of every charge that got it there. For each invoice line:

  1. Line value = quantity × unit cost (converted to your store's currency if you entered a rate).
  2. Each charge is shared out. By value, a line worth 60% of the goods carries 60% of the freight. By units, every unit carries the same amount. A percentage charge, like duty, is that percentage of each line's own value.
  3. Landed cost per unit = (line value + its share of the charges) ÷ quantity, rounded to the cent.

Example from our cost per item guide: 12 candles at $5.00 and 10 mugs at $4.50 make $105 of goods, with $10.50 freight. Shared by value, candles carry $6.00 of it and mugs $4.50, so the landed cost is $5.50 a candle and $4.95 a mug. Press Try an example above to see it.

Allocate freight by value or by quantity?

Cost per item in Shopify: latest cost or weighted average?

Shopify's Cost per item is one number per variant, so when a delivery arrives at a new cost you choose what goes in it:

Either is fine if you stick to one. The average uses the Inventory quantity and Cost per item in your export, so export just before you receive the delivery, or tick the box if it's already in stock.

How to add freight and duty to Cost per item in Shopify

Questions merchants ask

What is landed cost in Shopify?
It's the full cost of a product once it's in your stockroom: the supplier's price plus freight, duty, insurance, customs fees and any other charges to get it there. In Shopify, the landed cost per unit goes into each product's Cost per item, which is what Shopify uses for margin and profit reports.

Does Shopify calculate landed cost for me?
Not on its own. Shopify's guide for moving off Stocky lists automatic landed-cost allocation as something that needs an app, and Cost per item is a single number per variant that nobody updates for you.

Does Cost per item include shipping?
Only if you put it in. Cost per item is the number you enter, and Shopify doesn't add freight to it for you. Include the freight you pay to get stock from your supplier; the shipping you charge customers on their orders is a separate thing and doesn't belong in it.

Is landed cost the same as cost of goods sold (COGS)?
Not quite. Landed cost is what one unit of stock costs you to buy and bring in. Cost of goods sold is the total cost of the units you actually sold in a period. In Shopify they meet in Cost per item: the profit reports use the cost recorded when each item sold, so a landed cost there makes your margins and COGS more accurate.

Should I include VAT, GST or sales tax?
Usually only the tax you can't claim back. Import VAT or GST that you reclaim isn't a cost to you, so leave it out; if you can't reclaim it, add it as a charge. Your accountant can confirm which applies to you.

What if the supplier invoice is in another currency?
Enter the invoice prices as they are and the exchange rate you paid. The charges are entered in your store's currency, because freight and duty are often billed separately in your own currency.

Is it safe to add my product export?
Nothing is uploaded. The page reads the file in your browser and builds the import file there.

Next: how cost per item works in Shopify, and how to update prices when supplier costs rise so your margin stays where you want it. Got a whole new price list from a supplier? Update Shopify from the price list.