Ecommerce analytics: BI dashboards and CSV exports
Ecommerce analytics and sales reporting: export order data to CSV, view revenue and profit trends, and generate accountant reports.
In short
Ecommerce analytics in StoreChart come from three places: CSV exports of your filtered orders, customers or an import shipment; BI dashboards with revenue, profit and stock; and a monthly handoff of expenses to your accountant. There's no report builder or scheduled export at the moment, so you run exports by hand when you need them.
Your data, as a file or a chart
Export when you need to, and check trends without leaving the system
- Export the filtered orders list, with order number, customer, store and status
- Export the filtered customers list
- Export the lines of an import shipment
- CSV files that open correctly in Excel, Hebrew included
- BI dashboards for revenue, profit and stock, plus expenses sent to your accountant
What you can get out of the system
Exports, charts and handoff to your accountant
Exporting data in 3 steps
From a filter to a file in hand
Choose a store, status and date range in the orders or customers table.
Click export and get a CSV file with the rows on screen.
Open it in Excel, send it to your accountant, or check the trends in BI dashboards.
Reports and data exports: what you get
Three sources of reports
In StoreChart, reports come out of three places, each with a different job:
- Orders and customers tables: the source for CSV files.
- BI dashboards: where you watch trends in charts.
- Expenses module: sends supplier invoices to your accountant on a set day.
There's no screen that builds a free-form report from every field in the system. So start with what you want to know, and which screen holds that number.
Exporting orders to Excel
- Open the orders list and choose a store in the global selector.
- Filter by status and dates.
- Click export and get a CSV file with the rows left after filtering.
The file has fixed columns:
- Identity: order number, customer and store.
- Contents: status and number of items.
- Money: amount and gross profit.
- Other details: notes, created date and updated date.
Hebrew in Excel and a safe file
- Correct Hebrew: files are saved in an encoding Excel recognizes, with no garbled text.
- Formula protection: a cell that starts with a character such as an equals sign is neutralized, so it doesn't run as a formula.
- Up-to-date profit: gross profit comes from the costs you entered, so update costs before exporting.
- Contact details: a customer list includes phones and emails. Think about who receives it.
Customer and import shipment exports
- Customers: a filtered list, for example one store's customers for a campaign.
- Import shipment: the shipment lines in a separate file, for your customs broker or accountant.
- Several stores: each export covers the store in the selector, or all stores when none is chosen.
BI dashboards: trends in charts
In a BI dashboard you add charts as needed, and the store and date filters apply to the whole dashboard.
- Metrics: revenue, gross profit, costs, stock and customers.
- Displays: line, bar, pie, area or a single-number card.
- Layout: arrange the charts on a grid, with the key metrics on top.
- Export: chart data doesn't export to a file. For exact figures, go back to the table.
Build one fixed dashboard for month-end, so every comparison is against the same picture.
Example: closing the month with your accountant
Illustrative only. A business with two stores closes the month like this:
- On the 2nd, it filters and exports each store's orders: 310 in one store and 95 in the other.
- In BI, gross profit dropped to 34% from 38%, so it opens the orders to find the product behind it.
- On the 5th, 18 expense invoices collected from Gmail go to the accountant automatically, in one email.
- If the accountant asks for more data mid-month, it filters and exports again.
Who it's for and what's not included
- Good fit: a small or mid-sized business whose accountant is happy with an orders list, expense invoices and a view of trends.
- Tax reports: no VAT reports or accounting documents.
- Report builder: there's no screen where you pick columns and assemble a table of your own.
- Scheduled exports: none. Order exports are run by hand.
- Tranzila charges: live on the payment tracking screen, not in the orders export.
- Permissions: anyone without the profitability permission doesn't see profit data in the system.
Key integrations
Questions about reports and exports
What can I export?
The filtered orders list, the filtered customers list and the lines of an import shipment. Files are exported as CSV.
Is there a report builder?
No. Visual reports live in BI dashboards, where you choose metrics, chart type and date range. Data exports are done from the tables themselves.
Can I schedule automatic exports?
Not at the moment. Exports are run by hand. What does go out on a schedule is your expenses, sent to your accountant on the day of the month you pick.
Does the file open in Excel with correct Hebrew?
Yes. Files are saved in an encoding Excel recognizes, so Hebrew displays properly.
Are there VAT or tax authority reports?
No. StoreChart doesn't produce tax reports at the moment. You can export orders and send your accountant the expenses that were collected.
Can I export BI data?
Not at the moment. BI dashboards are shown inside the system, and the underlying data can be exported from the orders and customers tables.
Who can export data?
Anyone whose role gives them access to the orders or customers page. Profit data is visible only to owners, admins and accountants.
Related capabilities
Your store data in an Excel-ready file
Connect a store, filter your orders and export


