Developer forum

Forum » PIM » Issue when importing products from BC

Issue when importing products from BC

Joseph Vause
Reply

Hello, we are using the default blueprint from your DynamicWeb 10 Documentation.

The end client has started to create variants in DW10 (they dont have any set up in BC) and when we try and do a delta replication from BC we get the following error

 

Error: The input string '' was not in a correct format.Couldn't store <> in ProductVariantProdCounter Column.  Expected type is Int32. Stack:    at System.Data.DataColumn.set_Item(Int32 record, Object value)    at System.Data.DataRow.set_Item(DataColumn column, Object value)    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomDestinationWriter.UpdateFieldsInExistingProductsWithVariantIDs(String keyColumn, Mapping mapping)    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomDestinationWriter.UpdateFieldsInExistingProductsWithVariantIDs()    at Dynamicweb.DataIntegration.Providers.EcomProvider.EcomProvider.RunJob(Job job). System.ArgumentException: The input string '' was not in a correct format.Couldn't store <> in ProductVariantProdCounter Column.  Expected type is Int32.

I have tried to set the default value to 0 but that doesn't seem to do anything.

Is there a setting in the Ecom Provider i need to set? or something else that needs mapping?

Thanks


Replies

 
Brian Fredrick Ahlmann Boyles Dynamicweb Employee
Brian Fredrick Ahlmann Boyles
Reply

We will investigate and return with an answer

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Reply

Hi Joseph,

This has been fixed with version 10.7.1 of the EcomProvider.

BR
Snedker

 

You must be logged in to post in the forum