Step 2 – Scenario Selection of WooCommerce in the Integration Hub

Step 2 – Scenario Selection of WooCommerce in the Integration Hub

  1. The Scenario Selection summary displays the Scenario Name, Data Direction, and Field Mapping. The Field Mapping further displays information of the Field in SAP Business One and the mapped field in WooCommerce.   


     Configuration Summary
2.   The Configuration summary displays the  Date and time for  Template Selection, Set Connectivity steps  and  Scenario Selection .     
For each scenario, choose the Field Mapping button to select or unselect the fields to be mapped in the Field Mapping window. Mandatory fields are grayed out and cannot be unselected.

Scenario Name – Customer: 
Mapping is unidirectional from WooCommerce to SAP Business One. The Customer mapping list contains the following fields:

SAP Business One

WooCommerce

Customer.CardCode

Customer.ID

Customer.CardName

Customer.FirstName + LastName

Customer.Email

Customer.Email

Customer.Phone

Customer.Phone

Customer.Fax

Customer.Fax

Customer.Type

Customer.Type

Customer.Default Group

Customer.Group

Customer.Currency

Customer.Currency

Customer.Payment Term

Customer.Payment Term

Phone1

Address.Billing Phone

Address.Address Name

Address.id

Address.Billing Street

Address.Address 1: Street 1

Address.Billing Block

Address.Address 1: Street 3

Address.Billing City

Address.Billing City

Address.Billing State/Province

Address.Billing State

Address.Billing Zip/Postal Code

Address.Billing Postal Code

Address.Billing Country

Address.Billing Country

Address.Address Name 3

Address.Billing Company


Scenario Name – Product: 
Mapping is bidirectional between WooCommerce and SAP Business One. The Product mapping list contains the following fields: 
            

SAP Business One

WooCommerce

Item.ItemCode

Product.id

Item.Name

Product.Name

Item.User_Text

Product.description

Item.Price

Product.regular_price

Item.Inventory Item

Product.Manage Stock

Item.SalesUnitLength

Product.ts_dimensions_length

Item.SalesUnitWidth

Product.ts_dimensions_width

Item.SalesUnitHeight

Product.ts_dimensions_height

Item.SalesUnitWeight

Product.weight

Item.Cross reference code

Product.id

Item.Variant Item

Product.variant

Item.Inventory item id

Product.inventory item id

Scenario Name –Stock : 
Mapping is from SAP Business One to WooCommerce. The Stock mapping list contents:

SAP Business One

WooCommerce

Item.ItemCode

Product.SKU

Warehouse

Location Name

Quantity

Quantity

Scenario Name – Order, Reserve Invoice, Incoming Payment: 
Mapping is unidirectional from WooCommerce to SAP Business One. The Order, Reserve Invoice, Incoming Payment mapping list contains the following fields:

SAP Business One

WooCommerce

Order.DocDate

Order.date_created

Order.DocDueDate

Order.date_created

Order.CardCode

Order.customer

Order.Customer Reference no

Order.order number

Order.Comments

Order.comments

Order.DocTotal

Order.total price

Order.TotalTax

Order.total tax

Order.DocumentStatus

Order.status

Order.ItemCode

Order.variant id

Order.Unit Price

Order.price

Order.Quantity

Order.quantity

Order.Line Item Id

Order.line item id

Order.Freight Charges

Order.shipping charges

AddressExtension.ShipToAddress2

Shipping_address.FirstName+LastName

AddressExtension.ShipToStreet

Shipping_address.address1

AddressExtension.ShipToBlock

Shipping_address.address2

AddressExtension.ShipToCity

Shipping_address.city

AddressExtension.ShipToZipCode

Shipping_address.zip

AddressExtension.ShipToState

Shipping_address.province_code

AddressExtension.ShipToCountry

Shipping_address.country_code

AddressExtension.BillToAddress2

Billing_address.FirstName+LastName

AddressExtension.BillToStreet

Billing_address.address1

AddressExtension.BillToBlock

Billing_address.address2

AddressExtension.BillToCity

Billing_address.city

AddressExtension.BillToZipCode

Billing_address.zip

AddressExtension.BillToState

Billing_address.province_code

AddressExtension.BillToCountry

Billing_address.country_code

Scenario Name – Delivery: 
Mapping is unidirectional from SAP Business One to WooCommerce. The Delivery mapping list contains the following fields: 

