Following steps describe procedure to enable new current in Atomia platform.
WARNING: Make sure to use transactions when performing database commands.
- Update desired currencies to 'active'
UPDATE AtomiaBilling..currency SET active = 1 where code in ('EUR', 'USD')
( For list of all available currencies and their current status: SELECT name, code, active FROM AtomiaBilling..currency ) - Enable currency for each reseller where it is needed
INSERT INTO AtomiaBilling..reseller_currencies
SELECT r.id, c.id FROM AtomiaAccount..account a
INNER JOIN AtomiaBilling..account_details d ON d.account_id = a.id
INNER JOIN AtomiaBilling..reseller_configuration r on r.id = d.fk_reseller_configuration_id
INNER JOIN AtomiaBilling..currency c on 1=1
WHERE c.code IN ('EUR', 'USD')
AND a.name IN ('100000', '100497', '100617')
- Define products' prices for each new currency
Do not forget to replace example values from the guide with actual currency codes and reselles' numbers.