---
title: Filter Parent and Variant Products for Export
description: How to filter product exports by parent and variant relationships so you can export only variants, only parents, or variants from one parent product.
---

Use this page when you need advanced-price-related exports to target only parent products, only variants, or variants from a specific parent.

## Overview

You can now filter product exports by parent/variant relationships to export only the products you need.

## Filter Options

### Option 1: Export Only Variants

**How to configure:**

1. Go to export profile → Advanced Filters
2. Select field: `parent_id`
3. Select operator: `equals`
4. Leave value **empty** (do not enter anything)
5. Save profile

**Result:** Only variant products will be exported (no parent products)

![](/images/image%204.png)

### Option 2: Export Only Parent Products (Without Variants)

**How to configure:**

1. Go to export profile → Advanced Filters
2. Select field: `parent_id`
3. Select operator: `not equals`
4. Leave the value **empty**
5. Save profile

**Result:** Only parent products will be exported (no variants)

![](/images/image%205.png)

### Option 3: Export Variants from Specific Parent Product

**How to configure:**

1. Go to export profile → Advanced Filters
2. Select field: `parent_id`
3. Select operator: `equals`
4. Enter the **UUID** of the parent product (e.g., `019527ca391372d5a256adf8a79152a0`)
5. Save profile

**Result:** Only variants of the specified parent product will be exported

![](/images/image%206.png)

## Default Behavior

If no `parent_id` filter is set:

- The app exports parent products with all their variants
- Variants appear immediately after their parent product in the export file

## Known Limitation

⚠️ **Important:** When exporting only variants (Options 1 or 3 above), the `parent_sku` column will be **empty** in the export.

**Why:** The `parent_sku` field is computed during export and requires loading the parent product data. When you filter for variants only, parent products are not loaded.

**Workaround:** If you need `parent_sku` values:

1. Export without filters (gets parents + variants)
2. Filter the results in your spreadsheet/database after export