I can't assosicate my products to other categories...

[ldx1202]

Hello, i'm totally newb to prestashop and i am not a native english speaker but recently i met one problem which i couldn't fine a solution in my mother language forum so i decide to search the answer here.

 

My problem:

After the creation of several categories (not sub-categories in the "home" category) in the root of "category" option, i wanted to associate my products to the categories i created.

Unfortunately in the "associate" option i can only associate my products to the "home" category. The category tree only shows the "home" category is avaiable.

 

I have no idea what's happening but i failed to find the solutions on forum, please help me. Big thx.

[Constantino]

Hello,   ​

 

You can assign multiple products to any category just moving them with drag and drop feature available in the application called Store Manager for Prestashop. It has option "Assign categories" and you can add product to certain category or change it and assign products to some other category (one or many).

You can also use this guide, designed to help you better manage this task: http://www.prestashopmanager.com/useful-articles/how-to/how-to-assign-multiple-products-to-categories/  

 

SM is well worth trying. It's free to use for 30 days.

Edited May 30, 2014 by Constantino (see edit history)

[oscardwc]

LDX, did you figure this out? I am having a similar problem and it is driving me crazy!

 

Thanks in advance.

[jennywill]

Yes we have the same problem!!  PS 1.5.6.2 Fresh install imported category and product data.  The category tree is visible and functional under Categories.  I can create a new category and assign it within the category tree, and I can edit a category and change the category within the tree.

 

Under products I can filter by category.

 

I can also see the category tree on the front end navigation and it is functional for navigating the site through the category structure. 

 

However, when I go to edit a product, or add a new product, the associations tab does not show the category tree.  It only shows the home check box and the default drop down with the correct default category.  I can not change a product's category, nor can I assign any new product to anywhere else but home.

 

Until I press Save & Stay and then refresh, then voila! the category tree will appear on the associations page.  Now I can assign a new product or change an existing product. 

 

Please do not reply to go through and re-save all of my products because we have 48K of them - so not feasible. 

 

I have the rows in category_group and category_shop as suggested elsewhere.  I also have a very extensive category tree so resetting everything to have home as the parent isn't an option. 

 

Note that simply changing the date in the database so it 'appears' that the product was updated doesn't work either.  

 

Also a note that re-installing the shop and re-importing the data brought the problem with it, and everything was fine on the re-install until the data was brought over, so it has to be something off in there.   

 

What else in the Save & Stay action could be happening to correct the view of the category tree on the associations tab where I can fix it 'en masse'??? Any thoughts or help with this would be great as we do not want to go much further and risk more re-work if it can be fixed.  

 

Thanks in advance!  Jenny