Can I copy all products under one category to another? in bulk?

Can I copy all products under one category to another? in bulk?

i hate clicking on Copy one by one for each product... thakes for ever... any other way to apply in bulk?

Are you trying to "Copy as Linked Products" all Products from one Category to another Category ... or are you trying to "Move" all Products from one Category to another?

I would like to know the same thing. But mostly how to MOVE items from 1 catagory to another in bulk. If there were a way to COPY in bulk one could copy the contents of the source to the target then delete or rename the source catagory.

Thanks

To move ALL Products from one Category to another is done in 3 steps ...

NOTE: Backup your database before using this ...

Go to the Category you want to Move the Products from and click on Copy for one of the Products then click on the Multiple Categories Link Manager button ...

In the bottom of the page you will see:

Global Category Link Changes and Master Category ID Reset
Copy ALL Products in a Category as LINKED Products to another Category ...
Example: Using 8 and 22 would Link ALL Products in Category 8 to Category 22
Select All Products in Category: Link to Category:
Remove ALL Products in a Category that are LINKED Products to another Category ...

Example: Using 8 and 22 would Unlink ALL Products in Category 8 from Category 22
Select All Products in Category: Remove from being Linked to Category:
Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...

Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID
Reset the Master Categories ID for All Products in Category:

First set the Products from the Old Category to the New Category as Linked Products:

Copy ALL Products in a Category as LINKED Products to another Category ...
Example: Using 8 and 22 would Link ALL Products in Category 8 to Category 22
Select All Products in Category: Link to Category:

Next, you need to Reset the Master Categories ID on these Products to the New Categories ID ...

Reset ALL Products in the selected Category to use the selected Category as the new Master Categories ID ...
Example: Resetting Category 22 would set ALL Products in Category 22 to use Category 22 as the Master Category ID
Reset the Master Categories ID for All Products in Category:

Next, you need to remove the Products from being Linked to the Old > Category:

Remove ALL Products in a Category that are LINKED Products to another Category ...
Example: Using 8 and 22 would Unlink ALL Products in Category 8 from Category 22
Select All Products in Category: Remove from being Linked to Category:

Now, go to the NEW Category and all of the Products will have been moved ...

NOTE: if the NEW Category is not the Master Categories ID for all the Products in this New Category then you will need to do some clean up to fix those ...

how to i copy all the products from one category to another . need help ???

hc1501:

how to i copy all the products from one category to another . need help ???

see post #4 in this thread (the one just above yours)

say I have all of my products in one category. Call it All Products.

I am creating new categories that I want to separate those products into.

Is there a way to copy certain products from All Products to their respective categories in bulk?

Is there a "link" field in the database that I can maybe pick out product ID's and change via phpmyadmin?

Thanks!

Ajeh:

To move ALL Products from one Category to another is done in 3 steps ...

NOTE: Backup your database before using this ...

Go to the Category you want to Move the Products from and click on Copy for one of the Products then click on the Multiple Categories Link Manager button ...

In the bottom of the page you will see:

First set the Products from the Old Category to the New Category as Linked Products:

Next, you need to Reset the Master Categories ID on these Products to the New Categories ID ...

Next, you need to remove the Products from being Linked to the Old

Now, go to the NEW Category and all of the Products will have been moved ...

NOTE: if the NEW Category is not the Master Categories ID for all the Products in this New Category then you will need to do some clean up to fix those ...

hi mate where is this button?

Multiple categories link button?

i want to move multiple items from one category to another

The Multiple Categories Link Manager button is located on the C for Copy when you click that on a Product ...

thank you for sharing

Anytime I click the "Multiple Categories Link Manager" button I get taken back to the login screen.

This function worked before the last update as I use it semi regularly.

Hopefully this will begin the pay it forward for all the questions I've asked and for the ones still to come.

I personally am not familiar with the in's and out's of SQL but am much more comfortable with MS ACCESS. This is one reason I choose to use MS Access as my front end. All you have to do is set up a DNS to your SQL Database and viola. I find it much easier to copy, cut, paste, query in Access. And yes you can do bulk updates.

Hope this helps

jbible:

Anytime I click the "Multiple Categories Link Manager" button I get taken back to the login screen.

This function worked before the last update as I use it semi regularly.

What version of Zen Cart are you using? :unsure:

If you go to the Tools .. Developers Tool Kit ... and in the bottom input box enter:
products_to_categories.php

and select Admin ... and click Search ...

what comes up on the version $Id ...

NOTE: do not show your Admin directory name if you quote it ...

Hi there

Can anyone help please...?

Like the questions above mine is very similar.

I would like to copy in bulk products from one catagory to another.

NOT move them ...... but to copy a link into another catoagory.

At the moment i am doing this individually by coppying and then selecting the destination etc.

Is there a way how I can copy the links in bulk ...???

Thank you

Go to the Category that you want to copy so that you can see the Products ...

Click on C, for Copy, on one of the Products and you will see a button for Multiple Categories Link Manager ... click that ...

Now fill in the information down in the bottom for:

Copy ALL Products in a Category as LINKED Products to another Category ...
Example: Using 8 and 22 would Link ALL Products in Category 8 to Category 22 |

                                Select All Products in Category:                    | 
                                Link to Category:                    | 

Ajeh:

Go to the Category that you want to copy so that you can see the Products ...

Click on C, for Copy, on one of the Products and you will see a button for Multiple Categories Link Manager ... click that ...

Now fill in the information down in the bottom for:

Thank you very much for your help. much appreciated.

:D

Want to Copy without them being linked. Suggestions?

cubmanky:

Want to Copy without them being linked. Suggestions?
Can you elaborate on why you want 2 identical sets of products?
There has to be more to this that you are not explaining?

I have a monthly book i'm adding, I have several years of them. SO I started the products as the month plus year. Was just trying to save some time

cubmanky:

I have a monthly book i'm adding, I have several years of them. SO I started the products as the month plus year. Was just trying to save some timeAlso not sure what you are trying to accomplish.
If the cat name is not correct, change it.
Need them sorted different? Change the sort order.
If you want one cat with year and another with month and they will contain the same product(s), they should be linked or you will be dinged for duplicate content.
Perhaps another shot at the explanation?
There are also some possibilities in the Similar Threads section below. / / /