Products — margin by SKU
Margin by product
Where your gross profit actually comes from — gross profit = product revenue − product cost (before shipping, fees, and ads, which live on the home page). Ranked by total gross profit over all data loaded.
Big Value
error
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^
Big Value
error
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^
Big Value
error
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^
Big Value
error
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^
Top products by gross profit
Bar Chart
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^Thinnest margins — watch these
The SKUs giving you the least back per dollar (5+ units sold). Candidates for a price bump or a cost renegotiation.
Data Table
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 3: from trueprofit.sku_margin
^Every SKU
Data Table
Catalog Error: Table with name sku_margin does not exist!
Did you mean "pg_catalog.pg_description"?
LINE 5: from trueprofit.sku_margin
^Revenue here is line price × quantity (before order-level discounts), so it won't tie exactly to net revenue on the home page — it's a product-ranking view. COGS is the effective-dated Shopify cost-per-item.
no cost?flags SKUs missing a cost (treated as $0 cost → margin overstated).