Stocky report types
Stocky can record a daily snapshot of your stock value and retail price. After you enable stock on hand reporting, Stocky starts to gather data. It might take up to 24 hours before your first stock on hand record appears.
Access a report
- From your Shopify admin, go to Apps > Stocky.
- From the Reports drop-down menu, click the report that you want to run.
You can view the following reports from within Stocky.
Low stock reports
You can view low stock reports based on vendor, product, or variant SKU.
The Low Stock Vendors report shows you which vendors have variants that have low stock, and which variants are out of stock and the estimated revenue that is lost. It also shows the unique variants you have ordered from the vendor but not yet received.
The Low Stock Products report shows you which products have low stock, and which products are out of stock and not on order from a vendor. If the variant is out of stock, then it also shows you the estimated revenue that is lost each day.
The Low Stock Variants report is the most detailed low stock report. It shows such details as how many days of stock you have left, the estimated date when your inventory will run out, and the day by which you should reorder more inventory based on how long it takes you to receive it.
The Product Report shows details about your products, such as the current inventory and amount of sales. The report also displays an ABC analysis for each product, which grades your products based on their sales history for the past 8 weeks.
The SKU/Variant Report shows each variant's cost per unit, selling price, and number of sales. You can add additional columns to create a more detailed analysis of each variant.
Stock On Hand reports
You can view a current or historical report for your stock on hand.
The Stock On Hand - Current Report shows the current value and cost of your inventory.
The Stock On Hand - Historical Report shows a specified total for all inventory, such as cost price, value, or quantity, for each date in a date range. You can filter the report to base the total on all vendors or a specific vendor.
Purchase Orders Report
The Purchase Orders Report shows details about each of your purchase orders, such as arrival destination, delivery status, and payment status.
Stock Adjustments Report
The Stock Adjustments Report shows details about each stock adjustment, such as the date, the reason, and the employee who made it.
Stock Transfers Report
The Stock Transfers Report shows details about each stock transfer, such as its status, the origin and destination, and the reason for the transfer.
Store profit report
The Store Profit Report shows financial information, such as returns, gross sales, and your cost of goods sold.
There are multiple different stock on hand reports available.
Total cost is equal to the quantity of each variant multiplied by its cost price for all of your in stock variants. This calculation excludes variants with negative stock levels and hidden variants.
Total retail is equal to the quantity of each variant multiplied by its retail price. If you sold all of your stock at its current price, this is how much you'd make.
Total items is the total number of in stock items you have in your store. If you have 10 red socks and 5 blue socks, then the total items number is 15.
Stock on hand per vendor
Stocky keeps a stock-on-hand record for each vendor. To access the stock on hand for a vendor use the form at the top of the stock on hand report. Some reports might have stock listed as tracked by Shopify. This is a way of segmenting your stock on hand reports by items that are tracked by Shopify. If your drop-shipped products are not tracked by Shopify, then drop-shipped stock can be excluded from the stock on hand reports by selecting the tracked by Shopify version of each report.
Rounding in Stocky
Different accounting and inventory management systems handle rounding in different ways. Stocky rounds numbers at the line item level to two decimal places, and then sums the line items to give you the total. This can create a slight variance when compared to other methods of rounding after summing.
If you want to adjust any numbers manually, then you can do so in the Adjustments field. Adjustments might be necessary if your supplier's accounting system uses a different approach to rounding.