Buyer Onboarding
HPD Purchasing Intelligence — Column Reference Guide
Describes every column available in the HPD Purchasing web tool. Use it to understand what each number means and how it affects your ordering decisions.
Always Visible
2 columns| Column | Description |
|---|---|
| SKU | The Atrex Stockcode for the item. Click the link to open the item's Power BI report for deeper sales history. Hover over the link to see the image on hpd.ca. |
| To Order | The recommended order quantity — the number to place on your purchase order. Three rules: (1) at or above Line Point → 0; (2) between Order Point and Line Point → one Order Qty; (3) below Order Point → fill to Line Point (keep adding Order Qty until Available + On Order reaches it). Highlighted in red when action is needed. |
Product Info
6 columns| Column | Description |
|---|---|
| Description | The product description from Atrex. |
| Category | The product category from Atrex (e.g., RC Cars, Batteries, Accessories). |
| UPC | The product's Universal Product Code barcode number from Atrex. Hidden by default. |
| Order Unit | How the item is sold by the vendor — e.g., EA (each), 6* (must order in multiples of 6). Hidden by default. |
| Location | Warehouse bin/shelf location. Hidden by default. |
| Curr | The currency for this item's vendor cost — typically CAD or USD. The exchange rate for this currency is applied when converting Vendor Cost to CAD for EOQ calculations. |
Inventory Position
3 columns| Column | Description |
|---|---|
| Avail | Current quantity available in Atrex (on-hand minus committed). Can be negative if items are backordered. |
| On Order | Quantity already on order from the preferred/standard vendor — not yet received. |
| Factory On Ord | Quantity on order directly from the manufacturer (factory order), separate from your regular distributor order. |
Sales History
6 columns| Column | Description |
|---|---|
| 30d | Units sold in the last 30 days. This is the primary demand signal used for ordering calculations. |
| 90d | Units sold in the last 90 days. |
| 6 Mo | Units sold in the last 6 months. |
| Yr Usage | Units sold in the last 12 months. Used for EOQ calculations and the yearly supply cap. |
| Dealers | Number of distinct dealers who purchased this item in the last 12 months — a useful indicator of how broadly an item is carried. |
| Invoices | Number of invoices this item appeared on in the last 12 months. Higher numbers suggest more frequent, steady demand vs. bulk single purchases. |
Ordering Calculations
7 columns| Column | Description |
|---|---|
| Lead Mo | Lead time in months — how long after placing an order until it arrives. Used to calculate Order Point. |
| Lead Source | Where the lead time figure came from — SKU History (historical data for this item), Vendor Average, or a system default. |
| Ord Pt | Order Point — the inventory level that triggers a reorder. Calculated as monthly demand × (lead time + review cycle), plus a safety buffer for high-velocity A items. When Available + On Order falls below this, the system recommends ordering. |
| Line Pt | Line Point — the target stocking level the system aims to reach when placing an order. To Order is always sized to bring Available + On Order up to (but not beyond) Line Point. |
| Ord Qty | Order Quantity (EOQ) — the Economic Order Quantity: the mathematically optimal number of units to order, balancing ordering costs against carrying costs. Calculated using Vendor Cost (converted to CAD), annual usage, replenishment cost, and carrying cost %. When between Ord Pt and Line Pt, To Order = one Ord Qty. |
| Surplus | Units you have beyond Line Point + Order Qty. Positive = overstocked; these items show 0 in To Order. Highlighted in green. |
| ABC | ABC classification — A = high-velocity (top ~20% of sales), B = medium, C = slow movers. A items receive extra safety stock. Hidden by default. |
Flags & Status
5 columns| Column | Description |
|---|---|
| Freeze | Reason why normal ordering rules are suspended. The date shown is when the freeze ends — always the last day of the month, one year after the triggering event (e.g. a sale ending 5/15/2026 → freeze ends 6/30/2027). Other types: Do Not Order; Order by Email (must contact vendor directly). Frozen items use Min/Target Qty logic instead of EOQ. |
| Special Ord | Marks items ordered on-demand to fill specific customer backorders only — not stocked regularly. Type Yes to enable; clear to disable. When active, To Order = units needed to cover current backorders. |
| >1 Mo Supply | Shows YES when Available + On Order covers more than one month of demand (based on 30-day sales). A quick flag to spot items that are already well-covered. Hidden by default. |
| Min Qty | Minimum quantity to keep on hand at all times (used in frozen item ordering logic). Hidden by default. |
| Target Qty | For frozen items, the order-up-to quantity when stock falls below Min Qty. Hidden by default. |
Vendor-Specific
shown when that vendor is selected| Column | Description |
|---|---|
| Atrex Cost | Your cost for this item as recorded in Atrex. Shown for reference — Vendor Cost is what drives EOQ calculations. |
| Vendor Cost | Current cost from the selected vendor's price list, in the vendor's currency. Used for EOQ (converted to CAD via exchange rate). Sale prices flow through automatically — lower price → higher Order Qty recommendation. Hidden by default. |
| TRA Stock | Traxxas warehouse availability — In Stock or Out of Stock. Only visible when Traxxas (TRA/TRATW) is selected. |
| HH Stock | Horizon Hobby warehouse availability. Only visible when HH (HHUSA/HHCN) is selected. |
| HH ETA | Horizon Hobby estimated restock date for out-of-stock items. Only visible when HH is selected. |
Opportunity Buy Columns
only appear when an Opp Buy is loaded| Column | Description |
|---|---|
| Sale Price | Promotional vendor cost during the opportunity buy (in CAD). Used in EOQ calculations instead of regular Vendor Cost, so the lower price produces a higher Order Qty recommendation. |
| ETA | Estimated arrival date for this opportunity buy shipment. Used to calculate a temporary lead time for Order Point. |
| Next Order Date | Next date we expect pricing like this to be available again. Informational — helps decide whether to buy heavier now or wait. |
Opportunity Buy — CSV Input Format
columns in the CSV file you load| Column | Description |
|---|---|
| Code | Required The Atrex Stockcode for the item. |
| Price | Required The vendor cost in the vendor's currency (same as regular Vendor Cost). The tool applies the exchange rate automatically. |
| Min Qty | Optional Minimum order quantity required by the vendor for this promotion. |
| ETA | Optional Estimated arrival date — used to set a temporary lead time for this order. |
| Next Order Date | Optional Next date we expect pricing like this to be available again. |
Tips for New Buyers
To Order is your action column.
Sort by it descending to see what needs attention first.
Frozen items bypass EOQ logic.
Items with a Freeze reason use Min/Target Qty rules — review these manually.
Zero sales ≠ no supply.
Brand-new or very slow items with existing stock will show YES in >1 Mo Supply.
Hidden columns are still useful.
Use the Columns button (toolbar) to show/hide UPC, ABC, Min Qty, Target Qty, and more.
Power BI drill-down.
Click any SKU link to open the item's full sales history and trend report in Power BI.
Sale prices raise Order Qty.
When a vendor has a sale, the lower Vendor Cost flows through EOQ — expect higher order quantity recommendations.