THE ESSENTIAL IDEA
One reliable record. A routine everyone follows.
To create an inventory system, define what you track, give items and locations consistent IDs, count what you have, and record every movement. Then set replenishment rules and check your records against the physical stock. Software supports this routine; it does not replace it.
A customer asks for four mugs. Your spreadsheet says six are available, but two are packed for another order and one is chipped. Elsewhere, a technician orders a replacement drill because nobody knows which van has the original.
These are different businesses with the same problem: the record does not describe what is actually available. This guide shows you how to build a practical inventory system for products, materials, supplies and shared equipment, without making daily work unnecessarily complicated.
The examples and suggested rollout below are illustrative, not results from a Boxymi customer. Adapt the process to your team, stock and workload.
01. Decide what your system needs to track
Write down the decisions your team needs to make. Can we fulfil this order? Do we have supplies for tomorrow’s jobs? Where is the shared equipment? What should we buy next? Use these questions to decide which records matter.
| What you manage | Example | Useful tracking detail |
|---|---|---|
| Products for sale | Ceramic mugs in two colours | Quantity by product variant and location |
| Materials and supplies | Clay, replacement parts, packing boxes | Quantity in a defined unit; batch or expiry when relevant |
| Individual equipment | A drill or label printer | Unique asset ID, location, condition and assigned person |
For this operational guide, “inventory” includes things your team uses as well as things it sells. Keep equipment records separate from saleable stock so a checked-out tool is not mistaken for a sold item. This is an operational distinction, not a rule for accounting classification.
Choose a manageable pilot: one stockroom, one product range or one service van. Name the person responsible for keeping that pilot accurate. Expand once the routine works.
02. Choose a tool that fits the daily work
A spreadsheet is useful for preparing your inventory data before setting up a dedicated tool. Use it to organise product names, assign consistent item IDs, define locations and units, remove duplicate records, and prepare verified opening quantities. Our recommended approach is to use that structured list as the foundation for your inventory application, then manage daily stock movements in the application.
Check the chosen tool’s import format before preparing a large file. Test a small group of items first, confirm that IDs and locations map correctly, and check the resulting quantities before importing the rest. If importing is not supported, use the same structured list to guide manual setup.
Choose by workflow, not by the number of features on a sales page. Test one ordinary working day before committing:
- Receive a delivery and record a short shipment.
- Find an item and its location from a phone.
- Move stock between two places without changing the business-wide total.
- Record a sale or usage, then correct a mistake with an explanation.
- Check who can make changes and export your records.
If you sell online or use a point-of-sale system, verify the exact integration you need. Ask which events update stock, how returns are handled, and what happens when a connection fails. Do not assume that an inventory app automatically synchronises every sales channel.
Boxymi’s inventory management overview describes shared item and location records, images, SKUs and scanning. If those match your needs, include Boxymi in your workflow test. Compare required users, locations and features against the current plans and pricing; the Free plan requires a one-time Boxymi QR-label purchase.
Avoid two competing records.
Decide which system is authoritative for quantities. A spreadsheet used for a one-time import or backup is different from a second live stock list that someone updates independently.
03. Build consistent item and location records
Create a short naming convention before entering hundreds of items. For example, use MUG-SAND-350 for a 350 ml sand-coloured mug and MUG-GREEN-350 for the green version. Give variants separate records when customers order them separately.
Keep location names equally clear: SHOP-A-02 can mean shelf A, position 02 in the shop; VAN-02 identifies a service vehicle. Put location labels where people can see them. Store the location in its own field rather than embedding it in an item ID that must change whenever stock moves.
| Field | Example | Why include it? |
|---|---|---|
| Item ID and name | MUG-SAND-350 · Sand mug, 350 ml | Distinguishes similar products |
| Tracking unit | Each | Prevents boxes being confused with individual items |
| Location and quantity | SHOP-A-02 · 24 | Shows where that quantity is held |
| Stock status | Available, reserved or damaged | Separates physical stock from usable stock |
| Supplier and lead time | Supplier A · 5 working days | Supports replenishment planning |
| Reorder point | 18 units | Flags when to review replenishment |
| Last verified | 20 October 2026 | Records when a physical check occurred |
Use one stock balance per item and location. If 12 mugs are on the shop shelf and 24 are in storage, those are two location balances for the same item—not 36 mugs in each place. An item list can hold shared details such as its name and unit, while a separate balance sheet holds quantities by location.
For equipment, add a unique asset ID such as DRILL-003, its serial number when available, assigned person, condition and return date. For items that need batch or expiry tracking, confirm your chosen tool supports those fields and the associated workflow before rollout.
IN PRACTICE · PACKAGING
One box is not always one unit.
If shipping cartons arrive in packs of 25 but staff use them individually, choose “each” as the stock unit. Receiving four packs adds 100 cartons. Record that conversion instead of allowing “4 boxes” to mean four packs one day and four cartons the next.
Use codes to find the right record
An internal SKU identifies an item within your business; a GTIN identifies a trade item across organisations. Keep an existing supplier barcode in a separate field where supported, rather than replacing it with your own SKU.
For an internal QR-label workflow, test that scanning opens the intended item or location and that a staff member can complete the required update. A scan that only opens a record does not, by itself, prove that a sale, transfer or stock adjustment has been recorded.
04. Count your opening stock and separate unavailable items
Before relying on a new system, establish a starting balance you can explain. Tidy the pilot area, collect items left on desks or in vehicles, and separate damaged goods and customer returns awaiting inspection.
- Set a counting cut-off. Pause movements in the area, or record every movement during the count on a separate log.
- Count by location. Follow a fixed route so the same shelf is not counted twice.
- Record exceptions separately. Mark damaged, reserved and uninspected stock rather than treating everything as available.
- Recount surprises. Check unusual differences before entering the opening balances.
- Record the date and person. Make the starting point traceable.
ILLUSTRATIVE EXAMPLE · POTTERY SHOP
Physical stock is not the same as available stock.
You count 30 mugs. Four are reserved for customer orders and two are chipped. If those groups do not overlap, you have 30 physically on hand but only 24 available to sell.
Decide whether your system represents damaged stock as a separate status or a separate location. Do not subtract the same two mugs twice. A supplier order due next week is incoming stock, not stock you can hand to a customer today.
05. Record movements instead of overwriting totals
A number tells you what the record says now. A movement log explains how it got there. For each change, capture the date, item ID, quantity, source or destination, reason, person and an order or job reference where relevant.
Once your opening records are checked, use the inventory tool for receipts, transfers, sales and internal usage. Keep the preparation spreadsheet as a dated reference, not a parallel stock ledger. Use the tool’s correction or adjustment workflow to record the reason for a change while preserving its history, rather than silently overwriting totals.
| Event | Location change | Quantity effect | Reference |
|---|---|---|---|
| Receive delivery | Supplier → Stockroom | +24 stockroom | Delivery 104 |
| Transfer to shop | Stockroom → Shop | −6 stockroom; +6 shop | Transfer 008 |
| Fulfil customer order | Shop → Customer | −2 shop | Order 512 |
| Write off breakage | Shop → Written off | −1 shop | Adjustment 019 |
The transfer changes two location balances but leaves the total owned stock unchanged. In the breakage example, the mug leaves the counted stock; if your system instead retains it in a damaged location, record a transfer there and exclude it from availability.
Define one clear recording point for each workflow:
- Deliveries: record the quantity actually accepted, not simply the amount ordered.
- Sales: distinguish a reservation from dispatch or collection. Do not deduct once when ordered and again when shipped.
- Internal use: link parts or supplies to the job, team or reason that consumed them.
- Customer returns: inspect before returning goods to available stock.
- Tools: record checkout, movement and return, not a sale-style quantity deduction.
- Production: if you make goods, record materials consumed and finished items received through a defined process; do not leave both counted as unchanged stock.
IN PRACTICE · SERVICE TEAM
Track parts by quantity and tools by identity.
A technician takes eight replacement filters and DRILL-003 from the store to Van 2. That is a transfer, not consumption. After using three filters on a job, the van has five left. The drill remains a business asset assigned to the technician until it is returned or transferred.
06. Set a practical replenishment rule
For regularly used items, a reorder point gives you a trigger to review purchasing before usable stock runs out. Begin with observed usage and the time between placing an order and having the delivery ready to use.
Reorder point = average daily usage × replenishment lead time + safety stock
This is a basic continuous-review model. Safety stock is a buffer for uncertainty, not a guarantee against shortages. Use matching time units for daily usage and lead time.
WORKED EXAMPLE · SHIPPING CARTONS
An illustrative trigger of 84 cartons.
A shop uses an average of 12 cartons per working day. Replenishment takes five working days, and the owner chooses a 24-carton buffer for this example.
(12 × 5) + 24 = 84 cartons.
The 24-carton buffer is an assumption, not a recommended amount for every business. Review it against actual demand variation, late deliveries, space and the cost of running out.
Before placing an order, check usable stock, existing commitments and confirmed incoming deliveries. Otherwise, repeated low-stock checks can lead to duplicate orders. An overdue delivery should not reassure you in the same way as a shipment confirmed for tomorrow.
A reorder point tells you when to review ordering, not how much to buy. Choose the order quantity using expected demand, supplier pack sizes, minimum quantities, storage space and available cash. If you review stock only weekly, also allow for the time until the next review; do not apply a continuously monitored trigger blindly.
For seasonal or irregular items, use upcoming orders, scheduled jobs or event plans rather than a long-run average alone. For tools, the question may be whether an available, working asset can cover the next job—not whether a consumable stock threshold has been reached.
07. Give the team a routine and clear responsibilities
Write a one-page procedure that answers four questions: who records a change, when they record it, which fields they complete, and who resolves exceptions. Choose a backup person so the process does not stop when its owner is away.
A suggested starting routine for a small team is:
- At each movement: record the change where the work happens. If connectivity fails, use a numbered temporary log and reconcile it once access returns.
- At the end of the day: review unrecorded deliveries, transfers, returns and unexplained negative balances.
- Weekly: review replenishment needs, overdue incoming orders and equipment that has not been returned.
- Monthly: review unused items, recurring discrepancies and whether the process still fits the team.
Train with real scenarios, not only a tour of the software. Ask a colleague to receive a short delivery, move an item, find a tool and correct a wrong entry. Where permissions are available, restrict adjustments and record deletion to the people responsible for them.
Keep recovery in the routine too. Decide who exports or backs up records, where the copy is stored and how often restoration is checked. Make access changes promptly when someone leaves the business.
08. Check accuracy and fix the causes of errors
A cycle count checks part of your stock on a recurring basis rather than counting everything at once. The important sequence is to count, compare and investigate differences before accepting an adjustment.
For a small team, start with items whose errors are most disruptive: fast-moving products, expensive equipment, frequently misplaced parts and supplies that would stop work. Choose the frequency according to risk and the mistakes you actually find.
When a balance is wrong, recount the same item, unit and location; check transactions around the count time; then look for a missed receipt, duplicate deduction, wrong location, unit conversion or unrecorded damage. Record the approved correction and its reason. Fixing the balance without fixing the cause leaves the same problem for next week.
Measure a few things consistently
- Record accuracy: item-location records matching the physical count divided by records counted. If 46 of 50 match exactly, accuracy for that sample is 92%.
- Stockouts: incidents where missing stock delayed a sale or job.
- Unexplained adjustments: corrections that still have no identified cause.
- Time to find an item: a practical check of whether location records help the team.
A high match rate on easy-to-count items can hide a serious error in a critical part, so review the exceptions as well as the percentage. For equipment, verify identity, location and condition rather than treating a quantity of “one” as sufficient evidence.
PUT IT INTO PRACTICE
A seven-day plan for a small pilot
This is a suggested rollout for a manageable area, not a promise that every business can migrate in a week. Extend it if your records need more cleanup.
- Day 1: choose the pilot, owner and main problem to solve.
- Day 2: agree item IDs, units, location labels and the record structure.
- Day 3: clean the area, count stock and enter opening balances.
- Day 4: test receipts, transfers, sales or usage, and returns.
- Day 5: train the team and define replenishment checks.
- Day 6: run a normal working day and collect problems.
- Day 7: recount a sample, investigate differences and decide whether to expand.
Ready to expand? A colleague should be able to find an item, explain its balance and record its next movement without asking the system’s creator. If not, improve the pilot first.
Common questions
Can I start with a spreadsheet?
Yes—as a preparation step for your inventory tool. A spreadsheet helps you structure products, assign consistent IDs, organise locations and units, remove duplicates, and prepare opening quantities verified by a physical count.
Use the tool’s import template where available, test a small batch, and check the records before adding the rest. Once setup is complete, record day-to-day movements in the inventory tool so the team works from one shared source of stock information. Keep the spreadsheet as a setup reference or backup, not a second live inventory system.
Should I use barcodes or QR labels from the beginning?
We recommend building labelling and scanning into your system from the start. Barcodes or QR labels connect physical items, boxes and storage locations to their digital records, helping your team find the right record without repeatedly typing names or codes.
Start with the items and locations in your pilot, use existing product barcodes where your system supports them, and add QR labels where needed. Label the level you actually track: an individual tool, a box of supplies or a storage location. Test each label and teach the team how to record a movement after scanning.
For products sold through retailers or marketplaces, check their identifier requirements separately: an internal inventory label does not replace a required retail product barcode.
How often should we count stock?
There is no single frequency for every business. Start with more frequent checks for critical, fast-moving or error-prone items, then adjust based on discrepancies. Your operational count schedule is separate from any reporting or contractual requirements that apply to your business.
What if we operate from several locations?
Keep a separate balance for each item-location combination and record both sides of transfers. Decide how to represent stock in transit so it is neither available in two places at once nor lost between dispatch and receipt.
What is the most useful first step?
Pick one shelf, one category or one van. Count it, label it and record every movement for a short trial. A small record that people trust is a better foundation than a complete catalogue nobody maintains.