Parent/Variant Filtering for Export
Overview
Section titled “Overview”You can now filter product exports by parent/variant relationships to export only the products you need.
Filter Options
Section titled “Filter Options”Option 1: Export Only Variants
Section titled “Option 1: Export Only Variants”How to configure:
- Go to export profile → Advanced Filters
- Select field:
parent_id - Select operator:
equals - Leave value empty (do not enter anything)
- Save profile
Result: Only variant products will be exported (no parent products)
Option 2: Export Only Parent Products (Without Variants)
Section titled “Option 2: Export Only Parent Products (Without Variants)”How to configure:
- Go to export profile → Advanced Filters
- Select field:
parent_id - Select operator:
not equals - Leave the value empty
- Save profile
Result: Only parent products will be exported (no variants)
Option 3: Export Variants from Specific Parent Product
Section titled “Option 3: Export Variants from Specific Parent Product”How to configure:
- Go to export profile → Advanced Filters
- Select field:
parent_id - Select operator:
equals - Enter the UUID of the parent product (e.g.,
019527ca391372d5a256adf8a79152a0) - Save profile
Result: Only variants of the specified parent product will be exported
Default Behavior
Section titled “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
Section titled “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:
- Export without filters (gets parents + variants)
- Filter the results in your spreadsheet/database after export