View Status of the Clean up order data from legacy tables Tool

Hi @jwjo,

Thank you for reaching out to us. I understand that you’re having issues with the “Clean up order data from legacy tables” tool. The duration of the cleanup process can vary depending on the amount of data that needs to be cleaned up. However, it shouldn’t take days. If it appears to be stuck on “Clearing data…”, it might be encountering an issue.

To help us better understand the situation, could you please provide us with a copy of your System Status Report? This will give us more information about your site’s environment. You can find how to get this report from our documentation here.

Regarding the tool stopping when you log out from the WordPress Admin, this is expected behavior as the tool runs on the admin session. Unfortunately, there’s no built-in way to let it run in the background until it finishes. However, there might be other solutions or plugins that could help with this.

Once we have more information from your System Status Report, we’ll be able to provide more specific guidance.

Hi there,

Thanks so much for your reply. Please find below the information you have requested.

`
### WordPress Environment ###

WC Version: 8.7.0
REST API Version: ? 8.7.0
Action Scheduler Version: ? 3.7.2
Log Directory Writable: ?
WP Version: 6.4.3
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: –
Language: en_AU
External object cache: ?

### Server Environment ###

Server Info: LiteSpeed
PHP Version: 7.4.33
PHP Post Max Size: 256 MB
PHP Time Limit: 420
PHP Max Input Vars: 10000
cURL Version: 7.87.0
OpenSSL/1.1.1w

SUHOSIN Installed: –
MySQL Version: 8.0.36
Max Upload Size: 256 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 8.7.0
WC Database Prefix: wpux_
Total Database Size: 409.56MB
Database Data Size: 283.33MB
Database Index Size: 126.23MB
wpux_woocommerce_sessions: Data: 21.05MB + Index: 1.25MB + Engine InnoDB
wpux_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpux_woocommerce_order_items: Data: 1.52MB + Index: 0.34MB + Engine InnoDB
wpux_woocommerce_order_itemmeta: Data: 12.52MB + Index: 8.03MB + Engine InnoDB
wpux_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpux_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_actionscheduler_actions: Data: 10.52MB + Index: 9.09MB + Engine InnoDB
wpux_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_actionscheduler_logs: Data: 10.52MB + Index: 7.03MB + Engine InnoDB
wpux_adtribes_my_conversions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_basel_wishlist_products: Data: 0.19MB + Index: 0.08MB + Engine InnoDB
wpux_basel_wishlists: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wpux_cartflows_ca_cart_abandonment: Data: 0.48MB + Index: 0.02MB + Engine InnoDB
wpux_cartflows_ca_email_history: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_cartflows_ca_email_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_cartflows_ca_email_templates_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_connection_reports: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_no_cookie_data: Data: 1.52MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_sessions: Data: 2.02MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_sfw: Data: 0.48MB + Index: 0.39MB + Engine InnoDB
wpux_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_sfw_personal: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_cleantalk_wc_spam_orders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_commentmeta: Data: 0.16MB + Index: 0.16MB + Engine InnoDB
wpux_comments: Data: 5.52MB + Index: 2.13MB + Engine InnoDB
wpux_fbv: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_fbv_attachment_folder: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wpux_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpux_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_litespeed_avatar: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
wpux_litespeed_img_optming: Data: 3.52MB + Index: 4.42MB + Engine InnoDB
wpux_litespeed_url: Data: 0.47MB + Index: 0.47MB + Engine InnoDB
wpux_litespeed_url_file: Data: 2.52MB + Index: 5.22MB + Engine InnoDB
wpux_mailchimp_carts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_mclean_refs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_mclean_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_ml_data: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpux_ms_snippets: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_newsletter: Data: 1.52MB + Index: 0.17MB + Engine InnoDB
wpux_newsletter_autoresponder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_newsletter_autoresponder_steps: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_newsletter_emails: Data: 2.52MB + Index: 0.00MB + Engine InnoDB
wpux_newsletter_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_newsletter_sent: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wpux_newsletter_stats: Data: 2.52MB + Index: 0.83MB + Engine InnoDB
wpux_newsletter_user_logs: Data: 0.23MB + Index: 0.00MB + Engine InnoDB
wpux_newsletter_user_meta: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_offline_giftcard: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_options: Data: 12.41MB + Index: 0.72MB + Engine InnoDB
wpux_post_smtp_logmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_post_smtp_logs: Data: 9.52MB + Index: 0.00MB + Engine InnoDB
wpux_postmeta: Data: 136.67MB + Index: 61.16MB + Engine InnoDB
wpux_posts: Data: 12.52MB + Index: 2.58MB + Engine InnoDB
wpux_rank_math_404_logs: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_rank_math_analytics_gsc: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpux_rank_math_analytics_objects: Data: 0.17MB + Index: 0.08MB + Engine InnoDB
wpux_rank_math_internal_links: Data: 1.52MB + Index: 0.22MB + Engine InnoDB
wpux_rank_math_internal_meta: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wpux_rank_math_redirections: Data: 0.05MB + Index: 0.02MB + Engine InnoDB
wpux_rank_math_redirections_cache: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_css_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_layer_animations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_navigations_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_sliders: Data: 0.36MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_sliders_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_slides: Data: 4.52MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_static_slides: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpux_revslider_static_slides_bkp: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_rs_expiredpoints_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_rs_templates_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_rsgiftvoucher: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_rspointexpiry: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_rsrecordpoints: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpux_shipment_batch_process: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_snippets: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpux_sumo_reward_encashing_submitted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_sumo_reward_send_point_submitted_data: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_term_relationships: Data: 1.52MB + Index: 1.52MB + Engine InnoDB
wpux_term_taxonomy: Data: 0.06MB + Index: 0.03MB + Engine InnoDB
wpux_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wpux_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpux_tm_taskmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_tm_tasks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_trustreviews_biz: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_trustreviews_review: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_trustreviews_stats: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_usermeta: Data: 3.52MB + Index: 3.03MB + Engine InnoDB
wpux_users: Data: 0.16MB + Index: 0.14MB + Engine InnoDB
wpux_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wpux_wc_admin_notes: Data: 0.11MB + Index: 0.00MB + Engine InnoDB
wpux_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_wc_customer_lookup: Data: 0.31MB + Index: 0.22MB + Engine InnoDB
wpux_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_wc_order_addresses: Data: 1.52MB + Index: 0.59MB + Engine InnoDB
wpux_wc_order_coupon_lookup: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
wpux_wc_order_operational_data: Data: 0.48MB + Index: 0.20MB + Engine InnoDB
wpux_wc_order_product_lookup: Data: 2.52MB + Index: 1.05MB + Engine InnoDB
wpux_wc_order_stats: Data: 0.34MB + Index: 0.25MB + Engine InnoDB
wpux_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpux_wc_orders: Data: 1.52MB + Index: 0.86MB + Engine InnoDB
wpux_wc_orders_meta: Data: 6.52MB + Index: 8.06MB + Engine InnoDB
wpux_wc_product_attributes_lookup: Data: 0.20MB + Index: 0.16MB + Engine InnoDB
wpux_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_wc_product_meta_lookup: Data: 0.28MB + Index: 0.44MB + Engine InnoDB
wpux_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_wc_reserved_stock: Data: 0.08MB + Index: 0.00MB + Engine InnoDB
wpux_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpux_wcpdf_invoice_number: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_wlr_earn_campaign: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpux_wlr_earn_campaign_transaction: Data: 0.05MB + Index: 0.17MB + Engine InnoDB
wpux_wlr_levels: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpux_wlr_logs: Data: 0.08MB + Index: 0.03MB + Engine InnoDB
wpux_wlr_points_ledger: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
wpux_wlr_referral: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpux_wlr_reward_transactions: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
wpux_wlr_rewards: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpux_wlr_user_rewards: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wpux_wlr_users: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wpux_woo_shipment_status_email: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpux_woo_shippment_provider: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpux_wpr_rocket_cache: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wpux_wpr_rucss_used_css: Data: 0.02MB + Index: 0.09MB + Engine InnoDB

### Post Type Counts ###

attachment: 2258
basel_sidebar: 2
basel_size_guide: 1
cms_block: 15
custom_css: 1
cwginstocknotifier: 143
flamingo_contact: 2884
flamingo_inbound: 185
giftcard: 20
mailpoet_page: 1
mgmlp_media_folder: 20
nav_menu_item: 95
newsletter: 5
page: 33
portfolio: 3
post: 17
product: 1534
revision: 1
shop_coupon: 359
shop_order: 3
shop_order_placehold: 2625
wccf_product_field: 10
wmpc-trash: 570
wpcf7_contact_form: 8
xlwcty_thankyou: 1

### Security ###

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

### Active Plugins (43) ###

Afterpay Gateway for WooCommerce: by Afterpay – 3.8.5
Back In Stock Notifier for WooCommerce | WooCommerce Waitlist Pro: by codewoogeek – 5.2.2
XTEMOS Post Types plugin: by  – 1.16
Classic Editor: by WordPress Contributors – 1.6.3
Anti-Spam by CleanTalk: by СleanTalk - Anti-Spam Protection  – 6.29
Code Snippets: by Code Snippets Pro – 3.6.4
Contact Form 7 - Dynamic Text Extension: by AuRise Creative
SevenSpark – 4.3.1

Contact Form 7: by Takayuki Miyoshi – 5.9.3
Yoast Duplicate Post: by Enrico Battocchi & Team Yoast – 4.5
Trust.Reviews: by Trust.reviews  – 2.2.1
FileBird Pro: by Ninja Team – 6.1.1
Flamingo: by Takayuki Miyoshi – 2.5
Free Shipping Label: by Devnet – 3.0.2
Imagify: by Imagify – Optimize Images & Convert WebP & Avif – 2.2.0.1
WPBakery Page Builder: by Michael M - WPBakery.com – 7.5
Kadence WooCommerce Email Designer: by Kadence WP – 1.5.12
LiteSpeed Cache: by LiteSpeed Technologies – 6.1
Loco Translate: by Tim Whitlock – 2.6.7
Media Cleaner: by Jordy Meow – 6.7.3
Members: by MemberPress – 3.2.9
Newsletter - Amazon SES: by The Newsletter Team – 1.3.8
Newsletter - Leads: by The Newsletter Team – 1.2.8
Newsletter: by Stefano Lissa & The Newsletter Team – 8.2.4
OnSale Page for WooCommerce: by wpgenie – 1.1.3
Order Status History for WooCommerce: by alx359 – 2.0
Perfmatters: by forgemedia – 2.1.0
PixelYourSite Pinterest: by PixelYourSite – 5.3.4
PixelYourSite: by PixelYourSite – 9.5.3
Post SMTP: by Post SMTP – 2.8.11
Rank Math SEO: by Rank Math – 1.0.215.1
Tidio Chat: by Tidio LLC – 6.0.17
UpdraftPlus - Backup/Restore: by UpdraftPlus.Com
DavidAnderson – 2.24.1.26

Delete product images for WooCommerce: by Eduard V. Doloc – 1.1
Advanced Shipment Tracking for WooCommerce: by zorem – 3.6.5
WooCommerce Cart Abandonment Recovery: by CartFlows Inc – 1.2.27
Extra product options For WooCommerce | Custom Product Addons and Fields: by ThemeHigh – 3.2.5
Product Feed PRO for WooCommerce: by AdTribes.io – 13.3.1
NextMove Lite - Thank You Page for WooCommerce: by XLPlugins – 2.18.3
WooCommerce Stripe Gateway: by WooCommerce – 8.0.1
WooCommerce Photo Reviews Premium: by VillaTheme – 1.3.11
WooCommerce: by Automattic – 8.7.0
WPLoyalty - WooCommerce Loyalty Points, Rewards and Referral Pro: by Wployalty – 1.2.8
WPS Hide Login: by WPServeur
NicolasKulka
wpformation – 1.9.13.2


### Inactive Plugins (2) ###

WP-Optimize - Clean, Compress, Cache: by David Anderson
Ruhani Rabin
Team Updraft – 3.3.1

WP Rocket: by WP Media – 3.13.0.2

### Dropin Plugins () ###

advanced-cache.php: advanced-cache.php
maintenance.php: maintenance.php
object-cache.php: object-cache.php

### Settings ###

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

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 Woo.com: –
Enforce Approved Product Download Directories: –
HPOS feature screen enabled: ?
HPOS feature enabled: ?
Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore
HPOS data sync enabled: –

### Logging ###

Enabled: ?
Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2
Retention period: 30 days
Level threshold: –
Log directory size: 316 KB

### WC Pages ###

Shop base: #8 - /shop/
Cart: #9 - /cart/
Checkout: #10 - /checkout/
My account: #11 - /my-account/
Terms and conditions: ? Page not set

### Theme ###

Name: Basel
Version: 5.7.2
Author URL: https://themeforest.net/user/xtemos
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: basel/woocommerce/archive-product.php
basel/woocommerce/cart/cart.php version 7.4.0 is out of date. The core version is 7.9.0
basel/woocommerce/cart/cross-sells.php
basel/woocommerce/cart/mini-cart.php version 5.2.0 is out of date. The core version is 7.9.0
basel/woocommerce/checkout/form-checkout.php
basel/woocommerce/checkout/thankyou.php version 3.7.0 is out of date. The core version is 8.1.0
basel/woocommerce/content-product-cat.php
basel/woocommerce/content-product.php
basel/woocommerce/content-single-product.php
basel/woocommerce/content-widget-product.php
basel/woocommerce/global/breadcrumb.php
basel/woocommerce/global/form-login.php
basel/woocommerce/global/quantity-input.php version 7.4.0 is out of date. The core version is 7.8.0
basel/woocommerce/loop/loop-end.php
basel/woocommerce/loop/loop-start.php
basel/woocommerce/loop/no-products-found.php version 2.0.0 is out of date. The core version is 7.8.0
basel/woocommerce/loop/orderby.php
basel/woocommerce/loop/pagination.php
basel/woocommerce/loop/sale-flash.php
basel/woocommerce/myaccount/form-login.php
basel/woocommerce/product-searchform.php
basel/woocommerce/single-product/add-to-cart/variable.php
basel/woocommerce/single-product/meta.php
basel/woocommerce/single-product/product-image.php version 3.5.1 is out of date. The core version is 7.8.0
basel/woocommerce/single-product/product-thumbnails.php
basel/woocommerce/single-product/related.php
basel/woocommerce/single-product/sale-flash.php
basel/woocommerce/single-product/tabs/tabs.php
basel/woocommerce/single-product/title.php
basel/woocommerce/single-product/up-sells.php
basel/woocommerce/single-product.php

Outdated Templates: ?
					
					
						Learn how to update

### Admin ###

Enabled Features: activity-panels
analytics
product-block-editor
coupons
core-profiler
customer-effort-score-tracks
import-products-task
experimental-fashion-sample-products
shipping-smart-defaults
shipping-setting-tour
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
product-variation-management
product-virtual-downloadable
product-external-affiliate
product-grouped
product-linked
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: customize-store
minified-js
new-product-management-experience
product-pre-publish-modal
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-03-27 05:08:36 +11:00
Options: ?
Notes: 207
Onboarding: completed

### Action Scheduler ###

Complete: 26,453
Oldest: 2024-02-24 21:37:23 +1100
Newest: 2024-03-26 21:32:38 +1100

Failed: 3
Oldest: 2024-02-11 22:38:57 +1100
Newest: 2024-03-22 23:28:31 +1100

Pending: 4
Oldest: 2024-03-26 21:35:17 +1100
Newest: 2024-04-02 01:55:04 +1100


### Status report information ###

Generated at: 2024-03-26 21:35:38 +11:00
`

