Case Study
Innovating App with React and Node JS: A Symphony Story
Industry
Manufacturing & E-commerce
Core Technologies
MySQLNode.jsReact.jsShopify-SAP Integration
Challenges
Symphony relied on a manual order processing system, leading to errors, inefficiencies, and communication gaps. Managing inventory, order tracking, warranty registrations, and returns across multiple systems, including SAP HANA and third-party logistics (3PL) partner Delhivery, was a complex and time-consuming task.
Key challenges included:
Delayed Order Processing: Manual data entry caused delays and errors in order management.
Lack of Automation: No real-time synchronization between Shopify, SAP, and 3PL systems, leading to mismanaged inventory and shipping delays.
Inefficient GST Validation: No automated system to verify GST numbers for B2B orders, increasing compliance risks.
Complex Return & Replacement Management: Shopify did not support custom return/refusal policies, requiring manual handling of returns and refunds.
Solutions
To streamline Symphony’s operations, we developed a custom Middleware solution, a robust system integrating Shopify, SAP HANA, and 3PL logistics partners, ensuring automation and process efficiency.
Key Functionalities of Middleware Solution:
Automated Order Processing: Orders are seamlessly transferred from Shopify to SAP HANA, reducing manual effort and errors.
Real-time Inventory Sync: Existing product details such as SKU, quantity, and pricing are automatically updated from SAP to Shopify.
GST Validation API: Developed a custom API to validate GST numbers for B2B orders, ensuring tax compliance.
Seamless Invoice Generation: SAP-generated invoices are automatically pushed to Shopify, allowing customers to download invoices directly from their dashboard.
Integrated Order Tracking: Shipping labels with tracking numbers and URLs are generated, enabling customers to track their shipments in real-time.
3PL Logistics Automation:
Shopify-SAP integration communicates with Delhivery (3PL), sharing shipping details, CFA locations, and customer addresses.
This automates the entire delivery process, ensuring faster and more reliable order fulfillment.
Custom Return & Replacement Module: Implemented Symphony’s return, replacement, and refusal policies, enhancing customer experience and operational efficiency.
Order workflow (Custom App)
The various functionalities of this custom application:
-
Orders are moved/communicated from Shopify Store to SAP(HANA) with the help of our custom application.
-
Existing products can be pushed from SAP to Shopify. All the product details, from the name, SKU, quantity, price, etc., are pulled from SAP to Shopify with the help of our custom application.
-
We have created an API that checks whether the GST numbers are valid when determining B2B orders.
-
Billing Documents (invoices) can be sent from SAP to Shopify. As soon as an invoice is posted to accounting within SAP, it gets generated within Shopify and displayed on the dashboard so the customer can download it easily.
-
Our custom application creates the shipping label (consisting of tracking number and URL) and provides the information to SAP, which is then pulled to the Shopify store. The customer can easily track their shipment through it.
-
Our custom application also integrates Shopify stores and SAP with 3PL (i.e., the third-party logistics) to whom we communicate the shipping address and CFA location. This leads to a completely automated and smooth delivery process.
-
Symphony Ltd has various return, replacement, and refusal policies, which are applied with the help of our custom application so that there is no inconvenience to the customers.
Technologies and Tools
Backend Development
Node.js
Frontend Development
React.js
Database Management
MySQL
Enterprise Integration
Shopify-SAP HANA Sync, 3PL Logistics (Delhivery)
Automated Compliance
GST Validation API
Results
50% Reduction in Manual Effort: Automated processes minimized manual data entry, reducing errors and processing time.
40% Faster Order Fulfillment: Seamless integration between Shopify, SAP, and 3PL partners accelerated order processing and delivery times.
Improved Inventory Management: Real-time updates ensured accurate stock levels and pricing, optimizing supply chain efficiency.
Better Compliance & Security: Automated GST validation reduced compliance risks for B2B transactions.
Enhanced Customer Experience: A seamless return and replacement system resulted in higher customer satisfaction and retention.
Words of Appreciation
"We partnered with Lucent Innovation to expand our B2C e-commerce platform, and their seamless integration of our ERP with Shopify has been invaluable. Their support during peak seasons ensured zero downtime and improved customer satisfaction. We've also worked on custom development projects, and our experience with Lucent has been exceptional."
Ashwin Prajapati
Former Group CIO, Symphony Limited
One-stop solution for next-gen tech.