Solutions/Operating failure 05/Chemical traceability

Every gram, back to a branch, a person and a visit.

Six chemicals sit on the Andheri shelf. Pick one and follow it: the goods receipt it came in on, the branch that stored it, the technician who carried it, the site it was used at and the certificate that proves it.

CHAIN OF CUSTODY · FP-2291 Fipronil 0.05% gel · exp 11/27 · cockroach gel
01 · RECEIVED✓ ON RECORD
GRN GRN-0613
3 Sep · 40 tubes × 30 g · checked in by Arjun
02 · BRANCH STORE✓ ON RECORD
STORE Andheri
22 tubes still on this shelf, 18 issued
03 · ISSUED TO✓ ON RECORD
Imran S
ISS-2214 · 8 Sep, 08:12 · 4 tubes · accepted on his phone 08:14
04 · USED AT✓ ON RECORD
Sunrise Foods kitchen
VIS-04412 · 11:04 · 38 g on 46 points
05 · PROVED ON✓ ON RECORD
CERT SF-AMC-1188-09
Certificate · signed by Suresh Nair, 11:41
5 / 5 links on record, each written by the person who did it, at the time they did it.
Tuesday, 11:40 · the supplier calls

“Batch CY-0417 is off-spec. Where did it go?”

Recall took two days. Now two minutes.
— Suresh · owner

Twenty litres of Cypermethrin came in on 22 August. Since then it has been split across three branches, five technicians and eleven sites. On paper, finding them takes days of calls while the vans keep spraying. Run the trace.

00:00seconds so far
01 · THE BATCH
CY-0417Cypermethrin 10% EC · Sai Agro · GRN-0588
11 Lused on sites 2 Lstill in 3 vans 7 Lsealed in stores
02 · BRANCHES
03 · PEOPLE WHO CARRIED IT
04 · SITES AND VISITS
Sunrise Foods · Andheri kitchen9 Sep · 0.9 L · Imran S FOOD
Hotel Sea Pearl · Juhu11 Sep · 0.8 L · Imran S
Kalher Residency · Wing B13 Sep · 0.9 L · Imran S
Orchid Hospital · OPD block10 Sep · 1.0 L · Sunil K HOSPITAL
Greenfield Mall · basement12 Sep · 1.4 L · Sunil K
Vashi Grand · banquet hall10 Sep · 0.8 L · Faiz A
Little Stars School · Goregaon14 Sep · 0.8 L · Faiz A SCHOOL
Meridian Foods · plant 210 Sep · 1.2 L · Manoj P FOOD
Lodha Amara · tower C15 Sep · 1.0 L · Manoj P
Thane Civil Club · kitchen17 Sep · 1.2 L · Manoj P FOOD
Kalyani Pharma · warehouse 316 Sep · 1.0 L · Deepa R PHARMA
Tap a branch or a person to narrow the trace. Every row above is a record someone already created: the goods receipt, the branch transfer, the morning issue slip, the visit. The trace just reads them backwards.
The trace, run the other way

One kitchen. A year of what went into it.

Sunrise Foods’ Andheri kitchen gets a visit every fortnight. Each square is one visit, coloured by the chemical group used. Tap any square for its batch, dose and technician, then switch on the rotation rule.

Sunrise Foods · Andheri central kitchenAMC SF-1188 · 24 visits · Oct 2025 to Sep 2026
PhenylpyrazolePyrethroidNeonicotinoid Complaint
VISIT 10 · 6 Feb 26 · VIS-03597Cypermethrin 10% EC GroupPyrethroidBatchCY-0311Dose0.9 L at 1:100 over 420 m²Complaint afterNone
Sunil K · Andheri branch · certificate SF-AMC-1188-10
Visits 7 to 12 used the same pyrethroid six times running. Nobody decided that. It was simply the bottle in the van. NO RULE WAS CHECKING THE RECORD
On Imran’s phone · try it

Imran’s phone stops the wrong bottle before he sprays.

Phone said stop. Wrong bottle. Good catch.
— Imran · technician

Imran is at the Sunrise kitchen, recording what he used. Batch and expiry come from his morning slip, so he cannot mistype them. Pick what he tries to record.

VIS-04412 · Sunrise FoodsAndheri kitchen · 11:04 · Record chemical
CHEMICALFipronil 0.05% gel
BATCH · FROM SLIPFP-2291 ✓
EXPIRY · FROM SLIP30 Nov 2027 ✓
ISSUED TO · FROM SLIPImran · ISS-2214 ✓
DOSE · FROM IMRAN38 g on 46 points ✓
AREA · FROM IMRANKitchen + dry store · 380 m² ✓
LICENCE · FROM HRPCO-4471 · valid to Mar 2027 ✓
SAVED TO THE VISIT 38 g drawn from Imran’s hand-stock. It will print on today’s certificate with the batch.
Saved ✓
This is the boring one. Most visits look like this.
The trail, in the product

Three people write the trail. Nobody writes it twice.

Stores issues the bottle, the technician uses it on the visit, quality reads it on the certificate. Each screen adds one link to the same record.

Strict policy: a visit can’t name a chemical that was never issued.Issued against consumed, per chemical, every evening.Still holding stock from last week? Return first.
Demo workspace · sample data · Aug 2026
What you set up once

Close five links once. After that, every visit writes the trail.

Set once. I never fill the register again.
— Deepa · quality

Each link is one setup your stores and technical team finish during implementation. Tap a link to see what it holds, then close it. The bottle and the kitchen are only connected when all five are closed.

UPGEAR records what was used, by whom, where and from which batch. It does not make a use lawful. The label, the registration and your licence decide that, and UPGEAR keeps them on file beside the record.

THE BOTTLE
z z
THE KITCHEN
0 / 5 closed No links closed yet. The bottle and the kitchen are not connected.
LINK 1 · THE BOTTLE Every chemical in one product master. Active ingredient, strength, formulation, label colour, registration number, antidote and re-entry interval, with the label and MSDS attached. WHO · YOUR TECHNICAL HEAD + OUR TEAM MATERIALS
THE QUESTION THIS LINK ANSWERS Which chemical is this, and what does its label allow? You saw this on the shelf ↑
1-HOUR DEMO

Bring one batch number from your godown. We’ll trace it on the call.

Bring the product name, the batch, roughly how much you bought and which branches keep it. That is enough to show where each part of it would sit in UPGEAR and who would be holding it.

The half-empty bottles make the best demos.
Recall drillBatch off-spec. Where did it go?Rakesh · Godown