• Resolved josegallo

    (@josegallo)


    Hi,
    The analysis reports section is not working correctly. It takes all the orders included not finished orders (pending orders, failed orders ..). The legacy report is working correctly though. On screenshots, you can see the number of orders on Analysis is 422 and on Legacy Report 315 (the paid orders). The same is happening for total sales, gross sales, and net sales: is considering all orders, included abandoned orders. The errors can be observed easily on Revenues, Summary and Order (attaching screenshots of Analysis and Legacy Report here:https://imgur.com/a/vpZWCSG)
    Please, could you help us?
    Thanks indeed
    Adding the status

    Status:
    `
    ### WordPress Environment ###

    WordPress address (URL): https://tienda.davidmoreno.es
    Site address (URL): https://tienda.davidmoreno.es
    WC Version: 4.8.0
    REST API Version: ? 4.8.0
    WC Blocks Version: ? 3.8.1
    Action Scheduler Version: ? 3.1.6
    WC Admin Version: ? 1.7.3
    Log Directory Writable: ?
    WP Version: ? 5.5.3 – Hay una versión nueva de WordPress disponible (5.6)
    WP Multisite: –
    WP Memory Limit: 1 GB
    WP Debug Mode: ?
    WP Cron: ?
    Language: es_ES
    External object cache: –

    ### Server Environment ###

    Server Info: Apache
    PHP Version: 7.3.25
    PHP Post Max Size: 512 MB
    PHP Time Limit: 120
    PHP Max Input Vars: 20000
    cURL Version: 7.71.0
    OpenSSL/1.1.1d

    SUHOSIN Installed: –
    MySQL Version: 5.5.5-10.3.25-MariaDB-cll-lve
    Max Upload Size: 128 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?

    ### Database ###

    WC Database Version: 4.8.0
    WC Database Prefix: w47fa_
    Tama?o total de la base de datos: 177.95MB
    Tama?o de los datos de la base de datos: 159.12MB
    Tama?o del índice de la base de datos: 18.83MB
    w47fa_woocommerce_sessions: Datos: 1.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
    w47fa_woocommerce_order_items: Datos: 0.14MB + índice: 0.06MB + Motor InnoDB
    w47fa_woocommerce_order_itemmeta: Datos: 1.52MB + índice: 0.63MB + Motor InnoDB
    w47fa_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
    w47fa_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_actionscheduler_actions: Datos: 2.02MB + índice: 0.34MB + Motor InnoDB
    w47fa_actionscheduler_claims: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_actionscheduler_groups: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_actionscheduler_logs: Datos: 1.02MB + índice: 0.19MB + Motor InnoDB
    w47fa_aiowps_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_aiowps_failed_logins: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_aiowps_global_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_aiowps_login_activity: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_aiowps_login_lockdown: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_aiowps_permanent_block: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_appointments: Datos: 0.05MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_categories: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_coupons: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_coupons_to_events: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_coupons_to_services: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_customer_bookings: Datos: 0.17MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_customer_bookings_to_events_periods: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_customer_bookings_to_extras: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_custom_fields: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_custom_fields_events: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_custom_fields_options: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_custom_fields_services: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_events: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_events_periods: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_events_tags: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_events_to_providers: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_extras: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_galleries: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_locations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_locations_views: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_notifications: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
    w47fa_amelia_notifications_log: Datos: 0.06MB + índice: 0.06MB + Motor InnoDB
    w47fa_amelia_notifications_sms_history: Datos: 2.52MB + índice: 0.09MB + Motor InnoDB
    w47fa_amelia_payments: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_providers_to_daysoff: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_providers_to_events: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_google_calendar: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_providers_to_locations: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_outlook_calendar: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_providers_to_periods: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_periods_services: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_services: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_specialdays: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_providers_to_specialdays_periods: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_specialdays_periods_services: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
    w47fa_amelia_providers_to_timeouts: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_providers_to_weekdays: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_providers_views: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_services: Datos: 0.05MB + índice: 0.02MB + Motor InnoDB
    w47fa_amelia_services_views: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_amelia_users: Datos: 0.09MB + índice: 0.08MB + Motor InnoDB
    w47fa_commentmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_comments: Datos: 0.33MB + índice: 0.39MB + Motor InnoDB
    w47fa_icl_content_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_core_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_flags: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_languages: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_icl_languages_translations: Datos: 0.20MB + índice: 0.13MB + Motor InnoDB
    w47fa_icl_locale_map: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_message_status: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_icl_mo_files_domains: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_node: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_reminders: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_strings: Datos: 3.52MB + índice: 5.61MB + Motor InnoDB
    w47fa_icl_string_packages: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_string_pages: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_icl_string_positions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_string_status: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_string_translations: Datos: 0.42MB + índice: 0.19MB + Motor InnoDB
    w47fa_icl_string_urls: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_translate: Datos: 5.31MB + índice: 0.09MB + Motor InnoDB
    w47fa_icl_translate_job: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_icl_translations: Datos: 0.13MB + índice: 0.36MB + Motor InnoDB
    w47fa_icl_translation_batches: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_translation_downloads: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_icl_translation_status: Datos: 3.27MB + índice: 0.02MB + Motor InnoDB
    w47fa_links: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_options: Datos: 10.02MB + índice: 1.17MB + Motor InnoDB
    w47fa_postmeta: Datos: 98.39MB + índice: 5.75MB + Motor InnoDB
    w47fa_posts: Datos: 25.23MB + índice: 0.59MB + Motor InnoDB
    w47fa_redirection_404: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
    w47fa_redirection_groups: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_redirection_items: Datos: 0.02MB + índice: 0.09MB + Motor InnoDB
    w47fa_redirection_logs: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB
    w47fa_revslider_css: Datos: 0.13MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_css_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_layer_animations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_layer_animations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_navigations: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_navigations_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_sliders: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_sliders_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_slides: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_static_slides: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_revslider_static_slides_bkp: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_termmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_terms: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_term_relationships: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
    w47fa_term_taxonomy: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_usermeta: Datos: 0.52MB + índice: 0.44MB + Motor InnoDB
    w47fa_users: Datos: 0.06MB + índice: 0.05MB + Motor InnoDB
    w47fa_wc_admin_notes: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wc_admin_note_actions: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_wc_category_lookup: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wc_customer_lookup: Datos: 0.09MB + índice: 0.06MB + Motor InnoDB
    w47fa_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_wc_order_coupon_lookup: Datos: 0.06MB + índice: 0.06MB + Motor InnoDB
    w47fa_wc_order_product_lookup: Datos: 0.11MB + índice: 0.06MB + Motor InnoDB
    w47fa_wc_order_stats: Datos: 0.09MB + índice: 0.08MB + Motor InnoDB
    w47fa_wc_order_tax_lookup: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
    w47fa_wc_product_meta_lookup: Datos: 0.05MB + índice: 0.09MB + Motor InnoDB
    w47fa_wc_reserved_stock: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
    w47fa_wdr_order_discounts: Datos: 0.17MB + índice: 0.00MB + Motor InnoDB
    w47fa_wdr_order_item_discounts: Datos: 0.06MB + índice: 0.00MB + Motor InnoDB
    w47fa_wdr_rules: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wpdatacharts: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wpdatatables: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
    w47fa_wpdatatables_columns: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB

    ### Post Type Counts ###

    attachment: 677
    custom_css: 1
    elementor_icons: 1
    elementor_library: 108
    mc4wp-form: 2
    nav_menu_item: 113
    page: 115
    post: 9
    product: 135
    product_variation: 70
    revision: 2574
    shop_coupon: 13
    shop_order: 803
    shop_order_refund: 16
    tablepress_table: 2
    tribe_events: 8
    tribe_organizer: 2
    tribe_venue: 1
    vc_settings_preset: 4

    ### Security ###

    Secure connection (HTTPS): ?
    Hide errors from visitors: ?

    ### Active Plugins (34) ###

    WPML Multilingual CMS: por OnTheGoSystems – 4.3.19
    Admin Menu Editor: por Janis Elsts – 1.9.8
    Advanced Custom Fields PRO: por Elliot Condon – 5.8.2
    Age Checker: por Themeware – 1.2.0
    Amelia: por TMS – 2.9.2
    Ceca Gateway for WooCommerce: por codection – 2.3
    Join.chat: por Creame – 4.1.7
    David Moreno S: por David Moreno – 1.0.0
    David Moreno GE: por David Moreno – 1.2.11 – Versión instalada no está probada con la versión activa de WooCommerce 4.0
    David Moreno J: por – 1.0.20
    Disable Gutenberg: por Jeff Starr – 2.3
    Elementor Pro: por Elementor.com – 2.10.3
    Elementor: por Elementor.com – 3.0.15
    Envato Market: por Envato – 2.0.6
    Insert Headers and Footers: por WPBeginner – 1.5.0
    WPBakery Page Builder: por Michael M – WPBakery.com – 6.0.5
    Loco Translate: por Tim Whitlock – 2.5.0
    OKThemes Villenoir Shortcodes: por Gogoneata Cristian – 1.8
    Virtual Robots.txt: por Marios Alexandrou – 1.9
    RedSys Gateway for WooCommerce Pro: por codection – 3.4.4
    Slider Revolution: por ThemePunch – 6.0.9
    TablePress: por Tobias B?thge – 1.12
    User Role Editor: por Vladimir Garagulya – 4.57.1
    WE-Varnish-Cache: por David (Webempresa.com) – 0.1.2
    Checkout Field Editor for WooCommerce: por ThemeHigh – 1.4.5
    Woo Discount Rules PRO 2.0: por Flycart Technologies LLP – 2.3.2
    Woo Discount Rules: por Flycart Technologies LLP – 2.3.3
    Print Invoice & Delivery Notes for WooCommerce: por Tyche Softwares – 4.6.2
    WooCommerce Stripe Gateway: por WooCommerce – 4.7.0
    WooCommerce Multilingual: por OnTheGoSystems – 4.10.4
    WooCommerce: por Automattic – 4.8.0
    WP Crontrol: por John Blackbourn & crontributors – 1.9.0
    WPML String Translation: por OnTheGoSystems – 3.0.14
    WPML Translation Management: por OnTheGoSystems – 2.9.11

    ### Inactive Plugins (8) ###

    All In One WP Security: por Tips and Tricks HQ
    Peter Petreski
    Ruhul
    Ivy – 4.4.6

    David Moreno J: por – 1.0.14
    Essential Addons for Elementor: por WPDeveloper – 4.3.9
    Redirection: por John Godley – 4.9.2
    wpDataTables: por TMS-Plugins – 3.0.1
    WPML Media: por OnTheGoSystems – 2.5.6
    WP phpMyAdmin: por Puvox.software – 5.0.4.1
    Yoast Duplicate Post: por Enrico Battocchi & Team Yoast – 3.2.6

    ### Settings ###

    API Enabled: ?
    Force SSL: –
    Currency: EUR (€)
    Currency Position: right
    Thousand Separator: .
    Decimal Separator: ,
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    variable (variable)

    Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
    exclude-from-search (exclude-from-search)
    featured (featured)
    outofstock (outofstock)
    rated-1 (rated-1)
    rated-2 (rated-2)
    rated-3 (rated-3)
    rated-4 (rated-4)
    rated-5 (rated-5)

    Connected to WooCommerce.com: –

    ### WC Pages ###

    Base de la tienda: #1272 – /
    Carrito: #1273 – /carrito/
    Finalizar compra: #1274 – /finalizar-compra/
    Mi cuenta: #1275 – /mi-cuenta/
    Términos y condiciones: ? Página sin definir

    ### Theme ###

    Name: Villenoir
    Version: 5.1
    Author URL: https://www.okthemes.com
    Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
    te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo

    WooCommerce Support: ?

    ### Templates ###

    Archive Template: Tu tema tiene un archivo woocommerce.php
    no podrás sobreescribir la plantilla personalizada woocommerce/archive-product.php ya que woocommerce.php tiene prioridad sobre archive-product.php. Esto es intencionado para prevenir problemas de visualización.

    Overrides: villenoir/woocommerce/cart/cart-totals.php
    villenoir/woocommerce/cart/cart.php
    villenoir/woocommerce/checkout/form-checkout.php
    villenoir/woocommerce/checkout/form-coupon.php
    villenoir/woocommerce/content-product.php
    villenoir/woocommerce/content-single-product.php
    villenoir/woocommerce/loop/loop-end.php
    villenoir/woocommerce/loop/loop-start.php
    villenoir/woocommerce/loop/price.php
    villenoir/woocommerce/single-product/price.php
    villenoir/woocommerce/single-product/title.php
    villenoir/woocommerce/content-product_cat.php

    ### Action Scheduler ###

    Completo: 571
    Oldest: 2020-12-10 13:18:15 +0100
    Newest: 2021-01-08 16:57:47 +0100

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Analysis not working (including abandoned carts on sales reports)’ is closed to new replies.