BMW GL Products Source
Status (2026-07-03): GL Products has no extractor yet. It is the only source with real non-zero prices.
GL Products is a BMW product catalog API providing feature/option data with pricing. It is distinct from UCP and RIS. GL Products is the primary source for price_net and price_gross with real values.
BmwFeatureEntity field mapping (GL Products)
Composite primary key: feature_code + model_code
Note on extraction: No extractor exists yet. GL Products fixtures are available for DE market.
Field × source matrix (GL Products columns)
| Entity field | BQ column | GL Products path | manual check | code note |
|---|---|---|---|---|
| feature_code | code | features[*].option | ✓ | codes are 5-char alphanumeric; format consistent across all sources |
| model_code | product_code | item.modelCode | ✓ | |
| brand | — | item.brand | ✓ | not in BQ raw_feature_metadata — available from GL Products |
| name | name | — | ✓ | not in GL Products field matrix; use UCP or BQ for English name; GL Products DE fixture has German text |
| description | long_description | features[*].phrases.longDescription | ✓ | GL Products DE fixture: German text (e.g. "Service Inclusive für Sondergeschäftsfelder…") |
| feature_type | type | features[*].type | ✓ | all sources use same single-letter codes (S, F, I, P) — format consistent ✓ |
| family_code | family_code | features[*].familyCode | ✓ | GL Products: non-empty (e.g. YSERV, KUNST); BQ: empty for service options |
| is_standard | is_standard | features[*].std | ✓ | boolean — format matches ✓ |
| price_gross | list_price | features[*].grossListPrice | ✓ | GL Products DE has real prices (e.g. 1680.30); BQ has list_price only (no net) |
| price_net | — | features[*].netListPrice | ✓ | not in BQ — only available from GL Products and UCP pricing sources |
| currency | — | derived from market | ✓ | not in BQ — EUR for DE market (inferred) |
GL Products samples (DE fixture)
| feature_code | feature_type | family_code | is_standard | price_gross (list) | price_net | pack_flag | description (longDescription) |
|---|---|---|---|---|---|---|---|
S07DS | S | YSERV | false | 1680.30 | 1412.00 | — | "Service Inclusive für Sondergeschäftsfelder…" (German) |
FKUFU | F | KUNST | false | 900.00 | 756.30 | C | "Veganza perforiert Rauchweiß" (German) |
GL Products is the only source with real non-zero prices.
pack_flag=C(component) only present for package members. Not currently a field inBmwFeatureEntity.
Notes
pack_flag=Cmeans the feature is a component (member) of a package. Not yet added as an entity field — candidate for future addition.namelocale: GL Products DE fixture = German; BQ = English; UCP IE fixture = option code. Same concept, locale differs.family_codepopulated in GL Products (e.g.YSERV,KUNST) where BQ has empty strings for service-type options.price_netandcurrencyhave no BQ equivalent inraw_feature_metadata— GL Products is the primary source for net pricing.