Shopify

ExpandedToggleIcon        Connection Dialog

To connect to Shopify, start by entering the URL of your Shopify Store and providing the Access token.

1.Store - The URL address of your Shopify store.
2.Access Token - A token generated by Shopify after creating and configuring your custom application. The token is used for the AccessToken authentication type only and provides access to your Shopify data.

 

To find out required Information about your store and a valid access token, sign in to your Shopify account. If you don't have a valid access token and need to create one, follow the steps below:

1.Sign up or sign in to your Shopify account on the website log in page.
2.Go to your Shopify admin dashboard and click the arrow icon next to Apps at the bottom-left corner of your dashboard. Next, click App and sales channel settings at the bottom of the menu.
3.In the Settings window, proceed to the Apps and sales channel option and click the Develop apps button.
4.Now you have to confirm developing your app by clicking Allow custom app development.
5.Next, you need to create the application by clicking Create app. Therefore, specify all the requested details: App name, app developer.
6.After creating your app, you have to Configure Admin API Scopes. Select all the required scopes for Admin API and confirm your choice by clicking Save.
7.Go to the Apps and sales channels section and install your app by clicking Install app at the top right of the main window.
8.In the window, which appears, click Install to proceed with the installation.
9.After creating and installing your custom app, the access token is created automatically. So, go to the API credentials tab of the Apps and sales channels section and copy your Admin API access token.

Finally, you can use your Shopify store link and Access Token to be successfully connected to Shopify.

 

In addition to the required options, Advanced connection options may be set for more fine connection tuning.

ExpandedToggleIcon        Advanced Connection Options

The following table describes the options that you can include in the Connection String using the Advanced Connection Editor dialog box:

 

Option

Description

Authentication Type

Determines what authentication type will be used. AccessToken is the default authentication type.

Access Token

Specifies the token returned by Shopify after the user has authorized the custom app. The value is used for the AccessToken authentication type.

API Key

Specifies the API secret key for the APIKey authentication type. This parameter presents an automatically generated key for a private app, which is used for logging in to Shopify. The private app is registered in the Shopify account. Note, that at present APIKey authentication is not supported.

Client Id

Specifies the client ID of your custom Shopify app. The value is used for the RefreshToken authentication type.

Client Secret

Specifies the client secret of your custom Shopify app. The value is used for the RefreshToken authentication type.

Connection Lifetime

Specifies the time interval (in seconds) during which the connection is kept alive. The default value is 0 (in seconds).

Connection Timeout

Specifies the time interval (in seconds) to wait for establishing a connection to the server before terminating the attempt and generating an error. The default value is 60.

Default Command Timeout

Specifies the default timeout in seconds, that Command objects will be using unless being changed. The default value is 60.

Failover Retries

Specifies the number of retries to perform a command if it failed because of the exception, which indicates that the reason of the failure may be temporary. The default value is 7.

Initialization Command

Specifies a database-specific command executed right after opening the connection.

Local SQL Engine

Enables local SQL processing, that allows using more standard SELECT statement features. This parameter is enabled by default, so that the default value is True.

Max Pool Size

Specifies the maximum number of connections allowed in the pool. Setting the Max Pool Size value in the connection string can affect performance. The default value is 100.

Min Pool Size

Specifies the minimum number of connections allowed in the pool. The default value is 0.

NormalizeDbNames

Shortens too long names (e.g. table or column names) exceeding the 63-character limit. If the name is too long, the initial 51 characters are retained and an underscore and a hash are added to the name.

Password

Stores the API Key password for a private app, registered in the Shopify account. The value is used for APIKey Authentication.

Persist Security Info

Indicates if security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state.

Pooling

Specifies whether, by default, the connection is drawn from the appropriate pool or is created and added to the appropriate pool.

Proxy Host

Specifies the name or IP address of the proxy server to connect to, 'Proxy Host=X' in the connection string.

Proxy Password

Specifies the password for the proxy server account, 'Proxy Password=X' in the connection string.

Proxy Port

Specifies the port number of the proxy server to connect to, 'Proxy Port=X' in the connection string. The default value is 3128.

Proxy User

Specifies the proxy server account name, 'Proxy User=X' in the connection string.

Readonly

Indicates whether the connection is read-only (allows only SELECT statements). The default value is False.

Run Once Command

Specifies a command to execute when the connection is opened for the first time and not executed when the connection is taken from the pool.

Store

Specifies the Shopify store URL address.

Token Server

Specifies the location where new tokens are stored between sessions. This location serves as a storage place for access/refresh tokens, which are automatically refreshed by the provider as soon as the current token expires. You can specify the URL to the token server or the path to a file or a registry key, where temporary tokens will be stored.

UserAgent

Specifies the Shopify user name to log in with. Devart ADO.NET is the default value. The value is used for logging server-side requests allowing identification of the request sender. If nothing is specified, the user agent value 'Devart ADO.NET' will be sent in return.

UTC Dates

Determines whether to treat date values as UTC dates.