To populate multi-select attributes in Magento the values must be separated by semicolons


For example: White;Black


If you setup multiple fields in Counterpoint and want to combine these fields into a a list of values separated by semicolons you can use the following SQL code:


STUFF(COALESCE ('; ' + A.DIAMOND_COLOR1, '') + COALESCE (';' + A.DIAMOND_COLOR2, '') + COALESCE (';' + A.DIAMOND_COLOR3, ''), 1, 2, '') AS DIAMOND_COLOR