Reports

What each of StockWay's reports shows and when to use it, from ABC analysis and best sellers to profit and transfers.

StockWay's reports turn your stock, sales and purchasing records into tables. Some are worksheets for deciding what to buy; others are records of what has happened. This page says what each report shows and when to use it. Filters, saved reports, CSV and PDF are covered in Filter, save and export reports.

Open a report

Open Reports in the top bar and choose a report. The three low stock reports are under Low Stock. The back arrow on a report opens the Reports page, which lists them all with a short description.

Sales rates are measured over the last 60 days at most, because Shopify lets the app read only 60 days of order history. Cancelled orders and gift cards never count as demand. Products excluded from forecasting are left out of Best sellers, the low stock reports and Sale items.

Buying worksheets

ABC analysis

Grades products by their share of revenue over the last 8 weeks: A for the products making up the top 80%, B the next 15%, C the rest, U for no sales in those weeks or a product under 8 weeks old. Each grade shows Products with grade (the share of your products), Products, Items in stock, Retail value and Cost value; View products lists its variants. Grades cover the whole catalogue, so no filter or period changes a letter. Use it to see where your revenue comes from.

Best sellers

What sells fastest, ranked by revenue per day over the period, By Variant or By Product. ELT is the lead time, Est. the units to order to cover lead time, restock period and safety stock (net of stock and placed orders), Dep. the days of stock left, and Ord. what is on order. Stock turns red when out and amber when it covers fewer days than Cover (days) in Preferences (account menu).

Low Stock: Vendors

Low stock by vendor shows which vendors to chase first. Out of stock only counts out-of-stock variants, once per location (OOS), and the revenue lost meanwhile (Lost rev.). Within lead time adds stock that will run out before a replacement could arrive. Columns marked (ex ordered) leave out variants already on a placed purchase order. Possible rev. is what restocking now could earn over your Cover (days). Click an OOS count to open the Low stock report for that vendor, or + PO to start a purchase order.

Low Stock: Products

Low stock by product lists products with a selling variant that is out of stock or will run out within its lead time, costliest first. Available counts variants in stock, so 0 of 3 means nothing can be sold. Lost/Day is revenue lost per day.

Low Stock: SKU/Variants

The Low stock report has one row per variant per location. Slow sellers starts on Show all (every variant); Exclude slow sellers or Include slow sellers narrows it to selling variants out of stock or running out within their lead time. ROP is the reorder point (lead time × daily sales, unless imported), Dep (date) when it runs out (depleted if it is out or has no sales), Rep (date) when the next placed order is due (now if none is), and Forecast the demand over the Forecast period. Optional 15d, 30d, 60d and 90d columns give units to order for that many days, net of stock and placed orders. It always uses the sales window from Preferences.

Sale items

The Sale items report is a markdown shortlist of slow, ageing stock, most retail value first, By variant or By product. It opens with Minimum stock level 5, Minimum depletion (days) 30, Minimum age (days) 30 and, on By variant, ABC grade C.

Minimum age is measured from the last time StockWay updated the stock record, and every sync, including the automatic ones, updates it. So any minimum age longer than the time since the last sync empties the report. Set Minimum age (days) to 0 and click Filter to see candidates.

Sales records

Orders

Orders in a date range with Order No., Items, Tax, Discount, Refunded, Subtotal, Total and COGS, and a revenue graph (net of refunds, without cancelled orders) by Month, Week or Day. Filter by order number, vendor, product, variant, SKU, amounts, and whether to include cancelled orders. COGS uses the cost recorded with the sale, then the average cost, then the cost price; it is blank when a line has no cost.

Profit

The Store Profit Report gives Gross Sales, Discounts, Net Sales, Shipping, Taxes, Total Sales, Gift Card Sales, Cost Of Goods, Gross Profit, Net Profit and both margins for a date range. Cancelled orders are left out, tax is not profit, and no fees or fulfilment costs are deducted. Refunded (not deducted) is shown but not subtracted, because Gross Sales already counts only the units left on each order; a refund that removed no units, such as a shipping refund, is not taken off.

Statistics

Store stats has no filters. It compares the last 28 and 7 days: average order value, items per order, orders per day and a straight-line 52-week revenue estimate. Then it shows stock value at retail and cost, discounts given, total orders and SKU counts. Cancelled orders are left out.

Stock and catalogue

Stock on hand

Current stock on hand lists what you hold, with Total cost, Total retail and Total items. A variant at several locations has a row for each; choose a location to see one. Value it at Current cost price or Average cost. The History tab shows daily totals, starting from your first sync; earlier days cannot be filled in.

Products

The Product Report lists every product with Available and units sold (Sales). Columns adds sales value, vendor, type, status, variants, value at cost, created date and tags. Products excluded from forecasting are hidden unless you set Excluded from forecasting to Yes, which lists only those.

SKU/Variants

The SKU/Variant Report lists every variant, with more than 40 columns to choose from in Settings and a long Filters panel. Type a new Cost Price in the table and press Enter: it is saved to Shopify. Refund, cancelled and unfulfilled quantities are not available.

Purchasing and stock movements

Purchase orders

The Purchase orders report lists every purchase order with dates, payment state and totals in your currency, at each order's exchange rate. Received shows lines fully received of lines ordered: green when complete, amber when partly in, red when nothing has arrived by the expected date. The Purchase order items tab lists every line, with costs in your currency and the supplier's.

Adjustments

The Adjustments report lists every adjustment line, applied (Adjusted) or not, such as a draft (Not adjusted), with reason, notes, employee and the change in units.

Transfers

The Transfers report has one row per transfer: From, To, status, reason, units sent, received and In transit, and the In-transit value. Late transfers show Overdue.

Still have a question? Email us and we will help you get set up.

ilyasstaibi1992@gmail.com