What Manual Supplier Price Updates Really Cost: Calculate It for Your Store

Ask any e-commerce owner what supplier price updates cost them, and you’ll usually hear the same answer: “Nothing. I do it myself.”

Manual updating has no invoice, so it never shows up in any report. But there is a cost — just not in cash. It sits in five lines that aren’t in your bookkeeping: your time, overselling, outdated prices, missed sales, and creating new products.

This post isn’t a study, and it doesn’t claim to tell you what you’re losing. It’s a calculation model — five formulas and one worked example. The goal is simple: that after 20 minutes you have your own number instead of a hunch.

⚙️ Methodology and assumptions (read this first)

To be straight with you, here’s where the numbers below come from.

The example below is an illustrative model, not measured data. The store parameters (order count, margin, supplier count) were chosen as a typical case. The rates the calculation rests on — overselling frequency, price drift, missed-sales share — are conservatively chosen assumptions, not the result of market research.

Your store’s rates will almost certainly differ. They depend on category, supplier discipline, season, and how fast your assortment turns over. So don’t transfer the example result to yourself — take the formulas and plug in your own data.

The assumptions we use, and why:

How to measure your own rates instead of guessing is covered in “How to get your own numbers”.

The example store

Line 1: your time

The only line you can measure precisely rather than model. What does one “quick update” actually look like?

Twice a week, that’s roughly 20 hours per month.

In the example: 20 h × €18 = €360 per month

This estimate excludes the times a supplier changed their file structure and everything broke, or the import failed halfway through.

But €360 isn’t the main point. The main point is that these are 20 hours you didn’t spend improving product pages, talking to customers, or negotiating better supplier terms. The opportunity cost here is often higher than the hourly rate.

How to measure it yourself: start a timer next time you update. One measurement is enough.

Line 2: overselling

If you update stock twice a week, the average gap between updates is 84 hours. For all that time your store is selling against data that may be three days old. The result: a customer orders a product your supplier no longer has.

What one such order costs:

In the example, at the 3.5% assumption: 7 orders × €22.17 ≈ €155 per month

On the payment fee — this isn’t an estimate, it’s Shopify’s rule. Standard Shopify Payments online card rates in Lithuania:

These rates exclude VAT — it’s added separately. Whether that’s a real cost to you depends on your status:

• VAT-registered → VAT is deductible, real cost stays €1.42;

• Not VAT-registered → VAT isn’t recoverable, real cost is €1.72 (€1.42 × 1.21).

(Worth checking against your own Shopify invoices — for VAT-registered businesses, EU services are usually reverse-charged, so VAT doesn’t appear on the invoice at all.)

Now notice how this stacks. The cheapest plan carries the highest rate, and the smallest stores are also the ones least likely to be VAT-registered. The extremes differ by a third:

In other words: the smaller the store, the more each oversell costs it — even though that euro hurts it most. The example uses €1.42, because our store is VAT-registered (€156,000 annual turnover, well above the €45,000 threshold) and on the Basic plan.

Now, what happens to that fee when you refund the customer. Shopify’s help center puts it plainly: the original card transaction fee is not refunded to you when you issue a refund. It goes further, stating you get no card fees back on a cancelled or refunded order, whether or not it was fulfilled.

In fairness: no additional fee is charged for the refund itself, so you’re not double-charged. But the original €1.42 stays with Shopify.

In practice: every oversell costs you €1.42 just for the right to cancel a sale you earned nothing on. The smaller the average basket, the worse it stings — on a €25 order the fixed €0.25 alone is a full percent you’ll never get back.

What about WooCommerce and bank link?

In Lithuania many stores run WooCommerce with Paysera or Opay rather than Shopify Payments. The numbers there are different — and not always lower.

A Paysera fee has two parts: the bank or system fee plus the Paysera system fee (0.9%, min €0.10, max €0.40 in the lowest tier). On a €65 order:

Two counterintuitive conclusions:

1. Payment initiation (PIS) is radically the cheapest — €0.40 instead of €1.42. Banks charge nothing for it, leaving only the Paysera system fee.

2. Old-style 3% bank link is more expensive than card — €2.35 versus Shopify’s €1.42. “Bank link is cheaper than card” doesn’t always hold; it depends which bank your customer pays through.

