Filter, save and export reports
Filters, periods and date ranges, columns, saved reports, CSV export, PDF printing, row actions and importing edited values on StockWay's reports.
Every report in StockWay shares the same tools: filters, a period or date range, column choices, saved reports, CSV export and a print sheet you can save as a PDF. Many reports also let you act on a row, such as adding it to a purchase order. This page explains each tool. For what each report shows, see Reports.
Filter a report
Reports filter in one of two ways.
- A filter bar above the table. It has a location box (Entire store or one location), a search box, usually a period box and, on some reports, boxes such as All vendors, Tags or Sort. Changes apply straight away; there is no Apply button. When a filter is on, a reset link clears them all. The search box names what it searches.
- A Filters panel on the left. Orders, Products, Purchase orders, Sale items, SKU/Variants, Adjustments and Transfers have more filters here. Fill in the boxes, then click Filter or Update. Number filters have Greater than and Less than boxes, and sometimes Equal to, which wins when filled in. On SKU/Variants you can tick several locations.
Store stats has no filters. Profit has a single date range box and an Update button.
Periods and date ranges
- The period box offers Last 7 days, Last 30 days, Last 90 days and Last 365 days, plus your default if it differs. The default is Sales velocity window (days) in Preferences (account menu). The Low stock report has no period box.
- Date range boxes on Orders and Profit, and Sales between (end date is inclusive) on Products and SKU/Variants, take
DD/MM/YYYY - DD/MM/YYYY, for example01/10/2026 - 31/10/2026. The end date is included, and a range typed backwards is turned round. On Orders and Profit the box starts with your default period. On Products and SKU/Variants the range sets the sales totals; on SKU/Variants, Sales/Day and Depletes in (days) still use your default sales window. - The date filters on Purchase orders and Adjustments take one date per box, as
DD/MM/YYYY. Transfers uses date pickers. These three reports have no default date range: they show everything until you filter.
Choose columns and sort
- On the Low stock report use Settings, and on the Product Report use Columns. Tick or untick a column and the table changes at once.
- On the SKU/Variant report, Settings opens a dialog. Tick the columns and click Update.
- Column choices are lost when you reopen the report from the menu; save the report to keep them.
- To sort the SKU/Variant and Purchase orders reports, click a column heading; click it again to reverse. On SKU/Variants the Available heading does not sort yet. The Low stock report has a Sort box instead.
- Hover over a short heading such as OOS (ex ordered) to see what it means.
Save a report
- Set up the filters, period, columns and sort you want.
- Click Save Report at the top of the report.
- Type a Name and click Save.
To open it later, choose it from the Reports menu beside Save Report. Saved reports belong to that report, or that tab of it, and are shared with everyone who uses StockWay in your store. Saving under a name that already exists replaces it. To delete one, click Save Report and click Delete beside it under Saved views.
Export to CSV
Click CSV to download the report with the same filters, period and columns as the screen. The file is named after the report, for example low-stock-vendors.csv.
- It holds up to 50,000 rows, even when the screen stops at 5,000.
- Where the report has a total row, it is the last row, labelled Total.
- Store stats and Profit export their tables one after another.
- Empty cells stay blank and percentages are plain numbers, so the file adds up in a spreadsheet.
Print or save as PDF
- Click PDF. A print sheet opens in a new tab, and your browser's print dialog opens.
- Choose a printer, or choose Save as PDF as the destination to get a file.
The sheet is landscape. It carries your Document header from Preferences, the report title, the date, the summary and every row up to 5,000, without page links. If you close the dialog, click Print / Save as PDF on the sheet.
Long reports
Reports show 100 rows per page, with page links under the table. The screen holds up to 5,000 rows. Past that, the report says there are more than this: narrow the filters, change the sort, or download the CSV.
Act on a row
Row actions sit at the end of each row, most of them in a small menu.
- Add to PO is on Best sellers (By Variant), the Low stock report, SKU/Variants, and Low stock by product when one variant is low. In Add to purchase order, pick an open purchase order or a New purchase order with a supplier or vendor. The quantity starts at what covers your Cover (days), net of stock and what is on order; change Suggest for and click Update Forecast to recalculate. Click Add to PO: the line is added and the purchase order opens for editing. Bundles, and products Shopify does not track, cannot be added this way.
- Exclude from forecasting, on the Low stock report and SKU/Variants, takes the whole product out of forecasting and reorder suggestions. Include in forecasting on SKU/Variants brings it back, but does not override an ignore tag or archiving in Shopify.
- View on Shopify, View product on Shopify and View variant on Shopify open the item in your Shopify admin, in a new tab.
- + PO on Low stock by vendor opens the new purchase order form for that vendor.
- Where there is a New menu, it offers Purchase order, Adjustment and Transfer.
Edit values in a spreadsheet and import them
Reports that show a SKU column have an Import button.
- Click CSV and edit the file in a spreadsheet.
- Click Import, choose the file under CSV file and click Preview changes.
- Untick any column you do not want, then click the import button, which shows the number of changes, for example Import 12 changes.
Rows are matched by SKU, barcode or variant ID. Only cost price, average cost, minimum order, minimum and maximum stock, reorder point, bin location and the three text fields are imported. Cost prices are written to Shopify and cannot be undone from StockWay.
Refresh the data
Reports show what StockWay has synced. Sync from Shopify at the top of every report pulls products, variants, locations, stock levels and the last 60 days of orders. A progress bar shows while it runs, and the report refreshes when it ends.
Still have a question? Email us and we will help you get set up.
ilyasstaibi1992@gmail.com