Products Master Data - Shopify in the Integration Hub

Products Master Data - Shopify in the Integration Hub

The Integration Hub supports the integration of existing product data as well as new product data between both applications. In other words, product synchronization between SAP Business One and Shopify is bidirectional. 

All products added to Shopify or updated in Shopify are synchronized in SAP Business One with the default item group configured in the Shopify  General Settings .  
Shopify products for which the  Track Quantity is not selected are marked as non-inventory items in SAP Business One.

The  Item Code in SAP Business One is mapped with the Stock Keeping Unit (SKU) in Shopify for integration. 

To synchronize products from SAP Business One to Shopify, in the SAP Business One  Main Menu , choose  Inventory  Item Master Data.  On the Integration Hub  tab, choose   the Sync  button .

The following fields have been added to the  Item Master Data window and is relevant to the Integration Hub. For details of other fields on the  Item Master Data window, refer to the SAP Business One online help.

Field Name
Description
Template Name
Displays the name of the Shopify template.
Cross Reference Code 
Displays the Shopify product ID for normal products or the variant product ID for variant products.   
Sync
Select this checkbox to synchronize the product information from SAP Business One to Shopify. 


Caution
You cannot delete products from Shopify and SAP Business One. If a deleted product is used in a transaction, then data inconsistency will occur.
Manage items by Batches/ Serial Number are not supported for synchronization. 

Normal Products

The integration of normal products is bidirectional between Shopify and SAP Business One. Products other than variant products or gift certificates are integrated as normal products.

Variant Products

The integration of variant products is unidirectional (in other words, from Shopify to SAP Business One). Variants can be added to a product that comes in more than one option, such as size or color. Each combination of options for a product is a variant of that product.
For example, a user sells t-shirts with two options: size and color. The size option has three values: small, medium, and large. The color option has two values: blue and green. One specific variant from these options is a small, blue t-shirt.
Each variant is integrated as a separate item in SAP Business One.

Gift Card

A gift card can also be sold to a customer via Shopify (in other words, a customer can purchase a gift card like a regular item). The customer is emailed a gift voucher that can be given to someone or redeemed next time while making payment. 
A gift card is integrated as a sales item in SAP Business One. If the gift card in Shopify is set to have  Track Quantity, then the gift card is marked as an inventory item in SAP Business One.

Note
The integration of gift cards is unidirectional (in other words, from Shopify to SAP Business One). 

Product Prices

The prices integration between SAP Business One and Shopify is bidirectional. The application uses the default price list defined in the  General Settings  for Shopify to integrate the prices from SAP Business One to Shopify. 
To open the Shopify General Settings , in the SAP Business One  Main Menu , choose  Administration  Integration Hub   Shopify Settings  →  General Settings  tab .  
The price list selected in the  Default Price List for Items Prices Integration  field   is the integrated price list from SAP Business One to Shopify. 

Product Inventory 

The inventory integration is unidirectional (in other words, from SAP Business One to Shopify). The inventory status is updated from SAP Business One to Shopify. 
From SAP Business One, inventory data is integrated from the warehouse that is mapped with the Shopify location. To map the SAP Business One warehouse to a Shopify location, choose  Administration  Integration Hub   Shopify Settings  →  Location Mapping.   
The inventory can be synchronized from the  Synchronization  tab of the  Shopify  window. To synchronize inventory, choose  Administration  Integration Hub   Shopify Settings  →  Synchronization. 

There are two ways to synchronize inventory:

Manual  Synchronization of Inventory:
Whenever required, choose the  Sync Now button to synchronize the inventory from SAP Business One to Shopify.

Automatic  Synchronization of Inventory: 
Select the parameters for  Object Type , Run, On, Hour,  and Minutes to schedule synchronization and then choose the  Save Schedule button to schedule inventory synchronization at the predefined day and time. 

Field Name
Description
Object Type 
Select  Stock from the dropdown list. 
Run 
Specify if you want to run the synchronization daily or weekly. 
On
If you chose the  Weekly option, select the day of the week.
Hour
Select the hour on which you want the synchronization to run. 
Minutes
Select the minutes on which you want the synchronization to run. 
Sync Now
Choose this button to start the synchronization immediately.
Save Schedule
Choose this button to implement the selected schedule for the synchronization. 




    • Related Articles

    • Customer Master Data - Shopify in the Integration Hub

      The customer master data integration is unidirectional (in other words, from Shopify to SAP Business One). Customer information like Billing  and  Shipping Address , and other details are integrated from Shopify to SAP Business One.  When the ...
    • Shopify integration with SAP Business One

      Shopify is an e-commerce platform that allows users to create online retail stores. This cloud-based platform gives the flexibility to access and run a business from anywhere.  Shopify allows users to: Create and customize an online store. Sell in ...
    • Synchronization of Shopify in the Integration Hub

      The following two methods are available for synchronizing data between SAP Business One and Shopify: Manual Synchronization:  If you want integrations to be performed immediately (instead of waiting for the SCHEDULER services run), choose the Sync ...
    • General Settings of Shopify in the Integration Hub

      To configure the required settings for Shopify in SAP Business One, in the SAP Business One Main Menu, choose Administration → Integration Hub → Shopify Settings → General Settings tab.   The General Settings tab of Shopify window contains the ...
    • Initialization Process of Shopify in the Integration Hub

      Once the Shopify feature is enabled in SAP Business One, you need to initialize the integration of the objects between SAP Business One and Shopify. The objects include customer, products and inventory. Note Ensure that the weight UOM code in SAP ...