0

I want to create functionality like product prices can be set at the store-view level for that I've added one more option as Storeview in a configuration for

Stores > Config > Catalog > Catalog > Price

It's already done the price is changing properly store-view wise in the backend also showing on frontend but on a listing page, price filter in layered navigation is not showing products according to the price I've set store view wise.

At first, I thought to create a custom field store_id in

catalog_product_index_price

since it's default Magento table, it's not a good idea to change the default tables so I want to create a separate table like

catalog_product_index_price_store

There are a number of tables in the database related to catalog_product_index_price.

catalog_product_index_price
catalog_product_index_price_bundle_idx
catalog_product_index_price_bundle_opt_idx
catalog_product_index_price_bundle_opt_tmp
catalog_product_index_price_bundle_sel_idx
catalog_product_index_price_bundle_sel_tmp
catalog_product_index_price_bundle_tmp
catalog_product_index_price_cfg_opt_agr_idx
catalog_product_index_price_cfg_opt_agr_tmp
catalog_product_index_price_cfg_opt_idx
catalog_product_index_price_cfg_opt_tmp
catalog_product_index_price_downlod_idx
catalog_product_index_price_downlod_tmp
catalog_product_index_price_final_idx
catalog_product_index_price_final_tmp
catalog_product_index_price_idx
catalog_product_index_price_opt_agr_idx
catalog_product_index_price_opt_agr_tmp
catalog_product_index_price_opt_idx
catalog_product_index_price_opt_tmp
catalog_product_index_price_replica
catalog_product_index_price_tmp
catalog_product_index_tier_price
catalog_product_index_website

The problem is, I don't know which tables would be affected by this and which are the exact tables, I have to create that affected tables as well. Should I update all the tables related to price or are there any other tables than listed above?

Some tables are creating during indexing, so how can I create tables during indexing?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.