Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Connecting to Shopify with SmartConnect


This week we are going to take a look at Shopify and how we can use SmartConnect’s REST Connector to integrate with Shopify.  To get started you will need the following:

  1. Shopify store with a user that has access to create Apps.
  2. Postman 
  3. Latest version of SmartConnect 
  4. Reference to the Shopify Admin API

Shopify Setup

To start, we need to setup a Shopify app that will give us access to the Shopify API. Login to your Shopify account with a user that has permissions to create an App.  Once logged in to Shopify you will need to navigate to Apps>>Manage private apps.

Enter a Private app name of your choice and then set the permissions appropriately for what you need to do with an integration.  If you are planning on using Shopify as a Data Source only, you’ll only need to set Read access for all the endpoints.  The REST provider that will be included in this article will be setup to GET Orders and POST Products and Customers so you will need Read and write access for those endpoints.

Make sure to save your App settings so an API Key and Password will be generated.  We will need to use these values to generate our Basic Authentication in Postman.

Use Postman to get Basic Auth Value

Launch Postman and set the GET request url to https://YOUR_STORE_NAME.myshopify.com/admin/shop.json.  The store name can be found by navigating to Settings>>General in Shopify.  Next we need to set the Authorization Type to Basic Auth and enter the Username and Password from the previous screenshot.  The Username is the API Key.  After the credentials have been entered, click update request and then click Send.  If everything was setup correctly we will get back a response with our store info.

This will ensure that we have setup our App in Shopify successfully and also give us the Basic Auth Authorization that we will use in SmartConnect.  Click the Headers (1) tab to get our Basic Auth value.  You will need to copy the entire value including the word “Basic”. 

Import and Setup Shopify Connector

Next we can launch SmartConnect and import the included Shopify connector.  Navigate to the Maintenance tab and then click the Import button in the REST Connector section of the ribbon.  Select the xml file (Download here), mark all the methods and click import.

After the import finishes, navigate to Service Providers in the REST  Connector section of the ribbon.  We need to edit the Authorization and Store Prefix parameters to complete the connection to your Shopify store.  Double click the Shopify connector to edit the settings.  On the Parameters tab double click each parameter to enter your Shopify info.  Once your Basic Auth value (acquired in Postman steps above) has been set on the Authorization parameter and your store name has been set for the Store Prefix parameter you can save the connector setup and close any remaining REST connector windows.  You can now setup a new map using the rest connector to use the 5 included methods.  As a data source you can get Shopify Orders, Products and Customers.  As a SmartConnect destination, you can create Products and Customers.  Please note that the Create Products method will not currently add product variants. 

If you need more functionality added to the Shopify REST connector please refer to the Shopify Admin API.  Depending on the endpoint you are planning to work with, you may need to enable more permissions in the Shopify private app that was setup in the beginning of this article.

7 Comments

  1. Cecile on August 16, 2017 at 11:34 am

    What is the minimum version of SmartConnect you need to be able to complete this?

  2. Lorren Zemke on August 17, 2017 at 6:23 am

    Cecile, I would recommend using version 20.17.0.17. This has all of the most recent enhancements and fixes for the REST Web Services connector. http://www.eonesolutions.com/Downloads/SmartConnect/Software/SmartConnect%202017%20(20.17.0.17).zip

  3. Shawn Madsen on March 19, 2018 at 3:14 pm

    Is there a newer version of the Shopify XML import that supports loading inventory levels to Shopify?

    • Shawn Madsen on March 19, 2018 at 5:00 pm

      I added it myself in SmartConnect so no new file necessary.

      • Eric on June 25, 2019 at 5:50 pm

        Hi Shawn,

        Any tips to pull that off?

  4. Josh on March 19, 2020 at 6:36 am

    How stable is this option given that the API can change over the course of time. Is there an onus on an administrator to keep an eye on changes and if something breaks fix it? Realise that API’s aren’t as fragile as my description depicts but an off the shelf connector would be maintained by a software author.

    Asking this with the context that a collection of customers I have want Shopify integration but with next to no maintenance for themselves or from a partner.

  5. Patrick Roth on March 19, 2020 at 9:34 am

    “..but an off the shelf connector would be maintained by a software author.”

    Totally true and we fight with Microsoft BC a bit when they change stuff on their side and now suddenly SC no longer works with BC until we make changes and release a new version.

    The difference here would be that the end user can make changes faster than we can release a new version. Of course that said, the user would have to KNOW the changes to make – so not as trivial perhaps as I make out.

    And of course the other idea is that there isn’t going to be a time in SmartConnect that it just works with “everything”. We would have to build the connector for what you want. So we could add “Woocommerce” for example and that would be nice for those users – but leave Shopify customers where they are now. So you at least have that option to build your own using the REST connector.

Leave a Comment





RECENT POSTS


eOne at Summit North America 2021
Employee Spotlight: Megan Tripp, Business Development Representative
eOne is now compatible with Microsoft Dynamics GP October 2021 Release
October 2021 Releases of Extender, SmartList Builder, SmartView, SmartPost, and Flexicoder are Now Available
Advanced SmartConnect REST Web Services Integration - October 2021

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.