Woocommerce analytics pagination for coupons is missing

KseniaTseiko commented 2 years ago

Prerequisites

[X] I have carried out troubleshooting steps and I believe I have found a bug.
[X] I have searched for similar bugs in both open and closed issues and cannot find a duplicate.

Describe the bug

the coupons from Analytics > Coupons lacks pagination and only 25 coupons are shown.

Expected behavior

I expect pagination and to be able to download all coupons

Actual behavior

We have 162 coupons now and only 25 coupons are shown and can be downloaded in Analytics > Coupons

Steps to reproduce

Make sure that you have at least 26 orders with unique coupons added.
Go to Analytics > Coupons
Notice that only 25 coupons are shown even if you select a time range that should have all the orders with coupons (at least 26).

WordPress Environment

`

WordPress Environment

WordPress address (URL): https://style-republic.eu Site address (URL): https://style-republic.eu WC Version: 6.0.0 REST API Version: ✔ 6.0.0 WC Blocks Version: ✔ 6.3.3 Action Scheduler Version: ✔ 3.3.0 WC Admin Version: ✔ 2.9.4 Log Directory Writable: ✔ WP Version: 5.8.3 WP Multisite: – WP Memory Limit: 2 GB WP Debug Mode: – WP Cron: ✔ Language: de_DE External object cache: –

Server Environment

Server Info: nginx/1.20.1 PHP Version: 7.4.27 PHP Post Max Size: 510 MB PHP Time Limit: 30 PHP Max Input Vars: 1000 cURL Version: 7.29.0 NSS/3.53.1

SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.32-MariaDB Max Upload Size: 500 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 6.0.0 WC Database Prefix: wp_ Total Database Size: 231.40MB Database Data Size: 145.53MB Database Index Size: 85.87MB wp_woocommerce_sessions: Data: 1.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.25MB + Index: 0.13MB + Engine InnoDB wp_woocommerce_order_itemmeta: Data: 2.52MB + Index: 2.92MB + 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: 7.02MB + Index: 10.42MB + 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: 3.02MB + Index: 3.44MB + Engine InnoDB wp_aepc_custom_audiences: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aepc_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_aioseo_notifications: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_aioseo_posts: Data: 0.38MB + Index: 0.05MB + Engine InnoDB wp_aryo_activity_log: Data: 7.02MB + Index: 0.00MB + Engine InnoDB wp_berocket_termmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_ce4wp_abandoned_checkout: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_cmplz_cookiebanners: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_cookies: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_cmplz_services: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_commentmeta: Data: 0.11MB + Index: 0.13MB + Engine InnoDB wp_comments: Data: 1.52MB + Index: 0.88MB + Engine InnoDB wp_elfsight_instagram_feed_cache: Data: 1.44MB + Index: 0.00MB + Engine InnoDB wp_elfsight_instagram_feed_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_elfsight_instagram_feed_widgets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_enjoy_instagram_hashtags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_enjoy_instagram_media: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_ewwwio_images: Data: 1.19MB + Index: 1.48MB + Engine InnoDB wp_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_budget_recommendations: Data: 0.22MB + Index: 0.14MB + Engine InnoDB wp_gla_merchant_issues: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_gla_shipping_rates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_gla_shipping_times: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_mapping_to_external_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_subscribers: Data: 0.02MB + Index: 0.13MB + Engine InnoDB wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_mailpoet_subscriber_segment: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 26.02MB + Index: 5.08MB + Engine InnoDB wp_pimwick_gift_card: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_pimwick_gift_card_activity: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_postmeta: Data: 60.25MB + Index: 13.58MB + Engine InnoDB wp_posts: Data: 19.39MB + Index: 1.25MB + Engine InnoDB wp_seraph_accel_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.05MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_tinvwl_analytics: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_tinvwl_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_tinvwl_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_trp_dictionary_de_de_en_gb: Data: 0.47MB + Index: 0.50MB + Engine InnoDB wp_trp_gettext_de_de: Data: 1.52MB + Index: 0.66MB + Engine InnoDB wp_trp_gettext_en_gb: Data: 1.52MB + Index: 0.72MB + Engine InnoDB wp_trp_gettext_ru_ru: Data: 1.52MB + Index: 0.50MB + Engine InnoDB wp_trp_original_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_trp_original_strings: Data: 0.38MB + Index: 0.31MB + Engine InnoDB wp_usermeta: Data: 1.39MB + Index: 0.44MB + Engine InnoDB wp_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_wcpdf_credit_note_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wcpdf_packing_slip_number: Data: 0.08MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wc_customer_lookup: Data: 0.19MB + Index: 0.14MB + Engine InnoDB wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.06MB + Engine InnoDB wp_wc_order_product_lookup: Data: 0.31MB + Index: 0.34MB + Engine InnoDB wp_wc_order_stats: Data: 0.34MB + Index: 0.34MB + Engine InnoDB wp_wc_order_tax_lookup: Data: 0.09MB + Index: 0.09MB + Engine InnoDB wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + 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_wdi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wdi_themes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_wpf_meta_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_wpf_meta_values: Data: 0.02MB + Index: 38.88MB + Engine InnoDB wp_wpf_meta_values_bk: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_indexable: Data: 1.52MB + Index: 0.70MB + Engine InnoDB wp_yoast_indexable_hierarchy: Data: 0.05MB + Index: 0.05MB + Engine InnoDB wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_yoast_seo_links: Data: 0.05MB + Index: 0.03MB + Engine InnoDB

Post Type Counts

acf-field: 11 acf-field-group: 2 attachment: 950 custom_css: 1 customize_changeset: 2 elementor_font: 2 elementor_icons: 1 elementor_library: 12 elementor_snippet: 3 gift_card: 1 giftcard: 1 language_switcher: 2 mailpoet_page: 1 nav_menu_item: 5 oembed_cache: 1 page: 40 post: 5 product: 26 product_variation: 132 revision: 2602 shop_coupon: 225 shop_order: 2855 shop_order_refund: 701 wdi_instagram: 1 yith_wcan_preset: 1

Security

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

Active Plugins (36)

Advanced Custom Fields PRO: by Delicious Brains – 5.10.2 Ajax Cart AutoUpdate for WooCommerce: by taisho – 1.5.5 Activity Log: by Activity Log Team – 2.8.1 Cloudflare: by Cloudflare Inc. – 4.7.0

DHL for WooCommerce: by DHL – 2.7.6 Elementor Pro: by Elementor.com – 3.5.2 Elementor: by Elementor.com – 3.4.8 Elfsight Instagram Feed CC: by Elfsight – 4.0.2 Facebook for WooCommerce: by Facebook – 2.6.7 Google Listings and Ads: by WooCommerce – 1.9.0 Loco Translate: by Tim Whitlock – 2.5.5 Pixel Caffeine: by AdEspresso – 2.3.3 Qty Increment Buttons for WooCommerce: by taisho – 2.7.5 ERP_Sync: by Ruslan Denisevich – 1.0 TI WooCommerce Wishlist: by TemplateInvaders – 1.29.0 TranslatePress - Multilingual: by Cozmoslabs Razvan Mocanu Madalin Ungureanu Cristophor Hurduban – 2.1.7

Ultimate Addons for Elementor: by Brainstorm Force – 1.35.1 Google Analytics and Google Tag Manager by WebKinder: by WebKinder – 1.9.4 Checkout Field Editor for WooCommerce: by ThemeHigh – 1.5.1 Edit WooCommerce Templates: by ioannup – 1.1.1 Ultimate Gift Cards For WooCommerce: by MakeWebBetter – 2.2.2 Advanced Order Export For WooCommerce: by AlgolPlus – 3.2.1 Additional Variation Images Gallery for WooCommerce - Pro: by Emran Ahmed – 1.2.7 Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.2.8 Variation Swatches for WooCommerce - Pro: by Emran Ahmed – 1.1.17 Variation Swatches for WooCommerce: by Emran Ahmed – 1.1.19 WooCommerce Stripe Gateway: by WooCommerce – 5.8.1 WooCommerce Google Analytics Integration: by WooCommerce – 1.5.4 WooCommerce PayPal Payments: by WooCommerce – 1.6.1 (update to version 1.6.4 is available) WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.11.1 WooCommerce PDF Invoices & Packing Slips Professional: by Ewout Fernhout – 2.8.0 WooCommerce: by Automattic – 6.0.0 (update to version 6.1.0 is available) WooLentor Pro: by HasThemes – 1.8.2 WooLentor - WooCommerce Elementor Addons + Builder: by HasThemes – 2.1.2 Yoast SEO: by Team Yoast – 17.9 WP Crontrol: by John Blackbourn & crontributors – 1.12.0

Inactive Plugins (5)

Actions Pack: by Wpfolk – 2.3.4 Coming Soon Badge for WooCommerce: by wpcentrics – 1.0.10 Complianz | GDPR/CCPA Cookie Consent: by Really Simple Plugins – 5.5.2 Product Variation Swatches for Woocommerce: by ThemeHigh – 2.0.5 W3 Total Cache: by BoldGrid – 2.2.1

Dropin Plugins (1)

maintenance.php: maintenance.php

Settings

API Enabled: – Force SSL: – Currency: EUR (€) Currency Position: right_space 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) wgm_gift_card (wgm_gift_card)

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#14 - /shop/ Cart: woocommerce/woocommerce#15 - /cart/ Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block. My account: ❌ Page does not contain the [woocommerce_my_account] shortcode. Terms and conditions: ❌ Page not set

Theme

Name: style-republic Version: 1.4 Author URL: 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: style-republic/woocommerce/archive-product.php style-republic/woocommerce/cart/cart-totals.php style-republic/woocommerce/cart/cart.php style-republic/woocommerce/checkout/form-billing.php style-republic/woocommerce/checkout/form-checkout.php style-republic/woocommerce/checkout/review-order.php style-republic/woocommerce/checkout/thankyou.php style-republic/woocommerce/content-product.php style-republic/woocommerce/emails/customer-processing-order.php style-republic/woocommerce/emails/email-order-details.php style-republic/woocommerce/emails/plain/email-order-details.php style-republic/woocommerce/myaccount/form-edit-account.php style-republic/woocommerce/myaccount/my-orders.php style-republic/woocommerce/myaccount/orders.php /var/www/vhosts/style-republic.eu/style-republic.eu/httpdocs/wp-content/plugins/woo-variation-gallery/templates/product-images.php /var/www/vhosts/style-republic.eu/style-republic.eu/httpdocs/wp-content/plugins/woo-variation-gallery/templates/product-thumbnails.php style-republic/woocommerce/single-product.php

WooCommerce PayPal Payments

Onboarded: Yes Shop country code: DE PayPal card processing available in country: No Pay Later messaging available in country: Yes Vault enabled: Yes

TI WooCommerce Wishlist Templates

Overrides: –

Action Scheduler

Canceled: 2 Oldest: 2021-12-20 21:38:25 +0000 Newest: 2021-12-20 21:38:25 +0000

Complete: 22,319 Oldest: 2021-12-12 13:08:51 +0000 Newest: 2022-01-12 12:42:55 +0000

Pending: 4 Oldest: 2022-01-12 16:32:49 +0000 Newest: 2022-01-13 12:12:41 +0000

Status report information

Generated at: 2022-01-12 13:54:31 +01:00 `

