What Export and Import do
On the Version 2 Cost Of Goods page, TrueProfit lets you export a zone's costs to a CSV file. Edit the file in a spreadsheet, then import it back. You can update Cost per unit and bundle costs for up to 500,000 variants in one file.
How the COGS CSV file works
The TrueProfit COGS file covers the zone tab you have open and the products that match your search and filters. It holds saved costs only. TrueProfit imports only files in this exported format, so Version 1 Cost of Goods files don't work here.
The table below lists the three row types in a TrueProfit COGS file.
Row type | Variant_Id | Cost per unit | Bundle level, quantity, cost |
Variant cost | Filled | New cost, or blank to keep the current one | Blank |
Product-level bundle tier | Blank | Blank | Product, units, total cost |
Variant-level bundle tier | Filled | Blank | Variant, units, total cost |
TrueProfit matches rows by Product_Id and Variant_Id. Enter costs in your store currency as plain numbers, such as 1250.50: 0 or more, up to 2 decimals, no currency symbol or thousands separator. TrueProfit skips rows it can't read.
Before you import a COGS file
Before you import a file to TrueProfit, check these points:
Save or discard your changes on the Cost Of Goods page.
Keep all 10 columns, their names and their order. Don't change Product_Id, Variant_Id or Zone.
Save the file as comma-separated CSV in UTF-8. In Excel, pick CSV UTF-8 (Comma delimited).
Export and import your costs
To update costs in bulk with a file in TrueProfit, follow these steps:
Go to Cost of Goods and open the zone tab you want to update. Search or filter if you only need some products.
Click ⋮ next to the Cost Of Goods title, then click Export. The CSV file downloads when it's ready.
Edit the costs in your spreadsheet and save the file.
On the same zone tab, click ⋮, then Import, and pick your file. TrueProfit shows File received and is being processed.
Click the sync icon at the top right to open Data Sync Status. Cost of Goods file import moves to the Completed tab when it's done.
Check the table for your new costs.
Edit bundle costs in the file
In a TrueProfit COGS file, a bundle tier is the total cost of a pack, not a cost per unit. For example, Product, 3, 12.00 means 3 units cost $12 in total.
All tiers of one product, or of one variant, form a set. Importing replaces the saved set with the set in your file. To remove a tier, delete its row.
Each tier needs a whole-number quantity of 2 or more, no repeated quantity, and a total cost above 0. If one tier is invalid, TrueProfit keeps the saved set.
A product has bundles at one level only. Tiers at the other level switch the product's level. They also remove the old bundles from all its variants, even ones not in your file. If a product has rows at both levels, the variant level wins.
A few things to know about COGS import
Keep these points in mind when you import costs to TrueProfit:
New costs apply to upcoming orders. To update past orders, click Recalculate COGS. See How to recalculate COGS for past orders.
An imported cost counts as a manual edit. The next sync from Shopify or your supplier app can overwrite it.
TrueProfit doesn't list skipped rows. To find them, export the zone again and compare.
If an import fails, click Retry in Data Sync Status. TrueProfit opens the same zone so you can pick the file again.
Your exported file is also on the Exports page, in the Cost of Goods tab.
Messages when TrueProfit can't import a file
If TrueProfit can't import your COGS file, it changes no costs and shows one of the messages below.
Message | What to do |
This file doesn't match the export template. Please use a .csv exported from this page. | Export a fresh file and keep its columns and CSV format. |
This file must contain exactly one zone that exists in your store. | Use one zone name in the Zone column. |
This file is for the "zone name" zone. Please open that zone and import again. | Open that zone tab and import again. |
File is too big. Please reduce the file size and upload again. | Filter, then export and import in parts. |
This file has no rows to import. | Check that costs are plain numbers with a dot for decimals, such as 12.50. |


