copy all products from one category to another (not linked)

26 Oct 2011, 2:16 PM

Zen Follower

Join Date:: Jun 2008
Location:: Sheffield South Yorkshire
Posts:: 165
Plugin Contributions:: 1

copy all products from one category to another (not linked)

Hello,

I have a site and I need to copy all the products from one category to another. I dont want to link them and id rather not install any extra modules.

If the products dont have any attributes could a mysql staement be used? or am i missing something? if so can anyone help with this?

p.s. i have a full backup so i can play about!

Want to switch servers? see our how to migrate Zencart guide
Supercharge your website with our **Fast Zencart Hosting**

26 Oct 2011, 2:49 PM

gjh42

Black Belt

Join Date:: Jul 2005
Location:: Upstate NY
Posts:: 21,876
Plugin Contributions:: 8

Re: copy all products from one category to another (not linked)

How many products are in the category? You can copy/duplicate them one at a time in Catalog > Categories/Products > product listing > click (c) button. I don't know of a mass duplicate function. A SQL statement to move them all (if possible) would have to come from someone more experienced in mySQL.

Glenn . . . Future Relics Jewelry, NY Faerie Festival
Categories Dressing, Images for Titles, Smart Backgrounds, Additional Img Titles, Flexible Attributes, Ezpages Footer Columns, Model List...