How To Combine Wholesale Preorders And DTC Demand In One Forecast

A department store sends a purchase order for 300 navy sweatshirts, and the sales team celebrates. At the brand’s Monday inventory meeting, somebody adds 300 units to the wholesale forecast. Somebody else reserves 300 in the warehouse. By lunch the web team has lost access to stock and the buyer is on the phone asking a factory for more, all on the strength of an order the sales team had been telling everyone to expect for six weeks.
The order is real. So is the risk of buying it twice. A brand that sells both wholesale and direct to consumer (DTC) has two routes to market and at least three views of the future. The wholesale team has commitments from named accounts. Ecommerce has a stream of individual purchases, most of which will arrive without notice. Operations has one finite supply of garments, down to color and size. Combining those views starts with a surprisingly consequential question: what did the forecast already allow for?
Follow A Single Style Through The Order Book
Take a hypothetical brand planning the next four weeks of a navy sweatshirt. For the example, all quantities refer to the same size, destination warehouse and shipping window, and returns and safety stock are ignored. The wholesale forecast is 500 units, including the expected department-store order, and the DTC forecast is another 360. Opening sellable inventory is 720 units, with a confirmed receipt of 100 due before either channel needs it. The brand expects to need 860 units and has a route to 820, leaving a current exposure of 40 units.
When the 300-unit wholesale order arrives, it takes the place of 300 expected units. The wholesale plan now contains 300 booked and 200 still anticipated. Add the 360 DTC units and the combined plan still calls for 860. Something meaningful has changed nevertheless. Three hundred of those units now have a customer, a ship window and a specific size requirement attached, and the team knows something about the cost of disappointing this account that it could only guess at on Friday.
Once it reserves those 300, the warehouse might show just 420 units free. Starting the plan from that figure works too. Add the inbound 100 and compare the resulting 520 with the remaining 200 wholesale units and 360 DTC units: the gap is still 40. Two perfectly good views of the business produce the same answer. Compare those 520 free units against all 860 planned units, however, and the apparent shortage jumps to 340. A buyer could spend an impressive amount of money fixing that bookkeeping error.
Give Every Wholesale Order Somewhere Specific to Land
Forecast consumption is the practice of replacing an expected sale with a booked order that represents the same demand. Its usefulness depends on the match. An order from a national chain for a September floor set cannot automatically use up anticipated August reorders from independent shops, and an unexpected order for a special color cannot fulfill a forecast for black. At the opposite extreme, requiring a named-account forecast for every small boutique produces a book so thinly divided that genuine replenishment looks like a surprise every week.
A workable middle ground is to plan large accounts individually and pool smaller accounts with similar ordering patterns. When matching bookings to forecasts, retain the SKU, ship window and demand type. A first seasonal commitment comes out of the expected opening orders; a later repeat purchase draws on the allowance for reorders. If a preorder already fills an account’s entire allowance and its buyer adds another door, the extra units have earned their place in the plan. An unexplained excess should reach the account owner before it becomes a factory instruction.

Dates deserve as much attention as quantities. A retailer can place an order in June for delivery in September and pay in October. June describes when the order became visible. September usually matters most to the inventory planner, along with any earlier dates needed for picking and transit. October belongs in a cash view. Stacking bookings by order-entry month alongside DTC units by shipment month creates a peak the warehouse will never see. Keep the original dates, and give the planning view one explicit calendar convention.
Read A Wholesale Partner’s Sell-Through As Information
Suppose that account later reports 180 sweatshirt sales to shoppers. Its point-of-sale feed can be invaluable, showing the brand how quickly the retailer is moving through its delivery and which sizes may soon warrant a reorder. But the brand has already supplied those sweatshirts. Adding the 180 consumer transactions to the brand’s shipments overstates the units leaving its own network. Read the feed as evidence about the next order, taking into account what the account still has on hand, when it can reorder and how much of the season remains.
DTC has its own version of the problem. An ecommerce order may ship in two parcels, or a store may dispatch a unit on the website’s behalf. A planner interested in customer demand needs a consistent originating channel, while a planner positioning stock needs the fulfillment location. Both fields belong on the record. Without them, a ship-from-store program can make store demand look newly buoyant and web demand look soft just as customers are moving online. A multichannel inventory plan is easier to challenge when a merchant can trace a surprising number back to the channel that sold the unit and the node that supplied it.
The Inventory Meeting That Earns Its Place
Return to the 40-unit shortfall. First, find out when it bites. Suppose the warehouse has set aside all 300 units for the department store and the 100-unit receipt slips a week. The account’s order is covered. Web shoppers could still see a sold-out size before the truck arrives, even if the receipt lands within the four-week period and the total shortfall stays at 40. If stock is ample for the first three weeks, the team may have time to move units from another node or negotiate dates on the next wholesale reorder. If the shortage is concentrated in one size, buying a full assortment pack to secure those units could leave the brand with expensive leftovers.
The useful discussion is about the next commitment: what portion of the remaining wholesale demand has a credible buyer and enough time to convert, what the web customer would see if the brand protected every expected reorder, and which promise expires first. Show the booked units, the open forecast, the free stock and the next reliable receipt side by side. Let sales explain changes to the order book and ecommerce explain changes in the pace of demand, then record the allocation choice separately. A decision to reserve stock for a valued account is a legitimate commercial judgment. Hidden inside a higher demand forecast, that judgment becomes almost impossible to revisit.
By the following meeting, a buyer should be able to point to the fate of the original 300 sweatshirts. Perhaps they shipped as promised. Perhaps the account moved its date and opened a short selling window online. Either way, the order appears once in the history, its remaining commitment is visible, and any new purchase has to justify itself on demand that still lies ahead.