How to update data through Excel Add-In

Hi,

A new field in inventtable is added. I tried to update the new field data through excel add-in but the records did not get published by throwing an error message that the items already exist rather than updating the existing record.

Item number Product.Product number Kit
21SM0156 21SM0156 1
21SM0169 21SM0169 1
BC28515 BC28515 3
BC29053 BC29053 3
BC30376 BC30376 1
BC34076 BC34076 3

Item number Error Messages
21SM0156 Cannot create a record in Item table (RetailInventTable). Item number: 21SM0156. The record already exists. Document Generic document could not be created. Error details: Cannot create a record in Item table (RetailInventTable). Item number: 21SM0156. The record already exists.

Is excel add-in only for insertion and not for updating existing record?

Is there a way to update the new field data ? There are 1800 records to be updated.

Thanks,

Related
Recommended