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.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
|
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.
Related Articles
Shopify integration with SAP Business One
Shopify is an e-commerce platform that allows users to create online retail stores. This cloud-based platform gives the flexibility to access and run a business from anywhere. Shopify allows users to: Create and customize an online store. Sell in ...Setup in SAP Business One for Shopify in the Integration Hub
After deploying Shopify in the Integration Hub, check that the feature is correctly activated in SAP Business One and enter the B1i server details. To do so, perform the following: In the SAP Business One Main Menu, choose Administration → ...Step 1 – Set Connectivity of Shopify in the Integration Hub
1.Choose the SAP Business One SLD to provide the connection between SAP Business One system ID and the Shopify ID. Note By default, the solution displays all the SAP Business One SLDs available in the SLD Category field selected during customer ...Synchronization of Shopify in the Integration Hub
The following two methods are available for synchronizing data between SAP Business One and Shopify: Manual Synchronization: If you want integrations to be performed immediately (instead of waiting for the SCHEDULER services run), choose the Sync ...Step 3 – Deployment of Shopify in the Integration Hub
The Integration Hub pre-checks the configurations before the solution can be deployed. The Configuration Summary table is displayed. If all steps are successful, the solution is ready for deployment. To deploy the solution, choose the Deploy Now ...