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 of our 3 stores is dedicated for one country, while the store views are for the different languages within each country. We are using GeoIP in order to determine the visitor country and lead her to the right store.
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? And how people usually show the store-specific price in the category page?
Thanks in advanced