How TrueProfit import your COGS upon installing
If you've just installed TrueProfit to your Shopify store, there are 3 ways the app can get and calculate the cost of goods for your store.
When you install TrueProfit, it will automatically sync the Cost per item from your pricing settings on Shopify to each product variant.
If you use Cost per item to track product costs, review the imported COGS in TrueProfit to ensure they are accurate.
In the app, if a COGS value comes from Shopify, you’ll see a Shopify icon in the Source column.
If all costs are sync correctly for your products, remember to Recalculate your past orders with the synced cost:
To start editing the COGS value for a variant, click on the expand arrow next to the toggle button, then switch the source into the Manual input.
There are three ways for you to effectively manage your COGS manually in the app:
If you have different COGS value for each variant, edit directly in the Cost of Goods Sold field
If you have the same COGS value in all variants of a product, switch the Set to level toggle to Product manage COGS on the product level for all variants
If you need to add a COGS in the past or apply quantity break for your product costs, click on the history icon to start editing
Read more details on how to manually edit product costs in this article.
This is a fast and easy way to import your existing COGS of all products in your store at once. Here's how to import your COGS file in TrueProfit:
Step 1: Go to the Cost of Good page
Step 2: Click Export to download a .csv template of all products in your store
The file will look similar to the image below, find the COGS column and fill in the product cost for each product and variant accordingly
Do not make edits in the Sale price column, TrueProfit automatically syncs your product's sale price from Shopify.
The fixed decimal format in the CSV is separated by a dot, not a comma. If you make changes in the COGS or Handling Fee values, make sure to use a dot for decimal.
Do not add or change the order of the columns and rows so that our app can recognize the correct data when you import the file back.
Step 3: In the app, click Import then choose the CSV file you've saved in step 2 to import it to TrueProfit
Step 4: To check the progress of importing and updating your product cost, click on the notification bell.
1. TrueProfit automatically syncs Cost per item from your Shopify account upon installing.
When you install TrueProfit, it will automatically sync the Cost per item from your pricing settings on Shopify to each product variant.
If you use Cost per item to track product costs, review the imported COGS in TrueProfit to ensure they are accurate.
In the app, if a COGS value comes from Shopify, you’ll see a Shopify icon in the Source column.
If all costs are sync correctly for your products, remember to Recalculate your past orders with the synced cost:
2. Set up COGS manually
To start editing the COGS value for a variant, click on the expand arrow next to the toggle button, then switch the source into the Manual input.
There are three ways for you to effectively manage your COGS manually in the app:
If you have different COGS value for each variant, edit directly in the Cost of Goods Sold field
If you have the same COGS value in all variants of a product, switch the Set to level toggle to Product manage COGS on the product level for all variants
If you need to add a COGS in the past or apply quantity break for your product costs, click on the history icon to start editing
Read more details on how to manually edit product costs in this article.
3. Upload COGS in bulk with a .csv file
This is a fast and easy way to import your existing COGS of all products in your store at once. Here's how to import your COGS file in TrueProfit:
Step 1: Go to the Cost of Good page
Step 2: Click Export to download a .csv template of all products in your store
The file will look similar to the image below, find the COGS column and fill in the product cost for each product and variant accordingly
Important notes:
Do not make edits in the Sale price column, TrueProfit automatically syncs your product's sale price from Shopify.
The fixed decimal format in the CSV is separated by a dot, not a comma. If you make changes in the COGS or Handling Fee values, make sure to use a dot for decimal.
Do not add or change the order of the columns and rows so that our app can recognize the correct data when you import the file back.
Step 3: In the app, click Import then choose the CSV file you've saved in step 2 to import it to TrueProfit
Step 4: To check the progress of importing and updating your product cost, click on the notification bell.
Updated on: 27/02/2025
Thank you!