Follow

How do I upload multiple products at once?

This bulk import guide can be downloaded as a PDF

The product import tool is useful  for uploading a large number of products at once. The import process has three steps:

  1. Uploading photos of your products
  2. Downloading an Excel template (spreadsheet) to fill in your product details
  3. Uploading the completed Excel template

Step 1: Upload Product Photos

First, you will upload photos of the products you are going to import. We recommended uploading your images first, so that you can download the Excel template with the image names already filled in.

Tip: For the best product presentation results, use large, high-resolution photos (max 10MB per photo) in .jpg format

To upload photos, you can either drag-and-drop images from a folder on your computer or click “Click here” to open a file browser.

Screen_Shot_2019-07-31_at_12.46.41_PM.png

 

You can select multiple photos at once using the Shift key to select a block of photos or using the Ctrl button to select specific photos for uploading.

Tip: Prior to uploading, place all of the photos in a designated folder so they’re easy to find.

Once you’ve selected all of the photos you want to upload, click on the Open button and the photos will begin to upload.   You can monitor the uploading process by watching the progress bars.  Once all of the photos have been uploaded, thumbnail images of each photo will be presented on the Photos page.

Tip: Make sure that you select at least one photo for every item you plan on uploading.

The photos will remain in a temporary library until you import the Excel template in step 3. Once the products are successfully updated, the images will no longer be available on this page.

Step 2: Download Excel Template

Once all of your product photos are uploaded, you can download the Excel template to fill in your product details. 

 

To fill in the template, you should understand the basic format:

  • The first row of column headings should not be modified.
  • Each row after the column headings corresponds to a single product
  • The image names for your uploaded photos are pre-filled in the column ‘Image 1’
  • If multiple images in the ‘Image 1’ column belong to the same product, move them into one row (‘Image 1’, ‘Image 2’, ‘Image 3’, etc)
  • Fields marked with an * are required

Step 2 screen offers the following downloads:

  • Starter template (ideal for basic products with few specifications)
  • Full template (ideal for products with a full set of specifications)
  • Download list of categories existing on the domain
  • Import guide
  • Starter & Full template examples

Screen_Shot_2019-07-31_at_12.57.27_PM.png

 

Example of a starter template with no variants:

Screen_Shot_2019-07-31_at_12.59.23_PM.png

 

Example of  full template with variants:

Screen_Shot_2019-07-31_at_1.03.36_PM.png

 

Example of  full template without variants:

Screen_Shot_2019-07-31_at_1.06.54_PM.png

 

Variants are buying options that come along with a product. Example: If the product is a shoe, it can come in different colors, sizes and material. Here color, size & material are variant types and values can be blue, yellow for color & 8,10 for size & canvas, cotton for material.

 

 If your product has two buying options/variants, please follow the instructions below:

