Rank: Member
Joined: 8/22/2013(UTC) Posts: 11 Thanks: 4 times
|
I would like to re-assign the parent categories and I don't see a way to accomplish this.
Note the goal is not to simply rename, but to move categories within the hierarchy. An example would be a category (with or without subs) being moved from a "root" category to itself being a sub --- as part of a re-grouping of products within a store.
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,393 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
Presently this can only be achieved via SQL. You need to change a category's ParentId field. A ParentId value of "0" indicates a top-level category. Otherwise the ParentId presents the bvin value the parent category. So, to move a category from the root level (i.e. ParentId = 0) to be a sub-category of another category, start by finding the bvin value for both categories. You can do this via a SQL query or by editing each category in the admin and grabbing the bvin from the query string of the URL. Once you have bvin values you'll need to run a SQL query like this: Code:
UPDATE bvc_Category
SET ParentId = 'bvin-of-new-parent-category'
WHERE bvin = 'bvin-of-category-that-you-want-move'
|
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
1 user thanked Aaron for this useful post.
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.