Category Analytics

Hi @yknivag! Thanks for the detailed description of the problem. I’m going to ping our devs about this, as we’ve seen some other category issues with WC Admin recently. While I do that, can you get some more information for me?

1. Can you post your system status report? You can find that by going to WooCommerce > Status in your dashboard, then clicking “Get system report,” then “Copy for support.”

2. Are there any console (JS) errors or fatal errors in the fatal error logs? You can find the latter in WooCommerce > Status > Logs.

Thanks!

Hi @apmwebdev – thanks for getting back and investigating.

I’ve checked the console while generating the reports and there is nothing shown at all, no errors, no warnings, nothinh.

You can find the system report below:

### WordPress Environment ###

WordPress address (URL): https://my.domain.tld
Site address (URL): https://my.domain.tld
WC Version: 4.2.0
REST API Version: ? 1.0.8
WC Blocks Version: ? 2.5.16
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 1.2.3
Log Directory Writable: ?
WP Version: 5.4.1
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.6
PHP Post Max Size: 32 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.62.0
OpenSSL/1.0.2k

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

### Database ###

WC Database Version: 4.2.0
WC Database Prefix: wpri_
Total Database Size: 2.78MB
Database Data Size: 2.28MB
Database Index Size: 0.50MB
wpri_woocommerce_sessions: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_api_keys: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_order_itemmeta: Data: 0.03MB + Index: 0.03MB + Engine MyISAM
wpri_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_a4barcode_custom_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpri_a4barcode_custom_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpri_a4barcode_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpri_actionscheduler_actions: Data: 0.04MB + Index: 0.03MB + Engine MyISAM
wpri_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_actionscheduler_logs: Data: 0.03MB + Index: 0.02MB + Engine MyISAM
wpri_atum_order_itemmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_atum_order_items: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_atum_product_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_commentmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_comments: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpri_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_options: Data: 1.18MB + Index: 0.07MB + Engine MyISAM
wpri_pimwick_gift_card: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_pimwick_gift_card_activity: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_postmeta: Data: 0.27MB + Index: 0.13MB + Engine MyISAM
wpri_posts: Data: 0.61MB + Index: 0.05MB + Engine MyISAM
wpri_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_term_relationships: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_usermeta: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wpri_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_wc_admin_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_admin_note_actions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_customer_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_order_product_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wpri_wc_order_stats: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wpri_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_wfpklist_template_data: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wpri_wpmm_subscribers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wpri_zp_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM

### Post Type Counts ###

attachment: 77
atum_inventory_log: 1
atum_purchase_order: 1
atum_supplier: 2
customize_changeset: 55
custom_css: 1
mep_events: 1
nav_menu_item: 33
page: 12
pos-station: 3
post: 8
product: 21
product_variation: 3
revision: 95
shop_coupon: 2
shop_order: 38
wcpcsu-custom-post: 1
wpcf7_contact_form: 2

### Security ###

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

### Active Plugins (24) ###

Print Barcodes on Label Sheets for WordPress & WooCommerce (demo): by UkrSolution – 2.14.2 – Installed version not tested with active version of WooCommerce 4.2.0
ATUM Inventory Management for WooCommerce: by Stock Management Labs? – 1.7.2 – Installed version not tested with active version of WooCommerce 4.2.0
Change Quantity on Checkout for WooCommerce: by Bhavik Kiri – 1.0 – Installed version not tested with active version of WooCommerce 4.2.0
Contact Form 7: Accessible Defaults: by Joseph Dolson – 1.1.6
Contact Form 7 - reCAPTCHA: by iambriansreed – 1.2.0
Contact Form 7: by Takayuki Miyoshi – 5.1.9
Duplicate Post: by Enrico Battocchi – 3.2.4
Mongoose Page Plugin: by Mongoose Marketplace – 1.7.3
Woocommerce Events Manager: by MagePeople Team – 3.2.6 – Installed version not tested with active version of WooCommerce 4.2.0
Members: by MemberPress – 3.0.8
Point of Sale POS for WooCommerce: by BizSwoop a CPF Concepts
LLC Brand – 2.0.9 – Installed version not tested with active version of WooCommerce 4.2.0

WooCommerce PDF Invoices, Packing Slips, Delivery Notes & Shipping Labels (Basic): by WebToffee – 2.6.4 – Installed version not tested with active version of WooCommerce 4.2.0
Product Enquiry for WooCommerce: by WisdmLabs – 3.0.1 – Installed version not tested with active version of WooCommerce 4.2.0
WooCommerce Side Cart: by XootiX – 2.1 – Installed version not tested with active version of WooCommerce 4.2.0
Simple Local Avatars: by Jake Goldman
10up – 2.1.1

