All things Shopify and commerce
I'm using MS Access to download new orders from our store. The orders are stored in an Access table and the API call is set to look for all orders with Order ID greater than the last Order ID that was downloaded. We typically get less than 10 orders a day.
The MS Access application uses a timer to query Shopify once per minute. It seems to work fine. No errors. And we're well below our rate limit.
Still, we find that after a while, it stops downloading orders, even though the application says that it connected but that there were no new orders to download. But then, if we close and reopen the MS Access application, then it gets the new orders, some of which may be several hours old already.
So it's not clear why it stops working after a while. There are no error messages. And looking at the logged JSON responses, everything seems normal.
Any ideas what might be going on?
Thanks!
Note: this has been resolved, thanks for help from ChatGPT. It suggested using WinHttp.WinHttpRequest.5.1 to connect instead of MSXML2.XMLHTTP, and that resolved the issue.
Learn how to build powerful custom workflows in Shopify Flow with expert guidance from ...
By Jacqui May 7, 2025Did You Know? May is named after Maia, the Roman goddess of growth and flourishing! ...
By JasonH May 2, 2025Discover opportunities to improve SEO with new guidance available from Shopify’s growth...
By Jacqui May 1, 2025