I am running multiple sites off my Magento install, with multiple store views for each website.
Each of my store views is based on a different currency. My issue is due to contractual agreements etc I need to have the prices of my products individually set, rather than based on a currency exchange rate.
My process so far is as follows. I have set all my currency exchange rates to 1:1 so there is no conversion. For each of my products I have taken off the 'Default Store View' for pricing on each of my websites (now saving the product prices from Magento backend sets the same price across all stores, however, creates an EAV record for the pricing for each store view, so I have linked in the database to my local system that changes the price direct in the database giving a different price for each store view for each product). So my pricing across each store and currency is correct.
On the product view page, the price shows correct and can be bought at the correct price and no problems so far (due to the pricing taken from the EAV table).
At this point, I will mention I have for all of my products I have a 'price' set and also a 'special price'.
The category view page, however (and as I understand is taken from the Price Index Table, rather than the EAV to save time and processing etc. With the indexed table created and referenced to on a Website ID only, rather than store ID......) So the price is shown on the category view is wrongly taken from the default store price on the item. After a bit of playing around though, I noticed that ONLY the special price is showing as referenced from the Indexed table, the price that is shown (with a strikethrough as I have a cheaper special price) is actually correct.
Is this 'price' field always taken straight from the EAV instead of the indexed table?
Also is there a way that I could change the special-price field to take the value from EAV rather than the indexed table?
I have toyed with the idea of creating my own price block to be used on the catalog view pages only, however, this is a little out of my knowledge base (still getting the hang of Magento......)