Order errors

[Former user]

Customer name: issue

WT= wrong order total WQ= Wrong quantity

1 .Marks : WT,WQ (should be 1) 2. Thorpe: WT 3. Taylor: WQ appears 2x in system as same job older date (22 May) is the correct one 4. Pitts: appears as 3x 0 items 5. Shields: WT 6. Hibberd: WT 7. Andrews: WT 8. Laughlin: WT 9. Aldridge 3 May: WT, WQ (should be 1x) 10. Aldridge 24 June: WT 11. Ling: WT 12. Kerridge: WT 13. Benton: WT 14. Wickers: WT 15. Cracknell: WT 16. Naden: WT 17. Roche: WT 18. Harries: WQ 19. 'A valued customer' (2 May) ? nothing there 20. Outram: WQ 21. McDonald: WT 22. LeCheminant (23 April): WQ should be 1 23. Low: WT 24. Wadley (10 April): WT, WQ should be 1 25. Cook (14 April): WT 26. Leadbeater: WT 27. Kerin (8 April)): doubled up 28. Ridgeway (8 April): WQ should be 1 29. Calver: triple job , two are 0 should be just 1 30. Reid(15 April): Eternity ring WQ, should be 1, WT 31 Reid (15 April): Yellow gold ring WQ should be 1 32 Clague (14 March) WQ should be 1

[Simon Martin]

Updated the orders directly in the database. This has corrected the data, but unclear at this stage whether the root cause is still present. Have asked Julia to keep an eye on this and let me know of any new occurrences.

[Simon Martin]

Hi Julia,

I have updated the order table directly in the database and cleaned up the orders you've identified below. Some were really strange and I can't understand what could have caused them to be as wrong as they were. If it's ok can you keep an eye on this and let me know if any more happen. My suspicion is that the root of the problem is that "The Box" gets confused, well that theory explains the duplicate entries. So I'm thinking that somehow it's hanging on to a old order.

Kind regards,Simon