tommls

I can’t put in a screenshot, here is what it says — basically nothing, no scheduled actions are shown.

Action Scheduler migration in progress. The list of scheduled actions may be incomplete.Select AllHookSort descending.StatusSort descending.ArgumentsGroupSort descending.RecurrenceScheduled DateSort descending.LogNo items found.Select AllHookSort descending.StatusSort descending.ArgumentsGroupSort descending.RecurrenceScheduled DateSort descending.Log

here are the results minus identifying information

WordPress address (URL):
Site address (URL):
WC Version: 9.7.1
Legacy REST API Package Version: ✔ 1.0.5
Action Scheduler Version: ✔ 3.9.2
Log Directory Writable: ✔
WP Version: 6.7.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: – Server Environment

Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 128 MB
PHP Time Limit: 300
PHP Max Input Vars: 1000
cURL Version: 7.76.1
OpenSSL/3.2.2

SUHOSIN Installed: –
MySQL Version: 11.4.5-MariaDB
Max Upload Size: 128 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔ Database

WC Database Version: 9.3.3
WC Database Prefix: wp_
Total Database Size: 99.00MB
Database Data Size: 80.10MB
Database Index Size: 18.90MB
wp_woocommerce_sessions: Data: 17.26MB + Index: 0.43MB + 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.03MB + Index: 0.01MB + Engine MyISAM
wp_woocommerce_order_itemmeta: Data: 0.15MB + Index: 0.11MB + Engine MyISAM
wp_woocommerce_tax_rates: Data: 0.00MB + Index: 0.01MB + 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.01MB + 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.01MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_actionscheduler_actions: Data: 0.00MB + Index: 0.00MB + Engine
wp_actionscheduler_claims: Data: 0.28MB + Index: 0.53MB + Engine MyISAM
wp_actionscheduler_groups: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_actionscheduler_logs: Data: 1.09MB + Index: 0.82MB + Engine MyISAM
wp_ac_abandoned_cart_history_lite: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
wp_ac_email_templates_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ac_guest_abandoned_cart_history_lite: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_ac_sent_history_lite: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_commentmeta: Data: 1.05MB + Index: 0.14MB + Engine InnoDB
wp_comments: Data: 1.36MB + Index: 0.38MB + Engine InnoDB
wp_istkr_404_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_jetpack_sync_queue: Data: 0.15MB + Index: 0.01MB + Engine MyISAM
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_litespeed_img_optm: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_litespeed_url: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_litespeed_url_file: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_options: Data: 3.48MB + Index: 0.36MB + Engine InnoDB
wp_postmeta: Data: 11.52MB + Index: 8.03MB + Engine InnoDB
wp_posts: Data: 5.52MB + Index: 1.11MB + Engine InnoDB
wp_termmeta: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.16MB + Index: 0.13MB + Engine InnoDB
wp_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wp_tm_taskmeta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_tm_tasks: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_usermeta: Data: 0.47MB + Index: 0.52MB + Engine InnoDB
wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_wcpdf_invoice_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wcpdf_packing_slip_number: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_notes: Data: 0.08MB + Index: 0.00MB + Engine MyISAM
wp_wc_admin_note_actions: Data: 0.05MB + Index: 0.01MB + Engine MyISAM
wp_wc_category_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_customer_lookup: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_addresses: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_coupon_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_operational_data: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_order_product_lookup: Data: 0.01MB + Index: 0.02MB + Engine MyISAM
wp_wc_order_stats: Data: 0.01MB + Index: 0.01MB + Engine MyISAM
wp_wc_order_tax_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_attributes_lookup: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_download_directories: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.06MB + Index: 0.09MB + Engine MyISAM
wp_wc_rate_limits: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
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_wfauditevents: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfblockediplog: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfblocks7: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfconfig: Data: 3.34MB + Index: 0.01MB + Engine MyISAM
wp_wfcrawlers: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilechanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wffilemods: Data: 2.97MB + Index: 0.35MB + Engine MyISAM
wp_wfhits: Data: 0.09MB + Index: 0.01MB + Engine MyISAM
wp_wfhoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfissues: Data: 0.00MB + Index: 0.01MB + Engine MyISAM
wp_wfknownfilelist: Data: 6.27MB + Index: 0.39MB + Engine MyISAM
wp_wflivetraffichuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflocs: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wflogins: Data: 0.13MB + Index: 0.03MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_role_counts: Data: 0.00MB + Index: 0.00MB + Engine MEMORY
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfnotifications: Data: 0.08MB + Index: 0.01MB + Engine MyISAM
wp_wfpendingissues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfreversecache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfsecurityevents: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfsnipcache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfstatus: Data: 0.22MB + Index: 0.09MB + Engine MyISAM
wp_wftrafficrates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfwaffailures: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpforms_logs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wpforms_payments: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpforms_payment_meta: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpforms_tasks_meta: Data: 21.95MB + Index: 5.05MB + Engine MyISAM Post Type Counts

attachment: 4994
feedback: 43
nav_menu_item: 54
page: 44
post: 80
product: 715
product_variation: 250
revision: 58
shop_coupon: 1
shop_order: 167
shop_order_refund: 5
wooframework: 18
wpforms: 1 Security

