Reports
Reports
The sales report and how it counts, the OSS tab, and the columns in the order and customer export.
The sales report shows sales in the base currency.
Where: Reports. The same report for one storefront is on the storefront's Analytics tab.
Choose period and storefront
Reports has the windows 7D, 30D, 90D and 12M, back from today in your time zone. Choose All storefronts or one storefront. The address keeps the window and the storefront, and they carry over to the OSS tab and back.
The figures
| Tile | Counts |
|---|---|
| REVENUE | Money captured on orders placed in the window. An order without a payment provider counts with its total once marked paid |
| REFUNDED | Refunds made in the window, whatever the order date. Only refunds made in BunStack |
| NET | REVENUE minus REFUNDED |
| ORDERS PLACED | Orders placed in the window, every status. The line below shows the average order, avg. |
The average order is REVENUE divided by orders with captured money and a rate. The line under REVENUE shows how many orders are only reserved and how many lack a rate.
BunStack converts each order at the rate saved on the order. The totals leave out orders without a rate. The line under REVENUE counts them, and the line under REFUNDED counts refunds without a rate. A refund made in Kustom's portal does not show here.
The report counts neither test orders nor their refunds. See Test orders.
How these are counted expands the whole counting rule.
Under the figures
- Needs you has a row when there are checkouts that cannot become orders. It opens Abandoned checkouts with the same window and storefront.
- Daily bars on the same basis as REVENUE.
- Top products: the 10 best products by revenue, from orders with status PAID or FULFILLED, after line discount.
- Status mix: the orders per status.
- Storefronts: one row per storefront with sales and number of orders. Shows with All storefronts when you have more than one storefront. A row opens the storefront's Analytics.
A storefront that could not be read shows Could not load. The card's heading then gets Try again.
Export the report
Export CSV downloads the tiles' totals, one row per order in the window and the top list. Columns with amounts in the base currency end in its code, for example base_total_sek, revenue_sek, refunded_sek and net_sek. The file stops at 20,000 orders, and BunStack then marks it PARTIAL. The button works when the window has orders or refunds.
OSS
The OSS tab beside Sales is the quarterly return for OSS and destination VAT. See The OSS report quarter by quarter and Filed quarters and the auditor pack.
Order and customer export
Orders › Export CSV gives one row per order line, newest first, at most 5,000 orders. With a filter set the button reads Export filtered CSV. The file leaves out test orders. ⋯ › Export CSV with test orders includes them.
| Column | Content |
|---|---|
order_number, placed_at, status, payment_status | The order |
storefront | The storefront's slug |
customer_email, customer_name | The customer |
currency, subtotal, discount, shipping, tax, total | Amounts in the order's currency |
captured, refunded | Captured and refunded |
net | Kustom: captured minus refunded. Other orders: total minus refunded. Empty when no money was captured and on test orders |
item_title, item_sku, item_qty, item_unit_price, item_discount | The order line |
test_order | yes on a test order. The last column |
The file has no country column.
Customers › Export CSV gives the loaded customers, at most 500. Search to reach the rest. With a filter set the button reads Export filtered CSV.
| Column | Content |
|---|---|
email, first_name, last_name, phone | The customer |
storefront | Slug of the First storefront |
marketing_opt_in | yes or no |
joined | Date the customer was added |
The customer file has no order values.