Find empty canonical

  • Posts: 322
  • Thank you received: 18
  • Hikashop Business
5 months 2 weeks 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: 82910
  • Thank you received: 13386
  • MODERATOR
5 months 2 weeks 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: 322
  • Thank you received: 18
  • Hikashop Business
5 months 1 week 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: 82910
  • Thank you received: 13386
  • MODERATOR
5 months 1 week 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: 322
  • Thank you received: 18
  • Hikashop Business
5 months 1 week 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: 82910
  • Thank you received: 13386
  • MODERATOR
5 months 1 week 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: 322
  • Thank you received: 18
  • Hikashop Business
5 months 1 week 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.063 seconds
Powered by Kunena Forum