Normalized Categories: One Filter for "Polos" Across Ever...

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant

PSRESTful · 2026-05-01 · via DEV Community

<a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbqo8jor205ea7hhg8rj8.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fbqo8jor205ea7hhg8rj8.png" alt="Normalized Categories on PSRESTful — one cross-supplier category tree for promotional products" width="800" height="512"></a> If you've ever tried to search "polos under $10 in navy" across more than one supplier, you already know the punchline. SanMar files them under one label, S&S Activewear under another, Hit Promotional under a third, and a long tail of suppliers keep their own taxonomy of taxonomies — <code>Polos</code>, <code>Knits</code>, <code>Apparel > Tops > Sport Shirts</code>, <code>POLO/SPORT</code>, <code>Performance Polos</code>, you get the idea. Same garment, twelve different category strings. We just shipped a fix: a single curated category tree, an AI classifier that fills it in, and a real <code>normalized_category_id</code> filter on the API. PSRESTful Product Search and <a href="https://apps.shopify.com/promosync" rel="noopener noreferrer">PromoSync</a> Product Search both use it as of today. <h2> The Problem </h2> PromoStandards never standardized categories. The Product Data service hands back whatever the supplier decides to put in <code>ProductCategory</code> and <code>ProductSubcategory</code>, and every supplier decides differently. That's fine for browsing one supplier — it falls apart the moment you try to search across all of them. Concretely, when a sales rep is on the phone and asks "what polos do we have under $10 in navy that ship from the East Coast?", the honest answer used to be "give me a few minutes." You'd run the search per supplier, mentally translate each supplier's category labels, and stitch the results back together. We wanted a single dropdown that says Polos and means it. <h2> A Curated Two-Level Taxonomy </h2> The taxonomy lives in our Django backend as a YAML fixture and a pair of models — <code>NormalizedCategory</code> and <code>NormalizedSubcategory</code> — plus a nullable <code>normalized_subcategory_id</code> foreign key on <code>Product</code>. Eleven top-level categories, ~50 subcategories, deliberately small: <ul> <li> Apparel — T-Shirts, Polos, Crewnecks, Hoodies, Fleece, 1/4 Zip, 1/2 Zip, Jackets, Vests, Pants, Shorts, Activewear, Scarves </li> <li> Headwear — Caps, Beanies, Visors, Bucket Hats</li> <li> Bags — Backpacks, Totes, Duffels, Coolers, Drawstrings </li> <li> Drinkware — Tumblers, Mugs, Water Bottles, Stemware </li> <li> Tech — Power Banks, Chargers, Audio, Cables & Adapters, Phone Accessories, Projectors </li> <li> Office & Writing — Pens, Notebooks, Desk Accessories, Calendars </li> <li> Outdoor & Lifestyle — Blankets, Umbrellas, Camping, Towels, Sunglasses </li> <li> Novelties — Stress Relievers, Fidget Toys, Plush Toys </li> <li> Awards & Recognition — Trophies, Plaques, Crystal, Medals, Ribbons, Globes </li> <li> Trade Show & Signage — Banners, Flags, Pennants, Table Covers, Signage </li> <li> Personal Care — Hand Sanitizer, Sunscreen, Lip Balm, Masks </li> </ul> Two design choices worth calling out: <ol> <li> Two levels, not five. Distributors don't navigate ten-level decision trees on the phone. Category → Subcategory is the deepest you ever need to go for a search filter. </li> <li> Slugs are the contract, names are not. Each category and subcategory has a stable <code>slug</code> (<code>polos</code>, <code>power-banks</code>) and an admin-editable <code>name</code>. The filter API takes ids; URLs use slugs. Renaming "Tech" to "Electronics" tomorrow doesn't break anything downstream. </li> </ol> <h2> Classifying Existing Products with LLMs </h2> Curating a tree is the easy part. We had hundreds of thousands of existing products to classify, and "go through them by hand" was never on the table. So we built an LLM-backed classifier. For each product, the model returns a single best subcategory along with a confidence score and a one-line reasoning. The classifier is pluggable — we run it against a hosted model in production, and against a local model via Ollama for backfills and for environments without API access. Same input, same output shape, swap the backend. <h2> API: <code>GET /extra/v2/normalized-categories</code> </h2> The taxonomy is exposed as a first-class endpoint on the PSRESTful API. The whole tree fits in one paginated response — categories with their active subcategories nested inline: <div class="highlight js-code-highlight"> <pre class="highlight shell"><code> curl 'https://api.psrestful.com/extra/v2/normalized-categories?is_active=true' \ -H 'x-api-key: YOUR_KEY' \ -H 'accept: application/json' { "count": 11, "page": 1, "page_size": 50, "total_pages": 1, "next": null, "previous": null, "results": [ { "id": 1, "name": "Apparel", "slug": "apparel", "sort_order": 0, "is_active": true, "subcategories": [ {"id": 10, "name": "T-Shirts", "slug": "t-shirts", "sort_order": 0, "is_active": true}, {"id": 11, "name": "Polos", "slug": "polos", "sort_order": 1, "is_active": true} ] } ] } </code></pre> </div> Two things to notice: <ul> <li>One call, full subtree. The taxonomy is small enough that we deliberately denormalize the response. No second ?parent= call to flesh out the children. </li> <li>is_active=true filters both levels. It returns only active categories and drops inactive subcategories from each subcategories array. So a "soft delete" of a subcategory propagates cleanly to clients without breaking the filter the next time around. </li> </ul> This is not the existing GET /extra/v2/categories endpoint, which still returns the raw, supplier-specific category strings. The two coexist on purpose — supplier categories are still useful for supplier-scoped browsing, and the normalized taxonomy is the cross-supplier one. <h2> Filtering Products </h2> Two new query params on GET /extra/v2/products: GET /extra/v2/products?normalized_subcategory_id=11 # Polos, exact match GET /extra/v2/products?normalized_category_id=1 # anything under Apparel GET /extra/v2/products?normalized_category_id=1&normalized_subcategory_id=11 subcategory wins The normalized_category_id filter is implemented as a SQLAlchemy subquery — it expands to "subcategories whose parent is this category id," then filters products against that set. So a single category id matches every leaf under it without the client having to expand the tree itself. When both are passed, the more specific id wins; this matches how cascading dropdowns send their state and means clients don't have to clear the parent when the child changes. Each product in the response now also carries a normalized_subcategory block when classified: <div class="highlight js-code-highlight"> <pre class="highlight json"><code>{ "id": 12345, "name": "Performance Polo", "main_category": "Polos", "normalized_subcategory": { "id": 11, "name": "Polos", "slug": "polos", "category": {"id": 1, "name": "Apparel", "slug": "apparel"} } } </code></pre> </div> Clients get the leaf, the parent, and the slugs in one trip — no second lookup against the taxonomy endpoint to render a label. <h2> Wired Into PSRESTful Product Search </h2> Inside <a href="https://psrestful.com/extra/search/products" rel="noopener noreferrer">https://psrestful.com/extra/search/products</a>, the new "By Category" filter is a single dropdown over the active subcategories, grouped under their parent category. Pick "Polos" once, the search runs across every supplier you have credentials for, and the supplier-specific category strings stay out of your way. If a product hasn't been classified yet, the search result card falls back to the supplier's main_category so the row still says something useful. As the classifier sweeps newer products, the normalized subcategory takes over. <h2> Wired Into PromoSync Product Search </h2> <a href="https://apps.shopify.com/promosync" rel="noopener noreferrer">https://apps.shopify.com/promosync</a> hits the same endpoint from the Shopify app side, but with a couple of small wrinkles worth flagging because they came up in code review: <ul> <li>Two-step cascade, HTMX-driven. Picking a category triggers an hx-get against a server-rendered subcategory . The payload only forwards the more specific id (subcategory if set, otherwise the parent category), which keeps the URL clean and matches the API's "subcategory wins" rule.</li> <li>Per-shop 6-hour cache. PromoSync caches the full taxonomy per shop because every search page render needs it. Six hours is plenty — the taxonomy moves at the speed of YAML edits. </li> <li>Read ids from raw query data, not the form. Django form fields validate against the queryset they were built with at request time. If the cached taxonomy is one revision behind the database, the form would silently drop the filter on submit — the dropdown would show the choice, but the search would ignore it. We mirror our brand-filter pattern instead: pull the id directly out of request.GET for the actual query, and use the form only for rendering. Fewer surprises. </li> </ul> <h2> Why This Matters </h2> Three things, in order of how much your team will feel them: <ol> <li>Sales reps stop translating. "Polos" means polos. The supplier doesn't get to override that on the search page. </li> <li>Cross-supplier filtering is a single dropdown, not a join. The same category id works whether you have credentials for one supplier or fifty.</li> <li>AI classification is reproducible. The taxonomy is plain YAML, the classifier reads from the same database the API serves, and the suggestion queue means a low-confidence label gets a human look before it ships. No black-box magic — edit the tree, rerun the classifier, ship. </li> </ol> If you're already on PSRESTful, the new "By Category" filter is live in <a href="https://psrestful.com/extra/search/products" rel="noopener noreferrer">https://psrestful.com/extra/search/products</a>. If you're integrating against the API directly, hit GET /extra/v2/normalized-categories and start filtering products by normalized_category_id or normalized_subcategory_id — full schema is on <a href="https://docs.psrestful.com" rel="noopener noreferrer">https://docs.psrestful.com</a>. Not on PSRESTful yet? <a href="https://psrestful.com/contact-us/" rel="noopener noreferrer">https://psrestful.com/contact-us/</a> and we'll get you set up. ▎ Originally published on the <a href="https://blog.psrestful.com/posts/normalized-categories-cross-supplier-search" rel="noopener noreferrer">https://blog.psrestful.com/posts/normalized-categories-cross-supplier-search</a>.

此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。原文来自 — 版权归原作者所有。

推荐订阅源

DEV Community