Shopify to Galaxy Integration

Application integration system for Shopify stores that synchronizes their product catalogs and stock data with the Greek-market-oriented Galaxy ERP.

My involvement in this Cluster CIS project as a sole developer included development, testing, deployment, and direct communication with the clients throughout all the stages.

The system features highly frequent synchronization of the Shopify store with the ERP products, attributes, categories, images, and stock quantities. This is achieved through efficient GraphQL queries and data processing, and fine-tuned batching and queueing.

Technical overview

• Built with Node-RED, a low-code development tool that can be employed for crafting app integration and ETL pipelines.
• Node.js functions are used to handle advanced data transformation.
• Shopify data is fetched and updated with REST API calls and GraphQL queries.
• MSSQL queries fetch the ERP data.