Sample data
Customer file order · Hallmark Facilities

SO-52552

ConfirmedNo-subject email, caught
Customer file HMF-004471.csv from Hallmark Facilities’ own system today at 07:58, read and mapped to the Contract Master in 5 s. For Mon 16 Nov by DPD next day once decorated. Owner Hannah Price. Hallmark Facilities, corporate and services, price band B, 4 contract lines.
Website
Portal
Customer file
HMF-004471.csv, mapped in 5 s
Phone or email
Net, ex VAT
£259.30
£311.16 inc VAT
Margin
38.3%
GP floor 26% a line
Hallmark Facilities
About this order
Forwarded at 07:58 with no subject line and only a CSV attached: the kind of email that used to sit unread until someone noticed. Read in 5 seconds and on the board by 07:59.
Lines at Hallmark Facilities’ own prices
Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%
Price lists →
ProductQtyPriceSourceMarginLine
R331 Result Softshell Jacket, Black
HMF331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master
4£19.95
£20.00
Contract Master29.8% ✓£79.80
SizeSMLXL2XL3XLTotal
Ordered1111004
Blanks free1202442561463810814
On hand16132034019459101084
DecorationHMF331BLK: left chest embroidery (HALLMARK FACILITIES)
TRA620 Regatta Fleece, Navy
HMF620NAV · plain TRA620-NAV · Sizes S to 3XL · Contract Master
10£17.95Contract Master42.1% ✓£179.50
SizeSMLXL2XL3XLTotal
Ordered13321010
Blanks free45530118
On hand112123134173
DecorationHMF620NAV: left chest embroidery (HALLMARK FACILITIES)
Blanks TRA620-NAV on PO-3331, lands Tue 10 Nov
Goods, ex VAT£259.30
Delivery, DPD next dayFree
Net, ex VAT£259.30
VAT at 20%£51.86
Total£311.16
Free delivery over £100 ex VAT.
Margin 38.3% on the order; no line under the 26% GP floor.
Checked as it landed
price, stock and credit, before anyone touched it
£price
Priced at their rate
2 from the Contract Master. Contract Master prices as agreed; plain lines clear the 26% GP floor.
▦stock
Stock kept by size
Every size was available or due in next day, and kept for this order as it was read.
✓credit
Within the limit
£3,809 of the £5,750 limit in use with this order.
As it arrived
CSV from the customer’s own ordering app or buying system; their codes mapped to Contract Master lines, no retyping
FromFiona Rhodes, Hallmark Facilities
Toinfo@cwear.co.uk
Subject(no subject)
Today 07:58
HMF-004471.csv1 file, 2 rows
ABCD
1CODECOLOURSIZESQTY
2HMF331BLKBLACKS:1 M:1 L:1 XL:14
3HMF620NAVNAVYS:1 M:3 L:3 XL:2 2XL:110
How it was mapped
  1. HMF331BLK x S 1, M 1, L 1, XL 14 x R331-BLK
  2. HMF620NAV x S 1, M 3, L 3, XL 2, 2XL 110 x TRA620-NAV
Read and mapped in 5 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD
DPD Next Day
Collected 16:30 Fri 13 Nov
DeliveryMon 16 Nov
AddressSolihull B91
DPD Next DayDPD
1550 0002 0491 53
Hallmark Facilities
FAO Fiona Rhodes
Solihull, B91
Weight4.4 kg, 14 garments
LabelPrints 15:00 Fri 13 Nov
One DPD consignment per delivery address a day: orders for the same address that day go under one label. DPD collects at 16:30 the working day before delivery and sends the proof of delivery back onto the order.
Not yet. Once it is signed for, the invoice is made from the delivered quantities and sent to Xero at 18:00 that evening. Nobody re-types it.
Customer
HF
Hallmark Facilities
C-1021 · Corporate and services · Solihull · since 2021
PricesBand B, 10% off list, 4 contract lines
Terms30 days end of month
Credit£3,809 of £5,750
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Audit trail
Customer file HMF-004471.csv received
Customer · Today 07:58
Read in 5 s: 2 of 2 lines matched to Contract Master lines with sizes
Auto · Today 07:59
Priced at Hallmark Facilities’ own rates: 2 from the Contract Master
Auto · Today 07:59
Stock checked by size: every line available or due in next day
Auto · Today 07:59
Credit checked: within the £5,750 limit
Auto · Today 07:59
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Today 07:59
Next: lots done, pick slip released, collected by DPD Fri 13 Nov
Planned · Thu 12 Nov 15:00