Database Reference
Each Customer Price record connects one customer, one product and one website. This is the core relationship to consider when importing negotiated prices from an ERP or pricing service.
| Relationship | Why it matters |
|---|---|
pricesystem_customerprice applies to one customer_entity |
Identifies the customer who receives the negotiated price. |
pricesystem_customerprice prices one catalog_product_entity |
Identifies the Magento product covered by the price. |
pricesystem_customerprice belongs to one store_website |
Keeps customer prices separate between websites. |
pricesystem_customerprice can use one eav_attribute |
Allows an alternative product price attribute to be used where configured. |
Use Magento Admin, the import add-on or the module API for updates. Direct database writes bypass validation and cache handling.