SAP Business One Delivery Note to ShipStation Order
First published on: 08/03/2023/12:00 am
Workflow Description
This workflow creates a new order in ShipStation when a delivery note is created in SAP Business One.
The workflow then updates the SAP Business One delivery note with the ShipStation order ID using UDF U_V33SB_ShipStationOrderId.
Workflow Diagram
Mapping
The following mapping will be applied:
|
SAP Business One Delivery |
ShipStation Order |
Comments |
|---|---|---|
|
Header |
|
|
|
DocNum |
orderNumber |
|
|
DocEntry |
orderKey |
|
|
DocDate |
paymentDate |
|
|
DocDate |
orderDate |
|
|
DocTotal |
orderTotal |
|
|
DocTotal |
amountPaid |
|
|
VatSum |
taxAmount |
|
|
DocTotal |
shippingAmount |
|
|
|
orderStatus |
“awaiting_shipment” |
|
Lines |
|
|
|
ItemCode |
items.sku |
|
|
ItemDescription |
items.name |
|
|
Quantity |
items.quantity |
|
|
Price |
items.unitPrice |
|
|
Addresses |
|
|
|
CardName |
billTo.name |
|
|
BillToStreet |
billTo.street1 |
|
|
BillToCity |
billTo.city |
|
|
BillToZipCode |
billTo.postalCode |
|
|
BillToState |
billTo.state |
|
|
BillToCountry |
billTo.country |
|
|
CardName |
shipTo.name |
|
|
ShipToStreet |
shipTo.street1 |
|
|
ShipToCity |
shipTo.city |
|
|
ShipToZipCode |
shipTo.postalCode |
|
|
ShipToState |
shipTo.state |
|
|
ShipToCountry |
shipTo.country |
|
Update Business One Delivery:
|
ShipStation |
SAP BUSINESS ONE Delivery |
Comments |
|---|---|---|
|
Header |
|
|
|
orderId |
U_V33SB_ShipStationOrderId |
|
|
|
U_V33SB_EXTERNALORDERSRC |
“ShipStation” |
Assumptions
- ShipStation SKU will match SAP Business One ItemCode.
- The default username and email for ShipStation orders must be provided.
|
Last modified: 11/15/2023/8:21 pm |