disappearing subcategories after set Prestashop multistore

[shikotak]

I use Prestashop 1.7.5.2

I set the Prestashop multistore but after setting up the multistore the subcategories disappear. a developer could restore them in database but it happens again when I change the name of store.

It seems there is a bug in it and after any changing the subcategories disappear.

[musicmaster]

It would help if you could tell us what this developer did to bring them back.

If there is a bug you can report it on Github. Prestashop developers don't watch this forum. So any bug you report here is unlikely to get fixed.

[alaksa]

insert into ps_category_shop
SELECT a.`id_category`,bb.id_shop,0
FROM `ps_category` as a
left join ps_category_shop aa on a.`id_category`=aa.`id_category`
left join ps_category as b on a.`id_parent`=b.`id_category`
left join ps_category_shop bb on b.`id_category`=bb.`id_category`
where a.id_parent>2 and aa.id_shop is null

This will restore subcategories for all shops where main categories are used and have no subcategory assigned to a shop.

[apenimon]

Hi alaksa, would you please mind to tell me how and where to make those changes? Are these need to be done from via Cpanel via Database or is it somewhere from Prestashop back office? Any help would be greatly appreciated. Many thanks

[apenimon]

Hi, just wanted give an update that I solved the issue after playing around with a relatively easier workaround. No need to play with the codes at all. All you have to do simply just disable and re-enable all those sub categories from your BO that doesn't show up at the front end. Steps to follow as below:

-Go to categories under catalog menu

-Navigate to any main category with missing sub-categories

-Disable the missing sub-category by clicking green checked symbol under displayed section, then re-click it to re-enable.

-Apply the same steps for all the missing sub-categories. 

Go to your front end and refresh your website, this should bring back all the missing sub-categories again!