Adam Wayne · Case studiesConsumer products brand · operations

The whole back office, in one Airtable base.

A product brand that sells retail and wholesale, ships every day through ShipStation and pays affiliates. I built one system that holds all of it and talks to ShipStation on its own.

The result

Every order traceable in one place, from the order form through ShipStation to the doorstep and the affiliate payout, with stock that flags itself before it runs out.

Client
Consumer products brand
Built on
Airtable + ShipStation
Tables
18, linked
Runs
Every day
18
tables, linked
3
prices per product: retail + 2 wholesale tiers
1
record per order, end to end
Auto
low-stock alerts
№ 1

The problem: an order touches everything.

№ 2

What I built, table by table.

Orders and customers

Every order links to its customer, line items, shipments and payments. Each customer shows total spent, order count and what's still owed.

Pricing and stock

Retail plus two wholesale tiers on every product. Stock is received against suppliers, and a product flags itself below its reorder point.

ShipStation, built in

A paid order is created in ShipStation automatically. When it ships, the tracking number comes back to the order, and EasyPost follows the package to delivery.

Payments

Card payments arrive with fees and net, matched to their order.

Affiliates

Codes credit each sale to an affiliate and work out the payout owed.

A log of every run

Every automation writes to a log, so a problem shows up before a customer notices it.

AirtableFilloutn8nZapierStripeShipStationEasyPost
№ 3

What this looks like for your products.

If you sell physical products and run them across spreadsheets and apps, the same build gives you:

Your first step

Send me how an order moves today, even a messy list. I'll map the base and its automations first, as a small no-code prototype, before you pay for a full build.

Book a call →adam@adamwayne.com