Red Rook

If the Customer Synchronization between Counterpoint and Magento is being used and you need to map a customer profile code to a Magento Customer group then the following standard trigger on the Customer Table (AR_CUST) needs to be modified to track changes to customer profile codes.

Trigger on Customer Table: TR_AR_CUST_UPD_ECOMM

The following sections of this trigger need to have the code in red added. In this example we are looking to track changes to the Customer Profile Code 1 field

Note: Please make a backup of this trigger before making any changes

**********************************************

  if not(
      Update(IS_ECOMM_CUST) or
      Update(CUST_TYP) or
      Update(ALLOW_AR_CHRG) or
      Update(CR_LIM) or
      Update(NO_CR_LIM) or
      Update(BAL) or
      Update(UNPSTD_BAL) or
      Update(ORD_BAL) or
      Update(LWY_BAL) or
      Update(CATEG_COD) or
    Update(PROF_COD_1) or
      Update(TAX_COD) or
      Update(DISC_PCT) or
      Update(ECOMM_AFFIL_COD) or
      Update(NAM) or
      Update(FST_NAM) or
      Update(LST_NAM) or
      Update(ADRS_1) or
      Update(ADRS_2) or
      Update(CITY) or
      Update(STATE) or
      Update(ZIP_COD) or
      Update(CNTRY) or
      Update(CONTCT_1) or
      Update(PHONE_1) or
      Update(FAX_1) or
      Update(EMAIL_ADRS_1) or
      Update(COMMNT) or
      Update(SHIP_VIA_COD) or
      Update(CR_CARD_NO_1) or
      Update(CR_CARD_NO_1_ENC) or
      Update(CR_CARD_EXP_DAT_1)
  )
    return

**********************

when
            ( deleted.IS_ECOMM_CUST = 'N' and inserted.IS_ECOMM_CUST = 'Y' ) or
            dbo.fnValuesDiffer(deleted.CATEG_COD, inserted.CATEG_COD)='Y' or
        dbo.fnValuesDiffer(deleted.PROF_COD_1, inserted.PROF_COD_1)='Y' or
            dbo.fnValuesDiffer(deleted.TAX_COD, inserted.TAX_COD)='Y' or
            dbo.fnValuesDiffer(deleted.DISC_PCT, inserted.DISC_PCT)='Y' or
            dbo.fnValuesDiffer(deleted.ECOMM_AFFIL_COD, inserted.ECOMM_AFFIL_COD)='Y' or
            dbo.fnValuesDiffer(deleted.NAM, inserted.NAM)='Y' or
            dbo.fnValuesDiffer(deleted.FST_NAM, inserted.FST_NAM)='Y' or
            dbo.fnValuesDiffer(deleted.LST_NAM, inserted.LST_NAM)='Y' or
            dbo.fnValuesDiffer(deleted.ADRS_1, inserted.ADRS_1)='Y' or
            dbo.fnValuesDiffer(deleted.ADRS_2, inserted.ADRS_2)='Y' or
            dbo.fnValuesDiffer(deleted.CITY, inserted.CITY)='Y' or
            dbo.fnValuesDiffer(deleted.STATE, inserted.STATE)='Y' or
            dbo.fnValuesDiffer(deleted.ZIP_COD, inserted.ZIP_COD)='Y' or
            dbo.fnValuesDiffer(deleted.CNTRY, inserted.CNTRY)='Y' or
            dbo.fnValuesDiffer(deleted.CONTCT_1, inserted.CONTCT_1)='Y' or
            dbo.fnValuesDiffer(deleted.PHONE_1, inserted.PHONE_1)='Y' or
            dbo.fnValuesDiffer(deleted.FAX_1, inserted.FAX_1)='Y' or
            dbo.fnValuesDiffer(deleted.EMAIL_ADRS_1, inserted.EMAIL_ADRS_1)='Y' or
            dbo.fnValuesDiffer(deleted.COMMNT, inserted.COMMNT)='Y' or
            dbo.fnValuesDiffer(deleted.SHIP_VIA_COD, inserted.SHIP_VIA_COD)='Y' or
            dbo.fnValuesDiffer(deleted.CR_CARD_NO_1, inserted.CR_CARD_NO_1)='Y' or
            dbo.fnValuesDiffer(deleted.CR_CARD_NO_1_ENC, inserted.CR_CARD_NO_1_ENC)='Y' or
            dbo.fnValuesDiffer(deleted.CR_CARD_EXP_DAT_1, inserted.CR_CARD_EXP_DAT_1)='Y'
          then 'Y'