EN
Marketplace

How to Prevent Overselling on Marketplaces? A Course on Sellable Inventory, Inventory Buffers, Channel Shares, Low-Stock Rules and Cancellation Cost

How do you prevent overselling on marketplaces? Sellable inventory, the inventory buffer formula, channel share and cancellation cost: an 8-lesson guide with worked calculations.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: What is overselling and what causes it?
  3. Lesson 2: How is the cost of overselling calculated?
  4. Lesson 3: How is the inventory buffer calculated?
  5. Lesson 4: How do you determine sellable inventory and channel share?
  6. Lesson 5: Which rules apply at low inventory?
  7. Lesson 6: What are the return and cost of the buffer?
  8. Lesson 7: What do you do when overselling happens?
  9. Lesson 8: How do you monitor overselling?
  10. What are the most common mistakes when preventing overselling?
  11. How does NetKasam make preventing overselling easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Prevent overselling by calculation, not by guesswork
  14. Frequently Asked Questions About Marketplace Overselling

If the last two units of a product on a marketplace are sold through two different channels in the same minute, you are left with three orders and two products. This situation is called overselling. The result is clear: you have to tell a customer "it is out of stock", the order is cancelled, customer service gets extra work and your store rating suffers. As multichannel selling grows, so does the problem, because inventory information does not reach every channel at the same moment.

This article is not a narrative but an 8-lesson practical course. We will answer how to prevent overselling on marketplaces through a sample business that receives 2,400 orders per month and sells on two marketplaces and its own site: the causes of overselling, its cost, the inventory buffer calculation, channel shares, low-inventory rules, what to do when overselling happens and the monitoring indicators. At the end there is a mini quiz and an answer key. All figures are sample values chosen to show the method; follow the same steps with your own data.

What will you be able to do by the end of this training?

In short: You will find the cause of overselling, calculate its cost, set the inventory buffer per product and distribute sellable inventory across channels.

Course mapSix steps to preventing overselling
  1. 01
    FindIdentify the cause that leads to overselling.
  2. 02
    PriceCalculate the real cost of a cancellation.
  3. 03
    BufferFind the inventory buffer from peak rate and delay.
  4. 04
    AllocateDistribute sellable inventory across channels.
  5. 05
    Set rulesSet a threshold to throttle a channel at low inventory.
  6. 06
    MonitorTrack the overselling rate monthly.

The 8 lessons of the course: (1) what overselling is and what causes it, (2) its cost, (3) inventory update delay and the buffer, (4) sellable inventory and channel share, (5) low-inventory rules, (6) the return and cost of the buffer, (7) what to do when overselling happens, (8) monitoring indicators.

Lesson 1: What is overselling and what causes it?

In short: Overselling is taking more orders for a product than the units on hand. The cause is usually inventory information reaching channels late, or the same inventory being shown on more than one channel.

There are four common causes. The first is update delay: a sale happens on one channel and inventory drops, but this information reaches the other channels a few minutes later; in the meantime the same product can be sold again. The second is a shared pool: total inventory is shown at full quantity on every channel and each channel assumes all the inventory is its own. The third is transactions outside the system: a sale made in a store or by phone is not reflected in inventory. The fourth is orders waiting to be prepared: if an order has been received but not deducted from inventory, the product looks available on the shelf even though it is reserved.

For a detailed setup on update delay, see the article how to do marketplace inventory synchronization. This article goes one step further: even when synchronization is set up, the delay is never zero, so you manage the remaining risk with calculation and a buffer.

Lesson 2: How is the cost of overselling calculated?

In short: The cost of overselling is the number of oversold orders multiplied by the unit cost of one cancellation.

FormulaOverselling rate and cost
  1. Overselling rate = Orders cancelled due to insufficient inventory ÷ Total orders
  2. Monthly cost = Number of cancelled orders × Unit cost of a cancellation

The sample business receives 2,400 orders per month and 36 of them are cancelled because of insufficient inventory. The overselling rate is 36 ÷ 2,400 = 1.5%. The unit cost of a cancellation is found by adding up the labor cost of informing the customer, the compensation discount given, the effect on the store rating and the share of re-planning inventory; in the example it is taken as ₺85. The monthly cost is 36 × 85 = ₺3,060.

