EN
Marketplace

How Do You Choose Inventory Tracking Software? A Checklist for Variants, Multiple Warehouses, Critical Stock, and Marketplace Sync

How do you choose inventory tracking software? A checklist for variants, multiple warehouses, barcodes, critical stock and marketplace sync, a reorder point example and moving off Excel.

Contents 13 sections
  1. What is inventory tracking software and how is it different from Excel?
  2. Which nine features should you look for in inventory tracking software?
  3. How should products with variants be tracked in inventory tracking software?
  4. How is multi-warehouse inventory tracking done?
  5. How do you set up a barcode and stock code standard?
  6. How do you set a critical stock alert? A reorder point example
  7. Why do you need inventory movement and cost reports?
  8. How should stock sync with marketplaces and your e-commerce site work?
  9. How do inventory counts and reconciliation work in the software?
  10. How do you move from Excel to inventory tracking software step by step?
  11. What are the most common mistakes when choosing inventory tracking software?
  12. How do you track inventory with NetKasam?
  13. Frequently Asked Questions About Inventory Tracking Software

While stock counts are kept in an Excel spreadsheet, things work; once your product range grows and a second warehouse, a store or marketplace sales come into play, the spreadsheet starts slowing you down. Problems such as a sold product still showing as "in stock", orders placed for products not on the shelf and not knowing what is in which warehouse appear at this point. The solution is usually to use inventory tracking software; the hard part is choosing which one.

This guide does not explain from scratch what inventory tracking is; for that, see the article what you need to know about inventory management. Here we answer a single question: which features do you really need when choosing inventory tracking software, and how do you test them? You will find nine features, a comparison formula, what to watch for in multi-warehouse and marketplace sync, a sample calculation for critical stock and the steps for moving from Excel to software. The sample figures are only there to illustrate the method.

What is inventory tracking software and how is it different from Excel?

In short: Inventory tracking software is software that automatically updates the incoming, outgoing and current quantity of products with every sale, purchase and transfer. In Excel, you type the stock count yourself; in the software, sales, return and transfer documents change stock by themselves.

The difference looks small but its consequences are big. In a spreadsheet, every sale requires a second manual step; every forgotten row moves the stock count away from reality. In the software, stock is a by-product of the document: when an invoice or order is issued, the quantity drops; when a purchase is entered, it rises; and who changed what and when stays on record. This chain of records is also the basis of inventory valuation methods and cost calculation.

If you are experiencing two of these signs, it is time to move to software: you sell the same product on more than one channel; your inventory counts keep showing differences; your employees edit the same spreadsheet at the same time; you have to make a phone call to ask what is in which warehouse.

Which nine features should you look for in inventory tracking software?

In short: Look for nine features: variant product structure, multiple warehouses and branches, barcode and stock code setup, critical stock alerts, an inventory movements report, cost calculation, marketplace and e-commerce stock sync, counting and reconciliation, and user permissions. Weighting and scoring each one for your business makes the decision process clearer.

ScoringA weighted score formula for comparing inventory tracking software
  1. Feature score = the grade between 0 and 5 you give after testing with your own products
  2. Weight = the importance of the feature for your business (1, 2, or 3)
  3. Weighted score = Feature score × Weight
  4. Total score = Sum of weighted scores ÷ (5 × sum of weights) × 100

For a business selling from three warehouses on two channels, the multi-warehouse weight might be 3; for a single-store business, it might be 1.

The table below summarizes the nine features, the question to ask for each and what a good answer looks like. You can ask these exact questions during a demo.

FeatureQuestion to askWhat does a good answer look like?
Variant productsIs stock kept separately for breakdowns such as size and color?A single product card, with separate stock, barcode and image for each variant
Multiple warehouses and branchesHow many warehouses can I create; can I see stock per warehouse and make transfers?No limit on the number of warehouses, with transfer documents and per-warehouse reports
Barcodes and stock codesCan I give a product more than one barcode; are codes duplicated?Code uniqueness is checked, and multiple barcodes are supported
Critical stock alertCan I define a threshold per product and get an alert?A notification when the threshold is reached, and a critical stock report
Inventory movementsCan I see why a product's stock changed and who changed it?Every receipt, dispatch and transfer is listed with date and document
Cost calculationAre inventory cost and turnover reported?Cost and turnover come out as reports
Channel syncIs stock on marketplaces and your e-commerce site synced automatically?Stock drops on a sale, the change is reflected across channels, and errors are visible
Counting and reconciliationCan I enter the count result into the system with its difference?Count difference entries and their history are kept
User permissionsCan a warehouse employee see and work only in their own warehouse?Warehouse- and action-based permissions are defined per user

