Shopify landed cost calculator
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.
| SKU | Item | Quantity | Unit 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.
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.
| Charge | Amount | Type | Share 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:
- Line value = quantity × unit cost (converted to your store's currency if you entered a rate).
- 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.
- 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?
- By value is the usual default. Dearer items carry more of the freight, and duty and insurance are charged on value anyway.
- By quantity (units) suits items of similar size and weight, where each box costs the same to ship whatever is inside.
- Mix them if you need to: each charge has its own setting.
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:
- Latest cost is this delivery's landed cost. It's what replacing the stock costs from now on, so it's the safer number for pricing.
- Weighted average blends it with the stock you already had: (on hand × current cost + received × landed cost) ÷ (on hand + received). With 20 candles on hand at $4.40 and 12 arriving at $5.00, that's $4.63.
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
- A few products: open each product or variant and type the landed cost into Cost per item, or select them and use the bulk editor with the Cost per item column.
- Many products: download the import file in step 4 and import it from Products › Import with Overwrite products with matching handles ticked. It holds only the products on this invoice, their handle, title and option columns (Shopify needs those to keep your variants), and Cost per item. Prices, stock and everything else stay as they are.
- Import one product first and check it, as with any CSV import.
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.