Shopify <-> BigQuery integration connection error

[devopsadmin]

I followed the Shopify Integration docs, but my connection has an error Status Error

no protocol: (URL)

Possibly related - when I was configuring the connection, the Shopify Integration docs said that authentication for Shopify was not needed, but the connection form gave me a validation error that prevented submission with the "Access token" field completed. I created a Shopify app for the admin API to get an api access token, but that also did not work.

Please lmk if you have any ideas to get this integration to work.

[anjalisoni3655]

Can you please provide the url you are using to connect? 

[devopsadmin]

 is the error message today. The URL is  http://www.gothamlifestyle.myshopify.com/ but there is also an API key that is required, even though the Shopify connection should not require one. I cannot create the connection without it.

[anveshc05]

Hi, How did you get the access token to be used for Shopify connection? 
Please take a look at these steps which can be followed to generate access token while setting up the connection - https://www.shopify.com/in/partners/blog/17056443-how-to-generate-a-shopify-api-token

[Snoshone07]

Hi @devopsadmin the error "no protocol: (URL)" and the issues you're encountering with the Access Token and authentication are likely caused by an incorrect or incomplete configuration of your Shopify integration. Here's a clear, step-by-step guide to help you resolve the issue, along with an alternative approach using Windsor.ai to simplify the process.

1. Verify Your Integration URL

Start by ensuring that the Shopify URL you’ve provided is in the proper format. The URL should look like this:

https://{your-store-name}.myshopify.com

Replace {your-store-name} with your actual Shopify store name.
Double-check for typos or missing parts, like the https://.

2. Check Your Shopify API Access

To connect with Shopify’s Admin API, proper authentication is required. Follow these steps to configure it:

• Create a Custom App in Shopify:

  • Log in to your Shopify admin dashboard.
  • Navigate to Apps > Develop apps.
  • Click Create an app, assign a name, and set up permissions for the Admin API. Make sure the necessary scopes (e.g., read_orders, read_products) are enabled.

• Generate an Access Token:

  • Once the app is created, go to API credentials and generate an Admin API access token.
  • Save this token for use during the integration process.

3. Simplify the Process with an external tool

If you're looking for an easier way to connect Shopify to BigQuery or experiencing ongoing issues, consider using Windsor.ai. It streamlines the integration process by managing authentication and API setup for you.

• Why Windsor.ai?

  • Automates the data connection process, reducing technical complexity.
  • Allows seamless export of Shopify data (e.g., orders, products, sales channels) to BigQuery.
  • Supports connectors for multiple platforms, enabling you to consolidate and analyze all your sales and marketing data in one place.

• How to Get Started with Windsor.ai:

  1. Visit Windsor.ai.
  2. Set up the Shopify connector and authenticate using your store’s details.
  3. Configure your data destination (e.g., BigQuery) and schedule automatic updates.

This option can save time and significantly reduce technical overhead.

4. Test Your Connection

Once you've configured your integration (either directly with Shopify or using Windsor.ai):

• Test the connection and monitor for any errors in the logs.
• If issues persist with the direct integration, recheck permissions and the Access Token.

5. Fixing the "No Protocol" Error

The "no protocol: (URL)" error often happens when the URL field is empty or formatted incorrectly.

• Make sure the URL explicitly includes the https:// protocol.
• If you’re using Windsor.ai, these formatting issues are automatically handled, making the process smoother.

6. Additional Tips

If you're still unable to connect:

• Check API Rate Limits: Shopify has strict API rate limits. If you’ve made several failed attempts, wait a few minutes before trying again.
• Contact Support: Reach out to Shopify, Windsor.ai, or Google Cloud support for help with specific platform configurations.

Hope this helps!

[AlexET]

Hi @Snoshone07, thank you for taking the time to share such a detailed guide, it is incredibly appreciated, and I hope it'll help others facing similar challenges.

We appreciate your effort in making this community a great place to learn and collaborate.