Example GMV Calculation

Salesforce B2C Commerce customers often need to run the GMV report to re-calculate their B2C Commerce Invoices. These reports can be automated.

While B2C Commerce captures GMV data on Production, the GMV generation job is disabled on Development and Sandbox instances.

Note: See Taxation Impact On Subscription Fees to understand how tax calculations can significantly impact the subscription fees that you pay.
Note: The Business Manager Analytics module is available on all instance types. However, it's intended to be used on Production instances to reflect real revenue. The auto-generated reports are only generated on production instances.

The following instructions provide the steps necessary to run this report.

  1. Select Administration > Operations > GMV Reports.
    Report status appears in the Status section. Click Refresh to refresh your view as reports run.
  2. On the GMV Reports page, click Download in the Auto-Generated Reports section to download the auto-generated GMV reports.
  3. On the Manage Exports File page, open the report and save it as a .csv file to your PC.
    You can also configure your PC to automatically open the file in Excel (or another spreadsheet) when you click the report's file name.
  4. Open Microsoft® Excel or another spreadsheet software.
    1. Click the Data tab.
    2. Click the From Text button
    3. Find the downloaded file and click Import.
    4. On the Text Import Wizard - Step 1 of 3, keep the following settings: Delimited, Start import at Row: 1, File origin: MS-DOS (PC-8).
    5. Click Next.
    6. On the Text Import Wizard - Step 2 of 3, select Comma as the delimiter (de-select tab).
    7. On the Text Import Wizard - Step 3 of 3, click Finish with no setting changes.
    8. Save the data in an existing or new worksheet.
    These instructions might differ from what you see depending on the version of Excel or the spreadsheet software that you use.