Quote Originally Posted by mrcastle View Post
Hi, I'm trying to figure out how to remove one of two categories selected for several items using EP4 All of the items were originally placed in the category "miscellaneous" but since then I have created more specific categories like "Bach" "Bartok" "Beethoven" etc. When you do a search on "miscellaneous" all of the "Bach" "Bartok" "Beethoven" items are still listed. So I want to remove them all from the "miscellaneous' category and just have them in their own unique category. I think using EP4 may save me several hours of doing this one by one. Please note: all of those items are using "miscellaneous" as the master category, so I would need to somehow change master category first. Thx
Actually, if the master category is currently associated to the product and it is desired to remove them from that category, then it takes a little bit of logic/thought, but it is simple.

Here are two scenario that would work to remove a product from a category *AND* ensure maintaining a master_category.

If the standard output file that shows linked product is reviewed (sorted at least by the primary key) and there are two or more entries for the product: then either 1) remove the row that includes the row having the category that is the current master_category which is supposedly also the one from which to remove the product or 2) be sure that the category from which it is to be removed is in a row above/before the one in which it is to end up/stay.
Change the products_status to a value of 7 for the row that contains the category to which to change to master_category. This will perform two things. 1) it will change the master_category of the product to the category assigned for that row and will remove the product from the category from that which was identified as the master_category for the product.

If the product is not linked (only one record in the linked product export of a full set of the database, then simply changing the products_status to 7 and the category assignment to that desired will assign the product to the category and update the master_category to be that of the same and will remove the product from the previous master_category.

There are a number of ways to evaluate, discover, etc.. information related to the above, but as said, basically the product status of 7 will assign the current row's category as the master category and remove the product from the previous master_category. So there are a number of swaps that can be made to remove the product from each linked category by assigning the product to a new master category. Any record that follows the last status change to 7 will be added/updated to reflect the data on that row.