HOW-TO · INVENTORY

How to reconcile inventory across sales channels

Build a weekly reconciliation workflow that compares marketplace stock, warehouse stock, reserved units, returns and inbound stock before small discrepancies become overselling. The practical target feature is ChannelDock's Stock Reconciliation.

Compare
system vs. physical
Explain
root cause per SKU
Correct
once, then sync
Reconciliation queue18 checks
SKU-BAG-42-3 unitsreturns gap
SKU-CABLE-7+12 unitsinbound timing
SKU-KIT-3-1 bundlecomponent drift
Count → investigate → approve → sync channels

Inventory reconciliation matters most when one SKU is sold through Shopify, bol.com, Amazon, eBay, a B2B portal and a physical warehouse at the same time.

3-5 channelsenough to make manual checks fragile
10-15 minutescommon sync-delay window sellers report
1 SKU truthwarehouse stock must lead channel stock
Weekly cadencecatch drift before peak-day oversells

Before you start: reconciliation prerequisites

Do not start by changing numbers. Start by making sure every team is looking at the same definition of available stock.

Connected channels

Connect Shopify, WooCommerce, bol.com, Amazon, Zalando, eBay, Kaufland or other channels so you can compare every published quantity against one operational source.

Warehouse count method

Decide whether you use a focused cycle count, a full bin count or a count only for flagged SKUs. Pair this page with Cycle Counting for larger catalogs.

Adjustment authority

Choose who may approve stock corrections. Reconciliation is an accounting and customer-promise process, not just a warehouse housekeeping task.

Tip: reconcile your top-selling and recently returned SKUs first. Returns, transfers, bundles and delayed marketplace sync are the places where stock drift usually hides.

Step-by-step: reconcile stock across marketplaces

Use this workflow when Shopify, Amazon, bol.com, your warehouse system and accounting no longer agree.

Freeze the SKU scope for the check

Pick the exact SKUs, variants, bundles and warehouse locations you will reconcile. Freeze the report timestamp so new orders, returns or inbound deliveries do not move the target while you count.

Common mistake: comparing a 09:00 warehouse count with a 10:30 marketplace export after dozens of orders have already changed stock.

Pull the operational stock record

Export the stock quantity from your central inventory system, including available stock, reserved stock, inbound stock and stock allocated to bundles. In ChannelDock, use Stock Reconciliation as the working view.

Common mistake: reconciling only the visible channel quantity and ignoring reserved units for open orders.

Count the physical warehouse quantity

Count sellable units in the actual pick location. Separate damaged stock, quarantine stock, customer returns waiting for inspection and stock that arrived but has not been booked in.

Common mistake: treating returned products as sellable before quality control is complete.

Compare every channel-facing quantity

Check the quantity published to each sales channel. Marketplaces may show slightly different numbers because of safety buffers, update frequency, API delays or channel-specific stock rules.

Common mistake: assuming “real-time” means instant. Several seller discussions mention sync windows of 10-15 minutes during busy periods.

Classify the discrepancy before correcting it

Label the root cause: missed pick, duplicate adjustment, bundle component drift, delayed return, FBA/LVB transfer, supplier receiving error, manual channel edit or sync delay. The label prevents the same issue next week.

Common mistake: posting a correction without explaining why the mismatch happened.

Approve one correction in the source of truth

Make the stock correction once in the system that owns inventory. Then let connected channels receive the corrected quantity through stock-level sync.

Common mistake: fixing Shopify manually, then fixing Amazon separately, then losing the audit trail.

Verify the sync and document the audit trail

After the correction, check that every channel updated as expected. Save the reason, approver, timestamp and before/after quantity so finance, customer support and warehouse leads can trust the number.

Common mistake: closing the discrepancy before the marketplace quantity has actually updated.

The reconciliation rule: count, explain, then sync

The best reconciliation workflow does not just make the number match. It makes the next mismatch less likely by recording the cause.

For multichannel sellers, a stock correction without a reason is just a temporary truce between systems.

System stock
Physical count
Root cause
Channel sync
Available = physical sellable stock − reservations − buffers + approved inbound

Common reconciliation pitfalls

  • Correcting channel quantities directly instead of correcting the central inventory record.
  • Counting returned stock as available before the product is inspected and put back into a sellable location.
  • Ignoring bundles, kits and product components that sell as multiple channel SKUs.
  • Missing transfer stock between warehouses, FBA/LVB and your own location.
  • Letting support promise replacement shipments while the warehouse is still investigating the discrepancy.

Manual reconciliation vs. ChannelDock Stock Reconciliation

A spreadsheet can compare two numbers. Multichannel reconciliation needs context: orders, reservations, returns, bundles, warehouses and marketplace sync.

Without ChannelDock

  • Teams export Shopify, Amazon, bol.com and warehouse stock into separate files.
  • Corrections are made in multiple systems, often without one audit trail.
  • Discrepancies return because the root cause is not tagged.

With ChannelDock

  • Stock checks sit next to connected orders, reservations and channel quantities.
  • Corrections can be approved once and then reflected through stock-level sync.
  • Teams keep a cleaner trail for finance, support and warehouse leads.

Explore ChannelDock Stock Reconciliation ->

Inventory reconciliation FAQ

Inventory reconciliation is the process of comparing recorded inventory with physical stock and channel-facing quantities, then investigating and correcting any discrepancies with an audit trail.

Fast-moving SKUs should be checked weekly or after major campaign days. Slow movers can be checked on a rotating cycle, but any SKU with returns, transfers or bundle components deserves faster review.

Common causes include sync delays, manual channel edits, open order reservations, returns not yet inspected, transfer stock, missed picks, damaged stock and bundle component changes.

No. Correct stock once in the inventory source of truth and let the connected channels update from there. Editing each marketplace separately creates new drift and weakens the audit trail.

Reconciliation finds the stock drift that makes marketplaces publish too much availability. Pair it with real-time stock sync and safety buffers so corrections reach every channel quickly.

ChannelDock Stock Reconciliation helps sellers compare quantities, investigate discrepancies and keep stock corrections connected to the wider inventory workflow.

Related inventory guides and features

Reconciliation becomes stronger when it is connected to stock sync, cycle counts and replenishment controls.

Sync inventory across channels

Keep channel-facing quantities aligned with warehouse stock.

Read how-to

Set reorder points

Use demand, lead time and safety stock to buy earlier.

Read how-to

Cycle count stock

Count focused SKU groups without shutting down orders.

View feature

Inventory hub

Explore all ChannelDock inventory workflows.

View overview

Make stock corrections safer across every channel

Use ChannelDock Stock Reconciliation to investigate discrepancies once and keep your marketplaces, warehouse and support team aligned.