SAP Business One Item to Shopify Product

First published on: 10/19/2023/10:16 am

Workflow Summary 

• This workflow creates and updates products in Shopify from items in SAP Business One. 
• If required, custom integration rules can be added to control which items are integrated with Shopify. 
• The default price on the Shopify product is updated.
• The item group in SAP Business One is mapped to the Shopify product type.
• Custom data mappings can be implemented.
• Using product variants in Shopify requires additional design based on how you have items/products configured in both systems.
  • There may be an additional cost to implement this feature in the item and inventory workflows.

Workflow Description 

When an item is created or updated in SAP Business One, the integration process will check a UDF on the item master called U_V33SB_SHOPIFYITEMID, which contains the Shopify item ID.

If a value exists, the existing item in Shopify will be updated.

If the item doesn't exist, it will be created in Shopify.

Then, multiple fields from the newly created Shopify item will be saved back on the item master in SAP Business One in the following UDFs:

• U_V33SB_SHOPIFYITEMID
• U_V33SB_SHOPIFYITEMINVTID (Shopify Inventory Item ID)
• U_V33SB_SHOPIFYVARIANTID (Shopify Variant ID)

Workflow Diagram 

Mapping

If the item doesn't exist or is a new item in SAP Business One, the item is created in Shopify using the mapping above.

The newly created Shopify item details are saved in UDFs on the item master: 

Assumptions 

• By default, the first price list is selected by the starter workflow and updates the list to Shopify. 

• Weight is not a required mapping and not part of the starter workflow. 

• For items that exist in both systems before this workflow is implemented, a bulk update will be required to populate the Shopify UDFs on the item master in SAP Business One.

  • This establishes the item relationship between the Shopify and SAP Business One systems and prevents duplicates in Shopify. 

• There is no support for variants in the starter workflow.

Next