Product Price Index

Posted Almost 12 years ago. Visible to the public. Draft.

The Display Out Of Stock Configuration Option
is implemented by this index. If you have chosen not to display out of stock products,
then the effect is that a product is not entered into this index.

These tables seem to supply the data for the price index:

| Table | Notes |
|------------------------------------------------+-----------------------|
| catalogindex_price | has data |
| catalog_product_index_price | has data - main table |
| catalog_product_index_price_bundle_idx | no data |
| catalog_product_index_price_bundle_opt_idx | no data |
| catalog_product_index_price_bundle_opt_tmp | no data |
| catalog_product_index_price_bundle_sel_idx | no data |
| catalog_product_index_price_bundle_sel_tmp | no data |
| catalog_product_index_price_bundle_tmp | no data |
| catalog_product_index_price_cfg_opt_agr_idx | no data |
| catalog_product_index_price_cfg_opt_agr_tmp | no data |
| catalog_product_index_price_cfg_opt_idx | no data |
| catalog_product_index_price_cfg_opt_tmp | no data |
| catalog_product_index_price_downlod_idx | no data |
| catalog_product_index_price_downlod_tmp | no data |
| catalog_product_index_price_final_idx | no data |
| catalog_product_index_price_final_tmp | no data |
| catalog_product_index_price_idx | has data |
| catalog_product_index_price_opt_agr_idx | no data |
| catalog_product_index_price_opt_agr_tmp | no data |
| catalog_product_index_price_opt_idx | no data |
| catalog_product_index_price_opt_tmp | no data |
| catalog_product_index_price_tmp | has data |

From looking at query logs, catalog_product_index_price is the main table, as
it is the only one that is included in any queries when loading a category or
product page. I assume that all the rest of the tables are temporary.

Mike Whitby
Last edit
Over 10 years ago
Posted by Mike Whitby to Magento (2012-05-04 10:54)