Six Shopify stores and one set of books, run from one hub.
Raw Blend sells blenders, juicers and commercial kitchen equipment through six Shopify stores. We built the hub that moves their orders, stock, supplier prices, invoices and tracking between Shopify, QuickBooks Online and ShipStation.
- 6Shopify stores
- 52automations
- 26suppliers, about 95 brands
- 361 of 383invoices matched on the first tracking run
Before the build.
Raw Blend runs six stores: Raw Blend, Commercial Equipment Online, Commercial Fridges Online, Blenders Online, U-Konserve and EcoVessel. Each had its own orders, stock and prices, and they all fed one QuickBooks Online company.
Orders reached the books through a third-party sync tool. Warehouse staff copied tracking numbers from ShipStation onto invoices by hand. Supplier price lists arrived as spreadsheets, CSV files and portal downloads, and someone keyed the changes into every store. The first automations were scripts started by Windows Task Scheduler on an office PC.
What we built.
Orders to the books
Shopify orders become QuickBooks invoices, customers and payments. This replaced the old sync tool. A watch lists any order that hasn’t reached the books.
Tracking onto invoices
Every hour, new ShipStation tracking numbers are added to the matching invoices. Ones already done are skipped.
Supplier prices and stock
Price lists and stock feeds from 26 suppliers update costs in QuickBooks and prices and stock across the stores. The hub also drafts purchase orders to suppliers.
Live freight at checkout
Shopify asks the hub for Australia Post contract rates while the customer is checking out.
AI on the inbox
Claude sorts incoming email and drafts replies. Staff read and send every one.
One dashboard
Staff run, approve and revert jobs from the dashboard, with roles, two-step sign-in and run history.
What changed.
- 361 of 383 invoices were matched and updated on the first tracking run, clearing a month’s backlog. The other 22 were ambiguous and went to a person.
- About an hour a day of re-typing went with that one sync. That was the first job. The hub now runs 52.
- Big price swings are refused. If a supplier list would move more than 25% of a range by over 10%, it isn’t applied.
- Changes can be undone. Dry runs on 47 modules show what would change, and price, cost and promotion changes are snapshotted so they can be reverted.
Where it stands.
The hub started on an office PC and was moved to a hosted service on Railway, with an uptime check every 10 minutes. Raw Blend owns the code: the repository has been handed over to the business.
Got systems that should be talking to each other?
Request a free 20-minute call. Zac will email you within one business day to arrange a time.
Request a free 20-minute call