• Solarsys
• April 8, 2026

How to Track Multiple Inventory Locations in QuickBooks Online (Without Expensive Add-ons)

For small businesses, managing stock across multiple locations is a genuine headache. Moving inventory closer to customers improves delivery times and reduces risk — but only if you actually know where your stock is. Large companies solve this with expensive Enterprise Resource Planning (ERP) systems. For everyone else, the options are far more limited.

QuickBooks Online is a popular choice for small business owners: it’s approachable, cloud-based, and covers the basics well. But its inventory module has a significant blind spot — it cannot natively tell you where your stock is located. This article walks through a practical workaround using a feature already built into QuickBooks Online.

Why the Built-In Location Feature Doesn’t Help

QuickBooks Online does include a location feature, but it’s designed for a different purpose: tracking which office or shop a sale was made from, not where stock is physically stored. You can record an invoice against a location, which lets you analyse sales by branch—but it tells you nothing about where your ten units of a product are sitting right now.

Limitation

QuickBooks Online’s location field tracks the origin of a transaction, not the physical location of stock. It cannot be used as a substitute for warehouse location tracking.

Workaround: Two Separate Product Codes

QuickBooks Online generally does not allow two items to have the same “Name.” If Alan tries to save two products named “AB61UCHUB,” QBO will throw an error saying “Another product or service is already using this name.”

The most common approach is to create two product codes for the same item: one representing stock in the main location, and one for stock elsewhere. For example:

• AB61UCHUB-STORE — units stored in the Storeroom
• AB61UCHUB-SHOP — units on the Shop floor

This works, but it creates friction. You now have two separate product codes for one product, which complicates purchasing, reporting, and stock-taking. Searching for a product by code becomes ambiguous. And as your inventory grows, maintaining separate codes for every location multiplies the complexity.

A Smarter Way to Track: Using Categories

Since QuickBooks Online doesn’t allow two products with the same name, we need a strategy that keeps your data clean while separating your stock locations. Using Product Categories is the secret sauce here. It allows you to group different “items” under a single “location” heading for easier reporting.

The Setup

Instead of a messy list of random codes, follow this hierarchy:

1. Create Your Locations: Go to the Gear Icon > All Lists > Product Categories. Add two new categories: Shop and Storeroom.
2. The “Master” Item: Create your product (e.g., AB61UCHUB). Assign it to the Storeroom category. This is where you’ll record your initial purchases from suppliers.
3. The “Front” Item: Create a second product using the same name (e.g., AB61UCHUB). As long as you assign it to a different Product Category (e.g., “Shop”), QuickBooks will allow it.

This is a game-changer because it keeps your product list looking professional and uniform, while the bold category headers do the work of telling you where the stock is.

Notice how the same product code appears twice, but is clearly separated by location headers. This gives you the multi-warehouse view without the multi-warehouse price tag.

When you’re creating an invoice, QuickBooks will show both identical names in the dropdown menu. Just look for the Category listed next to the name to ensure you’re pulling stock from the Shop and not the Storeroom.

Moving Stock Between Locations

Since these are two separate line items in QuickBooks, “moving” stock isn’t a single button click—but it’s simple once you get the hang of it. 

For example, if Alan has 10 AB61UCHUB in store and wants to move 5, he performs a Quantity Adjustment and changes the “New Quantity” to 5.

• Step A: Decrease AB61UCHUB (Store) by 5 units.
• Step B: Increase AB61UCHUB (Shop) by 5 units.

Update the ‘New Quantity’ for both items—reducing the Storeroom count and increasing the Shop count by the same amount.

Note: When performing your Quantity Adjustment, pay close attention to the Category column in the dropdown menu. Since both items share the same name, the Category is your only way to tell them apart during the transfer!

Why does this beat “just using two codes”?

You might ask: “Isn’t this just creating two codes anyway?” Technically, yes. But by using Categories, you gain a massive reporting advantage.

When it’s time for a stocktake, you don’t have to scroll through a giant list and guess where things are. You can run an Inventory Valuation Summary and filter it by Category.

QuickBooks will then give you a beautiful, organised breakdown:

• Category: Shop — 2 units
• Category: Storeroom — 8 units
• Total Inventory Value — (The combined total of both)