Fill Shopify Published on online store from product status

Task

This case prepares the Published on online store column from status for the final CSV.

Short answer

Map active-like source statuses to true and all other source statuses to false before exporting the Shopify CSV.

How to do it in Eofferix

Select the source column or create the output column from the specified source. status → Published on online store.
Open the settings of the output column Published on online store.
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. Shopify CSV.

source data

result