Task
Each JSON product has a prices array: base and retail price. The import needs only the price with price_type=retail.
Short answer
Open amount inside prices and add a condition on neighboring price_type: regular expression ^retail$ (matches a value that is exactly retail).
How to do it in Eofferix
In the JSON snapshot, select
amountinside thepricesarray.
The selected field belongs to one array item. Open the value settings.
The animation shows opening the field settings. Option without a regular expression: add an export condition on neighboring
price_type-Equalsretail.
This makes Eofferix take amountonly from the array item with the needed price type.Regular expression option: add an export condition on neighboring
price_type-Regular expression^retail$(matches a value that is exactlyretail).
This is the strict version of the same check when the price type must match fully.
Before / after
Before
source data{
"products": [
{
"sku": "SKU-29001",
"name": "Hudson lamp",
"prices": [
{
"price_type": "base",
"amount": 1490,
"currency": "USD"
},
{
"price_type": "retail",
"amount": 1290,
"currency": "USD"
}
]
},
{
"sku": "SKU-29002",
"name": "Parker chair",
"prices": [
{
"price_type": "base",
"amount": 9200,
"currency": "USD"
},
{
"price_type": "retail",
"amount": 8400,
"currency": "USD"
}
]
}
]
}After
result{
"products": [
{
"sku": "SKU-29001",
"name": "Hudson lamp",
"price": 1290,
"currency": "USD"
},
{
"sku": "SKU-29002",
"name": "Parker chair",
"price": 8400,
"currency": "USD"
}
]
}