Use a price-type sort order

Sort order is useful when one source should always outrank another, regardless of the numeric values.

In Price Priority Order, place the authoritative price type first. Price System walks down the list and uses the first type that has a valid value for the current context.

For example:

  1. Customer Price
  2. Price List
  3. Product-Customer Matrix
  4. Category Price
  5. Magento catalog rule
  6. Original price

If Customer Price has no valid row for the requested quantity or date, the next available type is considered.

Advanced Config can replace the global order for a customer or customer group. Keep those exceptions rare and document why they exist; otherwise two customers with similar assignments can be difficult to compare.