Workflow: SAP Business One Business Partner to WooCommerce Customer
First published on: 07/26/2023/8:33 pm
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 WooCommerce customer ID.
If a value exists, the existing customer in WooCommerce will be updated.
If the value doesn't exist, the customer will be created.
The customer ID field from the newly created WooCommerce customer will be saved on the business partner master in SAP Business One in UDF U_V33SB_EXTBPID.
Workflow Diagram
Field Mappings
|
SAP Business One Business Partner |
WooCommerce Customer |
Comments |
|
OCRD.CardCode |
Custom field |
If required |
|
OCRD.E_Mail |
|
|
|
OCRD.CardName |
last_name |
|
|
CRD1.Street |
billing /address_1 |
Default Billing Address |
|
CRD1.Address2 |
billing /address_2 |
|
|
CRD1.City |
billing /city |
|
|
CRD1.State |
billing /state |
|
|
CRD1.ZipCode |
billing /postcode |
|
|
CRD1.Country |
billing /country |
|
|
CRD1.Street |
shipping /address_1 |
Default Shipping Address |
|
CRD1Address2 |
shipping /address_2 |
|
|
CRD1.City |
shipping /city |
|
|
CRD1.State |
shipping /state |
|
|
CRD1.ZipCode |
shipping /postcode |
|
|
CRD1.Country |
shipping /country |
|
Assumptions
- SAP Business One is the system of record for customers.
- When customers or business partners exist in SAP Business One and WooCommerce before this workflow is implemented, a bulk update is required to populate the WooCoomerce UDFs on the business partner record in SAP Business One to establish the relationship between the two systems.
- This will avoid duplicate customer records being created in WooCoomerce.
|
Last modified: 11/15/2023/8:21 pm |