Back to Tools

WooCommerce Product Sorter

Use cases

Improving default product sorting in WooCommerce Ensuring products appear in logical order based on category names

Connects to the WooCommerce REST API (wc/v3) to sort products within categories by relevancy using FuzzyWuzzy token_sort_ratio.

Compares product names against category names to calculate similarity scores.

Batch updates menu_order via API to reorder products.

Handles pagination (100 items per page) and dual timeout settings (120s send/receive).

Streamlit App

Platform

Browser-based (no installation required)

Input

WooCommerce store URL

Consumer key and consumer secret API credentials

Output

Products automatically reordered within WooCommerce categories by relevancy score. Console shows category names, product counts, and sorted listings.

Launch App View Source

Features

  • WooCommerce REST API v3 integration
  • FuzzyWuzzy token_sort_ratio similarity scoring
  • Batch POST updates for menu_order values
  • Pagination handling (100 products per page)
  • 120-second timeout for large catalogs
  • Console output: category names, product counts, sorted listings

How to use

  1. 1 Enter WooCommerce store URL and API credentials
  2. 2 Tool fetches all categories and products via API
  3. 3 FuzzyWuzzy calculates product-to-category similarity
  4. 4 Batch updates menu_order to reorder products
  5. 5 Review JSON responses confirming success

Let's work together

Monthly retainers or one-off projects. No lengthy reports that sit in a drawer.

Let's Talk