Skip to main content

Export, print and schedule a custom report

Download a custom report as CSV, Excel or PDF, print it, or have it emailed on a schedule.

A saved or unsaved custom report can be downloaded, printed or sent on a schedule. Every file has the columns, filters, grouping and totals you see on screen, and every row of the report.

Export a file

Click Export and choose CSV, Excel or PDF. If the report has cost columns, tick Leave out cost columns to take them out of this file only, for example before sending it to a supplier.

  • CSV is for spreadsheets and other tools. Numbers use a dot for decimals and dates are written year-month-day. On a report that shows variants under their product, the CSV leaves out the product lines, so adding up a column never counts a variant twice.

  • Excel keeps the product lines in bold with the variants grouped under them, and adds an About sheet with the dates and filters.

  • PDF is laid out for printing, with the dates, filters and the time it was made. It prints the pictures in Image and Product image columns, where CSV and Excel carry each picture's web address. A picture that can't be fetched prints as an empty cell.

Small files download straight away. A larger one is prepared in the background, and the download starts on the page when it's ready. The file stays available for 24 hours.

More actions > Print (PDF) downloads the PDF in one click. It's the quickest way to print a count sheet.

Export menu with CSV, Excel and PDF, and the Leave out cost columns tick box

Schedule it by email

Save the report first, since a schedule sends the saved version. Then click Schedule (on a phone, it's under More actions) to open Scheduled delivery, and Add a schedule:

  • How often: Daily, Weekly, on Mondays or Monthly, on the 1st, with Send at for the hour in your store's timezone.

  • File: CSV, Excel or PDF.

  • Send to: up to 10 email addresses, separated by commas. Leave it empty to send to your store's email.

  • Also post a summary in Slack posts the row count, dates and filters with a link to open the report. The file itself only goes by email.

  • Dates in each file: the period the schedule covers (yesterday, last week or last month), or the report's own date range.

  • Send even when there are no rows: otherwise an empty report is skipped.

Send a test sends one copy to an address you type, and Send now sends a copy straight away. Recent deliveries shows what was sent, skipped or failed. A report can have up to five schedules. Filters set to Ask when run use the answers saved with the report.

Scheduled delivery with a weekly schedule and Recent deliveries below

Limits

  • An export holds up to 100,000 rows as CSV or Excel, and 1,000 rows as PDF.

  • A scheduled file holds up to 20,000 rows as CSV or Excel, and 1,000 rows as PDF. A file that stops short says how many rows it holds, and its totals still cover every row.

  • A file over 7 MB arrives as a download link instead of an attachment. The link works for 7 days.

Good to know

  • If a scheduled report can't run, for example because a field it uses was removed, the recipients get an email saying it wasn't sent and why, and the schedule shows the problem.

  • Deleting a report stops its schedules. Undoing the delete starts them again.

  • Report names, column names and filter values appear in the file as you typed them. Other words in the file, such as Total, follow your language when you export, and your store's language in a scheduled send.

Did this answer your question?