Hi @ihereira or @anastas10s
I have a staging site using Storefront theme and 2 plugins, WooCommerce & WooCommerce Stripe Gateway. (No Must-use or Drop-ins plugins)
I purchased product/the-seven-rays-of-life-webinar/ which I have confirmed is set as a simple product, Virtual but not downloadable.
This order is still stuck at Processing. Do you want an admin login for the staging site?
- This reply was modified 1 hour, 48 minutes ago by AndrewNZ.
- This reply was modified 1 hour, 42 minutes ago by AndrewNZ.
- This reply was modified 1 hour, 41 minutes ago by AndrewNZ.
Here is a copy of WooCommerce > Status
WordPress Environment
WordPress address (URL):
Site address (URL):
WC Version: 7.4.0
REST API Version: ✔ 7.4.0
WC Blocks Version: ✔ 9.4.3
Action Scheduler Version: ✔ 3.5.4
Log Directory Writable: ✔
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –
Server Environment
Server Info: Apache
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 120
PHP Max Input Vars: 3000
cURL Version: 7.85.0
OpenSSL/3.0.8
SUHOSIN Installed: –
MySQL Version: 5.7.39-42-log
Max Upload Size: 256 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
Database
WC Database Version: 7.4.0
WC Database Prefix: aquar_
Total Database Size: 123.06MB
Database Data Size: 93.86MB
Database Index Size: 29.20MB
aquar_woocommerce_sessions: Data: 0.03MB + Index: 0.02MB + Engine InnoDB
aquar_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_woocommerce_downloadable_product_permissions: Data: 0.08MB + Index: 0.14MB + Engine InnoDB
aquar_woocommerce_order_items: Data: 0.20MB + Index: 0.08MB + Engine InnoDB
aquar_woocommerce_order_itemmeta: Data: 1.52MB + Index: 1.95MB + Engine InnoDB
aquar_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
aquar_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_woocommerce_payment_tokens: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
aquar_woocommerce_payment_tokenmeta: Data: 0.09MB + Index: 0.09MB + Engine InnoDB
aquar_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_actionscheduler_actions: Data: 0.11MB + Index: 0.13MB + Engine InnoDB
aquar_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_actionscheduler_logs: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
aquar_commentmeta: Data: 0.38MB + Index: 0.38MB + Engine InnoDB
aquar_comments: Data: 1.52MB + Index: 2.31MB + Engine InnoDB
aquar_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
aquar_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
aquar_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
aquar_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_links: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
aquar_options: Data: 46.36MB + Index: 0.25MB + Engine InnoDB
aquar_postmeta: Data: 21.55MB + Index: 15.03MB + Engine InnoDB
aquar_posts: Data: 11.52MB + Index: 1.25MB + Engine InnoDB
aquar_redirection_404: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_redirection_groups: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_redirection_items: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
aquar_redirection_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_rg_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_rg_form_meta: Data: 0.20MB + Index: 0.00MB + Engine InnoDB
aquar_rg_form_view: Data: 0.22MB + Index: 0.17MB + Engine InnoDB
aquar_rg_incomplete_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_rg_lead: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
aquar_rg_lead_detail: Data: 0.13MB + Index: 0.28MB + Engine InnoDB
aquar_rg_lead_detail_long: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_rg_lead_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
aquar_rg_lead_notes: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_rg_mailchimp: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_rg_userregistration: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_sensei_pro_groups_courses: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_sensei_pro_groups_students: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
aquar_tec_events: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
aquar_tec_occurrences: Data: 0.09MB + Index: 0.06MB + Engine InnoDB
aquar_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_terms: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
aquar_term_relationships: Data: 0.07MB + Index: 0.15MB + Engine MyISAM
aquar_term_taxonomy: Data: 0.05MB + Index: 0.06MB + Engine MyISAM
aquar_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_usermeta: Data: 7.52MB + Index: 4.03MB + Engine InnoDB
aquar_users: Data: 0.17MB + Index: 0.17MB + Engine InnoDB
aquar_wcepp_messages: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
aquar_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
aquar_wc_admin_note_actions: Data: 0.06MB + Index: 0.02MB + Engine InnoDB
aquar_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_wc_customer_lookup: Data: 0.14MB + Index: 0.13MB + Engine InnoDB
aquar_wc_download_log: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
aquar_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_wc_order_product_lookup: Data: 0.27MB + Index: 0.33MB + Engine InnoDB
aquar_wc_order_stats: Data: 0.22MB + Index: 0.22MB + Engine InnoDB
aquar_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
aquar_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
aquar_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
aquar_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
aquar_wp_auth_session_tbl: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
Post Type Counts
attachment: 379
course: 23
custom_css: 3
customize_changeset: 4
elementor_library: 12
elementor-hf: 2
feedback: 160
follow_up_email: 19
forum: 2
lesson: 112
nav_menu_item: 174
page: 79
post: 196
postman_sent_mail: 250
product: 137
product_variation: 10
quiz: 114
revision: 669
shop_coupon: 21
shop_order: 1683
shop_order_refund: 57
slide: 3
ticket-meta-fieldset: 2
tribe_events: 376
tribe_organizer: 104
tribe_venue: 166
tribe_wooticket: 824
woocustomemails: 1
wooframework: 460
wp_block: 1
wp_global_styles: 1
wpcf7_contact_form: 1
wpem-temps: 1
wpephpcompat_jobs: 18
wpsc-product: 11
wpsc-product-file: 5
wysijap: 1
Security
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
Active Plugins (2)
WooCommerce Stripe Gateway: by WooCommerce – 7.1.0
WooCommerce: by Automattic – 7.4.0
Inactive Plugins (21)
AddToAny Share Buttons: by AddToAny – 1.8.5
Classic Editor: by WordPress Contributors – 1.6.2
Contact Form 7: by Takayuki Miyoshi – 5.7.4
Elementor: by Elementor.com – 3.11.1
Elementor Pro: by Elementor.com – 3.11.1
Event Tickets: by The Events Calendar – 5.5.7
Event Tickets Plus: by The Events Calendar – 5.6.6.1
ManageWP - Worker: by GoDaddy – 4.9.16
Open External Links in a New Window: by WebFactory Ltd – 1.44
Post Type Switcher: by Triple J Software
Inc. – 3.2.1
Redirection: by John Godley – 5.3.9
S3 Media Maestro: by Fly Plugins – 4.1.6
Sensei Pro (WC Paid Courses): by Automattic – 4.11.1.1.11.1
Show Current Template: by JOTAKI Taisuke – 0.4.6
SiteGround Optimizer: by SiteGround – 7.3.0
The Events Calendar: by The Events Calendar – 6.0.9
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 1.22.24
WooCommerce Amazon S3 Storage: by Themesquad – 2.4.5
WooCommerce Google Analytics Integration: by WooCommerce – 1.6.1
Woo Custom Emails Per Product: by Alex Mustin – 2.2.9
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
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)
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: ✔
Enforce Approved Product Download Directories: –
Order datastore: WC_Order_Data_Store_CPT
WC Pages
Shop base: #3431 - /shop/
Cart: #3432 - /cart/
Checkout: #3433 - /checkout/
My account: #3434 - /my-account/
Terms and conditions: #12870 - /terms-of-use/
Theme
Name: Storefront
Version: 4.2.0
Author URL:
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: –
Admin
Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
multichannel-marketing
mobile-app-banner
navigation
new-product-management-experience
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
Disabled Features: minified-js
product-variation-management
settings
Daily Cron: ✔ Next scheduled: 2023-02-20 03:49:15 -08:00
Options: ✔
Notes: 117
Onboarding: completed
Action Scheduler
Complete: 272
Oldest: 2023-01-19 21:23:07 -0800
Newest: 2023-02-19 16:48:52 -0800
Failed: 1
Oldest: 2023-02-14 20:33:05 -0800
Newest: 2023-02-14 20:33:05 -0800
Pending: 2
Oldest: 2023-02-20 03:39:59 -0800
Newest: 2023-02-20 14:29:03 -0800
Status report information
Generated at: 2023-02-19 17:07:59 -08:00
`
As per the instructions in the “Guide to the WooCommerce Stripe forum” thread as a Woo paying customer “you can get help faster at WooCommerce.com > My Account > Tickets.”
The answer I received was that only products that are marked as Virtual and Downloadable are supposed to auto-complete.
Since my products are only marked as Virtual, they are not supposed to auto-complete.
Why this has always worked for the website, for over a 1,000 orders, the Woo help desk can not explain.
One suggestion is for me to edit the products and mark the appropriate ones as downloadable.
The Woo help said that
“You can also set the product to be downloadable and virtual if you would like, which would auto-complete the purchase. If a download is not included, it won’t display any information about downloading anything.”
I tested this with one product on the staging site and it worked.
The other suggestion is there is some code which I can add to the website, which will make all orders auto-complete.
