JBI Flat File — Product Categories & Marketing Bullets (v2)
Filename: inv_bullets.txt
Delivery path: <your-folder>/inv/v2/inv_bullets.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 Bullets file pairs each active SKU with its four-level category placement and its marketing copy — twenty model-level bullets (shared across every SKU in the model group) and twenty SKU-level bullets (specific to the individual variant). This is the file that powers product detail pages, feature lists, and category navigation on e-commerce sites.
The v2 file splits what was previously a mix of category, bullet, and SKU fields out of the product master into a dedicated file so the master file can stay slim and stable.
Delivery
| Property | Value |
|---|---|
| Host | ftp.jbi.bike |
| Protocol | FTP |
| Path | <your-folder>/inv/v2/inv_bullets.txt |
| Update schedule | 6:00 AM EST, Monday through Friday |
| Coverage | Active SKUs 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 (46 columns)
Identity
| # | Field | Description |
|---|---|---|
| 1 | item_id |
J&B part number |
| 2 | upc_ean |
UPC or EAN barcode |
Category Placement
| # | Field | Description |
|---|---|---|
| 3 | cat_1 |
Product category — level 1 (most general) |
| 4 | cat_2 |
Product category — level 2 |
| 5 | cat_3 |
Product category — level 3 |
| 6 | cat_4 |
Product category — level 4 (most specific) |
Model-Level Bullets
Marketing bullets shared by every SKU in the same model group. Use these for the "About this model" copy that does not change between sizes or colors.
| # | Field | Description |
|---|---|---|
| 7–26 | model_bullet_1 … model_bullet_20 |
Up to 20 model-level marketing bullets |
SKU-Level Bullets
Marketing bullets specific to this individual SKU. Use these for the variant-specific copy (size, color, finish, etc.).
| # | Field | Description |
|---|---|---|
| 27–46 | product_bullet_1 … product_bullet_20 |
Up to 20 SKU-level marketing bullets |
Notes
- All 40 bullet columns appear in every row. Unused bullet slots are emitted as empty strings — there is nothing between the surrounding tabs.
- Category columns are emitted in level order. A SKU that is only categorized to level 2 will leave
cat_3andcat_4blank. - Only active SKUs are included. If a SKU disappears from the file, treat it as no longer offered.
- Rows are sorted ascending by
item_id.
Document version: 1.0 — 2026-05-23 For questions or to request FTP access, contact JBI.