I have a scenario where some products need to be stored in a particular currency and others in a different currency. At the time of display, these need to be displayed in the currency setup at the store.
So was wondering if this was possible already and explored the magento backend (admin) a bit and found that the currency is read-only and defaults as the store currency (USD in my case). So thought this functionality was not supported yet and explored the magento database tables a bit.
Navigated thro ‘catalog_product_entity_tier_price’ and ‘catalogrule_product_price’ and didnot find the currency to be stored anywhere. Can anyone help me out on this please?