Developer forum

Forum » Integration » Data Integration - how to import product from excel, to multiple groups

Data Integration - how to import product from excel, to multiple groups

E-mail notifications
Hans Ravnsfjall
Hans Ravnsfjall
Reply
Posted on 12/02/2019 08:28:32

Hi

I have set up a dataintegration using the excel procider as source, and dynamicweb ecom products as destination. Now the problem is, I can´t get the products to end up in the right multiple groups. Let´s say I am supposed to get a product to be placed in these two groups.

 

1. Knives, forks, and spoons

2. Cutlery

 

I have tried setting the column in excel something like this:  "Knives, forks, and spoons","Cutlery"

 

but this ends up putting the product in these groups:

1. Knives

2.  forks

3. and spoons

4. Cutlery

5. Knives, forks and spoons.

 

What am i doing wrong?

 

/Hans

 


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 12/02/2019 09:58:46
Reply

Hi Hans,
the Excel source provider is stripping out the " symbol from the excel rows, so your "Groups" value of  "Knives, forks, and spoons","Cutlery" string is then converted to
'Knives, forks, and spoons,Cutlery' and passed to the Ecom provider and that is why it is not imported correctly.
You could rename your group name to smth like "Knives and forks and spoons" or use the group id value instead or just rename the Group Number to
"Knives and forks and spoons" and use that in the excel file.

Regards, Dmitrij

 

You must be logged in to post in the forum