Step 2 – Scenario Selection of Shopify in the Integration Hub
The scenarios (for example, Master Data, Transactions) are preselected. For scenarios such as Customer, Product, Order, Reserve Invoice, Incoming Payment, Delivery, Credit Memo, and Outgoing Payment, the direction of integration (i.e. from Shopify to SAP Business One or from SAP Business One to Shopify) and field mapping is selected by default.
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 Shopify to SAP Business One. The Customer mapping list contains the following fields:
Mapping is unidirectional from Shopify to SAP Business One. The Customer mapping list contains the following fields:
|
SAP Business One
|
Shopify
|
|
Customer.CardCode
|
Customer.ID
|
|
Customer.CardName
|
Customer.FIRST_NAME
|
|
Customer.Email
|
Customer.E_MAIL
|
|
Customer.Phone
|
Customer.Phone
|
|
Customer.Remark
|
Customer.Note
|
|
Customer.Type
|
Customer.Type
|
|
Customer.Default Group
|
Customer.Group
|
|
Customer.Currency
|
Customer.Currency
|
|
Customer.Payment Term
|
Customer.Payment Term
|
|
Address.Address Name
|
Address.Company
|
|
Address.Street
|
Address.Address
|
|
Address.Block
|
Address.Apartment
|
|
Address.State
|
Address.State
|
|
Address.Country
|
Address.Country
|
|
Address.Zip Code
|
Address.Zip Code
|
|
Address.City
|
Address.City
|
|
Address.Address Name 2
|
Address.Name
|
Scenario Name – Product:
Mapping is bidirectional between Shopify and SAP Business One. The Product mapping list contains the following fields:
Mapping is bidirectional between Shopify and SAP Business One. The Product mapping list contains the following fields:
|
SAP Business One
|
Shopify
|
|
Item.ItemCode
|
Product.sku
|
|
Item.ItemName
|
Product.Product Name
|
|
Item.SalesUnitWeight
|
Product.weight
|
|
Item.Item Remarks
|
Product.Description
|
|
Product.Tax Liable
|
Product.Charge taxes on this product
|
|
Item.Bar Code
|
Product.Barcode (ISBN, UPC, GTIN, etc.)
|
|
Item.Price
|
Product.Price
|
|
Item.Inventory Item
|
Product.Track quantity
|
|
Item.Weight Unit
|
Product.weight unit
|
|
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 Shopify. The Stock mapping list contents:
Mapping is from SAP Business One to Shopify. The Stock mapping list contents:
|
SAP Business One
|
Shopify
|
|
Item.ItemCode
|
Product.SKU
|
|
Warehouse
|
Location Name
|
|
Quantity
|
Quantity
|
Scenario Name – Order, Reserve Invoice, Incoming Payment:
Mapping is unidirectional from Shopify to SAP Business One. The Order, Reserve Invoice, Incoming Payment mapping list contains the following fields:
Mapping is unidirectional from Shopify to SAP Business One. The Order, Reserve Invoice, Incoming Payment mapping list contains the following fields:
|
SAP Business One
|
Shopify
|
|
Order.DocDate
|
Order.created_at
|
|
Order.DocDueDate
|
Order.created_at
|
|
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.Address Name2
|
Shipping_address.name
|
|
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.ShipToPhone | Shipping_address.phone |
|
AddressExtension.Address Name2
|
Billing_address.name
|
|
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
|
AddressExtension.BillToPhone | Billing_address.phone |
Scenario Name – Delivery:
Mapping is bidirectional between Shopify and SAP Business One. The Delivery mapping list contains the following fields:
Mapping is bidirectional between Shopify and SAP Business One. The Delivery mapping list contains the following fields:
|
SAP Business One
|
Shopify
|
|
Delivery.DocDate
|
Fullfilment.created_at
|
|
Delivery.DocDueDate
|
Fullfilment.created_at
|
|
Delivery.CardCode
|
Fullfilment.customer
|
|
Delivery.Customerr Reference no
|
Fullfilment.order number
|
|
Delivery.Comments
|
Fullfilment.comments
|
|
Delivery.DocTotal
|
Fullfilment.total price
|
|
Delivery.TotalTax
|
Fullfilment.total tax
|
|
Delivery.ItemCode
|
Fullfilment.sku
|
|
Delivery.Unit Price
|
Fullfilment.price
|
|
Delivery.Quantity
|
Fullfilment.quantity
|
|
Delivery.TrackingNumber
|
Fullfilment.tracking number
|
|
Delivery.Warehouse
|
Fullfilment.location id
|
|
Delivery.Line Item Id
|
Fullfilment.line item id
|
|
Delivery.Freight Charges
|
Fullfilment.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
|
Scenario Name – Credit Memo, Outgoing Payment:
Mapping is unidirectional from Shopify to SAP Business One. The Credit Memo, Outgoing Payment mapping list contains the following fields:
|
SAP Business One
|
Shopify
|
|
CreditMemo.DocDate
|
Refund.created_at
|
|
CreditMemo.DocDueDate
|
Refund.created_at
|
|
CreditMemo.CardCode
|
Refund.customer
|
|
CreditMemo.Comments
|
Refund.comments
|
|
CreditMemo.DocTotal
|
Refund.total price
|
|
CreditMemo.TotalTax
|
Refund.total tax
|
|
CreditMemo.ItemCode
|
Refund.sku
|
|
CreditMemo.Unit Price
|
Refund.price
|
|
CreditMemo.Quantity
|
Refund.quantity
|
|
CreditMemo.Line Item Id
|
Refund.line item id
|
|
CreditMemo.Freight Charges
|
Refund.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
|
Choose the Next button to proceed to Step 3.