How do you sync marketplace orders into one order queue?

Updated:

Marketplace order sync pulls each new order from Amazon, Flipkart, Myntra and your own store into one order system, maps every channel SKU to your own catalogue, reserves stock against the order, and sends the updated stock back to every channel. Your warehouse then picks and packs from one queue instead of several seller portals.

Order sync vs inventory sync

Order sync and inventory sync run in opposite directions. Order sync brings orders in: from each marketplace and your store into one order queue. Inventory sync sends stock out: the sellable count from your warehouse back to each channel. A brand needs both, because an order that comes in late, or a stock count that goes out late, can lead to the same oversold order. For the stock side, see inventory sync across channels.

How to set up marketplace order sync, step by step

  1. List every channel and seller account. Include each marketplace location you ship from, your own store and any quick-commerce purchase orders, so that no order source is left outside the queue.
  2. Build one SKU master and map every listing to it. Each marketplace listing, store variant and combo pack points to one internal SKU. Combo packs map to their component SKUs.
  3. Map each marketplace location to the warehouse that ships it. An order then lands in the queue of the warehouse that will ship it, not in a shared inbox.
  4. Reserve stock when the order is confirmed, not when it is picked. Stock that waits until picking to be reserved can be sold a second time on another channel.
  5. Decide how much stock each channel sees. Show the full sellable count, or hold some back as safety stock for a channel, before stock is sent back out.
  6. Release orders to the warehouse in dispatch-deadline order. Sort the queue by each channel's dispatch deadline rather than by the time the order arrived. See marketplace dispatch deadlines.
  7. Keep an exception queue with an owner. Unmapped SKUs, orders cancelled before picking, orders on hold and orders with no stock go to a named queue that someone clears every shift.
  8. Check each channel every day. Compare the day's orders in your order system with each channel's own order report, and chase any order that appears in one but not the other.

What usually goes wrong with marketplace order sync

ProblemUsual causeWhat to check
An order is missing from the queueThe channel connection stopped, its authorisation expired, or the order came from a seller account that was never connectedThat every seller account is connected, and the daily order-count check in step 8
The same order appears twiceThe same channel order was imported twice after a retryThat the channel's own order ID is used as the key, so a repeat import is ignored
An order is stuck and never reaches the warehouseIts SKU is not mapped to your catalogueThe exception queue for unmapped SKUs, cleared before the dispatch deadline
An order is sold twice on sale daysStock was reserved late, or the stock sent to channels did not include the orders just takenThat stock is reserved at confirmation (step 4) and how much each channel sees (step 5)
A cancelled order is still packedThe cancellation reached the warehouse after picking startedThat a cancelled or held order cannot move to packing or dispatch
The order ships from the wrong warehouseThe marketplace location is mapped to the wrong facilityThe location-to-warehouse map in step 3, and order allocation rules

How Fretron CommerceOS fits

Marketplace orders and stock

Fretron CommerceOS is order, warehouse and shipping software for Indian D2C, retail and omnichannel consumer brands. Amazon, Flipkart and Shopify run in production, with orders pulled and inventory published back automatically. It's designed to reduce overselling. Each channel's SKUs and locations are mapped to your catalogue and warehouses; an unmapped SKU doesn't come in until you map it.

Your own store and Myntra

Fretron CommerceOS connects to your Shopify or WooCommerce store, with orders pulled and inventory published back automatically. It's designed to reduce overselling. Fretron CommerceOS has a live Myntra (PPMP) connector for orders, inventory push, ready-to-dispatch labels and returns.

What each channel sees

In Fretron CommerceOS, the moment one channel confirms an order, every other channel sees the new available-to-sell count. In Fretron CommerceOS, you can hold back safety stock for each channel or publish only a set percentage of your stock to it. A stock hold takes the held stock out of what's offered for sale.

From order to warehouse

Each marketplace location is mapped to the facility that fulfils it. Stock is reserved against the order when it is confirmed and allocated. An order on hold can't be picked, packed, labelled or dispatched until it is released. Order, allocation, pick and dispatch share one record — no hand-off integration to break.

Fretron CommerceOS · order management software · warehouse management software · marketplace integration

Frequently asked questions

What is marketplace order sync?
Marketplace order sync is the process of pulling new orders from each marketplace and your own online store into one order system, so the warehouse works from one queue. It goes with inventory sync, which sends the updated stock count back to each channel.
What is the difference between order sync and inventory sync?
Order sync brings orders in from each channel to your order system. Inventory sync sends your sellable stock count out from your warehouse to each channel. Both are needed: a late order or a late stock count can each lead to an order you cannot ship.
How do you stop two marketplaces selling the same last unit?
Overselling happens when two channels sell the same last unit because one of them still shows stock that has already been sold elsewhere. The fix is one stock pool for every channel, with each sale reducing the available quantity on the other channels, plus a safety buffer on the channels where a cancellation costs the most. In Fretron CommerceOS, when stock changes, the available quantity is recalculated and pushed to each connected channel automatically, in batches within each channel's limits. It's designed to reduce overselling.
Why do marketplace orders go missing or appear twice?
Orders usually go missing because a channel connection stopped, its authorisation expired or a seller account was never connected. They appear twice when the same order is imported again after a retry. Use each channel's own order ID as the key, and compare order counts with each channel's report every day.
What happens to an order whose SKU isn't mapped?
It cannot be allocated or picked until the SKU is mapped to your catalogue, so it should go to an exception queue that someone clears before the dispatch deadline. In Fretron CommerceOS, each channel's SKUs and locations are mapped to your catalogue and warehouses; an unmapped SKU doesn't come in until you map it.
Which marketplaces does Fretron CommerceOS sync orders from?
Amazon, Flipkart and Shopify run in production, with orders pulled and inventory published back automatically. It's designed to reduce overselling. Fretron CommerceOS has a live Myntra (PPMP) connector for orders, inventory push, ready-to-dispatch labels and returns. For any other marketplace, ask for its current connector status.
When do my other channels see the new stock count after an order?
In Fretron CommerceOS, the moment one channel confirms an order, every other channel sees the new available-to-sell count.
Can I hold back stock for one channel?
Yes. In Fretron CommerceOS, you can hold back safety stock for each channel or publish only a set percentage of your stock to it. Hold stock back for any channel you cannot afford to oversell on.
How do I stop a cancelled or held order from being shipped?
Put the order on hold as soon as the cancellation or query arrives, and make sure held orders cannot move to packing. In Fretron CommerceOS, an order on hold can't be picked, packed, labelled or dispatched until it is released.