Customer file order · Sterling Guard London
SO-52367
PickingCustomer file SGS-68583.csv from Sterling Guard Security’s own system on Tue 3 Nov at 07:38, read and mapped to the Contract Master in 7 s. For Tue 10 Nov by DPD next day. Owner Hannah Price. Sterling Guard Security, security, price band A, 5 contract lines.
Website
Portal
Customer file
SGS-68583.csv, mapped in 7 s
Phone or email
Net, ex VAT
£821.10
£985.32 inc VAT
Margin
39.0%
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 |
|---|---|---|---|---|---|
B45 Beechfield Beanie, Black SGS45BLK · plain B45-BLK · One size · Contract Master | 11 | £5.95 | Contract Master | 47.9% ✓ | £65.45 |
SizeOne sizeTotal Ordered1111 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 | 8 | £5.95 | Contract Master | 43.7% ✓ | £47.60 |
SizeS/ML/XL2XL/3XL4XL/5XLTotal Ordered33208 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 | 13 | £25.95 | Contract Master | 37.4% ✓ | £337.35 |
SizeSMLXL2XL3XLTotal Ordered24421013 Blanks free1202442561463810814 On hand16132034019459101084 DecorationSGS331BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) | |||||
TRA620 Regatta Fleece, Black SGS620BLK · plain TRA620-BLK · Sizes S to 3XL · Contract Master | 14 | £17.95 | Contract Master | 42.1% ✓ | £251.30 |
SizeSMLXL2XL3XLTotal Ordered24431014 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK on PO-3331, lands Tue 10 Nov | |||||
UC101 Uneek Classic Polo, Black SGS101BLK · plain UC101-BLK · Sizes XS to 4XL · Contract Master | 12 | £9.95 | Contract Master | 30.2% ✓ | £119.40 |
SizeXSSMLXL2XL3XL4XLTotal Ordered0234210012 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£821.10
Delivery, DPD next dayFree
Net, ex VAT£821.10
VAT at 20%£164.22
Total£985.32
Free delivery over £100 ex VAT.
Margin 39.0% 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-68583
Tue 3 Nov 07:38
SGS-68583.csv1 file, 5 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | SGS45BLK | BLACK | One size:11 | 11 |
| 3 | SGSPWVESTYLW | YELLOW | S/M:3 L/XL:3 2XL/3XL:2 | 8 |
| 4 | SGS331BLK | BLACK | S:2 M:4 L:4 XL:2 2XL:1 | 13 |
| 5 | SGS620BLK | BLACK | S:2 M:4 L:4 XL:3 2XL:1 | 14 |
| 6 | SGS101BLK | BLACK | S:2 M:3 L:4 XL:2 2XL:1 | 12 |
How it was mapped
- SGS45BLK x One size 1111 x B45-BLK
- SGSPWVESTYLW x S/M 3, L/XL 3, 2XL/3XL 28 x PWVEST-YLW
- SGS331BLK x S 2, M 4, L 4, XL 2, 2XL 113 x R331-BLK
- SGS620BLK x S 2, M 4, L 4, XL 3, 2XL 114 x TRA620-BLK
- SGS101BLK x S 2, M 3, L 4, XL 2, 2XL 112 x UC101-BLK
Read and mapped in 7 s: their codes to Contract Master lines, their rows into size grids.
Delivery
DPD dispatch →DPD
DPD Next Day
Collected 16:30 Mon 9 Nov
DPD Next DayDPD
1550 0002 0422 71
Sterling Guard London, Sterling Guard Security
FAO Marcus Hale
London, EC1
Weight17.6 kg, 58 garments
LabelPrints 15:00 Mon 9 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.
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-68583.csv received
Customer · Tue 3 Nov 07:38
Read in 7 s: 5 of 5 lines matched to Contract Master lines with sizes
Auto · Tue 3 Nov 07:39
Priced at Sterling Guard Security’s own rates: 5 from the Contract Master
Auto · Tue 3 Nov 07:39
Stock checked by size: every line available or due in next day
Auto · Tue 3 Nov 07:39
Credit checked: within the £125,750 limit
Auto · Tue 3 Nov 07:39
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Tue 3 Nov 07:39
Production lots done on the tablet; booked back in and the pick slip released
Dev · Fri 6 Nov 15:20
On pick slip PS-52367, released to Tom
Auto · Today 09:30