The American personal care company, aimed to optimize its business operations by integrating its JD Edwards ERP system with Shopify and MSSQL database. The objective was to enable seamless data synchronization and improve order processing, inventory management, and product information exchange between the systems. The integration project also involved to validate and fulfil orders, as well as updating store information to Google Drive. The implementation was planned for a duration of 3 months and covered operations in 5 countries.
● Inefficient Order Processing from Shopify to JDE: The company experienced delays and potential errors in order processing while transferring data from Shopify to JD Edwards
● Manual Customer Validation and Fraud Checks: The manual customer validation and fraud check processes resulted in time-consuming operations, impacting efficiency.
● Difficulty in Managing Inventory and Fulfillment: Managing inventory and fulfillment between Shopify and the ERP system posed challenges, affecting timely and accurate order fulfillment.
● Inability to Transfer Store Details to Google Drive: The company faced difficulties in transferring store information from JD Edwards to Google Drive for easy access and reporting.
● Need for Robust BI Capabilities: To leverage data stored in the MSSQL database, the company required robust Business Intelligence (BI) capabilities for analysis and insights.