Are you seeing your cost as "Not Set" in your catalog or Product Sales Report?
If so, that indicates those specific products, in the current lot, do not have a lot cost associated with them.
Why is this happening?
Thrive does not know what your products cost before we were managing things, so no retroactive profit calculation is made automatically.
This can also happen if you create a new product, add quantities, and "Save." Then, later on, you come back and add a cost.
How do I fix this?
No matter how it happened, you can backfill all costs that say "Not Set" at once with current default costs.
To do this, navigate to the Advanced page (in Settings) and launch the task 'Set default cost on all lots without cost':
This task will apply the default cost to any lots that are "Not set" on your inventory page.
NOTE: In order for this task to apply the lot cost, there has to be a quantity remaining in that lot. Any lot with a blank or zero quantity will not be affected. Also, a default cost must be set!
Viewing Default Cost
As a reminder, the default cost is the cost listed on the new Product Details page, under the Inventory Section:
ou can also find it from the Bins View, under the Default Cost Column, or in grey under the cost column, if it's being overwritten by the lot cost.
Inventory costs are calculated using Lot costs
(You can learn more about lot costs vs. default costs in our Inventory Costs article.)
Even if a product has a Default Cost entered, the Lot Cost must be set for accurate calculations in the Reports section of Thrive.
Click the current cost in green in the Cost column of the Bins View to see lot history for that item:
The Lot history then opens, click to the Bin Details Page to edit. You can also switch location and variants from this screen, or navigate to the Product Details page and location settings page.
Things to Note:
Lot costs cannot be added if there are no quantities in stock. A product must have a quantity of at least 1 in order to update its lot cost.
If your Quantity tracking is "Disabled", go into the product to enable tracking first. Then a quantity can be added and lot costs will be tracked.
Updating the lot cost will also re-calculate the reports. For sales reports that predate the lot history, you'll have to backfill using the Default Cost.
Bundles do not have their own lot costs, and costs cannot be edited. The reason for this is a bundle's cost depends on the cost of its components. See more in the Inventory Costs article.
If you see costs as "Not Set" on the PRODUCT SALES REPORTS, you can backfill those lots using the current default cost.