Real-time inventory synchronisation across marketplaces and Shopify
Selling the same catalogue across multiple sales channels increases exposure but also raises the risk of stock conflicts. Real-time inventory synchronisation keeps available stock aligned wherever a customer places an order, reducing errors that stem from delayed updates.
By Sean SaleUpdated
Co-founder of Just Applications Ltd, the team behind Adlixor
The Challenge
Manual stock updates across channels are typically done in batches, relying on spreadsheets, exports, or periodic checks of each admin screen. This lag leads to overselling, cancelled orders, split shipments, and customer service workload when stock is not truly available. Legacy processes also struggle with partial fulfilment, bundles, and returns, causing stock counts to drift over time.
The Solution
A systematic approach centralises inventory as a single source of truth and pushes stock changes to each channel as orders, cancellations, returns, and adjustments occur. Automated rules can reserve stock at checkout, allocate by location, and reconcile discrepancies to keep counts consistent. This reduces overselling and improves fulfilment planning because replenishment decisions are based on current, channel-wide availability.
Step-by-Step Guide
- 1
Create a master product catalogue with unique SKUs and consistent variant definitions for every item you sell.
- 2
Audit and fix SKU mapping so each listing on every channel points to the correct master SKU and variant.
- 3
Define which system holds the authoritative stock figure, then configure all other channels to consume that value.
- 4
Set allocation rules for multiple locations, including how to handle backorders, pre-orders, and safety stock buffers.
- 5
Enable event-based updates for orders, cancellations, refunds, returns to stock, and manual adjustments so stock changes propagate immediately.
- 6
Configure reservation behaviour so stock is held when an order is created and released when an order is cancelled or expires.
- 7
Add exception handling for bundles, multipacks, and kitted items so component stock is decremented correctly.
- 8
Implement reconciliation checks that compare channel stock to the master stock and automatically flag or correct mismatches.
- 9
Run a controlled rollout by syncing a small subset of SKUs first, then expand once accuracy and latency are verified.
Pro Tips
- ✓Use one SKU per sellable unit and avoid reusing SKUs across different products, even if they look similar.
- ✓Maintain a small safety stock to absorb sync latency, carrier delays, and unprocessed returns.
- ✓Treat returns separately from cancellations and only return stock to available once inspected and approved.
- ✓For bundles, ensure the bundle listing does not carry independent stock if it should be derived from component quantities.
- ✓Record stock adjustments with a reason code so you can trace why inventory moved outside normal order flows.
- ✓Schedule a daily reconciliation report even if you use real-time updates, as a backstop against edge cases.
- ✓Avoid manual edits directly in channel interfaces unless they are pushed back into the master inventory immediately.
Frequently Asked Questions
- What does real-time inventory synchronisation mean in practice?
- It means stock changes are propagated as soon as an event occurs, such as an order being created, cancelled, or returned. In practice there can still be small delays due to channel processing and API limits, so monitoring and safeguards are still required.
- Why do stock counts drift between channels over time?
- Drift usually comes from manual edits, unrecorded warehouse adjustments, returns not processed consistently, or bundles not decrementing components correctly. Differences in how channels handle reservations and cancellations can also create mismatches if not standardised.
- How should I handle multiple warehouses or fulfilment locations?
- Use location-level stock and allocate orders using clear rules, such as nearest location, highest stock, or dedicated channel pools. Ensure transfers and stocktakes update the master inventory so channel availability remains accurate.
- What is the best way to prevent overselling during peak periods?
- Combine real-time sync with safety stock and immediate reservation on order creation. Also review channel-specific behaviours around payment pending orders and delayed cancellations so stock is not held unnecessarily.
- How do bundles and multipacks affect inventory synchronisation?
- Bundles require component-level decrementing so selling one bundle reduces stock of each included SKU. If the bundle is tracked as its own SKU without component logic, channels can show availability that the warehouse cannot fulfil.
- Should I sync inventory by quantity available or quantity on hand?
- Sync what is actually available to sell, which is on hand minus reservations, safety stock, and any quarantined or damaged units. This avoids advertising stock that is not practically fulfilable.
Related Guides
Further reading from our blog
Ready to simplify your multichannel operations?
Start your 14-day free trial with Adlixor — no credit card required.