Be sure to record your product variant costs in Shopify so that Better Reports can compute your Cost of Goods Sold and Gross Margin accurately.
How is COGS computed when product cost is unspecified?
If the product cost is unknown, Better Reports cannot compute COGS. In such cases, the built-in formula assumes that COGS is equal to Net Sales, resulting in a 0% margin.
As a consequence, your COGS is overstated and your gross margin is understated. This is an arbitrary choice, used as a conservative measure. You could easily create your own COGS and Gross Margin measures to achieve a different outcome. For example, your formula might assume that, if the product cost is unknown, the gross margin should be set to 10% arbitrarily.
A cost of $0 is not the same as an unspecified cost. A cost of $0 means your COGS is $0 and therefore your gross margin is 100%. This is often the case for digital products (an eBook for example).
Shopify doesn't record the historical cost of product variants (as of the date of the order).
As a result, COGS is always computed using the latest / current product costs.
For this reason, any time you update a product cost, all historical COGS amounts are updated immediately in all reports.
Another consequence is that if you delete a variant, it won't be possible to compute COGS anymore for that variant, because its cost cannot be retrieved anymore.
Why don't COGS in Better Reports match COGS in Shopify?
In Shopify's native reporting, COGS are recorded as sales occur with the cost at the time of the sale. Better Reports, however, does not have access to historical variant cost as this is not recorded in the Shopify API. Therefore, COGS in Better Reports is calculated using the current variant cost, and cost will be unknown if variants are deleted. This approach allows you to retroactively update or add costs, but it can also result in discrepancies between COGS in Better Reports and Shopify.