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

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 [email protected]