Analytics and Reports with Different Data
-
Hello friends!
I’m trying to get some Reports data using the Rest API. However, whenever I got the data, it was simply not matching the Analytics panel. It took me a while to figure that the information is actually matching the old REPORTS panel, instead of the analytics panel.
So, basically, the Reports and Analytics panel are showing different info. It makes no sense. We had some sales yesterday and the day before, but the reports panel show Zero and, therefore, the REST API returns zero sales.
How can this be fixed? Why the reports panel shows zero sales, when there has been sales with actual value? Can you help me fix the Reports panel or, maybe, pull the info that is shown in the Analytics panel?
Screenshots are attached:
Analytics Panel: https://snipboard.io/7HCJOz.jpg#:~:text=snipboard.io/7HCJOz.jpg
Reports Panel: https://snipboard.io/9OPCN7.jpg
Thanks in advance!
-
Hello thebrunomaya,
Thank you for contacting WooCommerce support.
I understand you’re trying to pull sales data using the REST API, but the information retrieved matches the old Reports panel instead of the Analytics panel. You also mentioned that recent sales show up in Analytics, but the Reports panel and API return zero sales.
Is this problem consistent for different periods?
Please check different options like the last 7 days, last month, and a custom range.I checked my test site and I see correct information in both the Reports panel and Analytics panel.
Here are the screenshots:
1- Reports panel
2- Analytics panelCould you navigate to WooCommerce > Status > Tools?
Look for the option to Reimport Historical Data, it can help resolve missing or inaccurate values in the Analytics reports.To help you further, I’d like to understand more about your setup.
Could you please send me a copy of your site’s System Status Report?
You can find it via WooCommerce > Status.
Select Get system report and then Copy for support.Looking forward to your response. ??
Hello Zubair!
I appreciate your help very much.
About Reimportint Historical Data, the option does not work for me: https://snipboard.io/ThGEZ6.jpg
I already tried clearing analytics cache, but nothing happens.
About comparing on same period, here are both on same period:
Analytics “This Month”: https://snipboard.io/LJrn0s.jpg
Reports “This Month”: https://snipboard.io/TdMUAJ.jpg
I have no idea what is causing this, but it is happening on two installations of mine. I hope we can fix on this one and maybe I’ll learn to fix the issue on the other too.
I hope you can help me!
Thanks again in advance.
About the system info, here it goes:
System Info:
WordPress Environment<br><br>WordPress address (URL): https://gateway1.clinicaseven.com.br<br>Site address (URL): https://gateway1.clinicaseven.com.br<br>WC Version: 9.5.1<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.8.2<br>Log Directory Writable: ?<br>WP Version: 6.7.1<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: pt_BR<br>External object cache: ? Server Environment<br><br>Server Info: Apache/2.4.62 (Debian)<br>PHP Version: 8.1.31<br>PHP Post Max Size: 50 MB<br>PHP Time Limit: 60<br>PHP Max Input Vars: 2500<br>cURL Version: 7.74.0<br>OpenSSL/1.1.1w<br><br>SUHOSIN Installed: –<br>MySQL Version: 10.6.20-MariaDB-deb11-log<br>Max Upload Size: 50 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 9.5.1<br>WC Database Prefix: wp_<br>Tamanho total do banco de dados: 27.77MB<br>Tamanho dos dados do banco de dados: 24.35MB<br>Tamanho do índice do banco de dado: 3.42MB<br>wp_woocommerce_sessions: Dados: 1.25MB + índex: 0.02MB + mecanismo InnoDB<br>wp_woocommerce_api_keys: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_woocommerce_attribute_taxonomies: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_woocommerce_downloadable_product_permissions: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_woocommerce_order_items: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_woocommerce_order_itemmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_woocommerce_tax_rates: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_woocommerce_tax_rate_locations: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_woocommerce_shipping_zones: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_woocommerce_shipping_zone_locations: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_woocommerce_shipping_zone_methods: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_woocommerce_payment_tokens: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_woocommerce_payment_tokenmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_woocommerce_log: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_actionscheduler_actions: Dados: 0.06MB + índex: 0.11MB + mecanismo InnoDB<br>wp_actionscheduler_claims: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_actionscheduler_groups: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_actionscheduler_logs: Dados: 0.05MB + índex: 0.03MB + mecanismo InnoDB<br>wp_bwf_ab_experiments: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_bwf_contact: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_bwf_contact_meta: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_bwf_conversion_tracking: Dados: 0.02MB + índex: 0.39MB + mecanismo InnoDB<br>wp_bwf_funnelmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_bwf_funnels: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_bwf_optin_entries: Dados: 0.02MB + índex: 0.08MB + mecanismo InnoDB<br>wp_bwf_wc_customers: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_commentmeta: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_comments: Dados: 0.02MB + índex: 0.09MB + mecanismo InnoDB<br>wp_csshero5: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_e_events: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_e_submissions: Dados: 0.02MB + índex: 0.27MB + mecanismo InnoDB<br>wp_e_submissions_actions_log: Dados: 0.02MB + índex: 0.11MB + mecanismo InnoDB<br>wp_e_submissions_values: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_getnet_api: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_getnet_api_token: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_links: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_options: Dados: 3.03MB + índex: 0.06MB + mecanismo InnoDB<br>wp_postmeta: Dados: 9.50MB + índex: 0.06MB + mecanismo InnoDB<br>wp_posts: Dados: 2.09MB + índex: 0.06MB + mecanismo InnoDB<br>wp_retentativas_log: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_revslider_css: Dados: 0.13MB + índex: 0.02MB + mecanismo InnoDB<br>wp_revslider_layer_animations: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_revslider_navigations: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_revslider_sliders: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_revslider_sliders7: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_revslider_slides: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_revslider_slides7: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_revslider_static_slides: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_shortpixel_folders: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_shortpixel_meta: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_shortpixel_postmeta: Dados: 0.02MB + índex: 0.08MB + mecanismo InnoDB<br>wp_shortpixel_queue: Dados: 0.02MB + índex: 0.09MB + mecanismo InnoDB<br>wp_snippets: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_termmeta: Dados: 6.52MB + índex: 0.03MB + mecanismo InnoDB<br>wp_terms: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_term_relationships: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_term_taxonomy: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_usermeta: Dados: 0.05MB + índex: 0.03MB + mecanismo InnoDB<br>wp_users: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB<br>wp_wc_admin_notes: Dados: 0.06MB + índex: 0.00MB + mecanismo InnoDB<br>wp_wc_admin_note_actions: Dados: 0.05MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wc_category_lookup: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_wc_customer_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_download_log: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_orders: Dados: 0.02MB + índex: 0.11MB + mecanismo InnoDB<br>wp_wc_orders_meta: Dados: 0.06MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_order_addresses: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_wc_order_coupon_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_order_operational_data: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_order_product_lookup: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_wc_order_stats: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB<br>wp_wc_order_tax_lookup: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wc_product_attributes_lookup: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wc_product_download_directories: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wc_product_meta_lookup: Dados: 0.02MB + índex: 0.11MB + mecanismo InnoDB<br>wp_wc_rate_limits: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wc_reserved_stock: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_wc_tax_rate_classes: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wc_webhooks: Dados: 0.02MB + índex: 0.02MB + mecanismo InnoDB<br>wp_wfacp_stats: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_wfco_report_views: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB<br>wp_wfob_stats: Dados: 0.02MB + índex: 0.06MB + mecanismo InnoDB<br>wp_wfocu_event: Dados: 0.02MB + índex: 0.05MB + mecanismo InnoDB<br>wp_wfocu_event_meta: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_wfocu_session: Dados: 0.02MB + índex: 0.03MB + mecanismo InnoDB<br>wp_wpmailsmtp_debug_events: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB<br>wp_wpmailsmtp_tasks_meta: Dados: 0.02MB + índex: 0.00MB + mecanismo InnoDB Post Type Counts<br><br>attachment: 58<br>elementor_font: 3<br>elementor_library: 4<br>page: 3<br>post: 1<br>product: 1<br>revision: 69<br>shop_coupon: 1<br>shop_order_placehold: 7<br>wfacp_checkout: 1<br>wffn_ty: 1<br>wp_font_face: 36<br>wp_font_family: 12<br>wp_global_styles: 1<br>wp_navigation: 1 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (21)<br><br>Admin Menu Editor Pro: por Janis Elsts – 2.26.1<br>Preenchimento Automático de Endere?o no WooCommerce: por Fernando Acosta – 1.3.2<br>Breeze: por Cloudways – 2.2.0<br>Code Snippets Pro (Premium): por Code Snippets Pro – 3.6.6.1<br>CSS Hero: por The CSS Hero Team – 5.1.0<br>Doubly Pro: por Unlimited Elements – 1.0.45<br>Elementor Pro: por Elementor.com – 3.26.2<br>Elementor: por Elementor.com – 3.26.3<br>Enable Media Replace: por ShortPixel – 4.1.5<br>FunnelKit Funnel Builder Pro: por FunnelKit – 3.8.1<br>FunnelKit Funnel Builder: por FunnelKit – 3.8.0<br>GPLVault Update Manager: por GPL Vault – 5.2.4<br>Getnet API - Loja5: por Loja5.com.br – 4.0<br>Object Cache Pro: por Rhubarb Group – 1.21.3<br>Slider Revolution: por ThemePunch – 6.7.25<br>Otimizador de imagens ShortPixel: por ShortPixel - Convert WebP/AVIF & Optimize Images – 6.0.4<br>WooCommerce Boleto e PIX PagHiper: por PagHiper Pagamentos – 2.3.3<br>Brazilian Market on WooCommerce: por Claudio Sanches – 4.0.2<br>WooCommerce Sequential Order Numbers Pro: por SkyVerge – 1.21.3<br>WooCommerce: por Automattic – 9.5.1<br>WP Mail SMTP Pro: por WP Mail SMTP – 4.3.0 Inactive Plugins (0) Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php<br>object-cache.php: Object Cache Pro (Drop-in) Settings<br><br>Legacy API Enabled: –<br>Force SSL: –<br>Currency: BRL (R$)<br>Currency Position: left_space<br>Thousand Separator: .<br>Decimal Separator: ,<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: ?<br>Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 dias<br>Level threshold: –<br>Log directory size: 65 KB WC Pages<br><br>Base da loja: ? Página n?o definida<br>Carrinho: ? O ID da página foi definido<br>mas a página n?o existe<br><br>Finaliza??o de compra: ? O ID da página foi definido<br>mas a página n?o existe<br><br>Minha conta: ? O ID da página foi definido<br>mas a página n?o existe<br><br>Termos e condi??es: ? Página n?o definida Theme<br><br>Name: Hello Elementor Child<br>Version: 2.0.0<br>Author URL: https://elementor.com/<br>Child Theme: ?<br>Parent Theme Name: Hello Elementor<br>Parent Theme Version: 3.2.1<br>Parent Theme Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash<br>Theme type: Classic theme<br>WooCommerce Support: ? Templates<br><br>Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>onboarding<br>onboarding-tasks<br>pattern-toolkit-full-composability<br>product-custom-fields<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>printful<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br>launch-your-store<br><br>Disabled Features: product-data-views<br>experimental-blocks<br>coming-soon-newsletter-template<br>minified-js<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>product-editor-template-system<br>blueprint<br>reactify-classic-payments-settings<br>use-wp-horizon<br>add-to-cart-with-options-stepper-layout<br><br>Daily Cron: ? Next scheduled: 2025-01-08 00:44:46 -03:00<br>Options: ?<br>Notes: 60<br>Onboarding: skipped Action Scheduler<br><br>Concluído: 75<br>Oldest: 2024-12-28 00:45:59 +0000<br>Newest: 2025-01-07 13:55:18 +0000<br><br>Malsucedido: 2<br>Oldest: 2024-12-28 01:08:50 +0000<br>Newest: 2024-12-30 17:16:21 +0000<br><br>Pendente: 4<br>Oldest: 2025-01-08 10:39:44 +0000<br>Newest: 2025-01-12 08:00:07 +0000 Status report information<br><br>Generated at: 2025-01-07 19:54:06 -03:00<br>
Hi @thebrunomaya,
Thank you for sharing the additional information and your System Status Report. After reviewing the report, I noticed that your Store base, Cart, Checkout, and My Account pages are missing and no longer exist.
It seems like the page IDs are still there, but the pages have been deleted, which could be causing a conflict. This also raises the question of how users are able to complete the checkout process if the page is missing.
Additionally, I saw that you have several addons installed on your site. To help diagnose the issue, could you try a conflict test by disabling all plugins except for WooCommerce and see if the problem persists? If it does, please switch to the Storefront theme and check again.
I suspect that one of your plugins might be causing a conflict.
Hello Moses!
Simple question: is WooCommerce Reports compatible with the latest versions of WooCommerce? Is it compatible with HPOS?
I run many WooCommerce installations and it seems that the WooCommerce Reports is not working on the latest ones.
Is it possible to retrieve ANALYTICS (not reports) information through API?
Thanks in advance!
Hello thebrunomaya,
Thank you for your reply.
Simple question: is WooCommerce Reports compatible with the latest versions of WooCommerce? Is it compatible with HPOS?
Even though the WooCommerce Reports was deprecated with the release of WooCommerce 4.0 in March 2020, it still works fine with the latest WooCommerce version and HPOS.
I have confirmed this by testing it on my site with default settings. I also shared a Reports panel screenshot in my last message which shows the same data as Analytics.Is it possible to retrieve ANALYTICS (not reports) information through API?
Retrieving the newer analytics data introduced in WooCommerce Admin isn’t natively supported through the standard REST API endpoints.
Feel free to contact us again if you have more questions or concerns.
We are here to help ??Best regards.
- You must be logged in to reply to this topic.