moving multiple products from categories

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

Hi,

HikaShop does not have such moving features.
A product can have several categories so, there is no such "moving" features.

Regards,

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.

Hi,

Solution 1 : use "display all sub elements" and not "display direct sub elements" in the product listing.

Solution 2 : use a MYSQL query in PHPMyAdmin in order to change category_id in the table #__hikashop_product_category.

Regards,

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

Hi,

You can do something like: Just replace "10" by the new category id and "20" by the old category id.
It would "move" every product in the category 20 to the category 10.

Regards,

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