• This reply was modified 8 months ago by jwjo.

Hi @jwjo,

Thanks for sharing additional details.

I have been running the Clean up order data from legacy tables tool for days but it seems to be stuck on “Clearing data…”.

It depends on the amount of data to be processed. In some cases, it can take several hours or even a few days.

However, since you are stuck for a while, do you see any error in WooCommerce > Status > Logs? If there are any errors, they will be recorded there. Could you please share that with us?

Additionally, make sure all the plugins, themes, and codes are HPOS compatible and that the HPOS compatibility mode is also disabled.

• https://elwpin.com/2023/11/15/how-to-clean-postmeta-data-of-old-orders-after-switching-to-woocommerce-hpos/
• https://rudrastyh.com/woocommerce/high-performance-order-storage.html

You can also manually delete that table, as shared here. Make sure to make a backup before directly making any changes to the database.

How long does this process actually take and is there a way to verify that it’s actually working?

To verify if the process is working, you can check your database directly. If the number of rows in the legacy tables decreases, then the clean-up process is working.

Every time I log out from the WordPress Admin, the tool stops and I would have to restart it every time I log back in. Is there a way to let it run on the background until it finishes?

Unfortunately, this process is designed to run in the active browser session. Hence, it will stop when you log out or close the browser. At present, there is no option to let it run in the background.

