Customer file order · Sterling Guard Glasgow
SO-52371
PickingCustomer file SGS-82277.csv from Sterling Guard Security’s own system on Tue 3 Nov at 08:10, 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-82277.csv, mapped in 4 s
Phone or email
Net, ex VAT
£683.65
£820.38 inc VAT
Margin
38.3%
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 | 6 | £5.95 | Contract Master | 47.9% ✓ | £35.70 |
SizeOne sizeTotal Ordered66 Blanks free330330 On hand562562 DecorationSGS45BLK: front embroidery (STERLING GUARD) | |||||
R331 Result Softshell Jacket, Black SGS331BLK · plain R331-BLK · Sizes S to 3XL · Contract Master | 14 | £25.95 | Contract Master | 37.4% ✓ | £363.30 |
SizeSMLXL2XL3XLTotal Ordered24431014 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 | 10 | £9.95 | Contract Master | 30.2% ✓ | £99.50 |
SizeXSSMLXL2XL3XL4XLTotal Ordered0133210010 Blanks free1619353217540128 On hand1968136145822540479 DecorationSGS101BLK: left chest embroidery (STERLING GUARD), back print (SECURITY) Blanks UC101-BLK on PO-3330, lands Tue 10 Nov | |||||
TRA620 Regatta Fleece, Black SGS620BLK · plain TRA620-BLK · Sizes S to 3XL · Contract Master | 7 | £17.95 | Contract Master | 42.1% ✓ | £125.65 |
SizeSMLXL2XL3XLTotal Ordered1221107 Blanks free133026171289 On hand35717543132239 DecorationSGS620BLK: left chest embroidery (STERLING GUARD) Blanks TRA620-BLK on PO-3331, lands Tue 10 Nov | |||||
PWVEST Portwest Hi-vis Vest, Yellow SGSPWVESTYLW · plain PWVEST-YLW · Sizes S/M to 4XL/5XL · Contract Master | 10 | £5.95 | Contract Master | 43.7% ✓ | £59.50 |
SizeS/ML/XL2XL/3XL4XL/5XLTotal Ordered342110 Blanks free7485016175 On hand174198239413 DecorationSGSPWVESTYLW: back print (SECURITY) Blanks PWVEST-YLW on PO-3331, lands Tue 10 Nov | |||||
Goods, ex VAT£683.65
Delivery, DPD next dayFree
Net, ex VAT£683.65
VAT at 20%£136.73
Total£820.38
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
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-82277
Tue 3 Nov 08:10
SGS-82277.csv1 file, 5 rows
| A | B | C | D | |
|---|---|---|---|---|
| 1 | CODE | COLOUR | SIZES | QTY |
| 2 | SGS45BLK | BLACK | One size:6 | 6 |
| 3 | SGS331BLK | BLACK | S:2 M:4 L:4 XL:3 2XL:1 | 14 |
| 4 | SGS101BLK | BLACK | S:1 M:3 L:3 XL:2 2XL:1 | 10 |
| 5 | SGS620BLK | BLACK | S:1 M:2 L:2 XL:1 2XL:1 | 7 |
| 6 | SGSPWVESTYLW | YELLOW | S/M:3 L/XL:4 2XL/3XL:2 4XL/5XL:1 | 10 |
How it was mapped
- SGS45BLK x One size 66 x B45-BLK
- SGS331BLK x S 2, M 4, L 4, XL 3, 2XL 114 x R331-BLK
- SGS101BLK x S 1, M 3, L 3, XL 2, 2XL 110 x UC101-BLK
- SGS620BLK x S 1, M 2, L 2, XL 1, 2XL 17 x TRA620-BLK
- SGSPWVESTYLW x S/M 3, L/XL 4, 2XL/3XL 2, 4XL/5XL 110 x PWVEST-YLW
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 0424 56
Sterling Guard Glasgow, Sterling Guard Security
FAO Marcus Hale
Glasgow, G1
Weight14.3 kg, 47 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-82277.csv received
Customer · Tue 3 Nov 08:10
Read in 4 s: 5 of 5 lines matched to Contract Master lines with sizes
Auto · Tue 3 Nov 08:11
Priced at Sterling Guard Security’s own rates: 5 from the Contract Master
Auto · Tue 3 Nov 08:11
Stock checked by size: every line available or due in next day
Auto · Tue 3 Nov 08:11
Credit checked: within the £125,750 limit
Auto · Tue 3 Nov 08:11
Blanks on the shelf, kept for this order by size; production lots ready for embroidery and print
Auto · Tue 3 Nov 08:11
Production lots done on the tablet; booked back in and the pick slip released
Dev · Fri 6 Nov 15:20
On pick slip PS-52371, released to Tom
Auto · Today 09:30