Retail Distribution and Logistics Management

Начало на работния поток/процеса.

Fetch all entries from the 'Orders' data model where status is 'Pending'.

Retrieve current stock quantities from the 'Inventory' data model for specific SKUs.

Sum the unit price multiplied by quantity for all line items in an order entry.

Calculate the difference between the 'Order Date' and the 'Expected Delivery Date'.

Decrement the 'Available Quantity' in the Inventory data model after an order is processed.

Change the status of an Order entry from 'Processing' to 'Shipped'.

Create a task for the Warehouse Manager to begin the picking process for a specific order.

Create a task for the QC Specialist to verify items before packaging.

Create a task for the Logistics Clerk to print and attach labels to outgoing parcels.

Create a new entry in the 'Shipments' data model once items leave the warehouse.

Create a new entry in the 'Returns' data model when a customer initiates a claim.

Sum the 'Total Value' property of all items in the Inventory data model.

Calculate the average duration of completed shipments to monitor carrier performance.

Send an automated email to the customer's email address with tracking information.

Send an email to the Procurement Team when inventory falls below the reorder point.

Send an SMS to the delivery driver containing the pickup location and time.

Generate a report summarizing total orders processed, shipped, and cancelled in the last 24 hours.

Delete specific line-item entries from an order if they are no longer available in stock.

Край на работния поток/процеса.