Multi-Channel RetailRetail / DTC7 min read

Margin Health Monitoring: Spot Unprofitable Shopify Promotions Early

A monitoring routine built on per-campaign profit and Loss, Thin margin, and Healthy colors, with thresholds set from your own costs.

Discount Prime computes Estimated Profit per order and campaign and colors them Loss, Thin margin, or Healthy against cutoffs you set, but it sends no margin alerts. Reliable monitoring needs current Shopify costs, cutoffs that cover fees and handling the figure excludes, and an owner who checks campaigns daily while promotions run.

At a glance

Challenge: A supplier cost increase pushed a product range below acceptable margin, and finance only discovered it days later because the new cost was not in Shopify.
Approach: Estimated Profit per order and campaign, color thresholds set to cover fees and handling, same-day cost updates in Shopify, and an owned daily check.
Discount Prime campaign types used: Profit AnalyticsMargin Health Colors

Scenario-based case study: the merchant is fictional and modeled on patterns across Discount Prime stores. Prices, costs and outcome figures are illustrative assumptions for teaching, not measured results from a real store.

Short Answer

To catch a promotion that has started losing money, you need three things: current product costs, a profit figure per order and per campaign, and a routine that someone actually follows. Discount Prime covers the middle part. Its analytics compute Estimated Profit for each order and campaign and color them Loss, Thin margin, or Healthy against thresholds you set.

What it does not do is alert you. There are no margin alert emails, no below-cost notifications, and no store health score. The colors appear when someone opens the app. This guide shows how to turn them into a reliable monitoring process, and where the numbers can mislead you.

Scenario

NorthPeak Outdoor is a fictional Shopify retailer of camping and hiking gear running 15 to 20 promotions at a time: BOGO offers, free shipping thresholds, seasonal discounts, and wholesale pricing.

During a holiday weekend, a supplier raised costs on a tent range. The pricing team had not yet updated those products. Orders kept arriving, and the following Monday finance found that the range had been selling below the company's minimum margin all weekend.

Two gaps caused this, and only one is about software:

The new cost was not in Shopify. Any profit report, including Discount Prime's, uses Shopify's Cost per item. Until someone updates it, every order still looks as profitable as before.
Nobody was looking. Even with correct costs, a colored dashboard only helps if it is checked.

What Discount Prime Provides

Capability	How it works	Limit to know
Estimated Profit per order	Revenue on lines with a cost, minus cost of goods, minus shipping you subsidized. Discounts are already reflected in the revenue	Lines without a cost are left out entirely. Payment fees, fulfillment, ads, and returns are not deducted
Per-campaign profit and margin %	Orders attributed to each campaign	Only campaigns still active when the paid order is processed are attributed
Performance colors	Settings, "Performance color thresholds": Loss below the loss cutoff (default 0%), Thin margin below the thin cutoff (default 20%), Healthy at or above it. Used on campaign cards, top performers, and recent orders	Display only; nothing is sent to you
Cost data	Synced from Shopify's Cost per item every night at the store's local midnight, recalculating the last 30 days of orders; "Recalculate" refreshes on demand	A cost changed in your supplier's invoice but not in Shopify is invisible
Order sale email (optional setting)	Notifies you when products from a live campaign sell, with a link to the order	Does not include margin or profit
Weekly email	Sent Tuesdays	Counts all orders in the last 7 days, not only discounted ones; its "top campaign" is ranked by discount given, not profit

Refunds and cancellations are not subtracted, because orders enter analytics when they are paid.

Alternatives Compared

Approach	Fits when	Does not fit when
End-of-campaign finance review (spreadsheet with costs)	Few campaigns; you need fully loaded profit including fees and returns	Problems must be caught during the campaign
Shopify's own reports (profit reports based on Cost per item, where your plan includes them)	You want store-level and product-level gross profit without an app	You need profit per promotion
Discount Prime colors plus a daily check	Many concurrent campaigns; you want profit per campaign and per order	Nobody owns the check; or most costs are missing
A push alert you build yourself (scheduled export, BI tool, or workflow automation)	You need notification without opening any dashboard	You cannot maintain it; test it against real orders first

Step 1: Set Thresholds From Your Own Economics

Estimated Profit excludes payment fees, fulfillment labor, and marketing. Set the cutoffs so that the colors account for them.

Illustrative assumptions for NorthPeak (replace with your own):

Cost not in Estimated Profit	% of order revenue
Payment processing	3%
Pick, pack, and packaging	6%
Average returns cost	3%
Total	12%

Cutoff	Setting	Meaning for NorthPeak
Loss cutoff	12%	Below 12% Estimated Profit margin, the order likely loses money once these costs are counted
Thin cutoff	25%	Between 12% and 25%, it covers variable costs but not NorthPeak's overhead and profit target
Healthy	25% and above	Meets the target

