Developer forum

Forum » Integration » Problems importing with Ecomprovider

Problems importing with Ecomprovider

E-mail notifications
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply
Posted on 14/08/2021 18:48:21

Hi guys,

I have a situation where I need to import several products with variants.

I have prepared a file, based on the export I previously made after manually configuring a product.
Everything works well except for VariantGroup and groups assignment.

In my case, I have included the ProductID, GroupID, VariantGroupID and VariantOptionsID in the file.

However, the data imported in the EcomVariantGroupproductRelation seems to ignore my supplied IDs and instead is using ImportedProductIDxxx. Which obviously messes up the entire setup of the products.

For Groups allocation, there is nothing imported.

I am not sure if there is something wrong with my setup, my file or something wrong in the EcomProvider. I have imported products before without any issues.

I was initially using 9.10.8 but I have upgraded to 9.10.13 just in case something was wrong in my version.

I have attached my file in case somebody wants to look at the data structure.

Thank you,

Adrian


Replies

 
Scott Forsyth Dynamicweb Employee
Scott Forsyth
Posted on 15/08/2021 19:50:40
Reply

Hi Adrian,

What happens if you also include VariantOptions, VariantGroups and ProductVariantId. The two Variant* fields are the special fields which create the related table data. ProductVariantId is still required and should be the same value as VariantOptions.

You mentioned VariantGroupId and VariantOptionsId and I'm not sure which fields they are, but hopefully the clue above in enough.

Thanks,

Scott 

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 16/08/2021 09:45:28
Reply

Hi Scott,

I already have them in.

I have also tried splitting theimport in 2 parts. First import all definitions (EcomGroups, EcomVariantGroups, EcomVariantOptions and then importing EcomProducts and EcomVariantOptionsProductRelations.

I got the same result. The Groups are not recognized and the import in EcomVariantGroupProductRelations is based on ImprtededPRODUCTxxx instead of the actual ProductID.

So far, it seems like a bug to me, but I may be wrong.

Adrian

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 16/08/2021 11:55:59
Reply

Hi Adrian,
that is a bug of type casting from ProductId (double) in Excel file to ProductId (string) in Dynamicweb,
so it can not find the propriate product id due to that.
Somehow it treats the Excel ProductId column as double, maybe you can try to change its type in Excel as a workaround.

Could you also download the dll with a bug fix and try with that?

BR, Dmitrij

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 16/08/2021 12:44:27
Reply

Hi Dmitrij,

Thank you for the solution.

I have downloaded the DLL and updated my bin and I have also changed the ProductID from 362 tp Product362.

And IT WORKED!

Thank you very much for this solution.

I assume the fix will be applied to future versions automatically.

Thank you,
Adrian

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 17/08/2021 11:31:29
Reply

Hi Adrian,
yes, it is released in the EcomProvider 5.0.6
BR, Dmitrij

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Posted on 17/08/2021 11:37:03
Reply

Great!

Thank you very much.


Adrian

 

You must be logged in to post in the forum