How should products with variants be tracked in inventory tracking software?

In short: A product's size, color or model breakdowns should be defined as variants of a single product, not as separate product cards, and stock should be kept separately for each variant. If the software limits the number of variants, a growing catalog becomes unmanageable at some point.

A T-shirt in five sizes and four colors makes 20 variants; when your range grows to a few hundred products, Excel ends up with thousands of rows. There are three things to ask about the software: is there a limit on the number of variants, does each variant have its own barcode and image, and is stock kept per variant? In NetKasam, inventory management supports creating unlimited variants, the stock of each variant is tracked separately and separate images can be uploaded for variants. We explained how the number of variants is calculated and how to match them on marketplaces in the article how to manage products with variants.

How is multi-warehouse inventory tracking done?

In short: In multi-warehouse inventory tracking, each warehouse's and branch's stock is kept separately, moves between warehouses are made with a transfer document and reports are pulled per warehouse. A single-pool structure can show a product that has run out in one warehouse as if it were available in another.

To test multi-warehouse support, try three things: make a transfer between two warehouses; report one warehouse's stock separately; define a user for a warehouse employee who sees only that warehouse. In NetKasam, with branch and warehouse management you can track your inventory from one place, transfer stock, report on each branch or warehouse separately and define separate users and permissions for each. There is also no limit on the number of warehouses: you can create as many warehouses as you like and assign users to them.

BreakdownThe sample business's 1,000 units of stock are split across three warehouses like this
  • Main warehouse₺60060%
  • Store warehouse₺25025%
  • Second warehouse₺15015%

Prepared with sample values. Even if total stock is correct, transfer and shipping decisions cannot be made if the per-warehouse view is not visible.

In a multichannel setup, store sales and online orders should be deducted from the same stock. To set this up in detail, see the tutorial how to manage store and e-commerce inventory from one center; for the store side, the in-store POS screen page is also useful.

How do you set up a barcode and stock code standard?

In short: Define a stock code for each product and each variant that is assigned once, never changes and never repeats; match the barcode to this code. If marketplace and e-commerce matching is done with these codes rather than product names, the link does not break when the name changes.

Four rules will serve you well in your code system: keep the code meaningful but short (product group, model, size and so on); do not include the product name or price, because these change; do not give the same code to two products; do not change a code once it is set. For coding details, read the article what you need to know about stock codes. It is also important that the software lets you give a product more than one barcode: when different markets require separate barcodes, you do not have to create the product twice. NetKasam's automatic multiple barcode feature supports assigning more than one barcode to products.

How do you set a critical stock alert? A reorder point example

In short: The critical stock level is the sum of the quantity that will be sold during the product's lead time and the safety stock; in other words, it is the reorder point. When stock drops to this quantity, you get an alert and place an order.

In NetKasam, the critical stock level is the stock threshold at which you want the system to warn you. For example, if you enter 3, you get a notification when stock drops to 3 units and can start replenishment before the product runs out. So what number should you enter? The example below finds the reorder point with a simple safety stock formula; for statistical methods and economic order quantity, see the article how to calculate safety stock.

Assumption (sample product)Denomination
Average daily sales8 units
Highest daily sales14 units
Average lead time6 days
Longest lead time9 days

First calculate safety stock: highest daily sales × longest lead time − average daily sales × average lead time = 14 × 9 − 8 × 6 = 126 − 48 = 78 units. Then find expected sales during the lead time: 8 × 6 = 48 units. The reorder point is the sum of the two: 48 + 78 = 126 units.

Reorder pointThe critical stock level is 126 units, the sum of lead-time sales and safety stock
  1. Expected sales during lead time (8 × 6)48 units
  2. Safety stock (14 × 9 − 8 × 6)78 units
  3. Reorder point (critical stock)126 units

