Database Reference
A price list is a reusable set of product prices with its own website scope and customer audience. Its assignments are stored separately so the same list can serve several customers or groups.
| Relationship | Why it matters |
|---|---|
pricesystem_pricelist belongs to one store_website |
Defines where the list and its currency context are valid. |
pricesystem_pricelist_product links one pricesystem_pricelist with one catalog_product_entity |
Stores the product covered by a list entry. |
pricesystem_pricelist_product can use one eav_attribute |
Allows a configured product price attribute to supply the list value. |
pricesystem_pricelist_customer assigns a list to one customer_entity |
Supports negotiated lists for individual customer accounts. |
pricesystem_pricelist_group assigns a list to one customer_group |
Reuses a list for an entire Magento customer group. |
Assignment and product records belong to the parent price list. Use Magento Admin, the import add-on or the module API so validation and price cache invalidation are handled correctly.