Sorting orders

Hi there @lop74,

Thank you for reaching out!

It seems like this issue is related to the compatibility between your invoice plugins and the updated version of WooCommerce.

As you’ve already tried different invoice plugins, I would suggest you to check if these plugins are compatible with the latest version of WooCommerce.

If they are indeed compatible, please share with us your System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support. This will help us get a better understanding of your site setup.

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

` WordPress Environment

WordPress address (URL): https://lobo-tactical.com
Site address (URL): https://lobo-tactical.com
WC Version: 8.4.0
REST API Version: ? 8.4.0
WC Blocks Version: ? 11.6.2
Action Scheduler Version: ? 3.7.0
Log Directory Writable: ?
WP Version: 6.4.2
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: es_ES
External object cache: – Server Environment

Server Info: Apache
PHP Version: 8.0.30
PHP Post Max Size: 128 MB
PHP Time Limit: 1200
PHP Max Input Vars: 30000
cURL Version: 7.74.0
OpenSSL/1.1.1n

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

WC Database Version: 8.4.0
WC Database Prefix: wp_
Tama?o total de la base de datos: 180.36MB
Tama?o de los datos de la base de datos: 125.99MB
Tama?o del índice de la base de datos: 54.37MB
wp_woocommerce_sessions: Datos: 0.09MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_api_keys: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_attribute_taxonomies: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_downloadable_product_permissions: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_order_items: Datos: 1.52MB + índice: 0.19MB + Motor InnoDB
wp_woocommerce_order_itemmeta: Datos: 5.52MB + índice: 5.03MB + Motor InnoDB
wp_woocommerce_tax_rates: Datos: 0.02MB + índice: 0.06MB + Motor InnoDB
wp_woocommerce_tax_rate_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zones: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_shipping_zone_locations: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_shipping_zone_methods: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_woocommerce_payment_tokens: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_woocommerce_payment_tokenmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_woocommerce_log: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_actionscheduler_actions: Datos: 2.66MB + índice: 0.73MB + Motor MyISAM
wp_actionscheduler_claims: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_actionscheduler_groups: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
wp_actionscheduler_logs: Datos: 1.38MB + índice: 0.97MB + Motor MyISAM
wp_aiowps_audit_log: Datos: 4.31MB + índice: 0.16MB + Motor InnoDB
wp_aiowps_debug_log: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_aiowps_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_aiowps_global_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_aiowps_logged_in_users: Datos: 0.02MB + índice: 0.08MB + Motor InnoDB
wp_aiowps_login_lockdown: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_aiowps_message_store: Datos: 14.52MB + índice: 0.00MB + Motor InnoDB
wp_aiowps_permanent_block: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_cart_process: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_cli_cookie_scan: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_cli_cookie_scan_categories: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_cli_cookie_scan_cookies: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
wp_cli_cookie_scan_url: Datos: 0.01MB + índice: 0.00MB + Motor MyISAM
wp_cli_scripts: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_commentmeta: Datos: 0.31MB + índice: 0.20MB + Motor MyISAM
wp_comments: Datos: 2.54MB + índice: 0.86MB + Motor MyISAM
wp_cr_local_forms: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_gla_budget_recommendations: Datos: 0.20MB + índice: 0.11MB + Motor InnoDB
wp_gla_merchant_issues: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_gla_shipping_rates: Datos: 0.02MB + índice: 0.05MB + Motor InnoDB
wp_gla_shipping_times: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_links: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_litespeed_img_optming: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_nacex_expediciones: Datos: 0.36MB + índice: 0.05MB + Motor InnoDB
wp_nacex_tarifas: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_nacex_tarifas_his: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_options: Datos: 5.39MB + índice: 0.35MB + Motor MyISAM
wp_postmeta: Datos: 53.60MB + índice: 19.12MB + Motor MyISAM
wp_posts: Datos: 10.52MB + índice: 3.75MB + Motor InnoDB
wp_redsys_order: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_redsys_reference: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_termmeta: Datos: 0.06MB + índice: 0.09MB + Motor InnoDB
wp_terms: Datos: 0.02MB + índice: 0.06MB + Motor MyISAM
wp_term_relationships: Datos: 0.28MB + índice: 0.53MB + Motor MyISAM
wp_term_taxonomy: Datos: 0.23MB + índice: 0.02MB + Motor MyISAM
wp_tinvwl_analytics: Datos: 0.16MB + índice: 0.16MB + Motor MyISAM
wp_tinvwl_items: Datos: 0.05MB + índice: 0.01MB + Motor MyISAM
wp_tinvwl_lists: Datos: 0.03MB + índice: 0.01MB + Motor MyISAM
wp_tm_taskmeta: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_tm_tasks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_trp_gettext_es_es: Datos: 0.36MB + índice: 0.27MB + Motor InnoDB
wp_usermeta: Datos: 1.58MB + índice: 0.87MB + Motor MyISAM
wp_users: Datos: 0.11MB + índice: 0.08MB + Motor MyISAM
wp_wcpdf_invoice_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wcpdf_packing_slip_number: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wc_admin_notes: Datos: 0.01MB + índice: 0.00MB + Motor MyISAM
wp_wc_admin_note_actions: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_wc_category_lookup: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
wp_wc_customer_lookup: Datos: 0.08MB + índice: 0.06MB + Motor MyISAM
wp_wc_download_log: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wc_orders: Datos: 1.50MB + índice: 0.63MB + Motor InnoDB
wp_wc_orders_meta: Datos: 5.52MB + índice: 5.03MB + Motor InnoDB
wp_wc_order_addresses: Datos: 0.48MB + índice: 0.42MB + Motor InnoDB
wp_wc_order_coupon_lookup: Datos: 0.01MB + índice: 0.01MB + Motor MyISAM
wp_wc_order_operational_data: Datos: 0.33MB + índice: 0.14MB + Motor InnoDB
wp_wc_order_product_lookup: Datos: 0.36MB + índice: 0.30MB + Motor MyISAM
wp_wc_order_stats: Datos: 0.18MB + índice: 0.10MB + Motor MyISAM
wp_wc_order_tax_lookup: Datos: 0.09MB + índice: 0.10MB + Motor MyISAM
wp_wc_product_attributes_lookup: Datos: 1.52MB + índice: 1.52MB + Motor InnoDB
wp_wc_product_download_directories: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_product_meta_lookup: Datos: 1.52MB + índice: 1.23MB + Motor InnoDB
wp_wc_rate_limits: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_reserved_stock: Datos: 0.00MB + índice: 0.00MB + Motor MyISAM
wp_wc_tax_rate_classes: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wc_webhooks: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpf_filters: Datos: 0.05MB + índice: 0.00MB + Motor InnoDB
wp_wpf_meta_data: Datos: 4.52MB + índice: 9.58MB + Motor InnoDB
wp_wpf_meta_keys: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpf_meta_values: Datos: 0.02MB + índice: 0.03MB + Motor InnoDB
wp_wpf_meta_values_bk: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpf_modules: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpf_modules_type: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wpf_usage_stat: Datos: 0.02MB + índice: 0.02MB + Motor InnoDB
wp_wpmailsmtp_debug_events: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_wpmailsmtp_tasks_meta: Datos: 0.02MB + índice: 0.00MB + Motor InnoDB
wp_yoast_indexable: Datos: 1.35MB + índice: 0.14MB + Motor MyISAM
wp_yoast_indexable_hierarchy: Datos: 0.04MB + índice: 0.10MB + Motor MyISAM
wp_yoast_migrations: Datos: 0.00MB + índice: 0.01MB + Motor MyISAM
wp_yoast_primary_term: Datos: 0.09MB + índice: 0.10MB + Motor MyISAM
wp_yoast_seo_links: Datos: 1.52MB + índice: 0.36MB + Motor InnoDB
wp_yoast_seo_meta: Datos: 0.17MB + índice: 0.00MB + Motor InnoDB Post Type Counts

acf-field: 1
acf-field-group: 1
apifw_inv_templates: 1
attachment: 5999
cookielawinfo: 16
custom_css: 7
elementor_library: 1
inspire_invoice: 2
mc4wp-form: 1
nav_menu_item: 57
oembed_cache: 81
page: 53
popup: 3
popup_theme: 8
post: 108
product: 727
product_variation: 7002
reviewx: 1
revision: 1
shop_coupon: 124
shop_order: 1509
shop_order_refund: 129
wp_global_styles: 1
wp_navigation: 1 Security

Secure connection (HTTPS): ?
Hide errors from visitors: ? Active Plugins (24)

All In One WP Security: por Equipo de All In One WP Security & Firewall – 5.2.5
Brave Conversion Engine: por Brave – 0.6.5
CookieYes | GDPR Cookie Consent: por CookieYes – 3.1.8
Customer Reviews for WooCommerce: por CusRev – 5.38.10
MC4WP: Mailchimp for WordPress: por ibericode – 4.9.11
Nacex: por Nacex development – 2.7.6.1
Perfect Brands for WooCommerce: por QuadLayers – 3.3.2
Pasarela Unificada de Redsys para WooCommerce: por Redsys Servicios de Procesamiento S.L. – 1.0.6
Show-Hide/Collapse-Expand: por Bunte Giraffe – 1.3.0
TI WooCommerce Wishlist: por TemplateInvaders – 2.8.0
Converter for Media: por matt plugins – 5.11.5
Woo Custom Stock Status: por Softound Solutions – 1.4.3
Product Filter by WBW: por WBW – 2.5.1
Payment Plugins para Stripe WooCommerce: por Payment Plugins
[email protected] – 3.3.55

WooCommerce Google Analytics Integration: por WooCommerce – 1.8.13
PDF Invoices & Packing Slips for WooCommerce: por WP Overnight – 3.7.6
WooCommerce: por Automattic – 8.4.0
Yoast SEO: por Equipo Yoast – 21.8
Asset CleanUp Pro: Page Speed Booster: por Gabe Livan – 1.2.4.7
Asset CleanUp: Page Speed Booster: por Gabe Livan – 1.3.9.3
WP Fastest Cache Premium: por Emre Vona – 1.7.0
WP Fastest Cache: por Emre Vona – 1.2.3
WP Mail SMTP: por WP Mail SMTP – 3.11.0
WP-Optimize - Clean, Compress, Cache: por David Anderson
Ruhani Rabin
Team Updraft – 3.2.22 Inactive Plugins (0) Dropin Plugins (1)

maintenance.php: maintenance.php Must Use Plugins (2)

aios-firewall-loader.php: por –
Asset CleanUp Pro: Plugin Filtering: por Gabriel Livan – 1.0 Settings

API Enabled: –
Force SSL: –
Currency: EUR (€)
Currency Position: right
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 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: ? WC Pages

Base de la tienda: #6 - /tienda/
Carrito: #7 - /carrito/
Finalizar compra: #8 - /finalizar-compra/
Mi cuenta: #9 - /mi-cuenta/
Términos y condiciones: #5778 - /terminos-y-condiciones/ Theme

Name: Woostify
Version: 2.2.8
Author URL: https://woostify.com/about
Child Theme: ? – Si estás modificando WooCommerce en un tema padre que no has creado personalmente
te recomendamos utilizar un tema hijo. Ver: Cómo crear un tema hijo

WooCommerce Support: ? Templates

Overrides: woostify/woocommerce/single-product/stock.php 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
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-external-affiliate
settings
async-product-editor-category-field

Daily Cron: ? Next scheduled: 2024-01-12 09:01:09 +01:00
Options: ?
Notes: 12
Onboarding: completed Plantillas de TI WooCommerce Wishlist

Anulaciones: – Action Scheduler

Completo: 7.665
Oldest: 2023-12-11 10:09:25 +0100
Newest: 2024-01-11 05:48:35 +0100

Fallida: 157
Oldest: 2021-04-27 10:39:19 +0200
Newest: 2024-01-11 09:57:30 +0100

Pendiente: 7
Oldest: 2024-01-11 10:12:30 +0100
Newest: 2025-01-01 00:00:01 +0100 Status report information

Generated at: 2024-01-11 10:08:15 +01:00
`

