Variant combination order does not match

Gaëtan Di Caro

Posted on 31/01/2017 07:45:39

Hi,

I'm having problems integrating variants. My data source seems correct (see screenshot), I have the variant options in the same order as my variant groups. However, when I integrate and go look at the ecom, I'm greeted with this error message : " Variant combination order does not match. Expected order is Size,Colour. Current order is Colour(20096)"

I notice that the table [EcomVariantOptionsProductRelation] does not contain these variants... The VariantGroups and VariantOptions tables have been filled correctly.

I'm using 9.1.6

Thanks

2017-01-31_07_21_15-SQLQuery8.sql_-_192.168.16.80_sql2012.PIMCommerceDIT_(PICOPUBLISH_gdc_(78))__-_M.png

Replies

Dmitriy Benyuk

Posted on 31/01/2017 17:50:17

Hi Gaëtan,
could you check this video https://vimeo.com/album/2042889/video/57368733 and the http://doc.dynamicweb.com/forum?M=BasicForum&PID=1605&ThreadID=32062
regarding variants import? This should help
Regards, Dmitrij

Gaëtan Di Caro

Posted on 01/02/2017 07:56:02

Yes I have seen both and I still don't get what's wrong with my data.

Dmitriy Benyuk

Posted on 01/02/2017 13:19:58

HI Gaëtan,
I need to get more information to answer your problem. Could you attach your data integration job xml file and the source xml file(if you are using XML as a Source)?
Regards, Dmitrij

Gaëtan Di Caro

Posted on 01/02/2017 13:43:05

I'm using an sql with Views source, but attached are the csv files with my data.

Dmitriy Benyuk

Posted on 02/02/2017 09:02:48

This post has been marked as an answer

Hi Gaëtan,
The problem is the wrong comma separator you have used in the products.csv/your sql view table. In your case it is the following:

products.csv:
ProductVariantID
20093,20096

VariantOptions
20093,20096

but it needs to be the dot "."
20093.20096
for both columns.

See the attached csv file which worked for me.
This needs to be the dot so the values in the [VariantOptionsProductRelationProductId] table will have the fine format after the import, see the attached image.
Regards, Dmitrij

product.csv

Votes for this answer: 1

Gaëtan Di Caro

Posted on 02/02/2017 13:04:00

Ok I changed it to a dot and it works... Did it change ? We have solutions on 8.x versions where we use a comma and it integrated fine.

Dmitriy Benyuk

Posted on 02/02/2017 13:05:44

No, the dot as a separator was not changed

Gaëtan Di Caro

Posted on 03/02/2017 12:53:24

Ok after modifying the program which fills my data source to use the dot, I wondered why it suddenly didn't work. Turns out that the variantgroups separator is comma, but the variantoptions separator is dot...

I could have used a bit more consistency, or at least a bit more clarity in the documentation or errors...

You must be logged in to post in the forum

Developer forum

Variant combination order does not match

Replies