EHERO Woo Query Order – Total control for sorting products in WooCommerce

Sort products in WooCommerce: decide what appears first in each category

With EHERO Ordena Productos Woo you can sort products in WooCommerce however you like: drag and drop the order of each category and set automatic rules so your best sellers rise on their own.

What a customer sees first is what gets bought most. And yet, in most stores that showcase is decided by chance: a menu_order field nobody controls, the date the product was added, or the latest supplier import. Out front, sold-out products and old references end up at the top, while what you really want to sell gets buried on page three.

EHERO Woo Query Order is the professional way to sort products in WooCommerce without touching a line of code. You define the order of the store and each category with 9 automatic patterns (newest, best sellers, by price, top rated, random, manual list…), with category rules, with a bulk action that applies a pattern to all of them at once, and with a visual drag-and-drop sorter. No more fighting WooCommerce’s default order or manually reordering hundreds of product pages.

You set it up once and the plugin applies it on the frontend, in real time, respecting catalog visibility and the sorting chosen by the customer themselves. No editing theme query loops and no losing the order every time a sync runs.

Why your catalog order determines your sales

WooCommerce, out of the box, barely lets you choose the sorting criterion, and doing it manually is impossible with dozens of categories and hundreds of SKUs. On top of that, every sync with your ERP brings in new products with menu_order set to zero, which slip in at the top and throw off the storefront.

• The first positions in each category get most of the clicks: whoever controls that controls your revenue.
• A catalog sorted by default rewards the old and the sold-out, not the profitable.
• Reordering product by product does not scale: the work is lost with the next import.

EHERO Woo Query Order solves it at the root: you set the order that sells and it stays stable.

9 patterns to sort products in WooCommerce

You choose how your store is sorted with a simple dropdown. Each pattern is applied on the frontend in real time and serves as the global starting order for the entire catalog.

• Custom menu + title: respects your menu_order and breaks ties by name.
• Newest first or oldest first: sorts by date added in whichever direction you prefer.
• Price low to high and high to low: ideal for outlet, entry-level range, or premium sales.
• Best sellers and top rated: puts what already works and converts up front.
• Random: rotates the storefront to give the whole catalog visibility.
• Manual list by IDs: the exact order you decide, reference by reference.

There are 9 patterns ready to use, and they are not mutually exclusive: they combine with category rules and advanced ordering.

Category rules: each section with its own order

Sorting products in WooCommerce does not mean the same thing in “New Arrivals” as it does in “Outlet”. With category rules you give each section its own pattern and leave the rest with the global order.

• A different pattern per category: new arrivals by date, outlet by price, featured by hand…
• Categories without their own rule automatically inherit the global pattern, with no setup needed.
• Clear status per category —”Global” or “Custom”— and a search box to find it instantly.
• Inheritance to subcategories: a rule in “Clothing” also applies to “Clothing › T-shirts” without duplicating work.

Bulk action: one pattern for all categories in one click

Want to show “newest” in all categories at once? Before, that was eighty clicks; now it’s one. The bulk action turns a repetitive task into something immediate.

• Apply a pattern to the selected categories or to ALL at once.
• Reset the categories you want back to the global order, also in bulk.
• Multi-select, “select all”, and search for stores with many categories.

It’s the fastest way to sort products in WooCommerce consistently, without going category by category.

Visual sorter: drag and drop your products

When you want the exact order, you drag and drop it. The visual sorter shows thumbnails, SKU, and stock at a glance so you don’t make mistakes.

• Reorder with the mouse, search products, and add them to the list instantly.
• Works both for the store’s global order and for a specific category.
• Option to also write the menu_order field so other plugins and exports respect your order.

Pin to the top without hiding the rest of the catalog

The classic flaw of other methods is that the manual list hides everything not in it. With EHERO Woo Query Order that doesn’t happen: your pinned products go first and the rest of the catalog is added automatically below, in a stable way.

• Pin your star products at the top and the rest is filled in automatically below.
• New products (new additions or syncs) appear at the end: they don’t disappear or jump to the top.
• The order stays put: no surprises of “it got lost and has to be saved again”.

Advanced ordering: pinned items, sold-out items, and new-arrivals boost

Combine automatic rules with your manual decisions to fine-tune the catalog to the maximum. These options are added to any pattern you have active.

