Zen Cart Logo
Forums / Basic Configuration / Moving multiple products at a time

Moving multiple products at a time

Locked

Views: 1,940

Results 1 to 7 of 7
This thread is locked. New replies are disabled.
21 Oct 2006, 7:26 PM
#1
iwebgeek avatar

iwebgeek

New Zenner

Join Date:
May 2006
Posts:
43
Plugin Contributions:
0

Moving multiple products at a time

I've tried searching for this but to no avail.

I've got quite a large number of products (300+) and I'm setting up a new structure of categories to make browsing much more smoother and efficient.

I want to move the products into their new categories, but the only way I see how to do it is click on each individual product's M and choose the new category.

Is there a way to move them in batches? I know some of you will suggest renaming their current category, but I'm moving some products into different areas for better relativity, so I can't just simply rename the category and leave it at that.

Any suggestions?

23 Oct 2006, 3:51 PM
#2
iwebgeek avatar

iwebgeek

New Zenner

Join Date:
May 2006
Posts:
43
Plugin Contributions:
0

Re: Moving multiple products at a time

Bump.. need a solution to this asap

23 Oct 2006, 4:25 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Moving multiple products at a time

Are all the products that you want to move to a new category in another category?

As in are you trying to move all products in categories_id 32 to categories_id 37 ...

25 Oct 2006, 6:27 PM
#4
iwebgeek avatar

iwebgeek

New Zenner

Join Date:
May 2006
Posts:
43
Plugin Contributions:
0

Re: Moving multiple products at a time

Well, let's say there are a bunch of about 10 products in a category/subcategory. I want to move those 10 products to a different category all at once.

25 Oct 2006, 7:26 PM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Moving multiple products at a time

If all the products in a category need to be moved you can do it but if it is just some products in a category it is best to do one by one ...

This is on the list for thing to do for a future release ...

23 Feb 2007, 4:49 PM
#6
ctcentralinfo avatar

ctcentralinfo

Totally Zenned

Join Date:
Apr 2005
Posts:
853
Plugin Contributions:
0

Re: Moving multiple products at a time

I have about 30,000 products in one store, I hope that I will be able to move multiple products soon in the next upgrade.

15 May 2007, 9:20 PM
#7
eddierosenthal avatar

eddierosenthal

New Zenner

Join Date:
May 2007
Posts:
19
Plugin Contributions:
0

Re: Moving multiple products at a time

there should be an easy way to do this using just sql in the database.
each product is connected with a product id to several other tables,
including category. there is one table that joins both category and product, i think it's called category_2_product. by updating that table and maybe one or two others you should be all set. suggest you ask the zen cart people to provide you with an sql update query you can use. always back up your database first, by either exporting it to your desktop or some other means...