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

This version of Elastic Path Commerce is no longer supported or maintained. To upgrade to the latest version, contact your Elastic Path representative.

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.