Ran into a problem, when combining product in PIM to create variants. If a product already on a user’s favorite list the procedure for combining will fail with following error.
The UPDATE statement conflicted with the REFERENCE constraint "DW_FK_EcomCustomerFavoriteProducts_EcomProducts". The conflict occurred in database "smartpagePIM", table "dbo.EcomCustomerFavoriteProducts".
The statement has been terminated.