Table Order and Order Item. Relation order id. When Order Status change it automatically update all Order Item Status and also in case of Order progress.
Status has three option 1-Pending, 2-Complete, 3-Cancel.
Progress has four option 1-Placed, 2-Despatched, 3-Delivered 4-cancel.
Specific users can use the order progress task. Marketing staff can place the order and after order place auto update the status to pending. Order goes to despatch staff view .Despatch staff can only despached and Delivered the order. After Order delivered auto updated status to complete. Once order Despatch then it never edited or add any item in it. Cancel the order is only the task made by user who place the order. In marketing staff view despached and Delivered option not show . Similarly in despach view placed and order cancel option not show.
Manager staff view all options.
LinkedIn
Twitter
