Find the order threshold
Enter fixed campaign cost, net order value, and variable cost per order in USD, plus commission. Variable costs should include product, fulfillment, and payment expenses.
- Result
- $33.00
- Result
- 31
How this estimate works: Use your own store data before making a commercial decision. All monetary amounts are USD.
Build the threshold from contribution per order
Break-even orders equal the fixed cost divided by positive contribution per order, rounded up to a whole order. Contribution here starts with the net order value you enter, then subtracts variable cost per order and percentage affiliate commission. Deduct the customer discount before entering net order value. Keep all inputs in the same currency and use the same monthly period for the fixed cost and the eventual order comparison.
This threshold concerns the costs in the worksheet. A single app subscription may be only part of a real program budget: include recurring creative, administration, or other campaign expenses if you want the target to cover them. Include shipping subsidies, fulfillment, and payment costs in the per-order variable-cost input when they apply. Do not quietly assume that a displayed break-even order count covers every expense in the business.
Recognize when more orders cannot fix the offer
If contribution per order is zero, additional orders provide nothing toward a positive fixed cost. If contribution is negative, additional orders deepen the modeled loss. In either case, the useful action is to reconsider the discount, commission, eligible product mix, or costs. The calculator should not present a negative number of orders as an achievable target. There is no finite positive threshold for that scenario.
Near-zero contribution also deserves attention even when the formula returns a number. A very large threshold may be mathematically correct but operationally unrealistic for your current creator roster. Compare it with observed eligible orders, available inventory, and your capacity to support partners. A threshold is a requirement of the offer economics, not evidence that the necessary demand exists or that paid acquisition would be sensible.
Translate the number into a reviewable pilot
Once you have a plausible threshold, set a pilot period long enough to observe the purchase cycle and relevant returns. Record actual eligible orders and the contribution they generated, rather than counting all clicks or code redemptions as success. If order values vary substantially, use actual aggregate contribution for the final review. An average-order threshold becomes less reliable when a few large baskets dominate the outcome.
Write down the decision you will make if the threshold is missed. You may need to improve the landing page, recruit better-matched creators, or redesign the offer; cutting the rate alone may weaken participation. Compare a base scenario with a smaller basket and a stronger discount to see whether the threshold remains manageable. Recalculate when costs or program terms change instead of keeping an outdated target.
Worked example · illustrative scenario
Worked example: rounding to a whole order
With an illustrative 80 net order value, 40 variable cost per order, and 10% commission, contribution is 32 per order. A fixed cost of 150 requires 4.6875 orders mathematically, so the practical threshold is 5 qualifying orders. Four orders contribute only 128. The variable-cost input should include all relevant order-level expenses.
Frequently asked questions
Why does the tool round up?
A fraction of an order cannot cover the remaining expense in an order-count target. Rounding down would report break-even before the modeled fixed cost has actually been covered.
What happens when the fixed cost is zero?
There is no positive fixed expense to recover. Still inspect contribution per order: an offer that loses money on each order does not become sustainable because its fixed cost is zero.
Can I use this threshold as a sales forecast?
No. It shows the order volume required by your assumptions. Forecasting demand requires separate assumptions about active creators, qualified traffic, conversion, and order value.
Put your Shopify affiliate plan into practice
Use Afivio to organize your affiliate campaigns, partners and commission records. Review the integration guide and current app listing before choosing your setup.