Ultimate Addons for Gutenberg: by Brainstorm Force – 1.15.2
WooCommerce Weight Based Shipping: by weightbasedshipping.com – 5.3.4.1 – Installed version not tested with active version of WooCommerce 4.2.0
wePOS - Point Of Sale (POS) for WooCommerce: by weDevs – 1.1.1 – Installed version not tested with active version of WooCommerce 4.2.0
Widget Context: by Kaspars Dambis – 1.3.2
WooCommerce Product Carousel, Slider and Grid Ultimate: by AazzTech – 1.7.4 – Installed version not tested with active version of WooCommerce 4.2.0
Product Slider and Carousel with Category for WooCommerce: by WP OnlineSupport – 2.2 – Installed version not tested with active version of WooCommerce 4.2.0
WooCommerce: by Automattic – 4.2.0
WooCustomizer: by Kaira – 1.1.9 – Installed version not tested with active version of WooCommerce 4.2.0
WP Maintenance Mode: by Designmodo – 2.2.4

### Inactive Plugins (9) ###

Advanced Access Manager: by Vasyl Martyniuk <[email protected]> – 6.5.2
Akismet Anti-Spam: by Automattic – 4.1.5
Conditional Payments for WooCommerce: by Lauri Karisola / WooElements.com – 2.1.5 – Installed version not tested with active version of WooCommerce 4.2.0
Facebook for WooCommerce: by Facebook – 1.11.3 – Installed version not tested with active version of WooCommerce 4.2.0
Gutenberg WooCommerce Blocks: by wpxpo – 1.0.6 – Installed version not tested with active version of WooCommerce 4.2.0
Order Receipt Print for WooCommerce Google Cloud Print: by BizSwoop a CPF Concepts
LLC Brand – 3.0.12 – Installed version not tested with active version of WooCommerce 4.2.0

Price based on User Role for WooCommerce: by Tyche Softwares – 1.4.1 – Installed version not tested with active version of WooCommerce 4.2.0
WooCommerce Admin: by WooCommerce – 1.1.3 – Installed version not tested with active version of WooCommerce 4.2.0
WooCommerce PDF Invoices: by Bas Elbers – 3.0.11 – Installed version not tested with active version of WooCommerce 4.2.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)
pw gift card (pw-gift-card)
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: #6 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #418 - /about/tcs/

### Theme ###

Name: Avant
Version: 1.1.40
Author URL: https://kairaweb.com/
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: –

### Action Scheduler ###

Canceled: 1
Oldest: 2020-05-26 10:43:55 +0000
Newest: 2020-05-26 10:43:55 +0000

Complete: 160
Oldest: 2020-05-26 10:43:55 +0000
Newest: 2020-06-04 19:29:37 +0000

Pending: 1
Oldest: 2020-06-05 19:29:37 +0000
Newest: 2020-06-05 19:29:37 +0000

Hopefully this will give you all you need.

Hi @yknivag, thanks for the update. Can you create an admin user for us using [email protected] as the email address? Once the user has been created, we can use the lost password functionality to reset the password and log in. The devs would like to take a closer look at your dashboard. Thanks!

Hi, sorry for the delay in getting back to you. I haven’t received a notification of your reply.

I’m really uncomfortable at the idea of providing admin level access to an e-commerce solution for an unknown dev. With little work this should be replicable on a test setup that your Devs should already have.

If you require specific information about my specific implementation then by all means ask for screenshots or ask for the results of database queries. I will happily provide any such information.

Providing an admin account is a huge amount of work at my end as every password, every API key with every payment provider, analytics company etc will need to be changed before and after your access. Not to mention the GDPR regulatory implications of your staff having access to customer data. This should only ever be the last possible resort.

To be honest the very fact that such access has been requested at all after so little investigation really calls into question for me the focus (or apparent lack of focus) that WooCommerce appear to place in security. Frightening for an e-commerce solution.

As I said I’m happy to provide any screenshots you may require and any data you may require.

Hi @yknivag. Perhaps I should have clarified earlier: We are not able to replicate this behavior with the category reports. I was also under the impression that this was a test site, not a live site, which is why I asked for credentials. You said

I have a small shop set up just for testing before I commit fully and am having some real problems with the analytics.

Because this is a test site with only a few products, categories and test orders it is very easy to see that things really aren’t adding up.

This made me think that there was no customer data or a live payment gateway that you were working with, but just test data. I apologize if I misunderstood. I will relay this to the devs.

Hi @apmwebdev,

I was also under the impression that this was a test site, not a live site, which is why I asked for credentials.

It is a test site, but I have been testing payment gateways and ordering also and so there are keys and addresses in place.

I can remove these keys and create a user for you if that is truly the only way to resolve this, but as with anything like this that should always be the last option.

I have done some more testing and if I use the “Reports” screen under “WooCommerce” the values are correct. If I use “Categories” under “Analytics” the values are incorrect. They’re not directly comparable as the “Reports” option doesn’t allow categories to be compared.

This would suggest that the issue lays possibly with the API. However I have not been able to identify which file in the plugin contains the code that answers the API requests or generates the queries to the database so I can’t figure out if the cause is bad data or a bad query.

Again, if there are queries I can run or screenshots I can provide please let me know.

Hi @yknivag. We identified an issue last week where some files created by the plugin were not loading properly due to the length of the file names and characters included in them. This caused varied issues, and might be the cause of the issue you’re seeing. If you haven’t already, can you install the newest version of the stand-alone WC Admin plugin, which you can find here, and see if that fixes the issue?

Hi @apmwebdev I have upgraded the WC Admin Plugin to the version released on 11th June and I can confirm that this has resolved the issue.

Many thanks for your help.