Migration limitation for certain order-level promotions

When you create promotions in WebSphere Commerce Accelerator, you can choose the exclusivity option Cannot be combined with product promotions in the Combination with other promotions field for certain order-level promotion types. This exclusivity option is not supported in the Management Center user interface.

In WebSphere Commerce Accelerator, the exclusivity option Cannot be combined with product promotions can be selected for any of following order-level promotion types:
  • OrderLevelFreeGift
  • OrderLevelPercentDiscount
  • OrderLevelValueDiscount
  • OrderLevelFixedShippingDiscount

If you have any existing promotions with this exclusivity option selected, the following are migration options to consider:

  1. Perform a complete migration of these promotions. After a complete migration, you can fully manage these promotions using Management Center. The exclusivity option Cannot be combined with product promotions will remain in effect on your storefront after you migrate; however, you will not be able to see this option in the Management Center user interface. If you change to a different exclusivity option, you will not be able to revert back.
  2. Perform a partial migration of these promotions. After a partial migration, you can only activate, deactivate and delete these promotions in Management Center; you cannot edit them. Do not use WebSphere Commerce Accelerator to edit these promotions after a partial migration; however, if you used an external tool for these promotions before migrating, you can continue to use the external tool for editing. At a later date, you can choose to perform a complete migration.
  3. Do not migrate these promotions; as a result, you will not be able to use the Management Center for these promotions and you must continue to use your existing tool.

This exclusivity setting is stored in the PX_PROMOTION database table in the EXCLSVE column; the value 3 corresponds to the Cannot be combined with product promotions option. To see whether you have promotions with this setting, you can run the following database query:

SELECT PX_PROMOTION_ID, NAME FROM PX_PROMOTION WHERE EXCLSVE=3;