Format Product Information for Bulk Import

Before you can upload a spreadsheet of your products to the Online Store, it must be formatted based on the guidelines below. You'll also need to download the Online Store starter CSV file as explained in Import Multiple Products. You can upload no more than 1,000 products.

1. To see how the guidelines below should be applied to your products, open the starter CSV file that you downloaded from the Online Store's Import Products Page.

   Note: If you have relatively few products to import, you can manually copy and paste them into the starter file, remove the four rows of example products, leave the rest of the file as is, and skip to Step 7.

2. Open your own product spreadsheet and save it as a copy of your original spreadsheet.
3. Rename the appropriate columns in your own product spreadsheet to match those listed below.
4. Rearrange the order of the columns in your spreadsheet to match the order they’re displayed in the Online Store starter template CSV file.
5. Remove any columns from your spreadsheet that are not included in the Online Store starter template CSV file.
6. Proceed column by column in your spreadsheet to format your data according to the formatting rules in the guidelines below.
7. Once that’s done, re-save your spreadsheet as a CSV file. See Upload Your Product Information to move the spreadsheet data into your Online Store.

   Note: Do not save your spreadsheet as a CSV file if it contains lots of UTF-8 characters, such as the accented é in resumé. (Other examples of these "extended" characters include ñ, ü, superscripts, fractions, and currency symbols other than the U.S. dollar, such as the euro symbol €.) Instead, see Prevent Extended Character Errors.

Product Spreadsheet Guidelines

Next steps

• Format Product Spreadsheet As CSV File
• Upload Product Information

More info

• Import Multiple Products
• Fix Product Import Errors