WooCommerce detaching payment methods from Stripe
-
On 10/07/2024 a series of 800+ calls was made to our Stripe backend over the period of an hour.
The calls looked scripted. It started with a GET with this payload to get payment methods
/v1/payment_methods{
"customer":"<customer_id>",
"limit":"100",
"type":"card",
}
Followed by a POST to /v1/payment_methods/<pm_id>/detach
The source was our web server and the WooCommerce Stripe plugin:IP<Our server IP>
Source: WooCommerce Stripe Gateway/8.4.0 (https://woocommerce.com/products/stripe/)
User agent: WooCommerce Stripe Gateway/8.4.0 (https://woocommerce.com/products/stripe/)
Trying to identify the root cause of this and checking that there is nothing in WooCommerce that would natively kick off a process for doing this?
- This topic was modified 4 months ago by peterwp99.
-
Hey there, @peterwp99! Thanks for contacting us. I’m happy to help you.
To confirm, this happened on July 10 and it did not happen again, correct?
If you go to WooCommerce > Status > Logs do you see any fatal errors or Stripe errors on July 10?
Can you please share a screenshot of what you see on WooCommerce > Settings > Payments > Stripe > Settings > Account details?
I recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.Can you also please share the System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support?
Looking forward to your reply.
Have a wonderful day!
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.jpgHere 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>
Hi @peterwp99
Thanks for sharing detailed information and the system report. It’s quite strange that this happened once and hasn’t happened again.
From the details you’ve shared, it doesn’t seem like there were any fatal errors or issues with your WooCommerce setup or the Stripe Gateway Plugin that could have caused this.
However, the number of calls and the specific API endpoints suggested this could have been a scripted event, possibly for testing or malicious purposes.
This is not a behavior that WooCommerce or the Stripe Gateway Plugin would natively initiate.
I recommend checking your server access logs around the time of the incident to see if there were any suspicious activities. You should also ensure that your website is secure and consider changing your API keys as a precautionary measure.
Additionally, please upgrade your WooCommerce from 9.0.2 to the latest version for better security and optimal performance.
In the meantime, please monitor your logs closely and let us know if you notice anything similar happening again.
I wish I could help more, but hopefully, this provides some clarity. Please let us know if you have any other questions!
Hi @peterwp99
I’m marking this topic as “resolved” due to recent inactivity. If more assistance is needed, feel free to post back here or open a new topic.
Thanks!
Hi,
I’m having exactly the same issue. Did you work out what was going on? There is a period of around 8 mins just over a month ago where a load of detach requests are sent for payment methods.
Thanks, Neil.
Hey @nbalcombe ,
I’m sorry to hear that you’re experiencing the same issue!
We’ll be happy to take a closer look at this and see what’s going on. Since each sites setup differs, and in order to align with the forum guidelines, would you please start your own topic?
We’ll be more than happy to help there. ??
Cheers!
@nbalcombe this was acknowledged as a bug with the new checkout experience and fixed. See here:
https://github.com/woocommerce/woocommerce-gateway-stripe/issues/3358Thank you. I saw the Github issue (and fix) after I did some more investigation. My issue was indeed related to a staging site. I was removing customers on my staging site (as I usually do) but had left the Stripe plugin activated. Which consequently tried to delete the customers in stripe and detached the payment methods. I’m currently getting some support from Stripe to see if there is a way to easily re-attach the payment methods. Upgrading to the latest plugin version and the new checkout experience seems to have made it so the affected customers are able to pay by card again at least.
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 55754UPDATE 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.")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.Thanks for your detailed replies. I completely agree on your second point. If I was starting from scratch again now, there’s no way I would choose the WP/Woo route. It’s great for getting something up cheaply and quickly but it doesn’t scale well at all.
- You must be logged in to reply to this topic.