Each warehouse publishes its own stock-on-hand file as YAK_SOH_<CODE>.csv. Files are regenerated automatically at the top of every hour, so a fresh download always reflects the most recent snapshot — there is no need to request a manual export.
Files are served over HTTPS at a stable URL, so you can script an hourly pull with curl, PowerShell, or your integration platform of choice. The filenames never change; only the contents update.
Consuming the feed
How the feed works
Hourly refresh
Every file is over-written on the hour. Pull once an hour just after xx:10 to stay in sync; the URL and filename stay constant.
One file per warehouse
Five warehouses in this order: BNE, BRN, MLB, PER, AKL. Each file lists only that warehouse's stock.
Plain CSV, 6 columns
Header row plus one row per product: name, description, UPC, Warehouse stock, range status and quantity on order. Treat UPC as text to keep leading zeros.
Scripted pulls welcome
Files are static HTTPS resources — automate into your system on a schedule.
Reference
File layout
| Column | Type | Description | Example |
|---|---|---|---|
SKU |
Text | Product name / item identifier as held in the ERP. | 8002479 |
Description |
Text | Full product description. | HoldUp EVO 2" |
UPC Code |
Text | Product barcode (UPC/EAN13). Best key for matching to POS and retail systems — treat as text to preserve leading zeros. | 736745024796 |
Warehouse-namedSTOCK |
Integer | Units on hand at this warehouse at the snapshot time. The header carries the warehouse name in the column, so it differs in each file. | 42 |
RANGE STATUS values to confirm |
Text | Whether the item is a current ranged line or obsolete/discontinued — aligns with the Ranged and Obsolete product data feeds. | Ranged |
ON ORDER |
Integer | Units on inbound purchase orders not yet received into the warehouse. | 120 |