Acumatica x Shopify Connector Failed

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?

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. 

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..

​@rashonmitchell19, could you please double check your credentials?
Please check here To Establish the Store Connection with a Custom App (specially at step 4) or To Establish the Store Connection with a Public App.

​@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.

It means your credentials are not working. When I run it with working creds, I get something like this: