How can I create a 'last sizes' collection when your items have multiple variants?

Store Design

Topic summary

A sneaker retailer is trying to create a “last sizes” collection but faces a technical challenge with Shopify’s variant filtering.

The Problem:

  • Each sneaker product has multiple size variants (US 9-12 with corresponding EU sizes)
  • Shopify’s collection conditions include products if “at least one variant” matches the criteria
  • The user needs products to appear only when “all variants” match specific conditions (presumably low stock/last available sizes)

Current Status:

  • The original poster has attempted multiple approaches without success
  • A screenshot shows Shopify’s collection condition interface highlighting the “at least one variant” limitation
  • Another user has expressed interest in finding a solution
  • No solution has been identified yet — the discussion remains open with an unanswered question about how to filter based on all variants meeting criteria rather than just one
Summarized with AI on November 1. AI used: claude-sonnet-4-5-20250929.
1

Hi everybody,

How am I able to create a collection which shows all the 'Last sizes" when your items have multiple variants?

I sell sneakers through my online store, each sneaker has multiple size variants eg.

US 9 – EU 42.5,

US 9.5 – EU 43,

US 10 – EU 44,

US 10.5 – EU 44.5,

US 11 – EU 45,

US 11.5 – EU 45.5,

US 12 – EU 46

I’ve tried numerous things but can not seem to find the answer.

Screenshot 2024-05-13 at 15.57.39.png
Screenshot 2024-05-13 at 15.57.39.png1270×656 43 KB

Here it says will include all products with at least one varient that matches.

I would need it to match with all the variants.

Thanks in advance!

1 Like
2

Interested in this solution. @SebrynRonge did you find a way to do that?