Sep 12, 2015
Giuseppe Tripiciano
wrote
If I import some products, the automatic manufacturer created are not showed on the manufacturer page of PS. The reason is that, while they are being added in the ps_manufacturer table, no associated entry exists in ps_manufacturer_lang table. So they are not visible on your website.
For now, the only way to fix this is to go in the backoffice, click on each one fo the manufacturer and simply save them again as they are. This creates the manufacturer_lang entries in db. But if, like me, you have thousand of manufactures this is very annoying.
Can you please fix this?
For now, the only way to fix this is to go in the backoffice, click on each one fo the manufacturer and simply save them again as they are. This creates the manufacturer_lang entries in db. But if, like me, you have thousand of manufactures this is very annoying.
Can you please fix this?
Reply
2 Answers
Sep 12, 2015
Giuseppe Tripiciano
wrote
Quick and dirty fix, run this query on your db to show them:
insert into ps_manufacturer_lang(id_manufacturer)
select distinct id_manufacturer from ps_manufacturer where id_manufacturer NOT IN(select id_manufacturer from ps_manufacturer_lang);
update ps_manufacturer_lang set id_lang = '1';
This assumes you have only one lang (id=1), otherwise you have to run it for each language (query differs a bit).
insert into ps_manufacturer_lang(id_manufacturer)
select distinct id_manufacturer from ps_manufacturer where id_manufacturer NOT IN(select id_manufacturer from ps_manufacturer_lang);
update ps_manufacturer_lang set id_lang = '1';
This assumes you have only one lang (id=1), otherwise you have to run it for each language (query differs a bit).
Sep 15, 2015
Dmytro Grycelyak
agent
wrote
Hello Giuseppe,
Thank you for your report.
We've reproduced the issue with manufacturers and will fix it in the next version of Store Manager for PrestaShop.
Thank you for your report.
We've reproduced the issue with manufacturers and will fix it in the next version of Store Manager for PrestaShop.