MenuStart a projectStart

Online shop

Etsy, Amazon and Shopify order and stock sync

Multichannel order sync brings orders from several marketplaces into one consistent list and keeps a single stock count for each product. Every sale reduces that count and updates the other channels, so the same item isn’t sold twice.

An example of how the studio would build it. No live services are connected.

From three sales channels to one picking list.

  1. Step 01

    Order received

    A new order arrives from Etsy, Amazon Seller Central or Shopify.

  2. Step 02

    Format matched

    Convert it into one shared order format in Airtable, keeping the channel and its original order number.

  3. Step 03

    Products matched

    Map each channel’s listing to a single product record using its SKU.

  4. Step 04

    Stock synced

    Reduce the shared stock count and push the new level to every other channel.

  5. Step 05

    Picking list built

    Produce one picking list for the day’s orders, grouped by product and shelf location.

The result

No overselling, one place to work from.

One stock figure is the source of truth, and every channel is updated from it. If a channel update fails, the team is alerted and the item can be held back until it’s fixed.

Before we connect it.

Where this is useful

Useful for small sellers who list the same products on two or more marketplaces and reconcile stock by hand. A sensible first version brings orders into one Airtable view and produces the picking list, before stock updates are switched on channel by channel.

What we need to connect

  1. 01Seller API access for each channel, such as Etsy, Amazon Seller Central and Shopify.
  2. 02A product list in Airtable with one SKU per item and how it appears on each channel.
  3. 03Your picking process, shelf locations and the safety stock you want to hold back.

What needs careful handling

Channels report orders and accept stock updates at different speeds, so two sales of the last item can land close together. Holding back a small safety buffer on slower channels reduces that risk. Bundles, variants and listings without a shared SKU need careful mapping, and each marketplace has its own API approval process and rate limits.

Questions people ask.

Do I need specialist inventory software instead?

Possibly, especially with many products or several warehouses. A tailored Airtable setup suits sellers who want something simpler that fits how they already work, and it can move to a dedicated system later.

What happens to cancelled or refunded orders?

Cancellations and refunds are read back from each channel and update the same order record. A cancellation before dispatch returns the stock straight away, while a returned item is only added back once someone confirms it can be sold again.

Stock level dropped → Sent on approval
Automation 50

Shopify low-stock reorder automation

Label created → Delivery reminder
Automation 51

Shopify dispatch updates by WhatsApp

All automation examples