Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Stop Selling Items Online That We Already Sold at the Market?
Problems We Solve

How Do We Stop Selling Items Online That We Already Sold at the Market?

Social enterprises selling online, at markets and wholesale oversell one-off and small-batch stock. We sync stock across every channel in near real time.

Updated 3 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Social enterprises that sell handmade, refurbished or small-batch products online, at markets and events and to wholesale customers oversell because each channel has its own stock figure. We connect your online shop, card reader and wholesale orders to one stock record, so a sale anywhere updates every channel, and one-off items come off the website the moment they sell at a stall.

A one-off chair sold twice

Your social enterprise sells what your trainees make or restore: refurbished furniture, upcycled items, pottery, textiles, woodwork, prints. Many items are one-offs or come in small batches. You sell through a Shopify, Etsy or WooCommerce shop, at weekend markets and craft fairs, at a pop-up in a shopping centre before Christmas, and to a couple of independent shops on wholesale terms.

On Saturday a customer at the market buys the restored oak chair from your stall, paying on the card reader. On Saturday evening someone else buys the same chair on the website. On Monday, a volunteer has to email the online customer to apologise and refund. It is the third time this month. The wholesale customer's order for twenty mugs was confirmed from the spreadsheet, which said thirty in stock, but twelve had gone at the Christmas fair.

Why every channel has its own number

Each sales channel was added when it became useful, and each keeps its own stock count.

ChannelWhere stock is recordedUpdated when
Online shopShop platformWhen someone remembers after an event
Market stall or fairCard reader, cash tinRarely, if ever
Pop-up or partner shopTheir till or a sale-or-return sheetWhen they report back
WholesaleSpreadsheet or emailWhen the order is packed
Workshop outputNowhere, or a whiteboardWhen a batch is finished

For one-off items the margin for error is zero: there is exactly one, and it can only be sold once. For small batches, a few sales in the wrong place are enough to oversell.

What overselling costs

Customers who are refunded after buying something are disappointed, and they are less likely to buy again. Online platforms may also penalise shops that cancel orders.

Volunteers and staff spend time apologising and refunding. The events team takes fewer items to markets than they could, to be safe, and sells less. Wholesale customers lose confidence when orders are short.

One stock record across every channel

What we build connects your channels so they share one stock figure.

  1. Each item or product is recorded once, with its photos, price and quantity, when the workshop finishes it, and published to the online shop from there.
  2. Your card reader at markets and events, such as Square, SumUp or Zettle, uses the same product list, so a sale on the stall reduces stock everywhere, including the website, within minutes.
  3. For one-off items, the moment of sale matters most: a sale on any channel takes the item off the others straight away.
  4. Stock taken to an event can be marked as at the event, so the website can show it as available soon or hide it, depending on your choice.
  5. Wholesale orders are entered against the same stock and reserve items when confirmed, so the same items cannot be sold elsewhere.
  6. Sale-or-return stock at partner shops is recorded as held there, with a simple monthly report from them updating what sold.

We connect through the APIs of the platforms you use, such as Shopify, WooCommerce and Etsy, or through a tool like Make or Zapier where that is enough. If your online platform can already share stock with your card reader, we help you set that up before building anything new.

The next market weekend

On Saturday morning the events team marks the items going to the market. On the website, they show as 'at our market stall today'. At eleven the oak chair sells on the card reader, and by five past eleven it is off the website.

On Monday a wholesale customer orders twenty mugs. The system shows eighteen available after the weekend, so the order is confirmed for eighteen with two to follow from the next batch, and the workshop sees the shortfall on its list.

Is overselling a problem for you?

  • You have sold the same one-off item twice.
  • Stock on the website is updated by hand after events.
  • Wholesale orders have been confirmed from out-of-date figures.
  • You take less to markets than you could, to avoid overselling.
  • Nobody knows exactly what is at partner shops.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Does this work at markets without Wi-Fi?

Card readers usually use mobile data. If a stall has no signal, sales sync when the connection returns, which is why marking stock as at an event helps.

Which platforms can you connect?

Common ones include Shopify, WooCommerce and Etsy online, and Square, SumUp and Zettle in person. We check yours before promising anything.

Can it cope with one-off items?

Yes. One-off items are the main reason for doing this, and a sale anywhere removes them everywhere.

What do we need to provide?

Access to your online shop, card reader account and wholesale order records, and how items move from workshop to sale.

Keep reading

More on Problems We Solve

Start here

Tell us how your social enterprise's trading side runs

Describe what you sell or make, where you sell it, who does the work and which part of the admin eats the most time. We will tell you what we would build and what we would leave alone, and if an off-the-shelf tool already does the job, we will point you to it.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →