Shopify

Setup Guide

Follow these steps to connect Shopify to your CData Connect Cloud account:

Open the Connections page of the CData Connect Cloud dashboard.
Click + Add Connection in the upper-right corner.
Type Shopify into the search field, then click the data source name.
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
Enter the the full URL of your shop into the Shop URL field (for example, https://yourshopname.myshopify.com).
Select the Authentication method, then proceed to the relevant section and follow those instructions.

Note:

You can only use OAuth if you have a Partner app published on the Shopify store.
The Partner app must have https://oauth.cdata.com/oauth/ registered as a redirect URI.
If you do not have a Partner app, you must create a custom app and authenticate with an access token.

Follow these steps in CData Connect Cloud:

In OAuthClientId, enter the Client Id from your Partner app.
In OAuthClientSecret, enter your Client Secret from your Partner app.
Choose REST or SOAP from the Schema drop down.
Click Sign in to connect securely through OAuth. This action opens the Shopify sign-in page in a new tab.
Log in to your Shopify account and provide the requested permissions (if applicable).
At the top of the CData Connect Cloud Add Shopify Connection page, click Save & Test.
- If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.
- If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.
- Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

For authentication with an access token, follow the steps below to create a custom app:

In a separate browser window, log in to your Shopify account and open the Apps page.
Select Develop apps and then Create an app.
Enter the App name and select the App developer, then click Create app.

In the new app, click Configure Admin API scopes. Enable the following permissions:

read_customers	write_customers	read_draft_orders	write_draft_orders
read_fulfillments	write_fulfillments	read_inventory	write_inventory
read_marketing_events	write_marketing_events	read_orders	write_orders
read_price_rules	write_price_rules	read_product_listings	write_product_listings
read_products	write_products	read_shopify_payments_payouts

Click Save to save the permission settings.
Select the API Credentials tab. Click Install app, then Install on the confirmation prompt.
Click Reveal token once and copy down the value. This acts as your access token for authentication.
Return to CData Connect Cloud.
In Access Token, enter your access token.
Choose REST or SOAP from the Schema drop down.
At the top of the CData Connect Cloud Add Shopify Connection page, click Save & Test.
- If the connection test succeeds, a message indicates that your connection has been created. The Status on the Edit Connection page also changes to Authenticated.
- If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. CData Connect Cloud displays error messages under the required fields with missing data. Some data sources require that you sign in directly to the source website. If you did not, an error message appears under the Sign in button. Correct the errors and try again.
- Unsuccessful connections are saved as drafts and have a Status of Not Authenticated. You can return to the connection and authenticate it later.

For more information about interactions between CData Connect Cloud and Shopify, see this information page.