Creating and assigning attributes for lots of products using the CSV import capabilities allows you to be more efficient, especially with large product catalogs.
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.
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.
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.
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:
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.
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:
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.