We recommend that you leave your browser open and your WordPress Admin logged in until the process is complete.

To speed up the process, you may also increase your PHP Post Max Size from 256 MB to 2 GB and PHP Time Limit from 420 to 1200.

If the tool continues to hang, you may want to reach out to your hosting provider to see if there’s a server configuration issue that could be causing the problem.

I hope this provides some clarity. Please let us know if you have any other questions!

Hi there,

Thanks for your reply. There are indeed errors in the logs as shown below.

However, since you are stuck for a while, do you see any error in WooCommerce > Status > Logs? If there are any errors, they will be recorded there. Could you please share that with us?

2024-03-31T02:31:16+00:00 Error Order 47599 legacy data could not be cleaned up during batch process. Error: 47599 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order 47600 legacy data could not be cleaned up during batch process. Error: 47600 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order 47601 legacy data could not be cleaned up during batch process. Error: 47601 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order 47599 legacy data could not be cleaned up during batch process. Error: 47599 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order 47600 legacy data could not be cleaned up during batch process. Error: 47600 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order 47601 legacy data could not be cleaned up during batch process. Error: 47601 is not a valid order ID.
2024-03-31T02:31:16+00:00 Error Order legacy cleanup failed for an entire batch of orders. Aborting cleanup.

• https://elwpin.com/2023/11/15/how-to-clean-postmeta-data-of-old-orders-after-switching-to-woocommerce-hpos/

