How does the "Database COGS Sync" work?
Whenever orders are synced with Profit Calc, the COGS for the order are calculated by using the currently saved COGS values. Depending on the setup, this could be the COGS by Country and Quantity, the COGS by Quantity, the COGS by Country, or the Manual COGS. This value is saved with the order.
If the "Database COGS Sync" is turned off (default setting), when any of the analytic sections request the COGS (e.g. the dashboard). The currently saved COGS values are used in the total COGS calculation rather than the previously calculated database values with each order.
If the "Database COGS Sync" is turned on. When any of the analytic sections request the COGS. The previously calculated and saved COGS order values from the database are used instead of calculating the COGS with the currently saved COGS.
The above setting allows for the scenario in which some of the prices for the COGS may change.
So if you would like to edit your COGS now without affecting the previously calculated COGS values. This setting has to be turned on.
This setting can be changed on this page here
OPTIONS TO EDIT THE SAVED/CALCULATED COGS
1) To resync the saved/calculated COGS for specific order ranges, this can be done on this page here
2) Individual orders can be edited on this page here.
3) All orders with 0 saved for the COGS can be recalculated on this page here.