Screen_Shot_2019-07-31_at_1.19.34_PM.png

  • The “parent” product information should fit on one row.
  • * indicates required field
  • If there are variants enter those variant values in the following rows immediately after the product row (as shown on the image above.

The chart below is a reference guide for the meaning and required format for each column in the template.

Column Description Example Values
PRODUCT SKU*

The product SKU is a unique identifier for a product in your store. You cannot reuse the same SKU number for multiple products.

 

If your product has a buying option, leave this field blank on the buying option (SKU) level.

10001
Product Name*

The name of the product as it will be displayed to customers.

 

If your product has a buying option, leave this field blank on the buying option (SKU) level.

Blue Running Shoes

Category*

The category that this product belongs to. The value entered here must exactly match a category that was setup by the marketplace organizer, and must contain all of the parent categories as part of the value.

Products can belong in more than one category. To associate the product with multiple categories, enter in a second category after the first, but separated with “//” (without the quotes).

To download a full list of available categories, return to the product import tool and look for the link to “Download List of Available Categories and Brands”.

If your product has a buying option, leave this field blank on the buying option (SKU) level.

 

Men||Apparel||Shoes

 

             or

 

                                      Men||Apparel||Shoes//Men

||Footwear||Athletic

Brand*

The brand that this product belongs to. The value entered here must exactly match a brand that you configured in your showroom.

If you have only a single brand, this will be the same as the name of your company. If you have multiple brands, you must set them up ahead of time to reference them. To download a full list of brands that you setup, return to the product import tool and look for the link to “Download List of Available Categories and Brands”.

If your product has a buying option, leave this field blank on the buying option (SKU) level.

Nike 
Collection

A product can be assigned to a specific collection. Please create a collection first

 

If your product has a buying option, leave this field blank on the buying option (SKU) level.

Any existing collection name from your online shop

Description*

A longer description of your product – this could be a few words to a few sentences.

If your product has a buying option, you can specify a different description than the one associated with the parent product. If you do not specify a description, the buying option (SKU) will inherit the description from the parent product.

Description of your product.

Example: High fashion                             shoes....

 

Minimum order If you want to enforce a minimum order quantity for this specific product, you need enter "Y" for "Yes" or "N" for "No".              Y or N
Minimum order (per variant if yes)

This is the minimum quantity of each variant of this specific product that the buyer must order. A variant is defined as one complete combination of the product (size, size + color).

Example: You set the minimum for each variant of this product at 7. Buyers must buy at least 7 of each variant: 7 blue, 7 red, and so on.

 

            7          
Variant name1 - 3

If your product does not have variants, ignore this column.

If your product has variants, on the rows immediately below the parent product row, enter values.  Please make sure that you enter all the variant values. For example, if you have 3 variant columns (Color, Size & Material) and your product has 2 variant combinations (Blue, S, Cotton & Red, M, Silk) , make sure to enter the values as per the full template with variant examples given above.

           Color
Immediate A product that is “available immediately” is displayed to customers as being available to ship immediately and will be displayed as public.             Y or N
Pre-order A product that can be ordered but will be delivered between a specific time frame.             Y or N
Stock The stock you have on hand for this product. This number will be decremented as buyers buy your product.            1000
 Shipping start date  This is the shipping start date for your product. 08/10/2019
 Shipping end date  This is the shipping end date for your product. 10/10/2019
Price

The standard wholesale price for this product.

 

If your product has a buying option, you can specify a different price than the one associated with the parent product. If you do not specify a price, the buying option (SKU) will inherit the price from the parent product.

                  100
MSRP

The standard MSRP for this product.

If your product has a buying option, you can specify a different MSRP than the one associated with the parent product. If you do not specify an MSRP, the buying option (SKU) will inherit the MSRP from the parent product.

                  110 
Image1-10

The image columns should contain the name of an image file that you uploaded. If the image file name does not match any images you uploaded, it will be ignored. Each product can have up to ten images. You must include the file extension (e.g. .jpg) in this field.

*Products with no images will be saved, but will not be published until you add at least one image.

If your product has a buying option, you can specify a different image than the one associated with the parent product. If you do not specify an image, the buying option (SKU) will inherit the pictures from the parent product.

blue-running-shoes.jpg 

 Additional Attributes  Any columns after the image columns and buying option columns are additional fields that the marketplace operator has set up. You can enter any descriptive text in these additional columns.

Example

column header:  Country of origin

Example

value: Vietnam

NOTE: If you have variants and you are specifying a different value for  some of them, it is a good idea to specify the value for each of them. Example : If for some variants you are specifying a different price from product price, it is recommended that you enter the price for each of the variants at row level.

 Upload File:


Once you have filled in the Excel template and saved it on your computer, you will start the import process by uploading this file.  Click on choose file and select the file you want to upload. Click 'Upload'.

When the import is complete, you will see a summary of how many products were successfully imported and whether there were any rows in the template with errors.

Screen_Shot_2019-08-05_at_1.04.22_PM.png

 

 

 

Product rows that have errors are not uploaded. Warnings can be ignored. The error description with row number will be displayed so that seller knows exactly where to look for the error. Clicking on 'Acknowledge' button, allows the seller to upload the corrected file again.

If there are any errors, you can download the list by clicking on 'DOWNLOAD LIST' button & make any necessary corrections to the Excel template and import it again. You do not have to import the product photos again. 

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments