Overview

In this Data Type, you can define all the data about customer vouchers or coupons.

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": "1234",
  "type": "product_specific",
  "voucher_products": [
    {
      "sku": "123"
    },
    {
      "sku": "456"
    }
  ],
  "title": [
    {
      "language": "en",
      "value": "20% voucher on 2 cool products"
    }
  ],
  "pricing": [
    {
      "customer_groups": [
        "new_customer"
      ],
      "voucher_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 voucher
external_id	STRING	NULLABLE	the external identifier of the voucher (can be the same as the internal identifier)
voucher_products	PRODUCT	REPEATED	products related to the voucher
voucher_products_attributes	RECORD	REPEATED	product segments related to the voucher
voucher_products_attributes. operator	STRING	NULLABLE
voucher_products_attributes. segments	RECORD	REPEATED
voucher_products_attributes.segments. type	STRING	NULLABLE
voucher_products_attributes.segments. name	STRING	NULLABLE
voucher_products_attributes.segments. value	STRING	NULLABLE
type	STRING	NULLABLE	the type value)
ean	STRING	NULLABLE	the ean value)
label	STRING	NULLABLE	label of the voucher
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. voucher_percentage_value	RECORD	REPEATED	the percentage value of the voucher
pricing.voucher_percentage_value. language	STRING	REQUIRED
pricing.voucher_percentage_value. value	STRING	REQUIRED
pricing.voucher_percentage_value. currency	STRING	REQUIRED
pricing. voucher_absolute_value	RECORD	REPEATED	the absolute value of the voucher
pricing.voucher_absolute_value. language	STRING	REQUIRED
pricing.voucher_absolute_value. value	STRING	REQUIRED
pricing.voucher_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
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_voucher.json

BigQuery DDL

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