• Resolved Blake

    (@alexanderblake)


    A client’s web store uses a plugin called “place order without payment for woocommerce” and it works flawlessly. It is used because this store sells supplements and prescriptions (refills for existing patients only) that payment gateways find violate their ToS (testosterone, etc.). So this plugin allows them to collect and order in their system, and process the payment with their own CRM after the doctor approves the request – so the plugin is necessary. I give you that info, only so you remove the “disable that plugin” option.

    What is happening, however, is orders that have been successfully reviewed and approved are being marked complete. Then WC kicked them back into Processing.

    Because there’s no successful payment being collected, WC might be kicking it back to processing to satisfy some variable of “completeness” – I’m just thinking out loud…

    Is there a way to add a snippet of code that prevents orders from kicking back into any status once marked complete? Something that tells WC, once the order is marked complete, it is unable to be marked anything else?

    I know this is long, but I’m stumped and I appreciate the help!

    – Blake

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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Hi @alexanderblake

    orders that have been successfully reviewed and approved are being marked complete. Then WC kicked them back into Processing.

    So this plugin allows them to collect and order in their system, and process the payment with their own CRM after the doctor approves the request – so the plugin is necessary. I give you that info, only so you remove the “disable that plugin” option.

    Orders going back from “Completed” to “Processing” may be happening because no payment has been made, but it is due to the involvement of something else, such as a plugin on your site, for example, because this not a normal behavior of WooCommerce. It could even be the plugin “place order without payment for woocommerce” you mentioned.

    * By default, an order will go to “Processing” once it’s paid for, after which you will need to set it to “Completed” manually when the products are shipped out. You can read more on order statuses here: https://woocommerce.com/document/managing-orders/#order-statuses

    * If the order only contains products that are virtual and downloadable, then it will go to “Completed” automatically after payment is completed.

    In your case, are the products set as virtual? If not, please make them so, and see if that eradicates the problem. Here is the documentation to follow: https://woocommerce.com/document/managing-products/#adding-a-virtual-product

    Can you please share the order notes of a couple of such orders? We recommend https://snipboard.io for easily sharing screenshots – please follow the instructions on that page, then paste the URL in this thread.

    In your response please also include a copy of your site’s System Status. You can find it via WooCommerce > Status. Select “Get system report” and then “Copy for support”. Once you’ve done that, paste it here in your response.

    Thread Starter Blake

    (@alexanderblake)

    Okay, here are two long notes. You can see when a user sets the order to completed, and you can also see when the system kicks it back to pending.

    https://snipboard.io/dWF2px.jpg
    https://snipboard.io/dIVaLb.jpg

    The products are set to regular products because there are variables on several of them (doses, bottle size, etc.) so I can’t convert them all to virtual.

    If you message me, I can provide you with a site login so you can check it out yourslef.

    Thanks!

    System Report //

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://hormonetherapyntx.com
    Site address (URL): https://hormonetherapyntx.com
    WC Version: 6.8.2
    REST API Version: ? 6.8.2
    WC Blocks Version: ? 8.0.0
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1
    PHP Version: 7.4.30
    PHP Post Max Size: 300 MB
    PHP Time Limit: 3000
    PHP Max Input Vars: 1000
    cURL Version: 7.58.0
    OpenSSL/1.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-0ubuntu0.18.04.2
    Max Upload Size: 300 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.8.2
    WC Database Prefix: wp_
    Total Database Size: 117.65MB
    Database Data Size: 94.83MB
    Database Index Size: 22.82MB
    wp_woocommerce_sessions: Data: 4.38MB + Index: 0.17MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.69MB + Index: 0.32MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 4.33MB + Index: 3.28MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 0.41MB + Index: 0.23MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 0.34MB + Index: 0.24MB + Engine MyISAM
    wp_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_failed_logins: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_login_activity: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_login_lockdown: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_comments: Data: 3.50MB + Index: 1.74MB + Engine MyISAM
    wp_db7_forms: Data: 1.91MB + Index: 0.05MB + Engine MyISAM
    wp_ess_social_networks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ess_social_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
    wp_gf_entry_meta: Data: 1.52MB + Index: 1.88MB + Engine InnoDB
    wp_gf_entry_notes: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mail_bank_logs: Data: 41.90MB + Index: 0.07MB + Engine MyISAM
    wp_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_masterslider_options: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_masterslider_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_options: Data: 4.14MB + Index: 0.15MB + Engine MyISAM
    wp_postmeta: Data: 20.73MB + Index: 10.85MB + Engine MyISAM
    wp_posts: Data: 5.18MB + Index: 0.72MB + Engine MyISAM
    wp_prli_clicks: Data: 0.23MB + Index: 0.58MB + Engine InnoDB
    wp_prli_links: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_prli_link_metas: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders_bkp: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides: Data: 0.43MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides_bkp: Data: 0.72MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides_bkp: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_term_relationships: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_usermeta: Data: 0.09MB + Index: 0.04MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.19MB + Index: 0.20MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 1.02MB + Index: 0.89MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.48MB + Index: 0.36MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.27MB + Index: 0.13MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 221
    cf_mega_menu: 1
    custom_css: 1
    flamingo_contact: 3
    flamingo_inbound: 455
    mpc_content_preset: 12
    nav_menu_item: 20
    page: 40
    post: 11
    pretty-link: 1
    product: 65
    product_variation: 8
    revision: 356
    service: 5
    shop_coupon: 1
    shop_order: 7427
    shop_order_refund: 7
    sln_attendant: 4
    sln_booking: 3
    sln_service: 6
    testimonial: 8
    theme_testimonial: 3
    wppopups: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (23) ###
    
    ManageWP - Worker: by GoDaddy – 4.9.14
    Gravity Forms: by Gravity Forms – 2.6.6
    Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.5
    All In One WP Security: by All In One WP Security & Firewall Team – 5.0.7
    CAM Gravity Form Addon: by Clearagain – 3.0
    CAM Heading Section: by Pixelomatic Team – 2.1
    Classic Editor: by WordPress Contributors – 1.6.2
    Disable Comments: by WPDeveloper – 2.4.1
    Easy Social Sharing: by ThemeGrill – 1.3.5.1
    Easy WP SMTP: by wpecommerce
    alexanderfoxc – 1.4.7
    
    Featured Images in RSS for Mailchimp & More: by 5 Star Plugins – 1.5.9
    Gravity Forms Email Blacklist: by hallme – 2.5.1
    Gravity Forms Webhooks Add-On: by Gravity Forms – 1.4
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.9.0
    Master Slider Pro: by averta – 3.6.1
    Pretty Links: by Pretty Links – 3.2.5
    Skill Bars: by Themepoints – 1.2
    Themify - WooCommerce Product Filter: by Themify – 1.3.9
    Place Order Without Payment for WooCommerce: by Nitin Prakash – 2.2
    WooCommerce: by Automattic – 6.8.2 (update to version 6.9.2 is available)
    Yoast SEO: by Team Yoast – 19.6.1
    WP Popups Lite: by timersys – 2.1.4.6
    WP Rocket: by WP Media – 3.12.0.4
    
    ### Inactive Plugins (5) ###
    
    Classic Widgets: by WordPress Contributors – 0.3
    Flat Preloader: by Thien Nguyen – 1.10.0
    Health Check & Troubleshooting: by The www.remarpro.com community – 1.4.5
    Query Monitor: by John Blackbourn – 3.10.1
    WooCommerce Payments: by Automattic – 4.6.0 (update to version 4.7.2 is available)
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (2) ###
    
    Health Check Troubleshooting Mode: by  – 1.7.2
    ManageWP - Worker Loader: by GoDaddy – 1.0.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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: –
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #10247 - /shop/
    Cart: #10248 - /cart/
    Checkout: #10249 - /checkout/
    My account: #10250 - /my-account/
    Terms and conditions: #3 - /privacy-policy/
    
    ### Theme ###
    
    Name: Hormone Therapyntx
    Version: 1.0
    Author URL: https://www.wphats.com/author/mehedi
    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 ###
    
    Archive Template: Your theme has a woocommerce.php file
    you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    
    Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    wc-pay-promotion
    wc-pay-welcome-page
    wc-pay-subscriptions-page
    
    Disabled Features: minified-js
    settings
    
    Daily Cron: ? Next scheduled: 2022-09-16 17:08:28 -05:00
    Options: ?
    Notes: 46
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 1,595
    Oldest: 2022-08-15 15:02:20 -0500
    Newest: 2022-09-15 14:43:44 -0500
    
    Pending: 2
    Oldest: 2022-09-15 16:21:22 -0500
    Newest: 2022-09-20 01:53:36 -0500
    
    ### Status report information ###
    
    Generated at: 2022-09-15 15:01:55 -05:00
    
    Thread Starter Blake

    (@alexanderblake)

    Okay, here are two long notes. You can see when a user sets the order to completed, and you can also see when the system kicks it back to pending.

    https://snipboard.io/dWF2px.jpg
    https://snipboard.io/dIVaLb.jpg

    The products are set to regular products because there are variables on several of them (doses, bottle size, etc.) so I can’t convert them all to virtual.

    If you message me, I can provide you with a site login so you can check it out yourself.

    Thanks!

    System Report //

    
    ### WordPress Environment ###
    
    WordPress address (URL): https://hormonetherapyntx.com
    Site address (URL): https://hormonetherapyntx.com
    WC Version: 6.8.2
    REST API Version: ? 6.8.2
    WC Blocks Version: ? 8.0.0
    Action Scheduler Version: ? 3.4.0
    Log Directory Writable: ?
    WP Version: 6.0.2
    WP Multisite: –
    WP Memory Limit: 256 MB
    WP Debug Mode: –
    WP Cron: ?
    Language: en_US
    External object cache: –
    
    ### Server Environment ###
    
    Server Info: Apache/2.4.29 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.1.1
    PHP Version: 7.4.30
    PHP Post Max Size: 300 MB
    PHP Time Limit: 3000
    PHP Max Input Vars: 1000
    cURL Version: 7.58.0
    OpenSSL/1.1.1
    
    SUHOSIN Installed: –
    MySQL Version: 5.7.39-0ubuntu0.18.04.2
    Max Upload Size: 300 MB
    Default Timezone is UTC: ?
    fsockopen/cURL: ?
    SoapClient: ?
    DOMDocument: ?
    GZip: ?
    Multibyte String: ?
    Remote Post: ?
    Remote Get: ?
    
    ### Database ###
    
    WC Database Version: 6.8.2
    WC Database Prefix: wp_
    Total Database Size: 117.65MB
    Database Data Size: 94.83MB
    Database Index Size: 22.82MB
    wp_woocommerce_sessions: Data: 4.38MB + Index: 0.17MB + Engine MyISAM
    wp_woocommerce_api_keys: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_attribute_taxonomies: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_downloadable_product_permissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_order_items: Data: 0.69MB + Index: 0.32MB + Engine MyISAM
    wp_woocommerce_order_itemmeta: Data: 4.33MB + Index: 3.28MB + Engine MyISAM
    wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_tax_rate_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zones: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_locations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_shipping_zone_methods: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokens: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_payment_tokenmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_actions: Data: 0.41MB + Index: 0.23MB + Engine MyISAM
    wp_actionscheduler_claims: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_actionscheduler_logs: Data: 0.34MB + Index: 0.24MB + Engine MyISAM
    wp_aiowps_debug_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_failed_logins: Data: 0.34MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_global_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_login_activity: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_login_lockdown: Data: 0.25MB + Index: 0.00MB + Engine InnoDB
    wp_aiowps_permanent_block: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_commentmeta: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
    wp_comments: Data: 3.50MB + Index: 1.74MB + Engine MyISAM
    wp_db7_forms: Data: 1.91MB + Index: 0.05MB + Engine MyISAM
    wp_ess_social_networks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_ess_social_statistics: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_gf_entry: Data: 0.14MB + Index: 0.03MB + Engine InnoDB
    wp_gf_entry_meta: Data: 1.52MB + Index: 1.88MB + Engine InnoDB
    wp_gf_entry_notes: Data: 0.11MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
    wp_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mail_bank: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_mail_bank_logs: Data: 41.90MB + Index: 0.07MB + Engine MyISAM
    wp_mail_bank_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_masterslider_options: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
    wp_masterslider_sliders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_options: Data: 4.14MB + Index: 0.15MB + Engine MyISAM
    wp_postmeta: Data: 20.73MB + Index: 10.85MB + Engine MyISAM
    wp_posts: Data: 5.18MB + Index: 0.72MB + Engine MyISAM
    wp_prli_clicks: Data: 0.23MB + Index: 0.58MB + Engine InnoDB
    wp_prli_links: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
    wp_prli_link_metas: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_revslider_css: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_css_bkp: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_layer_animations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_navigations_bkp: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders: Data: 0.09MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_sliders_bkp: Data: 0.13MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides: Data: 0.43MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_slides_bkp: Data: 0.72MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides: Data: 0.03MB + Index: 0.00MB + Engine MyISAM
    wp_revslider_static_slides_bkp: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_terms: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_term_relationships: Data: 0.02MB + Index: 0.04MB + Engine MyISAM
    wp_term_taxonomy: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_usermeta: Data: 0.09MB + Index: 0.04MB + Engine MyISAM
    wp_users: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_admin_notes: Data: 0.04MB + Index: 0.00MB + Engine MyISAM
    wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
    wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_customer_lookup: Data: 0.19MB + Index: 0.20MB + Engine MyISAM
    wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_order_product_lookup: Data: 1.02MB + Index: 0.89MB + Engine MyISAM
    wp_wc_order_stats: Data: 0.48MB + Index: 0.36MB + Engine MyISAM
    wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_product_meta_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
    wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_wc_reserved_stock: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wc_tax_rate_classes: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
    wp_wc_webhooks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
    wp_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_debug_events: Data: 0.22MB + Index: 0.00MB + Engine InnoDB
    wp_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
    wp_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_wpr_rucss_used_css: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
    wp_yoast_indexable: Data: 0.27MB + Index: 0.13MB + Engine InnoDB
    wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
    wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
    wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    wp_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
    
    ### Post Type Counts ###
    
    attachment: 221
    cf_mega_menu: 1
    custom_css: 1
    flamingo_contact: 3
    flamingo_inbound: 455
    mpc_content_preset: 12
    nav_menu_item: 20
    page: 40
    post: 11
    pretty-link: 1
    product: 65
    product_variation: 8
    revision: 356
    service: 5
    shop_coupon: 1
    shop_order: 7427
    shop_order_refund: 7
    sln_attendant: 4
    sln_booking: 3
    sln_service: 6
    testimonial: 8
    theme_testimonial: 3
    wppopups: 2
    
    ### Security ###
    
    Secure connection (HTTPS): ?
    Hide errors from visitors: ?
    
    ### Active Plugins (23) ###
    
    ManageWP - Worker: by GoDaddy – 4.9.14
    Gravity Forms: by Gravity Forms – 2.6.6
    Schema - All In One Schema Rich Snippets: by Brainstorm Force – 1.6.5
    All In One WP Security: by All In One WP Security & Firewall Team – 5.0.7
    CAM Gravity Form Addon: by Clearagain – 3.0
    CAM Heading Section: by Pixelomatic Team – 2.1
    Classic Editor: by WordPress Contributors – 1.6.2
    Disable Comments: by WPDeveloper – 2.4.1
    Easy Social Sharing: by ThemeGrill – 1.3.5.1
    Easy WP SMTP: by wpecommerce
    alexanderfoxc – 1.4.7
    
    Featured Images in RSS for Mailchimp & More: by 5 Star Plugins – 1.5.9
    Gravity Forms Email Blacklist: by hallme – 2.5.1
    Gravity Forms Webhooks Add-On: by Gravity Forms – 1.4
    WPBakery Page Builder: by Michael M - WPBakery.com – 6.9.0
    Master Slider Pro: by averta – 3.6.1
    Pretty Links: by Pretty Links – 3.2.5
    Skill Bars: by Themepoints – 1.2
    Themify - WooCommerce Product Filter: by Themify – 1.3.9
    Place Order Without Payment for WooCommerce: by Nitin Prakash – 2.2
    WooCommerce: by Automattic – 6.8.2 (update to version 6.9.2 is available)
    Yoast SEO: by Team Yoast – 19.6.1
    WP Popups Lite: by timersys – 2.1.4.6
    WP Rocket: by WP Media – 3.12.0.4
    
    ### Inactive Plugins (5) ###
    
    Classic Widgets: by WordPress Contributors – 0.3
    Flat Preloader: by Thien Nguyen – 1.10.0
    Health Check & Troubleshooting: by The www.remarpro.com community – 1.4.5
    Query Monitor: by John Blackbourn – 3.10.1
    WooCommerce Payments: by Automattic – 4.6.0 (update to version 4.7.2 is available)
    
    ### Dropin Plugins (1) ###
    
    advanced-cache.php: advanced-cache.php
    
    ### Must Use Plugins (2) ###
    
    Health Check Troubleshooting Mode: by  – 1.7.2
    ManageWP - Worker Loader: by GoDaddy – 1.0.0
    
    ### Settings ###
    
    API Enabled: –
    Force SSL: –
    Currency: USD ($)
    Currency Position: left
    Thousand Separator: ,
    Decimal Separator: .
    Number of Decimals: 2
    Taxonomies: Product Types: external (external)
    grouped (grouped)
    simple (simple)
    subscription (subscription)
    variable (variable)
    variable subscription (variable-subscription)
    
    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: –
    Enforce Approved Product Download Directories: –
    
    ### WC Pages ###
    
    Shop base: #10247 - /shop/
    Cart: #10248 - /cart/
    Checkout: #10249 - /checkout/
    My account: #10250 - /my-account/
    Terms and conditions: #3 - /privacy-policy/
    
    ### Theme ###
    
    Name: Hormone Therapyntx
    Version: 1.0
    Author URL: https://www.wphats.com/author/mehedi
    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 ###
    
    Archive Template: Your theme has a woocommerce.php file
    you will not be able to override the woocommerce/archive-product.php custom template since woocommerce.php has priority over archive-product.php. This is intended to prevent display issues.
    
    Overrides: –
    
    ### Admin ###
    
    Enabled Features: activity-panels
    analytics
    coupons
    customer-effort-score-tracks
    experimental-products-task
    experimental-import-products-task
    experimental-fashion-sample-products
    experimental-product-tour
    shipping-smart-defaults
    shipping-setting-tour
    homescreen
    marketing
    mobile-app-banner
    navigation
    onboarding
    onboarding-tasks
    remote-inbox-notifications
    remote-free-extensions
    payment-gateway-suggestions
    shipping-label-banner
    subscriptions
    store-alerts
    transient-notices
    wc-pay-promotion
    wc-pay-welcome-page
    wc-pay-subscriptions-page
    
    Disabled Features: minified-js
    settings
    
    Daily Cron: ? Next scheduled: 2022-09-16 17:08:28 -05:00
    Options: ?
    Notes: 46
    Onboarding: completed
    
    ### Action Scheduler ###
    
    Complete: 1,595
    Oldest: 2022-08-15 15:02:20 -0500
    Newest: 2022-09-15 14:43:44 -0500
    
    Pending: 2
    Oldest: 2022-09-15 16:21:22 -0500
    Newest: 2022-09-20 01:53:36 -0500
    
    ### Status report information ###
    
    Generated at: 2022-09-15 15:01:55 -05:00
    
    Saif

    (@babylon1999)

    Hi there,

    I noticed these two are outdated:

    WC Version: 6.9.2

    WC Database Version: 6.9.2

    This could be a problem that was patched in a recent update, please update to the latest version of both WooCommerce and the database.

    Also, what you’re describing is not a default feature of WooCommerce. Are you certain you didn’t add any code snippets like this one to automatically process orders to complete?

    • This reply was modified 2 years, 6 months ago by Saif.
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Completed Orders getting kicked back into processing’ is closed to new replies.