How can I generate a sales report for my orders?

You can generate sales reports from different pages depending on the information you need.

Daily sales total

To check total daily sales in RM:

Go to Analytics > Order Report.

Total orders for a selected date range

To check the total number of orders for certain dates:

Go to Analytics > Order Report and filter the date range.

To export the report, click the three-dot menu at the top right and select Export Data.

If you need to review a long period such as the last 2 years, export the report in multiple date ranges. The report supports a maximum 3-month range at one time.

Only orders captured after the marketplace integration date will appear in SiteGiant. Orders created before integration cannot be retrieved in the system.

Export order sales data for accounting

If you need to download sales records for accounting:

Go to Analytics > Marketplace Channel Report and filter the date range.

To export the report, click the three-dot menu at the top right and select Export Data.

Export order sales data for accounting

If you need to download sales records for accounting:

Order report

Go to Analytics > Order Report to export sales data.

• You can filter by date
• The report supports a maximum 3-month range at one time
• A full-year sales report cannot be generated at one time due to current system limitations
• To pull a whole year sales report, generate it month by month and combine the exported data as needed

All orders export

If you need transaction details such as date, order number, product items, and amount, export the orders from the All Order page.

You can filter by store and date before exporting.

Which order statuses to exclude for sales figures

If you want sales figures that tally with inventory out, exclude these statuses:

• Open
• Cancelled
• Returned
• Lost or Damaged

Orders in Pending Process and Processed can be included.

If an order is later cancelled, downloading the report again will exclude that cancelled order.

Orders not appearing in Marketplace Channel Report

An order with Open status will not be included in the Marketplace Channel Report.

Update the order to Pending Process if you want its sales to appear in the report.

Sales after deducting marketplace fees and charges

Not all marketplace fees and charges are shown directly in the order.

For Shopee orders, check App > Marketplaces > Payment Reconciliation to view fee and charge details and export the report after payment is made for the order.

If you are using this report for the first time, activate the feature first. The system takes time to run the report, so check again the next day. After that, you can filter the required order date range, including a previous day date range.

Item sold reports

If you want to see sold quantity by item, you can also use:

• Item Sold Analysis Report
• Item Sold Report

These reports can only be viewed in 3-month intervals.

Updated on: 11/05/2026