Reindex error

Issue: I have installed v2.1.7 of Multiple storeview pricing to our M2.2.7 site (uploaded, then ran setup:upgrade and setup:di:compile and setup:static-content:deploy). 

I am able to log in to Admin and everything appears normal, but I am unable to set product price by store view. (Store views are set up, each with a separate base currency and allowed currency, per your setup instructions.) I am getting a message that one or more indexers are invalid. When I run indexer:reindex, I get this:
SQLSTATE[42S22]:  Column not found: 1054 Unknown column 'csw.store_id' in 'on clause', query was: INSERT INTO `catalog_product_index_price_store_temp` SELECT `e`.`entity_id`, `cg`.`customer_group_id`, `pw`.`website_id`, IF(IFNULL(tas_tax_class_id.value_id, -1) > 0, tas_tax_class_id.value, tad_tax_class_id.value) AS `tax_class_id`, IFNULL((ta_price.value), 0) AS `price`, IFNULL((LEAST(ta_price.value, IF(ta_special_price.value IS NOT NULL AND IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value)) <= cwd.website_date AND IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value)) >= cwd.website_date, ta_special_price.value, ~0), IFNULL((tp.min_price), ~0))), 0) AS `final_price`, IFNULL((LEAST(ta_price.value, IF(ta_special_price.value IS NOT NULL AND IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value)) <= cwd.website_date AND IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value)) >= cwd.website_date, ta_special_price.value, ~0), IFNULL((tp.min_price), ~0))), 0) AS `min_price`, IFNULL((LEAST(ta_price.value, IF(ta_special_price.value IS NOT NULL AND IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_from_date.value_id, -1) > 0, tas_special_from_date.value, tad_special_from_date.value)) <= cwd.website_date AND IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value) IS NULL OR DATE(IF(IFNULL(tas_special_to_date.value_id, -1) > 0, tas_special_to_date.value, tad_special_to_date.value)) >= cwd.website_date, ta_special_price.value, ~0), IFNULL((tp.min_price), ~0))), 0) AS `max_price`, tp.min_price AS `tier_price` FROM `catalog_product_entity` AS `e`

Solution: 

Could you please check if you have changed Catalog price scope to store view: Store > Configuration > Catalog > Catalog > Price > Catalog Price Scope http://prntscr.com/lt0uw4 ?

If there are any issue, please feel free to contact us. We're always pleased to support you. As a trusted Magento 2 extensions provider with 14+ years of experience, serving 75,000+ customers worldwide, 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.

Explore our extensions here in: https://bsscommerce.com/magento-2-extensions.html

Discover our top tier plugins:

• Magento B2B Extension by BSS Commerce is a flagship and widely adopted solution globally, offering advanced pricing, company account management, and streamlined workflows.
• Magento 2 SEO Extension Suite by BSS Commerce is a reliable tool to strengthen your SEO strategy and drive sustainable growth.

FYI, this issue would be resolved totally from v2.1.8

Regards,