Seller Profit Guard

How to calculate the complete cost of a promotion stack

Last updated: 2026-07-29

Written and reviewed by Seller Profit Guard Editorial Team.

Calculate a promotion stack by applying the item discount first, applying the order coupon to the revised subtotal, then subtracting seller-funded shipping, platform and payment fees, affiliate commission, product, packaging, fulfillment, advertising, and expected return loss. Compare the remainder with both break-even and one declared target contribution margin.

formula and input map from promotion configuration to contribution decision
A formula sheet keeps rules, funding, economics, and rollback visible.

What does this equation and input map answer?

Calculate an offer stack by applying the item price reduction first, applying the transaction coupon to the revised subtotal, then subtracting merchant-funded shipping, channel and payment fees, affiliate commission, product, packaging, fulfillment, advertising, and expected return loss. Contrast the remainder with both break-even and one declared target remainder margin. This page treats the equation sheet as a bounded operating aid for the operator, not as a substitute for a channel statement or cart engine.

A $60 transaction uses a 5% item price reduction, a 10% transaction coupon, 8% fees, 5% affiliate commission, $3 merchant-funded shipping, $21.50 product-through-fulfillment outlay, $3 advertising, and $1.50 expected return loss. The transaction stays at one declared grain so the offer layers, merchant proceeds, and outlay can be contrastd without mixing products, countries, currencies, or transaction states.

The item price reduction reduces the merchandise subtotal before the modeled transaction coupon. Fees and commission use the resulting merchant-entered net basis in this estimator; the live channel statement may define different bases and remains the authority. Record the convention beside the calculation; a hidden convention is a authority of basis error, not a harmless simplification.

formula and input map formula with revenue discount and contribution layers
The formula sheet keeps sequence, funding, and bases visible.

How should the deduction sequence be calculated?

Start with gross merchandise seller proceeds for the selected transaction. Apply an item-level percentage to the eligible merchandise amount, then apply the transaction coupon to the revised subtotal when that is the verified sequence. Subtract fixed merchant-funded shipping separately. This retains each shopper benefit rather than adding percentages into one unsupported rate.

Calculate channel and payment fees and affiliate commission on the basis documented for the current market and account. The checker uses post-price reduction merchandise seller proceeds as its transparent planning basis. If the settlement report uses gross seller proceeds, shipping, tax, or another definition, replace the assumption and explain the variance in the input proof.

Round only display values. Keep unrounded numbers in the private equation sheet when cents affect the release decision. The equation is remainder, not tax or accounting profit, and excludes any overhead the operator has not entered.

Which channel combination rules must stay separate?

Etsy, Shopify, and TikTok Shop do not share one universal stacking rule. Etsy distinguishes shop and Etsy-funded coupons and can apply a best offer. Shopify uses product, transaction, and shipping classes with eligibility and application-transaction rules. TikTok directs merchants to current stacking guidance and its offer Simulator. Treat each as a separate calculation case.

Never transfer a rule from one channel, sales channel, plan, country, or offer class to another. A combination allowed in one Shopify cart path does not prove eligibility on an external cart. A TikTok-funded incentive does not prove merchant payer. An Etsy shopper offer does not define another channel’s commission basis.

Before the release decision, capture the exact account, market, product, channel, offer classes, dates, and cart outcome. If the interface shows an unexpected warning, wrong profile, missing target, ambiguous payer, or login challenge, safe-stop instead of inferring the rule.

Etsy Shopify and TikTok Shop promotion rules separated by platform
Platform-specific combination and funding rules never become universal defaults.

How should product, shipping, ads, and returns enter the equation sheet?

Use the landed product amount for the exact SKU or weighted mix, then add packaging and fulfillment at the same transaction grain. Put merchant-funded shipping in its own input because carrier zone, service, dimensional weight, and buyer charge can change independently from the merchandise deduction.

Advertising remains a separate acquisition outlay; an affiliate commission does not replace media spend. Use aggregate spend divided by the retained transactions assigned to the same campaign and window. Do not divide by impressions, clicks, all shop transactions, or refunded transactions when the question is retained remainder per promoted transaction.

Expected return loss is probability-weighted exposure after refund, reverse shipping, unrecovered outbound fulfillment, handling, inventory damage, replacement, and realistic recovery. Refresh it after the return window matures. An unresolved transaction is not final input proof.

What base and stress calculation cases belong in the analysis?

The base calculation case uses the most supportable present values. Stress higher shipping, advertising, return loss, and affiliate commission; a lower retained-transaction denominator; and a different redemption mix. Change one variable first, then combine an ordinary downside case whose values come from observed variation or contract boundaries.

