Order Sortby Date Not Working

Hi @webdevwalton

Thanks for reaching out!

I understand your concern regarding the issue you’re facing with the Order Date filter. It seems there might be a slight glitch causing the orders not to appear in the exact chronological order.

I’d like to understand your site properly. Please share with us the System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.

You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Once we have more information, we’ll be able to assist you further.

Hi there,

Thanks for replying!

Here’s the status report:

` WordPress Environment

WordPress address (URL): https://piesbypost.com<br>Site address (URL): https://piesbypost.com<br>WC Version: 8.3.1<br>REST API Version: ? 8.3.1<br>WC Blocks Version: ? 11.4.9<br>Action Scheduler Version: ? 3.6.4<br>Log Directory Writable: ?<br>WP Version: ? 6.3.2 - There is a newer version of WordPress available (6.4.1)<br>WP Multisite: –<br>WP Memory Limit: 512 MB<br>WP Debug Mode: –<br>WP Cron: ?<br>Language: en_GB<br>External object cache: – Server Environment

Server Info: nginx<br>PHP Version: 8.2.12<br>PHP Post Max Size: 100 MB<br>PHP Time Limit: 43300<br>PHP Max Input Vars: 10000<br>cURL Version: 7.81.0<br>OpenSSL/3.0.2

SUHOSIN Installed: –<br>MySQL Version: 8.0.33-25<br>Max Upload Size: 50 MB<br>Default Timezone is UTC: ?<br>fsockopen/cURL: ?<br>SoapClient: ?<br>DOMDocument: ?<br>GZip: ?<br>Multibyte String: ?<br>Remote Post: ?<br>Remote Get: ? Database

WC Database Version: 8.3.1<br>WC Database Prefix: wp_<br>Total Database Size: 304.64MB<br>Database Data Size: 178.81MB<br>Database Index Size: 125.83MB<br>wp_woocommerce_sessions: Data: 7.02MB + Index: 0.11MB + Engine InnoDB<br>wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_order_items: Data: 1.52MB + Index: 0.45MB + Engine InnoDB<br>wp_woocommerce_order_itemmeta: Data: 36.56MB + Index: 9.03MB + Engine InnoDB<br>wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_locations: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_woocommerce_payment_tokens: Data: 0.09MB + Index: 0.05MB + Engine InnoDB<br>wp_woocommerce_payment_tokenmeta: Data: 0.22MB + Index: 0.23MB + Engine InnoDB<br>wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_actions: Data: 5.02MB + Index: 5.83MB + Engine InnoDB<br>wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_actionscheduler_logs: Data: 4.02MB + Index: 3.63MB + Engine InnoDB<br>wp_automatewoo_abandoned_carts: Data: 1.52MB + Index: 0.08MB + Engine InnoDB<br>wp_automatewoo_customer_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_customers: Data: 1.52MB + Index: 1.84MB + Engine InnoDB<br>wp_automatewoo_events: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_guest_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_guests: Data: 0.25MB + Index: 0.39MB + Engine InnoDB<br>wp_automatewoo_log_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_logs: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_queue: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_queue_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_automatewoo_referral_advocate_keys: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_automatewoo_referral_invites: Data: 0.05MB + Index: 0.05MB + Engine InnoDB<br>wp_automatewoo_referrals: Data: 0.02MB + Index: 0.08MB + Engine InnoDB<br>wp_bakesheet: Data: 1.52MB + Index: 0.00MB + Engine InnoDB<br>wp_cf7a_blacklist: Data: 0.28MB + Index: 0.02MB + Engine InnoDB<br>wp_cf7a_wordlist: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_commentmeta: Data: 1.52MB + Index: 0.56MB + Engine InnoDB<br>wp_comments: Data: 12.52MB + Index: 10.09MB + Engine InnoDB<br>wp_defender_audit_log: Data: 14.52MB + Index: 11.58MB + Engine InnoDB<br>wp_defender_email_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_defender_lockout: Data: 2.52MB + Index: 2.28MB + Engine InnoDB<br>wp_defender_lockout_log: Data: 5.52MB + Index: 3.53MB + Engine InnoDB<br>wp_defender_scan: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_defender_scan_item: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_frmt_form_entry: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_entry_meta: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_frmt_form_views: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_mailchimp_carts: Data: 1.20MB + Index: 0.00MB + Engine InnoDB<br>wp_mailchimp_jobs: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_options: Data: 7.45MB + Index: 0.30MB + Engine InnoDB<br>wp_pmxe_exports: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_google_cats: Data: 0.39MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_posts: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_pmxe_templates: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_postmeta: Data: 44.58MB + Index: 49.16MB + Engine InnoDB<br>wp_posts: Data: 4.52MB + Index: 2.42MB + Engine InnoDB<br>wp_sbi_feed_caches: Data: 0.14MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_sbi_instagram_feed_locator: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_feeds_posts: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_sbi_instagram_posts: Data: 0.14MB + Index: 0.00MB + Engine InnoDB<br>wp_sbi_sources: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_smartcrawl_redirects: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_smush_dir_images: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_usermeta: Data: 15.52MB + Index: 18.03MB + Engine InnoDB<br>wp_users: Data: 1.52MB + Index: 1.19MB + Engine InnoDB<br>wp_wc_admin_note_actions: Data: 0.08MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_admin_notes: Data: 0.09MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_customer_lookup: Data: 1.52MB + Index: 0.52MB + Engine InnoDB<br>wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_od_time_framemeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_od_time_frames: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_order_addresses: Data: 0.02MB + Index: 0.06MB + Engine InnoDB<br>wp_wc_order_bundle_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_order_coupon_lookup: Data: 0.17MB + Index: 0.23MB + Engine InnoDB<br>wp_wc_order_operational_data: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_order_product_lookup: Data: 1.52MB + Index: 1.06MB + Engine InnoDB<br>wp_wc_order_stats: Data: 1.52MB + Index: 0.69MB + Engine InnoDB<br>wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_orders: Data: 0.02MB + Index: 0.11MB + Engine InnoDB<br>wp_wc_orders_meta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_wc_product_attributes_lookup: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB<br>wp_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdi_feeds: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wdi_themes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_bundled_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_bundled_items: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_woocommerce_exported_csv_items: Data: 0.16MB + Index: 0.02MB + Engine InnoDB<br>wp_woocommerce_gc_activity: Data: 0.06MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cards: Data: 0.08MB + Index: 0.06MB + Engine InnoDB<br>wp_woocommerce_gc_cardsmeta: Data: 0.05MB + Index: 0.03MB + Engine InnoDB<br>wp_wpvivid_options: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_wt_iew_action_history: Data: 0.11MB + Index: 0.00MB + Engine InnoDB<br>wp_wt_iew_mapping_template: Data: 0.02MB + Index: 0.00MB + Engine InnoDB<br>wp_yoast_indexable: Data: 0.09MB + Index: 0.09MB + Engine InnoDB<br>wp_yoast_indexable_hierarchy: Data: 0.02MB + Index: 0.05MB + Engine InnoDB<br>wp_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB<br>wp_yoast_primary_term: Data: 0.02MB + Index: 0.03MB + Engine InnoDB<br>wp_yoast_seo_links: Data: 0.25MB + Index: 0.22MB + Engine InnoDB Post Type Counts

acf-field: 122<br>acf-field-group: 23<br>attachment: 209<br>custom_css: 1<br>customize_changeset: 1<br>jb_store_css: 10<br>nav_menu_item: 15<br>page: 21<br>pie: 26<br>product: 34<br>product_variation: 9<br>revision: 13<br>shop_coupon: 105<br>shop_order: 8619<br>shop_order_refund: 109<br>side: 13<br>wp_block: 11<br>wp_global_styles: 1<br>wpcf7_contact_form: 1 Security

Secure connection (HTTPS): ?<br>Hide errors from visitors: ? Active Plugins (26)

Advanced Custom Fields PRO: by WP Engine – 6.2.3<br>AutomateWoo - Refer A Friend Add-on: by WooCommerce – 2.6.13<br>AutomateWoo: by WooCommerce – 5.5.22<br>WP Engine Smart Plugin Manager: by WP Engine – 5.17.30<br>Contact Form 7: by Takayuki Miyoshi – 5.8.3<br>Yoast Duplicate Post: by Enrico Battocchi and Team Yoast – 4.5<br>Facebook for WooCommerce: by Facebook – 3.1.4<br>Google Analytics for WordPress by MonsterInsights: by MonsterInsights – 8.21.0<br>Site Kit by Google: by Google – 1.114.0<br>Smash Balloon Instagram Feed: by Smash Balloon – 6.2.6<br>Jetpack Boost: by Automattic - Jetpack Site Speed team – 2.2.0<br>Mailchimp for WooCommerce: by Mailchimp – 3.3<br>Performance Lab: by WordPress Performance Team – 2.7.0<br>Post Types Order: by Nsp Code – 2.1.1<br>Regenerate Thumbnails: by Alex Mills (Viper007Bond) – 3.1.6<br>Lazy Load - Optimize Images: by WP Rocket – 2.3.6<br>TinyPNG - JPEG, PNG & WebP image compression: by TinyPNG – 3.4.3<br>Trustpilot-reviews: by Trustpilot – 2.5.925<br>WooCommerce Stripe Gateway: by WooCommerce – 7.7.0<br>WooCommerce Gift Cards: by WooCommerce – 1.12.1<br>WooCommerce Order Delivery: by Themesquad – 2.2.3<br>WooCommerce Shipping & Tax: by WooCommerce – 2.4.0<br>WooCommerce - ShipStation Integration: by WooCommerce – 4.3.9<br>WooCommerce: by Automattic – 8.3.1<br>Yoast SEO: by Team Yoast – 21.5<br>WP Migrate: by WP Engine – 2.6.10 Inactive Plugins (8)

AntiSpam for Contact Form 7: by Codekraft – 0.4.5<br>Branda Pro: by WPMU DEV – 3.4.9.3<br>MonsterInsights - Ads Addon: by MonsterInsights Team – 1.8.1<br>MonsterInsights - eCommerce Addon: by MonsterInsights Team – 8.4.0<br>MonsterInsights - EU Compliance: by MonsterInsights Team – 2.2.7<br>MonsterInsights Pro: by MonsterInsights – 8.17<br>SmartCrawl Pro: by WPMU DEV – 3.6.4<br>Smush: by WPMU DEV – 3.15.1 Dropin Plugins (2)

advanced-cache.php: advanced-cache.php<br>object-cache.php: Performance Lab Server Timing Object Cache Drop-In Must Use Plugins (6)

Force Strong Passwords - WPE Edition: by Jason Cosper – 1.8.0<br>WP Engine Cache Plugin: by WP Engine – 1.1.4<br>WP Engine Seamless Login Plugin: by WP Engine – 1.6.1<br>WP Engine Security Auditor: by wpengine – 1.1.1<br>WP Engine System: by WP Engine – 5.0.1<br>WP Migrate Compatibility: by Delicious Brains – 1.3 Settings

API Enabled: –<br>Force SSL: –<br>Currency: GBP (￡)<br>Currency Position: left<br>Thousand Separator: ,<br>Decimal Separator: .<br>Number of Decimals: 2<br>Taxonomies: Product Types: bundle (bundle)<br>custom_bundle (custom_bundle)<br>custom_pack (custom_pack)<br>external (external)<br>flexible_pack (flexible_pack)<br>grouped (grouped)<br>mix and match (mix-and-match)<br>pack (pack)<br>simple (simple)<br>subscription (subscription)<br>variable (variable)<br>variable subscription (variable-subscription)

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

Connected to WooCommerce.com: –<br>Enforce Approved Product Download Directories: ?<br>HPOS feature screen enabled: –<br>HPOS feature enabled: –<br>Order datastore: WC_Order_Data_Store_CPT<br>HPOS data sync enabled: – WC Pages

Shop base: #6 - /shop/<br>Basket: #7 - /basket/<br>Checkout: #8 - /checkout/<br>My account: #9 - /my-account/<br>Terms and conditions: #580 - /terms-conditions/ Theme

Name: Pies By Post<br>Version: 1.0<br>Author URL: https://alexwalton.dev/<br>Child Theme: ? – If you are modifying WooCommerce on a parent theme that you did not build<br>personally we recommend using a child theme. See: How to create a child theme

WooCommerce Support: ? Templates

Overrides: pies-by-post/woocommerce/global/wrapper-end.php<br>pies-by-post/woocommerce/global/wrapper-start.php Gift Cards

Database Version: 1.12.1<br>Loopback Test: ?<br>Task Queueing Test: ? Admin

Enabled Features: activity-panels<br>analytics<br>product-block-editor<br>coupons<br>core-profiler<br>customer-effort-score-tracks<br>import-products-task<br>experimental-fashion-sample-products<br>shipping-smart-defaults<br>shipping-setting-tour<br>homescreen<br>marketing<br>mobile-app-banner<br>navigation<br>onboarding<br>onboarding-tasks<br>product-variation-management<br>remote-inbox-notifications<br>remote-free-extensions<br>payment-gateway-suggestions<br>shipping-label-banner<br>subscriptions<br>store-alerts<br>transient-notices<br>woo-mobile-welcome<br>wc-pay-promotion<br>wc-pay-welcome-page

Disabled Features: customize-store<br>minified-js<br>new-product-management-experience<br>product-virtual-downloadable<br>product-external-affiliate<br>settings<br>async-product-editor-category-field

Daily Cron: ? Next scheduled: 2023-11-27 17:12:34 +00:00<br>Options: ?<br>Notes: 143<br>Onboarding: completed Action Scheduler

Canceled: 281<br>Oldest: 2023-10-28 10:52:57 +0000<br>Newest: -0001-11-30 00:00:00 +0000

Complete: 15,307<br>Oldest: 2023-10-28 00:26:20 +0000<br>Newest: 2023-11-27 12:57:28 +0000

Pending: 6<br>Oldest: 2023-11-27 12:57:57 +0000<br>Newest: 2023-12-25 20:54:00 +0000 Order Delivery

Minimum working days: 2<br>Checkout location: Before order notes<br>Checkout options: calendar<br>Max delivery days: 90<br>Delivery fields: required<br>Enable local pickup: ?<br>Overrides: - Shipping Days

Sunday: ?<br>Cut-off time: 14:00

Monday: ?<br>Cut-off time: 15:00

Tuesday: ?<br>Cut-off time: 15:00

Wednesday: ?<br>Cut-off time: 15:00

Thursday: ?<br>Cut-off time: 15:00

Friday: ?<br>Cut-off time: 15:00

Saturday: ?<br>Cut-off time: - Delivery Ranges

Default: 1 - 40<br>Shipping methods: - Delivery Days

Sunday: ?<br>No of orders: 0<br>Shipping methods: all<br>Time frames: no

Monday: ?<br>No of orders: 0<br>Shipping methods: all<br>Time frames: no

Tuesday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Wednesday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Thursday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Friday: ?<br>No of orders: 200<br>Shipping methods: all<br>Time frames: no

Saturday: ?<br>No of orders: 200<br>Shipping methods: all_except<br>Time frames: no Status report information

Generated at: 2023-11-27 12:58:02 +00:00<br>`

