EasyPopulate 4.0 Support Thread

[mrcastle]

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

[mc12345678]

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.

[mrcastle]

My apologies, the answer is within the ZenCart posts but I didn't understand it the first time through. For anyone else trying to do the same thing, you select the category, and then use copy function. At the bottom of the screen you will see a "multiple categories link manager". As a suggestion, perhaps it might be easier to find this feature under the tools menu ? Anyways, it is a very clever app and (once you understand it) and it works without any problems. For myself, I was able to move hundreds of items into new categories just by entering the current category number and then the new category number to replace it with. As always, make SURE you backup your database using the backup wizard.

[mc12345678]

My apologies, the answer is within the ZenCart posts but I didn't understand it the first time through. For anyone else trying to do the same thing, you select the category, and then use copy function. At the bottom of the screen you will see a "multiple categories link manager". As a suggestion, perhaps it might be easier to find this feature under the tools menu ? Anyways, it is a very clever app and (once you understand it) and it works without any problems. For myself, I was able to move hundreds of items into new categories just by entering the current category number and then the new category number to replace it with. As always, make SURE you backup your database using the backup wizard.

Yes, there is more than one way to accomplish something. That particular additional tool is accessible off of at least the tools/area of copying a product, when in the attributes controller with a product within a category "shown", or in the products price manager (found in the catalog menu).

Specifically to your issue if all product in question existed only in the miscellaneous and in the designated composer folder, then delete all rows in the file that had the miscellaneous category. Enter 7 in the products status field in the first row, copy that down to the end of the data, save the file (suggest modifying text towards the end so that still have the original file) upload and then import, would have been done. But glad that you found a way that didn't take too much time.

[aurum.genesis]

Can I do this https://www.zen-cart.com/showthread....-Bulk-Products through the help of easy populate? Thank you for the advice.

[mc12345678]

Can I do this https://www.zen-cart.com/showthread....-Bulk-Products through the help of easy populate? Thank you for the advice.

Yes, but I suggest working with EP4 (or any such software) in a test environment first to understand what is needed and how it works. The hardest part of using EP4 is working with whatever editor to save the file in a suitable UTF-8 CSV format. EP4 simply provides the doorway between the database and the data file.

A couple of things would be needed/needed to be done to accomplish the described task: product added to store, attributes made to exist in the store and detailed information applied to all of those.

Take a moment to read through the instructions. There are a lot more concepts than just press button, watch action that are described.