Can we link the language locale with currency code in multi-store? At the moment, currencies and languages are two separate tables. Please see example below:
Languages contains en_CA, fr_CA and en_US locale.
Currencies contains CAD (Canadian Dollar), CAF (Canadian French) and USD (US Dollar).
The goal is to
(a) store en_CA orders with currency code CAD.
(b) store fr_CA orders with currency code CAF.
(c) store en_US orders with currency code USD.
Does anyone know how can this be connected programmatically without hard coding any values by store?
Languages contains en_CA, fr_CA and en_US locale.
Currencies contains CAD (Canadian Dollar), CAF (Canadian French) and USD (US Dollar).
The goal is to
(a) store en_CA orders with currency code CAD.
(b) store fr_CA orders with currency code CAF.
(c) store en_US orders with currency code USD.
Does anyone know how can this be connected programmatically without hard coding any values by store?