I'm here because j2commerce.com is not responding so I can't find out if there are any forums there, so, here goes...My Joomla is 5.3.3 and my J2Commerce extension is 4.0.7 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.In Joomla I have a scheduled task set up to run every 12 hours and that appears to be fine:http://api.exchangerate.host/live?access_key=<REDACTED>&source=AUD¤cies=USD,EUR,GBP,CAD,NZD,BTC&format=1Also under WebCron I have:https://<REDACTED>.id.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
#435 Seeking assistance with J2Commerce
Posted in ‘Technical Support / Bugs’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Friday, 22 August 2025 02:26 UTC
I've not long ago posted this on Joomla extensions forum:
I'm here because j2commerce.com is not responding so I can't find out if there are any forums there, so, here goes...My Joomla is 5.3.3 and my J2Commerce extension is 4.0.7 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.In Joomla I have a scheduled task set up to run every 12 hours and that appears to be fine:http://api.exchangerate.host/live?access_key=<REDACTED>&source=AUD¤cies=USD,EUR,GBP,CAD,NZD,BTC&format=1Also under WebCron I have:https://<REDACTED>.id.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
I'm here because j2commerce.com is not responding so I can't find out if there are any forums there, so, here goes...My Joomla is 5.3.3 and my J2Commerce extension is 4.0.7 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.In Joomla I have a scheduled task set up to run every 12 hours and that appears to be fine:http://api.exchangerate.host/live?access_key=<REDACTED>&source=AUD¤cies=USD,EUR,GBP,CAD,NZD,BTC&format=1Also under WebCron I have:https://<REDACTED>.id.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
Stay Updated
Subscribe for free and be the first to know about the latest features, updates, and new additions.