Step 2 – Scenario Selection of Shopify in the Integration Hub

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:

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: 

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:

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: 
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: 

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 ...