SAP Business One Business Partner to BigCommerce Customer
First published on: 08/10/2023/6:54 pm
Workflow Description
In this workflow, a scheduled job will run at regular intervals (configurable) to retrieve SAP Business One business partners that have been added or modified since the last integration run and create or update customers in BigCommerce.
When a business partner is created or updated in SAP Business One, the workflow will check business partner UDF ‘U_V33SB_BCCUSTID’, which contains the BigCommerce customer ID.
If a value exists, the existing customer in BigCommerce is updated. If the customer doesn't exist, one will be created and the BigCommerce customer ID will be saved to the SAP Business One business partner UDF ‘U_V33SB_BCCUSTID.’
Workflow Diagram
Mapping
The following mapping will be applied:
|
SAP Business One Business Partner |
BigCommerce Customer |
Comments |
|---|---|---|
|
EmailAddress |
|
|
|
CardName |
first_name |
|
|
CardName |
Last_name |
|
|
Phone1 |
phone |
|
|
Address |
|
|
|
AddressName |
address1 |
|
|
Street |
address2 |
|
|
City |
city |
|
|
Country |
country_code |
|
|
ContactEmployees.FirstName |
first_name |
(First Contact) |
|
ContactEmployees.LastName |
Last_name |
(First Contact) |
|
ContactEmployees.Phone1 |
phone |
|
|
ZipCode |
Postal_code |
|
|
State |
state_or_province |
“GetStateName” Query Result based on BPAddresses.State |
|
Last modified: 08/30/2024/1:40 pm |
On this page