Resolved How to don't export discontinued products?

Hello Davide,
Discontinued product will have field product_discontinued set to 1 in database. What you can do is add product_discontinued field as export template field and using CSVI Skip rule plugin skip the rows with product_discontinued value set to 1. You can even set this field to Unpublished in template field so it is not included in export. Let me know if this helps.

Hi Tharuna,

ok, thank you very much.

Just one question related to this, how can I skip fields that has a value minor of 49?


Thanks.


Regards.

Hello Davide,
There is no direct way of skipping values less than 49 using Skip rule but it is possible by combining CSVI Conditional rule and CSVI Skip rule plugins. Create first rule using CSVI conditional rule plugin where you check the value is less than 49 and replace the value with some standard value like say 1. This rule will replace all the values less than 49 to 1. Now create another rule using CSVI Skip rule plugin to skip all the values with 1. Apply the rule in the order like CSVI conditional rule first and then CSVI Skip rule.

Hi Tharuna,

I just did it, but probably it's not working or I'm doing somethins wrong.

In the rule I inserted -> less than 49,00

If the field is 680,00, for example, the result is ok, if the field is 200,00 not, I see the 1 I inserted.

Any idea?


Thanks.

Hello,
Can you send the screenshot of both the rules?

Sure, you find them in attachment.


Thanks.

Hello Davide,
In your CSVI conditional rule instead of 49,00 what if you are setting it as 49? Does the rule works then?

Hello Tharuna,

tested, same problem...


Thanks.
Davide

Hello Davide,
Can you also send the screenshot of how you have applied the rules in template fields page?

Hello,

sure, in attachment.


Thanks.

Hello Davide,
I am not seeing anything wrong with your rules and the way it is applied as per the sceenshots. The rules should work with the way it looks. Can you send me your template XML file to check? To get template XML go to CSVI Maintenance page, select CSVI Pro in first dropdown and Backup templates in second dropdown and select your import template and click continue. Post the downloaded XML file.

Hello Davide,

Please use 49.00 instead of 49,00 and let me know if that works for you.

Hello rolandd,

just tested, now it seems to work.


Thanks a lot.
Davide