Database Reference
Category Price stores customer-specific and customer-group-specific pricing against Magento categories. The relationships below show how those prices are scoped and resolved.
| Relationship | Why it matters |
|---|---|
pricesystem_categoryprice assigns a price to one catalog_category_entity |
Defines the category whose products can inherit the customer price. |
pricesystem_categoryprice applies to one customer_entity |
Limits the price to an individual customer account. |
pricesystem_categoryprice belongs to one store_website |
Keeps the price within the website where it is valid. |
pricesystem_categoryprice can use one eav_attribute |
Selects a product price attribute when the rule should not use the standard price. |
pricesystem_categoryprice_customergroup links one catalog_category_entity with one customer_group |
Provides the same category-based model for an entire customer group. |
pricesystem_categoryprice_customergroup belongs to one store_website |
Separates group pricing between websites. |
The table intentionally omits storage columns and indexes. Manage prices through Magento Admin, imports or the module APIs rather than writing directly to these tables.