// Comments are here to help you understand,
// remove them before uploading mappings as they are not accepted in JSON
"created_by": <>, // Read only
"created_ts": <>, // Read only
// Maps $properties.order.order_products to $items
"target_attribute_name": "$items",
"source_attribute_path": {
"attribute_name": "$properties",
"attribute_name": "order",
"attribute_name": "order_products"
// Maps $properties.order.order_products.xxx to $items.xxx
// You can't use other target attributes than the ones
// But they are not all mandatory : a non used target
// attribute will use the default value
// $properties.order.order_products.product.id
// to be used by analytics database
"target_attribute_name": "$id",
"source_attribute_path": {
"attribute_name": "product",
// $properties.order.order_products.qty
// to be used by analytics database
"target_attribute_name": "$qty",
"source_attribute_path": {
"target_attribute_name": "$price",
"source_attribute_path": {
"attribute_name": "price"
"target_attribute_name": "$ean",
"source_attribute_path": {
"target_attribute_name": "$brand",
"source_attribute_path": {
"attribute_name": "brand",
"target_attribute_name": "$category1",
"source_attribute_path": {
"target_attribute_name": "$category2",
"source_attribute_path": {
"attribute_name": "cat2",
"target_attribute_name": "$category3",
"source_attribute_path": {
"target_attribute_name": "$category4",
"source_attribute_path": {