I also tried adding the code provided on the blog article above to my Code Snippets plugin. However after running the code via the “YOURWEBSITEURL/?delete_old_non_hpos_orders=yes” link, I only see the message “STOP”. I refreshed the wp_postmeta table and still see the same number of rows. I must be missing something. Is it because I need to access the URL as an administrator? I’m not sure how to do that.

Hope you could provide some guidance on how I should proceed.

Thank you.

Hi @jwjo,

The error logs show it’s trying to delete orders that don’t exist anymore. So some legacy data must’ve been deleted so far.

When you ran the code on the blog article above, did you change this line:

‘posts_per_page’ => 5,//change this number after making sure it is safe

To a higher number? If you don’t, then it’ll only delete the oldest 5 as per their instructions:

Step1: I activated HPOS in dual-mode (aka safe mode).

Step2: 1 day passed and i disabled legacy mode and kept HPOS only

Step3: 1 more day passed and i deleted the oldest 5 orders from wp_postmeta.

Step4: Everything looked good, and i did the same for all orders.

Warning: You should take a backup before applying this code

Please also keep in mind this is a third party blog post and we do not support third party codes. You should perform a backup before trying any such piece of code as a precaution.

I hope this helps so far!
-OP

Hi there,

How do I check if all the legacy data has been removed from the wp_postmeta table? Is there a SQL query I could run just to verify?