SAP Business One

WooCommerce

Delivery.ItemCode

Delivery.order_item_id

Delivery.Quantity

Delivery.qty

Delivery.CardCode

Delivery.customer

Delivery.Customer Reference no

Delivery.Delivery number

Delivery.Comments

Delivery.comments

Delivery.DocTotal

Delivery.total price

Delivery.Tax

Delivery.tax_code

Delivery.DocumentStatus

Delivery.status

Delivery.Unit Price

Delivery.price

Delivery.Line Item Id

Delivery.line item id

Delivery.Freight Charges

Delivery.shipping charges

AddressExtension.ShipToStreet

Shipping_address.address1

AddressExtension.ShipToBlock

Shipping_address.address2

AddressExtension.ShipToCity

Shipping_address.city

AddressExtension.ShipToZipCode

Shipping_address.zip

AddressExtension.ShipToState

Shipping_address.province_code

AddressExtension.ShipToCountry

Shipping_address.country_code

AddressExtension.BillToStreet

Billing_address.address1

AddressExtension.BillToBlock

Billing_address.address2

AddressExtension.BillToCity

Billing_address.city

AddressExtension.BillToZipCode

Billing_address.zip

AddressExtension.BillToState

Billing_address.province_code

AddressExtension.BillToCountry

Billing_address.country_code

Scenario Name – Credit Memo, Outgoing Payment: 
Mapping is unidirectional from WooCommerce to SAP Business One. The Credit Memo, Outgoing Payment mapping list contains the following fields: 

SAP Business One

WooCommerce

Credit Memo.ItemCode

Credit Memo.order_item_id

Credit Memo.Quantity

Credit Memo.qty

Credit Memo.CardCode

Credit Memo.customer

Credit Memo.Customer Reference no

Credit Memo.Credit Memo number

Credit Memo.Comments

Credit Memo.comments

Credit Memo.DocTotal

Credit Memo.total price

Credit Memo.Tax

Credit Memo.tax_code

Credit Memo.DocumentStatus

Credit Memo.status

Credit Memo.Unit Price

Credit Memo.price

Credit Memo.Line Item Id

Credit Memo.line item id

Credit Memo.Freight Charges

Credit Memo.shipping charges

AddressExtension.ShipToStreet

Shipping_address.address1

AddressExtension.ShipToBlock

Shipping_address.address2

AddressExtension.ShipToCity

Shipping_address.city

AddressExtension.ShipToZipCode

Shipping_address.zip

AddressExtension.ShipToState

Shipping_address.province_code

AddressExtension.ShipToCountry

Shipping_address.country_code

AddressExtension.BillToStreet

Billing_address.address1

AddressExtension.BillToBlock

Billing_address.address2

AddressExtension.BillToCity

Billing_address.city

AddressExtension.BillToZipCode

Billing_address.zip

AddressExtension.BillToState

Billing_address.province_code

AddressExtension.BillToCountry

Billing_address.country_code

    • Related Articles

    • WooCommerce integration with SAP Business One

      WooCommerce is an open-source e-commerce plugin for WordPress. It is designed for small to large-sized online merchants using WordPress. The integration between WooCommerce and SAP Business One facilitates automated, bi-directional data exchange ...

    • Setting Up WooCommerce in the Integration Hub

      The following are the steps to setup WooCommerce in Administration Console:  Add New Customer. Refer to  Add New Customer knowledge article.  Select the WooCommerce template to integrate. Upon selecting the template, a message “Let’s Start” prompts ...

    • Alerts Notification of WooCommerce in Integration hub

      Configure the alert settings in the Alert Notification tab in WooCommerce Settings window. The Alert Notification tab of WooCommerce Settings window contains the following fields: Field Name Description User Displays the list of users in SAP Business ...

    • Payment Mapping of WooCommerce in the Integration Hub

      Map the payment methods of WooCommerce in the Payment Mapping tab in the WooCommerce Settings window in SAP Business One.  A user needs to map WooCommerce Payment methods with the SAP Business One Credit Cards.  The payment methods other than Cash or ...

    • Setup in SAP Business One for WooCommerce in the Integration Hub

      1. In the SAP Business One Main Menu, choose Administration → Integration Hub → Application Deployment Status. The Deployment Status field should display 'Active', indicating that the feature is deployed in the Integration Hub. If the status displays ...