How to add and manage historical COGS
As products might have different COGS at different periods . For example, your product costs might be increased or decreased depending on the suppliers, and you should be able to track the changes in product in different time range.
In TrueProfit, the current COGS value is set to cover a product's entire lifetime by default. You can add unlimited COGS periods to manage the historical data of a product or variant, ensuring it matches the correct past orders.
Step 1: In the Edit COGS page, click Add COGS period
Step 2: Select a starting date for the current and ongoing COGS period. The preceding period will be automatically applied
Step 3: Add your current COGS value and review the product cost in the past to ensure the data is correct.
You can also Duplicate a period and change the date range to keep the existing COGS rule for the product/variant.
Step 4: Add more periods if needed. Once done, click Save to save your changes
All the edits you made to a product/variant will be saved and applied to future orders only. If you want to apply new costs to orders in the past as well, you will have to recalculate all past orders in TrueProfit.
Recalculate past orders means applying new changes to all orders that match for all products. If you want to manage different product costs in the past, add COGS periods like the instruction above.
Step 1: Select the products or variants that you want to recalculate using the checkboxes at the left of the table
Step 2: When a product or variant is selected, you can see the Re-calculate product past orders button showed up at the top of the table
Step 3: Click Re-calculate product past orders to start applying and recalculate COGS for all orders in the past of the selected products/variants
From TrueProfit version 7.1, the Re-calculate all past orders is removed from the COGS settings. Now, to apply your changes in COGS to all orders in the past, you will need to select all products in your store. Here's how:
Step 1: In the COGS table, select all products in the page
Step 2: You can see the option to Select all products that match your filter. Make sure you are filtering the correct list of product in your store, then click Select all filtered products to select all products in your store.
Step 3: Once all filtered products are selected, click Re-calculate product past orders to start applying and recalculate COGS for all orders in the past
In TrueProfit, the current COGS value is set to cover a product's entire lifetime by default. You can add unlimited COGS periods to manage the historical data of a product or variant, ensuring it matches the correct past orders.
How to edit and add historical COGS:
Step 1: In the Edit COGS page, click Add COGS period
Step 2: Select a starting date for the current and ongoing COGS period. The preceding period will be automatically applied
Step 3: Add your current COGS value and review the product cost in the past to ensure the data is correct.
You can also Duplicate a period and change the date range to keep the existing COGS rule for the product/variant.
Step 4: Add more periods if needed. Once done, click Save to save your changes
Applying your changes in product costs to all orders in the past
All the edits you made to a product/variant will be saved and applied to future orders only. If you want to apply new costs to orders in the past as well, you will have to recalculate all past orders in TrueProfit.
Recalculate past orders means applying new changes to all orders that match for all products. If you want to manage different product costs in the past, add COGS periods like the instruction above.
How to recalculate past orders for one or multiple products
Step 1: Select the products or variants that you want to recalculate using the checkboxes at the left of the table
Step 2: When a product or variant is selected, you can see the Re-calculate product past orders button showed up at the top of the table
Step 3: Click Re-calculate product past orders to start applying and recalculate COGS for all orders in the past of the selected products/variants
How to recalculate past orders for all products in your store
From TrueProfit version 7.1, the Re-calculate all past orders is removed from the COGS settings. Now, to apply your changes in COGS to all orders in the past, you will need to select all products in your store. Here's how:
Step 1: In the COGS table, select all products in the page
Step 2: You can see the option to Select all products that match your filter. Make sure you are filtering the correct list of product in your store, then click Select all filtered products to select all products in your store.
Step 3: Once all filtered products are selected, click Re-calculate product past orders to start applying and recalculate COGS for all orders in the past
Updated on: 25/07/2024
Thank you!