JBI Flat File — Inventory Availability (v2)
Filename: inv_loc.txt
Delivery path: <your-folder>/inv/v2/inv_loc.txt
FTP host: ftp.jbi.bike
Version: v2
Format: Tab-delimited UTF-8 text, header row in line 1, LF (\n) line terminator
Overview
The Inventory Availability file is the slim v2 replacement for the legacy inv_loc.txt. It provides current on-hand quantities for every J&B part number, broken down by warehouse location, plus a pre-computed avail_total so you do not have to sum the columns yourself.
Compared to the legacy file, v2 adds a header row, adds the upc_ean column, and orders the warehouse columns numerically by location code so the structure stays predictable as new warehouses are added.
Delivery
| Property | Value |
|---|---|
| Host | ftp.jbi.bike |
| Protocol | FTP |
| Path | <your-folder>/inv/v2/inv_loc.txt |
| Update schedule | Every 15 minutes, on the :15's (e.g. 10:00, 10:15, 10:30, 10:45) |
Many modern browsers no longer support FTP. We recommend a dedicated FTP client such as FileZilla, Cyberduck, or WinSCP.
File Format
- Delimiter: Tab (
\t) - Encoding: UTF-8
- Line terminator:
\n - Header row: Yes — column names are in row 1, in the order listed below
- Quoting: None. Any double-quote (
") or apostrophe (') found in the source data is replaced with a backtick (`) before write.
Field Reference (15 columns)
Identity
| # | Field | Description |
|---|---|---|
| 1 | item_id |
J&B part number |
| 2 | upc_ean |
UPC or EAN barcode |
Totals
| # | Field | Description |
|---|---|---|
| 3 | avail_total |
Total quantity on hand across all warehouses (pre-summed) |
Per-Warehouse Quantities
Each warehouse uses a numeric location code in the header. The state column below is provided for convenience.
| # | Field | State | Warehouse |
|---|---|---|---|
| 4 | avail_101 |
FL | Florida |
| 5 | avail_102 |
NC | North Carolina |
| 6 | avail_103 |
NY | New York |
| 7 | avail_104 |
AL | Alabama |
| 8 | avail_105 |
IN | Indiana |
| 9 | avail_106 |
PA | Pennsylvania |
| 10 | avail_107 |
MN | Minnesota |
| 11 | avail_108 |
TX | Texas |
| 12 | avail_109 |
CO | Colorado |
| 13 | avail_110 |
WA | Washington |
| 14 | avail_111 |
FCL | Florida Closeout |
| 15 | avail_112 |
CA | California |
Notes
- All known warehouse columns appear in every row, even when the on-hand quantity is
0. Locations are not silently omitted. - Quantities reflect the latest snapshot at the time of file generation. They do not account for in-flight orders or reservations placed between snapshots.
- For real-time availability checks against a small set of part numbers, the v3 Inventory API is a better fit than re-downloading this file.
Document version: 1.0 — 2026-05-23 For questions or to request FTP access, contact JBI.