Timmy Crawford

Thanks for sending along the system status report @dazzlealiasdinil999 – I’ve opened up an issue in our repository and we will be working on a fix for this soon.

Hello @travelavenger sorry you encountered an error with the update. We did test out the scenario of older versions of WooCommerce Admin being present during the 4.3 upgrade and we didn’t encounter the error you shared above.

Could you provide anymore details around your site to see if we could look into a cause of the error? Specifically what version of WooCommerce Admin you had installed, and how you updated to WooCommerce 4.3 would be quite helpful.

Additionally a copy of your System Status report would be informative too ( https://docs.woocommerce.com/document/understanding-the-woocommerce-system-status-report/ )

Thanks much, and again sorry you encountered this issue.

Hello @gevcen –
Sorry to hear you are experiencing some issues with the new dashboard and report functionality. Based off what you have shared above, it sounds like you might need to import your historical data into the new reporting system. Details on that can be found here: https://docs.woocommerce.com/document/woocommerce-analytics/

Look under the section for “Analytics Settings” in the document above for full details, or you can visit /wp-admin/admin.php?page=wc-admin&path=%2Fanalytics%2Fsettings on your site to being the historical data import.

The new reports leverage lookup tables in the the database to allow for more advanced filtering tools and speed… and by default historical orders are not imported to the tables.

> Also, it’s too much complicated that the previous one. You give 10 charts whereas the previous dashboard has only 1 single unique charts where all the informations were included in there.

On the same help document above, you can read about how you can fully customize the new dashboard to only contain the charts and figures that matter to your store. Please look under the section titled “Analytics Dashboard” for more details on how to do that.

Hey @maxwellnorman – thanks so much for the review. If you do have some bugs to report, please open up a topic in the forums here and we would be happy to help.

@rodoswebdesign sorry to hear you encountered a problem with the plugin. Just to confirm this is the theme you had issues with: https://themeforest.net/item/woodmart-woocommerce-wordpress-theme/20264492

By chance did you switch to another theme, like Storefront, to see if the error cleared up or was it specific to the theme?

Also if you could provide the full error message around the 500, that would be quite useful and would help me diagnose the problem. Again, apologies you had issues with the plugin, but I’m here and happy to help get them sorted out.

@nvisagie sorry you have had some issues with the plugin. In order for past orders to be visible within the new reporting system, you need to import the historical data into the new reporting database tables. When you first installed the plugin there is a prompt to do so – by chance did you see this and try to do the historical import?

Please let me know if I can help out at all with getting your historical data imported into the new reports.

Hi @nellybongo – sorry for the late reply here but yes, both of those items are expected behavior.

The long URLs are a result of any filters that you have defined on a current report. So that would include the date range, period ( month, day, year etc ), along with any other filters you have specified. The more filters, the longer the URL. This is done to allow for specific filtered views to be saved via bookmark, or linked from elsewhere within woocommerce and beyond.

I wasn’t aware of Excel having a limit on URL length, but one way around this would be to download the CSV locally to your computer, then import into excel for further data crunching.

As for some downloads being emailed and not others – by default if one page or less of data is returned on a report, it is downloaded directly from the page. On reports that have a larger data set, greater than one page, it requires a bit more resources for the report to assemble all the pages of that data and place it into a csv format. As such it is enqueued as a background job, and when complete, it is emailed to you. This is a similar experience that is seen when working with large data sets on products like Google Analytics.

Hope that helps, and let me know if I can answer any more questions.

@cristianciuberea reporting data is updated based upon various actions firing in WooCommerce. Like when an order is edited/created, a job is enqueued to update stats for that order – or if a user/customer object is updated, a job is enqueued to update associated reporting data.

By chance do you have any pending actions for scheduled jobs showing up:

/wp-admin/admin.php?page=wc-status&tab=action-scheduler&status=pending

That would give a glimpse into stat jobs that have yet to run.

Hello @phritzy – I took your example code and am running it on the latest versions of WooCommerce and WooCommerce Admin and I’m not seeing any exceptions locally. Could you share what versions you are running locally and/or any other plugins that you have installed?

@swekarl apologies about the order numbers. WooCommerce uses a job queuing system called ActionScheduler, which this plugin uses extensively for updating data in background jobs vs performing costly database inserts during a customer checkout for example.

ActionScheduler currently uses a Custom Post Type to store and process background job data, so each job inserts a new record into the posts table, which increases the order numbers – since Orders too, and their numbers are tied to the same database table.

A new version of ActionScheduler will be coming out soon that moves away from using the Custom Post Type so this will no longer be an issue. I realize that doesn’t fix your problem for you, but wanted to let anybody else who might read this know the cause and the solution that is being put into place.

Also just FYI, anytime you create a new page or blog post on your site, or if you use any other plugins that leverage Custom Post Types, your order numbers will increase.

@simbasounds sorry you encountered issues. Could you provide any more details into the clogged database? Did your clients perform a historical data import that was taking a long time?

@thd2018 thanks for the feedback, let us know if you need any assistance.

Wow @radethai – those kind words mean so much to us on the team, much appreciated!

obrigado!

Thanks for the feedback @rickbase1