WooCommerce Analytics Coupon Search Query

Viewing 11 replies - 1 through 11 (of 11 total)

  • Hi, I am having a problem with the coupon tab to. It previously showed how much each coupon totalled to, in the 4 currencies we use, USD, AUD, GBP & EUR and now there is no drop down option to change which currency I want to view! This is something I use almost everyday and its all of a sudden gone…

    Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @kwebdesign. Sorry we missed your post. The screenshot/screencast are now deleted and I cannot access them. Does the issue still persist on your site?

    @grainnefleming. Since you’re not the person who originally started this topic, per the forum guidelines, would you please start your own topic? We’ll be happy to help you there. ??

    Thread Starter kwebdesign

    (@kwebdesign)

    Apologies… I’d moved the file and thought Dropbox coped with that.

    Here’s the link again…
    https://www.dropbox.com/s/fzhxo5xnqztt45t/WooCommerce%20Analytics%20Coupon%20Search%20Query.mp4?dl=0

    The results aren’t identical, but if I search for “salus7362-2033” I get one result and if I search for “salus7362” I get no results.

    Plugin Support Damianne P (a11n)

    (@drwpcom)

    Thanks @kwebdesign. That is odd. Are you using the latest version of WooCommerce with the built-in Analytics. This is a hard one to try to replicate. If you make a new coupon with a smiliar format salus7362-2***, do you have the same issue?

    Thread Starter kwebdesign

    (@kwebdesign)

    Sorry for the delayed reply.

    All the latest updates.

    I’ve created a blank install of WordPress with just WooCommerce.
    I’ve created two coupons and placed two orders (1 for each coupon), ensuring both coupons display in Analytics.

    Searching for the full coupon name removes the other coupon name, so that’s working.

    Searching for part of either coupon returns no data.

    See… https://www.dropbox.com/s/bi76xkeswzeiruj/WooCommerce%20Analytics%20Coupon%20Search%20Query%20-%20Clean%20Example.mp4?dl=0

    Plugin Support John Coy a11n

    (@johndcoy)

    Automattic Happiness Engineer

    Hi @kwebdesign

    I’m not able to replicate that problem, and orders don’t need to be processed for the coupons to show: https://d.pr/i/VDtsZg

    Could you provide us with the status report found under **WooCommerce > Status > Get system report** so that we can get a better idea of the site’s environment?

    Thread Starter kwebdesign

    (@kwebdesign)

    
### WordPress Environment ###

WordPress address (URL): https://woocoupon.devrap.co.uk
Site address (URL): https://woocoupon.devrap.co.uk
WC Version: 5.1.0
REST API Version: ? 5.1.0
WC Blocks Version: ? 4.4.3
Action Scheduler Version: ? 3.1.6
WC Admin Version: ? 2.0.2
Log Directory Writable: ?
WP Version: 5.7
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ?
WP Cron: –
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: nginx/1.18.0
PHP Version: 7.4.15
PHP Post Max Size: 64 MB
PHP Time Limit: 30
PHP Max Input Vars: 1000
cURL Version: 7.68.0
OpenSSL/1.1.1j

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.4.18-MariaDB-1:10.4.18+maria~focal
Max Upload Size: 64 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 5.1.0
WC Database Prefix: 5f7_
Total Database Size: 2.35MB
Database Data Size: 0.97MB
Database Index Size: 1.38MB
5f7_woocommerce_sessions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
5f7_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
5f7_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
5f7_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
5f7_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
5f7_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
5f7_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_options: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
5f7_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
5f7_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
5f7_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
5f7_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
5f7_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
5f7_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
5f7_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
5f7_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
5f7_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
5f7_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
5f7_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

### Post Type Counts ###

attachment: 1
page: 6
post: 2
product: 1
shop_coupon: 2
shop_order: 3

### Security ###

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

### Active Plugins (3) ###

Limit Login Attempts Reloaded: by Limit Login Attempts Reloaded – 2.20.6
SpinupWP: by Delicious Brains – 1.3
WooCommerce: by Automattic – 5.1.0

### Inactive Plugins (0) ###

### Dropin Plugins (1) ###

object-cache.php: SpinupWP Redis Object Cache Drop-In

### Must Use Plugins (1) ###

SpinupWP Debug Log Path: by Delicious Brains – 1.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)
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: ? Page not set

### Theme ###

Name: Twenty Twenty-One
Version: 1.2
Author URL: https://www.ads-software.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: 8
Oldest: 2021-04-06 11:48:56 +0000
Newest: 2021-04-06 12:02:10 +0000

### Status report information ###

Generated at: 2021-04-09 03:03:19 +00:00
    Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @kwebdesign. This is odd indeed. Are you able to check if deactivating server caching has an impact? I noticed the following in your system status report: object-cache.php: SpinupWP Redis Object Cache Drop-In

    Thread Starter kwebdesign

    (@kwebdesign)

    I’ve tried disabling the SpinupWP plugin before, but that doesn’t disable object cache, it just prevents it being auto cleared.

    I’ve therefore added the following to my functions.php file…
    define( ‘WP_REDIS_DISABLED’, true );

    I’ve also disabled Full Page Cache.

    I’ll message SpinupWP encase they’re interested in looking at this.

    You’re welcome to logins if you’d like, although I’m not expecting premium level support for WooCommerce core.

    Plugin Support Damianne P (a11n)

    (@drwpcom)

    Hi @kwebdesign. Generally, for this type of case, we’d try to replicate the issue to confirm that it’s with WooCommerce. We have tried to replicate the issue but haven’t been able to do that, which points to something unique to your case. I’m afraid that we won’t be able to dig into your specific site, which makes troubleshooting rather tricky.

    Thread Starter kwebdesign

    (@kwebdesign)

    That’s fair enough. If no one would like to look at the test area that I’ve set up, I’ll delete it and you can close this ticket.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘WooCommerce Analytics Coupon Search Query’ is closed to new replies.