SAP Business One Business Partner (BP) to Shopify Customer

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

Workflow Summary

• This workflow scans SAP Business One at regularly scheduled intervals for newly created or modified business partners, then updates a Shopify customer record.
  • If a customer doesn't exist in Shopify, one will be created, and the client ID field value will be saved back to the business partner master in SAP Business One. 
• The workflow creates or modifies the billing address, shipping address, and contact on the SAP business partner card.

Workflow Description 

When a business partner is created or updated in SAP Business One, the integration process will check a UDF on the business partner master called U_V33SB_EXTBPID, which contains the Shopify customer ID.

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

If the value doesn't exist, the customer will be created, and the customer ID field from the newly created Shopify customer will be saved on the business partner master in SAP Business One in UDF U_V33SB_EXTBPID.

The integration process will then check UDFs on the business partner master U_V33SB_EXTBADDRESSID (Shopify Billing Address) and U_V33SB_EXTSADDRESSID (Shopify Shipping Address) to create or update the customer billing and shipping addresses.  

Workflow Diagram

Mapping 

Shopify Customer

The newly created Shopify customer ID is saved in the UDF on the business partner master: 

Shopify Customer Billing Address

The newly created Shopify billing address ID is saved in the UDF on the business partner master: 

Shopify Customer Shipping Address

The newly created Shopify shipping address ID is saved in the UDF on the business partner master: 

Previous

Next