Database Reference
Product Customer Matrix separates the price rule from the product conditions and direct customer assignments that make the rule eligible.
| Relationship | Why it matters |
|---|---|
pricesystem_product_customer_matrix_attribute belongs to one pricesystem_product_customer_matrix |
Defines the product attributes, categories or identifiers matched by a matrix. |
pricesystem_product_customer_matrix_customer assigns a matrix to one customer_entity |
Gives a named customer direct access to the matrix price. |
| A matrix customer-attribute value is matched against the configured customer attribute | Allows one matrix to apply to customers that share a business attribute without creating individual assignments. |
The matrix itself contains the commercial rule, including website, validity, quantity and priority settings. Use the matrix editor, import add-on or APIs for updates.