Leamington Spa
Thu, 19 Mar 2026
PI Dashboard
Wks 3–10 · Leamington Spa · 850 records
⚠️ Database out of sync — clean re-sync required
453 rows (159,317 units) from Weeks 7–10 will be force-upserted to Supabase.
This is safe to run multiple times — existing correct rows are simply overwritten.
PI Accuracy
98.53%
Target 99.00% AMBER
Total Errors
67
SKUs with discrepancy View →
Net Direction
-13
Found − Lost View →
Units Found
509
Surplus stock View →
Units Lost
763
Missing stock View →
Total Counted
272,430
Units processed
Accuracy vs Target
PI Accuracy: 98.53% / Target: 99.00%
95%96%97%98%98.53% ◆99% ▲ Target100%
Metric Target Actual Status
PI Accuracy 99.00% 98.53% FAIL
Top 10 Adjusted SKUs
Ranked by absolute qty impact
# SKU Units Found (+) Units Lost (−) Net Units Total Counted Locations Impact
1 ITM015638 +1 414 -413 2,991 3
415
2 PP-POAPSA-0200-UK +236 — +236 1,059 3
236
3 84755 +6 96 -90 4,885 4
102
4 S22011 — 90 -90 990 1
90
5 KNBSA250 +77 — +77 388 1
77
6 83491 +30 — +30 2,717 3
30
7 LMPRLGBX +28 — +28 8,976 10
28
8 56502 +18 — +18 546 1
18
9 83298 +18 — +18 5,322 6
18
10 PP-GOATPW-0250-UK — 18 -18 186 3
18
Weekly Accuracy Trend
Units Found
Units Lost
No multi-week data available for current filter
Top 10 Problem Locations
Ranked by absolute discrepancy
# Location Client SKUs Sys Qty Counted Qty Units Found (+) Units Lost (−) Net Accuracy
Loading…
Client Scorecard
Ranked by accuracy · click row to filter dashboard
Client RAG Lines Found Lost Accuracy vs Target
Pi Schedule
Weeks 3–52 · Client → SKU mapping · Click any Week to edit
—
# Client Product SKU Week ✎ editable Status Actions
Raw Data
Products in Location Export — Upload CSV to update
📂
Upload Products in Location CSV
Click or drag & drop · .csv files only
0 records
Client Warehouse Location Type Location Type Product SKU Product Name Qty Batch No Best Before Week
No records found
Results
Count results with accuracy metrics · 🔒 Editing locked
—
Week Client Warehouse Product SKU Product Name Location Sys Qty ✎ Counted Qty ✎ Discrepancy Accuracy % auto Loc Acc Avg % auto Batch Best Before Counted At audit Counted By audit
Second Counts
Verify discrepant counts with an independent second count before adjustment
Week Client SKU Location Sys Qty 1st Count 1st Disc 2nd Count 2nd Disc Status Counted By 2nd Counted By 2nd Counted At Action
Low Stock Checks
Locations under their level and not checked in the last few weeks. Sys qty is from the last Products in Location upload, so upload a fresh one before a round of checks.
Out for Count
Items currently being counted
—
Week Client Warehouse Product SKU Product Name Location Sys Qty Batch No Best Before Counted Qty
Count Data
Raw count data · 5,617 records
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
 = results counted
—
Week Client Warehouse Product SKU Product Name Location Quantity Serial No Batch No Best Before
Upload CSV
Upload a Products in Location export to replace the Raw Data tab
📤
Products in Location Export
Upload a .csv file · columns will be auto-detected
Expected CSV Columns
Client
Warehouse
Location
Type
LocationType
ProductSKU
ProductName
Quantity
SerialNo
BatchNo
BestBefore
Week
Column order doesn't matter — headers are matched by name. Extra columns are preserved.
📅 Week Planner 2026
ISO weeks · working days · bank holidays · PI schedule · Leamington Spa
Current ISO Week
—
—
Working Days Left (Year)
—
of 2026
Next Bank Holiday
—
—
PI Weeks Planned
—
weeks with PI scheduled
Client Adjustments
Review what clients have approved or disputed across all accounts
Pending Review
—
Awaiting client action
Approved
—
Client accepted
Disputed
—
Client queries count
Total Adjustments
—
All clients combined
Status Week Client SKU Location Sys Qty Counted Discrepancy Accuracy Batch Client Comment Reviewed At
Click Refresh to load adjustments
Client Access
Who at each client can sign in to the portal. People sign themselves up with an emailed code once their address or company domain is added here.
Let people sign up
Can see
A domain lets anyone with an address on it sign up and see the clients ticked. Personal email domains (Gmail, Outlook and so on) can only be added one address at a time.
Sign-up rules
Shown asWho can sign upCan seeAddedStatus
Loading…
People signed up
EmailShown asCan seeLast sign-inStatus
Loading…
Archiving a rule stops new sign-ups only. Anyone already signed up keeps access until you block them here.
🔓 Lock Editing
Lock Sys Qty & Counted Qty editing
🏭
Welcome
Your PI accuracy overview — Leamington Spa
🎯
PI Accuracy
—
Target: 99.00%
—
⚠️
Total Errors
—
SKUs with discrepancy
▼ Click to expand
↔️
Net Direction
—
Surplus locations − Loss locations
▼ Click to expand
✅
Units Found
—
Surplus stock
▼ Click to expand
📉
Units Lost
—
Missing stock
▼ Click to expand
📦
Total Counted
—
Units processed
Accuracy vs Target
—
Weekly Accuracy Trend
Units Found
Units Lost
Top 10 Adjusted SKUs
By absolute impact
#SKUFoundLostNetImpact
Top 10 Problem Locations
By absolute discrepancy
#LocationFoundLostNetAccuracy
My Results
Read-only view of your count results
Week Client Warehouse Product SKU Location Sys Qty Counted Qty Discrepancy Accuracy % Batch Best Before Counted At Counted By
Second Counts
Discrepant counts verified with an independent second count
Week SKU Location Sys Qty 1st Count 1st Disc 2nd Count 2nd Disc Status Counted By 2nd Counted By 2nd Counted At
My PI Schedule
Weeks when your stock is counted · green = counted · grey = upcoming
Counted — results available Upcoming — not yet counted
Week Client Product SKU Status Sys Qty Counted Qty Discrepancy Accuracy
Planner
Weekly planning notes and PI schedule overview
Discrepancy Summary
SKUs with stock differences — surpluses and losses
Surplus SKUs
—
units found
Loss SKUs
—
units missing
Exact Match SKUs
—
zero discrepancy
Week Client Product SKU Location Sys Qty Counted Difference Accuracy Batch
Adjustments for Approval
Review discrepancies and approve or dispute each one
WeekClientSKULocation Sys QtyCountedDiscrepancy AccuracyBatchStatusComment & Action
🔑Set your own password
You're signed in with a password Fullers set for you. You can replace it with one only your team knows.
🔑Set your password
Choose a new password for this login
This login is shared by everyone at your company. Changing the password changes it for all of them.