Search on admin catalog

[cronempower]

Hello i'm new in prestashop and i installed 1.7.2.2 . 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

[Scully]

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 October 6, 2017 by Scully (see edit history)