Symptom

 

Ambiguous column name 'MIX_MATCH_COD'.  Conversion failed when converting the varchar value 'Ambiguous column name 'MIX_MATCH_COD'.' to data type int.


When exporting products using the USR_MAG_ITEM_EXP_RUN procedure.


Cause

 

Item export control configuration value.


Solution

 

Remove IM_ITEM. prefix from field name


i.e. IM_ITEM.DESCR -> DESCR



Applies To

 

Commerce5 product export