[Skip to main content](#vessel-content) # Search by Product ID ## - **[jdbarr](/forum/user/31850-jdbarr "View jdbarr's Profile")** - [![jdbarr's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31850-jdbarr "View jdbarr's Profile") Topic Author - [ Offline](/forum/user/31850-jdbarr) Less More - Posts: 1 - Thank you received: 0 - - 12 years 7 months ago [\#149483](#149483) by [jdbarr](/forum/user/31850-jdbarr "View jdbarr's Profile") *[Search by Product ID](/forum/25-install-update/866893-search-by-product-id#149483 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* was created by *[jdbarr](/forum/user/31850-jdbarr "View jdbarr's Profile")* How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. [ silentwordministries.org/index.php/publications/swm-products](http://silentwordministries.org/index.php/publications/swm-products) However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14270 - - 12 years 7 months ago [\#149497](#149497) 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 Product ID](/forum/25-install-update/866893-search-by-product-id#149497 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* Hi, You need to edit the options of the HikaShop products search plugin via the Joomla plugins manager. There, you can select the columns for which you want the plugin to work. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")** - [![patoushka's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6145-patoushka "View patoushka's Profile") - [ Offline](/forum/user/6145-patoushka) Less More - Posts: 628 - Thank you received: 18 - - 6 years 2 months ago [\#323284](#323284) by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") Replied by *[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")* on topic *[Search by Product ID](/forum/25-install-update/866893-search-by-product-id#323284 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* I tried it and it doesn't work for me. I have a message that say that I need a word with more the 3 characters. I have lest than 100 products. So, All my products have only two characters (ex: 28). We really need the search to be applied into Product ID. Is there any way to include those product into the result? Thanks, This is my "Search - Hikashop Products" setup: [ ![Capturedecranle2020-08-23a17.05.45.png](/forum/attachment/50383) ](/forum/attachment/50383 "...3a17.05.45.png") - [ ![Capturedecranle2020-08-23a17.05.45.png](/forum/attachment/50383) ](/forum/attachment/50383 "...3a17.05.45.png") [ ](/forum/attachment/50383?download=1 "...3a17.05.45.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14270 - - 6 years 2 months ago [\#323303](#323303) 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 Product ID](/forum/25-install-update/866893-search-by-product-id#323303 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* Hi, I didn't thought about that. However, that's not a limitation of HikaShop but the Joomla search system so you would have to modify Joomla for that: [ forum.joomla.org/viewtopic.php?f=472&t=339184](https://forum.joomla.org/viewtopic.php?f=472&t=339184) Or you could change the ids in the hikashop_product table in the database and increase them. That would be a cleaner way to allow for that. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")** - [![patoushka's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6145-patoushka "View patoushka's Profile") - [ Offline](/forum/user/6145-patoushka) Less More - Posts: 628 - Thank you received: 18 - - 6 years 2 months ago [\#323312](#323312) by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") Replied by *[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")* on topic *[Search by Product ID](/forum/25-install-update/866893-search-by-product-id#323312 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* We will have to make a big reset and delete all our product when the work will be finished. So, it will be a fresh start. What procedure do you suggest? 1. I create a new product 2. change the database for a three digit ID ( ex: 101 ) After that, will my new products stills use the following ID,s? ( 102, 101, etc... ) -- -- -- -- Another option could be the create 99 fake products that I will keep unpublished with an inventory of 0. That way, new products created by vendors will have their 3 digits. Way do you think. Which approach would you choose in our situation? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")** - [![patoushka's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6145-patoushka "View patoushka's Profile") - [ Offline](/forum/user/6145-patoushka) Less More - Posts: 628 - Thank you received: 18 - - 6 years 2 months ago [\#323317](#323317) by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") Replied by *[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")* on topic *[Search by Product ID](/forum/25-install-update/866893-search-by-product-id#323317 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* I continue my reflexions about that. I have made some tests with products that I have deleted. Actually, I have only 6 products for my tests and my ID is at 28. I want your opinion on that. If I enter 72 news products during the tests process. products that i will delete before launching the website. The ne IDs will be > 100 and the products will be find by the search tool. What do you think of that? Thanks again! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14270 - - 6 years 2 months ago [\#323328](#323328) 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 Product ID](/forum/25-install-update/866893-search-by-product-id#323328 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* Hi, Yes, you can do it like that. You could also change the auto_increment of the hikashop_product table in the database via your phpmyadmin so that it directly starts at 100 without having to create fake products: [ stackoverflow.com/questions/5665571/auto...hatever%20you%20want](https://stackoverflow.com/questions/5665571/auto-increment-in-phpmyadmin#:~:text=In%20phpMyAdmin%2C%20navigate%20to%20the,set%20the%20current%20AUTO_INCREMENT%20value.&text=Just%20run%20a%20simple%20MySQL,number%20to%20whatever%20you%20want). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")** - [![patoushka's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/6145-patoushka "View patoushka's Profile") - [ Offline](/forum/user/6145-patoushka) Less More - Posts: 628 - Thank you received: 18 - - 6 years 2 months ago [\#323331](#323331) by [patoushka](/forum/user/6145-patoushka "View patoushka's Profile") Replied by *[patoushka](/forum/user/6145-patoushka "View patoushka's Profile")* on topic *[Search by Product ID](/forum/25-install-update/866893-search-by-product-id#323331 "How can I get the Search Module to search Product IDs? The search finds text in product descriptions and other web pages, but does not find product numbers. For example, a search for "Baby" on this page returns 50 results. Clicking the Products checkbox finds one result with the appropriate product. silentwordministries.org/index.php/publications/swm-products However, a search for the product number is BS1 does not return the Baby Sign Language book. I am using -- the latest stable version of HikaShop Starter: 2.3.0 -- Joomla version -- : 2.5.19 -- PHP version -- : 5.3.28 -- Chromium Browser (Linux) -- Error-message(set to Maximum) -- : No errors shown. Any ideas would be appreciated. Thanks.")* Much more easier. Thanks, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2Njg5My1zZWFyY2gtYnktcHJvZHVjdC1pZD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & 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.314 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)