WooCommerce Reports not Updating

  • Resolved cutty3d

    (@cutty3d)


    6 years, 2 months ago

    My WooCommerce reports have not been refreshing with up-to-date content in the last week on simplycraftysvgs.com. The info in the orders is not reflected in the reports. I thought it might be related to to caching, as I was able earlier last week to purge the cache a few times and sometimes it populates. The counts by product and $ amounts were showing correctly after that. However, in the last day or so, purging the cache is not working. I am using SG Optimizer from Siteground. The following are the steps I have taken to troubleshoot. I have reached out the Siteground already and this is my next step. The tech I am working with is running me around in circles. And for your reference, scroll down for the WooCommerce status report.

    *As soon as I recognized the issues, I created a Staging copy of my site to test. As soon as that loaded the reports on staging copy, the reports were working. So, there is essentially it does not appear to be any problems on staging copy. I was going to test in staging by disabling plugins/changing themes, etc. But problem does not appear.
    *I also looked up Woocommerce caching configuration and setup caching as close to possible as stated in this document. https://docs.woocommerce.com/document/configuring-caching-plugins/. It did not make a difference
    * I tried clicking Purge SG Cache again then reloading report. That does not work. For example, it shows $0 for last 7 days. I verified paid sales today under WooCommerce Orders. I even cleared my cache, history and every saved settings in Chrome browser. I then tried in Firefox. Same issues. I did not turn off SG Optimizer, as I was not sure what that would so with my SSL config.
    * Then, I disabled caching in SG Optimizer EXCEPT “Enable HTTPS” option. Then I clicked on “Purge SG Cache” in WP admin just to make sure it was clear. I then cleared my browser cache, closed Chrome and reopened. Signed back in the WP Admin page. That seem to fix part of it,so it confirms a caching issue. The Net sales for month under the Dashboard WooCommerce status now shows a the current monthly sales amount. When I go into WooCommerce Reports, and click on “Last 7 days” view, it shows a zero sales amount. Obviously, there are sales in last 7 days, as I had a total for current month. So, it is partially working now.
    *Next, I placed the website into maintenance mode and completely disabled SG Optimizer. Reports for last 7 days still do not populate. I also changed themes to see if it was a theme conflict. I use a Divi child theme. I switched to Twenty Nineteen and still same issue.

    Are there any known issues in regards to SG Optimizer and WooCommerce currently? I have a response into Siteground support asking if there any other backend purging of cache that needs to take place. After going back and forth, I though I would post here to see if you all have any words of wisdom. This only started occurring recently. With all the upgrades related to the WordPress 5.0 launch, it is just a matter of finding out what is causing the issue. Again, on my staging copy, I am unable to replicate.

    Any help would be appreciated. Status report is below. Thank you.

    Sandy

    WooCommerce Status Report

    
### WordPress Environment ###

Home URL: https://www.simplycraftysvgs.com
Site URL: https://www.simplycraftysvgs.com
WC Version: 3.5.3
Log Directory Writable: ?
WP Version: 5.0.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.2.13
PHP Post Max Size: 128 MB
PHP Time Limit: 120
PHP Max Input Vars: 5000
cURL Version: 7.59.0
OpenSSL/1.0.2q

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: 3.5.3
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 756.56MB
Database Data Size: 494.23MB
Database Index Size: 262.33MB
wp_woocommerce_sessions: Data: 23.52MB + Index: 0.22MB
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_downloadable_product_permissions: Data: 18.55MB + Index: 21.67MB
wp_woocommerce_order_items: Data: 8.52MB + Index: 3.52MB
wp_woocommerce_order_itemmeta: Data: 88.61MB + Index: 53.16MB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB
wp_commentmeta: Data: 0.05MB + Index: 0.03MB
wp_comments: Data: 11.52MB + Index: 9.09MB
wp_et_bloom_stats: Data: 0.17MB + Index: 0.00MB
wp_failed_jobs: Data: 0.27MB + Index: 0.00MB
wp_itsec_distributed_storage: Data: 3.52MB + Index: 0.02MB
wp_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB
wp_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB
wp_itsec_lockouts: Data: 0.02MB + Index: 0.08MB
wp_itsec_logs: Data: 0.02MB + Index: 0.09MB
wp_itsec_temp: Data: 0.17MB + Index: 0.34MB
wp_links: Data: 0.02MB + Index: 0.02MB
wp_mts_wp_reviews: Data: 0.02MB + Index: 0.00MB
wp_options: Data: 105.52MB + Index: 1.52MB
wp_postmeta: Data: 144.69MB + Index: 109.28MB
wp_posts: Data: 15.52MB + Index: 8.06MB
wp_queue: Data: 0.02MB + Index: 0.00MB
wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB
wp_termmeta: Data: 0.08MB + Index: 0.08MB
wp_terms: Data: 0.27MB + Index: 0.25MB
wp_term_relationships: Data: 1.52MB + Index: 0.33MB
wp_term_taxonomy: Data: 0.28MB + Index: 0.30MB
wp_usermeta: Data: 61.61MB + Index: 45.17MB
wp_users: Data: 3.52MB + Index: 4.55MB
wp_wc_download_log: Data: 5.52MB + Index: 4.03MB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB
wp_wpmm_subscribers: Data: 0.02MB + Index: 0.00MB
wp_yoast_seo_links: Data: 0.31MB + Index: 0.13MB
wp_yoast_seo_meta: Data: 0.09MB + Index: 0.00MB

