Duplicate Order Stock Deduction
-
Hello,
Our Woocommerce store has been experiencing the duplicate stock deduction issues for a few months. It happened quite often recently, at least two orders have been affected in the span of one week. It only happened to orders that were manually created on the admin order page after switching status from “Pending Payment” to “Processing”. I’m not able to reproduce the issue because I don’t know what might cause this
-
Hey there, @cllamsupport! Thanks for contacting us. I’m happy to help you.
Do you see any similarities between the orders with the issue?
Can you please share a screenshot of the order notes?
Also please share a screenshot of the order details.Please remove any sensitive information before sharing it here. I recommend using https://snipboard.io. You can share the direct link to the image as a response to this topic.
Here’s an example of what we need:
https://snipboard.io/ga15Gu.jpg
https://snipboard.io/uO6Lfj.jpgFurthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:
System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.Have a wonderful day!
Hi,
The only similarity between orders with the issue is that they are manually created from the Order Page.
Here is the screenshot of Order Details: https://snipboard.io/WT3Ick.jpg, https://snipboard.io/8DgK6Z.jpg
Here is the screenshot of Order Notes: https://snipboard.io/2rbY5d.jpg
Here is the system report:
WordPress Environment<br><br>WordPress address (URL): https://cllamsupply.com<br>Site address (URL): https://cllamsupply.com<br>WC Version: 8.8.5<br>REST API Version: ✔ 8.8.5<br>Action Scheduler Version: ✔ 3.7.4<br>Log Directory Writable: ✔<br>WP Version: ❌ 6.5.2 - There is a newer version of WordPress available (6.6.1)<br>WP Multisite: –<br>WP Memory Limit: 768 MB<br>WP Debug Mode: –<br>WP Cron: ✔<br>Language: en_US<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: 120<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: 8.8.5<br>WC Database Prefix: wp_<br>Total Database Size: 4985.77MB<br>Database Data Size: 2879.96MB<br>Database Index Size: 2105.81MB<br>wp_woocommerce_sessions: Data: 2.02MB + 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: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 25.55MB + Index: 10.52MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 217.75MB + Index: 179.41MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + 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.05MB + 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_actionscheduler_actions: Data: 20.06MB + Index: 14.14MB + 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: 9.02MB + Index: 8.05MB + Engine InnoDB<br>wp_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ahrefs_seo_content: Data: 0.09MB + Index: 0.08MB + Engine InnoDB<br>wp_ahrefs_seo_snapshots: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_aioseo_cache: Data: 1.03MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_crawl_cleanup_blocked_args: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_crawl_cleanup_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_aioseo_notifications: Data: 0.17MB + Index: 0.06MB + Engine InnoDB<br>wp_aioseo_posts: Data: 5.52MB + Index: 0.16MB + Engine InnoDB<br>wp_aioseo_revisions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_aioseo_search_statistics_objects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_aioseo_terms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_aiowps_audit_log: Data: 12.02MB + Index: 0.34MB + Engine InnoDB<br>wp_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aiowps_events: Data: 3.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aiowps_logged_in_users: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_aiowps_login_lockdown: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_aiowps_message_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_apmm_custom_theme: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_ariadminer_connections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_atum_product_data: Data: 0.41MB + Index: 0.33MB + Engine InnoDB<br>wp_barcode_gen2_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_codes_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_shortcodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_gen2_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_cart_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_history: Data: 0.27MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_locations_tree: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_logs: Data: 4.52MB + Index: 2.52MB + Engine InnoDB<br>wp_barcode_scanner_posts: Data: 21.55MB + Index: 3.03MB + Engine InnoDB<br>wp_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_posts_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_templates: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cartflows_ca_cart_abandonment: Data: 6.52MB + Index: 0.08MB + Engine InnoDB<br>wp_cartflows_ca_email_history: Data: 0.20MB + Index: 0.27MB + Engine InnoDB<br>wp_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_commentmeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB<br>wp_comments: Data: 62.58MB + Index: 32.08MB + Engine InnoDB<br>wp_cr_local_forms: Data: 7.52MB + Index: 0.13MB + Engine InnoDB<br>wp_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_dgwt_wcas_index: Data: 1.34MB + Index: 0.06MB + Engine InnoDB<br>wp_dgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_dgwt_wcas_invindex_doclist: Data: 3.19MB + Index: 3.58MB + Engine InnoDB<br>wp_dgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_dgwt_wcas_invindex_wordlist: Data: 0.47MB + Index: 0.23MB + Engine InnoDB<br>wp_dgwt_wcas_tax_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_dgwt_wcas_var_index: Data: 2.13MB + Index: 0.30MB + Engine InnoDB<br>wp_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_duplicator_pro_packages: Data: 1.50MB + Index: 0.02MB + Engine InnoDB<br>wp_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wp_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_e_submissions: Data: 1.52MB + Index: 1.58MB + Engine InnoDB<br>wp_e_submissions_actions_log: Data: 0.22MB + Index: 0.47MB + Engine InnoDB<br>wp_e_submissions_values: Data: 1.52MB + Index: 0.28MB + Engine InnoDB<br>wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_gf_entry: Data: 0.34MB + Index: 0.09MB + Engine InnoDB<br>wp_gf_entry_meta: Data: 1.52MB + Index: 0.86MB + Engine InnoDB<br>wp_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_gf_form_view: Data: 0.08MB + Index: 0.09MB + Engine InnoDB<br>wp_image_mapper_object: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_image_mapper_object_meta: Data: 0.02MB + Index: 0.03MB + 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_login_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_newsletters: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_subscriber_segment: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wp_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_mailpoet_subscribers: Data: 0.25MB + Index: 0.45MB + Engine InnoDB<br>wp_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_nf3_upgrades: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 22.45MB + Index: 1.30MB + Engine InnoDB<br>wp_pmxe_exports: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_google_cats: Data: 0.38MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_posts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 326.69MB + Index: 253.66MB + Engine InnoDB<br>wp_posts: Data: 61.47MB + Index: 13.73MB + Engine InnoDB<br>wp_qcld_conversion_tracker: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_reviewx_criterias: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_reviewx_import_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_reviewx_process_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_reviewx_reminder_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_shopmagic_automation_outcome: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_shopmagic_automation_outcome_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_shopmagic_guest: Data: 0.25MB + Index: 0.00MB + Engine InnoDB<br>wp_shopmagic_guest_meta: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>wp_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_signups: Data: 1.52MB + Index: 0.28MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_snippets: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_stock_log: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wp_term_relationships: Data: 5.52MB + Index: 2.42MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.14MB + Index: 0.14MB + Engine InnoDB<br>wp_termmeta: Data: 0.28MB + Index: 0.36MB + Engine InnoDB<br>wp_terms: Data: 0.11MB + Index: 0.13MB + Engine InnoDB<br>wp_trackship_shipment: Data: 0.02MB + Index: 0.19MB + Engine InnoDB<br>wp_trackship_shipment_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_trackship_shipping_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_unitegallery_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_unitegallery_galleries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_unitegallery_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_userfeedback_survey_responses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_userfeedback_surveys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_usermeta: Data: 7.52MB + Index: 5.98MB + Engine InnoDB<br>wp_users: Data: 0.22MB + Index: 0.28MB + Engine InnoDB<br>wp_wacv_abandoned_cart_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wacv_cart_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wacv_email_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wacv_guest_info_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 1.52MB + Index: 0.59MB + Engine InnoDB<br>wp_wc_download_log: 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: 9.52MB + Index: 9.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 3.52MB + Index: 1.33MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 1.52MB + Index: 0.70MB + 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_product_attributes_lookup: Data: 0.13MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 1.48MB + Index: 1.13MB + 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_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wdr_order_item_discounts: Data: 0.25MB + Index: 0.19MB + Engine InnoDB<br>wp_wdr_rules: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfconfig: Data: 0.47MB + Index: 0.00MB + Engine InnoDB<br>wp_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wffilemods: Data: 9.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wfhits: Data: 1.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB<br>wp_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wflogins: Data: 0.19MB + Index: 0.06MB + Engine InnoDB<br>wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wfpklist_template_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wp_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wfstatus: Data: 0.13MB + Index: 0.11MB + Engine InnoDB<br>wp_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wlr_earn_campaign_transaction: Data: 1.52MB + Index: 1.61MB + Engine InnoDB<br>wp_wlr_expire_points: Data: 0.50MB + Index: 1.13MB + Engine InnoDB<br>wp_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wlr_logs: Data: 2.52MB + Index: 0.42MB + Engine InnoDB<br>wp_wlr_points_ledger: Data: 1.52MB + Index: 0.77MB + Engine InnoDB<br>wp_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wlr_users: Data: 0.31MB + Index: 0.50MB + Engine InnoDB<br>wp_wonderplugin_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woo_shippment_provider: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_exported_csv_items: Data: 241.25MB + Index: 6.44MB + Engine InnoDB<br>wp_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wow_fmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_affiliates_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_creatives: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_impressions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_paypal_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_tracking_tokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_tracking_tokens_purchase_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpam_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wp_wpforms_tasks_meta: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wp_wpie_template: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_debug_events: Data: 0.27MB + Index: 0.00MB + Engine InnoDB<br>wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wsal_metadata: Data: 343.58MB + Index: 514.09MB + Engine InnoDB<br>wp_wsal_occurrences: Data: 178.75MB + Index: 41.14MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_commission_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_payment_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_payment_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcaf_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_indexable: Data: 5.08MB + Index: 0.59MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.13MB + Index: 0.16MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.09MB + Index: 0.11MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.13MB + Index: 0.09MB + Engine InnoDB<br>wp_zorem_email_sms_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpstg0_actionscheduler_actions: Data: 1.08MB + Index: 0.55MB + Engine InnoDB<br>wpstg0_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_actionscheduler_logs: Data: 1.08MB + Index: 0.22MB + Engine InnoDB<br>wpstg0_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_ahrefs_seo_content: Data: 0.11MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_ahrefs_seo_snapshots: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_aioseo_cache: Data: 0.11MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_aioseo_notifications: Data: 0.11MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_aioseo_posts: Data: 4.52MB + Index: 0.20MB + Engine InnoDB<br>wpstg0_aiowps_audit_log: Data: 10.02MB + Index: 0.30MB + Engine InnoDB<br>wpstg0_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_aiowps_events: Data: 4.52MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_aiowps_logged_in_users: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_aiowps_login_lockdown: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_aiowps_message_store: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_aiowps_permanent_block: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_alp_pickup_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_apmm_custom_theme: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ariadminer_connections: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_atum_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_atum_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_atum_product_data: Data: 0.28MB + Index: 0.25MB + Engine InnoDB<br>wpstg0_barcode_gen2_codes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_codes_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_shortcodes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_gen2_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_cart: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_interface: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_locations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_locations_tree: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_barcode_scanner_posts: Data: 19.55MB + Index: 3.03MB + Engine InnoDB<br>wpstg0_barcode_scanner_posts_columns: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_posts_list: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_scanner_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_dimension: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_fields_matching: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_label_sheets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_paper_formats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_profiles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_template_to_user: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_templates: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_barcode_v3_user_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_cartflows_ca_cart_abandonment: Data: 1.52MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_cartflows_ca_email_history: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_cli_csv_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_commentmeta: Data: 4.52MB + Index: 5.03MB + Engine InnoDB<br>wpstg0_comments: Data: 47.58MB + Index: 27.09MB + Engine InnoDB<br>wpstg0_cr_local_forms: Data: 3.52MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_csp3_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_dgwt_wcas_index: Data: 1.52MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_dgwt_wcas_invindex_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_dgwt_wcas_invindex_doclist: Data: 1.52MB + Index: 1.77MB + Engine InnoDB<br>wpstg0_dgwt_wcas_invindex_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_dgwt_wcas_invindex_wordlist: Data: 0.20MB + Index: 0.13MB + Engine InnoDB<br>wpstg0_dgwt_wcas_tax_index: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_dgwt_wcas_var_index: Data: 1.52MB + Index: 0.19MB + Engine InnoDB<br>wpstg0_duplicator_pro_entities: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_duplicator_pro_packages: Data: 1.52MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wpstg0_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_e_submissions: Data: 1.52MB + Index: 2.34MB + Engine InnoDB<br>wpstg0_e_submissions_actions_log: Data: 0.23MB + Index: 0.58MB + Engine InnoDB<br>wpstg0_e_submissions_values: Data: 1.52MB + Index: 0.39MB + Engine InnoDB<br>wpstg0_fc_campaign_emails: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpstg0_fc_campaign_url_metrics: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_fc_campaigns: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_fc_funnel_metrics: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_fc_funnel_sequences: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_fc_funnel_subscribers: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_fc_funnels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_fc_lists: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fc_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_fc_subscriber_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_fc_subscriber_notes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_fc_subscriber_pivot: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_fc_subscribers: Data: 0.25MB + Index: 0.20MB + Engine InnoDB<br>wpstg0_fc_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fc_url_stores: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_ff_scheduled_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_entry_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_form_analytics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_submission_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_fluentform_submissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_gf_addon_payment_callback: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_gf_addon_payment_transaction: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_gf_entry: Data: 0.36MB + Index: 0.13MB + Engine InnoDB<br>wpstg0_gf_entry_meta: Data: 1.52MB + Index: 1.13MB + Engine InnoDB<br>wpstg0_gf_entry_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_gf_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_gf_form_view: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_image_mapper_object: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_image_mapper_object_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_import_detail_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_import_log_detail: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_import_postID: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_litespeed_img_optming: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_login_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_automation_run_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_mailpoet_automation_run_subjects: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_automation_runs: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_mailpoet_automation_triggers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_automation_versions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_automations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_dynamic_segment_filters: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_feature_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_option: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_option_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_posts: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_segment: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_newsletter_templates: Data: 2.52MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_newsletters: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_mailpoet_scheduled_task_subscribers: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_scheduled_tasks: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_segments: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_sending_queues: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_settings: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_bounces: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_clicks: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_forms: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_newsletters: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_opens: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_unsubscribes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_mailpoet_statistics_woocommerce_purchases: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_mailpoet_stats_notifications: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_subscriber_custom_field: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_subscriber_ips: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_subscriber_segment: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_mailpoet_subscriber_tag: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_mailpoet_subscribers: Data: 0.16MB + Index: 0.45MB + Engine InnoDB<br>wpstg0_mailpoet_tags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_user_agents: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mailpoet_user_flags: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_mclean_scan: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_action_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_chunks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_field_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_form_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_object_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_objects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_relationships: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nf3_upgrades: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_nrp_accounts: Data: 0.16MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_nrp_points_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_nx_entries: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_nx_posts: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_nx_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_options: Data: 17.44MB + Index: 1.34MB + Engine InnoDB<br>wpstg0_parcelpanel_courier: Data: 0.30MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_parcelpanel_location: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_parcelpanel_tracking: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_parcelpanel_tracking_items: Data: 0.06MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxe_posts: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_files: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_hash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_images: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_pmxi_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_postmeta: Data: 226.73MB + Index: 205.55MB + Engine InnoDB<br>wpstg0_posts: Data: 40.55MB + Index: 13.06MB + Engine InnoDB<br>wpstg0_qcld_conversion_tracker: Data: 0.08MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_reviewx_criterias: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_reviewx_import_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_reviewx_process_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_reviewx_reminder_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_shopmagic_automation_outcome: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_shopmagic_automation_outcome_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_shopmagic_guest: Data: 0.27MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_shopmagic_guest_meta: Data: 2.52MB + Index: 1.52MB + Engine InnoDB<br>wpstg0_shopmagic_optin_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_signups: Data: 1.52MB + Index: 0.34MB + Engine InnoDB<br>wpstg0_sm_task_details: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_sm_tasks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_smackcsv_file_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_smackuci_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_snippets: Data: 0.06MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_social_users: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_stock_log: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_term_relationships: Data: 3.52MB + Index: 2.52MB + Engine InnoDB<br>wpstg0_term_taxonomy: Data: 0.14MB + Index: 0.20MB + Engine InnoDB<br>wpstg0_termmeta: Data: 0.28MB + Index: 0.45MB + Engine InnoDB<br>wpstg0_terms: Data: 0.13MB + Index: 0.17MB + Engine InnoDB<br>wpstg0_trackship_shipment: Data: 0.02MB + Index: 0.19MB + Engine InnoDB<br>wpstg0_trackship_shipment_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_trackship_shipping_provider: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ultimate_csv_importer_acf_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ultimate_csv_importer_mappingtemplate: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ultimate_csv_importer_media: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ultimate_csv_importer_shortcode_manager: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_ultimate_post_entries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_unitegallery_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_unitegallery_galleries: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_unitegallery_items: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_userfeedback_survey_responses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_userfeedback_surveys: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_usermeta: Data: 5.52MB + Index: 6.03MB + Engine InnoDB<br>wpstg0_users: Data: 0.25MB + Index: 0.25MB + Engine InnoDB<br>wpstg0_wacv_abandoned_cart_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wacv_cart_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wacv_email_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wacv_guest_info_record: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wc_admin_notes: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wc_customer_lookup: Data: 1.52MB + Index: 1.73MB + Engine InnoDB<br>wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_wc_order_product_lookup: Data: 8.52MB + Index: 13.06MB + Engine InnoDB<br>wpstg0_wc_order_stats: Data: 2.52MB + Index: 3.44MB + Engine InnoDB<br>wpstg0_wc_order_tax_lookup: Data: 1.52MB + Index: 0.73MB + Engine InnoDB<br>wpstg0_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpstg0_wc_orders_meta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wc_product_attributes_lookup: Data: 0.11MB + Index: 0.11MB + Engine InnoDB<br>wpstg0_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wc_product_meta_lookup: Data: 1.52MB + Index: 1.19MB + Engine InnoDB<br>wpstg0_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wdr_order_discounts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wdr_order_item_discounts: Data: 0.31MB + Index: 0.31MB + Engine InnoDB<br>wpstg0_wdr_rules: Data: 0.20MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfblockediplog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfblocks7: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_wfconfig: Data: 0.48MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfcrawlers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wffilechanges: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wffilemods: Data: 5.52MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfhits: Data: 0.34MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_wfhoover: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wfissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wfknownfilelist: Data: 4.52MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wflivetraffichuman: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wflocs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wflogins: Data: 0.20MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfnotifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfpendingissues: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wfpklist_template_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfreversecache: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wfsnipcache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_wfstatus: Data: 0.13MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_wftrafficrates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_wlr_earn_campaign_transaction: Data: 0.02MB + Index: 0.17MB + Engine InnoDB<br>wpstg0_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_wlr_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_wlr_points_ledger: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wpstg0_wlr_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_wonderplugin_gallery: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_woo_shippment_provider: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_woocommerce_exported_csv_items: Data: 74.59MB + Index: 2.52MB + Engine InnoDB<br>wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_woocommerce_order_itemmeta: Data: 174.72MB + Index: 197.52MB + Engine InnoDB<br>wpstg0_woocommerce_order_items: Data: 24.56MB + Index: 14.55MB + Engine InnoDB<br>wpstg0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_woocommerce_sessions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_wotv_woo_track_info: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wow_fmp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_actions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_affiliates_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_creatives: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_impressions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_messages: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_paypal_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_tracking_tokens: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_tracking_tokens_purchase_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpam_transactions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpfm_backup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpforms_payment_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_wpforms_payments: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wpstg0_wpforms_tasks_meta: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpie_template: Data: 0.06MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpmailsmtp_debug_events: Data: 0.44MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wsal_metadata: Data: 354.98MB + Index: 425.30MB + Engine InnoDB<br>wpstg0_wsal_occurrences: Data: 131.69MB + Index: 32.13MB + Engine InnoDB<br>wpstg0_wt_iew_action_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_xoo_wl_list: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_xoo_wl_list_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_yith_wcaf_affiliates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_clicks: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_commission_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_commissions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_payment_commission: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_payment_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcaf_payments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_yith_wcwl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_yith_wcwl_lists: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_yoast_indexable: Data: 1.52MB + Index: 0.67MB + Engine InnoDB<br>wpstg0_yoast_indexable_hierarchy: Data: 0.11MB + Index: 0.22MB + Engine InnoDB<br>wpstg0_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_yoast_primary_term: Data: 0.11MB + Index: 0.16MB + Engine InnoDB<br>wpstg0_yoast_seo_links: Data: 0.11MB + Index: 0.09MB + Engine InnoDB<br>wpstg0_zbs_admlog: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_aka: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_zbs_companies: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_zbs_contacts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_customfields: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_dbmigration_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_dbmigration_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_zbs_event_reminders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_events: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_zbs_externalsources: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_zbs_forms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_invoices: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_zbs_lineitems: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wpstg0_zbs_notifications: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_object_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_quotes: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wpstg0_zbs_quotes_templates: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_security_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_segments_conditions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_settings: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_sys_cronmanagerlogs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_sys_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_sys_email_hist: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wpstg0_zbs_tags: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_tags_links: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wpstg0_zbs_tax_table: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_temphash: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_tracking: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wpstg0_zbs_transactions: Data: 0.02MB + Index: 0.14MB + Engine InnoDB<br>wpstg0_zbs_workflows: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wpstg0_zorem_email_sms_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB Post Type Counts<br><br>attachment: 5300<br>blocks: 9<br>br_sale_report: 1<br>custom_css: 5<br>cwginstocknotifier: 422<br>elementor_library: 17<br>elementor_snippet: 1<br>featured_item: 8<br>jb_store_css: 9<br>jet-menu: 1<br>jet-smart-filters: 8<br>jet-theme-core: 6<br>jet-woo-builder: 9<br>jetpack_migration: 2<br>jp_img_sitemap: 1<br>jp_sitemap: 1<br>jp_sitemap_master: 1<br>mailpoet_page: 1<br>nav_menu_item: 90<br>oembed_cache: 19<br>order_status: 5<br>page: 25<br>points_image: 17<br>post: 11<br>postman_sent_mail: 250<br>product: 1431<br>product_variation: 2229<br>pw_gift_rule: 2<br>revision: 2924<br>shipping_option: 1<br>shop_coupon: 581<br>shop_order: 53935<br>shop_order_refund: 254<br>sidebar: 2<br>sp_wps_shortcodes: 1<br>um_directory: 1<br>um_form: 3<br>wacv_email_template: 3<br>wafs: 2<br>was: 1<br>wc_stamps_label: 2<br>woo_mb_template: 10<br>woocommerce-lookbook: 12<br>wpcf7_contact_form: 10 Security<br><br>Secure connection (HTTPS): ✔<br>Hide errors from visitors: ✔ Active Plugins (51)<br><br>Advanced Access Manager: by AAM – 6.9.25<br>FiboSearch - AJAX Search for WooCommerce (Pro): by FiboSearch Team – 1.14.1<br>All in One SEO Pro: by All in One SEO Team – 4.5.8<br>All In One WP Security: by All In One WP Security & Firewall Team – 5.2.9<br>Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.1.0<br>Barcode Scanner with Inventory & Order Manager - (business): by UkrSolution – 1.6.2<br>Custom Order Status Manager for WooCommerce: by Bright Plugins – 1.1.3.2<br>Clear Cache For Me: by Webhead LLC – 2.1.1<br>Code Snippets: by Code Snippets Pro – 3.6.4<br>Admin Columns: by AdminColumns.com – 4.6.1<br>Contact Form 7: by Takayuki Miyoshi – 5.9.3<br>Cookie Notice & Compliance for GDPR / CCPA: by Hu-manity.co – 2.4.16<br>Custom links in Elementor Image Carousel: by Charlie Etienne – 1.1.1<br>Customer Reviews for WooCommerce: by CusRev – 5.35.0<br>Duplicator Pro: by Snap Creek – 3.8.8<br>Elementor Pro: by Elementor.com – 3.21.0<br>Elementor: by Elementor.com – 3.21.1<br>Essential Addons for Elementor: by WPDeveloper – 5.9.15<br>Facebook for WooCommerce: by Facebook – 3.1.3<br>Happy Elementor Addons: by Leevio – 3.10.6<br>Jetpack Boost: by Automattic - Jetpack Site Speed team – 3.2.2<br>Order Export & Order Import for WooCommerce: by WebToffee – 2.5.1<br>Barcode Label Printing for WooCommerce and others plugins - (business): by UkrSolution – 3.4.8<br>Product Sales Report for WooCommerce: by WP Zone – 1.5.6<br>Redirection: by John Godley – 5.4.2<br>String Locator: by InstaWP – 2.6.5<br>Tidio Chat: by Tidio LLC – 6.0.19<br>UpdraftPlus - Backup/Restore: by UpdraftPlus.Com<br>DavidAnderson – 1.24.2<br><br>User Role Editor: by Vladimir Garagulya – 4.64.2<br>Advanced Shipment Tracking for WooCommerce: by zorem – 3.6.7<br>WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.27<br>Combo Offers WooCommerce: by QuanticEdge – 3.2<br>Woo Discount Rules PRO 2.0: by Flycart Technologies LLP – 2.3.2<br>Discount Rules Core: by Flycart – 2.6.3<br>Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.3.20<br>Variation Swatches for WooCommerce: by Emran Ahmed – 2.0.30<br>WooCommerce Customer/Order/Coupon Export: by SkyVerge – 5.1.2 (update to version 5.5.1 is available)<br>Print Invoice & Delivery Notes for WooCommerce: by Tyche Softwares – 4.9.0<br>WooCommerce Authorize.Net AIM Gateway: by SkyVerge – 3.13.0<br>WooCommerce Local Pickup Time Select: by Tim Nolte – 1.4.2<br>WooCommerce Security: by WooCommerce – 3.5.0<br>WooCommerce Shipping Tracking: by Lagudi Domenico – 20.4<br>WooCommerce Smart Coupons: by StoreApps – 4.12.0 (update to version 9.7.0 is available)<br>WooCommerce - StampscomEndicia Integration: by Stamps.comEndicia – 2.0.0<br>WooCommerce: by Automattic – 8.8.5 (update to version 9.1.4 is available)<br>WordPress Importer: by wordpressdotorg – 0.8.2<br>WP Activity Log for WooCommerce: by Melapress – 1.5.2<br>WP File Manager: by mndpsingh287 – 7.2.6<br>WPLoyalty - WooCommerce Loyalty Points, Rewards and Referral Pro: by Wployalty – 1.2.8<br>WP Mail SMTP: by WP Mail SMTP – 4.0.1<br>WP Activity Log: by WP White Security – 4.5.3 Inactive Plugins (4)<br><br>Copy & Delete Posts: by Inisev – 1.4.6<br>Download Plugin: by Metagauss – 2.1.0<br>WPForms Lite: by WPForms – 1.8.7.2<br>WP STAGING - Backup Duplicator & Migration: by WP-STAGING<br>WPStagingBackup – 3.1.0 Dropin Plugins ()<br><br>advanced-cache.php: advanced-cache.php 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>external (external)<br>grouped (grouped)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)<br>wooco (wooco)<br>woosb (woosb)<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 screen enabled: –<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: 3 MB WC Pages<br><br>Shop base: #60451 - /shop<br>Cart: #20 - /cart<br>Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block.<br>My account: #54342 - /dashboard<br>Terms and conditions: ❌ Page not set Theme<br><br>Name: Kava<br>Version: 1.2.0<br>Author URL:<br>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<br>WooCommerce Support: ✔ Templates<br><br>Overrides: /home/customer/www/cllamsupply.com/public_html/wp-content/plugins/woo-variation-gallery/templates/product-images.php<br>/home/customer/www/cllamsupply.com/public_html/wp-content/plugins/woo-variation-gallery/templates/product-thumbnails.php Authorize.Net AIM<br><br>Environment: Production<br>Debug Mode: Off 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-variation-management<br>product-virtual-downloadable<br>product-external-affiliate<br>product-grouped<br>product-linked<br>product-pre-publish-modal<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>product-custom-fields<br>settings<br>async-product-editor-category-field<br>launch-your-store<br><br>Daily Cron: ✔ Next scheduled: 2024-08-20 16:11:17 -07:00<br>Options: ✔<br>Notes: 43<br>Onboarding: completed WooCommerce Customer/Order/Coupon Export<br><br>Automated exports: 0<br>Custom formats: 3<br>Next export: Not scheduled Action Scheduler<br><br>Canceled: 5,106<br>Oldest: -0001-11-29 16:07:02 -0752<br>Newest: -0001-11-29 16:07:02 -0752<br><br>Complete: 23,747<br>Oldest: 2024-07-19 11:32:37 -0700<br>Newest: 2024-08-19 11:29:16 -0700<br><br>Failed: 176<br>Oldest: 2019-03-04 11:13:13 -0800<br>Newest: 2023-10-25 12:26:01 -0700<br><br>Pending: 14<br>Oldest: 2024-08-19 11:32:47 -0700<br>Newest: 2024-08-26 07:32:15 -0700 Status report information<br><br>Generated at: 2024-08-19 11:31:25 -07:00<br>For the fatal error logs: I went over them and did not find any that related to the issue at hand
Hi @cllamsupport,
As a first step, I can see from your System Status Report (SSR) that your WordPress and WooCommerce versions are out of date. Could you please try running all pending updates and seeing if that fixes it? You can take a full backup of your site before doing that or try the updates on a staging site to make sure nothing breaks while doing so.
Other interesting findings and possible leads from your SSR: I see you have 51 active plugins, one of them may be causing a conflict with your instal. Out of the list, these are the ones that caught my eyes the most due to the nature of the bug:
- Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.1.0
- Custom Order Status Manager for WooCommerce: by Bright Plugins – 1.1.3.2
You can also try disabling those two and see if the issue persists. Of course, this is difficult as I understand you haven’t been able to fully replicate this. So far the only thing in common you’ve found is the orders being made manually, correct?
How many manual orders do you manage per week? As I understand, two have failed recently within the span of a week. I’m interested in learning more to get an idea of the % of error here and trying to figure out the root cause or additional common elements between the orders that have shown this bug. Maybe shipping zones, maybe specific products, or anything you can find in common can help!
If we find a way to replicate this it’d be easier to fix it. For the time being, I’d start by running the pending updates, though!
Please let us know the results of your tests.
Thanks!
-OPHi,
We’ve processed around 10 manual orders on average every day. The only way to know what orders have issues is to check the order notes for every single order, so I don’t know what is the percent of erroneous orders yet. I’ve found another two orders with the same order date (August 18) that have issues.
On August 19, I found another order that has duplicate stock issues with a different note. I don’t know what cause the order note to log the line “Adjusted stock: CL152 PASTEL PINK – POWDER – 2oz (45→42)” but the system did reduce 3 stocks. Please see attached image https://snipboard.io/RsV7wr.jpg. And this is the image for order details: https://snipboard.io/NBbIea.jpg.
I’ve not been able to update all the outdated plugins yet (someone else handles that part), so far I was only able to deactivate “Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.1.0” plugin.
Are there any other ways to figure out the cause of the issues? I tried to replicate orders with issues but nothing unusual happened
-
This reply was modified 1 year, 7 months ago by
cllamsupport.
Hi @cllamsupport, thank you for the additional info.
This is curious, as this time, the notes are different; for instance, in the first one you shared, here, the notes showed the adjustment from pending payment to processed twice, reducing the stock levels twice. In the latest one you shared, here, the status only changed once, but the stock got adjusted nonetheless. It was reduced by an additional three, but that part makes sense since it was 3x the product quantity.
Please let us know when you’ve been able to run all the updates. If possible, you can also run some tests on a Staging site (you can ask your hosting provider if they offer this feature, or you can use a plugin like WP Staging for this—I see you have it installed already!), where you can run all the updates without the risk of affecting your live site, as well as place and modify test orders as needed.
If the issue persists, you can also disable every other plugin except WooCommerce to see if it’s fixed, and then you can re-enable all the other plugins until the issue happens again. Learn more about running conflict tests here.
I’m aware that this is complicated because you haven’t been able to replicate the issue fully consistently, so testing is more difficult this way. Do you have any code snippet or plugin that would modify the order pages in any way? While you create and update orders manually, have you checked on your browser’s console for any errors? Can you record a quick video using Loom of how you create and update the manual orders? That may shed some light on this issue.
Thanks!
-OPHi,
I have a few code snippets that run on the admin side on the edit order page: add custom fields, and prevent adding out-stocks products. I don’t think these snippets causing the issue because the issue has existed before adding these snippets.
There are multiple people create manual orders, so it is not possible to check the console for each person when the issue occurs. Furthermore, not all manual orders have issues, so it is very difficult to know exactly what or where to inspect.
For now, I’ll update all the outdated plugins and let you know the result afterwards.
Hi,
This is a link to a video on how I create and edit manual order: https://www.loom.com/share/23b906a5422543339bd9e8900c1df128?sid=2e72c50a-c3a9-49bf-ab77-c7d7811c69e0
Thank you so much for your collaboration, @cllamsupport.
The video shows a few differences from the default order page, but if the issue started before the modifications, we must look elsewhere. Unfortunately, when recording the video, it worked flawlessly; the stock was both increased and reduced accordingly. I’m also curious as to why this only happens for manual orders. You haven’t found any regular order with this behavior, correct?
It is difficult to troubleshoot without being able to replicate this one. I researched similar issues on GitHub, but the closest thing I’ve found is a report from three years ago reporting that accidentally double-clicking on Update order triggers the actions multiple times (this one).
For the time being, I think the best path forward is to update everything to the latest version (WordPress, WooCommerce, and its database) and watch for any persisting issues. If they do, a full conflict test on a Staging site would be advised.
Please, keep us posted!
-OPHi,
I was able to replicate (by clicking really fast on the Update button) the issue presented in the Github link you attached (see image https://snipboard.io/Ectv2V.jpg). It seems that issue have not been fixed yet? Anyway, order notes logged the status’s change 3 times, but the stock quantity was still only deducted one time (I confirmed the stock on the product page https://snipboard.io/lDrEjI.jpg). It is not exactly the issue we’re facing, but it could potentially be the cause of our issue. I’ll notify personnel who is in charge of creating manual orders of this matter.
Thanks for your research
Thanks for sharing further details. However, I tried to recreate the error using the latest version of WooCommerce but didn’t encounter any issues. Could you please update your WooCommerce to the latest version and see if the problem still exists?
If the problem persists, running a conflict test could be a great way to pinpoint the cause of the issue.
- Temporarily switch your theme to Storefront or Twenty Twenty-Four
- Disable all plugins except for WooCommerce
- Repeat the action that is causing the problem
If you do not see the same problem after completing the conflict test, then you know the problem was with the plugins and/or theme you deactivated. To determine which plugin is causing the problem, reactivate your other plugins one by one, testing after each, until you find the one causing conflict. You can find a more detailed explanation on how to do a conflict test here.
I hope that helps! Let me know once you have done a conflict test!
The topic ‘Duplicate Order Stock Deduction’ is closed to new replies.