LVK's Reports section gives you downloadable inventory data for every warehouse holding your stock. Use it to check what's available to sell, trace a stock change back to its cause, or pull shipped and received totals for a date range.
Table of Contents
- How to Find Your Inventory Reports in LVK
- Inventory Report
- Inventory Change Log
- Inventory Movements Report
How to Find Your Inventory Reports in LVK
Inventory Reports Available in LVK
| Report Name | What it shows | Use it when |
|---|---|---|
| Inventory Report | A real-time snapshot of stock in the warehouse and stock on its way. | You need to know what you can sell right now. |
| Inventory Change Log | Every individual addition or deduction to your stock, with a reason for each. | A count looks wrong and you need to find out why. |
| Inventory Movements Report | Total units shipped, received, and returned per SKU over a date range. | You're reviewing trends across a week, month, or quarter. |
Pro-Tip
Export reports at the end of the day. Stock levels shift as orders ship, so an end-of-day export gives you the most stable snapshot to work from.
Need more data to build custom reporting? See Data Export Service. If a report fails to download, contact Customer Support.
Inventory Report
The Inventory Report shows your stock at every LVK warehouse in real time. It counts both stock physically in the warehouse and inbound inventory, meaning units on a shipping plan that haven't arrived yet.
Watch this walkthrough of the Inventory Report:
Inventory Report Features
- Filter by warehouse.
- Search for a specific SKU.
- Select the gear icon to choose which columns display.
- Export the results.
Inventory Report Key Terms
| Report Term | Definition |
|---|---|
| On-hand | Units physically in the warehouse right now. |
| Allocated | Units already assigned to existing customer orders. |
| Available | Units you can sell right now. On-hand minus allocated equals available. |
| Backordered | Units needed to fill existing orders that don't have enough on-hand stock to cover them. |
| On Order | Units on incoming shipping plans that LVK hasn't received yet. |
| Pending Return | Units expected back based on open RMAs (Return Merchandise Authorizations, the records that authorize a customer return). |
Inventory Change Log
The Inventory Change Log records every change to a SKU's stock level over time, including shipments and cycle count adjustments. Each row shows what the count was before the change, what it became, and why it changed.
Watch this walkthrough of accessing and exporting the Inventory Change Log:
Inventory Change Log Features
- Filter by date or warehouse to see when and where changes happened.
- Search by SKU.
- Select the gear icon to choose which columns display.
- Export the results.
Inventory Change Log Columns Defined
| Column | Definition |
|---|---|
| Created at | The date the stock change was recorded in the warehouse. |
| Warehouse | The LVK location where the change happened. |
| Product Name and SKU | The product the change applied to. |
| Previous inventory on hand | The unit count before the change. |
| Updated inventory on hand | The unit count after the change. |
| Reason for the change in stock | Why the count changed, for example a shipment or a cycle count adjustment. |
Inventory Movements Report
The Inventory Movements Report totals the units shipped, received, and returned for each SKU across a date range you choose. Use it for historical trends rather than current availability.
Inventory Movements Report Features
- Filter by date.
- Search by SKU.
- Select the gear icon to choose which columns display.
- Export the results.
Inventory Movements Report Key Terms
| Report Term | Definition |
|---|---|
| Total SKUs received | Units LVK received from all incoming shipping plans during the period. |
| Total SKUs shipped | Units LVK fulfilled on customer orders during the period. |
| Total returned | Units included in RMAs created by customers during the period. |
| Total restocked from return | Units from returns added back to your sellable inventory, including Return to Sender items. |