How do I manage stock across multiple warehouses and 3PLs?

Running your own warehouse, a 3PL and marketplace warehouses? Here is how to set up locations, transfers and order routing so every unit is accounted for.

Anadoris Digital · · 4 min read

Container terminal from above
Photo: chuttersnap / Unsplash (CC0)

As D2C brands grow, stock spreads out. Some stays in your own godown, some goes to a 3PL in another city for faster delivery, some is sent to marketplace fulfilment centres and some to quick-commerce dark stores. Each location reports stock in its own way, and the total quickly becomes a guess.

Multi-location inventory is mostly a modelling problem. Once every location and every movement is defined clearly in one system, the numbers start to hold.

Model every location explicitly

  • Own warehouse: full control, you record every movement directly.
  • 3PL warehouse: the partner records movements in its system, you receive the data.
  • Marketplace fulfilment centre: stock sellable only on that marketplace.
  • Quick-commerce partner stock: held by the partner, often sold under their purchase order.
  • In-transit: stock that has left one location and not yet been received at another.
  • Quarantine, returns and damaged: separate locations inside each warehouse.

Each location should have its own GST address detail if it is registered as a place of business. Your CA can advise which warehouses need to be added to your GST registration.

Use transfers with an in-transit stage

When stock moves from your warehouse to a 3PL, create a transfer that takes it out of the source and into in-transit. When the 3PL confirms receipt, the transfer completes into the destination. Any shortfall becomes visible immediately as a difference between sent and received.

Inter-state transfers of goods generally need the right tax documents, such as a delivery challan or e-way bill. Your ERP should generate these from the transfer rather than having staff create them separately.

Get reliable data from 3PLs

Ask each 3PL how they share stock, dispatches and returns: through an API, a scheduled file or a portal you log into. Automated feeds are far better than downloading reports by hand. Agree the format, frequency and what happens when a feed fails.

Reconcile the 3PL’s stock report against your system on a fixed schedule. Differences should be raised with the partner quickly, while records are still available.

Route orders to the right location

Order routing decides which warehouse ships each order. Simple rules work for most small brands: ship from the location closest to the customer that has full stock for the order; avoid splitting orders unless necessary; keep marketplace-held stock for that marketplace only.

Multi-location checklist

  • Every stock-holding place exists as a location in the ERP.
  • Transfers use an in-transit stage and generate the required tax documents.
  • Each 3PL sends stock, dispatch and return data automatically.
  • Stock reconciliation with each 3PL runs on a set schedule.
  • Routing rules are written down and set in the system.
  • Reorder levels are set per location, not just in total.
  • Inventory valuation reports can be split by location.

Adding a warehouse in a new state can change your GST obligations. Speak to your CA before moving stock to a new state, not after.

Rebalancing stock between locations

Stock rarely sells evenly across warehouses. One 3PL runs out of a best seller while another holds weeks of cover. Review stock cover per SKU per location every week and move stock before a location runs dry, not after. Transfers take time, so plan them using the same lead-time thinking you use for reorders.

Weigh the cost of a transfer against the cost of shipping orders from a farther warehouse. For slow movers it is often cheaper to leave stock where it is and ship from there. For fast movers, keeping stock close to demand usually saves on delivery time and courier charges.

Returns across locations

Returns do not always come back to the warehouse that shipped them. Decide where each channel’s returns should go, record them into a returns location at that site and process them on a schedule. Without a clear rule, returned units pile up uncounted at whichever warehouse the courier chose.

Reporting across locations

The founder needs two views. The first is total stock by SKU, summed across every location, which drives decisions with the manufacturer. The second is stock by location, which drives transfers and routing. Both should come from the same system and the same data, refreshed at least daily.

Add a third view for stock you cannot sell right now: in-transit, quarantined, damaged and awaiting return processing. This is often a surprisingly large figure in growing brands, and it is invisible when reports show only saleable stock.

Where to start

  • List every place your stock sits today, including stock with marketplaces.
  • Create each as a location and load a counted opening balance for each.
  • Ask every 3PL for an automated data feed and agree a reconciliation routine.
  • Switch all inter-location movements to transfers with in-transit.
  • Set simple routing rules and review split shipments monthly.

Anadoris Digital can connect your ERP to 3PL and marketplace stock feeds so that each location reports into one record.

Related service: ERP Solutions · More on this topic: ERP Solutions articles

Common questions

Should marketplace fulfilment stock be in my ERP?

Yes. It is still your inventory and has value on your books. Hold it as a separate location, update it from the marketplace’s inventory reports and replenishment shipments, and exclude it from stock you show on other channels.

How do I handle stock lost by a 3PL?

Record the shortfall when it is found, usually through a reconciliation or transfer difference, and move it to a claim location. Raise a claim with the 3PL under your contract terms. Write it off only if the claim is rejected or settled.

What is in-transit stock?

In-transit stock has left one location but has not been received at the next. Tracking it separately prevents units from disappearing between warehouses and shows you exactly how much is on the road at any time.

Your next chapter

Let’s build what comes next.

A new website. A better system. A simpler way to work. Tell us where you want to begin.

Discuss your project