Items entered into coupon “Allowed emails” field disappear

  • Resolved rickjohnsongraffix

    (@rickjohnsongraffix)


    5 months, 2 weeks ago

    Ever since WooCommerce added the option to restrict coupon codes to certain email addresses, I have been using it without issue. I don’t know how long ago this behavior changed, but now all coupons show “No restrictions” for emails where there used to be several. When I add an email address, it appears to try to update, but the field again becomes blank with “No restrictions.”

    I tried updating to the newest WooCommerce, but after I did I could not log into my site — instead got “Forbidden” error. Backdating to 8.4.0 let me log in again. I have seen this question posted before, but no solution given. Any help would be much appreciated.

    Thanks — Rick

    WordPress Environment<br><br>WordPress address (URL): https://rj-graffix.com<br>Site address (URL): https://rj-graffix.com<br>WC Version: 8.4.0<br>REST API Version: ? 8.4.0<br>WC Blocks Version: ? 11.6.2<br>Action Scheduler Version: ? 3.7.2<br>Log Directory Writable: ?<br>WP Version: 6.5.4<br>WP Multisite: –<br>WP Memory Limit: 256 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_US<br>External object cache: – Server Environment<br><br>Server Info: nginx/1.26.1<br>PHP Version: 8.0.30<br>PHP Post Max Size: 134 MB<br>PHP Time Limit: 30<br>PHP Max Input Vars: 1000<br>cURL Version: 7.29.0<br>NSS/3.90<br><br>SUHOSIN Installed: –<br>MySQL Version: 5.5.68-MariaDB<br>Max Upload Size: 16 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database<br><br>WC Database Version: 8.9.2<br>WC Database Prefix: wp_<br>Total Database Size: 228.01MB<br>Database Data Size: 196.40MB<br>Database Index Size: 31.61MB<br>wp_woocommerce_sessions: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 3.39MB + Index: 6.47MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 0.31MB + Index: 0.13MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 7.39MB + Index: 5.02MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.08MB + Index: 0.16MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_404_to_301: Data: 14.55MB + Index: 0.00MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 0.13MB + Index: 0.13MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB<br>wp_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_connection_reports: Data: 0.31MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_no_cookie_data: Data: 2.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_sessions: Data: 0.36MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_sfw: Data: 0.48MB + Index: 0.41MB + Engine InnoDB<br>wp_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_sfw_personal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_comments: Data: 1.52MB + Index: 0.91MB + Engine InnoDB<br>wp_groups_capability: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_groups_group: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_groups_group_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_groups_user_capability: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_groups_user_group: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_jetpack_sync_queue: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_options: Data: 6.02MB + Index: 1.11MB + Engine InnoDB<br>wp_postmeta: Data: 108.25MB + Index: 9.50MB + Engine InnoDB<br>wp_posts: Data: 41.22MB + Index: 0.67MB + Engine InnoDB<br>wp_spbc_auth_logs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.16MB + Index: 0.13MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_tf_storage: Data: 1.05MB + Index: 0.06MB + Engine InnoDB<br>wp_usermeta: Data: 3.50MB + Index: 3.86MB + Engine InnoDB<br>wp_users: Data: 0.17MB + Index: 0.17MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 0.16MB + Index: 0.13MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.13MB + Index: 0.16MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 1.52MB + Index: 0.55MB + Engine InnoDB<br>wp_wc_order_stats: Data: 0.20MB + Index: 0.19MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_software_licence: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 0.20MB + Index: 0.19MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.28MB + Index: 0.16MB + Engine InnoDB<br>wp_yoast_seo_meta: Data: 0.05MB + Index: 0.00MB + Engine InnoDB Post Type Counts<br><br>attachment: 258<br>custom_css: 1<br>form-entries: 125<br>forum: 6<br>jetpack_migration: 2<br>library_rows: 1<br>nav_menu_item: 646<br>oembed_cache: 10<br>page: 72<br>post: 111<br>product: 16<br>product_variation: 147<br>redirect_rule: 5<br>reply: 80<br>revision: 824<br>shop_coupon: 106<br>shop_order: 1313<br>shop_order_refund: 21<br>tablepress_table: 1<br>tbuilder_layout_part: 2<br>themify_popup: 1<br>topic: 53<br>wcccf: 3<br>wp_global_styles: 1<br>wpforms: 4 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (46)<br><br>ManageWP - Worker: by GoDaddy – 4.9.20<br>404 to 301 - Redirect, Log and Notify 404 Errors: by Joel James – 3.1.4<br>Registration Order Link for WooCommerce: by SkyVerge – 1.0.0<br>bbPress WP Tweaks: by veppa – 1.4.4<br>bbPress: by The bbPress Contributors – 2.6.9<br>Better Search Replace: by WP Engine – 1.4.7<br>Classic Editor: by WordPress Contributors – 1.6.3<br>Anti-Spam by CleanTalk: by СleanTalk - Anti-Spam Protection – 6.33.2<br>Crowdsignal Forms: by Automattic – 1.7.1<br>Customizer Export/Import: by The Beaver Builder Team – 0.9.6<br>Disable New User Notifications: by Thomas Griffin – 2.0.0<br>Display PHP Version: by David Gwyer – 1.8<br>Simple File List Pro: by Mitchell Bennis – 6.1.12<br>Enable Media Replace: by ShortPixel – 4.1.5<br>XML Sitemap Generator for Google: by Auctollo – 4.1.19<br>Groups 404 Redirect: by itthinx – 1.8.0<br>Groups: by itthinx – 2.20.1<br>Image Upload for BBPress: by WP Zone – 1.1.19<br>ImageMagick Engine: by Orangelab – 1.7.8<br>Import and export users and customers: by codection – 1.26.7<br>Jetpack: by Automattic – 13.5<br>Official StatCounter Plugin: by Aodhan Cullen – 2.0.9<br>Really Simple SSL: by Really Simple Plugins – 8.1.3<br>Stop Comment Spam: by Predrag Supurovi? – 0.5.3<br>TablePress: by Tobias B?thge – 2.3.2<br>Temporary Login Without Password: by StoreApps – 1.8.3<br>Theme My Login: by Theme My Login – 7.1.7<br>Themify Portfolio Post: by Themify – 1.2.9<br>Themify Shortcodes: by Themify – 2.1.1<br>Themify Updater: by Themify – 1.4.8<br>UpdraftPlus - Backup/Restore: by UpdraftPlus.Com<br>DavidAnderson – 1.24.3<br><br>WC Fields Factory: by Saravana Kumar K – 4.1.8<br>Advanced Order Export For WooCommerce: by AlgolPlus – 3.5.3<br>WooCommerce Chained Products: by StoreApps – 3.5.0<br>Woocommerce Checkout Terms Conditions Popup: by WC Marketplace – 1.2.2<br>Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 5.0.0<br>WooCommerce Email Validation: by Hugh Lashbrooke – 2.1.1<br>WooCommerce Stripe Gateway: by WooCommerce – 8.3.1<br>WooCommerce Import Tax Rate Tables: by Katherine Semel-Munson – 1.9<br>WooCommerce Legacy REST API: by WooCommerce – 1.0.4<br>WP Software License: by Nsp Code – 3.3.8<br>WooCommerce: by Automattic – 8.4.0 (update to version 8.9.2 is available)<br>WordPress Importer: by wordpressdotorg – 0.8.2<br>Yoast SEO: by Team Yoast – 22.8<br>WPForms Lite: by WPForms – 1.8.8.3<br>Custom Product Tabs for WooCommerce: by Code Parrots – 1.8.5 Inactive Plugins (1)<br><br>WooCommerce: by Automattic – 8.9.2 Must Use Plugins (1)<br><br>ManageWP - Worker Loader: by GoDaddy – 1.0.0 Settings<br><br>API Enabled: ?<br>Force SSL: –<br>Currency: USD ($)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: external (external)<br>grouped (grouped)<br>simple (simple)<br>variable (variable)<br><br>Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)<br>exclude-from-search (exclude-from-search)<br>featured (featured)<br>outofstock (outofstock)<br>rated-1 (rated-1)<br>rated-2 (rated-2)<br>rated-3 (rated-3)<br>rated-4 (rated-4)<br>rated-5 (rated-5)<br><br>Connected to Woo.com: ?<br>Enforce Approved Product Download Directories: –<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages<br><br>Shop base: #17 - /shop/<br>Cart: #18 - /cart/<br>Checkout: #19 - /checkout/<br>My account: #20 - /my-account/<br>Terms and conditions: #1405 - /terms-and-conditions/ Theme<br><br>Name: Ultra Child<br>Version: (update to version 0 is available)<br>Author URL:<br>Child Theme: ?<br>Parent Theme Name: Themify Ultra<br>Parent Theme Version: 7.6.8<br>Parent Theme Author URL: https://www.themify.me<br>WooCommerce Support: ? Templates<br><br>Overrides: themify-ultra-child/woocommerce/emails/customer-completed-order.php<br>themify-ultra-child/woocommerce/emails/customer-invoice.php<br>themify-ultra/woocommerce/loop/loop-end.php<br>themify-ultra/woocommerce/loop/loop-start.php Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>product-virtual-downloadable<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page<br><br>Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-external-affiliate<br>settings<br>async-product-editor-category-field<br><br>Daily Cron: ? Next scheduled: 2024-06-07 14:28:25 -05:00<br>Options: ?<br>Notes: 181<br>Onboarding: completed Action Scheduler<br><br>Complete: 182<br>Oldest: 2024-05-07 13:38:50 -0500<br>Newest: 2024-06-06 14:18:04 -0500<br><br>Failed: 17<br>Oldest: 2023-02-17 07:47:00 -0600<br>Newest: 2024-04-22 10:41:39 -0500<br><br>Pending: 7<br>Oldest: 2024-06-07 01:25:23 -0500<br>Newest: 2024-06-12 00:21:12 -0500 Status report information<br><br>Generated at: 2024-06-06 15:43:50 -05:00<br>

    The page I need help with: [log in to see the link]

