Announcement: You can find the guides for Commerce 7.5 and later on the new Elastic Path Documentation site. The Developer Center continues to support Commerce 6.13.0 through 7.4.1.Visit new site

Price database schema

Price database schema

price_lists_schema.png

The following database tables are used to store Pricing:

  • TPRICELIST: Contains the price lists descriptors (metadata about price lists).
  • TBASEAMOUNT: Contains the base and sale prices and price tiers.
  • TPRICELISTASSIGNMENT: Contins the prioritized associations between price lists, selling context, and catalogs.
  • TSELLINGCONTEXT: Contains the selling contexts.
  • TSELLINGCONTEXTCONDITION: Associates the selling context with the conditions that define it. For more information on conditions, see the Tagging Framework section.