Shopify
Shopify cost per item: set your real landed cost by CSV, safely
Shopify’s Cost per item is where margin reports start — and it is a single value that receiving never updates. Here is how it behaves, what a safe import looks like, and the template our allocator writes for you.
What Shopify records
- One current cost per variant. There is no cost history inside Shopify. Receiving a purchase order in the admin does not change it.
- Snapshotted on orders. The cost in force when an order is created is what the profit reports use for that order, forever. Updating the cost later changes future orders only.
- Excludes freight, duty and fees unless you put them there. That is what landed cost allocation is for.
- Gift cards have no cost per item; stores with tax-inclusive prices do not see projected margin on the product page.
The import rules that matter
- Updating existing products needs only
URL handleandTitle. - Any variant-level column —
SKU,Cost per item, weight — also needsOption1 nameandOption1 value. Without them Shopify creates a default variant and deletes the existing ones. - A column that is present but blank clears the store value. A column that is absent is left alone. Fewer columns are safer.
- Tick Overwrite products with matching handles when importing, or the rows are skipped.
Cost per itemis a bare number:12.47, not$12.47.
Step by step
- Shopify admin → Products → Export → All products → CSV for Excel (or plain CSV).
- Open the allocator, attach that export in step 01, tick the variants you received, enter quantities, costs and bills.
- Click Allocate, then Export Shopify CSV.
- Products → Import → choose the file → tick Overwrite products with matching handles → Import.
- Open one updated variant and confirm Cost per item. Variant IDs are unchanged because every option value was copied verbatim.
Why only Cost per item? Our file copies every other value from your export and writes nothing else. Prices, inventory, images and SEO fields are not in the file, so they cannot be touched.
FAQ
Cost per item and the CSV
Which columns does the CSV contain?
Title, URL handle, Option1 name, Option1 value, Option1 Linked To, Option2 name/value/Linked To, Option3 name/value/Linked To, SKU and Cost per item — in that order, using Shopify’s current column names. The Linked To columns are included only when they were in your export, because a present-but-blank column clears store values.
Why does the file include variants I did not receive?
Shopify treats the variant rows under a handle as the product’s full variant list. If a variant row were missing, the import would delete it. So for every product that has at least one updated variant, all its variants are written; untouched ones keep the cost from your export.
What does Shopify do with the cost?
Cost per item is a single current value per variant. Shopify snapshots it onto each order at order creation, so changing it today does not rewrite yesterday’s profit reports. If your store shows prices including tax, the product page hides projected margin but the CSV still imports.
My export uses old column names (Handle, Variant SKU, Variant Cost).
Fine on the way in — we read both the current and the legacy names. The file we write always uses the current names.
Attach your export and get the import-ready file from LandedCostSKU in minutes.Start with my Shopify export