search

woocommerce / woocommerce-admin

(Deprecated) This plugin has been merged to woocommerce/woocommerce
https://woocommerce.github.io/woocommerce-admin/#/
Other
360 stars 145 forks source link

Duplicate "Items Sold" under Analytics > Overview #6915

Closed RiaanKnoetze closed 3 years ago

RiaanKnoetze commented 3 years ago

Prerequisites (mark completed items with an [x]):

Describe the bug When navigating to Analytics > Overview, the performance area lists duplicate areas. Both are called "Items Sold"

Expected behavior I expected only one area to be listed, or at least clarity on what each sold section means.

Actual behavior A clear and concise description of what actually happens. Please be as descriptive as possible;

Steps to reproduce the bug (We need to be able to reproduce the bug in order to fix it.) Steps to reproduce the bug:

  1. Go to your local testing site
  2. Navigate to Analytics > Overview
  3. Location "Performance" section near the top
  4. Notice two areas, both called "Items Sold"

Screenshots

https://d.pr/i/ahxvG9 Full Image: https://d.pr/i/ahxvG9

Isolating the problem (mark completed items with an [x]):

WordPress Environment We use the WooCommerce System Status Report to help us evaluate the issue. Without this report we won't be able to fully evaluate this issue.

``` ` ### WordPress Environment ### WordPress address (URL): https://wc.local Site address (URL): https://wc.local WC Version: 5.2.2 REST API Version: ✔ 5.2.2 WC Blocks Version: ✔ 4.7.2 Action Scheduler Version: ✔ 3.1.6 WC Admin Version: ✔ 2.1.5 Log Directory Writable: ✔ WP Version: 5.7.1 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: – ### Server Environment ### Server Info: nginx/1.16.0 PHP Version: 7.3.5 PHP Post Max Size: 1,000 MB PHP Time Limit: 1200 PHP Max Input Vars: 4000 cURL Version: 7.54.0 LibreSSL/2.6.5 SUHOSIN Installed: – MySQL Version: 8.0.16 Max Upload Size: 300 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### WC Database Version: 5.2.2 WC Database Prefix: wp_ Total Database Size: 13.79MB Database Data Size: 10.53MB Database Index Size: 3.26MB wp_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_advanced_notification_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_advanced_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_automatewoo_abandoned_carts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_customers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_automatewoo_referral_advocate_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_automatewoo_referral_invites: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_email_log: Data: 0.33MB + Index: 0.00MB + Engine InnoDB wp_followup_coupon_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_coupons: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customer_carts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customer_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_customer_orders: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_followup_customers: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_followup_email_excludes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_email_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_email_orders: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_followup_email_tracking: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_followup_followup_history: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_order_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_order_items: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_followup_subscriber_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_subscribers: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_followup_subscribers_to_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_layerslider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_layerslider_revisions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_options: Data: 8.06MB + Index: 0.13MB + Engine InnoDB wp_postmeta: Data: 0.27MB + Index: 0.23MB + Engine InnoDB wp_posts: Data: 0.09MB + Index: 0.06MB + Engine InnoDB wp_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_booking_relationships: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_bookings_availability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_bookings_availabilitymeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_points_rewards_user_points: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_points_rewards_user_points_log: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wcpv_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpv_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcrs_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_woocommerce_per_product_shipping_rules: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_woocommerce_subscription_downloads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB ### Post Type Counts ### af_product_videos: 1 attachment: 51 avia_framework_post: 6 aw_workflow: 1 custom_css: 1 global_product_addon: 1 nav_menu_item: 6 page: 14 pdr_product_base: 16 post: 3 product: 33 product_variation: 16 revision: 8 shop_coupon: 2 shop_order: 23 shop_subscription: 4 wc_membership_plan: 1 wc_memberships_team: 1 wc_user_membership: 1 wcpf_item: 4 wcpf_project: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (5) ### Code Snippets: by Code Snippets Pro – 2.14.1 Email Log: by Sudar – 2.4.5 Plugin Toggle: by Cedaro – 1.3.1 User Switching: by John Blackbourn & contributors – 1.5.6 WooCommerce: by Automattic – 5.2.2 ### Inactive Plugins (137) ### Add To Cart Redirect for WooCommerce: by Jeroen Sormani – 1.1.0 Admin category search: by Atilla Ordog – 1.0 Advanced Editor Tools (previously TinyMCE Advanced): by Automattic – 5.6.0 Affiliate For WooCommerce: by StoreApps – 3.3.0 Akismet Anti-Spam: by Automattic – 4.1.9 Auctions for WooCommerce: by WPInstitut – 1.5 AutomateWoo: by WooCommerce – 5.4.1 AutomateWoo - Refer A Friend Add-on: by WooCommerce – 2.6.1 AutomateWoo - Subscriptions Add-on: by Prospress Inc. – 1.0.1 AutomateWoo - Templates: by EasyExtend – 1.0.0 bbPress: by The bbPress Contributors – 2.6.6 Bookings Helper: by WooCommerce – 1.0.2 Braintree for WooCommerce Payment Gateway: by WooCommerce – 2.6.0 Bulk Order Form For WooCommerce: by wpexpertsio – 1.1.3 Caxton: by PootlePress – 1.27.0 Customize Event Google Calendar for WooCommerce Booking: by Ivan Barreda – 1.0.1 Custom User Registration Fields for WooCommerce: by Addify – 1.6.6 Debug Bar: by wordpressdotorg – 1.1.2 Debug Bar Cache Lookup: by Allan Collins – 0.1.1 Debug Objects: by Frank Bültge – 2.5.0 Disable Real MIME Check: by Sergey Biryukov – 1.0 Easy Google Fonts: by Titanium Themes – 1.4.4 Email Templates: by Damian Logghe – 1.3.2.1 Enable jQuery Migrate Helper: by The WordPress Team – 1.3.0 Enhancer for WooCommerce Subscriptions: by FantasticPlugins – 2.3 Export shipping zones: by Rynaldo Stoltz – 1.3 Follow-Up Emails: by WooCommerce – 4.9.13 GD Library Check: by Riaan Knoetze – 1.0 GDPR Cookie Consent: by WebToffee – 2.0.1 Health Check & Troubleshooting: by The WordPress.org community – 1.4.5 Hello Dolly: by Matt Mullenweg – 1.7.2 Homepage Control: by WooThemes – 2.0.3 Insert Headers and Footers: by WPBeginner – 1.6.0 Kadence WooCommerce Email Designer: by Kadence WP – 1.4.7 List Products By Category Widget For WooCommerce: by Blaze Concepts – 1.3.0 Loco Translate: by Tim Whitlock – 2.5.2 Mailchimp for WooCommerce: by Mailchimp – 2.5.1 Matty Theme QuickSwitch: by Matty – 1.2.3 One Click Demo Import: by OCDI – 3.0.2 Oxygen: by Soflyy – 3.5 Point of Sale for WooCommerce: by Actuality Extensions – 5.4.2 Product Designer for WooCommerce: by FantasticPlugins – 1.7 Product FAQs: by 99w – 1.0.8 Product Filters for WooCommerce: by WooCommerce – 1.2.5 Product Video for WooCommerce: by Addify – 1.3.7 Quote Request for WooCommerce: by FantasticPlugins – 1.6 Request a Quote for WooCommerce: by Addify – 2.2.0 Saved Addresses For WooCommerce: by StoreApps – 2.3.0 Say What?: by Ademti Software – 2.0.1 Show Current Template: by JOTAKI Taisuke – 0.4.6 Smart Manager For WooCommerce – Stock Management, Bulk Edit & more...: by StoreApps – 5.11.0 Smart Product Quantity: by HighAddons – 1.0.1 Sticky Cart For WooCommerce: by SkroTron – 1.1.6 Storefront - Lefthand Account Tabs: by Riaan K. | WooCommerce – 1.0 Storefront Horizontal Tabs: by Riaan K. | WooCommerce – 1.0 Storefront Mega Menus: by WooCommerce – 1.6.2 Storefront Powerpack: by WooCommerce – 1.6.1 Teams for WooCommerce Memberships: by SkyVerge – 1.5.3 Templates Pro for AutomateWoo: by EasyExtend – 1.0 Term Duplicator: by CGD Inc. – 1.0.0 Testimonials: by WooThemes – 1.5.4 Theme Customisations: by WooThemes – 1.0.0 Tiered Price Table for WooCommerce: by Kolya Lukin – 4.0.0 Top 50 WP: by PootlePress – 1.0.0 User Role Editor: by Vladimir Garagulya – 4.59 Walmart Integration for WooCommerce: by CedCommerce – 2.0.5 WC Custom Add to Cart labels: by Rynaldo Stoltz – 1.3 WooCommerce - ShipStation Integration: by WooCommerce – 4.1.42 WooCommerce 360° Image: by WooCommerce – 1.1.20 WooCommerce Accommodation Bookings: by WooCommerce – 1.1.23 WooCommerce Additional Variation Images: by WooCommerce – 1.9.0 WooCommerce Admin: by WooCommerce – 2.2.1 WooCommerce Admin Custom Order Fields: by SkyVerge – 1.15.1 WooCommerce Advanced Notifications: by WooCommerce – 1.2.30 WooCommerce Advanced Product Labels: by Jeroen Sormani – 1.1.8 WooCommerce Advanced Shipping Packages: by Jeroen Sormani – 1.1.8 WooCommerce All Products For Subscriptions: by SomewhereWarm – 3.1.26 WooCommerce Blocks: by Automattic – 5.0.0 WooCommerce Bookings: by WooCommerce – 1.15.38 WooCommerce Bookings Filters: by Codup – 1.2.0.12 WooCommerce Box Office: by WooCommerce – 1.1.31 WooCommerce Branding: by WooCommerce – 1.0.30 WooCommerce Brands: by WooCommerce – 1.6.24 WooCommerce Cart Notices: by SkyVerge – 1.13.2 WooCommerce Chained Products: by StoreApps – 2.9.9 WooCommerce Checkout Field Editor: by WooCommerce – 1.6.1 WooCommerce Composite Products: by SomewhereWarm – 8.1.1 WooCommerce Conditional Shipping and Payments: by SomewhereWarm – 1.9.3 WooCommerce Deposits: by WooCommerce – 1.5.6 WooCommerce Distance Rate Shipping: by Automattic – 1.0.26 WooCommerce Dynamic Pricing: by Element Stark – 3.1.24 Woocommerce Email Admin On Completed Order: by Özgür Özdemir – 0.1 WooCommerce Email Customizer: by WooCommerce – 1.2.0 WooCommerce EU VAT Number: by WooCommerce – 2.3.26 WooCommerce eWAY Payment Gateway: by WooCommerce – 3.1.25 WooCommerce Force Sells: by WooCommerce – 1.1.28 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.1 WooCommerce LightSpeed POS: by RafiLabs – 1.9.9 WooCommerce Local Pickup Plus: by SkyVerge – 2.9.4 WooCommerce Measurement Price Calculator: by SkyVerge – 3.19.1 WooCommerce Memberships: by SkyVerge – 1.21.8 WooCommerce Min/Max Quantities: by WooCommerce – 2.4.20 WooCommerce One Page Checkout: by Automattic – 1.7.11 WooCommerce Order Delivery: by Themesquad – 1.8.7 WooCommerce PayPal Checkout Gateway: by WooCommerce – 2.1.1 WooCommerce PDF Product Vouchers: by SkyVerge – 3.9.3 WooCommerce Photography: by WooCommerce – 1.0.29 WooCommerce Points and Rewards: by WooCommerce – 1.6.43 WooCommerce POS: by kilbot – 0.4.26 WooCommerce Pre-Orders: by WooCommerce – 1.5.30 WooCommerce Product Add-ons: by WooCommerce – 3.9.1 WooCommerce Product Bundles: by SomewhereWarm – 6.8.0 WooCommerce Product CSV Import Suite: by WooCommerce – 1.10.41 WooCommerce Product Vendors: by WooCommerce – 2.1.51 WooCommerce Quick View: by WooCommerce – 1.4.0 WooCommerce Referral System: by Codup.io – 1.3.8.1 WooCommerce Shipping Per Product v2: by WooCommerce – 2.3.13 WooCommerce Ship to Multiple Addresses: by WooCommerce – 3.6.25 WooCommerce Smart Coupons: by StoreApps – 4.19.0 WooCommerce Splash Popup: by WooCommerce – 1.2.20 WooCommerce Square: by WooCommerce – 2.4.1 WooCommerce Store Credit: by Themesquad – 3.6.1 WooCommerce Stripe Gateway: by WooCommerce – 5.1.0 WooCommerce Subscription Downloads: by WooCommerce – 1.1.31 WooCommerce Subscriptions: by WooCommerce – 3.0.15 WooCommerce Subscriptions - Advanced Options: by Automattic. – 1.0 WooCommerce Subscriptions Gifting: by WooCommerce – 2.1.3 WooCommerce Table Rate Shipping: by WooCommerce – 3.0.30 WooCommerce Xero Integration: by WooCommerce – 1.7.37 WooCommerce Zapier: by OM4 Software – 2.0.8 WooSidebars: by WooCommerce – 1.4.5 WP Crontrol: by John Blackbourn & crontributors – 1.10.0 WPML Multilingual CMS: by OnTheGoSystems – 4.0.7 WP Notification Center: by Never5 – 1.0.1 WP Reset: by WebFactory Ltd – 1.86 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.1.2 Yoast SEO: by Team Yoast – 16.2 ### Must Use Plugins (1) ### Local WP Live Link Helper: by Flywheel – 2.0 ### Settings ### API Enabled: – Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: booking (booking) bundle (bundle) composite (composite) external (external) grouped (grouped) simple (simple) subscription (subscription) variable (variable) variable subscription (variable-subscription) 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: woocommerce/woocommerce#8 - /shop/ Cart: woocommerce/woocommerce#9 - /cart/ Checkout: woocommerce/woocommerce#10 - /checkout/ My account: woocommerce/woocommerce#11 - /my-account/ Terms and conditions: ❌ Page not set ### Theme ### Name: Storefront Version: 3.5.1 Author URL: https://woocommerce.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 ### Complete: 10 Oldest: 2021-04-01 13:45:39 +0000 Newest: 2021-04-30 09:45:52 +0000 Pending: 1 Oldest: 2021-05-01 08:59:56 +0000 Newest: 2021-05-01 08:59:56 +0000 ### Status report information ### Generated at: 2021-04-30 09:47:04 +00:00 ` ```
zhongruige commented 3 years ago

Hi @RiaanKnoetze,

Thank you for taking the time to report this issue! I was able to see this as well after navigating to Analytics > Overview and expanding the more ellipses:

Screen Shot 2021-04-30 at 7 44 53 AM

I tested the above on WordPress 5.7.1 and WooCommerce 5.2.2. The analytics section is maintained in the woocommerce-admin repo, so I will be moving this issue there for further investigation. Thank you!

samueljseay commented 3 years ago

Thanks for raising this @RiaanKnoetze

I did some digging and these are 2 unique stats. One is the product items sold and the other is the variation items sold. For now the simplest fix (I think) is to make sure they're named appropriately to remove the ambiguity. I've submitted a fix for this, so hopefully it will be in a new version of wc-admin soon.