Resolved [SOLVED] Unpublish when price is 0

Thank you Tharuna,
So our best option is to use the skip option for now.

Hello Nico,
We don't have CSVI rules which can control two field values. The CSVI Conditional field plugin will manipulate values based on only one field. I can think of two ways to handle this situation.

One is to unpublish all the products before import by setting Unpublish before import to Yes on Options tab in import template settings and then publish the products which has a price value with published field set to 1 in your import file.

Second option would be using CSVI Skip rule plugin, where you skip the import of records which has a price value. You can add Published as a template field and set Default value to 0. With Skip rule all the records which has a price greater than 0 will be skipped and only records with price as 0 or empty will be imported. To find if the price has a value greater than 0, you may need to use regular expression. Regular expression something like ^(0*[1-9][0-9]*)$, this need to be modify accordingly but this will be a good one to start with.

Let me know if this helps.