Shopware 6 Product Export Guide: How to Filter Parent and Variant Products Efficiently

Managing product exports in Shopware 6 can quickly become complex — especially for merchants working with large catalogs that include hundreds or thousands of parent–variant combinations. Whether you need to export only parent products for a marketplace feed, extract only variants for a pricing update, or isolate variants of a specific configurable product, our improved filtering options make these tasks significantly easier.

This guide explains how Shopware 6 parent/variant filtering works, how to configure export profiles correctly, common use cases, and important limitations to keep in mind. You’ll also find best-practice recommendations and troubleshooting tips to help ensure clean and consistent export files every time.

This article is based on the new parent/variant export features available in the Shopware import/export app.

Why Parent/Variant Filtering Matters in Shopware 6 Export

Modern ecommerce catalogs rely heavily on product variations — sizes, colors, bundles, material types, and more. Each variation often represents its own sellable SKU while remaining tied to a parent product.

Different workflows require different data outputs:

• Marketplace feeds tend to use parent products only
• Inventory updates require variant-level exports
• Pricing updates may target only specific variations
• Store synchronizations may filter variants by their parent

Without filtering, exports become bloated and require significant manual cleanup. Efficient filtering ensures that exports include exactly the data required — nothing more, nothing less.

The improved filtering capabilities now allow Shopware users to control export behavior with precision.

Shopware 6 Filtering Options Explained

Shopware now supports three flexible filtering modes when exporting products: exporting only variants, exporting only parents, or exporting variants that belong to a specific parent product. All filtering options are configured within the Advanced Filters section of your export profile.

Below, we explore each mode in depth.

Option 1 — Export Only Variants

If you want to export only product variants (and exclude parent products entirely), use this filter:

1. Navigate to Export Profile → Advanced Filters
2. Select field: parent_id
3. Select operator: equals
4. Leave the value empty
5. Save the export profile.

Only variant products are included in the export file.

This is especially useful when:

• Updating variant-level pricing
• Exporting inventory for specific SKUs
• Working with ERP systems that handle variants separately

Option 2 — Export Only Parent Products (Without Variants)

To export only parent products (and exclude all variants), apply this configuration:

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

The export contains only parent products.

This option is ideal for:

• Creating marketplace feeds that require parent-level data
• Exporting product models without their variations
• Running catalog audits on parent products only

Option 3 — Export Variants of a Specific Parent Product

This filter enables you to extract variants belonging to a single configurable (parent) product.

1. Open Export Profile → Advanced Filters
2. Choose field: parent_id
3. Choose operator: equals
4. Enter the UUID of the parent product
   Example: 019527ca391372d5a256adf8a79152a0
5. Save the profile

Only the variants linked to the specified parent product are exported.

This is useful when:

• Updating variations for a single product family
• Sending specific product sets to partners
• Debugging a parent product with inconsistent variant data

Default Export Behavior

If no filter is applied to the parent_id field:

• Shopware exports parent products along with all their variants
• Variants are grouped directly below each parent in the export output

This combined export is convenient for full catalog updates or synchronization with external systems.

Known Limitation: parent_sku Values Are Missing When Exporting Only Variants

⚠️ Important Note

When exporting only variants (Options 1 or 3), the field parent_sku will be empty.

Why This Happens

The parent_sku value is computed dynamically during export. However, when you filter variants-only, Shopware does not load parent products — meaning it cannot supply the parent SKU.

Workaround

If you need parent_sku values:

1. Export without filters (parent + variants)
2. Filter the results yourself in Excel/Google Sheets/DB
   • Keeping only the variant rows
   • The parent_sku field will remain populated

Real-World Use Cases for Parent/Variant Filters in Shopware 6

1. Repricing Only Variants

A retailer selling clothing may need to update prices only for size/color variations. Exporting only variants ensures a clean and precise dataset.

2. Generating Parent-Only Marketplace Listings

Some channels like Google Merchant Center or certain marketplaces require parent-level data without variations.

3. Updating Inventory for a Specific Product Family

For example, exporting only the variants of “PARENT-123” to update stock levels in an ERP.

4. Debugging Variant Relationships

If variants do not show correctly in the storefront, filtering by parent helps isolate issues.

Troubleshooting & Best Practices for Shopware 6 Product Export Parent and Variant Filters

Problem: Your export includes more products than expected

• Check whether multiple filters are active
• Ensure you left the value empty where required
• Confirm that equals and not equals operators are used correctly

Problem: parent_sku is empty

• This is expected when exporting only variants
• Use the no-filter export workaround

Problem: Some variants are missing

• Ensure variants are not “orphans” (missing parent_id in database)
• Verify that the parent UUID was entered correctly

Best Practices

• Give each export profile a clear name (e.g., “Variants Only — US Market”)
• Use test exports before applying changes to large files
• Maintain a list of parent UUIDs for quick filtering
• Combine filters if needed (e.g., parent_id + active = 1)

Conclusion: Filter Parent and Variant Products on Shopware Export With Ease

The enhanced parent/variant filtering options in Shopware 6 give you powerful control over product exports. Whether you’re managing large catalogs, synchronizing with external systems, or preparing clean datasets for updates, these filters help ensure accuracy, flexibility, and efficiency.

With three simple filter modes — variants only, parents only, and variants of a specific parent — you can tailor exports to perfectly match your operational needs. For complex catalogs, these capabilities dramatically reduce manual work and improve data quality.

👉 Update your app today and experience seamless Shopware 6 product export filters support for parents and variants.

🔧 Get the Improved Import & Export Tool for Shopware 6
💬 Contact our team for expert support and personalized import strategies