Task
The CSV has an internal product status. Shopify needs true for published products and false for drafts.
Short answer
Create Published on online store: default to false, and set true when status is active, yes, or 1.
How to Do It in Eofferix
Method 1: How to Do It in Eofferix with Regular Expressions
- Open the settings of the output
Published on online storecolumn.
The screenshot shows the output Published on online storecolumn and the settings icon used to open its settings. - In
Transformations, set thefalsedefault and use^(active|yes|1)$fortrue.
The Transformationsblock shows the full rule chain for this case. - Save the column settings and go to the
Exportstep.
Method 2: How to Do It in Eofferix with Substring Search
- Open the settings of the output
Published on online storecolumn. - In
Transformations, replace the regular expression with separate rules for each text marker.If the source column contains longer phrases, get the same result without a regular expression: add several rules with
Contains substring, one rule for each marker. For the numeric1flag, keep anEqualscondition so other numbers are not matched.Order What to check Condition Action 1 Current value Any Replace with false 2 status Contains substring active Replace with true 3 status Contains substring yes Replace with true 4 status Equals 1 Replace with true 
In the second method, each text marker uses Contains substring; the numeric1marker uses an exact comparison. - Save the column settings and go to the
Exportstep.
Before / After
Before
source data| Handle | Title | status |
|---|---|---|
| desk-lamp | Desk lamp | active |
| office-chair | Office chair | draft |
After
result| Handle | Published on online store |
|---|---|
| desk-lamp | true |
| office-chair | false |