Customer file order · Sterling Guard London
SO-52366
PickingCustomer file SGS-67834.csv from Sterling Guard Security’s own system on Tue 3 Nov at 07:38, read and mapped to the Contract Master in 4 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-67834.csv, mapped in 4 s
Phone or email
Net, ex VAT
£684.05
£820.86 inc VAT
Margin
37.5%
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 | 13 | £17.95 | Contract Master | 42.1% ✓ | £233.35 |
SizeSMLXL2XL3XLTotal Ordered24421013 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK 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 | 14 | £9.95 | Contract Master | 30.2% ✓ | £139.30 |
SizeXSSMLXL2XL3XL4XLTotal Ordered1244210014 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£684.05
Delivery, DPD next dayFree
Net, ex VAT£684.05
VAT at 20%£136.81
Total£820.86
Free delivery over £100 ex VAT.
Margin 37.5% 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
3 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-67834
Tue 3 Nov 07:38
SGS-67834.csv1 file, 3 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | SGS620BLK | BLACK | S:2 M:4 L:4 XL:2 2XL:1 | 13 |
| 3 | SGS331BLK | BLACK | S:2 M:3 L:4 XL:2 2XL:1 | 12 |
| 4 | SGS101BLK | BLACK | XS:1 S:2 M:4 L:4 XL:2 2XL:1 | 14 |
How it was mapped
- SGS620BLK x S 2, M 4, L 4, XL 2, 2XL 113 x TRA620-BLK
- SGS331BLK x S 2, M 3, L 4, XL 2, 2XL 112 x R331-BLK
- SGS101BLK x XS 1, S 2, M 4, L 4, XL 2, 2XL 114 x UC101-BLK
Read and mapped in 4 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
Weight11.9 kg, 39 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-67834.csv received
Customer · Tue 3 Nov 07:38
Read in 4 s: 3 of 3 lines matched to Contract Master lines with sizes
Auto · Tue 3 Nov 07:39
Priced at Sterling Guard Security’s own rates: 3 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-52366, released to Tom
Auto · Today 09:30