• Toll-free  888-665-8637
  • International  +1 717-220-0012
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

SPCteam
#1 Posted : Thursday, October 24, 2013 3:50:34 PM(UTC)
SPCteam

Rank: Member

Joined: 8/22/2013(UTC)
Posts: 11
United States

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.
Aaron
#2 Posted : Thursday, October 24, 2013 7:11:47 PM(UTC)
Aaron

Rank: Administration

Joined: 4/2/2004(UTC)
Posts: 2,393
United States
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.

©2024 Develisys. All rights reserved.
  • Toll-free  888-665-8637
  • International  +1 717-220-0012