When does a spreadsheet stop working?

At the second location, the second sales channel, or the first oversell that cost a customer. Any of those means two people are editing the truth at once, which a spreadsheet cannot arbitrate.

How do these products prevent overselling?

By holding one stock figure and pushing it to every channel quickly. What matters is the sync interval and whether stock is reserved at checkout rather than at dispatch, since the gap between them is where oversells happen.

Do I need lot or serial tracking?

If you sell food, cosmetics, medical goods or anything with a warranty, yes. Retrofitting traceability after a recall is not possible, so buy it before you need it rather than after.

Will it work with my accounting system?

Most connect to the major ones. Check how stock value posts to the ledger, because a connection that syncs quantities but not cost of goods leaves your accountant doing the work by hand.

Inventory

Stock, warehouses and order fulfilment.

0 products

Nothing matches that yet

Try a broader category, or add the product you were looking for.

Add a product

What this category covers

Knowing what you have, where it is, and what it cost: stock levels across locations, purchasing, fulfilment and the paper trail between them.

Products here range from light stock tracking bolted onto a store, to systems running several warehouses with lots, expiry dates, serial numbers and bills of materials.

Storefronts and checkout belong in e-commerce. Carrier rates, labels and tracking sit in shipping and logistics, and full operational suites are in ERP and operations.

One number, many places

The problem this software solves is having a single stock figure that every channel respects.

Ask two questions of any product. How quickly does a sale on one channel reduce availability on the others, and is stock reserved when a customer checks out or only when the parcel leaves? The gap between those two moments is where overselling lives, and no apology email fixes it as well as a shorter interval.

Multi-location handling follows the same logic. Stock in a shop, a warehouse, a van and a marketplace fulfilment centre are four separate truths that have to reconcile, and transfers between them need to be recorded rather than remembered.

The features that matter by trade

Variants and bundles, where one sale consumes several stock items.
Lots and expiry, for food, cosmetics and anything with a shelf life.
Serial numbers, for warranty and traceability on individual units.
Bills of materials, if you assemble rather than resell.
Landed cost, so freight and duty end up in the value of the goods.

That last one changes what your margins look like. Products that treat purchase price as cost will quietly overstate profitability on anything imported.

Purchasing and the demand question

Reordering by instinct produces both stockouts and dead stock, frequently in the same warehouse.

Look for reorder points that account for lead time, supplier records with actual delivery performance rather than promised, and purchase orders that receive partially without breaking. Forecasting features vary from useful to decorative, and the useful ones are the ones that explain their reasoning.

Supplier lead time is worth tracking honestly. A reorder point built on the supplier’s stated fortnight, when the real figure is five weeks, is how a business runs out of its best-selling item twice a year.

Fulfilment, counting and the physical world

Software describes stock. Warehouses contain it, and the two disagree constantly.

Check how the product supports picking, packing, dispatch and the moment a picker finds an empty shelf. Ask whether barcode scanning is included or a paid extra, and how cycle counting works. A system that requires a full annual count and offers nothing in between will drift for eleven months.

Returns need a path too. Restocking, inspection, refunds and writing off damaged goods are ordinary events, and products that ignore them push the mess back into a spreadsheet.

Integrations and what they actually sync

An inventory system sits between a store, an accounting package and sometimes a courier.

Ask what fields flow in each direction and how often. Quantities are the easy part. Cost of goods posting to the ledger, tax on purchases, and returns reversing correctly are where thin integrations fail.

Pricing usually runs on orders per month, locations, users or connected channels. Order volume is the meter that grows with the business, so model the cost at next year’s volume, and check whether a busy season pushes you into a higher tier permanently. Similar meters across other categories appear in what pricing pages hide.

Where the numbers usually go wrong

Stock accuracy decays for a small number of predictable reasons, and knowing them helps when comparing products.

Sales channels that update on a schedule rather than immediately. Returns processed as a note rather than as a movement. Damaged goods written off in a conversation instead of a transaction. Stock moved between locations by somebody who intended to record it later.

Each of those is a process problem that software can either prevent or ignore. Products that force a movement to be recorded, and make recording it quick, keep counts closer to reality than products with better reports.

Cycle counting is the maintenance habit that catches the rest. Counting a small section frequently finds drift while it is still small, and it does not require closing the warehouse for a day.

Questions people ask

When does a spreadsheet stop working?: At the second location, the second sales channel, or the first oversell that cost a customer. Any of those means two people are editing the truth at once, which a spreadsheet cannot arbitrate.
How do these products prevent overselling?: By holding one stock figure and pushing it to every channel quickly. What matters is the sync interval and whether stock is reserved at checkout rather than at dispatch, since the gap between them is where oversells happen.
Do I need lot or serial tracking?: If you sell food, cosmetics, medical goods or anything with a warranty, yes. Retrofitting traceability after a recall is not possible, so buy it before you need it rather than after.
How is inventory software priced?: By orders per month, by locations, by users or by the number of connected channels. Order volume is the meter that grows with you, so model the price at next year's volume rather than today's.
Will it work with my accounting system?: Most connect to the major ones. Check how stock value posts to the ledger, because a connection that syncs quantities but not cost of goods leaves your accountant doing the work by hand.