Jump to content

Search with or without spaces


jcoletta

Recommended Posts

Hi,

I have a problem with my prestashop store. My store is: http://recambioprofesionalbarato.com

I have loaded about a thousand products, with reference codes to vehicles which account for each exchange.

But my problem comes here: I want these codes are found in the search, even if placed with or without spaces.

For example, when I do the search:

0 986 013 850

The search engine will find it perfectly.

However, if we look no spaces:

0986013850

The search finds nothing.

Is there an automatic way? Can you help me?

Looking forward for your answer.

Link to comment
Share on other sites

You could autogenerate aliases by doing something like this:

$sql = 'SELECT `reference`
         FROM `'._DB_PREFIX_.'product`';

$refs = Db::getInstance(_PS_USE_SQL_SLAVE_)->executeS($q);

foreach($refs as $ref){
  $alias = new Alias();
  $alias->search = preg_replace('/\s+/', '', $ref['reference']);
  $alias->alias = $ref['reference'];
  $alias->save();
}


I have not tested this, use at your own risk.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...