⚠️ And this matters most for refunds. Paysera’s terms state that the crediting fee is not returned — the same principle as Shopify. But there’s a difference that doesn’t favour bank link: Shopify charges nothing extra for the refund itself, whereas through Paysera a refund is a separate transfer to the payer, priced according to the recipient’s bank. So with bank link, a cancelled order can cost you the original fee plus an outgoing transfer fee.

Opay pricing is typically negotiated individually and there’s no public comparable rate card — check your contract.

But here’s why none of this changes the conclusion. The payment fee is the smallest part of an oversell — lost margin (€16.25) and your time (€4.50) dominate:

The gap between the cheapest and most expensive option is €14 per month, under 2% of the total. So whichever payment method you use, the model’s conclusion holds. Just plug in your own fee.

(VAT treatment may also differ — some financial services are exempt, so Paysera and Shopify invoices can look different. Check your own.)

The table excludes reputation. A customer whose order you cancelled returns less often, and if they leave a review the cost grows. We don’t model this, because we can’t estimate it reliably.

Line 3: outdated prices

Suppliers don’t change prices on your schedule. This bites hardest in electronics, appliances, and anywhere exchange rates or logistics costs move the final price.

If a supplier raised a price on Monday and you update the catalog on Wednesday, you spend two days selling at a thinner margin than you think.

In the example, at the 4% and 9% assumptions: 200 × 4% = 8 orders × €65 × 9% ≈ €47 per month

€47 sounds laughably small. But look at it differently: across those 8 orders, €10.40 of the €16.25 margin survived — roughly a third of the profit on those orders vanished. You fulfilled, packed and shipped them for almost nothing.

And if the drift exceeds your margin, you sold at a loss and paid for shipping too.

Line 4: missed sales

This line is the most invisible, because the loss is never recorded — nothing simply happens.

Your supplier restocked on Tuesday. Your catalog finds out on Thursday. For two days a product in demand shows as “out of stock” when you could have sold it. The customer goes to a competitor and you never hear about it.

In the example, at the 2% assumption: 4 × €16.25 = €65 per month

Line 5: creating new products

The four lines above measure what it costs to maintain your existing catalog. But suppliers keep adding products — and this is where the largest, most frequently uncounted cost hides.

A new product isn’t just a price and a stock number. It has to be created: name, description, images, category, attributes, SKU, pricing. Manually that takes about 5 minutes per product — plus translation if the product comes from a foreign supplier.

Say three suppliers add 150 products worth carrying in a month:

In the example: 150 × 5 min = 12.5 h × €18 ≈ €225 per month

And here’s the crucial nuance: most small stores never pay this amount — because they never create those products. So the cost takes a different form: the supplier’s assortment grows and yours doesn’t. A year later you’re selling a narrower range than you could be, and it shows up in no report.

So this line works as an either/or:

• You create products manually → you pay in time (~€225/month in the example);

• You don’t → you pay in a stalled assortment.

Automated integration removes almost all of this line: new supplier products are created on their own, with descriptions, categories and translations, according to your filters and pricing rules.

Example summary

Two totals, because these are two different scenarios. €627 if you only maintain what you already have. €852 if you also want the assortment to grow. If you do neither, the loss doesn’t disappear — it just becomes invisible.

Once more: this is the output of one model with the assumptions listed above, not a typical or measured figure. Change the overselling share from 3.5% to 1% and the result drops by about €111. Double the order count and the three error lines double, while the time lines stay roughly the same.

Note the proportion. In a store this size, time accounts for about 69% of the total loss (€585 of €852) — several times more than all the error lines combined. That’s because the amount of manual work is driven not by order count but by the number of suppliers and products: 8,000 products from 3 suppliers take the same effort whether you get 200 or 600 orders a month.

The practical conclusion: in a smaller store, automation buys you time first and reduces errors second. The error lines only dominate as order volume grows.

For comparison: for this example store (3 suppliers, 12 syncs per day) Unified Suppliers would cost €158 per month — the Plus plan at €119 plus one additional supplier at €39. Whether that pays off for you depends on your number — which is exactly why it’s worth calculating.

Why update frequency drives all three “invisible” lines

Overselling, outdated prices and missed sales share one root: how long your data stays stale. Here’s how that window shortens:

The practical floor worth treating as a minimum is several times per day. This isn’t a “more is always better” scale where you should chase the top. It’s a safety threshold: a catalog updated once a day or less means part of every day you’re selling against the past — and in peak season popular items sell out in hours, not days.

