When none of the ready-made reports answers your question, a custom report lets you choose what each row is, which columns it shows, how it is filtered and grouped, and which dates it covers. You can save it, run it again, export it and have it emailed on a schedule.
Custom reports carry an Early access badge. Early access marks newer, advanced features. They're free to use today and nothing is held back. Purchase orders and receiving are free, and they stay free - that's the core of the app. Features marked early access may become part of a future paid plan.
Where to find it
Open Reports. Its Custom reports section has the box for describing a report and your latest reports; the link beside it opens every saved report and the starter templates. The same pages are on the Reports page at go.stockroom.app.
Many standard reports also have a Customize button beside their title. It opens that report, with your filters, as a custom report you can change and save. Customize is on Sales, Stock on hand, Variants, Dead stock, Vendor purchase history, Receipts, Landed cost, Last counted, Margin (on the current-cost basis), ABC analysis, Approvals and finance review, Owed to suppliers, Purchase order charges and Out of stock. The reports built on the cost history (such as COGS and Stock on hand by date), Projected shortfall, Price review, Supplier performance, the Build reports and Expiring lots don't have it.
Start a report
There are three ways to begin:
New report asks what each row of the report is: Products and variants, Stock by location, Sales, Purchase orders, Purchase order lines, Deliveries, Delivery lines, Suppliers, Purchase order charges, Supplier payments, Stock adjustments, Stocktakes or Transfers. You can then add columns from related data, such as stock on hand beside units sold.
Start from a template offers ready-built reports in four groups: Purchasing, Receiving and bills, Sales and stock, and Counting. Examples are Receiving log, Bills by invoice date, Sales beside stock, Stock value by location and Count sheet, a printable sheet with on hand, reorder point, max level and a blank Counted column.
Describe the report you need takes a sentence, such as "open purchase orders by supplier with units still due", and Build report turns it into a report. It replies in the language you write in, lists the assumptions it made, and says plainly when it can't build what you asked. A store can ask 40 questions a day. Building a report by hand always works.
Change the report
The line above the table sums the report up: Data, Columns, Grouping, Date range, Filters and Sort. Click any part to change it.
Columns: the Fields panel lists what is In this report and, under Add fields, everything you can add. Use Search fields to find one. Click a column header for Rename, Summarize as, sorting, Group by this, Filter by this, Move left, Move right and Remove column. You can also drag a header to move a column, and drag its edge to resize it.
Pictures: Image (the variant's image, or the product's when the variant has none) and Product image (the product's main image) show a small picture on each row. In the Shopify admin, click one to see it larger. A picture column can't be filtered, sorted, grouped, summarized or charted.
Add a calculation makes a column from two others or a number: pick what to Take, what to Do (plus, minus, times or divided by) and what With, then how to Show as. Add a blank column adds an empty column to write on once printed.
Grouping: Group rows by a field, then by up to four more. Dates can be grouped by day, week, month, quarter or year with Group dates by. Show variants under their product gives one row per product with its variants underneath.
Date range: choose a preset such as Last 30 days or Last month, or Custom dates. Compare with adds the Previous period or Same period last year beside each figure. A comparison can't be combined with grouping by date.
Filters: Add filter for each condition, or add a group of conditions where any one may match. Tick Ask when run under a filter and whoever runs the report picks the value, such as the vendor or location, without changing the saved report. A filter asked when run, and the dates, can also be answered or changed straight from the summary line: click it there.
The table shows the first 500 rows. The totals always cover every row, and an export holds every row.
Undo and Redo step through your changes, and nothing is kept until you click Save. More actions holds Duplicate, Version history (where Restore brings back an earlier version) and Delete, which you can undo straight after.
Ask for a change in your own words
Switch the side panel to Stockroom AI and describe a change, such as "group this by vendor" or "only show the last 90 days". Each change it makes can be undone with Undo this change, and the report is only saved when you save it.
Charts
Draw a report as a chart, and see the records behind any number: Chart a custom report and see the records behind a number.
Export, print and schedule
Export downloads the report as CSV, Excel or PDF, and Schedule emails it on a cadence. See Export, print and schedule a custom report.
What custom reports don't include
Anything about individual customers, or single sales orders. Sales are added up by product, location, channel and date.
Anything below gross profit, such as expenses or a profit and loss, and nothing shaped as journal entries, debits or credits.
Figures from the cost history: FIFO cost of goods, stock value on a past date and the roll-forward. Use the COGS, Stock on hand by date and Inventory roll-forward reports for those. Cost fields in custom reports use each item's current cost, purchase order costs and landed costs from deliveries.
When a report is too big
A very large report keeps running in the background, and you can keep editing or come back to it. If it still can't finish, the page says so and suggests what to change: a shorter date range, a filter, or grouping the rows.
Good to know
Money in a supplier's currency is totalled per currency, never added together across currencies.
Stock value in your store's currency leaves out any item whose cost is held in another currency. Its units still count, and the page says how many rows were left out.
If costs or sales are hidden for you, you see reports without those columns and can't change a saved report that has them.
With staff roles on, saving one needs Create and edit purchase orders. Anyone who can see reports can run one.
A store can keep up to 500 saved custom reports.




