× Looking for a useful answer?

Read this first and make sure you checked all steps: csvimproved.com/support/getting-started

Don't just say it doesn't work but describe in detail what is happening and add the following information:
* Version of the extension you are using
* CSVI version (Latest is not a version number)
* Sample of the file being imported
* A copy of the template you are using. Use the maintenance menu to create a backup of your template
* Collected debug information

Without this information you won't get a useful answer. If no debug log is attached, you will get a request to post it.

Where to get the debug information?

A tutorial ( csvimproved.com/support/questions-and-answers/390-how-to-collect-debug-information ) has been written to help you collect your debug information.

[SOLVED] Unpublish when price is 0

  • delinieict
  • delinieict's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 3 weeks ago - 1 month 3 weeks ago #60385 by delinieict
delinieict created the topic: [SOLVED] Unpublish when price is 0
Hi,
Is it possible to unpublish HikaShop products during import when the price is 0 or empty ?
I've searched but have not found enough inspiration to make it work.
Thanks for any tips.
Nico
Last edit: 1 month 3 weeks ago by delinieict. Reason: solved for me

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #60388 by tharuna
tharuna replied the topic: Unpublish when price is 0
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.

Kind regards,

Tharuna

=========================
If you use CSVI, please post a rating and a review at the Joomla! Extension Directory

Please Log in or Create an account to join the conversation.

  • delinieict
  • delinieict's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 month 3 weeks ago #60393 by delinieict
delinieict replied the topic: Unpublish when price is 0
Thank you Tharuna,
So our best option is to use the skip option for now.

Please Log in or Create an account to join the conversation.