Name (numeric) attribute sorting showing up random order on refresh #33567
Labels
plugin: woocommerce
Issues related to the WooCommerce Core plugin.
status: can't reproduce
Issues that can't be reproduced.
Prerequisites
Describe the bug
After updating to 6.6.0 we noticed the attribute sorting for the method Name (numeric) has changed behavior and shows up random on each refresh
Expected behavior
A 1
A 2
B 1
B 2
Actual behavior
Showing randomly
Steps to reproduce
go to https://theshoehole.com/shop/
select size attribute selection in filters
See order of attributes
refresh browser
note different order
WordPress Environment
`
WordPress Environment
WordPress address (URL): https://theshoehole.com
Site address (URL): https://theshoehole.com
WC Version: 6.6.1
REST API Version: ✔ 6.6.1
WC Blocks Version: ✔ 7.6.2
Action Scheduler Version: ✔ 3.4.0
Log Directory Writable: ✔
WP Version: 6.0
WP Multisite: –
WP Memory Limit: 1 GB
WP Debug Mode: –
WP Cron: ✔
Language: en_US
External object cache: –
Server Environment
Server Info: LiteSpeed
PHP Version: 7.4.30
PHP Post Max Size: 128 MB
PHP Time Limit: 3000
PHP Max Input Vars: 10000
cURL Version: 7.83.1
OpenSSL/1.1.1o
SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.35-MariaDB
Max Upload Size: 122 MB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔
Database
WC Database Version: 6.6.1
WC Database Prefix: sh_
Total Database Size: 149.04MB
Database Data Size: 122.24MB
Database Index Size: 26.80MB
sh_woocommerce_sessions: Data: 1.02MB + Index: 0.02MB + Engine InnoDB
sh_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
sh_woocommerce_order_items: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_woocommerce_order_itemmeta: Data: 0.11MB + Index: 0.06MB + Engine InnoDB
sh_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
sh_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_actionscheduler_actions: Data: 5.02MB + Index: 4.72MB + Engine InnoDB
sh_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_actionscheduler_logs: Data: 5.02MB + Index: 4.23MB + Engine InnoDB
sh_cleantalk_ac_log: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_cleantalk_sessions: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_cleantalk_sfw: Data: 0.45MB + Index: 0.34MB + Engine InnoDB
sh_cleantalk_sfw_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_cleantalk_spamscan_logs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_cleantalk_ua_bl: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_comments: Data: 0.06MB + Index: 0.09MB + Engine InnoDB
sh_e_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_e_notes: Data: 0.02MB + Index: 0.17MB + Engine InnoDB
sh_e_notes_users_relations: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
sh_e_submissions: Data: 0.02MB + Index: 0.27MB + Engine InnoDB
sh_e_submissions_actions_log: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
sh_e_submissions_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_gf_addon_feed: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_gf_draft_submissions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_gf_entry: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
sh_gf_entry_meta: Data: 0.23MB + Index: 0.38MB + Engine InnoDB
sh_gf_entry_notes: Data: 0.13MB + Index: 0.03MB + Engine InnoDB
sh_gf_form: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_gf_form_meta: Data: 0.03MB + Index: 0.00MB + Engine InnoDB
sh_gf_form_revisions: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_gf_form_view: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_gf_rest_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_imagify_files: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
sh_imagify_folders: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_itsec_bans: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_itsec_dashboard_events: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_itsec_distributed_storage: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_itsec_fingerprints: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_itsec_geolocation_cache: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_itsec_lockouts: Data: 0.02MB + Index: 0.08MB + Engine InnoDB
sh_itsec_logs: Data: 15.02MB + Index: 2.58MB + Engine InnoDB
sh_itsec_mutexes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_itsec_opaque_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_itsec_temp: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
sh_itsec_user_groups: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_jet_smart_filters_indexer: Data: 0.17MB + Index: 0.00MB + Engine InnoDB
sh_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_mailchimp_carts: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
sh_mailchimp_jobs: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_options: Data: 16.03MB + Index: 0.16MB + Engine InnoDB
sh_postmeta: Data: 63.56MB + Index: 8.59MB + Engine InnoDB
sh_posts: Data: 9.14MB + Index: 0.89MB + Engine InnoDB
sh_signups: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
sh_termmeta: Data: 0.06MB + Index: 0.06MB + Engine InnoDB
sh_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_term_relationships: Data: 0.20MB + Index: 0.13MB + Engine InnoDB
sh_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_usermeta: Data: 1.52MB + Index: 0.64MB + Engine InnoDB
sh_users: Data: 0.09MB + Index: 0.08MB + Engine InnoDB
sh_wc_admin_notes: Data: 0.06MB + Index: 0.00MB + Engine InnoDB
sh_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
sh_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
sh_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
sh_wc_product_attributes_lookup: Data: 0.14MB + Index: 0.11MB + Engine InnoDB
sh_wc_product_download_directories: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_wc_product_meta_lookup: Data: 0.05MB + Index: 0.09MB + Engine InnoDB
sh_wc_rate_limits: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_woocommerce_square_customers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_wpforms_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_wpmailsmtp_debug_events: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_wpmailsmtp_tasks_meta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
sh_yoast_indexable: Data: 2.48MB + Index: 1.36MB + Engine InnoDB
sh_yoast_indexable_hierarchy: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
sh_yoast_migrations: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
sh_yoast_primary_term: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
sh_yoast_seo_links: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
Post Type Counts
afreg_fields: 1
attachment: 4671
custom_css: 1
def_reg_fields: 10
elementor_library: 8
elementor_snippet: 2
elementor-hf: 1
itsec-dash-card: 7
itsec-dashboard: 1
jet-smart-filters: 10
nav_menu_item: 19
page: 10
post: 3
product: 288
revision: 479
shop_coupon: 8
shop_order: 158
shop_order_refund: 11
wc_afrsm: 4
wc_afrsm_zone: 1
wp_global_styles: 1
wpforms: 1
Security
Secure connection (HTTPS): ✔
Hide errors from visitors: ✔
Active Plugins (29)
Gravity Forms: by Gravity Forms – 2.6.3
Advanced Flat Rate Shipping For WooCommerce: by theDotstore – 4.7.3
Astra Pro: by Brainstorm Force – 3.6.9
Premium Starter Templates: by Brainstorm Force – 3.1.11
BackupBuddy: by iThemes – 8.7.4.0
Better Search Replace: by Delicious Brains – 1.4
Anti-Spam by CleanTalk: by СleanTalk – 5.179.1
Elementor Pro: by Elementor.com – 3.7.2
Elementor: by Elementor.com – 3.6.6
Facebook for WooCommerce: by Facebook – 2.6.16
Facebook Chat Plugin - Live Chat Plugin for WordPress: by Meta – 2.4
Site Kit by Google: by Google – 1.77.0
Gravity Forms Mailchimp Add-On: by Gravity Forms – 5.1
Elementor Header & Footer Builder: by Brainstorm Force
Nikhil Chavan – 1.6.11
Imagify: by WP Media – 1.10
iThemes Security Pro: by iThemes – 7.1.2
iThemes Sync: by iThemes – 2.1.10
JetSmartFilters: by Crocoblock – 2.3.12
Jetpack: by Automattic – 11.0
Mailchimp for WooCommerce: by Mailchimp – 2.6.2
Ultimate Addons for Elementor: by Brainstorm Force – 1.36.7
Custom User Registration Fields for WooCommerce: by Addify – 1.7.6
WooCommerce Google Analytics Integration: by WooCommerce – 1.5.10
WooCommerce PayPal Payments: by WooCommerce – 1.8.1
WooCommerce Shipping & Tax: by WooCommerce – 1.26.1
WooCommerce Square: by WooCommerce – 3.1.0
WooCommerce: by Automattic – 6.6.1
Yoast SEO: by Team Yoast – 19.1
WP Mail SMTP: by WPForms – 3.4.0
Inactive Plugins (0)
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: –
WC Pages
Shop base: #1472 - /shop/
Cart: #7 - /cart/
Checkout: #8 - /checkout/
My account: #9 - /my-account/
Terms and conditions: #33 - /refund_returns/
Theme
Name: The Shoe Hole
Version: 1.0.0
Author URL: https://www.sieverscreative.com/
Child Theme: ✔
Parent Theme Name: Astra
Parent Theme Version: 3.8.2
Parent Theme Author URL: https://wpastra.com/about/?utm_source=theme_preview&utm_medium=author_link&utm_campaign=astra_theme
WooCommerce Support: ✔
Templates
Overrides: –
WooCommerce PayPal Payments
Onboarded: ✔
Shop country code: US
WooCommerce currency supported: ✔
PayPal card processing available in country: ✔
Pay Later messaging available in country: ✔
Webhook status: –
Vault enabled: ✔
Logging enabled: –
Reference Transactions: –
Used PayPal Checkout plugin: –
Square
Environment: Production
Tokenization Enabled:
Debug Mode: Off
Admin
Enabled Features: activity-panels
analytics
coupons
customer-effort-score-tracks
experimental-products-task
experimental-import-products-task
experimental-fashion-sample-products
homescreen
marketing
mobile-app-banner
navigation
onboarding
onboarding-tasks
remote-inbox-notifications
remote-free-extensions
payment-gateway-suggestions
shipping-label-banner
subscriptions
store-alerts
transient-notices
wc-pay-promotion
wc-pay-welcome-page
wc-pay-subscriptions-page
Disabled Features: minified-js
settings
Daily Cron: ✔ Next scheduled: 2022-06-22 17:26:02 -05:00
Options: ✔
Notes: 68
Onboarding: completed
Action Scheduler
Complete: 16,647
Oldest: 2022-05-22 11:37:05 -0500
Newest: 2022-06-22 11:35:15 -0500
Pending: 6
Oldest: 2022-06-22 11:36:39 -0500
Newest: 2022-06-28 09:20:49 -0500
Status report information
Generated at: 2022-06-22 11:36:24 -05:00
`
Isolating the problem
The text was updated successfully, but these errors were encountered: