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