We are currently facing the following problem:
We have our Magento (2.2.3) set with one Website, 3 Stores, each has 2 store views.
Each for our 3 stores is dedicated for one country, while the store views are for the different languages within each country.
We have different prices per store (country), and Magento is showing the prices correctly in the Product Details pages.
But in the Category pages, the prices are wrong for some stores, since the prices there come from the Price Index, we queried the table catalog_product_index_price, and found out that there is no store_id column, but just a website_id column.
Does that mean that we cannot have indexed prices per stores? And therefore we have to re-think about our entire structure and make it a multi-website shop where each website is for one country?