You are standing in your workshop on a Wednesday afternoon when a message comes in from the boutique downtown: "Do you have any more of the lavender soy candles? The last three sold this weekend." You are pretty sure you do. You made a batch of twelve last week. But you also packed six for Saturday's farmers market, gave two to a friend who owns a gift shop on consignment, and there might be one in the box you prepped for an online order that hasn't shipped yet.
So how many are actually available to send to the boutique? You don't know. Not because you didn't track your inventory — you did. You know you made twelve. But your system treats your entire business as one big bucket. It can tell you the total count. It cannot tell you that four are on a shelf in your workshop, three are in a tote bag in your car for Saturday, two are sitting in someone else's store, and one is committed to an order. The number in your spreadsheet says "twelve" but the real answer is "maybe four, if you can get to them before Saturday."
This is the multi-location problem, and it hits almost every maker who grows beyond selling from a single spot. The moment your products exist in more than one place at the same time — your workshop, a market booth, a consignment partner, a storage unit, a shipping station — a single inventory count becomes a fiction. You need to know where, not just how many.
Why Single-Location Tracking Breaks Down
Most inventory systems start simple: you make things, you count things, you sell things. The count goes up when you produce and down when you sell. This works perfectly when everything happens in the same place.
The trouble starts gradually. You get a consignment offer and drop off ten pieces at a local shop. You start doing two markets a month and pre-pack a tote the night before. You rent a small storage unit because your garage is overflowing. Each of these is a reasonable decision — but each one creates a new pool of inventory that your single-count system cannot distinguish.
Here is what goes wrong:
You overcommit. You see "15 in stock" and promise a wholesale buyer 10 units. But 6 of those 15 are already at a consignment partner's shop, and 3 are packed for this weekend's market. You actually have 6 available — and now you have to either pull stock from a partner (awkward) or rush-produce to fill the order (expensive).
You lose track of consignment. You dropped off 8 pieces at a gift shop two months ago. They sold 3 and paid you for them. But your system still shows those 8 as "in stock" because you never recorded the transfer out — or worse, you subtracted all 8 from your count even though 5 are still sitting on their shelf, technically still yours.
Market prep becomes guesswork. You are loading the car for Saturday's market and you grab what looks right. After the market, you bring back unsold items but don't update anything because you are tired and it is 4pm and you just want to sit down. By Monday, your numbers are wrong in a way you can't easily reconstruct.
You can't answer simple questions. Where is my best seller right now? How much stock does the downtown boutique have left? What do I need to produce this week to restock all my locations? If your system doesn't track location, these questions require a phone call, a drive, or a guess.
The Mental Shift: Inventory Has an Address
The fix is not complicated, but it does require a change in how you think about inventory. Stop thinking of inventory as a number. Start thinking of it as a number at a place.
Instead of "I have 24 bars of oatmeal soap," you need "I have 10 at the workshop, 6 at Pine Street Boutique, 4 at the Sunday market kit, and 4 at the storage unit." The total is still 24. But now you can actually make decisions with that information.
This means every time inventory moves — not just when it is sold — you record it. Moving products from your workshop to your car for a market? That is a transfer. Dropping off pieces at a consignment shop? Transfer. Pulling stock from storage to fulfill online orders? Transfer.
The key distinction: a transfer is not a sale. Your total inventory count doesn't change when you move something from your workshop to a market booth. What changes is where it lives. If you treat transfers as "sales" or just manually subtract from one mental bucket, you will lose accuracy within a week.
Setting Up Your Locations
Start by listing every place your inventory physically exists. Be specific. Here is what this looks like for a typical maker selling through multiple channels:
| Location | Type | What Lives There |
|---|---|---|
| Home workshop | Primary | Raw materials, work in progress, finished goods |
| Garage storage | Storage | Overflow finished goods, bulk materials, packaging |
| Saturday market kit | Sales | Pre-packed finished goods for weekly market |
| Pine Street Boutique | Sales (consignment) | Finished goods on consignment |
| Rosewood Gift Shop | Sales (consignment) | Finished goods on consignment |
| Shipping station | Sales | Items packed and ready to ship for online orders |
A few rules of thumb:
Your primary location is where you produce. This is home base — where raw materials come in, production happens, and finished goods are born. Most of your inventory management happens here.
Create a location for each consignment partner. Do not lump all consignment into one bucket. You need to know that Pine Street has 4 of your candles and Rosewood has 7 — because when Pine Street calls asking for a restock, you need to know their number, not the combined total across all shops.
Markets can be one location or many. If you do the same Saturday market every week, one "Saturday Market" location is fine. If you do three different markets and pre-pack separate kits for each, give each one its own location. The test: would you ever need to know the stock at one market independently of the others? If yes, separate locations.
Keep the list honest. If you have a box in your car that permanently has a few products in it "just in case," that is a location. If your mom's house has overflow stock, that is a location. Pretending inventory doesn't exist somewhere is how it gets lost.
Recording Transfers Like a Pro
Once your locations exist, the core habit is simple: every time products physically move, record a transfer. Not later. Not tomorrow. Right when it happens, or within the hour.
Here is the workflow for common scenarios:
Packing for a Market
The night before (or morning of), you pull products from your workshop and pack them for the market. Record a transfer:
- From: Home workshop
- To: Saturday market kit
- Items: 12 soy candles, 8 soap bars, 6 lip balms
After the market, you need to do two things:
- Record sales for everything you sold at the market (this reduces the market location's count)
- Transfer unsold items back from the market location to your workshop
Yes, this takes five minutes. Yes, it is worth it. The alternative is your numbers drifting further from reality every single week until the whole system is useless and you are back to guessing.
Dropping Off Consignment
When you deliver products to a consignment partner:
- From: Home workshop (or wherever you packed them from)
- To: Pine Street Boutique
- Items: 6 lavender candles, 4 cedar candles
When the partner sells items and reports back to you:
- Record a sale at the Pine Street Boutique location for the items sold
When the partner returns unsold items:
- Transfer back from Pine Street Boutique to your workshop
This gives you a clean picture at any moment: how many of your products are sitting on their shelves, how many they have sold, and what your sell-through rate is at each partner. That last number is gold — it tells you which partnerships are working and which ones are just tying up your inventory.
Restocking from Storage
When you pull finished goods from a storage unit to fulfill online orders or restock your workshop:
- From: Garage storage
- To: Home workshop (or shipping station)
- Items: 20 soap bars, 10 candles
Keep your storage location's count accurate and you will always know what reserves you have without driving to the unit to check.
Consignment Deserves Special Attention
Consignment is where multi-location tracking gets the most value — and where most makers get it the most wrong. The core issue is ownership: those products are still yours until the consignment partner sells them. They are sitting on someone else's shelf, but they are your inventory, your money, your risk.
Without location tracking, consignment creates a black hole. You know you dropped off products. You know you occasionally get a check. But in between, you have no visibility into what is selling, what is sitting, and what might be getting damaged or lost.
Here is what good consignment tracking looks like:
Track each partner as a separate location. Already covered, but worth repeating. Lumping all consignment together means you cannot evaluate individual partnerships.
Record the transfer out when you deliver, not when they sell. The moment products leave your workshop, they move to the partner's location in your system. Your workshop count goes down, the partner's location count goes up. Total inventory unchanged.
Record sales as they are reported. When your consignment partner sends you a sales report (monthly, biweekly, whatever the arrangement), record each sale at their location. Their location count drops, and those items move from "inventory" to "revenue."
Reconcile regularly. At least once a month, confirm with each partner: "You should have X of product A and Y of product B on your shelf. Does that match?" If it does not, figure out why. Theft, damage, misplacement, and miscounted sales all happen — and they all cost you money if you don't catch them.
Know your sell-through rate per partner. If you gave Pine Street Boutique 10 candles two months ago and they have sold 3, that is a 30% sell-through rate. If Rosewood sold 8 out of 10 in the same period, that is 80%. Where should you be sending your limited finished goods? The answer is obvious — but only if you have the data.
Knowing What to Restock and Where
Once your locations and transfers are dialed in, you unlock the ability to answer the most valuable question in your business: what do I need to make this week, and where does it need to go?
Without location data, restocking is reactive. You find out you are low on something when a customer asks for it and you don't have it. Or a consignment partner calls and says they are out. Or you show up to a market with half the product you meant to bring because you forgot you already sent most of it to a shop.
With location data, restocking becomes proactive. You can look at each location and see:
- Workshop: 4 lavender candles remaining. Saturday market usually needs 8-10. Need to produce at least 6 by Friday.
- Pine Street Boutique: Down to 2 candles from the 8 you delivered three weeks ago. Sell-through is strong — deliver another 6 this week.
- Rosewood Gift Shop: Still has 5 out of 6 from last month. Don't restock. Consider swapping out for a different scent that might move better there.
- Storage unit: 15 bars of oatmeal soap. Plenty of buffer stock — no need to produce more this week.
This is the kind of decision-making that separates businesses that grow from businesses that spin their wheels. You stop producing based on gut feeling and start producing based on where demand actually exists.
Transfers, Not Adjustments
One mistake to avoid: using inventory "adjustments" to fake multi-location tracking. Some makers subtract items when they take them to a market and add them back when they return unsold goods. This technically changes the numbers in the right direction, but it creates two problems.
First, adjustments don't leave a trail that tells you why the number changed. A month from now, you see "-6 candles" on March 15th. Was that a market? A consignment drop-off? Did you give them away? You have no idea.
Second, you lose the ability to see what is at each location right now. Adjustments only modify the total. Transfers create a from-and-to record that lets you view inventory by location at any point in time.
If your tracking tool supports transfers and locations, use them. If it doesn't, you need a different tool. This is not a nice-to-have feature — it is the difference between a system that reflects reality and one that reflects a guess.
What About Raw Materials?
So far we have been talking about finished goods — the products you sell. But if you store raw materials in multiple places, the same logic applies.
Maybe your bulk oils and waxes are in the garage, but you keep working quantities in the kitchen. Maybe you order packaging supplies to the house but store overflow in a unit. The same principle holds: if something can be in more than one place, you need to track which place it is in, or your "on hand" count will include materials you cannot immediately access.
That said, don't overcomplicate this. If all your raw materials live in one spot and only finished goods move around, track locations for finished goods only. Add raw material locations later if and when it becomes a real problem. The goal is accuracy, not exhaustive categorization.
Tools That Handle Multi-Location
Not every inventory tool supports multiple locations. Many apps marketed at small businesses assume you have one stockroom and one sales channel. When evaluating a system, look for:
- Named locations you can create and customize
- Transfer records between locations (not just adjustments)
- Per-location stock views so you can see what is where
- Entity-level filtering so switching between locations shows only that location's inventory
- Sales recorded per location so you can calculate sell-through by partner or channel
Ardent Seller was built with this exact pattern in mind. Every inventory item, transaction, and production record is scoped to a specific location. You can set up your workshop, storage unit, market booth, and consignment partners as separate entities, then switch between them to see exactly what each location holds. Transfers between locations are tracked as proper transactions — not adjustments — so you always have a clear audit trail of what moved where and when. If you are currently juggling a spreadsheet and a prayer, it is worth a look.
Getting Started Without Overwhelm
If you are reading this and your current system is a single spreadsheet with no location tracking, don't try to fix everything at once. Here is a practical sequence:
Week 1: List your locations. Write down every place your inventory physically exists. Be honest — include the box in your car and the shelf at your mom's house.
Week 2: Count what is where. Do a physical count at each location. This is your starting snapshot. It will take an afternoon, maybe two. Do it once and your system starts from a place of truth instead of an estimate.
Week 3: Start recording transfers. Every time products move between locations, log it. This is the habit that makes everything else work. Set a rule: nothing moves without a record.
Week 4: Record location-specific sales. When you sell at a market, record those sales at the market location. When your consignment partner reports sales, record them at that partner's location. When you ship an online order, record it at your shipping station.
After one month, you will have a working multi-location system. Your numbers will actually mean something. You will be able to answer "where is my stuff?" without making a phone call or opening a car trunk. And the next time a boutique asks if you have stock available, you will know — really know — the answer.
The shift from "I think I have some" to "I have four at the workshop and I can get them to you Thursday" is the difference between looking like a hobbyist and running like a business. Your products already move between multiple places. It is time your inventory tracking did too.
Ready to track inventory across every location where your products live? Start your free Ardent Seller account and set up your first locations in minutes.