• Pinned products at the top (hybrid order): you pin your stars in the header and the rest follows the chosen pattern.
• Sold-out items at the end: out-of-stock products are shown last with any pattern, so you don’t fill the storefront with items you can’t sell.
• New-arrivals boost: products added in the last N days rise above the active pattern during that time.
• Inheritance to subcategories: the parent category rule propagates downward without repeating configuration.

Also sort the categories themselves

In addition to sorting products within each section, with Query Order you sort the categories relative to each other and write that order into menu_order with a button.

• Drag and drop to decide which categories go first in menus and listings.
• “Slots” system so one category’s order does not overwrite the others.
• “Apply to all” button to write the menu_order for the entire catalog at once.

Fine-grained options for real catalogs

The details that make the difference when you sort a large catalog, with many SKUs and automatic syncs.

• Exclude featured products or grouped product children from listings to avoid duplicates.
• Price sorting that does not hide products without a price, a typical flaw in other solutions.
• Careful performance: the calculated order is cached and recalculated only when your rules or products change, not on every visit.
• Does not interfere with the REST / Store API or cron: the order is applied where the customer sees it, not where it can break integrations.

Compatible with your theme, HPOS, and page builders

Sorting products in WooCommerce should work with your theme and without breaking anything. Query Order respects what already works for you today.

• Respects the sorting chosen by the customer in the store (price, new arrivals…): if they change it, the plugin does not overwrite it.
• Compatible with HPOS, block themes, and builders like Bricks and Elementor.
• Configurable scope: apply it only to the main store archive or to all product queries, depending on what your builder needs.
• Also covers listings generated by WooCommerce product shortcodes.

Multilingual: one order for all versions of your store

If your store is multilingual with EHERO Woo Multilang, your order is respected in every language without duplicating work.

• Query Order resolves products by ID and translates references from the default language to the language the customer is viewing.
• Your pinned items, your manual lists, and your category rules apply the same in /es/, /en/, or any other configured language.
• You set the order once and it works for the whole store: zero maintenance per language.

Ideal for

No matter what you sell: if your storefront does not show first what you want to sell, sorting products in WooCommerce with EHERO Woo Query Order boosts sales from day one. Where it shines most:

📋 System requirements

Compatibility tested with current versions of WordPress and WooCommerce.

🛟 Technical support

Spanish email support* at soporte@consultoriaehero.com and a complete online manual (ES/EN). Your annual license includes updates, which install automatically from your dashboard: new features, compatibility with each WooCommerce version, and fixes. If something doesn’t sort as expected, we’ll help you get it working.

⚖️ Comparison: why EHERO Woo Query Order?

What sets this way of sorting products in WooCommerce apart from the default order, manual drag-and-drop reordering, and basic sorting plugins.

Frequently asked questions

How do I sort all categories the same way, for example “newest first”?

With the bulk action “By Category”: choose “Newest first” and click “Apply to ALL”. In one click you sort products in WooCommerce across all categories, and any categories with their own rule can also be reset to the global order in bulk.

If I set a manual order, do products not on the list disappear?

No. Query Order pins the ones you choose to the top and automatically adds the rest of the catalog below them. New products are placed at the end, never hidden. That’s exactly the difference from manual lists in other methods, which hide everything you don’t include.

Does it respect my store’s sort selector (price, new items)?

Yes. If the customer chooses a sort order, the plugin does not overwrite it: your pattern is the default order, but the visitor can change it. It also leaves the REST/Store API and cron untouched.

Does it work with my theme and page builders?

Yes: it is compatible with HPOS, block themes, and builders like Bricks or Elementor, with a scope setting to apply the order only to the shop archive or to all product queries, depending on what your builder needs.

Does it work if my store is multilingual?

Yes. With EHERO Woo Multilang, Query Order translates the references in your order into the language the customer sees, so your pinned items, manual lists, and category rules apply equally in all configured languages. You set the order once and it works for the whole store.

Why did my order used to get “lost” and not with this one?

Because it depended on the menu_order field, which new items and syncs reset to zero, letting new products slip in at the top. Query Order sets a stable pattern and places new items at the end: the order survives imports without needing to be saved again.

How many sales do you lose each month because your best products are on page three? With EHERO Woo Query Order your storefront always shows what sells, and it stays that way import after import. Start today from 49 €/year.

Take control and start sorting products in WooCommerce the way you want with EHERO Woo Query Order.

Want to see more tools for your store? Discover all our WooCommerce plugins or visit the Consultoría EHERO store.

*Support covers incidents, errors, and plugin installation; it does not include consulting, custom configurations, or custom development. Terms apply.