peterwp99

Also as a side note, you should set up a staging site which doesn’t hold copies of real-world data and nor should it attach to the production version of Stripe. Forget all that “oh it’s running in staging and test mode” nonsense. I’ve looked at the delete-user hooks in WordPress code which woocommerce uses and it’s a disaster waiting to happen.

You should never trust hosting platforms or plugin developers by default, and even if it takes a bit of effort to set up a completely separate separate environment, you will de-risk your platform.

I’m relatively new to the WordPress ecommerce world having come from the corporate world with it’s control and compliance constraints, and it is staggering what is being done as standard out here by people who don’t have that experience.

Yeah there is no way to re-attach the payment method. You have to get the customer to re-add a payment method, get a report (see below script) of what their new PM from Stripe, then you can update the _stripe_source_id on the order and re-run the payment attempt in the wp backend – assuming your order is pending or failed.

E.g. here’s the SQL to update the source id for order 55754

UPDATE wp_postmeta SET meta_value = 'pm_<new pm_id>' where post_id = 55754 and meta_key = '_stripe_source_id';

If you had woocommerce debug running you can get a exhaustive list of detachments from the log file. You can the run a script to pull all the default payment methods from Stripe. Run that daily and track it somewhere to flag when your customers have updated their default payment method the run the SQL as per above.

Here’s an example in python:

import stripe
import csv
from datetime import datetime

# Set your Stripe secret key
stripe.api_key = 'sk_live_<key0>'

# List of affected customer IDs 
customer_ids = [
"cus_<id1>",
"cus_<id2>",
...
"cus_<idn>"
]

# List to store the results
results = []

# Iterate over each customer ID
for customer_id in customer_ids:
    try:
        # Retrieve the customer's payment methods
        payment_methods = stripe.PaymentMethod.list(
            customer=customer_id,
            type="card",
            limit=1
        )

        # If the customer has payment methods, extract the ID, created date, and email
        if payment_methods.data:
            payment_method = payment_methods.data[0]
            payment_method_id = payment_method.id
            payment_method_created = datetime.fromtimestamp(payment_method.created).strftime('%Y-%m-%d %H:%M:%S')
            customer = stripe.Customer.retrieve(customer_id)
            email = customer.email

            # Append the result to the list
            results.append({
                "customer_id": customer_id,
                "email": email,
                "payment_method_created": payment_method_created,
                "payment_method_id": payment_method_id,
            })
    except stripe.error.StripeError as e:
        print(f"Error retrieving payment methods for customer {customer_id}: {e}")

# Write the results to a CSV file
with open('stripe_customers_payment_methods.csv', mode='w', newline='') as file:
    writer = csv.DictWriter(file, fieldnames=["customer_id", "email", "payment_method_created","payment_method_id"])
    writer.writeheader()
    writer.writerows(results)

print("CSV file 'stripe_customers_payment_methods.csv' created successfully.")

@nbalcombe this was acknowledged as a bug with the new checkout experience and fixed. See here:

https://github.com/woocommerce/woocommerce-gateway-stripe/issues/3358

Thanks for replying

Confirm, it happened once and hasn’t happened again.

There were no fatal errors on that day.


Here is the snipboard of the Account details
https://snipboard.io/Iukbe4.jpg

Here is the System report