Viewing 15 replies - 16 through 30 (of 49 total)
  • Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    I did the steps outlined and nothing changed. After switching to Woo Commerce 9 the site was again inaccessible, but there were no fatal errors generated in Woo Commerce > Status > Tools. When I clicked the button to update the database, it returned the 403 Forbidden error.

    After switching back to Woo Commerce 8.4.0 things worked fine again, except for the coupon email problem.

    Plugin Support Shameem R. a11n

    (@shameemreza)

    Hi @rickjohnsongraffix

    When I clicked the button to update the database, it returned the 403 Forbidden error.

    The 403 Forbidden error usually indicates a permissions issue on your server and database. You may need to check your server’s file and folder permissions or contact your hosting provider for further assistance.

    the coupon email problem.

    Can you please provide more details? What exactly is the problem you’re experiencing? Is there an error message? This information will help us diagnose and resolve the issue more effectively.

    If possible, can you provide a video showing the issue on your end? For video, you may use https://loom.com or https://www.awesomescreenshot.com/. Please follow the instructions on that page and then paste the URL into this thread.

    Remember, downgrading to a previous version of WooCommerce is not recommended as it can cause data loss and other issues. We highly recommend creating a backup of your site before making any changes.

    We look forward to your response so we can assist you further.

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    Thanks for getting back to me. You must not have seen that there is a previous page to this thread. File/folder permissions have already been checked and verified as OK. Why would the 403 problem exist with Woo Commerce 9 but not for version 8.4 and earlier? What changed?

    As for email restrictions, other fields within Usage Restriction are saved — only email addresses are cleared on Update. Is there something I can check using MySQL?

    anastas10s

    (@anastas10s)

    Hi @rickjohnsongraffix

    I reverted to WooCommerce 8.4.0 and did the steps you listed, then put WooCommerce 9.0.1 back. When I try to log in I get the Forbidden error 403 again.

    Just to add, meanwhile, WooCommerce version 9.0.2 was released.

    Could you please test if the issue persists, when updating to it, or otherwise?

    We look forward to your response. In the meantime, please let us know if you have any further questions or concerns.

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    WooCommerce 9.0.2 does not solve the problem. I’m back to using 8.4.0.

    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi @rickjohnsongraffix,

    WooCommerce 9.0.2 does not solve the problem. I’m back to using 8.4.0.

    As I understand you’ve tried with 9.0.0 and above. From 8.4.0 to it, there have been 20 updates, from minor to major.

    More specifically I see this one in 8.8.0:

    Enhancement – Validate coupons with email restrictions upfront and change user’s feedback when a coupon is not valid for the user. #43872

    With this in mind, can you please try rolling back to the previous version, which is 8.7.1, and see if it works for you? If it works there, we could pinpoint that change as the culprit. Similarly, you could try 8.8.0 and see if it breaks again.

    Kindly let us know please. You can try a plugin like WP Rollback to test this quickly. You can also try this on a staging site.

    Cheers!
    -OP

    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi there ?? ,

    We haven’t heard from you in a while; this is to check if you’ve been able to proceed with the troubleshooting steps provided before and if you still need help.

    Thanks!
    -OP

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    I’m sorry, my last reply must not have gone through. I installed Rollback, and it’s been great. I found that the newest version of WooCommerce I can run is 8.4.1. 8.5 will cause the 403 Forbidden errors I described earlier. I have found that it is not a conflict with another plugin or a theme, and all files and folders have permissions as was recommended — I have permission for all.

    What changed between WooCommerce 8.4.1 and 8.5 that might cause the access problem? Is there anything I can check with a browser inspector window or other tool to help narrow it down? I have PHP 8.1.29,

    My web host says all of his clients have trouble with newer versions of WooCommerce, so maybe there is something at the server level affecting all users, something that I cannot change. Is there anything I can ask my web host to check that might break in WooCommerce 8.5?

    Plugin Support omarfpg a11n

    (@omarfpg)

    Hi @rickjohnsongraffix,

    Thanks for getting back to us! And thanks for confirming it works up to 8.4.1 and it breaks from 8.5 and above.

    8.5 came with big changes, like the Order Attribution feature. This particular feature also caused a bug for some users on certain hosts that caused a 403 error but this was on 8.5.1. This sounds similar to your case, though, as you also mention this seems to be a hosting issue!

    Can you try updating to 8.5.1 or above, and trying either of those two options, please?

    • Check with your host to see if ModSecurity is enabled. If that is the case, you may ask your host to adjust the firewall rules to allow the cookies set by Woo’s Order Attribution feature. You can find more information about the cookies used by this feature in our documentation.
    • If the above doesn’t work for you, disable the Order Attribution feature to prevent future users from seeing the 403 errors by going to WooCommerce > Settings > Advanced > Features and toggling the Order Attribution feature off.

    Learn more:

    Thanks!
    -OP

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    My web host did the checks you suggested and the 403 error with newer versions of WooCommerce remained.

    I disabled Order Attribution and that fixed the 403 errors! I’m now running the current version of WooCommerce with no apparent issues.

    Now I hope we can address my original problem, which was that emails entered into coupon restrictions did not get saved. Is there anything I can do about that?

    Thanks — Rick

    Plugin Support ckadenge (woo-hc)

    (@ckadenge)

    Hi Rick @rickjohnsongraffix,

    Thanks again for reaching out.

    Glad to hear you were able to solve the issues with 403 errors.

    my original problem, which was that emails entered into coupon restrictions did not get saved.

    I understand you’re having trouble saving allowed emails under coupon usage restrictions. I tried replicating this in my test store and was able to save emails without any issues.

    Could you please try clearing your browser cache or any server side related cache and try again? You can also try using a different email to see if the issue persists.

    Looking forward to your reply.

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    I cleared my browser cache, Themify menu cache, and WC Software License cache, and the problem remains. It affects any address entered, and all addresses previously entered are now missing. It had worked perfectly for years, but I just noticed recently that all email addresses were gone and could not be saved when entered again.

    I had not added or changed coupons for weeks, maybe months, when I noticed the email problem (I was at version 8.4.0 at the time) so there could have been updates to WordPress, PHP, and others that happened before I noticed the problem. I am now at WooCommerce 9.0.2 and the problem is there when I have no other plugins active and using the generic 2024 theme.

    Is there anything I can check using MySQL or a browser developer inspector panel?

    Hey, @rickjohnsongraffix!

    Since this thread is a bit long, let me confirm the steps already taken:

    • You have reinstalled Woo more than once
    • Tested with both 8.4 and 9.0.2
    • Tested while having a default theme on (2024) and all plugins but Woo deactivated

    Correct?

    Is there anything I can check using MySQL or a browser developer inspector panel?

    From what I gathered there’s no console errors on the coupon page when you try to add the email, correct?

    You mentioned that the emails that were added to old coupons are also missing, right?
    Can you check them on the database and see if the email_restrictions are missing there too?

    Looking forward to your reply.

    Have a wonderful day!

    Thread Starter rickjohnsongraffix

    (@rickjohnsongraffix)

    You are correct on all items.

    I don’t see email_restrictions in the WP database. The only thing coupon-related appears to be wp_wc_order_coupon_lookup.

    Plugin Support Zubair Zahid (woo-hc)

    (@doublezed2)

    Hello rickjohnsongraffix

    Thank you for your reply.

    The emails for coupons are stored in wp_postmeta table.

    Could you run this SQL query to confirm whether the emails are stored in the database?
    Please replace the “wp_” prefix with one used in your database and also replace the email “[email protected]” with the one you want to search.

    SELECT * FROM 'wp_postmeta' WHERE 'meta_value' LIKE '%[email protected]%'

    This test will clarify where the problem lies.
    After that, we can proceed with the next steps.

    Looking forward to your response. ??

    Best regards.

Viewing 15 replies - 16 through 30 (of 49 total)
  • You must be logged in to reply to this topic.