← BlogStackKnack Team

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.

How one pair of boots becomes two orders
  1. Saturday, 2:05 pmBoots sell at the counter
  2. Nobody updates the listingsShopify and eBay still show 1 in stock
  3. Saturday, 3:10 pmSame boots sell on eBay
  4. 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.

1
Choose the one record that decides availability

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.

2
Give every item one ID that is the same everywhere

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.

3
Count everything once and load the starting numbers

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.

4
Connect every channel to the record

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?

5
Decide what goes on which channel

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.

6
Make every counter sale go through the system

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.

7
Turn on eBay's out-of-stock option for multi-quantity listings

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.

WhenWhat to checkWhy
Before openingYesterday's counter sales are all in the recordUnrecorded counter sales are the most common cause of drift
Before openingOpen orders on Shopify and eBay match units on the shelfAn order for something you cannot find is tomorrow's cancellation
Before openingCount 10 to 20 items against the recordSmall daily counts find broken habits early
During the dayEvery sale rung through the registerThe counter is the fastest channel and the easiest to forget
After a busy hourSpot-check that sold items are off eBay and ShopifyCatches a failed update before a second buyer does
At closeItems pulled for holds, repairs or photos are marked unavailableItems off the floor still look sellable online
WeeklyCompare each channel's listed stock with the recordFinds 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.

Where the shop's 300 items are listed
Shop floor300 items
Shopify180 items
eBay90 items

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:

  1. 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.
  2. 30 low-value one-of-ones come off eBay entirely, cutting the three-channel list from 90 to 60.
  3. The morning check covers yesterday's 25 counter sales and a 15-item count.
Items exposed to a double sale after a counter sale
Before: updated at closeStill listed online after selling 6Removed when sold 0
After: connected registerStill listed online after selling 0Removed when sold 6

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.

SituationWhat to do
Sold at the counter, then on eBayContact the eBay buyer at once. Explain, apologise, and offer the closest item you actually hold.
Sold on Shopify and on eBayKeep the order that would cost you most to cancel, which is usually the eBay one.
Order for an item you cannot findMark it unavailable everywhere first, then search. Do not leave it listed while you look.
A channel shows stock the record does notFix 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.
Shopify, eBay and the counter working from one record
  • ShopifyListings, stock and orders
  • eBayListings and available stock
  • Clover POSCounter sales
One item record in ConsoleLocation, condition, cost, owner and availability

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.

Commerce teams set the direction.
StackKnack carries the work through.

Walk through your inventory, decisions or supplier workflow with us. We’ll show you the relevant product, its current connections and what getting started involves.