Isolating the problem

[X] I have deactivated other plugins and confirmed this bug occurs when only WooCommerce plugin is active.
[ ] This bug happens with a default WordPress theme active, or Storefront.
[X] I can reproduce this bug consistently using the steps above.

lanej0 commented 2 years ago

Hi @KseniaTseiko,

Thanks for taking the time to report this. We'll try reproducing this issue on our end and give you a shout if we need any further details!

swatipawarGS commented 2 years ago

Hi @KseniaTseiko ,

Thank you for taking the time to report this bug, we really appreciate your help. We are able to reproduce the issue on our end using WooCommerce 6.1.0 version and WordPress 5.8.3 version.

Please find below screencast for reference :

https://user-images.githubusercontent.com/94531721/149290407-46aa5dd9-5999-4d87-a0b7-1e6fdd57c48a.mp4

Priority of this issue will be assigned shortly after we’d go through a round of prioritization. Please note it may take a couple of days.

vedanshujain commented 2 years ago

I have moved this issue to the admin repo, who would be the correct team to handle this.

louwie17 commented 2 years ago

Thanks for creating this issue @KseniaTseiko, This is a duplicate of #7681, and a fix has been released with WooCommerce Admin 3.1, this should be present in the next WooCommerce release (6.2), which will be released next week. If you find the issue still persisting in WooCommerce 6.2, please re-open this issue.

woocommerce / woocommerce-admin