Skip to content
  • There are no suggestions because the search field is empty.

How Configuration Prices are Stored [Migration Draft]

Configuration Prices


When you assign a Standard Product or a Configurator Item to a configurable product, the prices for those items are saved separately from their original price. This allows you, for example, to charge less for a “Hard Disk” when it's part of a customizable desktop computer compared to when the same product is sold as a stand-alone product.

You can assign the following prices for each item that is part of a product configuration:  

How the different configuration prices are saved to the database

 
Regular configuration items
They are saved to the configSpec_products table
  • specProduct = ID of the configurable product
  • configProduct = ID of the configuration item
  • price = online price
  • Wprice = wholesale price
 
Additional charges
They are saved to the configSpec_Charges table
  • specProduct = ID of the configurable product
  • configProduct = ID of the configuration item
  • price = online price
  • Wprice = wholesale price
 
Pricing category prices
In both cases, pricing category prices are saved to the pcCC_BTO_Pricing table:
  • idCustomerCategory = Pricing category ID
  • idBTOProduct = ID of the configurable product
  • idBTOItem = ID of the configuration item
  • pcCC_BTO_Price = price for that item when the customer belongs to this pricing category