Category Analytics
-
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.
I have read the official documentation (https://docs.woocommerce.com/document/woocommerce-analytics/#section-17) and I understand why the numbers may not always add up, but in this specific case those caveats don’t apply. Every product on the site is one (and only one) category. No product is in more than one category or in both the parent and child categories (except by automatic inheritance).
It is clearly obvious though from the screen shots that the numbers just don’t add up!
1. (https://ibb.co/QD0XLyK) clearly shows 39 products sold and yet the sum of all products against their categories is just 21. What happened to the other 18? They are all in categories, but those categories don’t show on the report.
2. (https://ibb.co/p1xG2HN) shows the comparison between categories and you can see that again the numbers don’t add up, and yet when a category with 0 sales is clicked…
3. (https://ibb.co/88p4fzs) you can see that the figures are there against that category.
Once again no products are in more than one category so nothing should be being counted twice.
This was the case before and after today’s 4.2 release and I have tried clearing stale transients from the database too.
Is there something I’m missing?
-
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.
- The topic ‘Category Analytics’ is closed to new replies.