Skip to main content

How to export multiple SKU's

Learn how to export specific SKUs in Elovate using the “IN” condition for precise, multi-SKU selection, and avoid common filtering mistakes

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 set SKU contains nike shoes, you may also get SKUs that include just nike, just shoes, or even partial matches like nike-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 named nike.

    • If you want to export nike and shoe, 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.

Did this answer your question?