Task
This case prepares the Type column from product_kind for the final CSV.
Short answer
Use a replacement dictionary so WooCommerce receives valid product type values.
How to do it in Eofferix
Select the source column or create the output column from the specified source.
product_kind→Type.Open the settings of the output column
Type.
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 | product_kind |
|---|---|---|
| LAMP-1 | Desk lamp | physical |
| CONS-1 | Online consultation | virtual |
| FILE-1 | Template pack | downloadable |
After
result| SKU | Name | Type |
|---|---|---|
| LAMP-1 | Desk lamp | simple |
| CONS-1 | Online consultation | simple, virtual |
| FILE-1 | Template pack | simple, virtual, downloadable |