Find empty canonical

  • Posts: 323
  • Thank you received: 18
  • Hikashop Business
6 months 4 days ago #361578

-- HikaShop version -- : 5.0.4
-- Joomla version -- : 4

Im trying to find all products with empty canonical with mass action, but without success.
How to configure filter?

Attachments:

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
6 months 4 days ago #361582

Hi,

Instead of "is null", use "equal" and leave the input field on the right side empty.
Also, if you have variants, you probably want a second filter on the product type in order to discard the variants as their canonical field is empty in the database, and not used by HikaShop.

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

  • Posts: 323
  • Thank you received: 18
  • Hikashop Business
6 months 3 days ago #361618

With equal I get all products (most of them have canonical). We dont use variants.

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
6 months 3 days ago #361620

Hi,

Indeed, I'm able to reproduce the issue on my end.
Change the line:

if($filter['value'] == 0 || !empty($filter['value']) || (empty($filter['value']) && in_array($filter['operator'],array('IS NULL','IS NOT NULL')))){
to:
if($filter['value'] == 0 || !empty($filter['value']) || (empty($filter['value']) && in_array($filter['operator'],array('IS NULL','IS NOT NULL','=','!=')))){
in the file plugins/hikashop/massaction_product/massaction_product.php and that will fix it.
We're going to add the patch for this on our end for the next version of HikaShop.

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

  • Posts: 323
  • Thank you received: 18
  • Hikashop Business
6 months 2 days ago #361630

Now I get some 100 products and most of them have canonical.

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

  • Posts: 83022
  • Thank you received: 13403
  • MODERATOR
6 months 2 days ago #361633

Hi,

I'm not able to reproduce the issue on my end.
It works fine for me now.
Could you provide a backend access and a FTP access and the name of the mass action you're using so that we can look into it ?
www.hikashop.com/support/contact-us.html

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

  • Posts: 323
  • Thank you received: 18
  • Hikashop Business
6 months 1 day ago #361645

I tryed day later and now works. Thank you.

The following user(s) said Thank You: nicolas

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

Time to create page: 0.045 seconds
Powered by Kunena Forum