Forum management
- Threads started by me
- Threads I participate in

Developer forum

Variant integration - question about the data

Gaëtan Di Caro

Posted on 25/01/2017 14:31:34

Hi,

I'm integrating some variants but I got a bit confused...

Let's say I have product n°1234 available in 2 sizes (M, value 01, and L, value 02), and 2 colors (red, value 10, and blue, value 11). With extended variants that's 5 lines in all in the database.

What values should these field hold for each of the lines in the database : ProductID, ProductVariantID, ProductNumber ?

Replies

Dmitriy Benyuk

Posted on 27/01/2017 08:16:38

This post has been marked as an answer

Hi Gaëtan,
the ProductID and ProductNumber can be the same for all. The ProductVariantID can be a combination of your variants IDs separated by dot ".". For example:
ProductVariantID "01.10" means that you have a product size: M and color: Red
ProductVariantID "01.11" means that you have a product size: M and color: Blue
ProductVariantID "02.10" means that you have a product size: L and color: Blue
etc
For the main product the field "ProductVariantID" should be empty.

Regards, Dmitrij

Votes for this answer: 1

Gaëtan Di Caro

Posted on 03/10/2017 11:21:51

The ProductVariantID can be a combination of your variants IDs separated by dot ".".

Does it mean that it must ? Or does it simply serve as a unique identifier of this specific product variant ?

Nicolai Pedersen

Posted on 03/10/2017 11:28:12

This post has been marked as an answer

If you have variants on more dimensions, it has to be optionFromDimension1.optionFromDimension2 - . i required. Option IDs cannot contain .

Votes for this answer: 1

You must be logged in to post in the forum