Shopify Fulfillment to SAP Business One Delivery and SAP Business One A/R Invoice
First published on: 10/19/2023/10:16 am
Workflow Summary
- The workflow assumes a Shopify order is fulfilled from Shopify.
- The workflow creates a delivery document on SAP Business One (linked to the appropriate sales order), including tracking number details.
- Offers an option to create the AR invoice.
- Supports partial fulfillments.
- Supports multi-warehouse inventory fulfillments.
Workflow Description
The workflow will be triggered when a fulfillment is created in Shopify.
This workflow process will create the SAP Business One delivery and SAP Business One A/R invoice for the relevant SAP Business One order.
Workflow Diagram
Mapping
SAP Business One Delivery
|
Shopify Fulfillment Field |
SAP Business One Delivery Field |
Comments |
|---|---|---|
|
Header |
|
|
|
created_at |
ODLN.DocDate |
|
|
created_at |
ODLN.DocDueDate |
|
|
|
ODLN.CardCode |
Business Partner retrieve from Order |
|
order_number |
ORDR.NumAtCard |
|
|
id |
ORDR.U_V33SB_EXTERNALORDERID |
|
|
|
ORDR.U_V33SB_EXTERNALORDERSRC |
“Shopify” |
|
Lines |
|
|
|
|
BaseType |
17 |
|
|
BaseEntry |
Related SAP B1 order docentry |
|
|
BaseLine |
Related SAP B1 line number |
|
line_items.quantity |
Quantity |
|
|
line_items.id |
U_V33SB_EXTERNALLINEID |
|
|
Expenses (Tax and Freight) |
|
|
|
|
ExpnsCode |
‘ShopifyTax’ code |
|
total_tax |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
|
ExpnsCode |
‘ShopifyFreight’ code |
|
shipping_lines.price |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
|
ExpnsCode |
‘ShopifyDiscount’ code |
|
total_discounts |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
Addresses |
|
|
|
billing_address.address1 |
StreetB |
|
|
billing_address.address2 |
Address3B |
|
|
billing_address.first_name + billing_address.last_name |
Address3B |
|
|
billing_address.city |
CityB |
|
|
billing_address.zip |
ZipCodeB |
|
|
billing_address.province_code |
StateB |
|
|
billing_address.country_code |
CountryB |
|
|
shipping_address.address1 |
StreetS |
|
|
shipping_address.address2 |
Address2S |
|
|
shipping_address.first_name + shipping_address.last_name |
Address3S |
|
|
shipping_address.city |
CityS |
|
|
shipping_address.zip |
ZipCodeS |
|
|
shipping_address.province_code |
StateS |
|
|
shipping_address.country_code |
CountryS |
|
SAP Business One A/R Invoice
|
Shopify Field |
SAP Business One AR Invoice Field |
Comments |
|---|---|---|
|
Header |
|
|
|
created_at |
ODLN.DocDate |
|
|
created_at |
ODLN.DocDueDate |
|
|
|
ODLN.CardCode |
Business Partner retrieve from Order |
|
order_number |
ORDR.NumAtCard |
|
|
id |
ORDR.U_V33SB_EXTERNALORDERID |
|
|
|
ORDR.U_V33SB_EXTERNALORDERSRC |
“Shopify” |
|
Lines |
|
|
|
|
BaseType |
15 |
|
|
BaseEntry |
Related SAP B1 delivery docentry |
|
|
BaseLine |
Related SAP B1 delivery line number |
|
line_items.quantity |
Quantity |
|
|
line_items.id |
U_V33SB_EXTERNALLINEID |
|
|
Expenses (Tax and Freight) |
|
|
|
|
ExpnsCode |
‘ShopifyTax’ code |
|
total_tax |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
|
ExpnsCode |
‘ShopifyFreight’ code |
|
shipping_lines.price |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
|
ExpnsCode |
‘ShopifyDiscount’ code |
|
total_discounts |
LineTotal |
|
|
|
TaxCode |
Exempt |
|
Addresses |
|
|
|
billing_address.address1 |
StreetB |
|
|
billing_address.address2 |
Address3B |
|
|
billing_address.first_name + billing_address.last_name |
Address3B |
|
|
billing_address.city |
CityB |
|
|
billing_address.zip |
ZipCodeB |
|
|
billing_address.province_code |
StateB |
|
|
billing_address.country_code |
CountryB |
|
|
shipping_address.address1 |
StreetS |
|
|
shipping_address.address2 |
Address2S |
|
|
shipping_address.first_name + shipping_address.last_name |
Address3S |
|
|
shipping_address.city |
CityS |
|
|
shipping_address.zip |
ZipCodeS |
|
|
shipping_address.province_code |
StateS |
|
|
shipping_address.country_code |
CountryS |
|
|
Last modified: 02/26/2024/4:36 pm |