Importing Attributes into the Shopify Collection Filter App

Creating and assigning attributes for lots of products using the CSV import capabilities allows you to be more efficient, especially with large product catalogs.

If you wish to update many products at a time, importing via CSV is perhaps the most efficient way.

Create the CSV File

Importing Attributes via CSV import will allow you to create Attribute Sets, Attributes and Values, and assign them to many Products.

For Shopify Basic stores, imports are limited to two Product updates every second. This is an API limitation set by Shopify. Shopify Plus stores have much faster API calls and imports should be quicker.

One of the easiest ways to understand how to format your import file is to download our sample CSV import file. This CSV file can be opened in Excel or Numbers.

Export Attributes

Export Attributes

If you have already assigned Attributes to some of your Products, you can export your existing configurations as a CSV file. This will allow you to simply edit the file, then import it back into the App.

File Columns

There are only three columns required to import product Attributes:

  • Handle. This is the Shopify handle for your products. You may want to export your products from your store and copy/paste your product handles into your import spreadsheet.
  • Attribute Set. The name of the Attribute Set you wish to assign to each Product. You must use an existing Attribute Set name (names are case-sensitive).
  • Attributes. The format of entering Attributes is [Attribute Name]=[Attribute Value]
    • Attribute Name. The name of the attribute. Spaces are allowed. Must match the name of an existing Attribute (case-sensitive).
    • Attributes. The value you wish to assign to the Product. New Attribute Values will be added to the App.
  • Products can be assigned multiple Attributes, each one separated by a semi-colon (“;”).

Let’s take an example row to illustrate:

14k-wire-bloom-earrings,Earrings,Stone=Diamond;Caret=14k;Metal=Platinum

In this row, the Product (14k-wire-bloom-earrings) will be assigned the Attribute Set of “Earrings.” The Attributes assigned to this Product will be:

  • Stone: Diamond.
  • Caret: 14k.
  • Metal: Platinum.
In your data, avoid using “curly quotes” or other special characters. This may keep certain attributes from being assigned. If your imported data do not render correctly, review your data for the presence of irregular characters.

If you are using Attributes that can accommodate multiple values for a given product (e.g. Multi-Select or Checkbox), you can import multiple Attribute Values for a product. Each Value should be included separately and paired with the appropriate Attribute. For example, if you wanted to assign Diamond and Pearl to an Attribute called Stone, the Attributes column would include:

Stone=Diamond;Stone=Pearl

This would assign both Diamond and Pearl to the assigned product.

Upload CSV File

Once you have created your import spreadsheet, you can now import it into the App to assign Attributes to many products.

Export Your Spreadsheet

If you’ve created your file in Excel, Google Sheets or Numbers, you will need to first export it as a comma-delimited CSV file. If you have to specify field quoting, choose “quotes” (“).

Import CSV File

In the Products > Import Attributes screen, at the bottom, you can either drag-and-drop your import file, or click and locate it on your computer. When the file is uploaded, the Progress Queue indicator in the sidebar will show you the process of updating your Products. Depending on the number of Products being updated, this may take a while due to Shopify API throttle limitations (Shopify Plus merchants enjoy faster API speeds).

After the import is completed, you will receive an email letting you know the results of the import. Any rows in your CSV file that failed to import will be included in a downloadable CSV file you can review, edit and re-submit.