The Multi-Channel Inventory Problem
Adding a second or third sales channel feels like a straightforward growth move. In practice, it creates an inventory coordination problem that trips up most brands within their first 90 days of multi-channel selling.
The fundamental issue: every channel draws from the same physical inventory, but each channel maintains its own inventory count. If you sell 1 unit on Amazon, Shopify doesn't know β unless you have a sync system in place.
The consequences of poor sync:
- Overselling: you sell the last unit on Amazon, then a Shopify order arrives for the same item. You can't fulfill it. You get a cancellation, a negative review, and a platform defect.
- Stockouts: you have inventory, but different channels show different counts β some showing zero when units remain, causing you to lose sales.
- Ghost inventory: FBA returns or damaged units appear as available in Seller Central but can't be shipped.
The Three Layers of Multi-Channel Inventory
Layer 1: Physical inventory
Your actual stock β in your warehouse, at a 3PL, or in Amazon FBA/Walmart WFS. This is the ground truth.
Layer 2: Channel inventory levels
What each marketplace (Amazon, Walmart, eBay) and your own store (Shopify) reports as available to sell. These must stay synced with physical inventory minus a buffer.
Layer 3: Committed inventory
Units that have been ordered but not yet shipped. Committed inventory must be subtracted from available-to-promise quantities to avoid double-selling.
Buffer Stock Strategy
The most reliable simple approach: reserve a buffer stock quantity that you never list on any channel.
How it works: If you have 50 units physically, list only 45 on all channels combined. The 5-unit buffer absorbs sync delays and prevents overselling during peak demand or when channels don't sync in real time.
Buffer size by channel count:
- 1 channel: buffer of 2β3 units is sufficient
- 2 channels: buffer of 5β8% of average weekly sales
- 3+ channels: buffer of 10β15% of average weekly sales, reviewed weekly
The downside of buffers: you leave potential sales on the table when stock is low. The upside: you prevent the operational chaos of oversell situations.
Sync Architecture Options
Manual sync (under 50 SKUs, 1β2 channels)
Update each channel inventory manually after each day's orders. Viable for very small operations with predictable, low order volumes. Breaks down above 20 orders/day.
Process:
- End of day: download orders from all channels
- Tally units sold by SKU
- Reduce inventory count in each channel by units sold
Time required: 30β60 minutes/day.
Spreadsheet-based sync (50β200 SKUs, 2 channels)
Maintain a master inventory spreadsheet. Pull orders from each channel into a common sheet. Use formulas to calculate remaining stock and flag reorder points.
Tools: Google Sheets + Zapier or Make (formerly Integromat) for automated order imports.
Suitable for brands doing under Β£50K/month with stable SKU counts.
Inventory management software (200+ SKUs or 3+ channels)
| Tool | Best for | Starting price |
|---|---|---|
| Linnworks | UK-based, excellent multi-channel support | From Β£449/month |
| SkuVault | US-focused, WMS + inventory management | From $359/month |
| Skubana (now Extensiv) | High-volume, enterprise-level sync | From $500/month |
| Veeqo (free for Shopify/Amazon) | Small brands, Amazon+Shopify sync | Free |
| ChannelAdvisor | Large-scale, feeds management | Enterprise pricing |
Most tools sync inventory in 15-minute intervals. For high-volume flash sales or Prime Day-style events, even 15-minute sync can cause overselling β reduce channel inventory to a lower buffer ahead of high-traffic events.
FBA-Specific Inventory Challenges
Stranded inventory
Units at FBA that are unavailable for sale due to a listing issue (suppressed listing, missing info). These show in your FBA inventory count but can't be ordered.
Fix: Weekly review of Stranded Inventory report in Seller Central. Fix the listing issue and the units become available within 24β48 hours.
Reserved inventory
Units at FBA that are in transit between fulfilment centres, being inspected, or processing returns. Amazon shows these as "Reserved β FC Processing" or "Reserved β Customer Order".
Key insight: Reserved FC Processing units are unavailable for sale but still counted in your FBA inventory total. Subtract this from your available-to-promise calculation.
Unfulfillable inventory
Damaged, expired, or customer-returned units that FBA has deemed unsellable. These don't count towards your available inventory but do incur storage fees.
Fix: Create a removal order for unfulfillable inventory quarterly. Don't let damaged stock accumulate at FBA β the storage fees cost more than the product value over time.
Reorder Point Calculation
The most important number in inventory management is your reorder point β the stock level at which you need to place a purchase order to avoid a stockout.
Formula:
Reorder Point = (Average daily sales Γ Lead time in days) + Safety stock
Safety stock = (Maximum daily sales - Average daily sales) Γ Lead time
Example:
Average daily sales: 5 units
Lead time: 14 days
Maximum daily sales: 9 units
Safety stock = (9 - 5) Γ 14 = 56 units
Reorder point = (5 Γ 14) + 56 = 70 + 56 = 126 units
When your inventory drops below 126 units, place the next purchase order.
Building an Inventory Dashboard
A simple weekly inventory report should show:
- Units on hand by SKU (physical)
- Units available to sell by channel
- Units reserved/committed
- Days of cover: units on hand Γ· average daily sales
- Reorder flag: SKUs below reorder point
A SKU with 10 days of cover and a 14-day supplier lead time is already at risk of a stockout. The report surfaces this before it becomes a lost sales event.
eData4You provides multi-channel inventory management as part of our marketplace management and virtual assistant services β daily reconciliation, reorder reporting, and FBA audit. See marketplace services β