Shopify Integration – Orders, Inventory Levels, and Shipments

Overview

In version 4.4.1, CIMcloud released a standardized method to sync data between Shopify and CIMcloud.  We currently support the following data syncing between these two systems in our core product:

• Orders from Shopify to CIMcloud to your ERP system
• Shipments from your ERP system to CIMcloud to Shopify
• Inventory Levels from your ERP system to CIMcloud to Shopify

In this article, we’ll cover the following:

• Shopify integration steps
  • Prerequisites to sync data
  • Creating an app in Shopify
• How the service works
  • Monitoring
  • Scheduling
  • Customizations
  • Data Mapping
• Future updates

Shopify Integration Steps

Data Sync Prerequisites

• For Orders:
  • If syncing orders from Shopify to CIMcloud, please send the default values:
    • Payment Terms
    • Salesperson Number
    • Customer Division
    • Customer Number
    • Order Status / Hold Code (if applicable)
    • Order Type
    • Print Pick Sheet / Print Sales Order values
    • Tax Schedule
• For Inventory and Shipments syncing from your ERP (and CIMcloud) to Shopify:
  • SKUs in Shopify must match the ItemCode/SKU in your ERP/CIMcloud
    • Otherwise, we will be unable to match the item between these systems
  • The location name in Shopify must match the Warehouse name in your ERP/CIMcloud
    • Otherwise, we will be unable to update inventory levels

Creating your app in Shopify

To sync data between Shopify and CIMcloud, you’ll need to create an App within your Shopify store.  Below are the steps to create an App and send us the credentials needed to sync data:

1. 1. Login to your Shopify Store
   2. Click “Apps” on the left side
   3. Click “App and sales channel settings”
   4. Click “Develop apps” in the top right of the modal
   5. Click “Create an app”
   6. In the App Name field enter “CIMCloud Integration App” and click “Create App”
   7. Click “Configuration” and select Configure next to “Admin API integration”.
   8. Grant the appropriate scopes by clicking the following. Clicking on these will also enable the read scope, we need access to both:
      1. write_customers
      2. write_fulfillments
      3. write_inventory
      4. write_locations
      5. write_orders
      6. write_products
   9. Once this is done, press “Save” and then hit “Install app”.
   10. Once it is installed, navigate to “API Credentials” and hit “Reveal Token Once”
   11. Copy this revealed token and send to CIMcloud
       1. Note: This token cannot be recovered once you reveal it, but a token can be generated again.  If a new one is generated, we will need to update it on our end.

How It Works

Monitoring Orders

• You can view the orders synced via the worker portal.
  1. Navigate to the tab “Pass Through Orders” in the worker portal
  2. From here, you can review orders synced from Shopify and their import status to Sage
  3. Clicking on an Order ID displays any errors when attempting to import into Sage

Scheduling

• Scheduled tasks, via Data Mover, send requests to Shopify’s API layer for the following:
  • Every 5 minutes for Orders
  • Every 5 minutes for Inventory
  • Every 5 minutes for Shipments

Customizations

• Customizations on fields are allowed (to an extent).  For example, meta data on orders can be added and pushed through to CIMcloud, and by extension, your ERP system.
  • Note: This is a pro services engagement to modify mappings of fields between the data sync

Data Mapping

• Tables with columns between Shopify and CimCloud

  • Orders (s_orders, s_order_details)

  • Shipments (external_order_shipments)

  • Inventory Levels (product_qty_in_stock)

Future Updates

• Better Logging

• Self-service Shopify data sync interface

• Self-service data mappings