In some cases, you may want to export only specific SKUs rather than an entire filtered product set. Elovate’s rule builder offers several conditions to achieve this — but it’s important to understand how each works, and which one is best for SKU lists.
How not to filter SKUs
Contains
The “contains” condition doesn’t check for exact matches — it looks for any SKU that contains the text you specify.
Example:
If you setSKU contains nike shoes
, you may also get SKUs that include justnike
, justshoes
, or even partial matches likenike-shows
. This is rarely ideal for precise exports.Equals
“Equals” looks for an exact match, but it only works for a single value per rule.
Example:SKU equals nike
→ exports only the SKU exactly namednike
.If you want to export
nike
andshoe
, you’d need to create two separate rules using “OR,” which can quickly become cumbersome.
The best way: IN
The most efficient method is to use the IN condition:
This allows you to specify multiple SKUs in one rule.
Separate SKUs with a comma and a space.
Example:
SKU IN nike, shoe, adidas-001, boots-2024
This will export exactly those SKUs you listed — no partial matches, no accidental extras.
Pro tip:
When working with large SKU lists, prepare them in a spreadsheet first, then copy and paste them into the “IN” condition for faster setup.