Shopify – SAP Business One integration template

The Shopify – SAP Business One integration lets you create new customers or update the existing ones between Shopify and SAP Business One. This template is comprised of a set of prebuilt integration flows, which automate the workflow by syncing the new customers being created and existing customers getting updated between Shopify and SAP Business One.

Supported integration flows

The Celigo quickstart bundle contains workflows you can easily configure and deploy without coding or IT support. The following built-in flows sync from the specified source data to the corresponding destination.

Shopify to SAP Business One

SAP Business One to Shopify

Gather your credentials

Keep your Shopify and SAP Business One account credentials ready:

• Shopify – verify APIs and Authorization
  • Before you set up a Shopify connection below, ensure that you have the API and authentication details for your Shopify app. 
• SAP Business One – verify APIs and Authorization
  • Before you set up a SAP Business One connection below, ensure that you have the API and authentication details for your NetSuite app. 
  • Refer to the SAP Business One help documentation to learn more about APIs and Authorization. 

Install the Shopify – SAP Business One template

1. Navigate to integrator.io > Marketplace.
2. From the available templates, select either Shopify or SAP Business One.
3. Find the Shopify - SAP Business One template and click Preview. The Install template page appears.
4. Review the template’s contents and the ReadMe file, and click Install now to begin.

Configure the Shopify – SAP Business One flows

Additional record mapping is required to integrate the template’s exports and imports with your  Shopify and SAP Business One apps.

Note that all of your flows are disabled when first installed. After configuring the flows, you may enable them in your Flows dashboard or Flow Builder with the Off/On toggle button and then run or schedule each flow. 

Shopify customers to SAP Business One customers

This integration flow syncs Shopify customers as SAP Business One customers. When a new customer is created, or an existing customer is updated in Shopify, the integration flow exports customers from Shopify to SAP Business One.

Setup instructions

Configure the following hardcoded mapping according to your business requirements in Import SAP Business One customers, before running the flow.

Shopify orders to SAP Business One sales orders

This integration flow syncs Shopify orders to SAP Business One sales orders. When a new sales order is created or an existing order is updated in Shopify, the integration flow exports orders from Shopify to SAP Business One.

Setup instructions

Configure the following hardcoded mapping according to your business requirements in Import SAP Business One customers, before running the flow.

SAP Business One customers to Shopify Customers

This integration flow syncs SAP Business One new/updated customers as Shopify customers. When a new customer is created, or an existing customer is updated in SAP Business One, the integration flow exports customers from SAP Business One to Shopify.

SAP Business One items to Shopify items

This integration flow syncs SAP Business One items as Shopify items. When a new customer is created or an existing customer is updated in Shopify, the integration flow exports customers from Shopify to SAP Business One.

SAP Business One orders to Shopify orders

This integration flow syncs SAP Business One orders to Shopify orders. When a new item is created or an existing item is updated in SAP Business One, the integration flow exports items from SAP Business One to Shopify.

Before you begin

1. The SAP Business One items and Shopify items must be in sync.

Setup instructions

1. Configure the following hardcoded mapping according to your business requirements in Import Shopify orders, before running the flow.

   Source record field (Shopify)	Destination record field (SAP Business One)
   "pending"	order.financial_status

2. Configure the following static mapping according to your business requirements in Import  Shopify orders, before running the flow.

   Source record field (SAP Business One)	Destination record field (Shopify)
   DocCurrency	order.currency

3. In the processingSAPOrders.js script, modify it according to your requirement if the code fails to correctly extract shipping information from the ShipToDescription field from SAP Business One.
4. Within SAP Business One, create a custom text-type field for sales order records to store the Shopify order ID. Subsequently, configure this field in the Import SAP Business One Orders flow.

   Source record field (SAP Business One)	Destination record field (Shopify)
   shopifyOrderId	U_shopifyOrderId