Common Business Scenarios

This section illustrates typical real-world use cases when importing assortments via CSV.


🌟

Products = bulk inclusion Variants = fine-grained control Variants always override products when they conflict.

Scenario 1 — Include a whole product (all variants)

Use case:

The product with all its variants must be fully visible in the catalog.

Assortment External IdProduct External IdVariant External Idunlink
123product-A

Result:

  • Product product-A is included.
  • All its variants are included.

Scenario 2 — Include only specific variants of a product

Use case:

Only some sizes/colors/formats should be visible.

Assortment External IdProduct External IdVariant External Idunlink
123variant-A1
123variant-A2

Result:

  • Only variant-A1 and variant-A2 are included.
  • The product itself is not linked.

Scenario 3 — Include a product but exclude one variant

Use case:

The product is available except one out-of-stock size.

Assortment External IdProduct External IdVariant External Idunlink
123product-A
123variant-A3true

Result:

  • Product product-A is included.
  • All variants are included except variant-A3.

Scenario 4 — Include only one variant from a product

Use case:

Only one specific format should be visible.

Assortment External IdProduct External IdVariant External Idunlink
123product-Avariant-A1

Result:

  • Only variant-A1 is included.
  • The product and other variants are not included.
📘

Because the variant has priority over the product on the same row, the product ID is optional.


Scenario 5 — Remove a full product from an assortment

Use case:

The product (all the variants) must no longer be visible at all.

Assortment External IdProduct External IdVariant External Idunlink
123product-Atrue

Result:

  • Product product-A is removed.
  • All its variants are removed.

Scenario 6 — Remove only one variant

Use case:

One specific variant should no longer be available.

Assortment External IdProduct External IdVariant External Idunlink
123variant-A2true

Result:

  • Only variant-A2 is removed.
  • Other variants remain untouched.

Scenario 7 — Progressive refinement (real-life PIM flow)

Use case:

Start simple, then refine over time.

Step 1 — Initial import:

Assortment External IdProduct External Id
123product-A
123product-B

Step 2 — Later refinement:

Assortment External IdVariant External Idunlink
123variant-A3true
123variant-B1true

Final result:

  • Products A and B included.
  • But:
    • variant-A3 excluded.
    • variant-B1 excluded.