Prepared with sample values. Results are rounded up if needed.

In this example, you enter 126 as the critical stock level on the product card. When stock drops to 126 units, you get an alert; if the supplier delivers in 6 days on average, the 48 units of sales expected in that time are deducted from stock, leaving 78 units as a safety buffer. Even if lead time stretches to 9 days and sales rise to 14 units a day, stock does not run out. Instead of repeating the same calculation by hand for many products, start with high-volume products; you can determine which ones take priority with an ABC analysis.

Takeaways from the exampleFour numbers from the reorder point example
  • 48 unitsexpected sales during the 6-day lead time
  • 78 unitssafety stock against fluctuations in demand and supply
  • 126 unitsreorder point to enter as the critical stock level
  • 14 unitshighest daily sales that can be met before stock runs out

Prepared with sample values.

Recommended readingHow to Calculate Safety Stock and the Reorder Point?

Why do you need inventory movement and cost reports?

In short: The inventory movements report shows which document changed a product's quantity, when and by whom. Cost and turnover reports reveal how efficiently the money tied up in inventory is turning over.

When the stock count comes out wrong, the first question is "why". Without a movement record, the answer is a guess; with one, sales, return, transfer and count documents can be traced one by one. In NetKasam, with the detailed inventory movements report you can calculate inventory costs and see your product expenses and inventory turnover rates. We explained, with calculations, how cost is found with methods such as FIFO and weighted average in the article how to calculate inventory cost. For what turnover means, the article the role of inventory turnover helps. For all reports, take a look at the reports page.

How should stock sync with marketplaces and your e-commerce site work?

In short: In stock sync, stock should drop the moment a sale happens, the reduced quantity should be reflected across all channels and failed updates should be visible. If sync is delayed, the same product is sold on two channels at once and orders have to be canceled later.

Ask four things about the software: does stock drop automatically when an order comes in; which channels does a stock change go to and how often; where do errors show up; are store sales and online sales deducted from the same stock? In NetKasam, inventory management sends your product stock to your e-commerce site and to sites you provide an XML feed to, and deducts stock on orders. In the Connect and Global Plus plans, order and stock synchronization is real-time; the scope and current prices of the plans are on the pricing page. Bookkeeping and inventory tracking are always free.

We covered, with calculations, how much overselling a sync delay causes and the difference between a shared pool and channel-allocated stock in the article how to do marketplace stock synchronization. If you receive products and stock from your supplier via XML, add the checks in the article how to set up an XML integration to your list as well. If you want to assess the marketplace side as a whole, see the marketplace integration page.

Recommended ReadingHow to Sync Marketplace Inventory?

How do inventory counts and reconciliation work in the software?

In short: A count compares the quantity counted on the shelf with the system record and corrects the difference with a document. Software that keeps count differences along with their history lets you see why the same error keeps repeating.

The first count after moving to the software is the most important one, because it sets your opening stock. For types of count differences, cycle counts and accounting entries, see the guide how to do an inventory count. The example below shows how the system record is brought in line with the count result.

ChartIn the sample count, the system record is 540 units while the count result is 533 units
  1. Quantity in the system record540 units
  2. Not found on the shelf (broken, lost)−4 units
  3. Put on the wrong shelf or in the wrong warehouse−3 units
  4. Quantity found by the count533 units

Prepared with sample values. The difference is 7 units; if the 3 misplaced units are found, the loss is 4 units.

The point to watch here is not to book the difference to a single line. A product put on the wrong shelf is not lost; once it is found and put back, the difference closes. A broken or lost product is recorded as shrinkage. Software that does not record the cause of a difference does not help you prevent the same error from repeating.

How do you move from Excel to inventory tracking software step by step?

In short: The move is done in six steps: cleaning up the Excel list, setting the code system, defining warehouses, importing products, doing an opening count and closing the old spreadsheet. Products should not be updated in two places at the same time.

