jseverson

I ran into the same issue today while using Firefox. I disabled both Ad Block Plus and Disconnect and the issue resolved itself. When I re-enabled both, I had no issues. Not sure it was a fluke but maybe this will help someone else.

@treibalen Thanks for that. That sort of fixed the issue.

They have 38 products so I upped the product view to 40. When I do so, it shows all products. I’m not sure what field it is sorting by but it does appear to show all products.

If I drop it down to 30, or back to the default of 20, I run into the same issue with sorting.

It’s really weird. But, at this point, I think this may be what my client will have to live with.

As a workaround, you could also try to change Number of items per page on All Products page in Screen Options, however, that might be not a too viable solution as your product count increases.

That would only affect the number of products displayed on the front end, no? The front end is working fine. It’s only the “All” option in the Products admin that is broken.

And it isn’t even the count that is broken. It displays 2 pages of products, which is correct, of 38 products total. But page 1 displays 20 products in the wrong order while page 2 displays 18 of the same 20 products from page 1 but in reverse order.

And I have switched themes. I’ve done the standard troubleshooting steps of switching to one of the default WordPress themes. I’ve tried Twenty Nineteen and Twenty Twenty. I’ve also deactivated all plug-ins except WooCommerce. I even deactivated WooCommerce in the hope that whatever the issue is, deactivating would reset something.

I’ve pretty much exhausted all possible solutions other than possibly forcing it to work via code.

I can open a ticket with my host and I will. But, being in this industry for 20 years, I know exactly how it will go. They will tell me it’s a plug-in issue and they are going to direct me right back to you.

No other item on the site is broken. It’s only the WooCommerce “All” sort option that isn’t working correctly. So that seems to indicate it’s either a WooCommerce plug-in issue or a WooCommerce data issue. Neither of which can the web host help me with.

Is there a custom PHP script that I can add to the functions.php file to force the default sort in the Products admin to sort by date published or ID? Or, better yet, as a drop-in plugin? The latter would be ideal since the designer didn’t set up a child theme for this site.

Great sleuthing here! You mentioned that your dev site is the exact copy as your live site, meaning that databases are identical too, is that correct? Is your dev database located locally in this case while live one is hosted?

There are 3 different installations: a live site, a dev site, and a local site. Each has their own database. Live and dev are hosted; local is sitting on my computer.

Plug-in wise, the only difference between the live and dev site is that the live site has an active backup plug-in while the dev site has an active Maintenance plug-in. All other plug-ins are the same.

The live site and my local site have the same files and the same database content. I grabbed a backup of the live database yesterday, dumped the contents of my local database, and imported the content into my local database.

When I view the local site using the latest data from the live database, the “All” sort is working perfectly. When I view the dev site using its database, the “All” sort also works perfectly. When I point to the live database on the dev site, the “All” sort is broken just like on the live site.

All I see in Console for the live site are some warnings; no errors. https://snipboard.io/uajk7q.jpg

I also tried some additional troubleshooting and ideas today. First, I decided to create a new database and pointed the dev site to it. I then exported an .sql backup from phpMyAdmin and imported it into the new database. Using the live site data in this new database still resulted in the “All” function failing to work properly. I then tried repairing and optimizing the tables on the new database. That also didn’t fix this issue.

Next, I dropped all of the tables in the new database. I then dropped the tables in my local version and imported the latest .sql file via SQLyog. Everything looked good locally. So, I exported an .sql of the tables from my local install and imported that file into the new database. That also didn’t resolve the issue.

Lastly, I dropped the tables in the new database and tried doing a direct copy from the live database to the new database via phpMyAdmin’s Copy Database. Again, the same result.

So, it seems like there is something in the live database that is causing the “All” sort function to not work correctly on the website’s hosting platform.

Is there a code snippet that I can add to functions.php to force it to sort by date published if sorting by “All” that I can try to see if that will fix the issue?

• This reply was modified 5 years, 1 month ago by jseverson.
• This reply was modified 5 years, 1 month ago by jseverson.

Ok, I updated my wp-config.php file on the dev site to point to the live database. I also hard coded the site URL into wp-config.php so that I could continue viewing the dev site.

When I go to Products on the dev site while connected to the live database, I get the same result as the live site. When I switch back to the dev database, the “All” products sorts correctly and I’m able to view all products across the 2 pages of results.

I just downloaded an SQL backup, emptied my local database and imported the new backup. When I log in and go to Products, everything is working as it should.

Jetpack isn’t installed. Both the live and dev sites are running PHP 7.2 now.

My local version is running PHP 7.1.22. The dev site is running 7.2.24. I can try upgrading PHP on the live site early next week to see if that resolves things.

