Home / Projects / Lola's Apicbase Updater App

Lola's Apicbase Updater App

Lola's Apicbase Updater App

Project Overview

Django app that syncs product data between Apicbase and Shopify with live progress and reporting.

ApicbaseApp is a smart sync tool for Lola’s Bakery. It keeps product data like ingredients, allergens, and nutrition info the same on both Apicbase (used in the kitchen) and Shopify (used online). The app helps staff update things quickly with just a click.

The process runs in the background, and staff can see live updates through WebSockets. It handles big bundles, tracks every stage, and shows results clearly. Errors are caught and shown with helpful messages.

The app saves hours of manual work and keeps food data correct and legal, with full support for complex bundles, portion sizes, and UK food laws like Southampton6 rules.

Key Features

  • Imports recipes from Apicbase based on last update time
  • Pulls ingredients, allergens, and full nutrition data
  • Reformats nutritional data according to UK food laws
  • Handles complex bundles and portion sizes
  • Pushes updates to Shopify via GraphQL API
  • Live progress tracking with WebSockets
  • Clear list of what was updated or skipped
  • CSV export of update results
  • Cancel tasks in real time
  • Clean dashboard UI with live notifications

Project Gallery

Live progress view showing current update task
Live progress view showing current update task
Results view with details on updated and skipped items
Results view with details on updated and skipped items
No updates found – shows message when all products are up-to-date
No updates found – shows message when all products are up-to-date

Project Details

Technologies

Python Django Celery Redis Channels HTMX Alpine.js Bootstrap JavaScript Shopify API Apicbase API PrintNode API

Completed

February 2025

Client

Lola's Bakery

My Role

Full-stack Developer