Product Import issue with foreign key column
When user is doing product import through xml from one environment to another environment PR_PROD_LN_ID column of S_PROD_INT is not getting populated.
Column PR_PROD_LN_ID is having relationship with S_PROD_LN through foreign key table and with S_PROD_LN_PROD through Primary Inter table. While importing product data from Development to Testing environment, column PR_PROD_LN_ID is having null value and when user is doing search for that product in application then PR_PROD_LN_ID column is getting populated with 'No Match Row Id Found' or with the Row_Id value. Is there any way to get this column updated once import is happening without doing explicite search of that product inapplication.