Include Product ID in front office search

[George Bazz]

As the title suggests, I would like to type the ID of a certain product in the Block Search as well.

Any override suggestions?

[Scully]

Without question this would be possible - but quite likely with some downsides. Imagine we have let's say 2'000 products. Starting with ID 1 and going up to 2000 and something. PrestaShops search is a full text search with no specification how it performs the search.

 

If you have set the minimum search length to 3 characters as an example, any search with ID's less than 100 wouln't work at all. So you had to set the minimum search length to 1 which leads to other problems.  If you are searching the product with ID 1, prestashop would then also find the following products:

 

All products with 1 in its title, product reference, eventually short descriptions and so on. So it would find products with 1, 10, 11, 100, 101, 1011 in any search field. To avoid this, you could define some kind of prefix like for example:

 

id:1

 

This would lead the override function only to search for IDs and nothing else. However, the prefix wouln't be self explanatory. So users must know about this "hidden" feature.

Edited August 30, 2017 by Scully (see edit history)

[Scully]

Just don't use  LIKE ,  use id_product=x

 

But you might still want to search with LIKE if in another context, text search as example. So the query needed to get some basic intelligence about IDs.

Edited August 30, 2017 by Scully (see edit history)

[George Bazz]

Kind of outdated but well..

I ended up creating a module that lets me search products by ID in the front office. Not only that, but if you wish you can enable a special block in every Product Page that indicates which the current product ID is. This is especially helpful, if you sell a lot by phone, and people keep asking you for complicated names and/or reference numbers. By telling you the ID you can search directly by it in a specialized search box, available only for logged in employees and navigate your products super fast!

Check it out:
https://addons.prestashop.com/en/search-filters/45058-quick-jump-to-product-by-id-search-by-id.html

[salouso]

On 6/20/2019 at 4:56 PM, George Bazz said:

Kind of outdated but well..

I ended up creating a module that lets me search products by ID in the front office. Not only that, but if you wish you can enable a special block in every Product Page that indicates which the current product ID is. This is especially helpful, if you sell a lot by phone, and people keep asking you for complicated names and/or reference numbers. By telling you the ID you can search directly by it in a specialized search box, available only for logged in employees and navigate your products super fast!

Check it out:
https://addons.prestashop.com/en/search-filters/45058-quick-jump-to-product-by-id-search-by-id.html

Is this module still available. Your links isn`t working and I can`t find it. Using PS 1.7.