Can anyone explain to me why this error are starting to show? At first there is no problem with our syncing of company entity to shopify then this year 2025 I’m not really sure exact date this problem start occurring
At least one GraphQL error has occurred. Error: Field 'locationCount' doesn't exist on type 'Company';Error: Field 'orderCount' doesn't exist on type 'Company';
Page 1 / 1
Hi @FrankieDC, this error is related to GraphQL bad request when sending Acumatica entity to Shopify. What Acumatica version are you using?
@gabrielpaz86 , I’m seeing this exact problem on 23.208.0026. Please note that this client had the sync working before, and now it doesn’t, throwing this error:
At least one GraphQL error has occurred. Error: Field 'locationCount' doesn't exist on type 'Company';Error: Field 'orderCount' doesn't exist on type 'Company';
Also note that according to Shopify GraphQL docs, their fields are called locationsCound and ordersCount - note the ‘s’, plural, for locationS and orderS vs what the error says: location and order.
I looked at the GraphQL versioning, and I couldn’t find a version where the fields were singular (without s’s).
Can we get some eyes (and hands) on this to get it resolved quickly?
Thank you!
@KarthikGajendran @WaqasMughal16 @DilshanThulapitiya67 I am also facing same issue, do you have any Insight on this.
@Yuri Karpenko, we actually use “orderCounts” and “locationCounts”. So, in this case I would kindly ask to create a case so we could investigate what is happening.
@Yuri Karpenko, @FrankieDC and @Manikanta Dhulipudi, I was checking in 2024R208 and only now I realized that the issue is happening in 2023r208, my apologies. It seems that this issue was fixed in 2023R2 Update 12. Is it possible to update?
@FrankieDC @Yuri Karpenko @Manikanta Dhulipudi Please update your build. These are recent changes from Shopify. You can find more information here
Thank you, @KarthikGajendran and @gabrielpaz86 ! We’re working on the upgrade.
@KarthikGajendran , @gabrielpaz86 , if the client is on 23.211 and can’t upgrade right away, is there a workaround? generate another api credentials with older API version? how can we get them unblocked before the upgrade is done?
thank you!
@Yuri Karpenko Cant they update? I know Upgrade is a big step. But updating to a later build in a same version should be easier i thought.
Thank you guys ! This is very big help for us.
Hi @FrankieDC, this error is related to GraphQL bad request when sending Acumatica entity to Shopify. What Acumatica version are you using?
Build 23.211.0017
I’m getting this error when trying to connect to shopify. @Yuri Karpenko @KarthikGajendran I’m using 2024r2.
Test connection failed: An error occurred while sending the request..
@gabrielpaz86 Thanks, for your help! I followed the instructions “To Establish the Store Connection with a Custom App “ exactly and I’m still receiving the same error message. I’m really not completely sure why...
@rashonmitchell19 , I never thought this will be helpful to anyone but me, but here’s a tool I built for myself to check if the APIs I have really work: https://shopify-api-checker.vercel.app/
Open that app, enter your store URL: {store-name}.myshopify.com, enter the Access Token, click Preview API Call, then click Confirm and Execute. In the Results, you will see if you have any API rights, or you will see an error message. Let us know what you get.
P.S. The app is free and doesn’t require registration. At least yet :)
@rashonmitchell19, According to To Establish the Store Connection with a Custom App, it seems that he full URL usually looks like this “https://<store name>.myshopify.com/admin/” while yours seems to be different. could you please check once more your Admin URL field? Maybe it should be “https://marchueq-dev… .myshopify.com/admin/”
@gabrielpaz86 The url follows this convention “https://<store name>.myshopify.com/admin/”. Admin API access token and API secret key all match and are correct. hmm…..
@Yuri Karpenko I get this back from the app you provided. However, the credentials are correct?
Invalid response format. Please check your API credentials.
@gabrielpaz86 The url follows this convention “https://<store name>.myshopify.com/admin/”. Admin API access token and API secret key all match and are correct. hmm…..
@Yuri Karpenko I get this back from the app you provided. However, the credentials are correct?
Invalid response format. Please check your API credentials.
It means your credentials are not working. When I run it with working creds, I get something like this: