Wholesale Handler
Can you run wholesale on Airtable's free plan?
For a lot of small operations, yes - and at no cost. The free plan gives you five editor seats, 1,000 records per base and unlimited form submissions, with no time limit. Whether it works for you comes down to how you take orders, not how much you can spend.
You take the orders yourself. If you and maybe a colleague key in every order from a call, a text or the market, five free seats cover your whole team. Airtable becomes a tidy home for orders you've already taken - a real step up from a spreadsheet, for nothing.
Everyone pays the same price. Wholesale's hard problem is per-customer pricing. If you genuinely charge everyone the same, or you're happy to tweak a few lines by hand, you can even gather orders through the free form - unlimited submissions cost nothing, and the "same options for everyone" limit doesn't bite when there's only one price.
Where the free plan runs out
Your order volume fills the base. The free ceiling is 1,000 records per base, and orders mount up fast - around twenty orders a week at five lines each fills a base in roughly ten weeks. After that you either archive old orders by hand or move up to the Team plan at $20 per editor a month for fifty thousand records. It's the most common reason people leave the free plan, and it has nothing to do with your customers.
You want customers logging in to their own prices. This is the wall wholesale actually hits. The only way to show a logged-in customer their own prices is to give them edit access to an interface - a paid seat each. Forty trade customers on the Team plan is $800/month, and more than double that on Business. Nobody pays that, so in practice you stay on the free anonymous form and its limits - the same options for everyone, no per-customer prices, no running total, no cut-off.
So it comes down to you, not Airtable. Take the orders yourself with simple prices and the free plan is great. Want customers placing their own orders at their own prices, and the free plan can't do it while the paid plan is priced for your team, not your customers.
What Airtable is actually good at
Airtable is a relational database wearing a friendly spreadsheet face, and for organising your back office that's a real step up from a flat sheet.
You can keep a Products table, a Customers table and an Orders table, and link them together so an order points at a real customer and real products instead of re-typed text. You get filtered views, so "today's deliveries" and "everything for the Tuesday run" are saved rather than re-sorted each time. Automations can send you a notification or tidy a record when something changes.
Why a database beats Excel or Google Sheets
The difference shows the moment something changes. In Excel or Google Sheets, every order is text typed into cells - a customer's name, a product, a price, all copied into every row they appear in. Change a price and you're hunting through the sheet fixing it everywhere, and the copies drift out of sync the second you miss one.
A relational database like Airtable stores each customer and each product once, and every order points at them. Change a price in one place and every order reflects it - nothing to find-and-replace, nothing left silently out of date. That's the same reason it can hold a different price for each customer without the whole thing turning into a tangle of duplicated cells.
If you take orders yourself - over the phone, on WhatsApp, in person at the market - and you just want somewhere sensible to record and organise them, Airtable does that job well. Many wholesalers would be better off in Airtable than in the Excel or Google Sheets file they're currently fighting.
Where Airtable breaks down for wholesale
The trouble starts the moment you want your customers to place the order themselves instead of you keying it in. That's the whole point of moving online, and it's where Airtable has no good answer.
No real customer login. Airtable's two ways to let outsiders in are a form or a shared base. A form is anonymous - it shows the same fields to everyone with the link, with no idea who's filling it in. Sharing the base or an interface means handing out collaborator access, which on Airtable's paid plans is priced per seat. You're not buying forty cafés an Airtable seat each, so in practice you're back to the anonymous form.
No per-customer pricing at the point of ordering. This is the one that matters most. Airtable can store a different price for every customer easily - that's what a relational database is for. What it can't do is show a logged-in customer only their own price. A form shows everyone the same options, so the café and the restaurant group see the same numbers. Wholesale runs on per-customer prices, and an anonymous form can't tell one account from another.
No running total, no guardrails. An Airtable form won't multiply quantity by each customer's price, won't stop an order placed after your cut-off or below your minimum, and won't know you don't deliver on that day or that a line is sold out. The form accepts whatever it's given, whenever it's given, and enforcing your rules stays a manual job.
You become the database administrator. A base that does even half of this is a build project - linked tables, lookups, rollups, automations, and an interface you maintain. It's never quite finished, it breaks when you change the structure, and the person who has to fix it at 6am is you. The tool that was meant to save time has quietly become a second job.
Recurring orders are a DIY project. Standing weekly orders, with the right cut-off, the ability to skip a week, and a lock once the deadline passes, can in theory be wired up with Airtable automations. In practice that's a fragile bespoke system you're now responsible for, not a feature you switch on.
The trade-off
Airtable is excellent at holding orders you have taken. It's poor at taking orders from customers. If your bottleneck is "my order records are a mess," Airtable fixes that. If your bottleneck is "I'm still the one typing every order in from a text or a call," Airtable doesn't, because the customer-facing front door is either an anonymous form or a paid seat.
How Wholesale Handler helps with wholesale orders
Wholesale Handler is built around the half Airtable can't reach: your trade customers get their own login, see the catalogue and the prices set for them, and place the order themselves.
Per-customer price lists. Each customer is assigned a price list and only ever sees their own prices. They never see the list name or know other prices exist.
A real catalogue with running totals. Products have names, units and prices. Customers enter quantities and watch the total update before they submit.
Guardrails built in. Cut-off times, delivery days, holidays, minimum spend and product availability are enforced for you. An order that breaks a rule can't be placed, rather than arriving and becoming your problem.
Standing orders without the wiring. Recurring weekly orders generate on their own, lock at the cut-off, and let a customer skip a week from a link in their reminder email. There's no automation for you to build or maintain.
One source of truth, and no re-keying. Change a price or switch a product off once and every customer sees it immediately. Orders land structured on your dashboard, customers can repeat a previous order from their history, and you generate invoices straight from the orders.
You're not maintaining a database for any of this - it's the product, not a base you built and now have to keep alive.
When Airtable is still the right tool
If you take the orders yourself and only need somewhere to organise them, Airtable is a fine choice - better than Excel or Google Sheets, and worth setting up properly. The same is true if you're managing internal stock, suppliers or a production list rather than customer ordering.
It's time to move off Airtable for the ordering itself when you want customers placing their own orders, at their own prices, without you re-keying anything - because that's the exact job a form-and-a-database can't do, no matter how well you build it.
