Task
Each JSON product has a warehouses array. The import needs stock only from warehouse ny-main, while reserve warehouses must not fill this field.
Short answer
Open qty inside warehouses and add a condition on neighboring warehouse_id: regular expression ^ny-main$ (matches a value that is exactly ny-main).
How to do it in Eofferix
In the JSON snapshot, select
qtyinside thewarehousesarray.
The selected field belongs to one warehouse object. Open the value settings.
The animation shows opening the field settings. Method 1: on neighboring
warehouse_id, setEqualsny-main.
This is one condition variant; the other variants do not need to be added. Method 2: keep regular expression
^ny-main$(matches a value that is exactlyny-main) as the strict option.
This is one condition variant; the other variants do not need to be added.
Before / after
Before
source data{
"products": [
{
"sku": "SKU-25001",
"name": "Hudson lamp",
"warehouses": [
{
"warehouse_id": "ny-main",
"qty": 14
},
{
"warehouse_id": "la-reserve",
"qty": 6
}
]
},
{
"sku": "SKU-25002",
"name": "Parker chair",
"warehouses": [
{
"warehouse_id": "ny-main",
"qty": 0
},
{
"warehouse_id": "la-reserve",
"qty": 5
}
]
}
]
}After
result{
"products": [
{
"sku": "SKU-25001",
"name": "Hudson lamp",
"stock": 14
},
{
"sku": "SKU-25002",
"name": "Parker chair",
"stock": 0
}
]
}