Ambiguous column name 'MIX_MATCH_COD' error when exporting products : Red Rook

How can we help you today?

Modified on: Mon, Jun 12, 2017 at 10:40 AM

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

Did you find it helpful? Yes No