I’ve tried the blog post above but it does nothing for me. The number of records on the wp_postmeta table remains the same. I have changed the number of posts as you have suggested but it doesn’t look like it’s removing anything at all.

@jwjo GREAT QUESTION ! Also wondering ! Shouldn’t the formerly used tables for orders and products be lighter after cleaning ? Thank you !

• This reply was modified 7 months, 3 weeks ago by clitopwebsite.

Hi @jwjo,

I’ve tried the blog post above but it does nothing for me. The number of records on the wp_postmeta table remains the same. I have changed the number of posts as you have suggested but it doesn’t look like it’s removing anything at all.

As mentioned before, since that’s a third party code we can’t provide support for it.

Let’s take a step back and focus on the default WooCommerce way of doing it:

Woocommerce > Status > Tools > Clean up order data from legacy tables

Can you share more details about this? Can you try running this again and seeing if you get any errors or it completes?

Please?also enable WP Debug?and share the log found in?WooCommerce → Status → Logs?and inside the error log file generated on your server.

Please know this is a brand new feature added just recently in 8.7.0 so any feedback on its usage will be valuable to polish it or fix it if necessary!

Looking forward to resolving this issue for you.
-OP

Hi there ?? ,

We haven’t heard from you in a while, so I’m going to mark this as resolved. Feel free to start a new thread if you have any more questions.

All the best,
Omar