Explaining Differences in Magento Sales and Advanced Reports

Why do Magento Sales report and Orders report by Advanced Reports contain different data?

By default, data in Magento reports does not align with the data in our Advanced Reports module. This discrepancy arises from the differences in how data is displayed across various reports within Magento.

The Sales Orders Report can be found under Reports > Sales > Orders, reflecting data from Magento's standard reporting system.
Our Advanced Reports are accessible via Reports > Advanced Reports > Advanced Reports > Orders, as part of our module specifically designed to provide more in-depth insights.

One of the main distinctions is that the Magento default report typically omits orders with a "Pending" status. In contrast, our Advanced Reports take into account all order statuses, offering a more comprehensive overview of your sales data.  




      • Related Articles

      • Advanced Reports API

        We have created a public API collection for Advanced Reports module with all available queries and sample data that you can both test via our demo endpoints and copy to run local tests in your Magento environment. More details about using public ...
      • How do I restore anonymized data to process the incoming orders?

        Once the customer submits the anonymization request from their account settings, it is approved automatically without any option to restore the anonymized data. The extension settings allow preventing data anonymization for the specific order ...
      • Can I create a report using fields from Affiliate extension?

        Since v.2.5.0 Affiliate extension is compatible with Custom Reports Builder module, enabling Affiliate entities for report creation. You can find the 'amasty/module-affiliate-to-builder-by-amasty' package for installing in composer suggest. Please ...
      • Advanced Search API

        We have created a public API collection for Advanced Search module with all available queries and sample data that you can both test via our demo endpoints and copy to run local tests in your Magento environment. More details about using public ...
      • Will the module help speed up the loading of Sales Order grid?

        The archive is located in tables that are separate from the default Magento ones. During installation, the module creates the tables that copy the structure of sales_order_grid, sales_invoice_grid, sales_shippment_grid, and sales_creditmemo_grid. ...