Cost itemHow to find it
Customer communicationTime spent on each customer called or written to × hourly cost
CompensationTotal of coupons, discounts or gift vouchers ÷ number of cancellations
Store rating effectAdditional cancellations and complaints tracked from records; in the example its share is added to the unit cost
Lost salesEstimated sales during the time the sold-out product is not visible; stockout cost is calculated separately

Calculate your own unit cost from your records; ₺85 is only an example. Also remember that not all cancellations come from overselling: customer withdrawals, payment errors or address problems should be grouped separately. To code cancellation reasons separately, see the method in the article how to cancel an order.

Takeaways from the exampleFour numbers from the overselling example
  • 1.5%monthly overselling rate (36 ÷ 2,400)
  • ₺85unit cost of one cancellation
  • ₺3,060monthly cost of overselling
  • 3 unitsrecommended inventory buffer per product

Lesson 3: How is the inventory buffer calculated?

In short: The inventory buffer is the quantity that can be sold in the time it takes inventory information to reach the channels: peak hourly sales rate × update delay (hours).

The buffer is the quantity deliberately hidden from the real inventory and not shown to channels. Its purpose is to cover orders that arrive during the update delay. Two pieces of information are needed for the calculation: the product's total peak hourly sales rate across all channels and the time it takes an inventory change to reach the channels.

FormulaInventory buffer calculation
  1. Peak hourly sales = The highest number of units sold per hour across all channels
  2. Update delay = The time for an inventory change to reach the channels (hours)
  3. Inventory buffer = Peak hourly sales × Update delay (rounded up)

In the example, a best-selling product sells 12 units per hour in total across three channels during a campaign hour, and the update takes 15 minutes (0.25 hours) to propagate. The buffer is 12 × 0.25 = 3 units. In other words, showing channels "sold out" when inventory falls to 3 units safely covers the orders that will arrive in that 15-minute window. For slow-selling products the buffer can be 1 unit or zero; applying the same buffer to every product ties up capital unnecessarily.

Product typePeak sales (units/hour)DelayBuffer
Campaign product1215 min3 units
Regularly selling product415 min1 unit
Slow-selling product0,515 min1 unit (0.125 rounded up; optional)

It is important to separate the size of the buffer from safety stock. Safety stock is inventory held against demand uncertainty during the lead time; the buffer is inventory not shown solely against information delay between channels. For how to calculate safety stock, see the article how to calculate safety stock.

Lesson 4: How do you determine sellable inventory and channel share?

In short: Sellable inventory = physical inventory − orders waiting to be prepared − buffer. This quantity can be distributed to channels according to their sales share.

ChartSellable inventory to show to channels: 60 units
  1. Physical inventory counted on the shelf80 units
  2. Orders waiting to be prepared−17 units
  3. Inventory buffer−3 units
  4. Sellable inventory to show to channels60 units

Prepared with sample values. Calculation: 80 − 17 − 3 = 60 units.

If an order waiting to be prepared has not been deducted from inventory, the product on the shelf is actually reserved. Removing these units from sellable inventory closes the most common cause of overselling. In marketplace and e-commerce integration, deducting inventory when an order is created and passing current inventory to the sales channels prevents wrong inventory counts; the details are on the marketplace integration page.

You can distribute the remaining 60 units in two ways. In a shared pool, 60 is shown on every channel and the first to sell takes it; it is a fast but risky method. In the share method, inventory is split by sales share over the last three months:

ChannelSales shareDisplayed inventory
Marketplace 1%5030 units
Marketplace 2%3018 units
Own site%2012 units
Total%10060 units
ChartShare of sellable inventory by channel
  • Marketplace 1₺3050%
  • Marketplace 2₺1830%
  • Own site₺1220%

Prepared with sample values.

The share method minimizes overselling, but inventory may remain on one channel while it sells out on another. To prevent this, update the shares weekly; if a channel's share runs out, transfer the remaining units to the other channels. The logic of managing store and e-commerce inventory in one place is explained in the article how to manage store and e-commerce inventory in one place.

Recommended ReadingHow to Sync Marketplace Inventory?

Lesson 5: Which rules apply at low inventory?

In short: When inventory falls below a threshold, throttle channels in order: first close the low-margin channel, then merge the shares, and last mark the product "sold out" on all channels.

The critical inventory threshold is the inventory limit at which you want the system to alert you. In NetKasam you can define a critical inventory quantity for a product and get a notification when inventory falls to that quantity; the notification gives you the chance to start the supply process and channel rules together. The table below is a sample rule set:

