Create and Download a GMV Report

Create a Gross Merchandise Value (GMV) report for B2C Commerce in Business Manager. Select from four report types: Order Journal, GMV Report per Month, GMV Report per Day, and GMV per Order. B2C Commerce also automatically generates daily and monthly GMV reports on production instances. You can download a report you create or an auto-generated report to a comma-separated values (CSV) file that you can import into a spreadsheet.

Note GMV reports are available for all instance types, but they're intended for production instances to reflect real revenue. B2C Commerce auto-generates reports for GMV data on production instances only. The auto-generated report job is disabled on Development and Sandbox instances.

Note See Taxation (Net and Gross) Impact on Subscription Fees to understand how tax calculations can significantly impact the subscription fees that you pay.

Note Set the brand and geographical location for the site so that they appear in GMV reports. See Site Brand and Billing Entity in B2C Commerce.

1. Click App Launcher , and then select Administration | Operations | GMV Reports.
   Report status appears in the Status section. Click Refresh to refresh your view as reports run.
2. To create a custom report, on the GMV Reports page click Create.
   1. Enter the report start date or select it with the calendar widget.
   2. Enter the report end date or select it with the calendar widget.
   3. Select the report type.

      Report Type	Description
      Order Journal	One row per line item in the order.
      GMV Report per Month	One row for each site, month, order source, action, and item type included within the specified time range. B2C Commerce automatically generates this report on the first day of each month.
      GMV Report per Day	One row for each unique combination of site, day, order source, action, and item type within the specified time range. B2C Commerce automatically generates this report on the first day of each month.
      GMV per Order	One row for each unique combination of site, date, order source, action, order, and item type within the specified time range.

   4. Select the report scope, for example, All Sites or one or more selected sites.
   5. Click Export.
3. Download a report.
   1. Click Download in the Custom Reports section for reports you created, or in the Auto-Generated Reports section for the reports that B2C Commerce generates on production instances.
   2. Select the report to download.
   3. To compress the report file before you download it, click Compress.
   4. Click the report name to start the download.
4. Import a downloaded report into Microsoft Excel or another spreadsheet.
   These instructions can differ depending on the spreadsheet software that you use.
   1. Open the spreadsheet software.
   2. Click the Data tab.
   3. Click the From Text button.
   4. Find the downloaded file and click Import.
   5. On the Text Import Wizard - Step 1 of 3, keep these settings: Delimited, Start import at Row: 1, File origin: MS-DOS (PC-8).
   6. Click Next.
   7. On the Text Import Wizard - Step 2 of 3, select Comma as the delimiter and deselect tab.
   8. On the Text Import Wizard - Step 3 of 3, click Finish with no setting changes.
   9. Save the data in an existing or new worksheet.