About Services Tools Blog Contact us

Postcode Order Value Map

Plots order postcodes from a payment export on a UK map. Circle size shows how often a postcode appears and colour shows order value.

  • Mapping & Geospatial
  • Retail
  • Dashboard feature
  • Productised
  • Hybrid
  • 2025

The problem

Staff could not see where orders cluster, or which districts spend more, from a flat payment export. Sorting the sheet by value put the biggest orders at the top but still showed no regions.

What it does

The payment export is counted by postcode, and each postcode is matched to a map position from a local list. Circles are drawn on Google Maps, coloured by order value and sized by how often that postcode appears. Clicking a circle shows the total, the order count and the map position.

Outcomes

  • Order clusters show up on a map instead of in a sorted sheet.
  • Value and frequency are shown separately, so a large circle is not mistaken for a large spend.
  • A district can be inspected without exporting the data again.
  • The same page takes the next payment export.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Order value by postcode

payments_october.csv
Postcodes plotted
20
Orders
331
Order value
£272,570
UK · size is count, colour is value
Selected district
N1 9ZZ
£42,800
Canal quarter
36 orders 51.53, -0.10

Highest spend on the export. Cloth quarter is larger because it has more orders, not a higher total.

Order value
True spend colours
How to read the map
Colour is order value
Lower Higher
Size is order count
Few Some Many

Load a payment export

1. Export
Click to load the October payment export

Columns used: postcode and order total. Totals are capped and rounded before the count.

2. Plot
Load an export to start
  1. Read the export
  2. Cap and round
  3. Count repeats
  4. Coordinate lookup
  5. Draw circles

District rollup

Orders by band
All 20 postcodes
PostcodeDistrictOrdersValueCoordinates
IV2 3ZZNess edge4£2,10057.46, -4.18
AB11 4ZZHarbour ward12£8,42057.14, -2.09
KY1 1ZZLang quay3£1,80056.12, -3.16
EH3 8ZZRidge18£22,10055.95, -3.20
G2 5ZZMerchant walk22£15,60055.86, -4.25
NE1 7ZZEast quay15£9,80054.97, -1.61
LS1 3ZZCity basin28£31,20053.80, -1.55
M1 5ZZCloth quarter41£27,45053.48, -2.24
L1 8ZZDock quarter19£11,30053.40, -2.98
NG1 5ZZLace edge21£13,40052.95, -1.15
B1 2ZZCanal works33£19,80052.48, -1.90
NR1 3ZZReed bank6£3,40052.63, 1.29
CB2 1ZZFen side8£9,10052.20, 0.13
OX1 3ZZCollege end9£18,70051.75, -1.26
CF10 4ZZBay quarter11£6,40051.48, -3.18
BS1 6ZZCut basin16£14,20051.45, -2.58
N1 9ZZCanal quarter36£42,80051.53, -0.10
SO14 2ZZTide dock10£5,20050.90, -1.40
BN1 4ZZSea lane14£7,60050.83, -0.14
PL1 1ZZSound5£2,20050.37, -4.14

How it works

  1. Read the payment export of postcode and total, limit extreme values and round the amounts.
  2. Count repeats of the same postcode.
  3. Match each postcode to a map position from a local list.
  4. Draw a circle on Google Maps, coloured by value and sized by count.
  5. Show the district total, the order count and the map position when a circle is clicked.

Pipeline

flowchart LR
  Pay[Payment export] --> Unique[Unique postcodes]
  Unique --> Lookup[Coordinate table]
  Lookup --> Circles[Circles on Google Maps]
  Circles --> Size[Size by order count]
  Circles --> Hue[Colour by value]
  Circles --> Detail[Click for the district total]