[Skip to main content](#vessel-content)

#   Search by code without sumbols

##

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

3 years 1 month ago [\#355628](#355628) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355628 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")* was created by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")*

-- HikaShop version -- : 4.7.5
-- Joomla version -- : 3.10.12

Hello!

I would like to be able to search by product code like this:
Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.

Thank you

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Philip](/forum/user/34318-philip "View Philip's Profile")**
- [![Philip's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34318-philip "View Philip's Profile")
- [ Offline](/forum/user/34318-philip)

Less More

- Posts: 4820
- Thank you received: 652
-
-

3 years 1 month ago -  3 years 1 month ago [\#355632](#355632) by [Philip](/forum/user/34318-philip "View Philip's Profile")  Replied by *[Philip](/forum/user/34318-philip "View Philip's Profile")* on topic *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355632 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")*

Hello,

Take a look on my **screenshot**, and especiallt red bordered part, this should get you what you need:
[ ![ alt](https://i.ibb.co/nfZZs50/screenshot1.png) ](https://i.ibb.co/nfZZs50/screenshot1.png " alt")

Regards

Last edit: 3 years 1 month ago by [Philip](/forum/user/34318-philip "View Philip's Profile").

The following user(s) said Thank You: [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

3 years 1 month ago [\#355664](#355664) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355664 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")*

Hi!

I did it but it's not working. I need the search filter to apply to titles also not just code.

Thank you

- [ ![search&#95;2023-10-06.jpg](/forum/attachment/57943) ](/forum/attachment/57943 "...2023-10-06.jpg") [ ](/forum/attachment/57943?download=1 "...2023-10-06.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

3 years 1 month ago [\#355667](#355667) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355667 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")*

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: Code:

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

(not tested)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")**
- [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") Topic Author
- [ Offline](/forum/user/8351-verzevoul)

Less More

- Posts: 1195
- Thank you received: 13
-
-

3 years 1 month ago [\#355719](#355719) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")  Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355719 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")*

Hi!

I created the custom field and did the filter as you said but the mass action didn't work.
The value of the custom field after i ran the mass action is 0.
Could you check the screenshots if everything is correct?

Thank you!

- [ ![Actions.jpg](/forum/attachment/57957) ](/forum/attachment/57957 "Actions.jpg") [ ](/forum/attachment/57957?download=1 "Actions.jpg")
- [ ![custom-field.jpg](/forum/attachment/57958) ](/forum/attachment/57958 "custom-field.jpg") [ ](/forum/attachment/57958?download=1 "custom-field.jpg")
- [ ![filter&#95;2023-10-09.jpg](/forum/attachment/57959) ](/forum/attachment/57959 "...2023-10-09.jpg") [ ](/forum/attachment/57959?download=1 "...2023-10-09.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

3 years 1 month ago [\#355725](#355725) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Search by code without sumbols](/forum/45-filters-search/907088-search-by-code-without-sumbols#355725 "-- HikaShop version -- : 4.7.5 -- Joomla version -- : 3.10.12  Hello!  I would like to be able to search by product code like this: Let's say the product code is 11-22-333, if i put this code in the search box it works correctly. What i want is to add the code without the dashes (-) and still get results, for example 1122333 or 11 22 333.  Thank you")*

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: Code:

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

The following user(s) said Thank You: [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNzA4OC1zZWFyY2gtYnktY29kZS13aXRob3V0LXN1bWJvbHM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.069 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