Hello lop74!

Thank you for your reply.

I appreciate you sending in the System Status Report, which helps provide a clearer picture of the situation.

With the update to WooCommerce for the HPOS database version, there’s been a change in how order data is stored, which can affect how third-party plugins interact with the orders list.

Could you let me know which invoice plugin you’ve been using? It’s possible that the plugin you’re using has not yet been updated to support sorting features with HPOS data storage.

Since these functionalities are often managed by the plugins themselves, it would be advisable to reach out directly to the plugin authors and inquire if they have plans to update their plugin to support HPOS. This step could potentially help in addressing the sorting issue you are experiencing.

Please keep me posted on your progress, and I’ll be here to assist you further if needed. ??

Best regards.

Hi @doublezed2

The plugin is PDF Invoices & Packing Slips for WooCommerce (WP Overnight).

I’ve contacted to them before. They’ve updated their plugin to HPOS version a year ago.

All of my plugins are always updated.

Thanks.

Hey @lop74,

I’ve contacted to them before. They’ve updated their plugin to HPOS version a year ago.

Gotcha!

Since this issue is specifically related to a third-party plugin and not WooCommerce core itself, I’d suggest touching base with the “PDF Invoices & Packing Slips for WooCommerce” plugin developers again for further help with this particular issue, as support related to third-party plugins is outside our scope of support.

The plugin developers may have a fix or temporary workaround for this ??. Here is a direct link to their dedicated support forum:

• PDF Invoices & Packing Slips for WooCommerce support forum

Hope this helps point you in the right direction!