Transformers
Configure column mappings, merges, and transform scripts.
ax_stock→normalise_stock→magento_source_items
Column Mapping
Source: ax_stock → Target: magento_source_items
| Source Field | Target Field | Type | Transform |
|---|---|---|---|
| SKU | sku | string | direct |
| Name | name | string | direct |
| Quantity | qty | number | direct |
| WarehouseCode | source_code | string | direct |
| — | status | number | qty > 0 ? 1 : 0 |
Merge Sources
Merge: shopify_productsKey: SKU | source_priority
Column Scripts
normalise_category
Input: department, category, subcategory → Output: category_path
department + '/' + category + '/' + subcategory
Interim Data Pool
3 sources · 12,450 rows
| SKU | Name | Qty | Src Code | Category Path |
|---|---|---|---|---|
| A001 | Trail Pack 45L | 245 | WH-AKL | Camp/Hike/Backpacks |
| A002 | Tent 2P Ultralight | 18 | WH-AKL | Camp/Tent/Ultralight |