Task
This case prepares the Backorders allowed? column from backorder_mode for the final CSV.
Short answer
Map preorder to notify, allowed to 1, and all other rows to 0.
How to do it in Eofferix
Select the source column or create the output column from the specified source.
backorder_mode→Backorders allowed?.Open the settings of the output column
Backorders allowed?.
Real animation: opening the output column settings in the table editor. In Transformations, add the rules shown below.
Real screenshot of the Transformations block for this column. Save the settings, go to export, and check the values in the downloaded CSV.
Check target column names and accepted values against the official CSV documentation. WooCommerce CSV.
Before / after
Before
source data| SKU | Name | backorder_mode |
|---|---|---|
| LAMP-1 | Desk lamp | deny |
| POST-1 | Wall poster | allowed |
| MUG-1 | Coffee mug | preorder |
After
result| SKU | Name | Backorders allowed? |
|---|---|---|
| LAMP-1 | Desk lamp | 0 |
| POST-1 | Wall poster | 1 |
| MUG-1 | Coffee mug | notify |