How To Calculate Units per Wholesale Order: Step-By-Step For Warehouses

Units per Wholesale Order is the average or actual count of sellable items included in a wholesale order. Calculating it precisely gives warehouses and wholesalers the data to optimize picking strategies, storage allocation, and freight planning. Accurate calculation considers mixed SKUs, conversion between cases and eaches, and the time period or sample set used to compute averages.

Begin with a clear definition of the sellable unit: is it an each, an inner pack, or a case? Converting every line in every order to that sellable unit removes ambiguity and ensures apples-to-apples comparisons across customers and time windows.

Step 1: Define The Sellable Unit

Decide whether to count eaches, inner packs, or cases. For example, a warehouse may choose to measure units in eaches for price-sensitive SKUs and in cases for crate-packed commodities. Record the conversion factors for every SKU (e.g., 12 eaches per case) in your WMS or analytics tool.

Step 2: Collect Order Lines Over A Representative Period

Pull order-level data for a period that reflects normal business activity — typically 30 to 90 days unless seasonality requires longer. Include all wholesale channels and annotate by customer segment so you can compute segmented averages.

Step 3: Convert Order Lines To The Chosen Unit

Convert every order line quantity to the agreed sellable unit using SKU conversion factors. For mixed-SKU orders, convert each line and sum across the order to obtain the total units per order.

Step 4: Calculate The Average And Distributions

Compute the arithmetic mean: total converted units across all orders divided by the number of orders. Also calculate the median and percentile breakdowns (25th, 75th) to understand spread — averages can be skewed by very large orders.

• Mean: Total units / total orders — useful for planning and forecasting.
• Median: Middle value — better when distribution is skewed by outliers.
• Percentiles: Help set practical thresholds (e.g., 75% of orders fall below X units).

Step 5: Segment And Report

Always segment the metric by customer type (chain, independent, distributor), SKU family (fast-moving, slow-moving), and order type (regular replenishment, promotional). This lets you apply different operational rules: larger customers may have case-only requirements, while independents may need mixed-case break packs.

Common Pitfalls And How To Avoid Them

Typical mistakes undermine the usefulness of units per wholesale order: mixing units without converting, using too-short sample periods, and failing to segment by channel. To avoid these problems, keep SKU conversion tables current, exclude non-standard orders (e.g., returns, samples) from baseline calculations, and recompute after major assortment or pricing changes.

• Conversion Errors: Ensure SKU master data includes accurate units-per-case values.
• Sample Bias: Use a representative period and remove promotional spikes when computing a baseline.
• Reporting Lag: Automate daily or weekly recalculation to capture trends proactively.

Using The Result Operationally

Once computed and segmented, the units per wholesale order figure should feed planning and operational systems. Examples:

• Slotting Decisions: Slot items by expected pick unit (case vs each) to reduce touches.
• Wave And Labor Plans: Create pick waves sized to typical order units to stabilize labor requirements.
• Freight Forecasting: Estimate pallet counts and carrier rates using average units and SKU cube information.

Practical Calculation Example

Suppose a 30-day sample contains 600 wholesale orders. After converting all SKUs to eaches, total units shipped equals 360,000 eaches. Mean units per order = 360,000 / 600 = 600 eaches. Median may be 520, with the 75th percentile at 780. Those numbers tell operations to prepare most waves around 500–800 units and identify that a minority of very large orders will need staging and pallet builds.

In short, the Units per Wholesale Order is best treated as a calculated, segmented metric: pick a sellable unit, convert order lines, compute averages plus distribution statistics, and apply the results to slotting, labor, and freight planning. Regular recalculation and careful segmentation make the metric operationally actionable.