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

The token returned by Shopify after the user has authorized the custom app. Used for the AccessToken authentication type.

API Key

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.

Connection Lifetime

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

Connection Timeout

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

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

Failover Retries

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

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

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

Used for APIKey Authentication. This parameter stores API Key password for a private app, registered in the Shopify account.

Persist Security Info

When set to False, security-sensitive information, such as the password, is not returned as a part of the connection in case the connection is open or it has ever been in an open state.

Pooling

If set to True, (i.e. the default value), the connection is drawn from the appropriate pool or is created and added to the pool.

Proxy Host

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

Proxy Password

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

Proxy Port

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

Proxy User

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

Readonly

If set to True, the connection allows only reading the source data (this applies to SELECT statements only). 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

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

The Shopify user name to login with. Devart ADO.NET is the default value. 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.