How to Track Inventory Across Multiple Antique Mall Booths (Without Losing Your Mind)
You started with one booth. It was manageable. You knew what was in it, roughly what you paid for everything, and you could eyeball whether you were making money.
Then you added a second booth. Maybe at a different mall. Different commission rate, different rent, different payout schedule. Now you're juggling two sets of numbers in your head — or worse, two tabs in a spreadsheet that hasn't been updated since last month.
If you're reading this, you probably have two or three booths, maybe an Etsy shop or a spot at the weekend flea market. And the question that keeps you up at night isn't "what should I buy next?" It's "am I actually making money at all of these locations?"
You're not alone. And the answer is probably murkier than you think.
The real problem isn't inventory — it's visibility
Most vendors can tell you roughly what's in their booth. The problem isn't knowing what you have. It's knowing:
- What did I pay for this? That vintage lamp — was it the estate sale two weeks ago or the auction last month? Did I pay $40 or $60?
- What are my real costs at this location? Booth rent, mall commission, credit card processing fees, the gas to drive there and restock. All of that eats into your margin.
- Is this booth actually profitable? You sold $800 last month. Sounds great. But after $250 rent, 10% commission, and $150 in sourcing costs — did you actually make anything?
- Where should I put my best items? If one mall moves vintage furniture fast but another is better for small collectibles, you want to stock accordingly. But that requires data you probably don't have.
This is the visibility gap. You're running a real business across multiple locations, but you're making decisions based on gut feel because the actual numbers are buried in receipts, spreadsheets, and mall statements you haven't reconciled.
Why spreadsheets break down at two locations
A spreadsheet works fine for one booth. You list your items, what you paid, what you sold them for, and you can see your margin. Simple.
Add a second location and everything falls apart:
Different fee structures. Mall A charges $200/month rent plus 8% commission. Mall B charges $150/month but takes 12%. Your flea market spot is $75 per weekend with no commission. Try calculating true profit per item across all three in a spreadsheet. Now do it for 200 items.
Moving inventory between locations. You pull a piece from Booth A because it's not selling and move it to Booth B. In your spreadsheet, you now need to update the location, recalculate the fees for the new location, and remember to do it before you check your numbers. Most people don't. The spreadsheet slowly drifts from reality.
Mall statement reconciliation. At the end of the month, the mall sends you a statement. It says you sold $643.27. Your records say $680. Where's the $36.73? Was it a return you forgot to log? A commission calculation difference? A mall error? Good luck figuring that out from a spreadsheet.
Tax time. Your accountant needs sales by location, costs of goods sold, and business expenses — all categorized. If your system is "a spreadsheet and a shoebox of receipts," tax season is a week of misery.
The spreadsheet worked when this was a hobby. When it becomes a business — even a side business — you need something better.
What actually works: a system that travels with you
The vendors who stay profitable at multiple locations share one trait: they record everything in real time, at the point of sale or the point of purchase.
Not "when I get home." Not "this weekend when I update the spreadsheet." Right now, standing at the estate sale or sitting in the booth.
Here's what a good tracking system looks like:
Record purchases the moment you buy
You're at an estate sale. You find a mid-century lamp for $35. Before you put it in the car, log it: item, cost, where you bought it, date. If you wait until you get home, you'll forget the price. If you wait until the weekend, you'll forget you bought it.
Set up each location with its real costs
Your tracking system should know that Booth A is $200 rent + 8% commission and Booth B is $150 rent + 12%. When you record a sale, the system should calculate your true profit automatically — not just sale price minus purchase price, but sale price minus purchase price minus location fees.
Record sales in 30 seconds
You're at the booth and someone just bought that lamp for $85. Log the sale right there: which item, which location, what price. Thirty seconds. If your system requires more than that, you won't use it on busy days — which are exactly the days that matter most.
Reconcile monthly
When the mall statement arrives, compare it against your records. Catch discrepancies early. If the mall shorted you $36, you want to know now — not six months from now.
Review monthly: which locations are earning their keep?
Once a month, look at the numbers. Not just total sales, but profit per location after all fees. If Booth B consistently underperforms after accounting for its higher commission rate, maybe those square feet aren't worth it.
The math most vendors skip
Here's a quick exercise. Pick your best-selling item from last month and calculate the true profit:
Sale price: $85 Minus purchase cost: -$35 Minus booth rent (allocated per item): Let's say you sold 20 items that month at this location with $200 rent = -$10 per item Minus mall commission (10%): -$8.50 Minus credit card fee (~3%): -$2.55
True profit: $28.95
That's a 34% margin on an item you thought was an $50 profit. The difference is $21.05 — and that's just one item. Multiply that gap across hundreds of items and you start to see why "I think I'm making money" and "I know I'm making money" are very different statements.
Most vendors skip this math because it's tedious to do manually. That's fair. But the vendors who do it — or who use a tool that does it for them — make better buying decisions, better pricing decisions, and better location decisions.
When to upgrade from the spreadsheet
If any of these sound familiar, you've outgrown the spreadsheet:
- You sell at more than one location
- You can't answer "what's my profit margin at Mall B?" without digging through files
- Your monthly reconciliation with the mall takes more than 15 minutes
- Tax season involves a shoebox of receipts and a weekend of data entry
- You've moved items between locations and your records don't reflect it
- You suspect a location isn't profitable but you can't prove it
You don't need enterprise software. You don't need a POS system built for the mall operator. You need something built for you — the individual vendor managing a few booths and trying to turn a side hustle into a real business.
That's exactly why we built MaxIMS. It's a mobile inventory app designed for booth vendors, craft sellers, and resellers. Track inventory, record sales, see real profits after all fees and commissions — all from your phone.
Free for up to 50 items and one location. Upgrade when you're ready.
MaxIMS is built by Uncomplicated Inc, a Memphis-based venture studio. We build tools for people who do the work.