Calculate a supplier-price review rule by defining your revenue basis, listing every included variable cost and comparing the resulting contribution before and after a cost change. Set a documented review threshold and keep approval separate from any live action. Use current account-specific charges rather than a universal marketplace fee percentage.
A supplier increase does not affect every product equally. An extra pound of cost may be manageable on one item and consume most of another item’s contribution. A useful rule therefore evaluates the business effect, not only the percentage change on the source page.
This guide provides an operational worksheet method for ecommerce sellers. It is not tax advice or a statement of current eBay fees. All worked values are hypothetical and use a consistent simplified basis. Zelluvo publishes the guide and has a commercial interest in supplier-monitoring workflows.
Name the measure before choosing a threshold
People often use “margin” to describe different calculations. Gross margin, contribution after selected variable costs and final profit are not interchangeable. Choose the measure you intend to review and list the costs it includes. That definition matters more than the label on a dashboard.
For this example, contribution means the revenue used in the model minus supplier cost, fulfilment cost and the included selling costs. The model does not claim to include fixed overhead, every possible charge or tax. A positive contribution in this worksheet does not establish positive final business profit.
Keep markup separate from contribution margin. Markup commonly compares an amount added to cost with that cost. A margin percentage uses revenue as its denominator. Confusing the denominators can make a target appear satisfied when the actual calculation is different.
Write the chosen formula in plain language beside the inputs. Another reviewer should be able to identify what was deducted without reverse-engineering a spreadsheet. If a cost is unknown, leave the decision unresolved or mark the result incomplete rather than quietly substituting zero.
Build a consistent input record
| Input | Record alongside it | Common mistake |
|---|---|---|
| Revenue basis | What the amount includes and excludes | Mixing tax-inclusive and tax-exclusive values |
| Supplier unit cost | Variant, pack conversion, currency and time | Comparing a pack with a single item |
| Fulfilment costs | Relevant delivery and packaging assumptions | Omitting a changed delivery charge |
| Selling costs | Applicable account/category assumptions | Copying another seller’s fee percentage |
| Other variable costs | Definition and allocation method | Hiding estimated costs inside an unexplained total |
Preserve original source amounts. If you convert currency or allocate a shared delivery charge, record the transformation separately. This lets a reviewer distinguish a supplier changing its price from your reporting assumptions changing.
Use a source date for each material input. A current supplier cost combined with an outdated selling-cost assumption can produce a precise-looking but unreliable result. The worksheet should make missing or stale assumptions visible before somebody acts on the calculated output.
For UK eBay business accounts, consult the current official business seller fee information and your actual account records. Sellers in Australia or other markets need the relevant local terms. This guide deliberately avoids embedding a fee rate that may not apply to your category or account.
Calculate the before-and-after effect
Consider a hypothetical item with revenue of £50 on the chosen basis. Supplier cost is £24, fulfilment costs are £5 and other included selling costs are £8. Contribution is therefore £13: £50 minus £24 minus £5 minus £8.
If the supplier cost rises to £27 while the other inputs remain unchanged, contribution becomes £10. The source cost increase is £3, or 12.5% of the previous £24 cost. The contribution reduction is also £3, but it is approximately 23.1% of the previous £13 contribution. The different denominators explain why the percentages differ.
| Measure | Before | After |
|---|---|---|
| Revenue | £50 | £50 |
| Supplier cost | £24 | £27 |
| Fulfilment costs | £5 | £5 |
| Other included selling costs | £8 | £8 |
| Contribution | £13 | £10 |
| Contribution / revenue | 26% | 20% |
Keep both the cash amount and the percentage in the review. A percentage can help compare products of different sizes, while the cash amount shows the effect on each sale. Neither replaces a clear definition of the costs included.
Also check what changed outside the supplier price. If fulfilment becomes more expensive at the same time, isolating only the supplier movement understates the combined effect. Preserve a component-level comparison so the operator can identify the cause.
Choose a rule that creates a review task
A rule can flag a product when contribution falls below a chosen amount, below a chosen percentage, or by more than a defined change from baseline. Those are different triggers. Choose them around your own operating policy rather than treating an illustrative threshold as a recommendation.
For example, a hypothetical business might request review when its contribution estimate drops below £11 or below 22% of the defined revenue. The example above would trigger both checks after the supplier increase. This does not mean that £11 or 22% is appropriate for your business; the numbers simply make the logic visible.
Specify whether the trigger compares with the previous observation or an approved baseline. A series of small increases may never exceed a single-step percentage threshold while still materially reducing contribution over time. A baseline comparison can reveal that accumulated movement if it matches your review objective.
Define the output as a review requirement, not an automatic commercial conclusion. A lower contribution may be acceptable for a particular product or strategy. The reviewer could change pricing, negotiate sourcing, reduce exposure or retain the current offer with a recorded reason. Software should not conceal that judgement behind a green or red badge.
Do not calculate a new price from incomplete assumptions
A simple required-price formula can be useful only when its assumptions fit the actual charges. If some selling costs are proportional to revenue and others are fixed per sale, they belong in different parts of the calculation. Treating every charge as a fixed amount can produce a misleading target.
For an illustrative model, let fixed per-unit costs be C, a proportional selling-cost rate be f, and a target contribution margin be m. If all those definitions are appropriate and the denominator is positive, the modelled price is C divided by one minus f minus m. This is an algebraic scenario, not a complete marketplace pricing rule.
Suppose C is £30, f is 10% and m is 20%. The denominator is 70%, so the modelled price is approximately £42.86 before any additional rounding or excluded considerations. At that price, the model’s proportional cost and contribution follow the stated assumptions. Real fees can have more complex bases, tiers and conditions.
If f plus m is one or greater, the formula does not produce a meaningful positive solution under that model. Flag the assumptions for review. Do not hide the problem with an arbitrary default price. Likewise, treat a missing cost as missing rather than allowing a blank cell to appear as a zero-cost opportunity.
Validate the supplier change itself
Before trusting the worksheet, confirm the exact source variant and cost basis. A new pack size, currency or account condition may explain the apparent movement. Record whether the supplier changed its price or whether your observation began reading a different field.
Check promotional conditions and minimum quantities. A crossed-out standard price and a temporary offer may both appear on the page. The relevant value depends on what your business can actually obtain. A monitoring tool should preserve the observation and expose uncertainty rather than automatically choosing the cheapest number.
Keep failed readings separate from valid amounts. A missing or zero result may require investigation. Retain the last valid cost with its original timestamp, and prevent the new uncertainty from looking like a confirmed dramatic price reduction.
If a mapping changed, reassess any outstanding margin review calculated from the old source. Updating the source link does not necessarily recalculate an existing proposal. The reviewer should see which evidence and assumptions supported the result they are approving.
Record decisions and baseline changes
Once a reviewer reaches a decision, record the selected action and reason. An accepted lower contribution should not be indistinguishable from an ignored warning. A rejected source reading should preserve the reason it was considered unreliable.
When you accept a new cost baseline, record its date and ownership. Otherwise, repeated alerts may remain tied to an obsolete value, or a silent reset may erase the history of a material increase. Clear baseline management makes later comparisons easier to interpret.
Separate the commercial decision from any live marketplace action. If a price or stock change is appropriate, use the permissions and review controls available in the relevant system, then verify the destination. A note saying “approved” does not establish that the listing changed successfully.
Zelluvo’s documented live eBay stock behaviour is approval-first. Confirm any specific price-review or price-update capability separately for your account. The calculation in this article can support a manual decision record even when a monitoring product does not implement every formula or rule described.
Test the worksheet before applying it widely
Specify whether a threshold includes equality. A rule for contribution below £10 behaves differently from one for contribution at or below £10. Test the exact boundary with an unrounded calculation, then confirm that the displayed result does not suggest the opposite outcome. Record this choice so a later spreadsheet revision preserves the intended behaviour.
Use a small set of cases with known expected results. Include a stable cost, a modest increase, a missing input, a pack-size change and an invalid denominator if you use the illustrative target-price model. These cases check interpretation as well as arithmetic.
- Write the revenue and cost definitions beside the test inputs.
- Calculate the expected result independently for one simple item.
- Change only the supplier cost and confirm the contribution difference.
- Change a second cost and check that the combined effect is visible.
- Remove an input and confirm that the result is marked incomplete.
- Test the review threshold exactly at, just above and just below its boundary.
- Record a decision and check how the baseline is retained or updated.
- Have another operator explain the result from the saved record.
Keep rounding rules explicit. Round for display only where possible and decide how actual commercial prices will be reviewed. A formatted two-decimal cell should not hide a calculation error or imply that every real charge is known to the penny.
Review the worksheet when selling terms, supplier conditions or your operating model changes. A rule that remains mathematically correct can still become commercially inappropriate if its inputs no longer describe the business.
Connect the calculation to a useful monitoring routine
Prioritise records where supplier changes are frequent, contribution is sensitive or source interpretation is difficult. That is a practical starting point, not proof that other products are safe. Expand coverage after the team can explain the pilot results and resolve exceptions consistently.
For tool selection, read the supplier price monitoring software guide. For the wider account workflow, use the eBay inventory software guide. If you are assessing Zelluvo, discuss your cost-review requirements and confirm the current source and account scope.
Questions about margin review rules
Is contribution the same as profit?
No. The contribution measure in this guide subtracts only the defined included variable costs. Fixed overhead and other excluded items still matter. Name the measure and its exclusions before using it in a commercial decision.
Should I use a fixed percentage for marketplace fees?
Only if that assumption accurately represents the specific calculation you are making. Actual charges can depend on account, category and other conditions. Use current applicable information and mark approximations clearly.
What if the supplier cost is missing?
Mark the result incomplete and investigate the source. A blank amount should not become zero in a decision-making calculation. Keep the previous valid amount as historical evidence with its date.
Does crossing a threshold mean I must raise the selling price?
No. It means the item needs the review defined by your policy. Pricing, sourcing and assortment decisions require commercial judgement. Record the chosen response and verify any separately authorised live action.