Product characteristics mass action SQL Error

-- url of the page with the problem -- : seemybag.gr/alpha
-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.18
-- PHP version -- : 7.4
-- Error-message(debug-mod must be tuned on) -- : Error in SQL syntax

Hello,

when I try to add a filter for a product Characteristic I get an SQL Error.
See attached image for info.

Hi,

Thank you for your feedback. We've added a patch on our end for that. Download again the install package of HikaShop on our website and install it on your website and it will add that patch.

Hello,

thank you so much! The error was resolved.

When I filter a certain Characteristic it finds the number of products x 2.
I have 76 products with Wet Bag Size = Small and it finds 152 results.

Is that normal? What if I change now the price?

Hi

Well, if you're sure you have 76 products with that characteristic value and it says you have 152 products with it, then there is a problem.
I would recommend to first use the action "display the results" so that you can check what products it found before running an action that will modify the products. That way, you can check on which products it will do the changes before doing them.

Hello,

I checked the results and it returns also the "parent" product along with the variant.
Is that normal?

Hi,

Yes. Just add a second filter on the product type to only have the main products if you don't want the variants matching with that value