WooCommerce Product Sort not working if Jetpack search enabled.

[WillBrubaker]

Steps to reproduce the issue

1. WooCommerce installed and activated on an Atomic environment and has a shop page that is populated with products.
2. Jetpack search is enabled
3. Visit the WooCommerce shop page.
4. Use the sorting option
   
5. Products not sorted :(

What I expected

For the products to be sorted.

What happened instead

Nothing.

cc: @robertocyrino can you provide some site details for the Atomic site you were able to reproduce this on?

[WillBrubaker]

reference 3356208-zen

[jeherve]

Jetpack search is enabled

By Jetpack Search, do you mean the default Search option available under Jetpack > Settings > Performance, or the additional "Instant Search experience" available there as well?

Thank you!

[robertocyrino]

Hi there @jeherve and @WillBrubaker.

That would be the default Jetpack Search option (and not Instant Search). The issue stops when we disable this setting:

Full Size: https://d.pr/i/k02aSZ

---

Here's what happens when it's on:
Full Size: https://d.pr/i/VVE988

And here's what happens when it's off:
Full Size: https://d.pr/i/mtSyAD

---

Here's the SSR, and if you check under Active Plugins, you can see I only have:

• Akismet Anti-Spam: by Automattic – 4.1.7
• Jetpack by WordPress.com: by Automattic – 9.1
• WooCommerce: by Automattic – 4.7.0

It's an atomic site.

Keep in mind that this happens only when we're looking at search results.

WordPress Environment

Details

```

`

WordPress Environment

WordPress address (URL): https://lets-test-this.blog
Site address (URL): https://lets-test-this.blog
WC Version: 4.7.0
REST API Version: ✔ 4.7.0
WC Blocks Version: ✔ 3.6.0
Action Scheduler Version: ✔ 3.1.6
WC Admin Version: ✔ 1.6.3
Log Directory Writable: ✔
WP Version: 5.5.3
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: ✔
WP Cron: ✔
Language: en_US
External object cache: ✔

Server Environment

Server Info: nginx
PHP Version: 7.4.12
PHP Post Max Size: 2 GB
PHP Time Limit: 1200
PHP Max Input Vars: 6144
cURL Version: 7.73.0
OpenSSL/1.1.1d

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.3.24-MariaDB-log
Max Upload Size: 2 GB
Default Timezone is UTC: ✔
fsockopen/cURL: ✔
SoapClient: ✔
DOMDocument: ✔
GZip: ✔
Multibyte String: ✔
Remote Post: ✔
Remote Get: ✔

Database

WC Database Version: 4.7.0
WC Database Prefix: wp_
Total Database Size: 3.78MB
Database Data Size: 2.31MB
Database Index Size: 1.47MB
wp_woocommerce_sessions: Data: 0.09MB + Index: 0.02MB + Engine InnoDB
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.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_order_itemmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_actions: Data: 0.02MB + Index: 0.11MB + Engine InnoDB
wp_actionscheduler_claims: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_groups: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_actionscheduler_logs: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_comments: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_options: Data: 1.11MB + Index: 0.06MB + Engine InnoDB
wp_postmeta: Data: 0.17MB + Index: 0.09MB + Engine InnoDB
wp_posts: Data: 0.16MB + Index: 0.06MB + 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: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_users: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_admin_notes: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_admin_note_actions: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_category_lookup: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_customer_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_download_log: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_coupon_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_order_product_lookup: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wp_wc_order_stats: Data: 0.02MB + Index: 0.05MB + Engine InnoDB
wp_wc_order_tax_lookup: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wp_wc_product_meta_lookup: Data: 0.02MB + Index: 0.09MB + Engine InnoDB
wp_wc_reserved_stock: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wp_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wp_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB

Post Type Counts

attachment: 33
customize_changeset: 1
jetpack_migration: 2
nav_menu_item: 7
page: 10
post: 8
product: 18
product_variation: 7
revision: 8
wp_template_part: 2

Security

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

Active Plugins (3)

Akismet Anti-Spam: by Automattic – 4.1.7
Jetpack by WordPress.com: by Automattic – 9.1
WooCommerce: by Automattic – 4.7.0

Inactive Plugins (8)

AMP: by AMP Project Contributors – 2.0.6
Classic Editor: by WordPress Contributors – 1.6
CoBlocks: by GoDaddy – 2.5.2
Crowdsignal Forms: by Automattic – 1.3.0
Gutenberg: by Gutenberg Team – 9.3.0
Layout Grid: by Automattic – 1.3
Page Optimize: by Automattic – 0.5.1
WordPress.com Editing Toolkit: by Automattic – 2.8.6

Dropin Plugins (2)

advanced-cache.php: advanced-cache.php
object-cache.php: Memcached

Must Use Plugins (1)

WP.com Site Helper: by –

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: #82 - /
Cart: #83 - /cart/
Checkout: #84 - /checkout/
My account: #85 - /my-account/
Terms and conditions: ❌ Page not set

Theme

Name: Storefront
Version: 2.9.0
Author URL: https://woocommerce.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: –

Action Scheduler

Complete: 5
Oldest: 2020-11-19 10:33:15 +0000
Newest: 2020-11-19 10:44:28 +0000

`

</details>

[robertocyrino]

Also, the correct ticket that originated this is 3500634-zen, not 3356208-zen.

[helgatheviking]

I'm able to reproduce this too with Twenty Seventeen + WooCommerce 4.7 + Jetpack 9.1 with the "Load more posts in page with a button" setting for Infinite scroll

[bluefuton]

Example of URLs that return the same set of results for me:

/?orderby=price-desc&paged=1&s=sloth&post_type=product
/?orderby=price&paged=1&s=sloth&post_type=product

The page does reload when the new sort is chosen, but the results don't reflect the change in sort.

Date sorts with an order supplied do continue to work:

/?s=sloth&orderby=date&order=ASC
/?s=sloth&orderby=date&order=DESC

cc @gibrown

[gibrown]

Sorting with either version of search (instant or "classic") doesn't work for prices or ratings or anything Woo specific. Only date and relevance is currently supported. There is no plan to add woo specific sorting to "classic" search at any point in the future. Will be getting added to the instant search.

[gibrown]

@bluefuton this is done now right? Can be closed?

[bluefuton]

@gibrown I think this is still broken for "classic" Jetpack Search - how difficult would it be to add support for Woo-specific orderby there?