mrcastle:
I have 300 items listed under one main category (Songs) and none of the items are linked. I'd like to add two sub-categories (vocal & piano) under the Songs category. My plan is to use easy populate 4 to remove all of the items and then re-upload them again with the new categories names (Songs^vocal & Songs^piano) I'm sure ZC will give all of these items new id#'s and am just curious if there is anything I'm missing that may cause complications. I'd hate to have to edit each one of them, that's for sure. Thx
While I advocate EP4 (though also have been known to discuss another similar application), the right tool for the right application. I would actually suggest a rather easier route, especially if you are going to be moving aall of the items, or at least all items in a particular category.
Come to think of it, if that is the only aspect you are looking at changing at the moment it probably would be better to just work with the particular tables that need changing instead. I thought basically the products_to_categories table would be the only thing that would need to be changed to actually do the move of the product from it's current category to the new one. I mean, I might suggest using ep4 to download the data, help identify which should go into which of the other two categories, maybe sort the daata in some way, then download the above table and modify it to match the new location(s) and then upload the new data directly into the database.
Okay, I'm sorry, I'm in a heavy programming mentality at the moment, basically, if the products are deleted, then some of the aspects of the customers history will be lost, but at least a huge time savings can be seen over doing it all manually. On the other hand I am still thinking that I thought I saw a way to move objects in an entire category to another. And if that is the case,I would move them all to one of the two new categories, then would use Ep4 to create a linked version to the second category of those items that should be in the second category, then I thought there waas a way to either reset the master category or in a way remove a linked product from a category or something similar, but in either case, do lots of changes in multiple steps rather than sort of two... :)
It'll provide the end desired result of all the products in two new categories as a sub-category to where they were.