Retail Equipment Tracking System — Case Study

2 947 units across 21 regions — the question "where is our equipment" now has a number attached
Who holds how much, what breaks most often, and what is waiting on a signature right now
Territory coverage at a glance: the manager plans purchases from the map, not from a hunch
The card for one fridge: where it stands, who is answerable for it, and when it was last visited
Acts, contracts, repairs and moves live on the unit itself — not in somebody's folder
Approval happens in the system: a request carries its own signature chain and cannot quietly skip one
Every hryvnia spent on repairs, traceable to a unit — this is what makes "repair or replace" a calculation

Client: Krivoozerska KhSF LLC — mineral water producer
Industry: FMCG: manufacturing and distribution
Launched: June 2023
Engagement: turnkey development and continued evolution of the system

The problem

Fridges, shelving units and branded stands are an asset the company buys with its own money but keeps outside its own premises: in someone else's points of sale, under the responsibility of different managers and distributors. Tracking was done in Excel — everyone with their own file and their own version of the truth.

What that led to:

nobody could say where a particular unit actually stood or what condition it was in;
moves were not recorded — equipment "disappeared" between managers and turned up only at stocktake;
repairs lived a paper life: statements filed separately, invoices separately, the history in the head of whoever was responsible;
there was no answer to "how much have we already put into this fridge";
a stocktake meant driving out and reconciling by hand against lists, while the manager could not see territory coverage.

In other words, the company owned an asset it did not actually manage.

The solution

We built a system in which every unit has its own card with a history running from purchase to write-off — not a stock balance table, but a chronicle of the equipment's life.

Full history of every unit
Repairs and maintenance costs
Moves and accountability
QR codes and stocktaking from a phone
Equipment map
Manager visits
Territory navigation and analytics

Results

Tracking left Excel: one database instead of a file per manager.
The full life history of every unit: placement, moves, repairs, cost, documents — equipment does not go missing.
Repair costs are visible per unit, per type and per period: "repair or replace" became a calculation rather than a hunch.
Stocktaking is carried out from a phone by scanning a QR code.
The manager sees territory coverage on a map and plans purchases against the facts.
Field work by managers is confirmed with geolocation and photos, and reporting takes two clicks.

For the client this is not an accounting program but control over an asset that physically sits outside the company.

Technologies

ASP.NET Core Entity Framework Core Microsoft SQL Server Google Maps API Microsoft Graph API ZXing.Net (QR) DataTables XLSX export

Retail equipment tracking system for points of sale