Hi @webdevwalton,

Thank you for providing the detailed system report. It helps us understand your setup better.

Looking at your report, I see that you are using an outdated version of WordPress. You are currently on version 6.3.2, while the latest version is 6.4.1. This could potentially be causing some issues, including the one you’re experiencing with the Order Date filter. I recommend updating your WordPress to the latest version.

?? Just a quick reminder: Before you make any changes, we strongly recommend that you create a backup of your full site and database. This is a crucial step to ensure that in case anything goes wrong, you can easily restore your site to its previous, functioning state.

Additionally, I see that you have a number of plugins installed. There’s a possibility that one of these plugins could be causing a conflict. To check this, you could temporarily deactivate all plugins except for WooCommerce, and see if the problem persists. If the issue is resolved, you can reactivate your plugins one by one to identify which one is causing the conflict. Here’s a handy guide on testing for conflicts: ?? How to Test for Plugin and Theme Conflicts.

If updating WordPress and checking for plugin conflicts do not resolve the issue, we would appreciate it if you could provide us with any fatal error logs that you might have. You can find these under WooCommerce > Status > Logs.

Once you’ve collected this information, please paste it inside a Code block in your reply, or use https://pastebin.com to paste it and share the link with us.

Thanks for your patience and cooperation in this matter! We’re here to help you get this sorted.