M2.2.x: Fix the issue when saving a product in catalog admin panel

Created by Rosa Truong, Modified on Mon, 31 Aug 2020 at 08:48 PM by Rosa Truong

Issue:


I purchased and installed your Multistore view pricing extension version 2.2.1_ce_m2.2.6_to_m2.3.0 on Magento 2.2.9, but products are disappeared from the frontend, when I try to save a product in catalog admin panel it gives me error 500, when I run the indexer on catalog_product_price it gives this error 

Base table or view not found: 1146 Table 'satu_it.catalog_product_index_price_temp' doesn't exist, query was: SELECT `main_table`.`entity_id`, `main_table`.`customer_group_id`, `main_table`.`website_id`, `main_table`.`tax_class_id`, `main_table`.`price`, LEAST(main_table.final_price, rule_index.rule_price) AS `final_price`, LEAST(main_table.min_price, rule_index.rule_price) AS `min_price`, LEAST(main_table.max_price, rule_index.rule_price) AS `max_price`, `main_table`.`tier_price` FROM `catalog_product_index_price_temp` AS `main_table`
 INNER JOIN `catalogrule_product_price` AS `rule_index` ON rule_index.product_id = main_table.entity_id AND rule_index.website_id = main_table.website_id AND rule_index.customer_group_id = main_table.customer_group_id WHERE (rule_index.rule_date = '2020-06-29') AND (main_table.entity_id IN (34510, 34514, 34661))


Solution:


The issue happens since our module does not work well on Magento 2.2.x with version 2.2.1_ce_m2.2.6_to_m2.3.0.

It causes the error when saving a product in the catalog admin panel.

To fix this issue, we have modified the file app/code/Bss/MultiStoreViewPricingTierPrice/Model/Product/Attribute/Backend/Tierprice/UpdateHandler.php

We would like to give the attachment file below.

Please replace the file and flush the cache on your site.


If you need any assistance, please feel free to email us at sales@bsscommerce.com 



Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article