Case studies

Custom systems shaped around real stock and operations workflows.

A closer look at two custom systems: connected retail stock operations for Robert Bell Goldsmith and multi-location stock control for House of Somm.

ClientRobert Bell Goldsmith

Inventory management · Shopify integration

CASE STUDY 01

Connected retail stock operations

A protected inventory workspace connecting product records, stock movements, and Shopify order activity.

Project need

Keep product and variant stock visible across locations while handling reservations, returns, and online order changes in a controlled way.

System approach

We shaped the system around a stock ledger and linked it with Shopify inventory and order workflows. Product mappings and queued sync jobs help keep changes traceable, while unmatched product codes remain available for review.

What the system covers

Product catalogue, variants, locations, and stock balances
Reservations, returns, and auditable stock movements
Shopify order and fulfilment event handling
Inventory sync queue with mapping and retry visibility

ClientHouse of Somm

Hospitality · Stock control

CASE STUDY 02

Multi-location hospitality stock control

A stock-control system designed to track goods and movement across service and storage locations.

Project need

Record stock changes consistently across locations and make it easier to review balances for a selected business date and location.

System approach

We built the workflow around a movement ledger, with transactional records for goods received, transfers, usage, and stock-count adjustments. Reports follow the selected date, location, and stock filters.

What the system covers

Location-based product balances and movement history
Goods received, transfers, usage, and stock-count adjustments
Negative-stock safeguards for transfers and usage
Filtered stock reports and Excel exports

Have a similar workflow?

Let’s map the system your business needs.

Share the steps, tools, and stock or customer workflows you want to improve. We’ll help scope a practical starting point.

Talk through your project