Migration limitation for certain order-level promotions

When you create promotions in , 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 user interface.

In , 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 . 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 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 ; you cannot edit them. Do not use 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 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;