### Post Type Counts ###

attachment: 2065
customize_changeset: 1
custom_css: 1
et_pb_layout: 29
feedback: 2
jetpack_migration: 2
mc4wp-form: 1
nav_menu_item: 16
oembed_cache: 34
page: 18
post: 175
product: 292
product_variation: 2
project: 1
sg_optimizer_job: 2
shop_coupon: 141
shop_order: 43468
shop_order_refund: 17
wpcf7_contact_form: 1

### Security ###

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

### Active Plugins (20) ###

VaultPress: by Automattic – 1.9.7
Akismet Anti-Spam: by Automattic – 4.1
Bloom: by Elegant Themes – 1.3.8
Contact Form 7: by Takayuki Miyoshi – 5.1.1
Duplicate Post: by Enrico Battocchi – 3.2.2
Elegant Themes Updater: by Elegant Themes – 1.2
ET Shortcodes: by Elegant Themes – 1.2.1
Google Analytics: by ShareThis – 2.1.5
iThemes Security Pro: by iThemes – 5.5.8
Revision Control: by Dion Hulse – 2.3.2
SG Optimizer: by SiteGround – 5.0.10
WooCommerce Extended Coupon Features FREE: by Soft79 – 3.0.5
WooCommerce Google Analytics Integration: by WooCommerce – 1.4.7
WooCommerce Menu Cart: by Jeremiah Prummer
Ewout Fernhout – 2.7.3

WooCommerce Order Status Control: by SkyVerge – 1.9.2
WooCommerce Smart Coupons: by StoreApps – 3.8.6
WooCommerce: by Automattic – 3.5.3
Yoast SEO Premium: by Team Yoast – 9.3
WP Maintenance Mode: by Designmodo – 2.2.2
WP-Optimize: by David Anderson
Ruhani Rabin
Team Updraft – 2.2.7

### Settings ###

API Enabled: ?
Force SSL: –
Currency: USD ($)
Currency Position: left
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-4 (rated-4-2)
rated-5 (rated-5)

### WC Pages ###

Shop base: #973 - /shop/
Cart: #974 - /cart/
Checkout: #975 - /checkout/
My account: #976 - /my-account/
Terms and conditions: #743 - /terms/

### Theme ###

Name: Divi Child By Simply Crafty SVGS
Version: 4
Author URL: 
Child Theme: ?
Parent Theme Name: Divi
Parent Theme Version: 3.19.3
Parent Theme Author URL: https://www.elegantthemes.com
WooCommerce Support: ?

### Templates ###

Overrides: –

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    Thank you for the detailed description – you’ve done great work in troubleshooting for this so far!

    What you described does sound like the issue is being caused by some sort of cache. The staging site did not present the issues because – being a new copy– there were no cached files yet. That’s why it must have worked correctly.

    If the issue remained even after disabling the caching plugin, there are two other possible causes:

    – There could be another caching plugin installed on the site, besides the Optimizer you referenced.

    – Caching could be happening at the server level. You’d have to reach out to your host to verify whether any caching is being done on their end.

    Hopefully this helps!

    Thread Starter cutty3d

    (@cutty3d)

    @fhaps,
    Thanks for the response. I worked with Siteground for a long time to determine the issue.Based on the symptoms, it definitely was a caching issue. After working with support for a few days, they stated the issue was not on their side. However, issue mysteriously stopped happening a few days later. There was a update of the SG Optimizer a few days later. I am not sure if that was the problem, but it seemed to clear itself on its own after hours and days of troubleshooting. I did not change anything at that point, so I have to assume something on the back end was causing it.

    Thanks again!

    Plugin Support Fernando a11n

    (@fhaps)

    Automattic Happiness Engineer

    Hi @cutty3d,

    Thanks for updating the thread with the resolution. Mysterious one, for sure! But I’m glad everything’s working correctly now.

    Best,
    Fernando

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WooCommerce Reports not Updating’ is closed to new replies.

Tags