Custom Reports

Custom reports are available for an additional fee. Or you can export your order data and produce your own custom reports using any spreadsheet software.

When requesting a custom report, please provide a spreadsheet that has a sample format in it, so we are very clear on your requirements. 

Please identify clearly in your request if you want filters for order payment status or any other status.

If you want to produce your own custom reports, it is relatively easily to export your data as CSV and import into your spreadsheet software. 

Tips on working with export data

• b_total_total is the total including freight, GST, discounts etc. This amount will commonly be used in your reports.
• b_closed is the official order date. This is when the order was submitted. Orders may exist for days before a customer submits them. It may be days more before it's paid for (b_paidon) 
• If you include product data in your order export, then the order header lines will be repeated for each item line. So you should SUM the bi_line_total, and not the b_total_total