Calculate progressive commission tiers
Enter eligible sales and a threshold in USD, then the base rate and the rate above the threshold. The higher rate applies only to revenue above that threshold.
- Result
- $1,300.00
- Result
- $2,000.00
How this estimate works: Use your own store data before making a commercial decision. All monetary amounts are USD.
Define the event that qualifies a creator
A tier can depend on eligible revenue, approved orders, or another clearly documented condition. Choose a measure that matches the behavior you want to reward and can be reconciled. Gross checkout revenue may include refunded or ineligible items, while approved revenue may become available only after a review period. Explain which measure counts, the measurement window, and when you evaluate the result.
Avoid a rule that changes meaning mid-campaign. State whether the period is a calendar month, a rolling window, or a one-time milestone, and what happens when the next period begins. Also decide how returns affect qualification. A creator should be able to understand progress from the records you provide without guessing whether pending orders or excluded products contribute toward the threshold.
Separate whole-period and marginal tier rules
A whole-period rule applies the higher rate to all qualifying revenue in the period after the threshold is reached. A marginal rule applies it only to revenue above the threshold. These can have very different costs near the boundary. This tool uses the marginal interpretation: revenue up to the entered threshold earns the base rate, and only revenue above it earns the second rate. It does not apply the higher rate to the entire period.
The displayed total adds the commission earned in both revenue bands. For a prospective promotion, keep earlier orders at their original rate and use the higher rate only after its effective date. Write the chosen interpretation into the offer with a numerical example. Calling all of these arrangements “tiered commission” without further explanation creates avoidable disagreement when the first payout is prepared.
Check the incentive against product contribution
Estimate the additional commission expense at the promoted rate and compare it with the contribution available from the creator’s product mix. High revenue does not guarantee high margin. A partner promoting discounted low-margin products may reach a revenue threshold while leaving little capacity for an increased payout. Keep eligibility and economics aligned, and model the largest plausible qualifying period before committing to a retroactive rule.
Operational simplicity matters too. A small pilot may benefit from one published base rate and a clearly approved upgrade rather than a complicated ladder. Confirm that your chosen tooling and reconciliation process can represent the exact policy before announcing it. This planner is an economic comparison, not a claim that Afivio automatically implements every possible tier structure or retrospectively recalculates past orders.
Worked example · illustrative scenario
Worked example: a progressive threshold
With 6,000 in eligible sales, a 5,000 threshold, a 10% base rate, and 12% above the threshold, commission is 500 + 120 = 620. A separate whole-period policy applying 12% to all sales would pay 720. The calculator implements the first, progressive model; these illustrative rules must be distinguished in your actual offer.
Frequently asked questions
Does the planner automatically change affiliate rates?
No. It compares amounts. Confirm your program’s configuration and operating process before offering a specific threshold or effective-date rule.
Should higher rates apply to previous orders?
Only if that is the published policy. Whole-period, marginal, and prospective rules have different costs and should never be treated as interchangeable.
What should count toward a revenue threshold?
Define a reconciliable eligible revenue measure, including how discounts, excluded products, and refunds are handled. Use the same definition in the offer and the review.
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.