The default 0% loss cutoff only flags orders that lose money on goods and shipping alone, which is too late for most stores. The app limits the loss cutoff to 50% and requires it to be below the thin cutoff.

Step 2: Make Cost Updates Part of Purchasing

The tent incident would not show up in any color until the new cost reached Shopify. Make it a purchasing rule: when a supplier confirms a new price, update Cost per item the same day (bulk editor or CSV), then press Recalculate in Discount Prime rather than waiting for the nightly sync.

Track cost coverage: the share of revenue from lines that have a cost. Lines without cost are silently excluded, so a campaign can look Healthy because its weakest products are not counted.

Step 3: A Daily Check During Promotions

When	Who	What to open	What to look at
Each morning while promotions run	Promotions owner	Discount Prime analytics, campaign cards	Any campaign colored Loss or Thin margin; campaigns whose margin dropped since yesterday
Same check	Same	Recent orders	Red orders: which products and which campaign; whether shipping subsidy caused it
After any supplier cost change	Purchasing	Cost per item in Shopify, then Recalculate	Affected campaigns' colors after the refresh
Weekly	Finance	Campaign profit for the week	Compare with the fully loaded figure from your own books

Responding to each color

Color	First question	Typical actions
Loss	Is it one product, one campaign, or shipping?	Pause or narrow the campaign, raise the threshold, or update prices
Thin margin	Did cost, discount depth, or shipping change?	Review this week; adjust the deepest tiers or exclude low-margin products
Healthy	Is cost coverage high enough to trust it?	No action if coverage is good

Illustrative example

Campaign	Estimated margin	Color with NorthPeak's cutoffs (12% / 25%)	Color with defaults (0% / 20%)
A	28%	Healthy	Healthy
B	12%	Thin margin	Thin margin
C	-3%	Loss	Loss
D	9%	Loss	Thin margin

Campaign D shows why thresholds matter: with defaults it looks merely thin, but after fees and handling it is losing money.

Limits and Edge Cases

No alerts. If the check is skipped, nothing reaches you. Assign an owner and a backup.
Paid orders only, no refunds. A campaign with heavy returns looks better in the app than in your books.
Free shipping is counted, but other costs are not. Subsidized shipping reduces Estimated Profit; fees and fulfillment do not.
Attribution needs a live campaign. Orders processed after a campaign ends are not attributed to it.
Bulk Price Update orders show a price change, not a discount, so judge them by margin rather than discount given.

Measuring the Monitoring Process

Detection time: hours from the first Loss-colored order of a campaign to the first action taken.
Cost lag: days from a supplier price change to the updated Cost per item in Shopify.
Cost coverage: share of campaign revenue with a cost. If it is low, fix data before trusting colors.
Reconciliation gap: difference between campaign Estimated Profit and finance's fully loaded profit. If it grows, revisit your cutoffs.

Judge the process by these, not by sales. A higher count of paused or repriced campaigns can be a good sign: it means problems were found while they were still small.

Frequently asked questions

Does Discount Prime send alerts when a promotion loses money?

No. There are no margin alert emails, below-cost notifications, or store health score. Analytics color campaigns and orders Loss, Thin margin, or Healthy, and you see those colors when you open the app. The optional order email reports that a campaign product sold, without margin. If you need push notifications, build them with another tool and test them on real orders.

What does Estimated Profit include?

Revenue on order lines that have a Shopify Cost per item, minus their cost of goods, minus shipping you subsidized. Discounts are already reflected in revenue. Lines without a cost are left out entirely. Payment fees, fulfillment, ads, and returns are not deducted, and refunds or cancellations are not subtracted because orders are recorded when paid.

How should I set the Loss and Thin margin cutoffs?

Start from the costs Estimated Profit leaves out. If payment fees, handling, and returns average about 12% of revenue, a Loss cutoff of 12% flags orders that probably lose money once those are counted. Set the Thin cutoff where a campaign meets your profit target. The defaults, 0% and 20%, only flag orders that lose money on goods and shipping alone.

Why does a campaign still look Healthy after my supplier raised costs?

Because profit uses Shopify's Cost per item. Until the new cost is entered in Shopify, every order is valued at the old cost. Costs sync nightly and you can press Recalculate after updating them. Also check cost coverage: lines without any cost are excluded, so a campaign can look healthy because its weakest products are not counted.

Is native Shopify reporting enough to monitor promotion margins?

For store-level and product-level gross profit, Shopify's reports based on Cost per item can be enough where your plan includes them. They do not break profit down by promotion. If you run many overlapping campaigns, per-campaign profit helps you find which offer is responsible, but either way someone has to review the numbers regularly.