Write data in Shopify using Shopify Connector in SSIS

In this section we will learn how to configure and use Shopify Connector in the API Destination to write data in the Shopify.

Video Tutorial - Write or lookup data to Shopify using SSIS

This video covers following and more so watch carefully. After watching this video follow the steps described in this article.

How to download SSIS PowerPack for Shopify integration in SSIS
How to configure connection for Shopify
How to Write or lookup data to Shopify
Features about SSIS API Destination
Using Shopify Connector in SSIS

Watch this video on YouTube

How to write or lookup data to Shopify in SSIS (Import data)

In upper section we learned how to read data, now in this section we will learn how to configure Shopify in the API Source to Post data to the Shopify.

Read the data from the source, being any desired source component. In example we will use ZappySys Dummy Data Source component.
From the SSIS Toolbox drag and drop API Destination (Predefined Templates) on the Data Flow Designer surface and connect source component with it, and double click to edit it.
Select New Connection to create a new connection:

API Destination - Shopify

Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Use a preinstalled Shopify Connector from Popular Connector List or press Search Online radio button to download Shopify Connector. Once downloaded simply use it in the configuration:

Shopify

Proceed with selecting the desired Authentication Type. Then select API Base URL (in most cases default one is the right one). Finally, fill in all the required parameters and set optional parameters if needed. You may press a link Steps to Configure which will help set certain parameters. More info is available in Authentication section.

Access Token [Http]

Steps to get Shopify Credentials : Access Token [Http]
Setting up your Shopify store account for API access involves creating an "app" for your store. The "app" is installed into the Shopify account and configured with the appropriate access levels for your data integration needs.

Visit https://accounts.shopify.com and log into your Shopify store account.
After logging in, select the store to connect to with the ZappySys Shopify Connector.
Select the Settings link (usually in the lower-left corner) to launch the Settings screen.
On the left menu panel, select Apps and sales channels.
On the Apps and sales channels screen, select Develop apps (near the top of the screen).
On the App development screen, select Create an app (near the upper-right corner of the screen).
Give the app that will be used to provide Shopify API access a name, select the appropriate developer from the App developer drop-down, and then select Create app.
Select Configure Admin API scopes and the Admin API access scopes screen will appear.
In the Admin API access scopes screen, select every access scope checkbox that applies to your integration needs. It is generally not a good idea to allow more access than what is needed in order to fulfill your integration needs.
- To enable the reading of customer information, select read_customers.
- To enable the writing of customer information, select write_customers.
- To enable the reading of inventory item information, select read_inventory.
- To enable the writing of inventory item information, select write_inventory.
- To enable the reading of order information, select read_orders.
- To enable the writing of order information, select write_orders.
After selecting all applicable access scopes, select Save.
Install the app by selecting the Install app button (near the upper-right corner of the screen). If any other prompts for installation appears, select Install.
After the app is installed, the Admin API access token will be available in the API credentials tab of the page. It can only be revealed ONCE for security purposes. Select Reveal token once to show the new Admin API access token. SAVE THE ADMIN API ACCESS TOKEN IN A SAFE PLACE WHERE YOU HAVE IT CONFIDENTIAL, SECURE, AND NOT ACCESSIBLE TO UNAUTHORIZED INDIVIDUALS. The Admin API access token will be needed in this process later.
In the ZappySys connector API screen, enter the subdomain of your Shopify store into the Subdomain parameter textbox. For example, if your Shopify URL is https://acmetoys.myshopify.com, the subdomain would be acmetoys.
In the same screen, enter the Admin API access token saved from step 11 above into the Admin API Access Token textbox. In order to edit the text in this field, select the ellipses (...) button that appears when the textbox is clicked and edit the access token with the dialog box that appears.
Select the Test Connection button at the bottom of the window to verify proper connectivity with the Shopify store.
If the connection test succeeds, select OK.

Shopify

Access Token [Http]

https://[$Subdomain$].myshopify.com/admin/api/2023-01

Required Parameters
Sub-domain	Fill in the parameter...
Admin API Access Token	Fill in the parameter...
Optional Parameters
RetryMode	Fill in the parameter...
RetryStatusCodeList	Fill in the parameter...
RetryCountMax	Fill in the parameter...
RetryMultiplyWaitTime	Fill in the parameter...

Select the desired endpoint, change/pass the properties values, and go to the Mappings tab to map the columns.

API Destination - Shopify

Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
Finally, map the the desired columns:

API Destination - Shopify

Shopify Connector can be used to integrate Shopify REST API in your App / BI Tools. You can read/write data about Customers, Orders, OrderItems, Products and more.
That's it; we successfully configured the POST API Call. In a few clicks we configured the Shopify API call using ZappySys Shopify Connector