search

woocommerce / woocommerce

A customizable, open-source ecommerce platform built on WordPress. Build any commerce solution you can imagine.
https://woocommerce.com
9.32k stars 10.75k forks source link

Duplicate order numbers #32529

Closed ASI-Wise closed 2 years ago

ASI-Wise commented 2 years ago

When quotes are converted to Invoices in XERO (linked to WooCommerce), WooComerce is duplicated in theInvoice number used on the next order that comes through via the website.

Eg. Sally smith has been quoted by the team in Xero and that Quote (QU001) is then converted to an invoice (INV001) for product ABC John Jones then places an order for product DEF online via the WooCommerce Store. An order with Order number (INV001) is then generated in XERO for that order.

XERO has been contacted and they can confirm that that the bug is not in their system.

`

WordPress Environment

WordPress address (URL): https://sensoryproject.org Site address (URL): https://sensoryproject.org WC Version: 6.3.1 REST API Version: ✔ 6.3.1 WC Blocks Version: ✔ 7.0.0 Action Scheduler Version: ✔ 3.4.0 WC Admin Version: ✔ 3.2.1 Log Directory Writable: ✔ WP Version: 5.9.3 WP Multisite: – WP Memory Limit: 512 MB WP Debug Mode: – WP Cron: ✔ Language: en_GB External object cache: ✔

Server Environment

Server Info: nginx PHP Version: 7.4.28 PHP Post Max Size: 2 GB PHP Time Limit: 1200 PHP Max Input Vars: 6144 cURL Version: 7.82.0 OpenSSL/1.1.0l

SUHOSIN Installed: – MySQL Version: 5.5.5-10.3.34-MariaDB-log Max Upload Size: 2 GB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔

Database

WC Database Version: 6.3.1 WC Database Prefix: wp42333479 Total Database Size: 576.04MB Database Data Size: 395.96MB Database Index Size: 180.08MB wp_42333479_woocommerce_sessions: Data: 4.02MB + Index: 0.14MB + Engine InnoDB wp_42333479_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_42333479_woocommerce_order_items: Data: 0.16MB + Index: 0.05MB + Engine InnoDB wp_42333479_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.73MB + Engine InnoDB wp_42333479_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_42333479_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_commentmeta: Data: 0.19MB + Index: 0.06MB + Engine InnoDB vp_backup_wp_42333479_comments: Data: 0.14MB + Index: 0.09MB + Engine InnoDB vp_backup_wp_42333479_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_options: Data: 0.30MB + Index: 0.06MB + Engine InnoDB vp_backup_wp_42333479_postmeta: Data: 3.52MB + Index: 0.61MB + Engine InnoDB vp_backup_wp_42333479_posts: Data: 9.52MB + Index: 0.56MB + Engine InnoDB vp_backup_wp_42333479_ssf_wp_addon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_ssf_wp_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_ssf_wp_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_ssf_wp_stores: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_ssf_wp_tag: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_store_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_term_relationships: Data: 0.13MB + Index: 0.05MB + Engine InnoDB vp_backup_wp_42333479_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_usermeta: Data: 0.20MB + Index: 0.16MB + Engine InnoDB vp_backup_wp_42333479_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB vp_backup_wp_42333479_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_downloadable_product_permissio: Data: 0.02MB + Index: 0.05MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_order_itemmeta: Data: 0.06MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_sessions: Data: 0.14MB + Index: 0.02MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB vp_backup_wp_42333479_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_actionscheduler_actions: Data: 0.45MB + Index: 0.53MB + Engine InnoDB wpstg0_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_actionscheduler_logs: Data: 0.36MB + Index: 0.33MB + Engine InnoDB wpstg0_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_comments: Data: 0.44MB + Index: 0.48MB + Engine InnoDB wpstg0_ld_notifications_delayed_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_form: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_learndash_pro_quiz_lock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_master: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_prerequisite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_question: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_learndash_pro_quiz_statistic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_statistic_ref: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_learndash_pro_quiz_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_pro_quiz_toplist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_learndash_user_activity: Data: 0.38MB + Index: 1.27MB + Engine InnoDB wpstg0_learndash_user_activity_meta: Data: 1.52MB + Index: 0.73MB + Engine InnoDB wpstg0_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_login_redirects: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_nobuna_backups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_nobuna_downloads: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_nobuna_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_options: Data: 2.52MB + Index: 0.13MB + Engine InnoDB wpstg0_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpstg0_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_pmpro_memberships_categories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_pmpro_memberships_pages: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpstg0_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpstg0_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB wpstg0_postmeta: Data: 14.52MB + Index: 6.03MB + Engine InnoDB wpstg0_posts: Data: 35.31MB + Index: 2.64MB + Engine InnoDB wpstg0_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpstg0_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpstg0_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpstg0_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_ssf_wp_addon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_ssf_wp_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_ssf_wp_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_ssf_wp_stores: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_ssf_wp_tag: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_store_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_term_relationships: Data: 0.13MB + Index: 0.13MB + Engine InnoDB wpstg0_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wpstg0_usermeta: Data: 4.52MB + Index: 6.03MB + Engine InnoDB wpstg0_users: Data: 0.34MB + Index: 0.31MB + Engine InnoDB wpstg0_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wc_customer_lookup: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wpstg0_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_wc_order_product_lookup: Data: 0.11MB + Index: 0.06MB + Engine InnoDB wpstg0_wc_order_stats: Data: 0.09MB + Index: 0.05MB + Engine InnoDB wpstg0_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wpstg0_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpstg0_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_order_itemmeta: Data: 0.39MB + Index: 0.53MB + Engine InnoDB wpstg0_woocommerce_order_items: Data: 0.09MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_sessions: Data: 1.52MB + Index: 0.02MB + Engine InnoDB wpstg0_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wpstg0_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wpstg0_wpgmza: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_circles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wpstg0_wpgmza_datasets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_maps_has_custom_fields_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_markers_has_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_markers_has_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpgmza_rectangles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wpstg0_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_actionscheduler_actions: Data: 15.05MB + Index: 7.75MB + Engine InnoDB wp_42333479_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_actionscheduler_logs: Data: 4.28MB + Index: 3.88MB + Engine InnoDB wp_42333479_ac_segments: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_admin_columns: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_commentmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_42333479_comments: Data: 1.52MB + Index: 0.91MB + Engine InnoDB wp_42333479_dprv_licenses: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_dprv_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_dprv_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_dprv_post_content_files: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB wp_42333479_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB wp_42333479_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_ld_achievements: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_ld_notifications_delayed_emails: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_category: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_form: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_learndash_pro_quiz_lock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_master: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_prerequisite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_question: Data: 0.08MB + Index: 0.03MB + Engine InnoDB wp_42333479_learndash_pro_quiz_statistic: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_statistic_ref: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_learndash_pro_quiz_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_pro_quiz_toplist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_learndash_user_activity: Data: 2.52MB + Index: 4.45MB + Engine InnoDB wp_42333479_learndash_user_activity_meta: Data: 0.41MB + Index: 0.45MB + Engine InnoDB wp_42333479_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_nobuna_backups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_nobuna_downloads: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_nobuna_products: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_options: Data: 4.17MB + Index: 1.08MB + Engine InnoDB wp_42333479_pmpro_discount_codes: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_42333479_pmpro_discount_codes_levels: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_pmpro_discount_codes_uses: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_pmpro_memberships_categories: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_pmpro_memberships_pages: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_pmpro_memberships_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_42333479_pmpro_membership_levelmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_pmpro_membership_levels: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_42333479_pmpro_membership_ordermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_pmpro_membership_orders: Data: 0.02MB + Index: 0.20MB + Engine InnoDB wp_42333479_postmeta: Data: 40.36MB + Index: 10.67MB + Engine InnoDB wp_42333479_posts: Data: 63.47MB + Index: 3.48MB + Engine InnoDB wp_42333479_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_42333479_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_42333479_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_42333479_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_simple_history: Data: 3.02MB + Index: 1.47MB + Engine InnoDB wp_42333479_simple_history_contexts: Data: 14.02MB + Index: 11.03MB + Engine InnoDB wp_42333479_ssf_wp_addon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_ssf_wp_region: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_ssf_wp_setting: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_ssf_wp_stores: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_ssf_wp_tag: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_store_ratings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB wp_42333479_term_relationships: Data: 0.16MB + Index: 0.09MB + Engine InnoDB wp_42333479_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB wp_42333479_um_metadata: Data: 0.02MB + Index: 0.05MB + Engine InnoDB wp_42333479_usermeta: Data: 11.31MB + Index: 10.73MB + Engine InnoDB wp_42333479_users: Data: 0.48MB + Index: 0.39MB + Engine InnoDB wp_42333479_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_42333479_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wc_customer_lookup: Data: 0.16MB + Index: 0.11MB + Engine InnoDB wp_42333479_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_wc_order_product_lookup: Data: 0.19MB + Index: 0.23MB + Engine InnoDB wp_42333479_wc_order_stats: Data: 0.20MB + Index: 0.19MB + Engine InnoDB wp_42333479_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB wp_42333479_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wc_zapier_history: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza: Data: 0.06MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_category_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_circles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_custom_fields: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_wpgmza_datasets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_maps: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_maps_has_custom_fields_filters: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_markers_has_categories: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_markers_has_custom_fields: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_polygon: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_polylines: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpgmza_rectangles: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wpmailsmtp_emails_log: Data: 62.52MB + Index: 0.25MB + Engine InnoDB wp_42333479_wpmailsmtp_email_tracking_events: Data: 0.19MB + Index: 0.20MB + Engine InnoDB wp_42333479_wpmailsmtp_email_tracking_links: Data: 1.52MB + Index: 0.27MB + Engine InnoDB wp_42333479_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB wp_42333479_wsal_metadata: Data: 55.23MB + Index: 86.48MB + Engine InnoDB wp_42333479_wsal_occurrences: Data: 20.55MB + Index: 5.03MB + Engine InnoDB wp_42333479_wsal_sessions: Data: 0.05MB + Index: 0.00MB + Engine InnoDB wp_42333479_yoast_indexable: Data: 5.52MB + Index: 3.14MB + Engine InnoDB wp_42333479_yoast_indexable_hierarchy: Data: 0.34MB + Index: 0.42MB + Engine InnoDB wp_42333479_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_42333479_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_42333479_yoast_seo_links: Data: 1.52MB + Index: 0.56MB + Engine InnoDB wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_comments: Data: 0.02MB + Index: 0.08MB + Engine InnoDB wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_options: Data: 0.03MB + Index: 0.02MB + Engine InnoDB wp_postmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_posts: Data: 0.02MB + Index: 0.06MB + Engine InnoDB wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_usermeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB

Post Type Counts

attachment: 2612 customize_changeset: 97 custom_css: 2 elementor_library: 8 feedback: 430 groups: 53 jetpack_migration: 2 job: 1 jobs: 1 job_listing: 4 jp_img_sitemap: 20 jp_img_sitemap_index: 10 jp_pay_order: 8 jp_pay_product: 8 jp_sitemap: 10 jp_sitemap_master: 10 jp_vid_sitemap: 10 ld-notification: 21 nav_menu_item: 56 oembed_cache: 66 page: 211 post: 483 product: 63 revision: 7720 safecss: 1 sfwd-assignment: 233 sfwd-certificates: 3 sfwd-courses: 21 sfwd-essays: 378 sfwd-lessons: 241 sfwd-question: 14 sfwd-quiz: 9 sfwd-topic: 131 shop_order: 1925 shop_order_refund: 2 tp_event: 48 um_directory: 1 um_form: 3 wp_global_styles: 1

Security

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

Active Plugins (53)

WP Activity Log (Premium): by WP White Security – 4.4.1.1 PDF Embedder Premium: by Lever Technology LLC – 4.4.3 Accelerated Mobile Pages: by Ahmed Kaludi Mohammed Kaludi – 1.0.77.36

ActiveCampaign: by ActiveCampaign – 8.1.9 WP Activity Log for Yoast SEO: by WP White Security – 1.3.0 Advanced iFrame: by Michael Dempfle – 2021.9 Akismet Anti-Spam: by Automattic – 4.2.2 CoBlocks: by GoDaddy – 2.22.9 Column Shortcodes: by Codepress – 1.0.1 Copyright Proof: by Digiprove – 4.16 Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.2 Elementor Pro: by Elementor.com – 3.6.4 Elementor: by Elementor.com – 3.5.6 WordPress.com Editing Toolkit: by Automattic – 3.30395 Google XML Sitemaps: by Auctollo – 4.1.1 Gutenberg: by Gutenberg Team – 12.9.0 Import and export users and customers: by codection – 1.19.1.9 Jetpack: by Automattic – 10.9-a.1 LearnDash Content Cloner: by WisdmLabs – 1.3.0 Visual Customizer for LearnDash: by SnapOrbital – 2.3.6.1 LearnDash LMS - Achievements: by LearnDash – 1.1.1 LearnDash LMS - Certificate Builder: by LearnDash – 1.0.3 LearnDash LMS - Course Grid: by LearnDash – 2.0.2.2 LearnDash LMS - EDD Integration: by LearnDash – 1.3.0 LearnDash LMS - Elementor: by LearnDash – 1.0.3 LearnDash LMS - iThemes Exchange: by LearnDash – 1.1 LearnDash LMS - Notifications: by LearnDash – 1.5.3 LearnDash LMS - Paid Memberships Pro: by LearnDash – 1.3.1 LearnDash ProPanel: by LearnDash – 2.1.4 LearnDash LMS - Stripe Integration: by LearnDash – 1.9.1 LearnDash LMS - Zapier Integration: by LearnDash – 2.3.0 Custom Login Page Customizer: by Hardeep Asrani – 2.1.6 My Wordpress Login Logo: by Afsal Rahim – 2.4.1 Nobuna Plugins: by Nobuna – 2.6 Paid Memberships Pro: by Paid Memberships Pro – 2.7.4 Pixabay Images Gallery: by Simon Steinberger – 1.10 Pixabay Images: by Simon Steinberger – 3.4 Redirection: by John Godley – 5.1.3 LearnDash LMS: by LearnDash – 3.6.0.3 Simple History: by Pär Thernström – 3.2.0 Uncanny Toolkit for LearnDash: by Uncanny Owl – 3.6 Uncanny Toolkit Pro for LearnDash: by Uncanny Owl – 3.5.8 WooCommerce Blocks: by Automattic – 7.0.0 WooCommerce PayPal Payments: by WooCommerce – 1.7.0 (update to version 1.7.1 is available) WooCommerce Shipping & Tax: by WooCommerce – 1.25.25 WooCommerce Zapier: by OM4 Software – 2.2.2 (update to version 2.3.0 is available) WooCommerce: by Automattic – 6.3.1 Wordfence Login Security: by Wordfence – 1.0.9 Yoast SEO: by Team Yoast – 18.5.1 WP Activity Log for WooCommerce: by WP White Security – 1.4.0 WP Mail SMTP Pro: by WPForms – 3.3.0 WPC Pixabay: by WPClever.net – 3.1.4 Zapier for WordPress: by Zapier – 1.0.4

Inactive Plugins (24)

Admin Columns: by AdminColumns.com – 4.4.5 Admin Columns Pro: by AdminColumns.com – 5.6.3 Advanced iFrame custom folder: by Michael Dempfle – 1.0 AMP: by AMP Project Contributors – 2.2.3 Auto Login New User After Registration: by Jeff Sherk – 1.9.4 BadgeOS LearnDash Add-On: by BadgeOS – 1.2.3 Classic Editor: by WordPress Contributors – 1.6.2 Classic Editor Addon: by Pieter Bos Greg Schoppe – 2.6.3

Colorlib Login Customizer: by Colorlib – 1.3.0 Course Access Manager: by LearnDash – 1.0 Elementor Beta (Developer Edition): by Elementor.com – 1.1.1 Layout Grid: by Automattic – 1.8.1 LearnDash LMS - WooCommerce Integration: by LearnDash – 1.9.3.3 Page Optimize: by Automattic – 0.5.2 Super Store Finder Wordpress: by Joe Iz – 4.5 WooCommerce Admin: by WooCommerce – 2.8.0 WooCommerce PDF Invoices & Packing Slips: by Ewout Fernhout – 2.11.1 WooCommerce Stripe Gateway: by WooCommerce – 6.3.0 WP Activity Log: by WP White Security – 4.4.1 WP Events Manager: by ThimPress – 2.1.10 WP Google Maps: by WP Google Maps – 8.1.20 WP Job Manager: by Automattic – 1.35.3 WP Mail SMTP: by WPForms – 3.3.0 WP STAGING: by WP-STAGING – 2.9.0

Dropin Plugins (2)

advanced-cache.php: advanced-cache.php object-cache.php: Memcached

Must Use Plugins (3)

LearnDash LMS Multisite: by LearnDash – 1.0.0 WP.com Site Helper: by – WP STAGING Optimizer: by René Hermenau – 1.4

Settings

API Enabled: ✔ Force SSL: – Currency: GBP (£) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5)

Connected to WooCommerce.com: ✔

WC Pages

Shop base: #1973 - /shop/ Cart: #1975 - /basket/ Checkout: #1977 - /checkout/ My account: #1979 - /my-account/ Terms and conditions: #22654 - /terms-and-conditions/

Theme

Name: Storefront Version: 4.1.0 Author URL: https://woocommerce.com/ Child Theme: ❌ – If you are modifying WooCommerce on a parent theme that you did not build personally we recommend using a child theme. See: How to create a child theme WooCommerce Support: ✔

Templates

Overrides: –

WooCommerce PayPal Payments

Onboarded: ✔ Shop country code: GB WooCommerce currency supported: ✔ PayPal card processing available in country: ✔ Pay Later messaging available in country: ✔ Webhook status: ✔ Vault enabled: – Logging enabled: – Reference Transactions: – Used PayPal Checkout plugin: ✔

Action Scheduler

Complete: 16,319 Oldest: 2022-03-08 06:25:02 +0000 Newest: 2022-04-08 06:36:57 +0100

Pending: 6 Oldest: 2022-04-08 12:44:35 +0100 Newest: 2022-04-13 21:55:26 +0100

WooCommerce Zapier

Database Version: ✔ 13 Detailed Logging Enabled: Yes Legacy Mode Disabled: ✔ Yes SSL: ✔ Yes REST API Authentication Key(s): ❌ 0 Task History Record Count: ✔ 75 Webhook #13: Zapier #subscription:12472758

Status report information

Generated at: 2022-04-08 06:38:18 +01:00 `

jonathansadowski commented 2 years ago

Hi @ASI-Wise,

While our goal is to address all the issues reported in this repository, GitHub should be treated as a place to report WooCommerce bugs only.

The issue you are having seems to be caused by the Xero plugin which is one of the paid products on our marketplace. To get further technical support for it, please contact WooCommerce support team by opening a ticket or starting a live chat.

One of the support agents will be able to confirm the issue with you and file a bug with the developers of the plugin.