Database Reference

Pricesystem coordinates the installed price providers. Most prices stay in the price-type modules (Customer Price, Price List, Category Price). The tables below are what the Pricesystem packages themselves add or extend.

Pricesystem core

Table / field	What it stores
`customer_group.pricesystem_price`	The group-level discount or price value entered on the customer-group form (Group Price).
`customer_group.pricesystem_price_type`	The application type chosen for the group value.
`pricesystem_price_adjustment_job`	Scheduled price-adjustment jobs (status, scope and target of a pending recalculation).
`quote_item.ps_discount_amount`, `quote_item.ps_applied_pricetype`	The resolved discount amount and the price type that won, stored on the cart line.
`sales_order_item.ps_discount_amount`, `sales_order_item.ps_applied_pricetype`	The same values carried onto the ordered line for reporting.
Customer attributes `pricesystem_price`, `pricesystem_price_type`	The per-customer value entered in the customer form's Pricesystem section.

Pricesystem AdvancedConfig add-on

Table / field	What it stores
`pricesystem_customer_sort_position`	Per-customer ordering of price types used by the configured selection strategy.
`pricesystem_customer_group_sort_position`	The corresponding ordering for customer groups.
`customer_group.priceselect`, `customer_group.price_formula`	Per-group price-selection rule and formula.
Customer attributes `verified`, `priceselect`, `price_formula`, `sortPrice…`	Per-customer selection rules, formulas and explicit sort positions.
Product attribute `discountable`	Whether a product participates in Pricesystem discounting.

Use the price-type modules' reference pages when planning pricing imports or integrations for the actual price records.