Import Shopify Products and include them in Collections from the same file

Import Shopify Product with Collection column

You can add Product to Custom Collections (Manual Collections) when creating or updating Products sheet.

Changes

New column: “Collection”

This column is only imported – so that you can import the standard Shopify CSV files the same way as you would using the Shopify Admin CSV import.

The Excelify app will read from the Collection column the collection title, and add your product to it.

The difference from standard Shopify CSV import is that you also can use this to add this product to several collections at once – just repeat the product row for each collection you want to add it to.

Importing from: “Custom Collection”

This column was earlier used just to export the list of Handles of all the Manual Collections where this product is in. Now you can import from this column too – the Excelify app will add this product to all the collections that you have listed here.

If they don’t exist, then Excelify will create them for you.

Example

Import Shopify Products to several Collections at once

In this example you can see that we are importing “Product 1” which will be included in the following collections:

  • Collection A
  • Collection B
  • collection-1
  • collection-2
  • collection-3
  • collection-4
  • collection-5

The result will look like this:

Shopify Product added to several collections with one import

Good to know

  • You can use those columns to also update existing products – add them to certain collections.
  • If you need to manage your Collections in more details, including adding and removing products, please, refer to Custom Collections sheet documentation.

What to do next?