Hi,
I have a huge # of products (too many to do manually) that need to be moved to new categories. I will then go back and delete the old categories, there are about 40 categories that need to go.
Can somebody show me how I could write a little script I could send thru the SQL Patch that would change the Category ID for all prod in a specific category to a different Category ID?
And maybe a second script that would erase the soon to be empty categories?
++++
My preference would be to search the product DB and do like a Find/Replace.
FIND: Category ID xxx
REPLACE WITH: Category ID yyy
It would be lovely if I could wrap numerous Find/Replace strings into a single statement! If you did a sample that changed 2, I could replicate the syntax to get them all done in one shot.
++++
++++
Alternatively, I have all my Product IDs. So if, because of table relationships, it was necessary to lookup the product first, then alter the associated Category ID, that would work, too. A bit messier, but it could be done, np. Again, if your sample showed how to change 2, I could replicate your syntax to do all the products.
++++
Thank you in advanced! I'm totally desperate here, back against the wall with a huge deadline. I really appreciate you looking at this for me!
Thanks,
Mike
Bookmarks