Search by code without sumbols

Hello,

Take a look on my screenshot, and especiallt red bordered part, this should get you what you need:

Hi,

There is no option to dynamically apply modifications to the texts being searched.
What you need to do is to create a custom field of the table "product" and of the type "text" or "textarea" where you can enter the product code without the dashes. Then, in your filter, also select that custom field and you'll find results for the product code without the dashes.
And you can also create a mass action to automatically fill the custom field with the product_code without the dashes with a mass action of the type "update the values" on the column of the custom field with the "operation" mode and the value:

replace({product.product_code},'-','')

Hi,

I would recommend doing it with a normal mass action (with a filter on the product_id to target only one product first) and see if you get any error when you run it.

Otherwise, you could also try running a MySQL query directly in the database via PHPMyAdmin. Something like that:

UPDATE #__hikashop_product SET search_column = replace(product_code,'-','');