BV Commerce Forum
»
BV Commerce Support
»
General Support
»
What Table in BVC5 SQL holds the relationships between Product and Product Variations?
Rank: Member
Joined: 8/25/2007(UTC)
Posts: 124
|
What Table in BVC5 SQL holds the relationships between Product and Product Variations?
SKU
-- Product Variation SKU
How do these items gets married together.
Thank you.
Also what Column toggles (Active vs Inactive) in SKU Product Table Is this 0 and 1 (1 Being Active)
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
There are several tables and some complex relationships. Not easy to put into a short forum post.
|
|
|
|
|
|
Rank: Member
Joined: 8/25/2007(UTC)
Posts: 124
|
Does version 5.5 now support SKU searching (Product SKU and Product Variation SKU)
I can't find sku numbers in our database. I see the items in our Product Table, but I can not easily find via the Product Search.
|
|
|
|
|
|
Rank: Member
Joined: 8/25/2007(UTC)
Posts: 124
|
What Table in BVC5 SQL holds the relationships between Product and Product Variations? I found what I was looking for. THank you Marcus.
Table: BVC_Products
Columns: BVIN and ParentID
Every item has a BVIN number. Only items with Product Variations have a ParentID (The ParentID is the BVIN number of the parent)
Other question...
Does version 5.5 now support SKU searching (Product SKU and Product Variation SKU) ---> Anyone know the answer to this?
|
|
|
|
|
|
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.