Create a matrix

Open Pricesystem > Product Customer Matrix > All Matrix Prices and add a matrix.

Define the price

Enter a Name, Quantity, Price, Price Application Type, Website, optional Valid From/Valid To dates and a Priority. Relative surcharges and discounts can use a selected Price Attribute as their base.

Select products

Add one or more product conditions. A condition contains a source, operator and value. Supported sources include product attributes, SKU and category IDs. Operators include equals, not equals, in list and not in list.

Use AND when every condition must match. Use OR when any condition is enough. Start with one condition and confirm its product set before adding more.

Select customers

Choose either or both methods:

  • assign individual customers directly, optionally with assignment dates;
  • enter the customer-attribute value that should match the configured attribute.

You can also assign matrices from the other direction: the customer edit form contains a Product Customer Matrices Assigned by Customer Relation section with an Add-Matrix dialog and Assign/Unassign actions. Managing assignments there requires the dedicated Admin permission MageB2B_PricesystemProductCustomerMatrix::customer_save.

Matrix dates, website, product conditions and customer assignment must all be valid for a price to apply.

Test the matrix

Test a matching product and customer, then test one product and one customer that should not match. Check the exact quantity threshold and one unit below it. If several matrices match, test the configured priority mode.