🛍 Shopify application for HerbaMadrid store 🌿

Summary

Ruby on Rails application to manage Shopify store´s stock.

Introduction

Herbo-stock provides a list of features through the fulfillment service Distribudiet to keep a Shopify store up-to-date.

📸 Application UI

How it works

Catalog management

We allow to load the fulfillment service remote catalog from a shared CSV to Shopify. Here a hightlight of how the process works under the hood:

• It generates the product in the app to keep the original format
• It parses the original product into a Shopify product with the required format. Then we creates/updates in the Shopify store.

It has two running modes:

• Manual: we can either load the whole catalog or filtered by SKU.
• Scheduled: we can load the whole catalog based on a scheduler based on minutes, hours or days.

Shopify catalog synchronization

We keep up-to-date each product of the catalog through the following Shopify work-flows:

• Shopify requests by default for an availability update each hour where all the products are updated. The request is done agains an specific endpoint.
• Shopify communicates once a fulfillment order is created (once an order is processed and archived). Then, the application updates the product in Shopify and the app itself. The request is done through a webhook

Shopify stock synchronization

The app loads the following async processes once the server is up:

• Process catalog loader: it represents the heaviest process to load the entire the fulfillment service catalog.
• Process stock refresher: it represents a light process to load the fulfillment service stock.
• Process stock archiver: it represents a light process to disable those products which are no longer part of the fulfillment service catalog.

Then, Shopify fetches each hour the fulfillment service stock from our app to get the fresh picture of our stock.

Additional features

• All the actions are internally audited to keep tracking of them.
• Once a product got no availability, we temporarilly mark it as archived.
• Once a product archived is refilled, we mark it as active again.
• Once the application is uninstalled, a webhook will manage the cleaning-up of the affected shop internally.