Use this article to troubleshoot any errors you receive when using the bulk uploader.
Error: Product with name already exists
- This means you already have a product on Faire with that exact product name. We use the product name to know that you are adding a new product.
- We do allow the ability to list duplicate products if one is a preorder and the other is an immediate/ATS.
- We most commonly see this issue when you attempt a second upload with the same products. If this is the case, you can ignore those errors as your products were likely successfully created in your first upload.
Error: Required fields are missing [fields]
- Mandatory fields required for import are not filled in in the template.
- To see the full list of mandatory fields, please reference the Column Definitions tab in the Faire bulk upload template.
Error: The following image(s) were not uploaded: [image(s)]
- The image file name in the bulk upload sheet does not match any image file that was uploaded.
Error: [value] is not a valid value for [column]
- A valid value was not entered into the cells under the mentioned column.
- To see a full list of data options for columns with dropdowns, please reference the Data Options tab in the Faire bulk upload template.
Error: All rows for a product must have the same [column names]
- Product Status
- Product Type
- Description
- Unit Wholesale Price
- Unit Retail Price
- Case Quantity
- Min Order Quantity
- Any rows sharing the same product name will be considered the same product. One exception to this rule is that you can have two products with the same name if one is a preorder. That way you can offer the same product as a preorder and ATS/immediate.
- There are many fields that need to be the same across one product. These columns are green in the Faire bulk upload template.
Error: Missing sheet names "Products"
- This is the main sheet we use to process and upload new products.
- This was most likely due to removing or renaming the sheet originally titled Products in the Faire bulk upload template.
Error: Unidentified columns at column number(s): [columns]
- You cannot add or delete columns that are in the Faire bulk upload template or else the file will fail.
Error: File did not contain any valid products to process
- The upload file was an empty file and did not contain any products.
Error: At least one image is required to create a new active product
-
In order for a product to be published or active, there needs to be an associated image.
-
The image 1 column is mandatory for at least one row for each product.
-
We do not support adding actual images in the image cells in the Faire bulk upload template. This cell needs to have an image link or image name. To learn more about how to add images correctly, please refer to the Instructions tab in the Faire bulk upload template or you can read here for further instructions.
Error: Multiple options with variations [name] = [value]
- You cannot repeat the same combination of option names and values in the same row for the same product.
Error: Need to specify either per style min order quantity or min order quantity and case quantity
- The values for min order quantity and case quantity or per style min order quantity must be set.
- If you are selling in prepacks, set per style min order quantity to "1" and then add your prepacks in the option section.
Error: Per style min order quantity can only be applied to products that have a size variation
- Products must have size options in order to be set up as open sizing.
Error: No variation name specified
- When an option name is not specified for a product.
Error: Option # Name and Option # Value must both be empty or both be specified
- You must specify both the option name and value when you provide either of them.
Error: Option names cannot be added or removed
- You cannot change option names when editing.
Error: The image format was not supported
- If linking to images, they must be direct-to-image links. If you're using a program like Google Drive to link to the image, you will need to convert the image link into a direct-to-image file link as the default link that Google Drive provides is only a link to the preview of the image.