Cant merge product entity due to unique primary keys

Description

When merging product entity, update M_StorageOnHand or M_StorageReservation throws unique primary key error.

Suggested solution:
Quantities of old Product should be added to new Product and then deleted (in case of M_StorageOnHand it is M_AttributeSetInstance,DateMaterialPolicy and M_Locator_ID). After this will remain only records for old product which will not throw any error and could be updated by standard merge functionality.

Environment

None

Attachments

1
  • 24 Sep 2014, 08:54 AM

Activity

Show:

Carlos Ruiz July 27, 2018 at 4:03 PM

Not sure is a good idea to do automatically this in the back of the user.

I think a safer option is that the user must clear the storage of the product being merged.

Tomáš Švikruha September 24, 2014 at 8:54 AM

Added sql update and delete for M_StorageOnHand and M_StorageReservation which will fix error with unique primary keys.

Won't Fix

Details

Assignee

Reporter

Labels

Priority

Created September 24, 2014 at 8:44 AM
Updated September 1, 2018 at 11:01 AM
Resolved July 27, 2018 at 4:03 PM