Turning accounting data and a handwritten stocktake into an online sales workflow.

An online shop and part-number search for a regional bearings and filters supplier, built from the accounting system they already had.

Customers had to phone to ask whether a part was in stock. There was no online catalogue, and the accounting system held no stock quantities.

I owned the client relationship and the key decisions (Shopify over a custom build, MYOB's price as the shop price), ran discovery on site and directed Claude Code.

• A four-stage pipeline that turns MYOB data into Shopify products: build, enrich from the supplier's data, validate, bulk load.
• A Shopify store with weight-based postage and click and collect.
• A website that searches by interchange part number, so a customer can type in the number on their old filter.
• A stock ledger that works out what's on hand from the stocktake plus MYOB's sales report.

• Claude read 26 photographed pages of the handwritten stocktake into a spreadsheet.
• Claude Code wrote every script in the pipeline. The live shop runs no AI.

980

products in the shop, 954 of them (97.3%) with a barcode and spec table

Source: catalogue enrichment report, Jul 2026

14,002

interchange part numbers searchable on the website

Source: website search index, 1 Oct 2026

1,617

units across 638 lines, read from the handwritten stocktake

Source: stocktake counts file, 3 Sep 2026

Shopify Admin GraphQL, Python, Vercel, Cloudflare, MYOB