Issue with WooCommerce sales analytics

Resolved blagojgjelevski
(@blagojgjelevski)

2 years, 1 month ago

Hello,

I have issue with the WooCommerce sales analytics (WooCommerce > Dashboard). Last 5 days, although there is sales through the website, in the revenue analytics, I see 0 sales reported. The sales are shown in the orders section, but does not appear in the sales analytics.

Please advice what could cause this issue?

Thanks,

Blagoj

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

Viewing 6 replies - 1 through 6 (of 6 total)

Plugin Support

Jess – a11n

(@jlundie)

2 years, 1 month ago

Hi Blagoj,

Sorry you’re seeing this discrepancy in your site analytics!

Could you please share a copy of your site’s System Status? You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

Thank you!

marcusdahlberg83

(@marcusdahlberg83)

2 years, 1 month ago

I have the exact same issue. The orders get registered in “orders” – but nothing on the dashboard. Been like this on and of during the entire month of may. Some orders seems to get added to the analytics dashboard, but far from all of them. Last 3 days we hade around 17-18 orders, but in the dashboard view is a straight line at 0?

Plugin Support

Jess – a11n

(@jlundie)

2 years ago

Hi @marcusdahlberg83 –

Sorry to hear you are also seeing this issue.

Thank you!

Thread Starter

blagojgjelevski

(@blagojgjelevski)

2 years ago

Sorry for my late reply. Here is the system status:


### WordPress Environment ###

WordPress address (URL): https://floreo.mk
Site address (URL): https://floreo.mk
WC Version: 4.1.1
REST API Version: ✔ 1.0.7
WC Blocks Version: ✔ 2.5.16
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.1.3
Log Directory Writable: ✔
WP Version: 5.4.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ✔
Language: mk_MK
External object cache: ✔

### Server Environment ###

Server Info: Apache
PHP Version: 7.3.16
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.59.0
OpenSSL/1.0.2r

SUHOSIN Installed: –
MySQL Version: 5.6.40-84.0-log
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.1.1
WC Database Prefix: wpmh_
Total Database Size: 24.42MB
Database Data Size: 18.00MB
Database Index Size: 6.42MB
wpmh_woocommerce_sessions: Data: 2.02MB + Index: 0.05MB + Engine InnoDB
wpmh_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmh_woocommerce_order_items: Data: 0.14MB + Index: 0.06MB + Engine InnoDB
wpmh_woocommerce_order_itemmeta: Data: 1.50MB + Index: 0.53MB + Engine InnoDB
wpmh_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmh_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_actionscheduler_actions: Data: 1.50MB + Index: 0.53MB + Engine InnoDB
wpmh_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_actionscheduler_logs: Data: 0.20MB + Index: 0.17MB + Engine InnoDB
wpmh_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_comments: Data: 0.22MB + Index: 0.28MB + Engine InnoDB
wpmh_elfsight_instagram_feed_widgets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_loginizer_logs: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpmh_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpmh_mailchimp_jobs: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpmh_options: Data: 3.02MB + Index: 0.06MB + Engine InnoDB
wpmh_postmeta: Data: 4.09MB + Index: 2.88MB + Engine InnoDB
wpmh_posts: Data: 3.05MB + Index: 0.20MB + Engine InnoDB
wpmh_post_views: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_slides: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_soo_wishlists: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_soo_wishlists_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_usermeta: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
wpmh_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpmh_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wc_order_product_lookup: Data: 0.11MB + Index: 0.09MB + Engine InnoDB
wpmh_wc_order_stats: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wpmh_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpmh_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpmh_wfconfig: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wffilemods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfhits: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wpmh_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmh_wfknownfilelist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wflogins: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpmh_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpmh_wfstatus: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpmh_yoast_indexable: Data: 0.22MB + Index: 0.05MB + Engine InnoDB
wpmh_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpmh_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpmh_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpmh_yoast_seo_links: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpmh_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB

### Post Type Counts ###

attachment: 127
customize_changeset: 22
custom_css: 1
elementor_library: 3
jet-popup: 1
mc4wp-form: 1
nav_menu_item: 24
oembed_cache: 2
page: 16
portfolio: 15
post: 12
product: 23
revision: 232
shop_coupon: 1
shop_order: 358
shop_order_refund: 1
us_content_template: 1
us_grid_layout: 1
us_header: 1
us_page_block: 1
us_portfolio: 3
wafs: 2
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (27) ###

