Jump to content

Search on admin catalog


Recommended Posts

Hello i'm new in prestashop and i installed . A lot of my products are like "Mike's Blouse", "Mike's T-shirt" etc. I'd like to see all my products name like "Mike's". I found from inpect elemenent

SELECT SQL_CALC_FOUND_ROWS p.`id_product` AS `id_product`, p.`reference` AS `reference`, p.`price` AS `price`, p.`id_shop_default` AS `id_shop_default`, p.`is_virtual` AS `is_virtual`, pl.`name` AS `name`, pl.`link_rewrite` AS `link_rewrite`, sa.`active` AS `active`, shop.`name` AS `shopname`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, 0 AS `price_final`, pd.`nb_downloadable` AS `nb_downloadable`, sav.`quantity` AS `sav_quantity`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger` FROM `pscs_product` p LEFT JOIN `pscs_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.`id_lang` = 1 AND pl.`id_shop` = 1) LEFT JOIN `pscs_stock_available` sav ON (sav.`id_product` = p.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `pscs_product_shop` sa ON (p.`id_product` = sa.`id_product` AND sa.id_shop = 1) LEFT JOIN `pscs_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1) LEFT JOIN `pscs_category` c ON (c.`id_category` = cl.`id_category`) LEFT JOIN `pscs_shop` shop ON (shop.id_shop = 1) LEFT JOIN `pscs_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = 1) LEFT JOIN `pscs_image` i ON (i.`id_image` = image_shop.`id_image`) LEFT JOIN `pscs_product_download` pd ON (pd.`id_product` = p.`id_product`) WHERE (1 AND pl.`name` LIKE '%Mike's%' AND state = 1) ORDER BY `id_product` desc LIMIT 0, 20 ;

So i changed a product name in my database to "Mike's Blouse" and now i'm getting it after searching.


But on catalog and on product page i see name like "Mike's" and not "Mike's". In product.tpl i added nofilter.


Could you please help me?


Sorry for my english

Link to comment
Share on other sites

Using an apostrophe in product names is probably not the best idea. But if you consider it as a must, have you recompiled your template file?

And can we see the source code of your page?


Btw: consider your manual database updates don't have an effect on newly added products.

Edited by Scully (see edit history)
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...