Tuesday, January 25, 2011

Policy For Stacking Shipping promotions

If you have a client that requires multiple shipping promotions to be applied on an order.
By default there can only be 1 shipping promotion applied on any order.

1). update px_policy set status = 1 where name in ('Shipping: Any order item can only participate in one promotion') and store_id = STORE_ID
2). Get the xmlparam data for this policy: select xmlparam from px_policy where name in ('Shipping: Any order item can only participate in one promotion') and store_id = STORE_ID
3). Update the xmlparam
Before:
<PromotionPolicy impl="com.ibm.commerce.marketing.promotion.policy
.EachItemCanParticipateInPromotionOncePolicy"
&.......;/StoreKey></PromotionPolicyKey><Status>Active</Status></PromotionPolicy>
After:
<PromotionPolicy impl="com.ibm.commerce.marketing.promotion.policy.
EachItemCanParticipateInPromotionOncePolicy"&
.........;</StoreKey></PromotionPolicyKey><Status>Inactive</Status></PromotionPolicy>

4). restart the server
Posted by at

2 comments:

  1. Liam HorsemanApril 8, 2013 at 10:09 AM

    This is very informative and briefly detailed. Thank you for this shipping promotion!

    ReplyDelete
  2. ABAugust 23, 2013 at 3:29 AM

    the default is blank i.e. there is no active/inactive. how is no-value interpreted.

    ReplyDelete

Subscribe to: Post Comments (Atom)