A $60 transaction uses a 5% item price reduction, a 10% transaction coupon, 8% fees, 5% affiliate commission, $3 merchant-funded shipping, $21.50 product-through-fulfillment outlay, $3 advertising, and $1.50 expected return loss. Recalculate with a plausible carrier increase, a less favorable ad-outlay allocation, and a mature return estimate. The point is to identify which layer consumes the remainder floor, not to manufacture dozens of arbitrary combinations.

Keep the single-coupon row as a matched control. Hold product, base seller proceeds, fee convention, direct outlays, advertising, return exposure, and target constant. Add only the full-stack layers so the calculated remainder difference remains interpretable.

What input proof is required before decision?

retain market, currency, time zone, product and variation scope, offer class, item and transaction price reduction settings, combination controls, payer owner, fee and commission convention, shipping rule, direct-outlay version, advertising filter, return cohort, authority access dates, and calculator version.

Use aggregate inputs and privacy-safe references in the working equation sheet. Buyer identities, addresses, messages, payment details, raw transaction exports, private CSV files, affiliate contact details, and account credentials are unnecessary for this public checker and must remain in the approved private environment.

Separate official channel guidance, merchant-observed records, model assumptions, and the release decision. A authority can define eligibility without proving settlement; a payout can show payer without proving causal demand. Unknown inputs remain labeled unknown or assumed.

How should the remainder floor and maximum coupon be read?

Break-even is zero remainder under the entered assumptions. The target reserves the merchant’s declared margin requirement. The checker’s maximum transaction coupon at target solves for the coupon rate that would consume the remaining cushion after the other full-stack layers. It is a sensitivity boundary, not channel permission.

If fee plus affiliate rates leave no remainder-bearing seller proceeds, or item price reductions eliminate the subtotal, no safe coupon rate exists. A displayed zero can also mean the target is already missed before the transaction coupon. Diagnose the outlay stack rather than interpreting zero as a recommended launch value.

An equation that applies every percentage to the original price can overstate or understate merchant payer. An equation that silently treats channel-funded incentives as merchant-funded produces a different error. Express the remainder floor as a range when shipping, ads, returns, or settlement bases are uncertain. The precision of the calculated remainder cannot exceed the precision of its inputs.

Which release decision and rollback controls apply?

Approve only when every input has a authority or explicit assumption, the cart transaction is verified for the current account, and the base and ordinary downside case both clear the target. The decision log names owner, market, product, exact offer layers, start and end, volume or spend cap, expected comparison window, unchanged context, exception list, stop trigger, and restoration instruction.

After saving, reconcile the intended product, dates, eligibility, combination settings, budget, and customer-facing output. Use a cart simulator or controlled test appropriate to the channel. Do not assume a saved configuration is active merely because the editor accepted it.

Rollback restores the retaind offer state or pauses the offer when remainder misses the remainder floor, payer differs from the approval, shipping or returns drift beyond bounds, the wrong context appears, or a channel or policy warning is unresolved. Reconcile the restored state and keep the failure record.

formula review controls from source snapshot to rollback
A reversible release decision includes verification and a restoration path.

How should the calculated remainder be reviewed after the offer?

Wait for the declared proof window, then reconcile retained transactions, merchant-funded price reductions, fee and commission settlement, shipping, advertising, returns, and outlay changes at the same grain. Use observed-after language; do not claim the offer caused volume without a credible experimental design.

contrast the modeled base, stress range, and reconciled distribution. Diagnose variance by layer. A miss caused by carrier mix requires a different response from one caused by affiliate rate, redemption mix, fee basis, ad allocation, or refund maturity.

Close the equation review with keep, cap, adjust, retest, hold, stop, or rollback and a reason. Schedule the next check and retain the accepted equation, authoritys, calculated remainder, exceptions, and restoration state.

What should the merchant do next?

Open the Coupon Stack Risk Checker and enter one representative transaction without private data. Save the single-coupon and full-stack outputs, then replace every default with an account-specific value supported by the input proof map.

Run the cart and authority checks described above. If the full-stack calculated remainder clears the remainder floor, test within the declared cap. If it fails, change one controllable lever—price reduction, shipping, commission, ad spend, price, or direct outlay—then rerun the matched cases.

The calculator is unaffiliated with Etsy, Shopify, TikTok, or other channels and does not provide tax, legal, accounting, or channel-compliance advice. Verify official guidance and current account behavior before publishing or spending.

Sources and further reading

Related Seller Profit Guard tools

Next step: Open the Coupon Stack Risk Checker.

This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.