Customer file order · Sterling Guard London
SO-52352
With DPDCustomer file SGS-58293.csv from Sterling Guard Security’s own system on Mon 2 Nov at 14:02, read and mapped to the Contract Master in 5 s. For Mon 9 Nov by DPD next day. Owner Hannah Price. Sterling Guard Security, security, price band A, 5 contract lines.
Website
Portal
Customer file
SGS-58293.csv, mapped in 5 s
Phone or email
Net, ex VAT
£699.45
£839.34 inc VAT
Margin
39.6%
GP floor 26% a line
Lines at Sterling Guard Security’s own prices
Contract price first, then any promotion, then their band; GP (profit / sell price) flagged when under 26%
| Product | Qty | Price | Source | Margin | Line |
|---|---|---|---|---|---|
TRA620 Regatta Fleece, Black SGS620BLK · plain TRA620-BLK · Sizes S to 3XL · Contract Master | 11 | £17.95 | Contract Master | 42.1% ✓ | £197.45 |
SizeSMLXL2XL3XLTotal Ordered23321011 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK on PO-3331, lands Tue 10 Nov | |||||
B45 Beechfield Beanie, Black SGS45BLK · plain B45-BLK · One size · Contract Master | 9 | £5.95 | Contract Master | 47.9% ✓ | £53.55 |
SizeOne sizeTotal Ordered99 Blanks free330330 On hand562562 DecorationSGS45BLK: front embroidery (STERLING GUARD) | |||||
PWVEST Portwest Hi-vis Vest, Yellow SGSPWVESTYLW · plain PWVEST-YLW · Sizes S/M to 4XL/5XL · Contract Master | 13 | £5.95 | Contract Master | 43.7% ✓ | £77.35 |
SizeS/ML/XL2XL/3XL4XL/5XLTotal Ordered453113 Blanks free7485016175 On hand174198239413 DecorationSGSPWVESTYLW: back print (SECURITY) Blanks PWVEST-YLW on PO-3331, lands Tue 10 Nov | |||||
R331 Result Softshell Jacket, Black SGS331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master | 12 | £25.95 | Contract Master | 37.4% ✓ | £311.40 |
SizeSMLXL2XL3XLTotal Ordered23421012 Blanks free1202442561463810814 On hand16132034019459101084 DecorationSGS331BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) | |||||
UC101 Uneek Classic Polo, Black SGS101BLK · plain UC101-BLK · Sizes XS to 4XL · Contract Master | 6 | £9.95 | Contract Master | 30.2% ✓ | £59.70 |
SizeXSSMLXL2XL3XL4XLTotal Ordered012210006 Blanks free1619353217540128 On hand1968136145822540479 DecorationSGS101BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) Blanks UC101-BLK on PO-3330, lands Tue 10 Nov | |||||
Goods, ex VAT£699.45
Delivery, DPD next dayFree
Net, ex VAT£699.45
VAT at 20%£139.89
Total£839.34
Free delivery over £100 ex VAT.
Margin 39.6% 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
5 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
£79,301 of the £125,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 retypingFromPurchasing, Sterling Guard Security
Toinfo@cwear.co.uk
SubjectOrder file SGS-58293
2 Nov 14:02
SGS-58293.csv1 file, 5 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | SGS620BLK | BLACK | S:2 M:3 L:3 XL:2 2XL:1 | 11 |
| 3 | SGS45BLK | BLACK | One size:9 | 9 |
| 4 | SGSPWVESTYLW | YELLOW | S/M:4 L/XL:5 2XL/3XL:3 4XL/5XL:1 | 13 |
| 5 | SGS331BLK | BLACK | S:2 M:3 L:4 XL:2 2XL:1 | 12 |
| 6 | SGS101BLK | BLACK | S:1 M:2 L:2 XL:1 | 6 |
How it was mapped
- SGS620BLK x S 2, M 3, L 3, XL 2, 2XL 111 x TRA620-BLK
- SGS45BLK x One size 99 x B45-BLK
- SGSPWVESTYLW x S/M 4, L/XL 5, 2XL/3XL 3, 4XL/5XL 113 x PWVEST-YLW
- SGS331BLK x S 2, M 3, L 4, XL 2, 2XL 112 x R331-BLK
- SGS101BLK x S 1, M 2, L 2, XL 16 x UC101-BLK
Read and mapped in 5 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD dispatch →DPD
DPD Next Day
Collected 16:30 Fri 6 Nov
DeliveryMon 9 Nov, Sterling Guard London
AddressLondon EC1
DPD windowdue about 11:51
DPD Next DayDPD
1550 0002 0407 54
Sterling Guard London, Sterling Guard Security
FAO Marcus Hale
London, EC1
Weight15.5 kg, 51 garments
LabelWith DPD
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.
Invoice
Invoicing →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
SGSterling Guard Security
C-1005 · Security · 4 sites · since 2015
PricesBand A, 15% off list, 5 contract lines
Terms30 days end of month
Credit£79,301 of £125,750
Orders byCustomer file
Short stockpart-ship and back-order
RepHannah Price
Other orders from Sterling Guard Security
SO-52580
Today · Sterling Guard London
£431.85
Confirmed
SO-52572
Today · Sterling Guard Manchester
£601.70
Confirmed
SO-52554
Today · Sterling Guard Birmingham
£212.45
Confirmed
SO-52549
Today · Sterling Guard London
£480.35
Confirmed
SO-52481
Thu 5 Nov · Sterling Guard London
£546.30
In production
Audit trail
Customer file SGS-58293.csv received
Customer · 2 Nov 14:02
Read in 5 s: 5 of 5 lines matched to Contract Master lines with sizes
Auto · 2 Nov 14:03
Priced at Sterling Guard Security’s own rates: 5 from the Contract Master
Auto · 2 Nov 14:03
Stock checked by size: every line available or due in next day
Auto · 2 Nov 14:03
Credit checked: within the £125,750 limit
Auto · 2 Nov 14:03
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · 2 Nov 14:03
Production lots done on the tablet; booked back in and the pick slip released
Dev · Thu 5 Nov 15:20
Picked and packed, checked by size against the pick slip
Tom · Fri 6 Nov 14:10
Collected by DPD at 16:30; DPD label and tracking emailed to Marcus
DPD · Fri 6 Nov 16:30
Plan: DPD one-hour window from about this time
Planned · Today 11:51