Sellable inventoryRuleGoal
30 units and aboveShown to channels by shareNormal operation
10 – 29 unitsUpdate shares daily, place the supply orderRestock before selling out
4 – 9 unitsClose sales on the low-margin channel, give the remainder to the high-margin channelProtect the margin
0 – 3 unitsShow "sold out" on all channels (the buffer is not touched)Zero out overselling

Adjust these thresholds to the product's sales rate: on a fast product 10 units may be one day of inventory, on a slow product one month. To compare channel margins, you can use the method in the article how to measure profitability by sales channel. To track inventory movements in detail, the inventory movements report in the inventory management feature is useful.

Lesson 6: What are the return and cost of the buffer?

In short: The return of the buffer is the cancellation cost avoided; its cost is the capital cost of the inventory held in the buffer. Compare the two.

In the example, once the buffer is applied, overselling falls from 36 orders to 9; that is, it decreases by 75%. The overselling rate becomes 9 ÷ 2,400 = 0.4% (approximately). The cancellation cost avoided is (36 − 9) × 85 = 27 × 85 = ₺2,295. The cost of the buffer is as follows: for 25 fast products with a 3-unit buffer per product and an average purchase cost of ₺200, the inventory tied up is 25 × 3 × 200 = ₺15,000. If the monthly cost of capital is assumed to be 3%, the cost is 15,000 × 3% = ₺450.

ChartMonthly net effect of the inventory buffer: ₺1,845 saved
  1. Monthly overselling cost without a buffer (36 orders)₺3,060
  2. Monthly overselling cost with a buffer (9 orders)−₺765
  3. Monthly capital cost of the buffer−₺450
  4. Monthly net saving₺1,845

Prepared with sample values. Calculation: 3,060 − 765 − 450 = ₺1,845. The cost after the buffer is 9 × 85 = ₺765.

The net saving comes to 1,845 × 12 = ₺22,140 per year; moreover, the calculation does not include the improvement in store rating and customer trust. If the cost of the buffer is low (few fast products, low purchase cost), it makes sense to widen the buffer; if the product is expensive and slow, shortening the update delay is a better choice than a buffer. Halving the delay (from 15 minutes to 7.5 minutes) reduces the buffer from 3 units to 1.5, that is, to 2 units when rounded up.

Lesson 7: What do you do when overselling happens?

In short: Act fast: find how many orders cannot be fulfilled, put the orders in sequence, inform the customer before they find out on their own, and record the reason.

StepWhat happens
1. CountCompare real inventory with open orders and find the number of orders that cannot be fulfilled.
2. SortSort orders from oldest to newest; separate orders that are paid, have fast delivery and can be partially cancelled.
3. Offer optionsOffer the customer waiting, a similar product or cancellation; if cancellation is needed, the order is cancelled or partially cancelled.
4. InformExplain to the customer before the order is shipped. Use the template in the article order notifications to customers.
5. RecordThe cancellation reason is entered as "insufficient inventory" and reported together with the product code.

In NetKasam you can change the status of orders and, if necessary, cancel or partially cancel them; because orders can be filtered and processed in bulk, response time is shorter in a large overselling event. For the general flow of order management, see the article how to manage orders in e-commerce.

After overselling, examine the process rather than a single product: which channel did the inventory information reach late, was there an off-system sale at the time, was the buffer insufficient? Every incident is data for updating next month's buffer and share settings.

Lesson 8: How do you monitor overselling?

In short: Track five indicators monthly: overselling rate, cancellation cost, buffer utilization, inventory update delay and the number of stockouts by channel.

IndicatorHow it is calculatedSample value
Overselling rateCancellations due to insufficient inventory ÷ Total orders%1,5 → %0,4
Monthly cancellation costNumber of cancellations × unit cost3.060 ₺ → 765 ₺
Buffer utilizationNumber of products that dropped into the buffer ÷ Number of products with a buffer6 of 25 products
Update delayTime for an inventory change to reach the channels15 minutes
Channel stockout countNumber of products whose inventory share ran out on one channel while remaining on another4 products per month

You can store the indicators as a saved report in the reports section and export them to Excel. If the overselling rate rises two months in a row, review the buffer and the shares. During campaign periods rates multiply; calculate the buffer separately for these periods. For preparation, see the article how to prepare for a busy campaign period. You can also track your on-time order fulfillment performance with the method in the article how to measure order fulfillment rate.

