My Joomla is 5.3.3 and my J2Commerce extension is 4.0.17 running on Debian 12 on a Raspberry Pi 4 with 8G of RAM.
My problem is setting getting multiple currencies in J2Commerce to auto update.
I am pulling exchange rates from api.exchangerate.host with an assigned API key. That works fine and the JSON result looks as expected.
{"success":true,"terms":"https:\/\/currencylayer.com\/terms","privacy":"https:\/\/currencylayer.com\/privacy","timestamp":1756000386,"source":"AUD","quotes":{"AUDUSD":0.6468,"AUDEUR":0.551788,"AUDGBP":0.482057,"AUDBTC":5.527992e-6}}
In Joomla I have a scheduled task set up to run every 24 hours and that appears to be fine:
http://api.exchangerate.host/live?access_key=<REDACTED>&source=AUD¤cies=USD,EUR,GBP,BTC&format=1
Also under WebCron I have:
https://<REDACTED>.au/index.php/component/ajax?plugin=RunSchedulerWebcron&group=system&format=json&hash=<REDACTED>
In J2Commerce:Currencies I have my default currency (AUD) set at 1.0 and all other currencies set at 0.0 - I tried setting the non-defaults to NULL but that gave a MySQL error.
My problem is that there appears to be a stage needed between getting the JSON and updating the currencies and I can't work out what that missing stage is.
TIA
