Connecting a Shopify store to the Marketplace via Fuse

Credentials Required from Platform

Here is the information needed to provide to the UC Support / Project team so that the store may be connected to the Marketplace.

• API Key
• Admin API Access Token
• Shopify URL

Shopify Products Inbound

Shopify Products Inbound standard connector is a generic connector used to fetch product data from the Shopify API, here below are listed things needed to connect to that API.

To grant Fuse access to a Shopify store, you will need to create a private Shopify App and generate a key. This will then need to be provided to your Ultra Commerce Support or Project Manager.

Create a private Shopify App

1. In the Shopify Admin Panel, select Apps from the left menu, and a dropdown will appear at the top. From here, select App and sales channel settings.

   

   
   

2. A pop up will appear, and from here, you can select Develop apps from the top right.

   

   
   

3. Next select the Create an app button on the top right of the pop up.

   

   
   

4. Another pop up will appear to label your App, and choose the owner for it.

   Label the App name as {Marketplace} Integration (replacing {Marketplace} with the name of your marketplace this will be synced with, or simply Ultra Commerce Fuse Integration is also fine.

   Then choose Create app on the bottom right of the pop up.

   

5. Once the page loads, you will be able to see the configuration options for the app you had just created.

   

6. Select Configure Admin API scopes from the overview page.

   

7. Here you will need to select a few options. Note that you can use the search bar to filter the options to what you're after.

   In cases where only fetching products is needed, the following permissions are required:

   • Products: read_products

     

     
     

   • Inventory: read_inventory

     

   • Locations: read_locations

     \
     

   In cases where orders are need to be sent to Shopify, that requires order write access:

   • Order editing: write_order_edits and read_order_edits

   • Orders: write_orders and read_orders

     

     
     

8. Select Save from the top right, once all required options are selected.

   

9. Once saved, you will need to obtain the API information to provide to Ultra Commerce. Navigate to API credentials from the top, and on the page, you will see API key.

   

Installing the App and generating a token

1. You will then need to get an access key. There is an Install app button in the same screen. Click on this to trigger a pop up.

   

2. The pop up will just confirm you would like to activate the app. Simply select Install.

   

3. Once you install the app, you will see an API Access Token. This token will be hidden on load.

   ❗️

   WARNING

   This token can only be revealed ONCE. So ensure you copy it somewhere safe and secure.

   You can select Reveal token once to show the token when you are ready.

   

   You can copy the key manually or use the copy function in the field. A confirmation message will appear with Copied to clipboard.

   

   
   
   

   ❗️

   WARNING

   Ensure you copy this, as the next time you load this page, you will not be able to see the access token. If you need the access token again, you can potentially reach out to Shopify, or create a new app from scratch.

4. Provide the Ultra Commerce Team with the data for the following:

   • API key

   • Admin API Access Token

     

   • Shopify URL (which should be something along the lines of: https://shopname.myshopify.com)

     

     
     

     📘

     NOTE

     If you are using redirect to a custom domain, you will be able to see your other domains here. You should use your {.myshopify} domain. This can be found in Settings > Domains in the Shopify Admin Panel:

     

     

5. Ultra Commerce will then set this up for you using Fuse and let you know when connected.

Identifying Duplicate SKUs in Shopify

Products in the Marketplace can only be mapped on a one-to-one basis. This means, if there are any products (or variants) with the exact same SKU (Product code), the integration will fail to sync them successfully. This can result in Shopify failing to import or update products (including stock availability) correctly with the Marketplace. We recommend that all SKUs in Shopify be unique across all active, draft, and variant products to help reduce this occurrence.

A method that can be used is by exporting the products and identifying them in Microsoft Excel (or similar). Here is an example:

1. In Shopify, navigate to the Products page.
2. From the top right of the page, select Export > All Products > CSV to Excel. A file will then download.
3. Open the exported file in Excel, and select the Variant SKU column.
4. Navigate to Conditional Formatting (location depends on the version of Excel) and select Highlight Cell Rules.
5. In the second menu, select Duplicate Values.
6. After selecting OK, a rule apply a highlight to any cell in the excel column that has the exact same value as another cell (duplicate).
7. Compare the SKUs column, and if you have found any duplicates, edit those Products in Shopify so that they are unique.

What happens next?

Ultra Commerce will connect your store via our integrator application and Fuse, and begin to sync products to the Marketplace. The UC team will then advise when this has been connected, and you can map the data when ready.