I’m wondering if I should try pointing the dev site to the live database to see if I then get the same results?

No luck.

I also tried deactivating WooCommerce and re-activating it to see if that would solve this issue. I also created a new user account to see if it was something with my own admin account. Neither changed how the “All” sort option is presenting products.

Any other ideas? I’m totally stumped.

Is there possibly a piece of code that I can add to functions.php to try to force it to order by ID (or some other field) when the querystring doesn’t contain post_status or orderby?

Yup, when I go to the 2nd page, the slug is: /wp-admin/edit.php?post_type=product&paged=2.

Yes, my local version is an exact copy. I downloaded all of the files in the root as well as everything in wp-admin, wp-content, and wp-includes. And I took a fresh version of the MySQL database and set it up locally.

My client has the site hosted with InMotion on one of their WordPress plans. It has a Cache Manager in cPanel. I’ve both purged that cache and disabled it. Neither fixed the issue.

Is there anything under Status -> Tools that might help? I tried clearing the transients before posting to the forum. Would running the Update Database option possibly help? Or regenerating the product lookup tables?

Jess,
Here is the report. I’ve removed the domain for privacy. The URL slug is correct.

There are 4 WooCommerce related plug-ins that are marked as not having been tested with the installed version of WooCommerce. I had deactivated all 4 and it did not resolve this issue. I also have all 4 installed and active on both the dev site and my local site without any issues.

### WordPress Environment ###

WordPress address (URL): https://www.******.com
Site address (URL): https://www.******.com
WC Version: 3.8.1
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.3.2
WP Multisite: –
WP Memory Limit: 768 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: –

### Server Environment ###

Server Info: Apache
PHP Version: 7.0.33 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 512 MB
PHP Time Limit: 30
PHP Max Input Vars: 6200
cURL Version: 7.66.0
OpenSSL/1.0.2t

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.2.25-MariaDB-log
Max Upload Size: 512 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wp_
MaxMind GeoIP Database: ?
Total Database Size: 38.37MB
Database Data Size: 30.80MB
Database Index Size: 7.57MB
wp_woocommerce_sessions: Data: 2.54MB + Index: 0.09MB + Engine MyISAM
wp_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_downloadable_product_permissions: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_order_items: Data: 0.08MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.23MB + Index: 0.25MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.27MB + Index: 0.48MB + Engine InnoDB
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.00MB + Engine MyISAM
wp_woocommerce_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.45MB + Index: 0.45MB + Engine InnoDB
wp_ctsop_plugin: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_draft_submissions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_entry: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_gf_entry_meta: Data: 0.05MB + Index: 0.08MB + Engine MyISAM
wp_gf_entry_notes: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_form: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_form_meta: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_gf_form_revisions: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_gf_form_view: Data: 0.04MB + Index: 0.02MB + Engine MyISAM
wp_ksp_layers: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ksp_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_ksp_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 2.16MB + Index: 1.08MB + Engine InnoDB
wp_pmxi_files: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_history: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_imports: Data: 0.02MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_posts: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_pmxi_templates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_postmeta: Data: 8.52MB + Index: 3.03MB + Engine InnoDB
wp_posts: Data: 3.52MB + Index: 0.28MB + Engine InnoDB
wp_revslider_css: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_terms: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_term_relationships: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_term_taxonomy: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_usermeta: Data: 1.52MB + Index: 0.63MB + Engine InnoDB
wp_users: Data: 0.06MB + Index: 0.05MB + Engine InnoDB
wp_verticalmarquee: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_vertical_thumbnail_slider: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_download_log: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wc_product_meta_lookup: Data: 0.00MB + Index: 0.01MB + 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_wfBlockedIPLog: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_wfBlocks7: Data: 0.02MB + Index: 0.02MB + Engine MyISAM
wp_wfConfig: Data: 2.54MB + Index: 0.02MB + Engine MyISAM
wp_wfCrawlers: Data: 0.02MB + Index: 0.01MB + Engine MyISAM
wp_wfFileChanges: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfFileMods: Data: 1.54MB + Index: 0.32MB + Engine MyISAM
wp_wfHits: Data: 0.71MB + Index: 0.12MB + Engine MyISAM
wp_wfHoover: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfIssues: Data: 0.03MB + Index: 0.01MB + Engine MyISAM
wp_wfKnownFileList: Data: 0.81MB + Index: 0.10MB + Engine MyISAM
wp_wfLiveTrafficHuman: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfLocs: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfLogins: Data: 0.17MB + Index: 0.04MB + Engine MyISAM
wp_wfls_2fa_secrets: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wfls_settings: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wfNotifications: Data: 0.01MB + Index: 0.00MB + Engine MyISAM
wp_wfPendingIssues: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfReverseCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfSNIPCache: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wfStatus: Data: 0.15MB + Index: 0.06MB + Engine MyISAM
wp_wfTrafficRates: Data: 0.00MB + Index: 0.00MB + Engine MyISAM
wp_wpml_mails: Data: 4.84MB + Index: 0.01MB + Engine MyISAM

