Skip to Content
Business Trends
Author's profile photo Harini Vijayakumar

Shopify Integration with SAP ByDesign

Introduction:

Integrated systems demonstrate better performance comparing to the sum of all independent ones. In the below article let us see how ERP Logic’s integration solution helps in keeping Shopify Plus and SAP ByDesign in synch. Integration with Shopify plus is separated into two parts for ease of understanding. The first Part handles Master Data Integration and the Second Part Integrates transaction data between both systems.

Requirement:

At high-level the following are the requirements considered while developing the Integration

  • Fulfilled orders from the Shopify Plus system will be sent to Webhook Processor and those orders are created in ByDesign as Sales Order/Customer Invoice staging tables. This process will be triggered immediately after the order fulfilment occurs in Shopify Plus System.
  • The Webhook Processor checks for any new products created or updated in ByDesign by sending a webservice request at regular intervals and sends the details to Shopify Plus system.
  • At Regular Intervals the inventory data from ByDesign shall be sent to Shopify Plus via Webhook Processor.

Solution:  

The custom solution is developed using SAP Cloud Application Studio utilizing webhook Processor and the APIs provided by Shopify Plus System.

          Process Flow:

  • Sales Transaction
  • Inventory
  • Product

 

1.Sales Transaction :

2. Inventory :

 

3. Product :

Once the solution is deployed, a custom Work Center will be available to the enabled users in the SAP Business ByDesign.

 

Now let us see different Scenarios that are done for this Integration.

  1. Sales Transaction – With Credit Card Payment
  • In this scenario, any account holder in Shopify Plus can place the Order for the Goods by making a Credit Card Payment. Once the order is placed, the Fulfilment to the Order triggers the Transaction synch into SAP ByDesign.
  • The Sales Order and the Bank Payment clearing (Receivables) against the Shopify Order will be created in SAP ByDesign.
  1. Sales Transaction – With Account Payment (B2B)
  • In this scenario, any account holder in Shopify can place the Order for the Goods assigning B2B Payee – “Payment Method – B2B”. Once the order is placed, the Fulfilment to the Order, triggers the transaction creation in ByDesign.
  1. Sales Transaction – Drop Shipment with Credit Card
  • In this scenario, the Order is marked as Dropship Order in Shopify Plus, the Payment and Invoice Request are alone created in ByDesign once the fulfilment is done.
  • The Drop shipment Order are completely handled in Shopify Plus and since most of the inventory movement takes place directly with Supplier, there is no inventory related transaction posted in ByDesign. So, the Invoice Request is directly created for the Accounts (Generic Customer).
  • Invoice Job run, converts the Invoice Request to Invoice. The Invoice Clearing Run automatically assigns the payment to Open Invoices and Clears.
  • On the Supplier side of Invoice is directly posted in ByDesign as Manual Supplier Invoice, with the Shopify Drop shipment Order reference.
  1. Sales Transaction – Drop Shipment with Account Payment B2B
  • In this scenario, the Order is marked as Dropship Order in Shopify Plus and the Payment & Invoice Request are alone created in ByDesign once the fulfilment is done. Since the Payment Type is “B2B Payment”, the transactions are created directly under the Account.

Benefits:

  • Configuration and Deployment is made easy.
  • Less human Involvement.
  • Log screens to capture exceptions and errors are logged and can be tracked within SAP ByDesign.
  • Option to Resend the failed integration records.
  • Helps to transfer data between two systems.

Conclusion:

Transferring data between two systems via Integration helps to save time and improves better communication between two systems. Kindly share your questions and feedback in comment section. For more details please visit https://erplogic.com.

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Venkatesh Govindan
      Venkatesh Govindan

      Hi Harini,

      Good Job. Please help us to understand about the webhook processor. Is it a standalone program outside SAP ByD or built in SAP Cloud application Studio? Thanks

      Regards

      Venkatesh

      Author's profile photo Harini Vijayakumar
      Harini Vijayakumar
      Blog Post Author

      Hi Venkatesh,

      Yes , webhook processor is a standalone program outside SAP ByD.

       

      Regards,

      Harini