The good news is that the entry-level plan already clears this threshold — 6 syncs a day shortens the window from ~84 h to ~4 h, roughly 95%. Beyond that point, a denser schedule is no longer a safety question but a refinement: it pays off most in fast-turning categories, during peak season, and wherever supplier stock swings hour to hour.

Denser than hourly is technically possible — the limit is usually not the platform but how often your supplier refreshes their own data. There’s no point pulling a file every 15 minutes if the supplier regenerates it twice a day.

It’s important to understand what this window does not guarantee: some overselling comes from supplier errors or simultaneous order surges rather than data lag. Sync frequency doesn’t remove that portion. But it does remove the portion you can actually control — which is why it’s the first thing worth fixing.

One more thing worth noting: this loss grows as you do. Double your orders and overselling doubles. Add a fourth supplier and manual work lengthens. Manual process is the one part of your business that gets more expensive every time things go well.

Where the real break-even sits

Intuitively it feels like a tool pays off “above a certain order count”. But as you’ve seen, order count drives only three of the five lines — and the largest, time, is driven by something else entirely. So it’s more accurate to calculate two separate break-even points.

Take the Lite plan — €59/month. If you’re not VAT-registered, the real cost is €71.39 (with 21% VAT). If you are, VAT is deductible, so €59. You cross that line when annual turnover exceeds €45,000; a smaller store usually isn’t registered, so the tool costs it more.

The same logic applies on both sides: for a non-registered business, not only the tool but every Shopify fee is more expensive too. So keep one basis when you calculate — either everything with VAT or everything without.

Break-even on time (at €18/h):

Read that again: if you spend more than an hour a week on supplier files, the tool pays for itself on time alone — whether you have 20 orders or 200.

Break-even on errors. If we counted no time at all, our assumptions give about €1.34 of loss per order. You’d then need roughly 44–53 orders per month for the tool to pay for itself on error reduction alone.

Those two numbers answer the “from what point is it worth it” question: 20 orders a month can be plenty, if a couple of hours of weekly file work comes with them. And conversely — 60 orders might not justify it if you have one tidy supplier whose file imports in 10 minutes.

When manual still makes sense

• You spend less than ~1 hour per week on supplier files, and that isn’t changing.

• You have one supplier with a tidy, stable file whose structure doesn’t shift.

• Your prices barely move (e.g. your own manufactured goods).

• You sell unique or one-off items where a stock error is practically impossible.

• You’re not planning to expand the assortment — line 5 doesn’t apply to you.

If that’s you, change nothing. Come back to this calculation when a second supplier appears, or when you realise you can no longer keep up with entering new products.

How to get your own numbers

Plug your own data into five formulas:

1. Time — catalog maintenance Hours per week × 4.33 × your hourly value

2. Overselling Orders per month × overselling share × (margin + payment fee + 0.25 h × hourly value)

Use your own payment fee — Shopify Basic €1.42, PIS ~€0.40, 3% bank link ~€2.35 (on a €65 order).

3. Outdated prices Orders per month × affected share × average basket × price drift

4. Missed sales Orders per month × missed share × margin

5. Creating new products New products per month × minutes per product ÷ 60 × hourly value

6. Break-even Plan price (incl. VAT if you're not VAT-registered) ÷ your hourly value = hours per month you need to save

How to measure your rates instead of guessing:

• Overselling share — review cancelled and refunded orders from the last 30 days and count how many happened because the supplier didn’t have the item. Divide by total orders. Takes ~20 minutes and is usually an unpleasant but useful discovery.

• Price drift — take your supplier’s last two files and compare them. You’ll see what percentage of items changed and by how much.

• Missed sales — the hardest. “Out of stock” product page views in your analytics give a rough picture.

Conclusion

Manually updating supplier prices isn’t free. It’s paid not in cash but in time, margin, customers and an assortment that doesn’t grow — things nobody consolidates into a single line.

Our example, with the assumptions listed, came to €627–852 per month depending on whether you’re also expanding the assortment. Most of that was not errors, just time.

And here’s the main message: the question “how many orders before it pays off” is asked of the wrong metric. The right question is how many hours a week you spend on supplier files. If it’s more than one, the answer is already clear, even at twenty orders.

Spend 20 minutes and calculate it. If the result is higher than the cost of automation — good, now you know. If it’s lower, also good, because that’s knowledge rather than guesswork.

Questions about preparing your supplier catalog for integration? Contact us — we’ll review your supplier files and tell you what can realistically be automated.