BigCommerce Order to SAP Business One Order
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 BigCommerce orders created since the last integration run.
The integration will only retrieve orders that have a status of “awaiting fulfillment” in Big Commerce. Sales orders will be created in SAP Business One.
When a sales order is added in BigCommerce, the integration will check a UDF on the SAP Business One sales order called ‘U_V33SB_BCORDERID’, which contains the BigCommerce Sales order ID.
If a value doesn't exist, a sales order will be created and the sales order ID from BigCommerce will be saved to the sales order in SAP Business One on UDF ‘U_V33SB_ BCORDERID.’
The workflow will also create the SAP Business One down payment invoice and incoming payment documents when creating the sales order in SAP Business One.
Workflow Diagram
Mapping
The following mapping will be applied:
Create SAP Business One Order
|
BigCommerce Order |
SAP Business One Order |
|
|---|---|---|
|
Header |
||
|
date_created |
DocDate |
|
|
customer_id |
CardCode |
“GetBPCardCodeByExtId” Query Result based on customere_id |
|
id |
U_V33SB_BCORDERID |
|
|
Lines |
||
|
sku |
ItemCode |
|
|
orderitem.quantity |
Quantity |
|
|
|
TaxCode |
Default value |
|
|
ShippingMethod |
“GetShippingCode” Query Result |
|
orderitem.Base_price |
UnitPrice |
|
|
orderitem.id |
U_V33SB_BCORDERLINEID |
|
|
Expenses.TaxPayment |
||
|
|
ExpenseCode |
“GetExpenseCode” Query Result |
|
Total_tax |
LineTotal |
|
|
|
TaxCode |
Default Value |
|
Expenses.Frieght |
||
|
|
ExpenseCode |
“GetExpenseCode” Query Result |
|
Base_shipping_cost |
LineTotal |
|
|
|
TaxCode |
Default Value |
|
Addresses |
||
|
Billing_address.street_1 |
BillToAddress3 |
|
|
Billing_address.country_sio2 |
BillToCountry |
|
|
Billing_address.state |
BillToState |
“GetStateCodeByName” Query Result based on Billing_address.state |
|
Billing_address.zip |
BillToZipCode |
|
|
Billing_address.city |
BillToCity |
|
|
Billing_address.street_1 |
BillToStreet |
|
|
Shippingaddress.country_sio2 |
ShipToCountry |
|
|
Shippingaddress.state |
ShipToState |
“GetStateCodeByName” Query Result based on Shippingaddress.state |
|
Shippingaddress.city |
ShipToCity |
|
|
Shippingaddress.street_2 |
ShipToBuilding |
|
|
Shippingaddress.street_1 |
ShipToStreet |
|
|
Shippingaddress.first_name Shippingaddress.last_name |
ShipToAddress2 |
Two value concatenate |
|
Shippingaddress.zip |
ShipToZipCode |
|
Down Payment Invoice
|
BigCommerce Order |
SAP Business One Down Payment Invoice |
|
|
date_created |
DocDate |
|
|
Date_modified |
DocDueDate |
|
|
customer_id |
CardCode |
“GetBPCardCodeByExtId” Query Result based on customere_id |
|
amount |
DocTotal |
|
|
|
Confirmed |
‘tYES’ |
|
|
DownPaymentType |
‘dptInvice’ |
|
id |
U_V33SB_BCORDERID |
|
|
Lines |
||
|
|
BaseType |
‘17’ |
|
id |
BaseEntry |
“GetOrderDocEntryByExtId” Query Result based on id |
|
orderitem.id |
BaseLine |
“GetOrderLine” Query Result based on id and orderitem.id |
Incoming Payment
Note: The incoming payment will be created against the down payment invoice created in the previous step.
|
BigCommerce Order |
SAP Business One Incoming Payment |
|
|
Header |
||
|
date_created |
DocDate |
|
|
customer_id |
CardCode |
“GetBPCardCodeByExtId” Query Result based on customere_id |
|
|
TransferAccount |
Default Value |
|
payments.amount |
TransferSum |
|
|
|
DocObjectCode |
Bopot_IncoingPayments |
|
PaymentInvoices Lines |
||
|
id |
DocEntry |
“GetDownPaymentDocEntry” Query Result based on id |
|
|
InvoiceType |
‘it_DownPayment’ |
Assumptions
- The standard workflow creates the following SAP Business One documents: sales order, down payment invoice, and incoming payment.
- This assumes the payment is taken when placing the order in BigCommerce.
- If the business process varies from this, it must be discussed before implementation.
|
Last modified: 11/15/2023/8:21 pm |