Review the full history of stock movements for each sub-warehouse with purchase price and all three selling prices, and see the real value of stock per shop, exportable to CSV, Excel and PDF.
The Fixh IT warehouse inventory turns the day-to-day movement of spare parts and accessories, every purchase, sale, repair, transfer, return or adjustment, into a searchable log and a concrete economic value. While the product catalog tells you "what is" in the warehouse, the inventory tells you "what happened" and, above all, "how much what is left is worth": for every movement it shows the recorded purchase price alongside the three selling prices active at that moment, counter sale, private customer repair, and partner repair, so you always keep margin and stock value under control, shop by shop and sub-warehouse by sub-warehouse.
Why it matters for a repair shop
A repair shop running several sub-warehouses in the same location, main warehouse, sales counter, lab, warranty parts store, can easily lose the overall picture: knowing how many pieces came in this week is useful, but it does not tell you whether that warehouse, as a whole, is really worth what you expect, or whether capital tied up in spare parts is quietly piling up in a forgotten corner. Likewise, an owner who has to report the warehouse value at month end, or check whether the margin on partner repairs is still sustainable against the purchase price, needs a single document that cross-references quantity, purchase price and selling prices, not a manual reconstruction from dozens of product records. The inventory answers exactly this need: it is the bridge between day-to-day operations, stock in, stock out, and a real-time, filterable snapshot of the warehouse's worth, sliced by sub-warehouse and category. Without that snapshot, two shops in the same chain can carry very different amounts of capital locked up in spare parts without anyone noticing until the year-end physical count, by which time it is too late to correct course.
How it works in practice
The page opens on the currently selected shop and lists, from most recent, every recorded warehouse movement: purchases from suppliers, counter sales, parts used in repairs, transfers in and out between sub-warehouses, returns, manual adjustments and scrap. Two filters narrow the view: the first picks a single sub-warehouse or all of them together, the second lets you choose one or more product categories via checkboxes, leaving "all categories" selected when none is picked. Each table row shows the date, the product with SKU and EAN, the sub-warehouse, the category, the movement type with quantity in or out, the purchase price tied to that movement and, next to it, the product's three current selling prices: counter sale price, price reserved for private customer repairs, and price reserved for partner repairs.
At the bottom of the page, a separate section shows the warehouse's real value: not the sum of the listed movements, which would count sold and returned pieces more than once, but the valuation of the stock actually on hand right now, calculated line by line on the still-available purchase batches and multiplied by the three selling prices. The result is grouped by sub-warehouse, with a grand total at the bottom, so you can immediately see whether value is concentrated in the main warehouse or spread across several stores, and what potential margin it represents for each sales channel.
The whole list, with the same filters applied on screen, can be exported to CSV, an Excel sheet, or a PDF document ready to be archived or shared with your accountant, automatically respecting the sub-warehouse and categories selected at export time. There is no need to redo the search or reapply filters on the exported file: the document reflects exactly what is on screen at the moment it is generated.
Quick guide
- Go to Warehouse and open Inventory.
- Select the shop whose inventory you want to review from the top selector.
- Pick a single sub-warehouse or leave "All warehouses" to see them all together.
- Select one or more categories with the checkboxes, or leave "All categories" for no filter.
- Scroll the list to review every stock in and stock out with purchase and selling prices.
- Check the totals section at the bottom to see the real stock value per sub-warehouse.
- Export to CSV, Excel or PDF whenever you need a document to archive or share.
Real use cases
At month end the owner needs to report the warehouse value to the accountant for the books: they open the inventory, select "All warehouses", export the PDF with the valuation totals and attach it without manually rebuilding stock and prices from several spreadsheets.
A shop manager notices that the "Warranty store" sub-warehouse keeps accumulating value and never clears out: filtering the inventory to just that sub-warehouse reveals that several parts returned under warranty were never resold or scrapped, prompting a decision on how to clear them.
Before renewing an agreement with an external repair partner, the owner filters the inventory by the category of parts most used in those repairs and compares purchase price against the partner price row by row, checking whether the margin is still sustainable or needs revising.
Tips and best practices
Check the inventory for a single sub-warehouse when you want to investigate a specific issue, for example a store that never reconciles, and switch to "All warehouses" when you need the shop's overall picture instead. Export the valuation totals PDF periodically, even just monthly, to keep a history of warehouse value over time instead of relying only on live data. Combine the category filter with the sub-warehouse filter when you need to isolate a pricing or stock issue on a single product family, such as batteries or displays.
Common mistakes to avoid
Do not confuse the total of the listed movements with the warehouse value: adding up every stock in and out over a period does not give you the real value of stock, because it also counts pieces already sold or returned; the correct figure is always the one shown in the valuation totals section, calculated on the stock actually on hand. Avoid ignoring a secondary sub-warehouse for too long just because it sees few movements: the least-visited stores are precisely where forgotten value or stock to be sorted out tends to build up unnoticed. Do not rely on memory alone to check whether the partner price is still in line with the purchase price: the inventory puts the two figures side by side exactly to make that check immediate.
Frequently asked questions
Does the warehouse value shown at the bottom of the page reflect the movement history or the current stock? It reflects the stock currently on hand, valued at the purchase price of the available batches: the movements listed above are for traceability, not for the value calculation.
Can I view the inventory of a single sub-warehouse at a time? Yes, the warehouse filter lets you pick a single sub-warehouse or "All warehouses" to see them aggregated.
What happens if I do not select any category in the filter? Movements from all categories are shown: the category filter is optional and only narrows the view when needed.
Are the three selling prices shown for each movement the historical ones at the time of the movement, or the current ones? They are the selling prices currently set on the product, so you can always compare the historical purchase cost against today's active price list.
Does the export respect the filters I set on screen? Yes, CSV, Excel and PDF are generated with the same sub-warehouse and categories selected on the page.
Do I need to change anything in the product catalog to use the inventory? No, the inventory automatically reads the movements and prices already present in product records and sub-warehouses: no extra setup is required.
