Bulk uploader: Products

When you receive a brand new collection, using the bulk uploader in the Tools section is an efficient way to add new products to your account.

In this article, we will guide you through how to fill out the template and highlight important fields to be aware of before uploading.

Overview of the Upload Process

There are three main steps to uploading products using the bulk uploader:

1. Download the Template

Go to Tools > Bulk Uploader > Products (found in the dropdown menu) to download the template.

2. Fill Out the Template

Complete the template with all relevant data. Required fields are marked with an asterisk (*) and include:

• Product Name
• SKU
• Category
• Stock
• Case Quantity

3. Save and Upload the Template

After filling out the template, save it as a .csv file and upload it in Tools > Bulk Uploader > Products (found in the dropdown menu).

Detailed Instructions for Filling Out the Template

When filling out the template, there are a few key points to keep in mind:

SKU:

Ensure that all SKUs are unique. If you have a Shopify integration, the SKUs must match exactly across both platforms.

Variants:

If you’re adding variants for your products (e.g., different sizes or colors), make sure all three columns are filled:

• Variant
• Variant Title
• Size/Color

If any of these fields are left empty, the upload will create variants incorrectly. Here’s a breakdown of what each field represents:

• Variant: This links all products within the same variant group on the backend. Ensure that all products in the same group have the same data filled in this field.
• Variant Title: This can represent attributes like color, size, scent, or amount.
• Size/Color: As suggested by the name of the field, this refers to the specific size or color. If you’ve already filled out the Variant Title with size or color and there’s nothing to put in the Size/Color field, simply repeat the information from Variant Title or combine data from both fields.

Example:

• Variant: T-shirt
• Variant Title: Grey
• Size/Color: L

Example of how these fields could be filled in the template.

Example from product card

Category:

Unless you're creating a new category or sub-category, ensure you use the exact same categories and sub-categories as those on your shop. To avoid typos, it's best to copy and paste the category names from Products > Categories.

Product Groups:

If the product belongs to a new product group that doesn't yet exist in your shop, you must create that group in Products > Product Groups before uploading the products.

Images:

Images can be added in two ways to the sheet: by image links or by image names. To add multiple images for one product, separate the image names with a vertical bar (|) with no spaces before or after (e.g., Image1|Image2).

• Image Links: These links must be public, meaning they should be accessible to anyone with the link.
• Image Names: Before uploading the template, ensure all images are uploaded in Products > Image Upload. In the sheet, include only the image name without the file extension (e.g., enter Image1 instead of image1.png). Additionally, ensure that no two images share the same name.

Example

• Image1|Image2

Prices:

Use periods (.) to separate decimals, not commas. This is because the sheet will be converted into a .CSV file before uploading.

• Correct: 20.99
• Incorrect: 20,99

If you have new currencies or special price lists for your products, make sure to configure these in your settings.

• Currencies: Settings > Currencies
• Special Price Lists: Settings > Companies

To hide a product from a specific currency or special price list, simply leave the price field for that currency/price list blank.

Important Notes

Do Not Move or Delete Columns:
It’s critical that you do not move or delete any columns in the template when adding new products. This will ensure that the upload process works correctly.