Developer forum

Forum » Integration » Some trouble integrating variants

Some trouble integrating variants

E-mail notifications
Gaetan Di Caro
Reply
Posted on 04/02/2016 09:08:17

Hi,

 

I'm trying to set up data integration for variants on a solution based on wrap. However I'm having some trouble, it seems that the integration isn't really complete : I can't see the variant groups in the administration, and when I try to see a product's variants I have the same issue. Attached are screenshots of the integration, the administration and the SQL tables.

 

Am I missing something ?

 

Thanks !

 

2016-02-03_10_47_50-Windows_Shell_Experience_Host.png 2016-02-03_10_48_37-Windows_Shell_Experience_Host.png 2016-02-03_11_20_31-Windows_Shell_Experience_Host.png 2016-02-04_09_05_26-Windows_Shell_Experience_Host.png 2016-02-04_09_05_52-Windows_Shell_Experience_Host.png

Replies

 
Gaetan Di Caro
Posted on 04/02/2016 09:08:37
Reply

Last screenshot

2016-02-03_10_47_21-Windows_Shell_Experience_Host.png
 
Dmitriy Benyuk
Posted on 04/02/2016 15:46:56
Reply

Hi Gaetan,
maybe this is a caching problem(which was fixed in some version), you can try to restart the web site or try log-out and log-in again to backend and check if the problem has gone.
What version of Dynamicweb and what destination provider (Dynamicweb or eEcom) are you using?
Regards, Dmitrij

 
Gaetan Di Caro
Posted on 05/02/2016 08:51:23
Reply

I've tried the obvious cache-refreshing solutions but nothing more seems to happen. I'm running 8.7.2.3 and the Destination is Ecom Provider.

Thanks !

 
Dmitriy Benyuk
Posted on 05/02/2016 15:35:59
Reply
This post has been marked as an answer

Hi Gaetan,

try update the column "VariantGroupUnit" with all rows setting to zero "0" in the table [EcomVariantGroups] and restart the web site.
For showing the variants it is needed to fill the table [EcomVariantgroupProductRelation], but it is not availble directly in the EcomProvider(it fills it on the information from EcomProducts VariantOptions and VariantGroups columns).
For importing variants with EcomProvider it is needed to use the columns "VariantOptions", "VariantGroups"  in "EcomProducts" table and filling the values with comma separator,
fx for "VariantOptions": "VO1,VO2". It can be variant option id or variant option name, the same for variant groups id/name.
You can read more about this columns here.

Maybe this can help if you need to use the Dynamicweb provider.

Regards, Dmitrij

Votes for this answer: 1
 
Gaetan Di Caro
Posted on 08/02/2016 07:18:04
Reply

Ah thanks, I set the column VariantGroupUnit to 0 and it did the trick :)

I modified my integration source table so that it gets 0 instead of NULL.

 

You must be logged in to post in the forum