JBI Flat File — Product Specifications (v2)
Filename: inv_spec.txt
Delivery path: <your-folder>/inv/v2/inv_spec.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 Product Specifications file provides up to twenty attribute label / attribute value pairs per active product — for example Frame Material / Aluminum, Wheel Size / 29", Brake Type / Hydraulic Disc. These are the structured specs that typically render as the "Specifications" tab on an e-commerce product page.
The attribute labels are not fixed across the file. Each product's category determines which labels apply, so two rows in the same file may have entirely different title_* columns. This is by design — it lets a single file deliver category-appropriate specifications for the whole catalog.
Delivery
| Property | Value |
|---|---|
| Host | ftp.jbi.bike |
| Protocol | FTP |
| Path | <your-folder>/inv/v2/inv_spec.txt |
| Update schedule | 6:05 AM EST, Monday through Friday |
| Coverage | Active products only (status = 'active') |
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 (42 columns)
Identity
| # | Field | Description |
|---|---|---|
| 1 | part_number |
J&B part number |
| 2 | upc_ean |
UPC or EAN barcode |
Specification Pairs
Twenty alternating title / spec columns. For each pair, title_N is the attribute label (e.g. Frame Material) and spec_N is the value for that attribute on this product (e.g. Aluminum).
| # | Field | Description |
|---|---|---|
| 3 | title_1 |
Label for specification 1 |
| 4 | spec_1 |
Value for specification 1 |
| 5 | title_2 |
Label for specification 2 |
| 6 | spec_2 |
Value for specification 2 |
| … | … | (pattern repeats) |
| 41 | title_20 |
Label for specification 20 |
| 42 | spec_20 |
Value for specification 20 |
Notes
- All 20 title/spec pairs appear in every row. Pairs the product's category does not use are emitted as empty strings — there is nothing between the surrounding tabs.
- The same column index can carry a different attribute on different rows. Always pair a value with the
title_Non its own row, not with a label inferred from another product's row. - Rows are sorted ascending by
part_number. - Only active products are included.
Document version: 1.0 — 2026-05-23 For questions or to request FTP access, contact JBI.