How to prevent overselling when you sell supplier stock
Overselling happens when a store accepts an order for an item it cannot deliver. For stores that keep their own stock, the usual cause is a sale on one channel that did not reach the others in time. For stores that sell from supplier warehouses, there is a second, bigger cause: the store simply does not know that the supplier has run out.
Each oversold order costs more than the lost sale. There is the time spent contacting the customer, a possible refund, a cancellation that marketplaces count against you, and a customer who may not come back.
Why it happens
- Supplier data is updated rarely. The store refreshes stock once a week, the supplier sells out on Tuesday.
- Products disappear from the supplier's file and keep their last known quantity in the store.
- Stock statuses are interpreted too optimistically. "Limited" or "1-2 pcs" is treated as available.
- Several channels are updated separately, so one of them still shows stock after the others are corrected.
- The same item comes from two suppliers and their stock is added up even though one of them stopped supplying it.
Practical ways to prevent it
Update stock on a schedule that matches your suppliers
Find out when each supplier publishes new stock data and run your update shortly afterwards. For fast-moving products, update at least twice a day.
Treat missing products as unavailable
If a product is not in the latest file from a supplier, set its stock from that supplier to zero. Do not keep the old figure.
Use a safety threshold
Show a product as out of stock when the supplier has fewer than a set number of units. One unit at a supplier is often already reserved for someone else.
Calculate stock in one place
Combine all suppliers and your own warehouse in one catalog and send the same figure to every channel.
Prefer reliable suppliers
When several suppliers have the item, use the one whose stock data has proven accurate first.
Be honest about lead times
If you accept orders for items that ship from the supplier in several days, say so on the product page. A clear delivery estimate prevents more complaints than an optimistic "in stock".
How YfiFX helps
YfiFX updates stock from supplier price lists, feeds and APIs as part of a scheduled chain that also recalculates prices and exports the results. Stock from several suppliers and warehouses is combined in one catalog, supplier priority decides which offer is used, and you can export only items that are actually available. Products that disappear from a supplier's price list are detected on import, so they stop being sold instead of keeping an outdated quantity.
The same figures go to every channel you use: Shopify, WooCommerce, OpenCart, Horoshop, Prom.ua or an XML feed.
Check it regularly
Once a month, look at cancelled orders with the reason "out of stock". For each one, find out which supplier and which channel were involved. Patterns appear quickly, and they usually point to one supplier with unreliable data or one channel with a slower update.
Set it up once. YfiFX does the rest
14 Days Free Trial. Sign up and import your first price list today.