How to Sync Shopify, eBay and In-Store Inventory
A practical setup and daily routine for keeping Shopify, eBay and your shop counter on one stock count, so an item that sells in one place disappears everywhere.
To sync Shopify, eBay and in-store inventory, pick one record that decides what is available, give every item the same ID on every channel, and make each sale (online or at the counter) reduce that one record before anything else happens. Then run a short daily routine that catches the gaps: unrecorded counter sales, listings that did not update, and items that are not where the record says they are.
That is the whole method. The rest of this guide is the setup, the routine and what to do on the day it fails anyway. If you want the background on how sync software passes sales between platforms, read multi-channel inventory sync explained first. This post is the practical side: what to set up on Monday and what to check every morning after that.
Take a small vintage and sneaker shop. It has a counter, a Shopify store and an eBay account. On Saturday afternoon a pair of boots sells at the register. Nobody updates anything for an hour, because the shop is busy. In that hour the boots sell again on eBay. The owner now has to cancel an eBay order, and cancelling on eBay is not free.
Why do Shopify, eBay and the counter disagree?
Because each one keeps its own copy of your stock. Shopify has a number for each product at each location. eBay has a quantity on each listing. The register knows what it rang up, and the shelf holds what is really there. Four copies, and every sale changes only one of them until something carries the change to the others.
- Saturday, 2:05 pmBoots sell at the counter
- Nobody updates the listingsShopify and eBay still show 1 in stock
- Saturday, 3:10 pmSame boots sell on eBay
- ResultAn eBay cancellation and an unhappy buyer
Illustrative. The gap between the two sales is where oversells happen.
The counter is usually the weak link. Online orders arrive with a timestamp and a notification. A counter sale only reaches your other channels if someone rings it through a system that is connected to them, or remembers to update them by hand later.
What does an oversell cost on each channel?
On eBay, the cost is written into the rules. eBay's order cancellation policy says that cancelling an order because the item is out of stock will result in a transaction defect. So an oversold eBay order costs you more than the refund.
On Shopify, the cost is mostly the customer and the staff time. Shopify does help you, though: it separates units you can still sell from units already promised. In Shopify, "available" inventory is stock you can sell, and it is not committed or set aside as unavailable. Committed inventory is units set aside that can't be sold, such as units in an unfulfilled order. That split matters later, when you check numbers each morning: look at what is available, not what is on the shelf.
Step by step: set up Shopify, eBay and in-store sync
You can do most of this with what you already have. Software makes steps 4 and 6 automatic, but the decisions in steps 1 to 3 are yours either way.
Decide which system answers "can this still be sold?" It might be Shopify, an inventory system, or for a very small shop a single spreadsheet. Write the choice down. Every other channel follows that record, and nobody edits eBay or Shopify stock directly except through it.
Use one SKU or item ID per product, and for one-of-one items per physical unit. Put the same ID on the Shopify product, the eBay listing and the tag on the item in the shop. If the IDs do not match, nothing can match a sale to the right listing.
Close the counter for an hour or do it before opening. Count what is physically there and set your one record to that count. Then set Shopify and eBay to match it. Starting from three different numbers guarantees you will spend a week chasing them.
Link Shopify, eBay and your register to the record, either through an integration or through a written manual routine. The test is simple: when a unit sells anywhere, how does each other channel find out, and how long does that take?
Not every item needs to be everywhere. A one-of-one item listed on three channels is three chances to sell it twice. List widely where the extra reach changes the price or the speed of sale, and keep cheap or fast-moving items to the counter and Shopify.
Ring every in-store sale through a register that updates the record straight away. Never write a sale on paper to enter later. If the register is not connected, update the record before the customer leaves the counter.
In eBay's selling preferences, under multi-quantity listings, there is a setting that keeps listings active when you are out of stock. With it on, a listing that reaches a quantity of 0 stays active but hidden from search results, and it reappears when you increase the quantity. That keeps its history when you restock. eBay will end a listing that sits at 0 for 180 consecutive days, so clean those up.
The daily routine that keeps the channels in sync
Setup gets you to the same number once. The routine keeps you there. It should take 10 to 15 minutes a day for a small shop.
| When | What to check | Why |
|---|---|---|
| Before opening | Yesterday's counter sales are all in the record | Unrecorded counter sales are the most common cause of drift |
| Before opening | Open orders on Shopify and eBay match units on the shelf | An order for something you cannot find is tomorrow's cancellation |
| Before opening | Count 10 to 20 items against the record | Small daily counts find broken habits early |
| During the day | Every sale rung through the register | The counter is the fastest channel and the easiest to forget |
| After a busy hour | Spot-check that sold items are off eBay and Shopify | Catches a failed update before a second buyer does |
| At close | Items pulled for holds, repairs or photos are marked unavailable | Items off the floor still look sellable online |
| Weekly | Compare each channel's listed stock with the record | Finds listings that drifted without a sale |
For the morning check, compare like with like. In Shopify, "on hand" is all units at a location, while "available" excludes what is committed to orders. If you compare your shelf count with Shopify's available number, unfulfilled orders will look like missing stock.
Worked example: a three-channel shop on a Saturday
Take a shop with 300 items: 220 one-of-one items and 80 multi-quantity items, such as new socks and cleaning kits. 180 items are on Shopify, 90 of the one-of-ones are also on eBay, and everything is on the shop floor.
Illustrative example store.
Those 90 items on all three channels carry the risk. On a busy Saturday the shop sells 25 items at the counter, 8 on Shopify and 4 on eBay. Suppose 6 of the counter sales were items also listed online.
Without a connected register, those 6 items stay listed online until someone updates them. If the owner updates at close, the items are exposed for the whole afternoon. If even one sells online in that time, it is a cancellation, and on eBay a defect.
With the routine above, the owner makes three changes:
- Every counter sale goes through a register that updates the record, so the 6 items come off Shopify and eBay when they sell, not at close.
- 30 low-value one-of-ones come off eBay entirely, cutting the three-channel list from 90 to 60.
- The morning check covers yesterday's 25 counter sales and a 15-item count.
Illustrative example store.
The numbers are made up, but the shape is typical. Most of the risk sits in a small group of items listed everywhere, and most of the fix is how fast a counter sale reaches the other channels.
What to do when an item sells twice anyway
Write this down before you need it, so nobody makes it up with a customer waiting.
| Situation | What to do |
|---|---|
| Sold at the counter, then on eBay | Contact the eBay buyer at once. Explain, apologise, and offer the closest item you actually hold. |
| Sold on Shopify and on eBay | Keep the order that would cost you most to cancel, which is usually the eBay one. |
| Order for an item you cannot find | Mark it unavailable everywhere first, then search. Do not leave it listed while you look. |
| A channel shows stock the record does not | Fix the channel to match the record, then find out why it drifted. |
eBay allows a seller to cancel up to 30 calendar days after being notified of the sale, but the defect applies when the reason is that the item is out of stock. Speed matters more than the deadline: the sooner the buyer hears from you, the better the conversation goes.
When is a spreadsheet enough, and when is it not?
A spreadsheet works as the one record when sales are slow enough that you can update every channel by hand after each sale, and when only one or two people sell. It stops working when:
- Counter sales and online sales happen in the same hour on a regular basis.
- More than one person rings sales and edits listings.
- You sell one-of-one items on more than one channel, so every update has to be about a specific unit.
- You need to know cost and ownership per item, for example for consignment.
Our post on why spreadsheets fail for sneaker resale goes into more detail on that last point, and how to stop overselling one-of-one items covers the oversell rules in depth.
Where StackKnack fits
StackKnack Console is built to be the one record in step 1 for specialty resale and consignment shops. It keeps inventory unit by unit: intake records each unit, its cost and its owner, and each item's location, condition, cost and ownership stays connected to its orders and payouts.
Console currently connects Shopify, eBay and Clover POS, and the three connections do different jobs:
- Shopify: Console syncs listings, stock and orders with your online store.
- eBay: you connect your seller account to manage listings and available stock alongside item records.
- Clover POS: counter sales are recorded and sold units are removed from available inventory.
- ShopifyListings, stock and orders
- eBayListings and available stock
- Clover POSCounter sales
In the Saturday example, the boots sell at a Clover register, the unit comes out of available inventory and stays tied to that sale. What Console does not do: it does not connect other registers or marketplaces today, so if you use a different POS, tell us what you use and we will say plainly whether it fits. The daily routine still matters with Console, too. Software removes the hand updates, but it cannot ring a sale nobody rings.
Selling the same items at the counter, on Shopify and on eBay? Bring us an example of one item's journey from intake to sale, and we will show you how Console keeps it on one record.