Migration pathMoving from Excel to software in six steps: clean up first, then import, count and close the old spreadsheet
  1. 01
    Clean up the listRemove duplicate rows, blank codes and discontinued products.
  2. 02
    Set the code systemWrite down stock code and barcode rules; put variants on separate rows.
  3. 03
    Define warehousesCreate physical warehouses, stores and branches; assign users and permissions.
  4. 04
    Import productsTry first with your 20-30 best-selling products, then upload the whole list.
  5. 05
    Do an opening countCount the shelves and correct the quantity in the system to match the count result.
  6. 06
    Close the old spreadsheetArchive the Excel file; stock should change only in the software.

In NetKasam you can import products from the software you use with the help of Excel; you can get help from the user guide or the expert support team. For the general migration logic, the articles moving from Excel to cloud accounting software and data transfer when changing accounting software are also useful.

What are the most common mistakes when choosing inventory tracking software?

In short: The most common mistakes are looking only at price, deciding without a demo, not setting up the code system from the start, skipping the count and keeping inventory software separate from invoicing. The seven mistakes below explain most of the losses.

  1. Creating variants as separate products. Making separate cards for the sizes of the same product scatters reports and marketplace matching.
  2. Tying the code to the product name. When the name changes, matching breaks; the code should be a key that does not change.
  3. Entering critical stock by guesswork. Instead of saying "let's make it 10", calculate it from lead time and sales.
  4. Not doing an opening count. Every movement built on a wrong opening stock stays wrong.
  5. Keeping inventory separate from invoicing. If an invoice is issued but stock does not drop, the two systems drift apart; stock should be deducted from the sales document.
  6. Naming warehouses after channels. Physical location and sales channel get mixed up, and stock appears duplicated.
  7. Leaving the old spreadsheet open. Stock updated in two places soon becomes wrong in both.

How do you track inventory with NetKasam?

In short: In NetKasam, inventory tracking runs in the same panel as bookkeeping and e-Invoice: unlimited variants, multiple warehouses, critical stock alerts, an inventory movements report and stock transfer to marketplaces and e-commerce are all in one system. Bookkeeping is free.

With inventory management you can define your products with unlimited variants, sell in cases or boxes using tiered pricing and set definitions, copy a new product from a similar one, import and export XML and monitor critical stock reports. Branch and warehouse management lets you track warehouses and branches separately and transfer between them. Because inventory data is combined with order management and invoicing, you work with the same data. To learn about the bookkeeping side, see the bookkeeping software page; for e-commerce site and marketplace coverage, see the e-commerce software page. No credit card details are required to sign up, and setup is free.

Frequently Asked Questions About Inventory Tracking Software

How do you choose inventory tracking software?

Nine features such as variant structure, multiple warehouses, barcode and code setup, critical stock alerts, inventory movements, channel sync and counting are tested with your own products and compared with a weighted score.

How is multi-warehouse inventory tracking done?

Each warehouse and branch is defined separately, stock is kept per warehouse and moves between warehouses are made with a transfer document. In NetKasam there is no limit on the number of warehouses, and separate users can be assigned to warehouses.

What is the low-stock quantity?

It is the stock threshold at which you want the system to warn you. When stock drops to this quantity, you get a notification and can start replenishment before the product runs out. Calculate the quantity from lead time and sales.

How is stock tracked for products with variants?

The product is created as a single card, breakdowns such as size and color become variants and the stock of each variant is tracked separately. NetKasam supports unlimited variants.

Why is marketplace stock sync important?

If sync is delayed, the same product is sold on more than one channel and orders have to be canceled later. Stock needs to drop instantly on a sale and be reflected across channels.

Can I import my inventory list from Excel into the software?

Yes. In NetKasam, products from your current software can be imported with the help of Excel. Before importing, you need to clean up the list, make codes unique and then do an opening count.

Is the inventory tracking software free?

In NetKasam, bookkeeping, the e-Invoice system and inventory tracking are free. What is paid are the marketplace and e-commerce integrations; current scope and prices are on the pricing page.

How often should inventory be counted?

An opening count is essential when moving to the software; after that, in addition to the year-end count, cycle counts can be done for best-selling products. The cause of every difference should be recorded.

The right inventory tracking software is one that not only shows today's stock count correctly but can also handle the warehouse and channel you will open tomorrow. As a first step, clean up your Excel list, test your twenty best-selling products on two or three candidates, set the critical stock level with the calculation above and do not close the old spreadsheet before doing the opening count.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeInventory Tracking and Management

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools