The Quantity-Based COGS feature in TrueProfit helps you see a clear picture of your store's profits by figuring out product costs accurately.

If your supplier offers discounts when you buy more units, it's important to break down these bundle costs to understand what each unit costs you. By calculating and entering the cost per unit for each pricing level, you ensure that your profit reports are correct. This easy step helps you better manage your pricing and make smarter business decisions.

Read the step-by-step tutorial below or watch this video for a quick walkthrough:

If you're looking for how to set up COGS in TrueProfit, check out the Setting up Cost of Goods (COGS) for all products article.

In this article:

1. Setting up quantity-based for COGS
   1.1 How to calculate Cost per unit
2. Configuring quantity-based COGS on the Product vs. Variant Level
3. Applying your changes in product costs to all orders in the past

Setting up quantity-based for COGS

1. Locate the product or variant you want to edit.
2. Click the icon to the right of its Cost of Goods Sold field. This action will open the Edit COGS table, allowing you to edit the COGS based on specific quantities.
3. In the first row, enter the maximum number of units for the first tier. The next row will be filled automatically to ensure your setting is correct.
4. Enter the Cost per unit value for each row.

How to calculate Cost per unit

Understanding Tiered Cost vs. Cost per unit:

When suppliers offer products at a tiered pricing structure based on the quantity purchased (buy 1 get 1, buy 2 get 2), you'll need to calculate the cost per unit for each pricing level to set up in the app.

This granular approach ensures that your profit calculations are not skewed by total bundled costs, but rather reflect the incremental cost associated with each additional unit sold. This means you need to establish the Cost of Goods Sold (COGS) incrementally as more units are sold.

For example, the product costs given by your supplier are:

• $9 if a customer purchases 1 unit
• $15 if a customer purchases 2 units
• $20 if a customer purchases **3 units **
• $25 if a customer purchases 4 units or more

Inputting Correct Cost per Unit:

Calculation breakdown:

• For 1 unit: The cost per unit is $9.
• For 2 units: Calculate the incremental cost: $15 total for 2 units, minus $9 (cost for 1 unit) = $6. Thus, second unit cost = $6.
• For 3 units: Total $20 minus $15 (cost for 2 units) = additional $5. So, the third unit cost = $5.
• For 4 units or more: Total $25 minus $20 (cost for 3 units) = additional $5. So, fourth unit cost = $5.

Configuring quantity-based COGS on the Product vs. Variant Level

To effectively manage your Cost of Goods Sold (COGS), you can choose to set calculations at either the product level or the variant level, based on your business needs.

Setting COGS at the Product Level

Ensure the Set to Level toggle is set to 'Product' if you intend to calculate COGS universally for the product, without accounting for individual variants. This method streamlines your COGS under a single calculation, offering a straightforward view of your product

Setting COGS at the Variant Level

If the Set to Level toggle is set to 'Variant', the app will individually calculate quantity-based COGS for each variant, which will then be summed to reflect the overall product cost.

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 instructions above.

Steps to recalculate past orders for one or multiple products

1. Select the products or variants by ticking the checkbox next to the product(s) or variant(s) you want to update.
2. Click Re-calculate product past orders to start applying and recalculate COGS for all orders in the past of the selected products/variants.

Updated on: 24/04/2025