### Security ###

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

### Active Plugins (27) ###

Gravity Forms: by rocketgenius – 2.4.16
BackWPup: by Inpsyde GmbH – 3.7.0
Black Studio TinyMCE Widget: by Black Studio – 2.6.9
Classic Editor: by WordPress Contributors – 1.5
Contact Form 7: by Takayuki Miyoshi – 5.1.6
Content text slider on post: by Gopi Ramasamy – 7.6
Cyclone Slider Pro: by Nico Amarilla – 2.10.4
Duplicate Post: by Enrico Battocchi – 3.2.4
Kadence Slider: by Kadence Themes – 2.3.0
liMarqueeWP: by MASSCODE – 1.1.1-6.2.0
Revolution Slider: by ThemePunch – 4.6.5
SEO Ultimate: by SEO Design Solutions – 7.6.5.9
Page Builder by SiteOrigin: by SiteOrigin – 2.10.13
Tiger Technologies Plugin: by Tiger Technologies – 1.0
User Role Editor: by Vladimir Garagulya – 4.52.2
Velvet Blues Update URLs: by VelvetBlues.com – 3.2.9
Vertical marquee plugin: by Gopi Ramasamy – 6.6
WooCommerce Dynamic Pricing & Discounts: by RightPress – 2.0 – Not tested with the active version of WooCommerce
WooCommerce Customer/Order CSV Export: by SkyVerge – 4.3.7 – Not tested with the active version of WooCommerce
WooCommerce Authorize.Net AIM Gateway: by WooThemes / SkyVerge – 3.10.1 – Not tested with the active version of WooCommerce
WooCommerce UPS Shipping: by WooCommerce – 3.2.7 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.8.1
Wordfence Security: by Wordfence – 7.4.3
WP Clone by WP Academy: by WP Academy – 2.2.9
WP Mail Logging: by MailPoet – 1.9.5
WP Mail SMTP: by WPForms – 1.8.1
WordPress vertical Thumbnail Slider: by I Thirteen Web Solution – 1.2.11

### Inactive Plugins (4) ###

Akismet Anti-Spam: by Automattic – 4.1.3
Check Email: by Chris Taylor – 0.5.6
cPanel & WHM? Site Software: by cPanel
Inc. – 1.0

WP Super Cache: by Automattic – 1.7.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: –

### WC Pages ###

Shop base: #788 - /shop/
Cart: #789 - /cart-2/
Checkout: #790 - /checkout/
My account: #791 - /my-account/
Terms and conditions: #401 - /terms-of-use/

### Theme ###

Name: Virtue - Premium
Version: 4.9.18
Author URL: https://www.kadencewp.com/
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: virtue_premium/woocommerce/archive-product.php
virtue_premium/woocommerce/content-product.php
virtue_premium/woocommerce/content-product_cat.php
virtue_premium/woocommerce/content-single-product.php
virtue_premium/woocommerce/loop/loop-end.php
virtue_premium/woocommerce/loop/loop-start.php
virtue_premium/woocommerce/loop/rating.php
virtue_premium/woocommerce/loop/sale-flash.php
virtue_premium/product-searchform.php
virtue_premium/woocommerce/single-product/add-to-cart/external.php
virtue_premium/woocommerce/single-product/add-to-cart/grouped.php
virtue_premium/woocommerce/single-product/add-to-cart/simple.php
virtue_premium/woocommerce/single-product/add-to-cart/variable.php
virtue_premium/woocommerce/single-product/product-image.php
virtue_premium/woocommerce/single-product/product-thumbnails.php
virtue_premium/woocommerce/single-product/related.php
virtue_premium/woocommerce/single-product/sale-flash.php
virtue_premium/woocommerce/single-product/up-sells.php
virtue_premium/woocommerce/single-product.php
virtue_premium/woocommerce/taxonomy-product_cat.php
virtue_premium/woocommerce/taxonomy-product_tag.php

### Customer/Order CSV Export ###

Order Export Format: default
Customer Export Format: default
Automatically Export Orders: disabled
Automatically Export Customers: disabled

### Authorize.Net AIM ###

Environment: Production

### Action Scheduler ###

Complete: 26
Oldest: 2019-12-21 21:23:43 -0800
Newest: 2020-01-13 18:16:42 -0800

Pending: 0
Oldest: –
Newest: –

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

• This reply was modified 5 years, 2 months ago by jseverson.