Overview

In this Data Type, you can define all the data about product bundles.

Example

In this example, we provide a simple attribute definition.

Here is the example for the first case above (make sure to format it in JSONL before loading to BigQuery: Newline delimited JSON : https://en.wikipedia.org/wiki/JSON_streaming).

{
  "internal_id": "2345",
  "type": "simple_bundle",
  "bundle_products": [
    {
      "sku": "123"
    },
    {
      "sku": "456"
    }
  ],
  "title": [
    {
      "language": "en",
      "value": "20% discount if both products are bought together"
    }
  ],
  "pricing": [
    {
      "customer_groups": [
        "new_customer"
      ],
      "bundle_percentage_value": [
        {
          "value": 0.2
        }
      ]
    }
  ],
  "creation_tm": "2020-10-20 00:00:00",
  "client_id": 1,
  "src_sys_id": 1
}

Properties

Field name	Type	Mode	Description

Field name	Type	Mode	Description
internal_id	STRING	REQUIRED	the internal identifier of the bundle
external_id	STRING	NULLABLE	the external identifier of the bundle (can be the same as the internal identifier)
bundle_products	PRODUCT	REPEATED	relations to other products
type	STRING	NULLABLE	the type value)
ean	STRING	NULLABLE	the ean value)
label	STRING	NULLABLE	label of the bundle
creation	DATETIME	NULLABLE
last_update	DATETIME	NULLABLE
is_new	BOOLEAN	NULLABLE
in_sales	BOOLEAN	NULLABLE
product_relations	PRODUCT	REPEATED	relations to other products
other_relations	CONTENT	REPEATED	relations to other contents
stores	STRING	REPEATED	the stores
title	LOCALIZED	REPEATED	the title of the attribute value
short_description	LOCALIZED	REPEATED	the short description of the product group
description	LOCALIZED	REPEATED	the description of the attribute value
images	LIST	REPEATED	the images of the attribute value
link	LOCALIZED	REPEATED	the link of the attribute value
tags	TAG	REPEATED	the tags , e.g.: [STRUCT('tag', 'hello world', [STRUCT('de', 'hello world')])]
labels	LABEL	REPEATED	the labels of the product line, e.g.: [STRUCT('symbol', 'delivery', '24h', [STRUCT('de', '24-H Versand')])]
pricing	PRICE	REPEATED
pricing. bundle_percentage_value	RECORD	REPEATED	the percentage value of the voucher
pricing.bundle_percentage_value. language	STRING	REQUIRED
pricing.bundle_percentage_value. value	STRING	REQUIRED
pricing.bundle_percentage_value. currency	STRING	REQUIRED
pricing. bundle_absolute_value	RECORD	REPEATED	the absolute value of the voucher
pricing.bundle_absolute_value. language	STRING	REQUIRED
pricing.bundle_absolute_value. value	STRING	REQUIRED
pricing.bundle_absolute_value. currency	STRING	REQUIRED
periods	PERIOD	REPEATED	information about the activity periods of the ugc
stock	STOCK	REPEATED	the stock
visibility	VISIBLITY	REPEATED	the product visibility :VISIBILITY_NOT_VISIBLE = 1; VISIBILITY_IN_CATALOG = 2; VISIBILITY_IN_SEARCH = 3; VISIBILITY_BOTH = 4;
status	STATUS	REPEATED	the product status
individually_visible	BOOLEAN	NULLABLE	in addition to be an bundle in this product group, the product should also appear separately in the list of results as itself
show_out_of_stock	BOOLEAN	NULLABLE	show the bundle even if one of its products is out of stock
string_attributes	MAP	REPEATED	additional string (not localized) attributes of the product line (MAP type: STRING)
localized_string_attributes	MAP	REPEATED	additional localized string attributes (MAP type: LOCALIZED in STRING)
numeric_attributes	MAP	REPEATED	additional numeric (not localized) attributes (MAP type: NUMERIC)
localized_numeric_attributes	MAP	REPEATED	additional localized numeric attributes (MAP type: LOCALIZED in NUMERIC)
datetime_attributes	MAP	REPEATED	additional datetime (not localized) attributes (MAP type: DATETIME)
localized_datetime_attributes	MAP	REPEATED	additional localized datetime attributes (MAP type: LOCALIZED inDATETIME)
creation_tm	DATETIME	REQUIRED	technical field
client_id	INTEGER	REQUIRED	technical field
src_sys_id	INTEGER	REQUIRED	technical field

Resources

BigQuery JSON Schema

https://github.com/boxalino/data-integration-doc-schema/blob/master/doc/doc_bundle.json

BigQuery DDL

https://github.com/boxalino/data-integration-doc-schema/blob/master/ddl/doc_bundle.sql