The pre-sales representative takes an order for 20 cases. The back-office sees a total of 58 cases in the distribution software. Yet the warehouse preparing the route has only 12 available for this customer. The other cases are at another site or already committed. Before confirming delivery, you need to know which warehouse can prepare the order and when.
Published by FULLLOYAL, this article offers a method for wholesalers and distributors in Algeria working with several warehouses.

Use distribution software to read stock warehouse by warehouse
Total stock helps managers see how much merchandise the business holds. The warehouse keeper needs a more specific figure to know what can be prepared at their site.
For each product, check the quantity physically present in the warehouse, quantities already committed and the condition of the goods. A case awaiting inspection may be inside the building without being available for a new order. Goods travelling from another warehouse must also remain distinct from goods already received.
If you are starting with an Excel file, assign an identifier to each site and use a common product code. Two different descriptions for the same product make reconciliation harder. Use the same counting unit at both sites or clearly record conversions between cases and individual units.
Decide who chooses the warehouse that prepares the order
Assign a usual warehouse to each area or route. This starting point helps the pre-sales representative send the order to the right person. The manager can then choose another site if the usual warehouse is short of goods.
Check three things before deciding. Does the warehouse have the quantities needed for the whole order? Can it prepare the goods before the scheduled departure? Can a delivery driver serve the customer from that site?
Also decide who confirms the quantity and lead time with the customer. If the representative forwards a request to the office, the customer needs to know when confirmation will arrive. Once the decision is made, give the warehouse keeper and driver the same order reference and preparing warehouse.
Fictional example: two warehouses and an order for 20 cases
Consider a fictional food distributor with three pre-sales representatives, two delivery drivers, two warehouse keepers and one back-office employee. A customer usually served by warehouse A requests 20 cases. In the following table, committed quantities are still physically present and have not already been deducted from the opening figures.
| Warehouse | Cases physically present | Already committed | Available for a new order |
|---|---|---|---|
| A, usual warehouse | 18 | 6 | 12 |
| B, other warehouse | 40 | 15 | 25 |
| Total | 58 | 21 | 37 |
Warehouse A is short of 8 cases to fulfil the entire order. The back-office has three options to assess.
- Have warehouse B prepare all 20 cases if its route and delivery timing are suitable.
- Bring 8 cases from B to A and confirm departure after they have been received and checked.
- Offer 12 cases on the first delivery and agree with the customer on what happens to the remaining 8.
In the transfer scenario, B can commit 8 of its 25 available cases. That leaves 17 for other orders. A can prepare the 20 cases once the additional 8 have arrived, provided the initial 12 are still available for this sale.
Follow a warehouse transfer through to receipt
When cases leave a warehouse, keep a common reference for dispatch and receipt. Record the origin site, destination, product and announced quantity. On arrival, the warehouse keeper checks what has been received and reports discrepancies to the office.
For example, if B dispatches 8 cases but A receives only 7, A can prepare 19 cases using the 12 already planned. The eighth case must be accounted for before the office confirms a complete delivery. Counting goods in transit in both warehouses would show availability that the warehouse keeper cannot use.
Before loading, check that the quantity to prepare, departure warehouse and delivery note match the office’s latest decision. If the customer has accepted a partial shipment, also tell the person responsible for follow-up how much remains to be delivered.
Check the scenario in FULLLOYAL
FULLLOYAL provides an Android field app and a web back-office, with stock per warehouse, routes and stock reports. The pre-sales representative takes orders without carrying goods. In driver mode, delivery notes are assigned to each driver.
To prepare for a demonstration, bring the quantities from the table and show who decides which site prepares an order in your business. Ask to check how stock at each warehouse is viewed and how the team would find delivery notes assigned to the driver. Ask how committed quantities and goods in transit would be handled for your organisation.
FAQ
Can we confirm an order if total stock is sufficient?
First check the usable stock at the site preparing the order. If the remaining quantity is elsewhere, confirm the preparation or transfer lead time before making a commitment to the customer.
When is it better to deliver from the other warehouse?
This option may suit you if the other site can prepare the whole order and serve the customer at the required time. Check the other products in the order too, before changing the departure site for a single product.
Can we manage two warehouses with Excel?
You can start with a common product list, a stock position for each site and a shared movement register. Define who updates the data and who confirms quantities to representatives.