The "Inventory Status Report" lets you know about all your current stock statuses for your SKUs. If you've been submitting product costs with your stock level updates, the report will also tell you the last reported cost and the average cost per unit for each SKU.
To find this report and see what it's all about, follow the directions below:
Click on the Insights tab.
Next, select Reports from the sidebar on the left.
Scroll down to the "Inventory Reports" section, and click Inventory Status Report.
You have the choice of grouping your products according to Parent SKU, which you should only do if you've enabled advanced product types and grouped all of your size and color variations under non-buyable Parent SKU umbrellas.
When you're ready to generate the report, we can produce it in a number of formats:
- Viewable in-app
- A PDF file that's easy to print or share
- A spreadsheet file you can manipulate in Microsoft Excel
- A text file for use with any text editor
Here's a screenshot of the report's header row and an example SKU:
Now, for some details on the available columns (in order of complexity):
- SKU & Product Name - Pretty straightforward!
- Stock - The number of inventory units for the SKU at all locations. This number decreases as orders are shipped, and increases when more units are added.
- Allocated - The number of inventory units reserved for your "Awaiting Shipment" orders. This number increases as you allocate orders, and decreases as you either ship allocated orders, or deallocate your orders.
- Available - The number of inventory units available to allocate or ship orders that haven't been allocated yet (Available = Stock - Allocated).
- Re-Order Threshold - The SKU-specific stock threshold which (if set to a non-zero number) will override an account-wide stock threshold. When the threshold is met, alert icons will show up on the inventory grid.
- Last Cost - The last per unit cost associated with a stock addition. In other words, what you last paid your vendor for these units. You can specify a per unit cost while adding stock via the ShipStation interface or via the "Cost" column when setting new stock levels via CSV (assuming you 'set' the stock level to be higher than the previous value). These costs are not connected to the consumer's purchase price.
- Avg Cost - The average cost of your "Stock" units. At times, you may pay a higher or lower per unit cost to replenish your stock, so be sure to input those costs correctly every time you add stock via the interface or via CSV. Again, these costs are not connected to the consumer's purchase price.
It's worth emphasizing that the "Last Cost" and "Avg Cost" columns are very sensitive to the costs you enter-- a per unit cost of $0.00 can really mess up calculations. If you use the interface to "Set" the stock level to a higher amount, you'll effectively add units at a cost of $0.00, which can drive your average cost down significantly. The same is true if you upload an inventory CSV that sets the stock to a higher value-- if you don't specify a unit cost in the CSV, then you'll effectively add units at a cost of $0.00.