Elastic Path Commerce Development

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.