WordPress Environment<br><br>WordPress address (URL): https://dressageinstitute.com<br>Site address (URL): https://dressageinstitute.com<br>WC Version: 9.0.2<br>Legacy REST API Package Version: The Legacy REST API plugin is not installed on this site.<br>Action Scheduler Version: ? 3.7.4<br>Log Directory Writable: ?<br>WP Version: 6.6.1<br>WP Multisite: –<br>WP Memory Limit: 1 GB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_AU<br>External object cache: – Server Environment<br><br>Server Info: Apache<br>PHP Version: 7.4.33<br>PHP Post Max Size: 256 MB<br>PHP Time Limit: 600<br>PHP Max Input Vars: 3000<br>cURL Version: 8.2.1<br>OpenSSL/3.1.1<br><br>SUHOSIN Installed: –<br>MySQL Version: 8.0.36-28<br>Max Upload Size: 256 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: 9.0.2<br>WC Database Prefix: lin_<br>Total Database Size: 929.15MB<br>Database Data Size: 558.00MB<br>Database Index Size: 371.15MB<br>lin_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB<br>lin_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_woocommerce_order_items: Data: 1.52MB + Index: 1.44MB + Engine InnoDB<br>lin_woocommerce_order_itemmeta: Data: 115.52MB + Index: 10.00MB + Engine InnoDB<br>lin_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_woocommerce_payment_tokens: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>lin_woocommerce_payment_tokenmeta: Data: 0.16MB + Index: 0.16MB + Engine InnoDB<br>lin_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_actionscheduler_actions: Data: 32.08MB + Index: 21.16MB + Engine InnoDB<br>lin_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_actionscheduler_logs: Data: 26.06MB + Index: 23.06MB + Engine InnoDB<br>lin_apbd_wps_canned_msg: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_custom_field: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_debug_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_email_templates: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_imap_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_incoming_webhook: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_notification: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_apbd_wps_role: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_role_access: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_support_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_ticket: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_ticket_assign_rule: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_ticket_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_ticket_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_ticket_reply: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_apbd_wps_webhook: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_apbd_wps_woocommerce: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_automatewoo_abandoned_carts: Data: 0.05MB + Index: 0.08MB + Engine InnoDB<br>lin_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_automatewoo_customers: Data: 0.31MB + Index: 0.73MB + Engine InnoDB<br>lin_automatewoo_guest_meta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>lin_automatewoo_guests: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_automatewoo_log_meta: Data: 3.36MB + Index: 3.02MB + Engine InnoDB<br>lin_automatewoo_logs: Data: 1.52MB + Index: 0.81MB + Engine InnoDB<br>lin_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_automatewoo_queue_meta: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>lin_awb_critical_css: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bm_mentions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bm_message_messages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bm_message_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bm_message_recipients: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>lin_bm_moderation: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bm_thread_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bm_threads: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_appointments: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_customer_appointment_files: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_customer_appointments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>lin_bookly_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_email_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_gift_card_type_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_gift_card_type_staff: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_gift_card_types: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_gift_cards: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>lin_bookly_holidays: Data: 0.05MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_mailing_campaigns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_mailing_list_recipients: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_mailing_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_mailing_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_news: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_notifications_queue: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_payments: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_schedule_item_breaks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_sent_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_series: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_services: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_sessions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_shop: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_staff: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_staff_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_staff_preference_orders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_staff_schedule_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bookly_staff_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bookly_stats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_bookly_sub_services: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_activity: Data: 0.31MB + Index: 1.05MB + Engine InnoDB<br>lin_bp_activity_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_friends: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_groups: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_bp_groups_groupmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_groups_members: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>lin_bp_invitations: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>lin_bp_messages_messages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_messages_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_messages_notices: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bp_messages_recipients: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>lin_bp_notifications: Data: 0.09MB + Index: 0.14MB + Engine InnoDB<br>lin_bp_notifications_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_optouts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_bp_user_blogs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_user_blogs_blogmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_bp_xprofile_data: Data: 0.27MB + Index: 0.19MB + Engine InnoDB<br>lin_bp_xprofile_fields: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>lin_bp_xprofile_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_bp_xprofile_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_commentmeta: Data: 0.48MB + Index: 2.16MB + Engine InnoDB<br>lin_comments: Data: 24.55MB + Index: 25.59MB + Engine InnoDB<br>lin_fb3d_pages: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_fbv_attachment_folder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_frm_fields: Data: 1.34MB + Index: 0.03MB + Engine InnoDB<br>lin_frm_forms: Data: 0.11MB + Index: 0.02MB + Engine InnoDB<br>lin_frm_item_metas: Data: 4.52MB + Index: 6.52MB + Engine InnoDB<br>lin_frm_items: Data: 3.52MB + Index: 1.36MB + Engine InnoDB<br>lin_frm_payments: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_frm_subscriptions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_fusion_form_entries: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_fusion_form_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_fusion_form_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_fusion_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_indexnow_failed_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_indexnow_passed_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_ld_achievements: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_form: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_learndash_pro_quiz_lock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_master: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_prerequisite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_question: Data: 0.17MB + Index: 0.03MB + Engine InnoDB<br>lin_learndash_pro_quiz_statistic: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_statistic_ref: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>lin_learndash_pro_quiz_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_pro_quiz_toplist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_learndash_user_activity: Data: 21.55MB + Index: 45.80MB + Engine InnoDB<br>lin_learndash_user_activity_meta: Data: 3.50MB + Index: 3.98MB + Engine InnoDB<br>lin_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_login_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_mepr_events: Data: 1.52MB + Index: 1.44MB + Engine InnoDB<br>lin_mepr_jobs: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>lin_mepr_members: Data: 0.36MB + Index: 1.30MB + Engine InnoDB<br>lin_mepr_rule_access_conditions: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>lin_mepr_subscription_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_mepr_subscriptions: Data: 0.02MB + Index: 0.30MB + Engine InnoDB<br>lin_mepr_tax_rate_locations: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_mepr_tax_rates: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>lin_mepr_transaction_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_mepr_transactions: Data: 0.34MB + Index: 1.34MB + Engine InnoDB<br>lin_options: Data: 53.52MB + Index: 1.92MB + Engine InnoDB<br>lin_postmeta: Data: 102.78MB + Index: 144.06MB + Engine InnoDB<br>lin_posts: Data: 62.11MB + Index: 7.16MB + Engine InnoDB<br>lin_redirection_404: Data: 1.02MB + Index: 0.27MB + Engine InnoDB<br>lin_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_redirection_items: Data: 0.38MB + Index: 0.41MB + Engine InnoDB<br>lin_redirection_logs: Data: 6.02MB + Index: 3.05MB + Engine InnoDB<br>lin_sgs_log_events: Data: 9.02MB + Index: 6.08MB + Engine InnoDB<br>lin_sgs_log_visitors: Data: 1.47MB + Index: 0.63MB + Engine InnoDB<br>lin_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_tec_events: Data: 0.28MB + Index: 0.06MB + Engine InnoDB<br>lin_tec_occurrences: Data: 2.33MB + Index: 0.72MB + Engine InnoDB<br>lin_tec_posts_and_ticket_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_tec_series_relationships: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>lin_tec_ticket_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_term_relationships: Data: 0.17MB + Index: 0.09MB + Engine InnoDB<br>lin_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>lin_termmeta: Data: 8.03MB + Index: 0.98MB + Engine InnoDB<br>lin_terms: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>lin_usermeta: Data: 44.36MB + Index: 42.94MB + Engine InnoDB<br>lin_users: Data: 1.52MB + Index: 0.64MB + Engine InnoDB<br>lin_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>lin_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_wc_customer_lookup: Data: 0.23MB + Index: 0.19MB + Engine InnoDB<br>lin_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>lin_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>lin_wc_order_coupon_lookup: Data: 0.28MB + Index: 0.31MB + Engine InnoDB<br>lin_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_wc_order_product_lookup: Data: 1.52MB + Index: 0.67MB + Engine InnoDB<br>lin_wc_order_stats: Data: 1.52MB + Index: 0.59MB + Engine InnoDB<br>lin_wc_order_tax_lookup: Data: 0.39MB + Index: 0.36MB + Engine InnoDB<br>lin_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>lin_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wc_product_meta_lookup: Data: 0.05MB + Index: 0.11MB + Engine InnoDB<br>lin_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_wcpdf_packing_slip_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_wcs_payment_retries: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>lin_woocommerce_bundled_itemmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>lin_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>lin_wpf_logging: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_wpmailsmtp_email_tracking_events: Data: 1.02MB + Index: 0.23MB + Engine InnoDB<br>lin_wpmailsmtp_email_tracking_links: Data: 2.02MB + Index: 0.11MB + Engine InnoDB<br>lin_wpmailsmtp_emails_log: Data: 3.02MB + Index: 1.06MB + Engine InnoDB<br>lin_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_xyz_ips_short_code: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>lin_yoast_indexable: Data: 3.52MB + Index: 1.84MB + Engine InnoDB<br>lin_yoast_indexable_hierarchy: Data: 0.44MB + Index: 0.63MB + Engine InnoDB<br>lin_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>lin_yoast_primary_term: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>lin_yoast_seo_links: Data: 1.34MB + Index: 0.22MB + Engine InnoDB Post Type Counts<br><br>3d-flip-book: 1<br>acf-field: 4<br>acf-field-group: 2<br>after_checkout_ob: 1<br>attachment: 488<br>avada_faq: 4<br>aw_workflow: 36<br>awb_off_canvas: 17<br>bp-email: 21<br>buddypress: 3<br>csp_rules: 1<br>dearpdf: 171<br>dflip: 1<br>forum: 10<br>frm_form_actions: 71<br>frm_styles: 3<br>fusion_element: 204<br>fusion_form: 4<br>fusion_icons: 2<br>fusion_tb_layout: 24<br>fusion_tb_section: 44<br>fusion_template: 27<br>groups: 1<br>memberpressproduct: 1<br>nav_menu_item: 24<br>oembed_cache: 5<br>page: 165<br>post: 1<br>product: 59<br>product_variation: 128<br>reply: 2341<br>revision: 265<br>seedprod: 1<br>sfwd-certificates: 1<br>sfwd-courses: 15<br>sfwd-lessons: 1081<br>sfwd-question: 56<br>sfwd-quiz: 6<br>sfwd-topic: 277<br>shop_coupon: 88<br>shop_order: 7176<br>shop_order_refund: 190<br>shop_subscription: 1247<br>slide: 26<br>sumo_payment_plans: 5<br>sumo_pp_cron_jobs: 156<br>sumo_pp_payments: 155<br>ticket-meta-fieldset: 2<br>topic: 1344<br>tribe_event_series: 4<br>tribe_events: 198<br>tribe_organizer: 2<br>tribe_rsvp_attendees: 2088<br>tribe_rsvp_tickets: 633<br>tribe-ea-record: 8<br>wp_global_styles: 1<br>wp_navigation: 1 Security<br><br>Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (73)<br><br>Direct checkout, WooCommerce Single page checkout , WooCommerce One page checkout - PRO: by PI Websolution – 1.3.9.42<br>Advanced Access Manager: by AAM – 6.9.32<br>Advanced Custom Fields: by WP Engine – 6.3.2<br>Advanced Database Cleaner: by Younes JFR. – 3.1.4<br>Autocomplete Address and Location Picker for WooCommerce: by powerfulwp – 1.1.8<br>AutomateWoo: by WooCommerce – 6.0.27<br>bbPress Toolkit: by Pascal Casier – 1.0.12<br>bbPress Notify (No-Spam): by <a href="https://usestrict.net">Vinny Alves (UseStrict Consulting)</a> – 2.18.3<br>bbPress: by The bbPress Contributors – 2.6.9<br>Bookly Custom Fields (Add-on): by Nota-Info – 4.3<br>Bookly Files (Add-on): by Nota-Info – 3.6<br>Bookly Pro (Add-on): by Nota-Info – 8.0<br>Bookly: by Nota-Info – 23.6<br>BuddyPress: by The BuddyPress Community – 12.5.1<br>Cloudflare: by Cloudflare<br>Inc. – 4.12.7<br><br>The Events Calendar Countdown Addon: by Cool Plugins – 1.4.8<br>Custom Product Tabs Pro: by Code Parrots – 1.2.6<br>DearPDF Lite: by DearHive – 2.0.38<br>Duplicate Page: by mndpsingh287 – 4.5.3<br>Email Templates: by wpexpertsio – 1.4.3<br>Event Tickets Plus: by The Events Calendar – 5.10.2<br>Event Tickets: by The Events Calendar – 5.11.0.4<br>The Events Calendar Pro: by The Events Calendar – 6.5.0<br>The Events Calendar: Virtual Events: by The Events Calendar – 1.15.8<br>Facebook for WooCommerce: by Facebook – 3.2.4<br>FileBird Lite: by Ninja Team – 6.3<br>Formidable Datepicker Options: by Strategy11 – 2.0.4<br>Formidable Geolocation: by Strategy11 – 1.3<br>Formidable Locations: by Strategy11 – 2.03<br>Formidable Forms Pro: by Strategy11 – 6.11<br>Formidable Registration: by Strategy11 – 2.13<br>Formidable Stripe: by Strategy11 – 3.1.5<br>Formidable Surveys: by Strategy11 – 1.1.1<br>Formidable Forms: by Strategy11 Form Builder Team – 6.11<br>RD Theme Builder: by RD Theme – 3.11.9<br>RD Theme Core: by RD Theme – 5.11.9<br>RD Theme Custom Branding: by RD Theme – 1.2<br>HandL UTM Grabber: by Haktan Suren – 2.7.27<br>Index WP MySQL For Speed: by Oliver Jones<br>Rick James – 1.4.18<br><br>IndexNow: by Microsoft Bing – 1.0.3<br>Insert PHP Code Snippet: by xyzscripts.com – 1.3.5<br>LearnDash LMS - bbPress Integration: by LearnDash – 2.2.3<br>LearnDash LMS - Certificate Builder: by LearnDash – 1.0.4<br>LearnDash Licensing & Management: by LearnDash – 1.3<br>Loco Translate: by Tim Whitlock – 2.6.10<br>Login as User: by Web357 – 1.5.0<br>Maximum Products per User for WooCommerce Pro: by WPFactory – 3.8.5<br>Quantity Discounts Child: by Plugify – 1.0.0<br>Quantity Discounts & Pricing For Woocommerce: by Plugify – 5.0.1<br>Redirection: by John Godley – 5.4.2<br>Role Based Pricing for WooCommerce: by Addify – 2.1.1<br>LearnDash LMS: by LearnDash – 4.10.1<br>Security Optimizer: by SiteGround – 1.5.1<br>SUMO Payment Plans: by Fantastic Plugins – 10.1<br>The Events Calendar: by The Events Calendar – 6.6.0.1<br>Event Tickets Extension: Organizer Notifications: by The Events Calendar – 1.0.2<br>Event Tickets Extension: Ticket Email Settings: by The Events Calendar – 1.0.4<br>Wicked Folders: by Wicked Plugins – 3.0.4<br>WooCommerce.com Update Manager: by Automattic – 1.0.3<br>WooCommerce Stripe Gateway: by WooCommerce – 8.4.0<br>Google Analytics for WooCommerce: by WooCommerce – 2.1.3<br>PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 3.8.4<br>Woo Product Bundles: by Woo – 7.1.2<br>WooCommerce Smart Coupons: by StoreApps – 9.4.0<br>WooCommerce Subscriptions: by WooCommerce – 6.4.0<br>WooCommerce: by Automattic – 9.0.2 (update to version 9.1.4 is available)<br>Yoast SEO: by Team Yoast – 22.9<br>WP Crontrol: by John Blackbourn – 1.16.3<br>WP Fusion - Logins Addon: by Very Good Plugins – 1.3.3<br>WP Fusion - User Roles Addon: by Very Good Plugins – 1.2.1<br>WP Fusion: by Very Good Plugins – 3.43.15<br>WP Mail SMTP Pro: by WP Mail SMTP – 4.0.2<br>Custom Product Tabs for WooCommerce: by Code Parrots – 1.8.5 Inactive Plugins (3)<br><br>One Click Upsell Funnel for Woocommerce: by WP Swings – 3.4.5<br>One Click Upsell Funnel For WooCommerce Pro: by WP Swings – 4.2.6<br>Speed Optimizer: by SiteGround – 7.6.2 Must Use Plugins (1)<br><br>Index WP MySQL For Speed Upgrade Filter for mu-plugins.: by – 1.4.13 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: bundle (bundle)<br>course (course)<br>external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)<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 WooCommerce.com: ?<br>Enforce Approved Product Download Directories: ?<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – Logging<br><br>Enabled: ?<br>Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2<br>Retention period: 30 days<br>Level threshold: –<br>Log directory size: 12 MB WC Pages<br><br>Shop base: #17408 - /programs/<br>Cart: ? Page does not contain the [woocommerce_cart] shortcode or the woocommerce/cart block.<br>Checkout: ? Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.<br>My account: ? Page does not contain the [woocommerce_my_account] shortcode.<br>Terms and conditions: #5208 - /service-terms/ Theme<br><br>Name: Avada Child<br>Version: 1.0.0<br>Author URL: https://theme-fusion.com<br>Child Theme: ?<br>Parent Theme Name: Avada<br>Parent Theme Version: 7.11.9<br>Parent Theme Author URL: https://themeforest.net/user/ThemeFusion<br>WooCommerce Support: ? Templates<br><br>Overrides: Avada/woocommerce/cart/cart.php<br>Avada/woocommerce/checkout/form-pay.php<br>Avada/woocommerce/checkout/review-order.php<br>Avada/woocommerce/checkout/thankyou.php<br>Avada-Child-Theme/woocommerce/emails/customer-processing-order.php<br>Avada/woocommerce/loop/loop-start.php<br>Avada/woocommerce/single-product/add-to-cart/variable.php<br>Avada/woocommerce/single-product/short-description.php<br>Avada/woocommerce/single-product/tabs/additional-information.php<br>Avada/woocommerce/single-product/tabs/description.php Subscriptions<br><br>WCS_DEBUG: ? No<br>Subscriptions Mode: ? Live<br>Subscriptions Live URL: https://dressageinstitute.com<br>Subscriptions-core Library Version: 7.2.0<br>Subscription Statuses: wc-active: 614<br>wc-expired: 4<br>wc-pending-cancel: 16<br>wc-pending: 31<br>wc-on-hold: 165<br>wc-cancelled: 417<br><br>WooCommerce Account Connected: ? Yes<br>Active Product Key: ? No<br>Custom Retry Rules: ? No<br>Custom Retry Rule Class: ? No<br>Custom Raw Retry Rule: ? No<br>Custom Retry Rule: ? No<br>Retries Migration Status: ? Completed<br>Report Cache Enabled: ? Yes<br>Cache Update Failures: ? 0 failure Store Setup<br><br>Country / State: Australia — Queensland Subscriptions by Payment Gateway<br><br>Stripe: wc-active: 366<br>wc-cancelled: 399<br>wc-expired: 2<br>wc-on-hold: 140<br>wc-pending-cancel: 15<br><br>other: wc-cancelled: 8<br>wc-on-hold: 12 Payment Gateway Support<br><br>Stripe: products<br>refunds<br>tokenization<br>add_payment_method<br>subscriptions<br>subscription_cancellation<br>subscription_suspension<br>subscription_reactivation<br>subscription_amount_changes<br>subscription_date_changes<br>subscription_payment_method_change<br>subscription_payment_method_change_customer<br>subscription_payment_method_change_admin<br>multiple_subscriptions Product Bundles<br><br>Database Version: 7.1.2<br>Loopback Test: ?<br>Template Overrides: – Admin<br><br>Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customize-store<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-custom-fields<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: minified-js<br>new-product-management-experience<br>pattern-toolkit-full-composability<br>product-pre-publish-modal<br>settings<br>async-product-editor-category-field<br>launch-your-store<br>product-editor-template-system<br><br>Daily Cron: ? Next scheduled: 2024-07-31 04:32:59 +10:00<br>Options: ?<br>Notes: 43<br>Onboarding: completed Action Scheduler<br><br>Canceled: 10<br>Oldest: 2024-07-09 19:22:05 +1000<br>Newest: 2024-07-30 10:42:13 +1000<br><br>Complete: 59,348<br>Oldest: 2024-06-30 02:44:52 +1000<br>Newest: 2024-07-31 02:42:47 +1000<br><br>Failed: 34<br>Oldest: 2023-11-07 12:24:12 +1100<br>Newest: 2024-07-29 10:04:42 +1000<br><br>Pending: 683<br>Oldest: 2024-07-31 02:43:46 +1000<br>Newest: 2025-07-21 12:41:58 +1000 Smart Coupons related settings<br><br>?* Number of coupons to show: 3<br>?* Number of characters in auto-generated coupon code:<br>?* Valid order status for auto-generating coupon: Processing | Completed<br>?* Include tax in the amount of the generated gift card: ? No<br>?* Deduct credit/gift before doing tax calculations: ? No<br>?* Gift Card discount is inclusive of tax: ? No<br>?* Automatic deletion: ? No<br>?* Coupon emails: ? Yes<br>?* Printing coupons: ? Yes<br>?* Sell gift cards at less price: ? No<br>?* Use gift card applied in first subscription order for subsequent renewals until credit reaches zero: ? Yes<br>?* Renewal orders should not generate coupons even when they include a product that issues coupons: ? No<br>?* Allow sending of coupons to others: ? Yes<br>?* Allow schedule sending of coupons: ? No<br>?* Combine emails: ? No<br>?* Auto generated coupon email: ? Yes<br>?* Combined auto generated coupons email: ? No<br>?* Acknowledgement email: ? Yes<br>?* Enable taxes: ? Yes<br>?* Prices entered with tax: ? Yes<br>?* Display prices in the shop: ? Incl<br>?* Display prices during cart and checkout: ? Incl<br>?* Rounding: ? Yes<br>?* Display tax totals: Itemized<br>?* Enable the use of coupon codes: ? Yes<br>?* Calculate coupon discounts sequentially: ? No<br>?* Account endpoints > Coupons: wc-smart-coupons<br>?* Block-enabled Cart: ? No<br>?* Block-enabled Checkout: ? No<br>?* WooCommerce Account Connected: ? Yes Status report information<br><br>Generated at: 2024-07-31 02:43:54 +10:00<br>