Inventory reports help you monitor stock levels, track fulfillment performance, analyze product profitability, and prevent stockouts or overstock situations. This guide covers all 10 inventory reports available in Pulse Commerce, explaining what each report does, when to use it, and the key business decisions it supports.
Current Inventory Status Report
Navigation: Reports > Current Inventory Status
Report Type: Simple (Real-Time)
The Current Inventory Status report provides a comprehensive, real-time snapshot of inventory levels and stock status across all warehouse locations and fulfillment centers. This report displays detailed quantity information, reorder triggers, and inventory valuation data to give merchants complete visibility into their stock position for every SKU in their system.
Key columns: SKU, Qty. Available, Qty. On Hand, Qty. On Order, Qty. Committed, Qty. Backordered, Re-Order Point, To Order, Location Name, Bin Number, Preferred Location, Preferred Vendor, Cost, Value of Inventory
When to Use This Report
- Prevent stockouts and overstock - Monitor quantities against reorder points
- Optimize inventory distribution - Balance stock across warehouse locations
- Manage cash flow - Understand capital tied up in inventory
- Coordinate procurement - Track purchase orders and vendor relationships
- Handle customer demand - Monitor committed and backordered quantities
- Streamline warehouse operations - Optimize picking routes using bin numbers
Shipment Projection Report
Navigation: Reports > Shipment Projection
Report Type: Simple (Real-Time)
The Shipment Projection report provides a forward-looking view of inventory levels by showing current stock quantities alongside projected inventory positions for specific dates in the future. This inventory forecasting tool helps merchants anticipate stock levels and potential shortages across their product catalog over the coming days.
Key columns: SKU, Quantity On Hand, Projected Quantity (by selected future date)
When to Use This Report
- Prevent stockouts before they happen - Anticipate inventory shortages days in advance
- Plan replenishment timing - Determine when to place supplier orders
- Coordinate marketing campaigns - Verify stock before launching promotions
- Optimize fulfillment operations - Identify products needing expedited shipments
- Manage seasonal fluctuations - Track projections during peak selling periods
- Support customer service - Proactively communicate potential backorders
Items Backordered (Simple) Report
Navigation: Reports > Items Backordered (Simple)
Report Type: Simple (Real-Time)
The Items Backordered (Simple) report provides a comprehensive view of all items currently on backorder across the business, showing which products customers have ordered but cannot be immediately fulfilled due to insufficient inventory. It displays backorder details at both the individual order level and aggregated SKU level.
Key columns: SKU, Product Name, Sales Order #, Customer Name, Qty. Ordered, Qty. Fulfilled, Qty. Backordered, Qty. On Order, Qty. In Transfer
When to Use This Report
- Prioritize inventory replenishment - Identify which SKUs need immediate restocking
- Manage customer expectations - Track specific orders waiting for backordered items
- Analyze fulfillment performance - Identify patterns in inventory shortages
- Monitor supplier performance - Track pending purchase orders for backordered items
- Optimize inventory allocation - Review inter-warehouse transfers that could resolve backorders
- Identify high-demand products - Spot items consistently on backorder
Items BackOrdered (Advanced) Report
Navigation: Reports > Items BackOrdered (Advanced)
Report Type: Advanced (Updated every 24 hours)
The Items BackOrdered (Advanced) report provides merchants with a comprehensive view of all items currently on backorder, showing which products cannot be immediately fulfilled due to insufficient inventory. This report tracks the gap between customer demand and available stock across all warehouse locations with full customization capabilities.
Key columns: SKU, Product Name, Sales Order #, Customer Name, Warehouse Location, Qty. Ordered, Qty. Fulfilled, Qty. Back Ordered
When to Use This Report
- Identify fulfillment bottlenecks - Track which SKUs and locations have highest backorders
- Monitor customer impact - Review specific orders affected by backorders
- Optimize inventory allocation - Analyze distribution imbalances across locations
- Prioritize purchase orders - Identify products with consistent backorder patterns
- Track fulfillment progress - Monitor how backorder quantities change over time
- Manage customer expectations - Enable proactive communication about delays
Items Pending Fulfillment (Simple) Report
Navigation: Reports > Items Pending Fulfillment (Simple)
Report Type: Simple (Real-Time)
The Items Pending Fulfillment (Simple) report provides visibility into orders that have been placed but not yet fully shipped or delivered to customers. It shows the gap between what customers ordered versus what has been fulfilled and committed for shipment.
Key columns: SKU, Product Name, Sales Order #, Customer Name, Warehouse Location, Qty. Ordered, Qty. Fulfilled, Qty. Committed
When to Use This Report
- Identify fulfillment bottlenecks - Spot delays and prioritize shipments
- Monitor inventory allocation - Ensure proper inventory is reserved
- Prioritize customer communications - Contact customers about delayed shipments
- Optimize warehouse operations - Identify which locations have highest pending volume
- Prevent stockouts - Identify high-demand products with fulfillment gaps
- Measure fulfillment performance - Track how quickly orders move through the pipeline
Items Pending Fulfillment (Advanced) Report
Navigation: Reports > Items Pending Fulfillment (Advanced)
Report Type: Advanced (Updated every 24 hours)
The Items Pending Fulfillment (Advanced) report provides real-time visibility into all customer orders that have been placed but not yet completely shipped across all warehouse locations. This report tracks the fulfillment pipeline by showing ordered quantities versus what has been fulfilled, committed, or backordered.
Key columns: SKU, Product Name, Sale Order #, Customer Name, Warehouse Location, Qty. Ordered, Qty. Fulfilled, Qty. Committed, Qty. Back Ordered
When to Use This Report
- Monitor fulfillment performance - Track warehouse processing efficiency
- Identify allocation issues - Spot products reserved but not yet shipped
- Manage backorder situations - Track quantities by SKU and location
- Optimize warehouse operations - Balance workloads across facilities
- Prioritize customer service - Identify high-value or time-sensitive orders
- Analyze product-level patterns - Identify items with chronic fulfillment delays
Inventory Profitability Report
Navigation: Reports > Inventory - Profitability
Report Type: Advanced (Updated every 24 hours)
The Inventory Profitability report provides comprehensive financial performance analysis for individual SKUs, combining sales metrics with cost and profit data to evaluate which products are driving the most value for the business. This report enables merchants to assess product-level profitability across their entire inventory while tracking key operational metrics like availability and sales velocity.
Key columns: SKU, Product Name, Items Sold, Qty. Avail, Gross Sales, Cost, Gross Profit, Gross Profit %, Preferred Vendor, Mfg. Name, Product Category, Product Type, Preferred Location
When to Use This Report
- Identify top-performing products - Focus marketing on most profitable SKUs
- Optimize inventory allocation - Increase stock for high-profit products
- Make product mix decisions - Consider discontinuation or pricing adjustments
- Streamline vendor relationships - Negotiate better terms for profitable products
- Improve category management - Identify which segments deserve investment
- Optimize warehouse operations - Position high-value SKUs strategically
Shipped Item SKU Summary Report
Navigation: Reports > Shipped Item SKU Summary
Report Type: Advanced (Updated every 24 hours)
The Shipped Item SKU Summary report provides merchants with a comprehensive view of product-level sales performance by tracking which SKUs have been shipped to customers and their associated sales volumes. This inventory-focused report combines quantity and revenue data to help retailers understand their actual fulfilled demand patterns and product performance metrics.
Key columns: SKU, Item Name, Qty. Sold, Gross Sales
When to Use This Report
- Identify top-performing products - Determine which SKUs drive volume and revenue
- Optimize inventory planning - Understand actual customer demand patterns
- Analyze product profitability - Compare gross sales against quantities moved
- Support merchandising strategies - Identify products to promote or discontinue
- Monitor fulfillment accuracy - Track what was actually shipped vs ordered
- Generate performance reports - Demonstrate product success to stakeholders
Shipped Bundle SKU Summary Report
Navigation: Reports > Shipped Bundle SKU Summary
Report Type: Advanced (Updated every 24 hours)
The Shipped Bundle SKU Summary report provides comprehensive performance analytics for bundle products that have been shipped to customers. This report tracks sales volume and revenue data for each bundle SKU, enabling merchants to analyze which product bundles are performing well and generating the most revenue over specified time periods.
Key columns: Bundle Name, Qty. Sold, Gross Sales
When to Use This Report
- Evaluate bundle profitability - Identify top-performing product combinations
- Optimize inventory planning - Forecast demand for bundle components
- Identify underperforming bundles - Spot bundles needing discontinuation or pricing changes
- Track seasonal trends - Analyze bundle performance during specific periods
- Support pricing decisions - Calculate average selling prices by bundle
- Guide product development - Understand customer preferences for new bundles
Inventory Adjustments Report
Navigation: Reports > Inventory Adjustments
Report Type: Simple (Real-Time)
The Inventory Adjustments report provides a detailed audit trail of all manual inventory changes made to stock levels in the system. This report tracks when, why, and by whom inventory quantities were adjusted, giving merchants complete visibility into inventory modifications outside of normal sales and receiving processes.
Key columns: SKU, Product Name, Date, Created By, Reason, Change (quantity), Average Cost, Net (dollar value), Location
When to Use This Report
- Track inventory discrepancies - Monitor patterns of shrinkage, damage, or counting errors
- Audit inventory control - Review authorization and documentation of changes
- Analyze financial impact - Understand dollar impact of inventory corrections
- Investigate stock accuracy issues - Identify when and where problems occurred
- Monitor staff accountability - Track which team members make adjustments
- Reconcile inventory records - Document adjustments during physical counts
Video Tutorial: Item Sell Through Report
Essential Reading:
- Understanding Reports in Pulse Commerce - Report types, update frequencies, and export formats
- Working with Advanced Reports - Filtering, grouping, aggregating, and column management
- Creating Custom Reports - Save your customizations for recurring analysis
Other Report Guides:
- Purchase Order Reports Guide - Vendor performance, costs, and procurement analysis
- Returns Reports Guide - Return patterns, costs, and customer behavior