Calculate a Rebate Before or After Shopify Discounts?

A campaign promises 10% back on an order containing a $120 item and an $80 item. The customer receives $30 of merchandise discounts before paying. Is the proposed reward $20 or $17? Both numbers can be calculated correctly from different bases. The merchant must choose which base the offer means.

The problem is not the percentage. It is the amount to which the percentage applies. This worksheet separates original merchandise value, allocated discounts and the resulting paid merchandise amount so the selected rule can be stated unambiguously.

Separate original merchandise price from discounted merchandise value

Use a fictional basket with a $120 desk organizer and an $80 shelf. The organizer receives $20 of discount and the shelf receives $10. The original merchandise total is $200. Discounts total $30. The discounted merchandise amount is therefore $170.

For this example, assume both items are eligible and the discount allocations are already established. Shipping, tax and other charges are excluded from the reward base. This article does not decide which promotions can combine or configure Shopify’s discount engine; it takes the actual merchandise amounts as inputs.

Shopify documents discount-combination behavior, including different discount classes and calculation order. When building a live reward worksheet, use the resulting order values from the relevant setup rather than assuming every discount is a simple reduction of the same subtotal.

Name the two candidate bases in plain language. Base One is eligible merchandise value before the selected discounts. Base Two is eligible merchandise value after those discounts. Avoid vague labels such as gross and net unless the team has defined exactly which amounts those labels include.

Calculate both reward bases on one order

Apply the same 10% rate to each candidate base.

The difference is $3, which equals 10% of the $30 discount. That relationship explains the result: the before-discount formula continues to reward the portion of original merchandise value removed by the discounts, while the after-discount formula does not.

Neither calculation determines whether the offer is commercially appropriate. A merchant might deliberately calculate from an original reference value, or it might choose the amount paid for eligible merchandise. The important point is that the selected base must be intentional and supported by the approved program.

Now change only the discount. If the basket receives $50 of merchandise discounts, the original-value reward remains $20 while the after-discount reward becomes $15. The formula’s sensitivity to discounts is therefore different. This matters when the same reward offer appears alongside several purchase promotions during its lifetime.

A difficult case involves an order-level discount allocated across eligible and ineligible products. The reward base should use the relevant eligible-line values under the chosen rule, not blindly subtract the whole order discount from only the eligible merchandise. This worksheet assumes the allocation is already known; the implementation team needs an authoritative allocation input rather than a new commercial guess.

For example, if an eligible $100 item has a confirmed $12 allocated discount, its after-discount base is $88. A separate ineligible item’s discount does not further reduce that $88 merely because both appear in the same order. The calculation follows the selected line values, not an approximate cart-level subtraction.

State the selected base unambiguously

A useful amount specification names the eligible merchandise, the discount treatment and the excluded charges. For the fictional basket, one possible statement is: “Calculate the proposed 10% reward from eligible merchandise value after the discounts allocated to those eligible lines. Exclude shipping, tax and other non-merchandise charges in this example.”

If the merchant selects the original-value approach, the statement should identify the exact reference amount. “Before discounts” can still be ambiguous if the team alternates between a current catalog price, an order-time price and a compare-at price. The selected input must be one reproducible amount, not whichever reference happens to be available.

Attach the $200/$30/$170 worksheet to the specification. Sales should obtain $17 under the after-discount rule, finance should budget the same $17 and engineering should receive the same expected output. If one team calculates $20, the disagreement is evidence that the base description remains unclear.

Keep this decision separate from whether two offers are permitted to coexist. A merchant can allow a checkout discount and a later reward while still choosing either approved base. Conversely, a base definition does not authorize all discount combinations. The formula describes the amount once the relevant purchase and offer conditions have been established.

A final edge test is a fully discounted eligible line. Under the example’s after-discount rule, a line reduced to zero contributes zero to the percentage base. Under an approved original-value rule, it could contribute its stated original value. The team should explicitly accept the selected result rather than encounter it for the first time during a live campaign.

Preserve the chosen treatment when a customer uses several discounts. The worksheet needs the final allocated merchandise reduction relevant to the selected base, not a count of discount codes. Two codes producing $30 of eligible-line reductions should not change the after-discount result merely because another customer reached the same $30 reduction through one promotion. Equivalent approved monetary inputs should produce equivalent reward amounts under the same rule.

The practical output is one filled discounted-order worksheet and a single authoritative base definition. With those in place, the reward percentage becomes an unambiguous calculation rather than a number that different teams apply to different versions of the same order.

Review the monetary base your proposed Shopify rebate should use. Discuss program fit.

Source references

• discount-combination behavior
• Discuss program fit

Back to contents