Task
This case prepares the In stock? column from stock_qty for the final CSV.
Short answer
Write 1 when stock is positive or the source status says in stock; write 0 otherwise.
How to do it in Eofferix
Select the source column or create the output column from the specified source.
stock_qty→In stock?.Open the settings of the output column
In stock?.
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 | stock_qty | stock_status |
|---|---|---|---|
| LAMP-1 | Desk lamp | 12 | |
| POST-1 | Wall poster | 0 | out of stock |
| MUG-1 | Coffee mug | 0 | in stock |
After
result| SKU | Name | In stock? |
|---|---|---|
| LAMP-1 | Desk lamp | 1 |
| POST-1 | Wall poster | 0 |
| MUG-1 | Coffee mug | 1 |