Product listed in subcategory but not in parent category [1.7.5.x]

[Maths]

Hello,

I exported a list of products from one prestashop to another, but the list came only with the subcategories, and I had already registered the categories and subcategories on the site. The products linked with the subcategories, but not with the father category.

If anyone could help me, I'd like to know if there is some way to connect all the products listed on a subcategory to it's parent category. 

There is an example attached

Edited August 29, 2019 by Maths (see edit history)

[ApoA]

hi,

try checking also the parent category

[CedCommerce Team]

12 hours ago, Maths said:

Hello,

I exported a list of products from one prestashop to another, but the list came only with the subcategories, and I had already registered the categories and subcategories on the site. The products linked with the subcategories, but not with the father category.

If anyone could help me, I'd like to know if there is some way to connect all the products listed on a subcategory to it's parent category. 

There is an example attached

HI,

There are 2 ways to accomplish your need 

First you need to select parent too while selecting child categories 

Or you can get some custom code, add parent category too while saving products for assigned child categories 

For existing we can update it by custom queries using a php script.

You can check {{ YOUR DB PREFIX }}_category_product table and understand the relation 
 

Kind Regards

[helderv]

Same situation here... Any solution? How did you solve it?