Recommended readingHow Do You Manage Products with Variants on a Marketplace? A Guide to Size, Color, SKU, Barcode and Variant Matching

What are the most common mistakes when preventing overselling?

  1. Showing all inventory on every channel. In a shared pool the first to sell takes it, and the last units collide.
  2. Not deducting pending orders. A product on the shelf is reserved but looks sellable.
  3. Applying the same buffer to everyone. On slow products capital is tied up for nothing, and on a fast product it is not enough.
  4. Not reflecting store sales in inventory. Off-system sales are the hidden cause of overselling.
  5. Not measuring the update delay. The buffer is set by guesswork and the real delay is unknown.
  6. Not recording the cancellation reason. Overselling gets mixed with other cancellations and its cost stays invisible.
  7. Never updating the shares. Inventory split by an old sales share sells out on one channel while waiting on another.

How does NetKasam make preventing overselling easier?

  • Inventory in one place. The inventory of the products you create is passed to your e-commerce site and to the sites you provide XML to; inventory is deducted with the order (inventory management).
  • Marketplace orders on one screen. You see orders created on all platforms in a single panel, change their statuses and, if necessary, cancel or partially cancel them (order management).
  • Up-to-date data flow. Product information and inventory statuses are kept up to date with the marketplaces (marketplace integration).
  • Critical inventory alert. You set a threshold for a product, and a notification arrives when inventory falls to that quantity.
  • Multiple warehouses and variants. Variant inventory is tracked separately, and branch and warehouse inventory is visible instantly.
  • Saved reports. You save monthly reports and export them to Excel (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. If 36 of 2,400 orders were cancelled due to insufficient inventory, what is the overselling rate as a percentage?
  2. If the cost of one cancellation is ₺85, what is the monthly cost of 36 cancellations?
  3. If peak hourly sales are 12 units and the update delay is 0.25 hours, how many units is the buffer?
  4. If physical inventory is 80, pending orders are 17 and the buffer is 3, what is the sellable inventory?
  5. If overselling falls from 36 to 9 orders, how much does the cancellation cost decrease (unit cost ₺85)?

Answer key:

  1. 36 ÷ 2.400 = %1,5.
  2. 36 × 85 = 3.060 ₺.
  3. 12 × 0.25 = 3 units.
  4. 80 − 17 − 3 = 60 units.
  5. (36 − 9) × 85 = 27 × 85 = 2.295 ₺.

Frequently Asked Questions About Marketplace Overselling

How do you prevent overselling on marketplaces?

Calculate the inventory shown to channels as sellable inventory: from physical inventory, subtract orders waiting to be prepared and the inventory buffer. Make sure inventory changes reach channels as fast as possible.

What causes overselling?

The main causes are inventory information reaching channels late, the same inventory being shown at full quantity on several channels, sales outside the system not being reflected in inventory, and pending orders not being deducted from inventory.

What is an inventory buffer and how is it calculated?

It is a safety quantity that is not shown to channels. Multiply the peak hourly sales rate by the inventory update delay (in hours) and round up.

Is the buffer the same as safety stock?

No. Safety stock is held against demand uncertainty during the lead time; the buffer is stock that is not shown solely against information delay between channels.

Should inventory be shown to each channel as a share?

For high-risk products, yes. Sellable inventory is split by sales share over recent months and updated weekly. The share method reduces overselling but increases the risk of selling out on one channel.

What should I do if overselling happens?

Find the number of orders that cannot be fulfilled, sort the orders from oldest to newest, offer the customer waiting, a similar product or cancellation, and record the reason as "insufficient inventory".

Does a critical inventory alert prevent overselling?

It does not prevent it on its own but it helps. When inventory falls to the threshold you set, you get a notification and can activate supply and channel rules in time.

How often should the overselling rate be monitored?

Monthly. During campaign periods, weekly or even daily monitoring is recommended, with the buffer calculated separately for that period.

Conclusion: Prevent overselling by calculation, not by guesswork

The most useful thing you can do today is to count the orders cancelled for insufficient inventory over the last three months and find the unit cost of one cancellation. The next step is to measure peak hourly sales and update delay for your 10-20 best-selling products, calculate the buffer and distribute sellable inventory across channels. If the return on the buffer is greater than its cost, roll the rule out more widely.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeMarketplace Integration

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools