Promo margin check - and how to run it (with or without AI)
The margin math behind every discount and promo, plus the exact weekly steps to catch losses early, by hand or with AI.
How to check if a promo is killing your margin
A proper promo margin check compares discounted price against landed cost, not just list price, across every active offer.
- 1.
Gross margin per discounted SKU - Calculate margin after the promo, not before, to see real profitability
- 2.
Discount depth vs cost buffer - Flag promos that cut deeper than your product's cost buffer allows
- 3.
Bundle and stacked discounts - Codes stacking with sitewide sales often push margin negative unnoticed
- 4.
Best-seller exposure - High-volume SKUs at thin margins do more damage than slow movers
- 5.
Return-prone products on promo - Discounted items with high return rates erode margin twice
- 6.
Trend vs last week - A margin drop that's worsening week over week signals a runaway promo
Takeaway: Run this check weekly, not just after a promo ends, so you can pause or adjust it while it still matters.
How e-commerce teams run promo margin checks
Time per report
Popular tools
- Shopify order and discount reports - Pull discounted orders and applied codes
- Spreadsheet (Excel/Google Sheets) - Join cost data with sale price to compute margin per SKU
- Cost of goods sheet or inventory system - Source landed cost per product for margin math
Time to set up
2-4 hrs per run
Cadence: Ad-hoc, usually after a promo underperforms
Who does it: Finance analyst plus merchandiser cross-checking sheets
Coverage: Top sellers or biggest discounts only
Delivered as: Spreadsheet shared when someone asks
Implement it with AI
Schedule
Integrations
ShopifyChannel
