How to Create API credentials for Shopify

To make the most of your Shopify data, you need to know how to create API credentials for Shopify. Creating API credentials also protects data and ensures smooth integration.

However, as opposed to other connectors, setting up a Windsor.ai connector is extremely simple.

1. It can only be done via the Shopify App Store
2. Just locate the Windsor.ai connector and install it from there.

Get started for free >>

This method is the simplest and most convenient way to connect Shopify to Windsor.ai. No manual API credentials are needed for this path.

 

Turning connected Shopify data into e-commerce insights

Once Shopify is connected, Windsor.ai blends your order, customer, and revenue data with spend from your ad platforms (Google Ads, Facebook Ads, TikTok, and more) in one place, so you can see true ROAS and customer lifetime value per channel and campaign, not just per platform in isolation. This also removes the need for manual CSV exports or spreadsheet formulas to join Shopify data with ad performance, since it stays in sync automatically once set up.

 

How to create API credentials for Shopify (if you need them for another tool)

Shopify has since retired the manual API-credential method this article originally described (first Private Apps, then Custom Apps); if you need Shopify API access for something other than Windsor.ai, see Shopify’s current developer documentation.

Also read:

Connect Shopify to Excel

Connect Shopify to Tableau

Shopify BigQuery Integration

Connect Shopify to Power BI

Connect Shopify to Google Sheets

Connect Shopify to Snowflake

Shopify Google Data Studio Connector

 

Setting up the Windsor.ai Shopify Connector

Now that you have created the API credentials, the next step is to set up the Windsor.ai Shopify connector.

The Shopify Connector also needs to be installed via Shopify. There are fewer steps in this part of the process.

1. Find the Windsor connector and install it.
2. Once the connector is in place, choose the store or stores you wish to link.
3. The next step is to select the destination.

There are multiple data destinations. It depends on your preference and the platform you use to analyze your data. As you can see, Tableau, Looker Studio, Google Sheets, Excel, Python, and more.

There are options for different purposes on Windsor.ai. But it also depends on your preferences and what type of reports you prefer. If you’re familiar with Windsor.ai, there’s no need to explain this step to you in great detail.

Finally, you can also choose the database or databases from which you can get the data. Google Big Query and Windsor.ai Cloud Database are among the offered options here.

 

How to use the Shopify Connector

Once it’s all set, let’s take a look at the options that the Shopify Connector offers. Here’s a sample of the structure:

The Shopify data is shown on an object level and if you specify the date fields you can use that as a filter to view data based on the period when it was collected, i.e. when the objects were created.

Some of the Customer available fields are:

• Customer created at – The date and time when the entry for a customer/visitor was created in the system
• Currency – This can be quite useful if you sell goods or services in multiple countries and your customers pay using different currencies.
• Email address – If the customer has provided an email address, which is usually the case, you can use it for remarketing purposes, cross-selling, and more.
• ID – This is the unique ID for each customer that is created in the system.
• Note – This is a customized note that you have created about the customer and it can refer to anything and everything. It depends on the nature of the business and the type of goods or services you offer.

The types of fields based on their function are timestamp, text, date numeric, and Boolean. All of the fields are explained and described here. Just select the Shopify Connector, and you can read more details regarding the fields.

 

Conclusion

Shopify is one of the largest e-commerce platforms, and its analytics allow you to get insight into the recent activities of your visitors, their shopping patterns, and habits. However, you can also analyze aspects like the speed of online stores and more. Automating the data extraction is one of the key functions and benefits of the Windsor.ai API.