Advanced Reporting For Woocommerces: by phoeniixx – 3.0 – Installed version not tested with active version of WooCommerce 4.1.1
Classic Editor: by WordPress Contributors – 1.5
Contact Form 7: by Takayuki Miyoshi – 5.1.9
Envato Market: by Envato – 2.0.3
Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 7.10.4
WPBakery Page Builder: by Michael M - WPBakery.com – 6.2.0
Kirki Customizer Framework: by David Vongries – 3.1.3
Loco Translate: by Tim Whitlock – 2.4.0
Loginizer: by Raj Kothari – 1.4.4
Mailchimp for WooCommerce: by Mailchimp – 2.4.0 – Installed version not tested with active version of WooCommerce 4.1.1
Meta Box: by MetaBox.io – 5.3.0
Official Facebook Pixel: by Facebook – 2.0.2
ProveSource: by ProveSource LTD – 1.4.1 – Installed version not tested with active version of WooCommerce 4.1.1
Slider Revolution: by ThemePunch – 6.1.8
SG Optimizer: by SiteGround – 5.5.5
Sober Addons: by UIX Themes – 1.4.2
Soo Demo Importer: by SooThemes – 1.1
Soo Product Filter: by UIX Themes – 1.0.8 – Installed version not tested with active version of WooCommerce 4.1.1
Soo Wishlist: by UIX Themes – 1.1.2 – Installed version not tested with active version of WooCommerce 4.1.1
Variation Swatcher for WooCommerce: by ThemeAlien – 1.0.10
CPAYMK for WooCommerce: by Rosen Zahariev – 2.0.1 – Installed version not tested with active version of WooCommerce 4.1.1
Advanced Order Export For WooCommerce: by AlgolPlus – 3.1.4 – Installed version not tested with active version of WooCommerce 4.1.1
WooCommerce Advanced Free Shipping: by Jeroen Sormani – 1.1.4 – Installed version not tested with active version of WooCommerce 4.1.1
WooCommerce: by Automattic – 4.1.1
Wordfence Security: by Wordfence – 7.4.7
Yoast SEO: by Team Yoast – 14.2
WP Subscribe Pro: by MyThemeShop – 1.5.15

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

object-cache.php: Memcached

### Settings ###

API Enabled: –
Force SSL: –
Currency: MKD (ден)
Currency Position: right_space
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 0
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 ###

Shop base: #4 - /proizvodi/
Cart: #5 - /cart/
Checkout: #6 - /checkout/
My account: #7 - /my-account/
Terms and conditions: ❌ Page not set

### Theme ###

Name: Sober Child Theme
Version: 1.0.0
Author URL: http://uix.store
Child Theme: ✔
Parent Theme Name: Sober
Parent Theme Version: 2.3.0
Parent Theme Author URL: http://uix.store
WooCommerce Support: ✔

### Templates ###

Overrides: sober/woocommerce/cart/cart-shipping.php
sober/woocommerce/cart/cart.php
sober/woocommerce/cart/mini-cart.php
sober/woocommerce/checkout/form-checkout.php
sober/woocommerce/checkout/form-coupon.php
sober/woocommerce/checkout/form-login.php
sober/woocommerce/checkout/review-order.php
sober/woocommerce/global/form-login.php
sober/woocommerce/global/quantity-input.php
sober/woocommerce/global/wrapper-end.php
sober/woocommerce/global/wrapper-start.php
sober/woocommerce/loop/add-to-cart.php
sober/woocommerce/loop/price.php
sober/woocommerce/loop/result-count.php
sober/woocommerce/myaccount/dashboard.php
sober/woocommerce/myaccount/form-edit-account.php
sober/woocommerce/myaccount/form-login.php version 3.6.0 is out of date. The core version is 4.1.0
sober/woocommerce/myaccount/my-address.php
sober/woocommerce/notices/error.php
sober/woocommerce/notices/success.php
sober/woocommerce/order/form-tracking.php
sober/woocommerce/single-product/add-to-cart/external.php
sober/woocommerce/single-product/add-to-cart/grouped.php
sober/woocommerce/single-product/add-to-cart/simple.php
sober/woocommerce/single-product/add-to-cart/variable.php
sober/woocommerce/single-product/add-to-cart/variation-add-to-cart-button.php
sober/woocommerce/single-product/product-image.php
sober/woocommerce/single-product/product-thumbnails.php
sober/woocommerce/single-product/related.php
sober/woocommerce/single-product/review-meta.php
sober/woocommerce/single-product/tabs/additional-information.php
sober/woocommerce/single-product/tabs/tabs.php
sober/woocommerce/single-product/up-sells.php
sober/woocommerce/single-product-reviews.php

Outdated Templates: ❌
					
					
						Learn how to update

### Action Scheduler ###

Complete: 1.302
Oldest: 2020-04-15 09:00:12 +0000
Newest: 2020-05-16 08:00:39 +0000

Pending: 225
Oldest: 2020-05-16 13:05:12 +0000
Newest: 2020-06-02 19:29:17 +0000

Canceled: 211
Oldest: 2020-04-21 21:45:10 +0000
Newest: -0001-11-30 00:00:00 +0000

Plugin Support

Austin M – a11n

(@apmwebdev)

2 years ago

Just checking in here. Are you all still seeing this issue?

If so, this could be due to a bug that was recently fixed, where WC Admin file names were being created in such a way that they conflicted with file name limitations for many hosting environments. This caused a lot of strange issues, and could be the reason for what you are seeing. There is a fix for this that was released in the stand-alone WooCommerce Admin plugin in version 1.2.4. Please install that if you haven’t already, or update it if you have. The change should be going out with the next WooCommerce Core release as well, but use the stand-alone plugin for an immediate fix.

If that doesn’t solve the issue, go to Analytics > Settings and look in the Import Historical Data section. Is it listing anything that needs to be imported there? If so, import it. Did that import the missing orders into the reports? This obviously doesn’t solve the problem of why this happened to begin with, but it means that those orders aren’t completely invisible to WC Admin, which is something.

Another thing to check would be WooCommerce > Status > Scheduled Actions.

First, go the Pending tab, then search for wc-admin_import_orders. Are there any pending scheduled actions with a Scheduled Date in the past?

Next, go to the Failed tab (if it exists) and search for wc-admin_import_orders again. Do you see any failed scheduled actions with this hook?

I created a screenshot here to help clarify things.

Plugin Support

Joey – a11n

(@jricketts4)

2 years ago

We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

– Joey

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Issue with WooCommerce sales analytics’ is closed to new replies.

Views