Redwood: Apply Promotions According to Items on Sales Orders

Before Update 25A, you could create a promotion according to whether the line was eligible for the promotion, such as the quantity or shipping address on the order line. You can now use another item on the sales order to determine whether to apply the promotion. You can apply a simple discount, tiered discount, or a free item.

For example:

  • Buy at least 1 Modern Standard Door and at least 2 Bay Window, then get 10% off any item you buy that's in the Modern Standard Windows category.

A new column for Additional Buy Items is now available on the promotion line

Try it:

  1. Create a 10% discount for any purchase that you make from the Modern Windows category:

10% Promotional discount on modern windows

  1. Click the link in the Additional Buy Items column, and then add a rule for the windows and doors:

Additional buy items

For the windows, this rule says:

Total Buy Item Quantity Greater Than or Equals 2 
Item is one of Bay Window 
Unit of Measure is one of Each

And then for the doors:

Total Buy Item Quantity Greater Than or Equals 1
Item Category is one of Modern Standard Doors
Unit of Measure is one of Each

Click Additional Buy Items, then select from a list of attributes:

  • Currency
  • Item
  • Item Category
  • Total Buy Item Amount
  • Total Buy Item Quantity
  • Unit of Measure

More Examples

  • Buy a coat and a matching scarf, then get 15% off any of the items that you buy from the Accessories category.
  • Buy a laptop, mouse, and keyboard, then get 30% off the 24" Monitor item.
  • Buy a laptop and monitor, then get 10% off the Leather Laptop Bag item and 15% off the Groovy Keyboard item.
  • Buy $1,000 worth of items from the Hardware category, then get $5 off each item that you buy on the sales order.

Not Supported

  • Buy 1 coat and get 15% off only 2 items from the Accessories category.
  • Get 60% off books for every quantity of 2 of pens that you buy. For example, if you buy 4 pens, you're not going to get a 120% discount on books.

Use other items from your inventory to promote sales.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Order ManagementNo Longer Optional From: Update 25C

Tips And Considerations

You must not use the For Every Amount attribute or the For Every Quantity attribute with a simple or tier discount. If you must aggregate, use Total Buy Quantity or Total Buy Amount.

If your rule has a condition for:

  • Item or item quantity. You must include a condition for the unit of measure.
  • Item amount. You must include a condition for the currency.

You can click Validate to make sure you set your rules up correctly.

If you apply the rule for:

  •  A specific item. Pricing will apply the discount on all order lines that have that item in the sales order. Assume your order has 5 lines. If you apply a discount on the Glorious Bouquet item, and if order lines 1, 3 and 5 have the Glorious Bouquet, then Pricing will apply the discount only on lines 1, 3, and 5.
  • All items. Pricing will apply the discount on all items on all 5 lines.

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Manage Draft Pricing Promotions (QP_MANAGE_DRAFT_PRICING_PROMOTIONS)
  • Manage Pricing Promotions (QP_MANAGE_PRICING_PROMOTIONS)
  • View Pricing Promotions (QP_VIEW_PRICING_PROMOTIONS)
  • Activate Pricing Promotions (QP_APPROVE_PRICING_PROMOTIONS)
  • Manage Dynamic Rules (QP_MANAGE_DYNAMIC_RULES)
  • Manage HCM Rules (HRC_MANAGE_HCM_RULES_PRIV)
  • Manage File Import and Export (FND_MANAGE_FILE_IMPORT_AND_PRIV)