Frequently asked questions about Jetpack’s analytics reports, metrics interpretation, data exports, and reporting features.
Common questions about understanding and using Jetpack’s analytics and reporting features, including Velocity reports, Snapshot reports, OOS tracking, and metrics interpretation.
Different reports refresh on different schedules: Inventory Snapshot, Inventory Velocity, and Inventory Replenishment reports refresh daily in the mornings (UTC), while the Out of Stock with Exceptions report refreshes daily at 10:00 am UTC. The SKU forecasts and replenishment recommendations within the Inventory Replenishment Report refresh weekly on Monday mornings (UTC). Each report page displays the last refresh timestamp so you know how current the data is.
Can I see current day data in reports?
No, most reports don’t show data for the current day until the next refresh. This is because reports refresh daily in the mornings (UTC). Plan your reporting workflows accordingly if you need end-of-day snapshots.
How far back can I access historical data?
Most reports provide access to the last 12 months of data, allowing you to analyze year-over-year trends and seasonal patterns. The Inventory Replenishment Report provides access to the last 90 days of data.
Average Daily Velocity shows the average number of units sold per day for a given SKU. It’s calculated by dividing Total Quantity Sold by the Number of Days in your selected date range. For example, 100 units sold over 7 days equals 14.29 average daily velocity. Learn more in the Inventory Velocity Report documentation.
How is Estimated Days On Hand calculated?
Estimated Days On Hand estimates how many days your current inventory will last based on average daily velocity. It’s calculated by dividing Current Inventory On Hand by Average Daily Velocity. This metric helps you understand when to reorder inventory to prevent stockouts.
What's the difference between Start Count and End Count in the Snapshot report?
Start Count shows units available at the beginning of the day (which equals the previous day’s End Count), while End Count shows total on-hand units at the end of the day after all movements. The difference between these numbers reflects all inventory changes that occurred during that day.
What does Rebalance Point mean?
Rebalance Point is the recommended total units to have on-hand for orders, as calculated by Jetpack’s MultiHub IQ algorithm or overridden based on your input. It’s used to determine recommended replenishment quantities and helps optimize inventory distribution across fulfillment centers. Learn more about MultiHub IQ and rebalancing.
What is Fulfillable On Hand Quantity?
Fulfillable On Hand Quantity shows the quantity of a SKU currently available across all fulfillment centers, which includes units assigned to orders but not yet picked. This metric appears in multiple reports and reflects inventory status as shown on the Inventory Status page.
Why don't I see a SKU forecast for all products in my Product Catalog?
Products will only have a SKU forecast if more than 100 units of the product were shipped in D2C orders in the last 14 days. Additionally, after a product hasn’t shipped in 3 months, the SKU will be considered inactive in Jetpack’s forecasting model. The product will be considered active automatically once it has shipped 100 units in 14 days.
Why are there SKUs with forecast but not replenishment recommendations?
The Inventory Replenishment page will not provide replenishment recommendations if the product is not forecasted to have movement over the next 12 months, or if there is enough inventory on-hand and inbound (via WROs) to meet demand. Learn more in the Inventory Replenishment Report documentation.
How is the Recommended Replenishment Qty calculated?
Recommended Replenishment Qty is calculated by taking the product’s Fulfillable inventory, subtracting Incoming inventory, and adding 3 months of Jetpack’s projected demand forecast. This represents the total number of units you would need to have stored with Jetpack to meet a product’s Rebalance Point for 3 months. You can configure a different timeframe by contacting your Merchant Success Manager.
How is the Recommended Replenishment Date determined?
Recommended Replenishment Date is calculated as the date when Fulfillable inventory and Incoming inventory are less than the Rebalance Point, after subtracting the order-to-hub lead time (which is 21 days by default). This date indicates when you should order inventory to decrease the chance of stocking out. You can customize the order-to-hub lead time by contacting your Merchant Success Manager.
How soon will custom inputs be reflected in the Inventory Replenishment Report?
You will be able to review the Inventory Replenishment reports with your custom inputs (such as order lead time) the following Monday morning (CST) from when you provided the updated information, since SKU forecasts and replenishment recommendations refresh weekly.
What inventory movements does the Snapshot report track?
The Inventory Snapshot Report tracks 9 different inventory movement types: Received (units from completed WROs), In Transit (units traveling between FCs), Picked (units removed for orders), Internal Transfer (units transferred between FCs), Spot Check (inventory count adjustments), Restock (units returned to available inventory), and Inventory Merge (units added from merged product IDs). Each movement type is displayed in its own column for daily tracking.
What does the In Transit column show in the Snapshot report?
The In Transit column shows units currently traveling to a Jetpack fulfillment center, including internal transfers between fulfillment centers and MultiHub IQ distribution shipments. This helps you track inventory that’s in motion within your fulfillment network.
How do I track inventory across multiple fulfillment centers?
If you use MultiHub IQ or store inventory at multiple fulfillment centers, all reports break down data by location. The Inventory Snapshot Report shows separate rows for each fulfillment center, while the Velocity Report includes an “On-Hand Quantity across Fulfillment Centers” sub-report showing distribution details.
Orders enter the Exception status when they cannot be fulfilled due to issues like unavailable inventory. When a SKU is out of stock and an order requires that product, the order remains in Exception status until the inventory is replenished or the order is modified. Learn more about Order Status.
How do I identify which SKUs are causing Exception Orders?
The Out of Stock with Exceptions Report provides a centralized view of which SKUs are causing order exceptions, how many orders are affected, and which incoming WROs will resolve the shortages. The report includes five sub-reports that break down exception orders by SKU, fulfillment center, and WRO status.
What does 'SKU with No WRO Incoming' mean?
This metric shows the number of SKUs that are out of stock without any WROs inbound to replenish the SKU. These products need immediate attention and should be prioritized for replenishment by creating a WRO.
How do I know if incoming WROs will resolve my Exception Orders?
The Out of Stock with Exceptions Report Summary shows two key metrics: “SKU with Incoming Quantity > Exception Count” (enough inventory inbound to resolve all exceptions) and “SKU with Incoming Quantity < Exception Count” (insufficient inventory to resolve all exceptions). Use these to prioritize which SKUs need additional replenishment.
Yes, all Jetpack reports support data export in multiple formats. Each sub-report includes an export menu (accessed via the three-dot icon) with options like “Data with current layout,” “Summarized data,” and “Underlying data” depending on the report. Exported files download automatically to your computer.
What filtering options are available?
Every report provides filtering options to narrow down data by product, fulfillment center, date range, order type, and more. Filters apply to all sub-reports simultaneously, allowing you to focus on specific SKUs, locations, or time periods relevant to your analysis.
What does the Drill Up and Drill Down feature do?
In the Inventory Velocity Report, the Drill Up feature (up arrow icon) lets you view a summary of SKU performance rolled up by product, which is useful for viewing overall product family performance. The Drill Down feature (down arrows icon) reverts back to the detailed chart view with fulfillment center breakdown.
Can I view Top and Bottom performing SKUs?
Yes, the Inventory Velocity Report includes Top 5 and Bottom 5 SKUs sub-reports that identify your highest and lowest performing SKUs by sales volume within your selected time range. Use these insights to ensure star performers remain well-stocked and to evaluate slow-moving inventory.
Why does data differ between reports and the Inventory Status page?
Common reasons include different refresh schedules (reports refresh daily or weekly, while the Inventory Status page updates in real-time as inventory moves) and WRO processing timing (units appear under Incoming inventory until the WRO is processed, causing a slight delay in units being available to fulfill forecasted demand).
Why are some export options disabled?
Some export options may be disabled or incompatible with certain sub-reports depending on the data structure and your current filter selections. Choose an available format that matches your analysis needs, such as switching from “Underlying data” to “Data with current layout.”
What should I do if I don't understand a specific metric?
If you need help interpreting report data, have questions about specific metrics, or want guidance on using reports for strategic planning, your Jetpack Care team is available via Slack, phone, or email. The team can help you get the most value from your data.
How should I use reports together for seasonal planning?
For planning seasonal replenishment, combine the Inventory Replenishment Report (for demand forecasts for the next 12 months) with the Inventory Velocity Report (for historical performance data). Review demand forecasts alongside velocity data from last year’s season to plan order timing and quantities. Learn more about managing replenishment schedules.
How do I identify slow-moving inventory?
Use the Inventory Velocity Report to find SKUs with high days-on-hand estimates, then cross-reference with the Inventory Snapshot Report to review movement history. SKUs with minimal movement over time are candidates for promotions or liquidation.
How can I resolve stockout situations?
Start with the Out of Stock with Exceptions Report to identify SKUs causing exception orders, then check the Inventory Replenishment Report to see if incoming WROs will resolve the issues. If incoming inventory is insufficient, create an emergency WRO to prevent prolonged stockouts.
Which report should I use to answer specific business questions?