moving multiple products from categories

how can you move multiple products from one category to another, is this possible?

after some feedback from testing users have said I have too many categories on my site,

for example
> Condiments > (Sauces, chutney etc) >Fruit Sauce > Colmans > Colmans Apple Sauce (250ml)

there's 4 steps (or mouse clicks) here to get to the product , what i need to do I make it easier for users. I want to place the product in just the condiments category. As there are over 3000 products I cant do this one by one. Can you recommend as in this example I just need to move the Apple sauce product into the condiments category.

solution 1 just shows all products , not really what i need, i just want to reduce my subcategories

solution 2 - have no knowledge of sql queries

surely there must be an easier way? why cant you select multiple products and change category without resorting to sql queries and programming?

even if a product belongs to multiple categories you should at least have the option of overriding this. I really need an easier solution.

hope you can advise

thanks, where would i insert this code

Hi,

You'll just have to use this code through your "phpmyadmin".

got this error when trying to run above:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Hi,

Do you have replaced "#_" by your database prefix ?

sorry where do i find the database prefix?, sorry not familiar with SQL and PHP

i attach a screenshot is it myhcw_hikashop_product_category ?

Yes.

that worked thanks