Net sales are showing 0 in woocommerce stats
-
Net sales are showing 0 in woocommerce stats but we are receiving order daily. This issue occurs on 25 my 2023 and continues till now. What should I do to resolve it. I have tried to clear analytical cache, and importing historical data but this issue is same.
-
I have also imported historical data but this is not helping me out. The issue is still same, and there is no error in log
Hi @sabeelmansoof ,
Thanks for reaching out!
I understand that net sales are not being displayed, is that right?
I see that you have already tried importing historical data as well as clearing analytical cache, however, can you please do the following, in this exact order, and see if this resolves the issue:
- Navigate to Analytics → Settings, scroll down to Date type , and select Date Created on the dropdown:
- Navigate to WooCommerce → Status → Tools, and click on Clear Analytics Cache
- Import Historical Data
Cheers!
I tried importing historical data now my website is super slow also the issue is not solved still.
Hi @sabeelmansoof ,
Please can you share a copy of the following so that we can have a better understanding of your sites current environment:
- System Status Report: navigate to WooCommerce → Status. Select
Get system report
and thenCopy for support
. - Fatal Error log: Share a copy of any fatal error log (if any) found under WooCommerce → Status → Logs.
- Screenshot(s): Please share a screenshot(s) of exactly what you are seeing on your end
Snipboard.io can be used for easily sharing screenshots – please follow the instructions on that page, then paste the URL in this thread.
Once you have these, please share them in your response here.
Cheers!
Do i have to paste it here in this section? because i don’t see an option for submitting a file here.
@sabeelmansoof Feel free to copy the text and paste it inside a Code block in your next reply.
System report
` ### WordPress Environment ### WordPress address (URL): https://inspirelondoncollege.co.uk Site address (URL): https://inspirelondoncollege.co.uk WC Version: 7.8.0 REST API Version: ✔ 7.8.0 WC Blocks Version: ✔ 10.2.3 Action Scheduler Version: ✔ 3.5.4 Log Directory Writable: ✔ WP Version: 6.1.3 WP Multisite: – WP Memory Limit: 3 GB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: – ### Server Environment ### Server Info: Apache PHP Version: 8.1.18 PHP Post Max Size: 32 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.87.0 OpenSSL/1.1.1p SUHOSIN Installed: – MySQL Version: 5.7.42-cll-lve Max Upload Size: 32 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 7.8.0 WC Database Prefix: wp_ Total Database Size: 1262.54MB Database Data Size: 902.09MB Database Index Size: 360.45MB wp_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.41MB + Index: 0.13MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.16MB + Index: 1.14MB + Engine InnoDB wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_actionscheduler_actions: Data: 381.53MB + Index: 209.93MB + Engine MyISAM wp_actionscheduler_claims: Data: 0.22MB + Index: 0.78MB + Engine MyISAM wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_actionscheduler_logs: Data: 115.74MB + Index: 95.42MB + Engine MyISAM wp_aiowps_audit_log: Data: 7.52MB + Index: 0.34MB + Engine InnoDB wp_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_activity: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aiowps_login_lockdown: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_chaty_contact_form_leads: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_connection_reports: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_no_cookie_data: Data: 2.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_sessions: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_sfw: Data: 1.52MB + Index: 0.42MB + Engine InnoDB wp_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 2.52MB + Index: 1.17MB + Engine InnoDB wp_counter_box: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_db7_forms: Data: 6.52MB + Index: 0.00MB + Engine InnoDB wp_elfsight_social_icons_widgets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_expander_maker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_expm_hiiden_content: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_expm_maker: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_expm_maker_pages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_e_submissions: Data: 0.31MB + Index: 0.28MB + Engine MyISAM wp_e_submissions_actions_log: Data: 0.11MB + Index: 0.11MB + Engine MyISAM wp_e_submissions_values: Data: 0.87MB + Index: 0.42MB + Engine MyISAM wp_find_and_replace: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_fsmpt_email_logs: Data: 16.02MB + Index: 0.00MB + Engine InnoDB wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gf_entry: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gf_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_hustle_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_hustle_entries_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_hustle_modules: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_hustle_modules_meta: Data: 0.17MB + Index: 0.03MB + Engine InnoDB wp_hustle_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_litespeed_img_optm: Data: 0.13MB + Index: 0.06MB + Engine InnoDB wp_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_lockdowns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_login_fails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_qm_audit_trail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_questions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_question_terms: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mlw_quizzes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_quiz_theme_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_results: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mlw_themes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_newsletter: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_newsletter_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_newsletter_sent: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_newsletter_stats: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_options: Data: 37.47MB + Index: 2.73MB + Engine InnoDB wp_postmeta: Data: 28.55MB + Index: 13.03MB + Engine InnoDB wp_posts: Data: 9.42MB + Index: 0.98MB + Engine InnoDB wp_pps_countries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_pps_popup: Data: 1.52MB + Index: 0.00MB + Engine InnoDB wp_pps_popup_show_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_revslider_css: Data: 0.09MB + Index: 0.01MB + Engine MyISAM wp_revslider_css_bkp: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_revslider_sliders_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides: Data: 0.04MB + Index: 0.00MB + Engine MyISAM wp_revslider_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_revslider_static_slides_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_smush_dir_images: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_social_users: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_termmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.27MB + Index: 0.25MB + Engine InnoDB wp_term_relationships: Data: 0.22MB + Index: 0.13MB + Engine InnoDB wp_term_taxonomy: Data: 0.22MB + Index: 0.23MB + Engine InnoDB wp_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_uacf7_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_usermeta: Data: 27.50MB + Index: 18.92MB + Engine InnoDB wp_users: Data: 2.45MB + Index: 3.20MB + Engine InnoDB wp_wccs_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wccs_condition_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_admin_notes: Data: 0.07MB + Index: 0.00MB + Engine MyISAM wp_wc_admin_note_actions: Data: 0.04MB + Index: 0.01MB + Engine MyISAM wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_customer_lookup: Data: 0.45MB + Index: 0.36MB + Engine MyISAM wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_order_product_lookup: Data: 0.68MB + Index: 0.65MB + Engine MyISAM wp_wc_order_stats: Data: 0.46MB + Index: 0.29MB + Engine MyISAM wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.04MB + Index: 0.06MB + Engine MyISAM wp_wc_rate_limits: Data: 1.52MB + Index: 1.52MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfblockediplog: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfconfig: Data: 3.56MB + Index: 0.01MB + Engine MyISAM wp_wfcrawlers: Data: 0.01MB + Index: 0.01MB + Engine MyISAM wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wffilemods: Data: 18.85MB + Index: 1.91MB + Engine MyISAM wp_wfhits: Data: 0.90MB + Index: 0.09MB + Engine MyISAM wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfissues: Data: 0.09MB + Index: 0.01MB + Engine MyISAM wp_wfknownfilelist: Data: 14.30MB + Index: 0.60MB + Engine MyISAM wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wflocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wflogins: Data: 0.37MB + Index: 0.08MB + Engine MyISAM wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wfnotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM wp_wfpendingissues: Data: 0.11MB + Index: 0.01MB + Engine MyISAM wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wfstatus: Data: 0.39MB + Index: 0.15MB + Engine MyISAM wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wow_countdowns_free: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpfm_backup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_debug_events: Data: 0.09MB + Index: 0.00MB + Engine InnoDB wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpml_mails: Data: 209.64MB + Index: 0.00MB + Engine InnoDB wp_wppb: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wp_quiz_play_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.24MB + Index: 0.07MB + Engine MyISAM wp_yoast_seo_meta: Data: 0.55MB + Index: 0.58MB + Engine MyISAM wp_ywcdd_calendar: Data: 0.00MB + Index: 0.00MB + Engine MyISAM ### Post Type Counts ### accept_payments_wp: 1 acf-field: 26 acf-field-group: 2 aoc_popup: 1 attachment: 427 braintree_payment: 1 cartflows_flow: 1 cartflows_step: 2 cnf_mail_template: 1 cool_timeline: 2 copy-to-clipboard: 1 courses: 56 custom_css: 3 customize_changeset: 3 e-landing-page: 1 elementor_library: 42 elementskit_content: 15 elementskit_template: 2 jp_img_sitemap: 1 jp_sitemap: 1 jp_sitemap_master: 1 master-popups: 2 ml-slider: 1 nav_menu_item: 202 oembed_cache: 3 page: 96 popup: 5 popup_theme: 8 post: 19 product: 471 product_variation: 150 pw_bogo: 2 revision: 466 shop_coupon: 6 shop_order: 6593 shop_order_refund: 14 tabs_responsive: 1 team: 2 testimonial: 8 tribe_events: 8 tribe_organizer: 1 tribe_venue: 1 vc_settings_preset: 6 wc_product_table: 1 wp_global_styles: 2 wp_quiz: 1 wpautoterms_page: 1 wpcf7_contact_form: 16 wpcf7r_action: 2 wpcode: 2 wpforms: 1 wppopups: 2 xlwcty_thankyou: 2 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (34) ### Elementor Pro: by Elementor.com – 3.5.2 Advanced Custom Fields: by WP Engine – 6.1.6 FiboSearch - AJAX Search for WooCommerce: by FiboSearch Team – 1.24.0 All-in-One WP Migration: by ServMask – 7.75 All In One WP Security: by All In One WP Security & Firewall Team – 5.1.9 Chaty Pro: by Premio – 2.1.2 Classic Editor: by WordPress Contributors – 1.6.3 Anti-Spam by CleanTalk: by СleanTalk – 6.11.2 Contact Form 7: by Takayuki Miyoshi – 5.7.7 Contact Form CFDB7: by Arshid – 1.2.6.5 Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.4.8 Crisp: by Crisp – 0.43 Disable All WordPress Updates: by Oliver Schlöbe – 1.7.1 Dynamic.ooo - Dynamic Content for Elementor: by Dynamic.ooo – 2.2.8 Elementor: by Elementor.com – 3.13.4 ElementsKit Lite: by Wpmet – 2.8.8 Read More: by Edmon – 3.1.7 Featured Image by URL: by Knawat – 1.1.7 FluentSMTP: by FluentSMTP & WPManageNinja Team – 2.2.4 WPCode Lite: by WPCode – 2.0.12 Meta Box: by MetaBox.io – 5.7.2 PRO Elements: by PROElements.org – 3.8.0 Really Simple SSL: by Really Simple Plugins – 7.0.5 Side Cart WooCommerce: by XootiX – 2.2 10Web Booster: by 10Web - Website speed optimization team – 2.21.25 Extended Order Details for WooCommerce: by Fahad Mahmood – 2.0.0 WooCommerce Product Table Lite: by WC Product Table – 2.6.1 Thanks Redirect for WooCommerce: by Nitin Prakash – 3.1 Payment Plugins Braintree For WooCommerce: by Payment Plugins support@paymentplugins.com – 3.2.44 WooCommerce: by Automattic – 7.8.0 Yoast SEO Premium: by Team Yoast – 6.1 WP File Manager: by mndpsingh287 – 7.1.9 WP Mail Logging: by WP Mail Logging Team – 1.11.2 YITH WooCommerce Name Your Price: by YITH – 1.3.0 ### Inactive Plugins (1) ### Site Kit by Google: by Google – 1.103.0 ### Dropin Plugins (1) ### advanced-cache.php: advanced-cache.php ### Must Use Plugins (1) ### Elementor Safe Mode: by Elementor.com – 1.0.0 ### Settings ### API Enabled: ✔ Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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: – Enforce Approved Product Download Directories: – HPOS feature screen enabled: – HPOS feature enabled: – Order datastore: WC_Order_Data_Store_CPT HPOS data sync enabled: – ### WC Pages ### Shop base: #1949 - /shop/ Basket: ❌ Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block. Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block. My account: #1954 - /my-account/ Terms and conditions: #776 - /terms-conditions/ ### Theme ### Name: Hello Elementor Version: 2.6.1 (update to version 2.7.1 is available) Author URL: https://elementor.com/?utm_source=wp-themes&utm_campaign=author-uri&utm_medium=wp-dash Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔ ### Templates ### Overrides: hello-elementor/woocommerce/emails/admin-new-order.php hello-elementor/woocommerce/emails/customer-new-account.php ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page Disabled Features: core-profiler minified-js new-product-management-experience product-variation-management settings async-product-editor-category-field Daily Cron: ✔ Next scheduled: 2023-06-24 05:12:20 +00:00 Options: ✔ Notes: 144 Onboarding: completed ### Action Scheduler ### Complete: 6,670 Oldest: 2023-05-23 10:52:38 +0000 Newest: 2023-06-18 04:20:57 +0000 Pending: 1,812,615 Oldest: 2023-05-25 23:49:35 +0000 Newest: 2023-06-23 10:49:24 +0000 Failed: 104,843 Oldest: 2023-03-02 04:43:49 +0000 Newest: 2023-06-23 10:48:21 +0000 ### Status report information ### Generated at: 2023-06-23 10:49:59 +00:00 `
My site especially backend of website is super slow after trying to import this historical data.
Thanks for sharing that! I see that your site is still running on WordPress version 6.1.4. Please consider upgrading to the latest version, 6.2.2.
https://wordpress.org/download/
My site especially backend of website is super slow after trying to import this historical data.
The process may have stalled at some point. Can you please try going to WooCommerce > Status > Tools > Clear analytics cache, click Clear, and check your site again?
If the site is still slow, check under WooCommerce > Status > Scheduled Actions to see if any stuck processes are preventing the updated information from being imported.
I can see that your site’s database is a bit huge at >1GB, so that may be contributing to the issue at hand.
I have done with all suggestions you provided, but my site’s database was ok before importing historical data, my site’s size was only 2Gb but after doing a single thing (importing historical data) it becomes 3.3Gb so for sure it is just because of this action. Kindly tell me how to reduce this.
@sabeelmansoof you may need to go to WooCommerce > Status > Tools > Clear Analytics Cache and clear the cache. Then, go to WooCommerce > Status > Tools and delete all transients. Let us know if that helps.
I have cleared Analytics Cache and there is no option of delete all transient, there was only two options clear woocommerce transient and expired transient. I just cleared expired transient but this didn’t help me either.
@sabeelmansoof Try going to Analytics > Settings and click “Delete Previously Imported Data” at the bottom of the page.
I tried this too but nothing happens. site dashboard is still too much slow.
@sabeelmansoof Can you share your fatal error log as per https://woocommerce.com/document/finding-php-error-logs/#woocommerce-fatal-errors-log ?
There are a lot of fatal error logs with dates. Do I have to share the recent one? or all?
- The topic ‘Net sales are showing 0 in woocommerce stats’ is closed to new replies.