How Configuration Prices are Stored

Last Updated: Jun 23, 2014 11:20AM EDT

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

Menu

  • Support Forums
  • Video Tutorials
  • Support Request
  • Support Policy
647e99095133bd6d1ae916f97dc7f92f@productcart.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete