How to stop overselling one-of-one items across your store and channels
When you only have one of something, a quantity count will not protect you. A practical system for resellers selling the same item online and at the counter.
A customer buys a pre-owned jacket at your counter at 2:10 pm. At 2:14 pm, someone else buys the same jacket on your website. You now have one jacket, two paid orders and an apology to write.
A brand selling 400 units of a t-shirt can absorb this with a safety buffer. A reseller cannot. When you hold exactly one of something, there is no buffer to hold back. The item is either available or it is gone.
- 2:10 pmJacket sells at the counter
- 2:10 to 2:14 pmWebsite still shows it in stock
- 2:14 pmSame jacket sells online
- ResultTwo paid orders, one jacket
Illustrative. The minutes between the two sales are where oversells happen.
Why overselling hurts more than a lost sale
The refund is the small part. An oversold order also costs you:
- The staff time to find the problem, cancel the order and contact the customer.
- The trust of a buyer who thought they had won something scarce.
- Marketplace standing, if the cancellation lands on a channel that scores sellers on it.
- Time spent after the fact, working out which record was wrong.
Most oversells come from the same place: the item exists as several separate copies, one on each channel, and something has to keep those copies in agreement.
Five rules that prevent most oversells
Stop tracking "Jacket, size M, quantity 3" when those three jackets differ in condition, cost or owner. Give each physical item an ID at intake. A channel listing should point at a specific unit, so that when the unit sells, there is no doubt about what is gone.
Pick a single record that answers "can this still be sold?" Shopify, eBay and your register should all take their answer from it. If each one keeps its own opinion, they will eventually disagree.
Online orders arrive with a timestamp. A floor sale often goes unrecorded until someone gets to it. Ring every counter sale through a system that removes the unit straight away, and never write one down to enter later.
A low-value, one-of-one item rarely earns a place on every channel. Keep wide listing for items where extra reach changes the outcome, and accept that each added channel adds one more place that can go stale.
Pick 10 to 20 items at the start of each shift and confirm that they are where the record says they are. Small daily counts find a broken process weeks before a full stocktake would.
Decide what happens when it goes wrong anyway
Even a good system will have a bad day. Write the procedure down before you need it, so nobody invents one with an angry customer waiting.
| Situation | What to do |
|---|---|
| Two online orders for one item | Keep the earlier order. Contact the other customer within the hour. |
| Online order for an item already sold in store | Cancel online and offer the closest alternative you actually hold. |
| Item is on record but cannot be found | Mark it unavailable first, then search. Do not leave it listed while you look. |
| Same item sold on a marketplace and your own site | Check the marketplace's cancellation rules before you choose which order to keep. |
How StackKnack helps
StackKnack Console is built around the unit rather than the SKU count. Each item gets one record holding its location, condition, cost and owner, and your channels work from that record.
Connections are not all the same, so it helps to be exact about what each one does:
- Shopify: listings, stock and orders sync with Console.
- eBay: you manage listings and available stock from the item record.
- Clover POS: counter sales remove the sold unit from available inventory.
- ShopifyListings, stock and orders
- eBayListings and available stock
- Clover POSCounter sales
So the jacket from the opening example sells at a Clover register, the unit comes out of available stock, and it stays tied to that sale for everything that follows. You can see what each channel connects to on the integrations page.
Selling the same items in more than one place? Bring us an example of an item's journey from intake to sale, and we will show you how Console keeps it connected.