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 sales@bsscommerce.com 

Get to know about us

BSS Commerce is a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide. We are an Adobe Commerce Solution Bronze Partner and a Select Magento Extensions Builder, reinforcing our expertise in the Magento ecosystem.

We specialize in developing 150+ high-quality Magento 2 extensions that enhance functionality, improve user experience, and support scalable growth. Our reputation is built on long-term partnerships, positive feedback, and proven performance-driven solutions.

Browse for more at https://bsscommerce.com/magento-2-extensions.html 

Here are our top tier extensions:

• Magento 2 B2B Extension by BSS Commerce delivers a complete solution for scalable and efficient wholesale management.
• Magento 2 SEO Extension by BSS Commerce empowers your store to rank higher and grow organic traffic faster.