Stalled sync after initial successful attempt

[cmalven]

Description

I was initially able to successfully sync products from our Shopify site, but all future attempts have failed silently. On a site with existing products, craft shopify/sync produces the following state:

Even after days, this Status and Shopify Status never fails or changes in any way. It is permanently stuck in QUEUED.

If I delete all Shopify products and data from the database and attempt to sync, I get the following:

Again, this status never changes. It is permanently stuck in CREATED.

In either case, there are no CP Queued jobs, logs in /storage/logs or any other evidence that anything is happening.

I ran the following, as recommended in another similar issue:

curl -X "POST" "https://<HOSTNAME>.myshopify.com/admin/api/2024-10/graphql.json" \
     -H 'X-Shopify-Access-Token: <ACCESS_TOKEN>' \
     -H 'Content-Type: application/json; charset=utf-8' \
     -d $'{
	"query": "query{products(first:100){nodes{id publishedOnCurrentPublication}}}",
	"variables": {}
}'

…which produced…

{"data":{"products":{"nodes":[{"id":"gid://shopify/Product/8807636467998","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8807649673502","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8807674872094","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8807678542110","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810125754654","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810142040350","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810154557726","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810169270558","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8810186146078","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810198466846","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810206134558","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810249617694","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810295951646","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810302734622","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810310730014","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810319773982","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810331767070","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8810360144158","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812418367774","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812430655774","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812446286110","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812453953822","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812460835102","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812475187486","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812486623518","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812516671774","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812523290910","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812540625182","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812571197726","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812581126430","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812585484574","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812586926366","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812602523934","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812609536286","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812611764510","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812617335070","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812652036382","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812656427294","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812661932318","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812692111646","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812700303646","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812706955550","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812711641374","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812718424350","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812722749726","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812724060446","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812738380062","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812744212766","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812749979934","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812754862366","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812758106398","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8812767150366","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8812770885918","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8817589715230","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8817604657438","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817608884510","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817640898846","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817765843230","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817864409374","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8817874010398","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817890853150","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8817897439518","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817906352414","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817918083358","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8817924243742","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819489505566","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819493830942","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819510247710","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819515326750","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819522404638","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819530465566","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819539968286","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819547963678","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819552321822","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819560775966","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819569787166","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819581681950","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819586400542","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819595084062","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819609567518","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819616907550","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819626279198","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819633324318","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819640336670","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8819649642782","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819651215646","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819662029086","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8819674349854","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8822573629726","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8822618423582","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823859183902","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8823866294558","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8823872258334","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823880220958","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8823885988126","publishedOnCurrentPublication":true},{"id":"gid://shopify/Product/8823933501726","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823948837150","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823973609758","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823983702302","publishedOnCurrentPublication":false},{"id":"gid://shopify/Product/8823985701150","publishedOnCurrentPublication":false}]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":4000.0,"currentlyAvailable":3989,"restoreRate":200.0}}}}%

This at least seems like a successful request? See anything unusual? Please let me know what I can do to help track this down, and thank you!

Additional info

• Craft version: 5.7.10
• PHP version: 8.2.28
• Database driver & version: MySQL 8.0.40
• Plugins & versions: Shopify 6.0.3

[linear]

PT-2824 Stalled sync after initial successful attempt

[nfourtythree]

Hi @cmalven

Thank you for your message.

We have seen similar behaviour with Craft 4 although yesterday's release of version 4.16 should have solved that issue.

Is this still happening for you?

Thanks!

[cmalven]

Hi @nfourtythree thanks for responding. Maybe I'm misunderstanding, but I'm seeing this issue in Craft 5.7.10, not Craft 4.

[siebird]

@nfourtythree we're seeing this issue in 4.16.0. Says completed. No products showing.

[nfourtythree]

Hi @cmalven

Apologies, I didn't mean to cause any confusion. I just wanted to check in to see if the problem was still persisting for you in your project as the only time we had seen the issue in your first screenshot was within Craft 4.

If you delete all the bulk operations and then run the sync again. Then run the following CURL command that gives us info on the status of the bulk operation on Shopify's end:

## Shopify Op Status
curl -X "POST" "https://<HOSTNAME>.myshopify.com/admin/api/2024-10/graphql.json" \
     -H 'X-Shopify-Access-Token: <ACCESS_TOKEN> \
     -H 'Content-Type: application/json; charset=utf-8' \
     -d $'{
	"query": "query{currentBulkOperation{id status errorCode createdAt completedAt objectCount fileSize url partialDataUrl}}",
	"variables": {}
}'

Hopefully, that will provide further information as to what is happening. Bulk operations can take a little while to run on Shopify's end so might be worth executing that a few times and monitoring the status data returned.

Thanks!

[nfourtythree]

Hi @siebird

Do you see any errors in your logs? Did you happen to see if the queue jobs were executed?

Thanks!

[cmalven]

@nfourtythree I cleared the existing request from the CP and ran shopify/sync, then the curl request you shared. This was the response, both immediately after the sync and after a couple of hours:

{"data":{"currentBulkOperation":null},"extensions":{"cost":{"requestedQueryCost":1,"actualQueryCost":1,"throttleStatus":{"maximumAvailable":4000.0,"currentlyAvailable":3999,"restoreRate":200.0}}}}

The CP still reports that the sync task is QUEUED.

[nfourtythree]

@cmalven is this still the case? It is strange that it says currentBulkOperation: null in the response. This suggests it hasn't been created.

Would it be possible to allow API access so we can test the connection directly?

If you write into support@craftcms.com referencing this issue we can take it from there.

You can always create a separate new app and generate keys from there so you can delete it once we have finished in support.

Thanks!

[siebird]

Hi @siebird

Do you see any errors in your logs? Did you happen to see if the queue jobs were executed?

Thanks!

This got sorted for us – just took some time. 

[kragit]

I'm seeing this as well:

• Craft version: 5.8.6
• PHP version: 8.3
• Database driver & version: PostgreSQL 16.3
• Plugin Version: Shopify 6.0.3

Had one in 'Created' status, another in 'Queued' status. Cleared them both out and ran a sync. CURL command came back with:
{"currentBulkOperation":{"id":"gid://shopify/BulkOperation/[ID]","status":"COMPLETED","errorCode":null,"createdAt":"2025-07-14T19:40:43Z","completedAt":"2025-07-14T19:41:22Z","objectCount":"7016","fileSize":"4523380","url":"URL&response-content-disposition=attachment%3B+filename%3D%22bulk-[ID].jsonl%22%3B+filename%2A%3DUTF-8%27%27bulk-[ID].jsonl&response-content-type=application%2Fjsonl","partialDataUrl":null}},"extensions":{"cost":{"requestedQueryCost":1,"actualQueryCost":1,"throttleStatus":{"maximumAvailable":2000.0,"currentlyAvailable":1999,"restoreRate":100.0}}}}

Still seeing it as 'Created' in the control panel

I have a few products where I've updated the title and these updates aren't yet reflected in the Craft Shopify product entry.

I'm not seeing any relevant logs in console, queue or phperrors logs.

EDIT: About 2 hours later, the original request still shows as 'Created' and another one has appeared as 'Queued'.

EDIT 2: About 4 hours since the original post, same 2 entries.

Of note, I have a daemon setup for the Craft queue
php craft queue/listen --verbose=1 --color=0

EDIT 3: Of note, all products indicate they were last updated about 10 days ago, which I believe aligns to when I updated both Craft and the Shopify plugin to newer versions.

[nfourtythree]

Hi @kragit

Thank you for the info.

Other similar reports of this have come from a error when processing the data (in one support ticket the error was from a unrelated plugin).

Could you remove the two bulk operation rows and trigger a new full sync. Then, if things end up in the same state, check for any errors in your logs.

Along with this you could also try disabling all custom modules and plugins to try and narrow down the test case.

Let us know how you get on, thanks!