Help CenterAnalytics & Reporting
How do I export my report data?
2 min readReports (web dashboard)
On Reports, choose a store and period, then click Export CSV. You get one row per order in that period, except returned and deleted orders, with the sale total, Sales, marketplace fees, Order Earnings, Revenue, supplier cost, Profit and ROI. Figures that are not final yet are marked "(est.)".
Steps
- Open Reports and choose a store in the store picker.
- Pick the period: Last 7 days, Last 30 days, Last 90 days or All time.
- Click Export CSV. A file named reports-<store>-<period>-<date and time>.csv downloads.
- If there are no orders in the period, you see "No orders in the selected period." and no file downloads.
Good to know
- Columns: Order Date, Order Fulfill Date, Store Order ID, Supplier Order ID, Sale Store Total, Sales, Marketplace Fee, Ad Fee, Other Store Fees, Order Earnings, Revenue, Item Procurement, Profit, ROI %, Status, Total sale (USD), Rate (USD per unit), Rate date.
- The last three columns show each order's total in US dollars. Total sale (USD) is the full amount the buyer paid, tax and shipping included like Sales (Sale Store Total is the item prices only), converted at the rate saved on that order the day it arrived. Rate (USD per unit) is that rate, and Rate date is its day in UTC. A USD order shows rate 1 and no date. An order with no saved rate leaves all three cells blank. They stay filled on a cancelled or refunded order, where Sales is blank, because the sale still happened.
- Sales is the full amount the buyer paid, tax and shipping included. Revenue is Sales minus the sales tax and the channel fees. Both are blank on a cancelled, refunded or partly refunded order, the same orders the Sales and Revenue cards leave out, so each column adds up to its card.
- Item Procurement is the supplier cost DS-Mate billed you. Profit is what you keep after fees and supplier cost. ROI % is Profit divided by Item Procurement.
- "Pending" in a fee cell means the channel has not reported fees for that order yet. "(est.)" means the value may still change when fees settle.
- Status is Active or Cancelled. Cancelled orders stay in the file, so a supplier cost already paid shows as a loss.
- An order with no supplier cost recorded yet shows Profit 0.00.
- Deleted orders and returned orders are not included.
- The export covers one store. To compare stores, export each store and combine the files in your spreadsheet.
- Each click fetches fresh data. If it fails, you see "Failed to generate spreadsheet. Please try again."
Still have questions?
Our support team is ready to help. Reach out and we'll get back to you as soon as possible.