Reports
Explore all the fulfillment reports that HotWax Commerce OMS offers out of the box to help monitor and track your fulfillment operations.
Explore all the fulfillment reports that HotWax Commerce OMS offers out of the box to help monitor and track your fulfillment operations. Putting all of these reports together, retailers can ensure that they're always shipping items on time.
Fulfillment Performance
Reports that help monitor orders that were shipped out.
Daily Warehouse Fulfillment Report
In the era of eCommerce growth, retail warehousing has become increasingly crucial to modern businesses. A fully functional warehouse gives the best output because of its low inventory carrying cost. As a result, the warehouse is responsible for fulfilling the majority of orders placed.
As warehouse operations are incredibly massive, there is always a possibility that some brokered orders can get misplaced or left unattended during the process. For merchants, evaluating warehouse performance and order fulfillment rates becomes crucial to success.
The Daily Warehouse Fulfillment Report provides all the orders brokered at the warehouse but not fulfilled yet. The report shows all the daily shipped and pending orders at a warehouse.
After identifying all the pending orders within this report, retailers can work to clear the backlog. Ultimately, this report helps to analyze the warehouse's fill rate. And in the case of multiple warehouses, it helps to compare their performance and give retailers actionable insights to improve their omnichannel order fulfillment strategy.
User
Vice President of Retail, Warehouse Fulfillment team
Report Glossary
| Item | Item Details |
|---|---|
Brand | The brand of the ordered product |
Warehouse | The warehouse of the order |
HC_Order_ID | The ID of order in HotWax Commerce |
HC_Order_Line_ID | The ID of order line items in HotWax Commerce |
UPC/SKU | The unique product code |
Item Description | The style, color, size of the item |
Shipping Preference | The preference of shipping selected by the customer |
Order Date | The date when the customer placed the order |
Order Time | The time when the customer placed the order |
Brokered Date | The date when the order is brokered to a fulfillment location |
Brokering Time | The time when the order was brokered |
Shopify Fulfillment Status Report
The Shopify Fulfillment Status Report offers retailers valuable insights into their order processing. It highlights the number of orders fulfilled and those still pending, aiding in the assessment of operational efficiency. Retailers can leverage reports from Hotwax to access historical data and current statistics, enabling them to track performance over time and promptly address any issues. It serves as a progress report for order fulfillment, ensuring smooth operations.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Hotwax Order ID | Unique identifier for the order in Hotwax system |
Shopify Order Name | Name or identifier associated with the order in Shopify system |
SKU | Stock Keeping Unit, a unique code assigned to each product |
Facility Name | Name of the facility where inventory is stored |
Item Status | Status of the item (e.g., available, out of stock, backordered) |
Hotwax Shipment Status | Status of the shipment in Hotwax |
Hotwax Fulfillment Time | Time taken to fulfill the order in Hotwax |
Created Time | Time when the order was created |
Shopify Fulfillment ID | Unique identifier for the fulfillment process in Shopify system |
Shopify Fulfillment Status | Status of the fulfillment process in Shopify system |
Shopify Fulfillment Entry Time | Time when the fulfillment process was initiated in the Shopify system |
Store Daily Orders Fulfillment Report
The Store Daily Orders Fulfillment Report empowers retailers to monitor the efficiency and effectiveness of their store operations. By tracking the daily number of orders fulfilled per store, retailers can identify trends and patterns, facilitating individual store performance assessments. This insight aids in recognizing top-performing stores and pinpointing areas for improvement in underperforming ones. With Store Daily Orders Fulfillment Reports, retailers can optimize store operations, enhance customer satisfaction, and ultimately drive revenue growth.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Store | Store Name |
Count | Count of orders fulfilled in a store |
Daily Store Shipment Performance Report
Merchants measure their stores’ omnichannel order fulfillment rates and want a clear, accurate view of their daily shipping performance. Therefore, merchants seek a detailed storewide report that displays every store’s daily shipping performance.
The Daily Store Shipment Performance Report shows the number of daily shipped orders for each store, giving an overview of the store’s daily performance.
This performance report also yields valuable insight into the most active and least active stores within a set timeframe. With this data, retailers can work with underperforming stores to understand the reason for low activity, identify the cause of underperformance, and resolve the issue.
Similarly, the retailer wants to see product-level shipping performance. The report also includes product-level performance. This information helps retailers understand a newly launched product's performance in a given area or region. Retailers can plan their inventory accordingly after knowing which products perform best at a given store.
User
Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Store | The fulfillment store location of the retailer |
Shipped Units | The number of orders shipped from a store |
UPC/SKU | The unique product code |
Style | The category of the product/item |
Color | The color of the product |
Size | The size of the product |
Units | The units shipped of the product |
Store Dashboard
Omnichannel retailers use stores as their order fulfillment locations. Fulfillment centers help merchants meet customer expectations of faster delivery. Merchants often operate multiple stores in various locations within their operational area so they need a reliable way to measure their fulfillment performance.
Many reasons contribute to stores delaying and rejecting orders, including low operational strength and inventory shortages. Customer order cancellations are also common. Tracking store fulfillment performance enables retailers to identify and resolve these order fulfillment issues.
Likewise, merchants prefer to keep a company-wide order fulfillment goal for daily processed, shipped, rejected, and canceled orders. Any facility performing below the set goal raises a concern for merchants and puts their focus on improving the performance of these facilities.
The Store Dashboard shows the storewide data where the orders were brokered, rejected, canceled, and then fulfilled in a day.
The report shows the percentage of shipped, processed, and canceled orders of the stores. Retailers can compare the actual fulfillment performance against the set goal to assess the performance of each store.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Order ID | The ID of order in HotWax Commerce |
Shopify ID | The ID of order in Shopify |
Import Date | The date when the order was imported |
Confirm Date | The date when the order found inventory |
Item Description | The style, color, size of the item |
UPC/SKU | The unique product code |
Customer Name | The name of the customer |
Status | The status of order pick up |
Store | The store which customer chose |
Brokered Date | The date when the order is brokered |
Pickup Date | The date when the order is picked up |
Canceled Date | The date when the order was canceled |
Shipping Method | The Shipping method by which order is |
Daily BOPIS Orders
Insider reports that 39% of consumers prefer using BOPIS when placing online orders because they get their orders faster. During their BOPIS journey, customers also expect prompt notifications from the brand on the status of their orders.
When customers can’t come to the store to pick up their orders, store managers need a detailed report on the unpicked BOPIS orders.
The Daily BOPIS Orders Report provides cumulative details of all the BOPIS orders of the last 30 days. This Shopify report also shows the status of these BOPIS orders if orders are picked up, canceled, or not picked up.
With this detailed report, store managers also look for long pending BOPIS orders. These orders keep the inventory blocked which can be used to fulfill other orders. With the knowledge of pending BOPIS orders, merchants can cancel all long-pending orders and use the inventory for new orders.
The report is essential to improve the BOPIS order fulfillment rate. Again, the fewer the unpicked orders, the better the order fill rate. Additionally, the problem diagnosis with the report helps retailers to clear the challenges in the omnichannel order fulfillment cycle.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Order ID | The ID of order in HotWax Commerce |
Shopify ID | The ID of order in Shopify |
Import Date | The date when the order was imported |
Confirm Date | The date when the order found inventory |
Item Description | The style, color, size of the item |
UPC/SKU | The unique product code |
Customer Name | The name of the customer |
Status | The status of order pick up |
Store | The store which customer chose |
Brokered Date | The date when the order is brokered |
Pickup Date | The date when the order is picked up |
Canceled Date | The date when the order was canceled |
Shipping Method | The Shipping method by which order is |
*** | |
## Customer support |
These reports help customer service representatives answer customer questions about their order
Shipment Tracking Report
Merchants use third-party services to ship orders to customers' addresses. Orders are picked, packed, and handed to third-party logistics (3PL) companies like FedEx and UPS. All shipments dispatched have their unique tracking ID. This tracking ID is provided by the 3PLs and helps customers keep track of their orders.
Because multiple shipments are sent out daily, merchants require a centralized view of order shipment details. This Shopify report helps merchants quickly identify an order's tracking ID, shipping address, and dispatch location.
The Shipment Tracking Report shows the daily shipment details for each order. Using this report, merchants can quickly resolve questions related to order tracking by finding the tracking ID and the shipping address for the order.
User
Fulfillment team
Report Glossary
| Item | Item Details |
|---|---|
Order ID | The ID of Order in Shopify |
Shipped Date | The date when order was shipped |
Fulfillment location code | The code of the fulfillment location |
Tracking Number | The tracking number of the shipped order |
Customer Address | The shipping address of the customer |
Carrier | The shipping carrier who shipped order |
Units | The number of units shipped in order |
Revenue | The revenue generated from the shipped order |
Problematic Orders
These reports help retailers find where orders are falling through the cracks and ensure that all orders are beign shipped out on time.
Daily Unfulfilled Expedited Orders
According to the State of Shipping Report, 62% of consumers expect their orders to arrive in less than three business days. To help expedite shipping, many brands have started implementing same-day/next-day delivery. That sounds like an easy fix, right?
Well, sometimes omnichannel order fulfillment teams can't fulfill same-day/next-day orders due to inventory discrepancies or other reasons. Orders go unfulfilled, which leads to increased order cancellations, poor customer service, and broken promises.
To provide a better customer experience, merchants have dedicated Customer Success Teams. The Customer Success Team wants to be on top of unfulfilled expedited delivery orders and continuously work on decreasing the order cancellation rate.
To effectively manage unfulfilled expedited orders, Customer Success Teams need a Daily Unfulfilled Expedited Orders Report. This report provides a granular view of all the unfulfilled same-day/next-day delivery orders. It also helps identify the order’s last brokered location with brokering time.
Furthermore, the report will help Customer Success Teams to evaluate the efficiency of their expedited shipping fulfillment process. Due to the large volume of expedited orders handled by an OMS daily, merchants prefer to have a daily report of all unfulfilled orders.
User
Head of eCommerce, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Order ID | The ID of order in HotWax Commerce |
Shopify ID | The ID of order in Shopify |
Order Date | The date when the customer placed the order |
Brokered Date | The date when the order is brokered to a fulfillment location |
Brokering Time | The time when the order was brokered |
Shipping | The preference of shipping selected by the customer |
Customer Name | The name of the customer |
UPC/SKU | The unique product code |
Style | The category of the product/item |
Color | The color of the product |
Size | The size of the product |
Store ID | The last brokered location of the order |
Daily Unfulfilled Orders
Merchants set benchmarks for fulfilling orders. Generally, merchants intend to complete order fulfillment within a seven-day maximum time frame. If any order’s fulfillment takes more than seven days, it draws a merchant’s attention.
To avoid order delays, merchants prefer to check all the pending orders at the facilities and alert fulfillment locations to speed up order fulfillment.
The Daily Unfulfilled Orders Report provides the data for all unfulfilled orders at different fulfillment locations. These can be standard, same-day/next-day delivery or store pick-up orders. The report also shows the last brokered facility and order brokered time which helps retailers analyze unfulfilled orders and mitigate challenges in the omnichannel order fulfillment pipeline.
User
Head of eCommerce, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
HC_Order_ID | The ID of order in HotWax Commerce |
Shopify ID | The ID of order in Shopify |
Location | The location of the order |
Item Description | The style, color, size of the item |
Style | The category of the product/item |
Color | The color of the item |
Size | The size of the item |
Brokered Date | The date when the order is brokered to a fulfillment location |
Brokering Time | The time when the order was brokered |
Order Rejection
Rejected Order Items Report
It is common for fulfillment locations to reject online orders due to various factors such as inventory discrepancies or fulfillment issues. However, minimizing these rejections holds importance for retailers striving to uphold customer satisfaction and streamline operations. HotWax Commerce recognizes this need and offers a report on rejected orders from multi-fulfillment locations.
This report serves as a crucial tool for retailers in their efforts to reduce rejection rates. By providing insights into rejection occurrences—including timing, locations, SKUs, and order IDs—it empowers users to identify patterns and root causes behind rejections. Armed with this information, retailers can take measures to optimize inventory management, streamline fulfillment processes, and enhance staff training.
Leveraging HotWax Commerce's rejection report enables users to make decisions aimed at improving overall operational efficiency. By understanding which items are rejected more frequently and in which locations, retailers can implement strategies to minimize rejections and ensure accurate, timely order fulfillment. Ultimately, this proactive approach not only enhances customer satisfaction but also strengthens the retailer's competitive edge in the market.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item details |
|---|---|
Shopify Order ID | Identifies the order within the Shopify platform |
Location | Indicates the location of the order fulfilment |
HC Order ID | HotWax Commerce Order ID for internal tracking |
Style | Specifies the style or type of the product |
demand | Reflects the demand or quantity ordered |
SKU | Stock Keeping Unit for inventory tracking |
Product Name | Name of the product ordered |
ATP | Indicates the quantity of the product available for shipment |
Safety Stock | Quantity of stock kept in reserve to meet unexpected demand |
Rejected Datetime | A timestamp indicating when the rejection occurred |
Reason | Specifies the reason for rejection |
Comments | Additional comments or notes regarding the rejection |
Store Rejections with Reasons
Rejection reason reports provide valuable insights into rejection rates and reasons across different facilities. These reports outline the number of rejections at each facility along with the underlying reasons behind them. This allows retailers to pinpoint facilities with higher rejection rates and take targeted actions to enhance their performance.
For example, if a store frequently experiences rejections due to items being out of stock, conducting cycle counts can help reconcile discrepancies between the system's available inventory and the physical stock in the store. Moreover, by identifying facilities where damaged items are more prevalent, retailers can streamline operations to mitigate such occurrences.
Ultimately, the aim of these reports is to pinpoint the location and frequency of rejections and implement measures to minimize them, thereby optimizing overall store performance.
User
Head of eCommerce, Head of Stores, Vice President of Retail
Report Glossary
| Item | Item Details |
|---|---|
Location | The physical location or facility from which an order item was rejected. |
Reason | The reason for the rejection of an order item. |
Shopify Order ID | A unique identifier for an order within the Shopify platform. |
HC Order ID | The order ID within the system, possibly a reference to internal order management. |
Style | The description of the style of the product. |
SKU | Stock Keeping Unit, a unique identifier for a product. |
Product Name | The name of the product associated with the order item. |
ATP | Available-to-Promise, indicating the available inventory of a product at a particular location. |
Rejected_Datetime | The date and time when an order item was rejected. |
NOT_FOUND | Inventory is not found in the facility |
CN_FL_EO | Entire order cannot be fulfilled from the facility |
REJ_RSN_DAMAGED | Order is rejected due to unavailable inventory |
NO_VARIANCE_LOG | Order rejected without any variance so inventory won't get affected. |
Last updated