Price list hierarchy

In a price list hierarchy, prices are searched for in reverse hierarchical order.

The following figure shows a price list hierarchy.

Price list hierarchy graphic"

In the price list hierarchy shown above, prices are searched for in reverse hierarchical order, at the lowest level of the region first, then up the hierarchy. For example, if Sterling Order Management System Software is searching for a price list for Item 3 and the store organization on the order is Store 235, it looks first at Store 235. If the price is not found, the search for Item 3 goes up to the California region, then the West Coast region, and then finally to the Enterprise level, which does have a price of $100. If a store defines its own price lists for certain items, such as when Store 235 defines Item 2’s price at $65.00, the search does not go up the hierarchy if it is found at the store level.

If the following two price lists were added to the lists above, Item 3 could have an even lower price for Gold Customers ($80.) or for Employees ($65.).
  • Gold Customers – Price List 5
    • Assignments:
      • Store: All Stores
      • Customer: Gold Customers
        • Item 3 - $80.
        • Item 5 - $90.
  • Employees – Price List 6
    • Assignments:
      • Store: All Stores
      • Customer: Employees
        • Item 3 - $65.
        • Item 5 - $85.

This search behavior is governed by the way you configure precedence. In the previous price list example, if the customer happened to be a Gold Customer and also an Employee, Sterling Order Management System Software would pick the lowest price of the two, provided that precedence was defined as the third option, "Consider both and choose the lowest priced price list."