BV Commerce Forum
»
BV Commerce Support
»
Tools & Downloads
»
OK to add records to bvc_ProductXCategory to work around Category Import bug?
Rank: Member
Joined: 5/2/2005(UTC) Posts: 259
|
Attempting to perform a fairly big import of products, using the Import-Export tool, and running into the problem where Categories aren't imported into BVC.
What I'd like to avoid is having to use the admin tool to manually select the category for every single product, so I'm looking at how to do this directly in SQL (this site's still running on localhost, so it's quick & easy to work on large SQL changes).
Question: Can I do this by just adding the appropriate records to the bvc_ProductXCategory table? My concern is that assigning a category to a product might do something in addition to just creating a record the bvc_ProductXCategory table that I don't know about.
Thanks!
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,381 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
No, that should be all that you need to do. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 5/2/2005(UTC) Posts: 259
|
Aaron, thanks for the verification!
That gives me the ability to perform a reasonable workaround (and saves my weekend too!)
|
|
|
|
Rank: Administration
Joined: 4/2/2004(UTC) Posts: 2,381 Location: Hummelstown, PA Thanks: 6 times Was thanked: 163 time(s) in 158 post(s)
|
I guess one other thing to remember is that you will need to increment the sort order field for products in the same category. If the sort order value is the same for every product, you will not be able to manually sort them in the admin. |
Aaron Sherrick BV Commerce Toll-free 888-665-8637 - Int'l +1 717-220-0012 |
|
|
|
Rank: Member
Joined: 5/2/2005(UTC) Posts: 259
|
Thanks for that update on SortOrder Aaron!
I was working on adding those records this morning, and was just puzzling over what to do with that SortOrder field.
I was just about to post a "what's the SortOrder field do" question here, and viola, you'd beaten me to the punch! You've saved me a good chunk of investigation time!
|
|
|
|
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.