How do I add products using the Bulk Uploader?

The bulk uploader tool allows you to upload an entire spreadsheet of new product listings to your shop. Follow the steps below to learn how.

---

How to create a bulk upload

1. Click the Product tab on the left-hand side of the page in your Brand portal. A dropdown menu will appear that will include Bulk Uploader as an option.
   
   
2. Select the Bulk Uploader tab to open the Bulk Uploader page.
   
   
3. To begin the upload, click the "Download" button under the "Only adding new products?" section. This will download the template required to bulk upload your products.
   
   
   
   
   
4. Use the template as a reference (there are instructions and examples within) and fill in all the required information needed for the bulk upload. This includes:
   
   • SKU
   • Product name
   • Product type
   • Description
   • Unit wholesale price
   • Unit retail price
   • Case quantity
   • Image name
     
     
5. If you sell products as a prepack, please make sure you complete the following columns:
   • Option Name - Enter “Size|Prepack” in this field
   • Option Value - List the size ratio and sizes in this format (e.g. 1-3-1; S-M-L)
     
     
6. Once the template has been filled in with your product details, you can click the "Start Upload" button on the Bulk Upload page.
   
   
   
   
7. This will bring you to a new page where you can bulk upload the spreadsheet by dragging and dropping the file or clicking the "Upload completed spreadsheet" section on the page.
   
   
   
   
8. After uploading your completed spreadsheet, upload your image files.
   
   
   
   Please note: the image name column(s) in the template for each product listing must match the name of the image file for that product listing.
   
   
9. Once you are ready to upload, you can click the submit button in the bottom right corner of the screen. For troubleshooting support, please reference Bulk Upload Processing Report: Error Types & Solutions.
   
   
10. You'll receive an email to confirm the upload.
    
    

Congratulations! You've completed your bulk upload.

---

Adding new products in bulk

1. Open the template in either Excel or Google Sheets
2. Complete the "Products" tab with the products you'd like to add. We included an Instructions tab and Column Definitions tab to help you format your products correctly. See more details on how to add products: How to format your products
3. Save the file as a .xlsx file. If using Google Sheets, you can do this by going to File -> Download -> Microsoft Excel (.xlsx)
4. Upload the saved file in your portal under Products -> Bulk Uploader
5. Upload your image files in your portal under Products -> Bulk Uploader. See more details on how to add images: How to add your images
6. You'll receive an email once your file has been uploaded with the status of the upload and any errors, usually within an hour. It can take up to 4 hours for large uploads.

Tips & Tricks

• Be mindful that we will process the entire sheet, including any columns you may have hidden or filtered out.

• Do not add “notes” in the files, do not add HTML, do not add emojis or copyright symbols

• Do not sort the sheet by any column

• Do not rename any of the tabs

• We only support xlsx format (which can be opened and saved in Excel or Google Sheets). We do not accept CSVs.

Resources

• You can find examples for how to format your products in the Product Examples Sheet

• For more detailed information about each column, see the "Column Definitions" tab in your template

• Many cells have drop-downs with the valid values. All valid values can be seen in the "Data Options" tab in your spreadsheet

---

Formatting products with variants

1. Products are often sold in different sizes, colors, styles, and other "options"
2. Any rows sharing the same product name will be considered part of the same product
3. All options for a product must be grouped together in consecutive rows. The second group of rows with the same name will be rejected as a duplicate
4. Some column values must be the same across all product options. These are noted in "Column Definitions"
   
   

---

Formatting products with multiple options

1. In order to specify multiple sizes in one cell, Option Name must be "Size|Multiple"
2. Option 1 Value then must be in the comma-separated format. An example is S,M,L
3. Every size will share the same image and metadata listed in that row
   
   

Tips & Tricks

• Do not include any extra characters

• Add them in the order you would like them to be displayed

---

Formatting products sold in prepacks

1. In order to sell a product in a prepack, Option 1 Name must be "Size|Prepack"
2. Option 1 Value then must be in the format #-#-#;size-size-size. An example is 1-2-2-2-1;XS-S-M-L-XL
3. You must specify each size individually. For example, 1-2-1;S-L will result in an error. The correct specification is 1-2-1;S-M-L
4. A single product variant can either be included in one or more prepacks or sold on its own with its own row, but not both
5. The first image will be applied to all variants in the prepack
6. The case quantity and minimum order quantity are only used if items in the prepack are eventually converted to sell by individual size
   
   

