Outbound Orders Report

The Outbound Orders Report provides a comprehensive view of each order processed and shipped from the warehouse. It includes essential details from order placement to shipment, allowing for efficient tracking and management.

Each field in the report contains specific information relevant to the order fulfillment process.

Report Fields

Order ID: A unique identifier assigned to each order, enabling easy tracking and referencing of specific orders in the system. For example, an Order ID might look like ORD123456 or AMZ987654.

Status: Indicates the current state of the order in the fulfillment process. Common statuses include 'COMPLETED,' 'PENDING,' and 'SHIPPED.'

Sub Status: Provides a more granular view of the order's status, indicating specific stages like 'PACKING_COMPLETED,' 'READY_FOR_PICKUP,' or 'IN_TRANSIT.' For example, PACKING_COMPLETED means the order has been packed and is ready for the next step.

Client: The name of the client or customer who placed the order. This helps in tracking orders based on customers and managing client-specific details. An example client might be John Doe or Acme Corp.

Warehouse: The specific warehouse where the order is being processed. This field helps identify the location handling the order, such as Warehouse A or Main Fulfillment Center.

Type: Indicates the category of the order, such as Shopify, B2B, or FBA (Fulfilled by Amazon). It helps distinguish between different sales channels. For example, an order type could be Ebay.

Reference: Any additional reference number or identifier associated with the order. This provides an extra layer of identification for cross-referencing. For example, a reference might be PO12345 or INV67890.

Carrier: The shipping company responsible for delivering the order, such as FedEx, DHL, or USPS. This is crucial for tracking shipments and handling carrier-specific inquiries.

Insurance Required: Indicates whether shipping insurance is required for the order. This is important for high-value shipments to ensure protection against loss or damage. Examples include Yes or No.

Carrier Service: The specific service level offered by the carrier, such as Next Day Air, Ground, or Standard Shipping. This determines the speed and type of delivery service selected.

Tracking Number: The tracking number assigned by the carrier for the shipment. This is used by customers and support teams to track the status of the shipment. Examples include 1Z9999999999999999 or 9400110898825022579493.

Email: The email address associated with the order for tracking notifications. This facilitates communication and tracking updates sent to the customer. For example, customer@example.com.

Tracking URL: The URL link to track the shipment online. This provides direct access to the carrier's tracking page for real-time updates.

Tracking Numbers: Additional tracking numbers if the order has multiple packages. This is useful for orders split into multiple shipments.

SKU (Stock Keeping Unit): A unique identifier for each product in the order, used for inventory management and product tracking. Examples include SKU12345 or PROD67890.

Order Line Item Quantity: The number of units for each line item in the order. This helps in verifying the quantity of each item ordered. For example, 2 for two units of a product.

Order Quantity: The total quantity of items in the order. This provides an overview of the total items shipped. For example, 5 for five items in total.

Order Value: The total monetary value of the order. This is important for financial tracking and reporting. Examples include 100.00 for $100.00 or 250.75 for $250.75.

Shipped Quantity: The number of items that have been shipped. This verifies the quantity shipped against the order quantity. For example, 3 if three items have been shipped.

Differential Quantity: The difference between the ordered quantity and the shipped quantity. This helps identify any discrepancies in the shipment. For example, 1 if one item is missing.

Additional Notes on Order IDs

Order IDs may repeat in the report because each line item within an order is listed separately.
For example, if an order contains multiple products or SKUs, each product will be listed as a separate line item with the same Order ID. This allows for detailed tracking of each individual product within a single order.

Example View of the Report

Here is an example of how the report might look: