Shopify-API Export in ETL-Pipeline

Initial situation

KingController GmbH is an online shop for gamers looking for individually configured game controllers. The shop includes over 500 different parts that can be combined to create the perfect controller. To enable this customisation, Shopify was extended with the MyCustomizer plugin. However, the orders generated in this way could no longer be imported directly into the ERP system Xentral.

So the goal is to develop a lean data pipeline to enable the automatic import of orders from Shopify and MyCustomizer to Xentral.

Our solution

We have automated this process with Laravel. The app retrieves orders from Shopify via API and converts them into the required XML-based format. The app is also able to automatically import the orders into Xentral via Webhook.

To ensure that the process runs smoothly, we implemented a small management dashboard with Laravel Nova that allows the user to monitor the import status of orders and repeat import processes if necessary.

Benefits

This customised solution has optimised and accelerated KingController's workflows.