Tips & Tricks

• Do not add extra white space

• You can specify as many prepacks for a single product as you want

---

Formatting products available for preorder

1. There is a flag to list something as a preorder
2. If you mark it as a preorder using the "Y" notation, you must provide a "Ship By Date"
3. The other columns are optional, but provide customizations to your preorder
   
   

Tips & Tricks

• You can only list a product as either a preorder or not; you cannot have it be both at the same time. To create both, you must create a new product or row, and it will be listed separately.

• Be mindful that we will process the entire sheet, including any columns you may have hidden or filtered out.

• Do not add “notes” in the files, do not add HTML, do not add emojis or copyright symbols

• Do not sort the sheet by any column

• Do not rename any of the tabs

• We only support xlsx format which can be opened and saved in Excel or Google Sheets (note: this sheet won't work in Numbers). We do not accept CSVs

---

Bulk uploading images

There are two ways you can upload images to your new products

• Uploading images using URL links

• Uploading images by attaching image files (JPEGs, PNGs)

Uploading images using URL links

1. Paste the URL of the image you are uploading in the "Image" column.
   1. To add multiple image URLs to a product, include a space in between each URL.
2. You must attach at least 1 image to all products with a Product Status of "Active". Any "Active" products with 0 images will be rejected. You can upload "Draft" products without images.
3. The bulk upload tool will only accept public URLs. If a URL requires a password to view, we will not be able to upload it.
4. Each URL must link to a single image. We cannot accept URLs to folders of images. This will result in an error.
   
   

Tips & Tricks

• Make sure the URL is public and accessible to Faire or people outside your organization.
  
  
• If linking to images, they must be direct-to-image links, if you're using a program like Google Drive to link to the images, you will need to convert the image links into direct-to-image file links. The default link that Google Drive provides is only a link to the preview of the image.

Uploading images using File Upload

1. Enter the file name of the image you are uploading in the "Image" column.
2. Once you are finished filling out your spreadsheet and upload it to your Faire portal, you'll be able to upload your image files in bulk.
3. You can only add a product with a Product Status of "Active" if it has at least one image. Any "Active" products added with 0 images will result in an error. However, you can upload "Draft" products without images.

Tips & Tricks

• When listing the file name, the extension (i.e. ".jpg") is optional

• Images will be added to the product in the order they are imported from the spreadsheet

• Make sure the leftmost image in the first row for the product is the one you want to be the hero image. That image will be the one shown on product titles for your product

• You can import up to 4 images for each option of your product. The leftmost image will be the one shown when that product option is selected

• Your product photos should comply with our Product Image guidelines

---

Bulk uploading testers and customizations

Testers

For each product that you would like to create a tester for, enter the price of the tester for each currency amount in the corresponding cell(s) below the "Tester Price" column(s). You may choose to enter tester prices for as many of the available currency columns as you would like.

Customizations

1. Under the "Customizable" column, enter "Yes" if you would like to offer customization for the corresponding product
2. Under the "Customizable Instructions" column, provide instructions to your retailer for how to add customization text to the selected product. A maximum of 70 characters is allowed for this cell.
3. Under the "Customization Input Required" column, enter "Yes" if retailers must add some customization text when purchasing this product. Otherwise they will be allowed to check out without specifying any customization
4. Under the "Customization Character Input Limit" column, enter the maximum number of characters (in numerical format) for your customizations (ex: entering 50 would mean that a retailer's customization text cannot contain more than 50 characters)
5. Under the "Customization Minimum Order Quantity" column, enter the minimum order quantity (MOQ) for your customization. Your customization MOQ is the minimum number of items a retailer must order when they purchase your customization. Remember that the minimum order quantity must be greater than or equal to your product's MOQ and must be a multiple of your case size
6. Under the "Customization Charge Per Unit" column(s), enter the customization price(s) for each currency that you would like to offer your customization to. You may choose to enter customization prices for as many of the available currency columns as you would like