Secure connection (HTTPS): ✔
Hide errors from visitors: ✔ Active Plugins (18)

AddToAny Share Buttons: by AddToAny – 1.8.13
Akismet Anti-spam: Spam Protection: by Automattic - Anti-spam Team – 5.3.7
Classic Editor: by WordPress Contributors – 1.6.7
XML Sitemap Generator for Google: by Auctollo – 4.1.21
Heartbeat Control by WP Rocket: by WP Rocket – 2.0.1
Jetpack: by Automattic – 14.5
LiteSpeed Cache: by LiteSpeed Technologies – 7.0.0.1
Mailchimp: by Mailchimp – 1.6.3
Abandoned Cart Lite for WooCommerce: by Tyche Softwares – 6.3.0
WooCommerce Stripe Gateway: by Stripe – 9.3.1
WooCommerce Legacy REST API: by WooCommerce – 1.0.5
WP Menu Cart: by WP Overnight – 2.14.10
PDF Invoices & Packing Slips for WooCommerce: by WP Overnight – 4.3.0
Sequential Order Numbers for WooCommerce: by SkyVerge – 1.11.0
WooCommerce: by Automattic – 9.7.1
Wordfence Security: by Wordfence – 8.0.4
WP Display Header: by Konstantin Obenland – 7
WPForms Lite: by WPForms – 1.9.4.2 Inactive Plugins (5)

catalog Mode Premium: by Phoeniixx – 1.4
Disable Bloat for WordPress & WooCommerce: by Disable Bloat – 3.5.0
Issues Tracker: by lysyiweb – 1.16
Woocommerce Exclude Categories PRO: by Alvaro Neto – 2.0
WP-Optimize - Clean, Compress, Cache: by TeamUpdraft
DavidAnderson – 4.1.1 Dropin Plugins ()

advanced-cache.php: advanced-cache.php Settings

Legacy 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: –
HPOS feature enabled: –
Order datastore: WC_Order_Data_Store_CPT
HPOS data sync enabled: – Logging

Enabled: ✔
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 18 MB WC Pages

Shop base: #2113 - /shops-at-fayrehale/
Cart: #2114 - /cart/ - Contains the woocommerce_cart shortcode
Checkout: #2115 - /checkout/ - Contains the woocommerce_checkout shortcode
My account: #2116 - /my-account/ - Contains the [woocommerce_my_account] shortcode
Terms and conditions: ❌ Page not set Theme

Name: Canvas Child
Version: 1.0
Author URL: http://www.woothemes.com
Child Theme: ✔
Parent Theme Name: Canvas
Parent Theme Version: 5.12.0
Parent Theme Author URL: http://www.woothemes.com/
Theme type: Classic theme
WooCommerce Support: ✔ Templates

Overrides: – WooCommerce Stripe Payment Gateway

Version: 9.3.1
Account ID: acct_1DcZ7kGCAjjm2Q8B
Account Email:
Test Mode Enabled: ✔
No
OAuth Connected: No
Legacy Checkout Experience: ✔
No
Enabled Payment Methods: card
Express Checkout: Disabled
Auth and Capture: ✔
Yes
Logging: No Admin

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customize-store
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
onboarding
onboarding-tasks
pattern-toolkit-full-composability
product-custom-fields
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
printful
shipping-label-banner
subscriptions
store-alerts
transient-notices
woo-mobile-welcome
wc-pay-promotion
wc-pay-welcome-page
launch-your-store
add-to-cart-with-options-stepper-layout

Disabled Features: product-data-views
experimental-blocks
coming-soon-newsletter-template
minified-js
product-pre-publish-modal
settings
async-product-editor-category-field
product-editor-template-system
blueprint
reactify-classic-payments-settings
use-wp-horizon
blockified-add-to-cart

Daily Cron: ✔ Next scheduled: 2025-04-07 23:49:29 -04:00
Options: ✔
Notes: 210
Onboarding: completed Action Scheduler Status report information

Over 24 hours ago (yesterday evening) I went to WC > Status > Tools > Update database, clicked the button, and received the background processing message. 24 hours later, the WC database version remains at 9.3.3 — unchanged and UN-updated.

Please advise.

Thank you, Tom

Got it working, only minor drawback was that I had to figure out how to prioritize the flat rate shipping so it is always selected for non-local-pickup items.

Is there a way to make things such that if no shipping class is assigned to a product, then only the flat rate shipping is shown and chosen for that product??

Is there a way to test if the product has no shipping class and thereby not show local pickup??

Right now, free pickup is enabled for all products but we don’t want it to be able to chosen by someone far away who can not do local pickup and then have hassles about shipping…

Thank you, Tom

Thank you…I did not think to look in my profile…I scrolled endlessly through the list of topics. 🙁

If I remember and understand correctly your explanation, I need to make a shipping class corresponding to local pickup and change this line??

$new_package[‘ship_via’] = array( ‘flat_rate’ ); // Only allow flat rate for items in special class

That is, I’d change this line to ‘local_pickup’ instead of flat_rate?? — is local_pickup the correct phrase to use??
Everything ships flat rate, we want local_pickup assigned to the special class.
I think that’s the only line I should change besides special-class slug??

Thank you, Tom