VENDOR BULK UPLOAD PRODUCTS
On the United States Wholesale marketplace, vendors can leverage our bulk-import tool to upload their products in bulk.
This page provides you with a comprehensive guide that walks you through the step-by-step process.
You can visit our Vendor Bulk Upload Variation Products page to bulk upload products with variations.
Alternatively, you can visit our Vendor Custom Onboarding Page if you prefer us to onboard your products for you. By doing so, we will also import all the images from your website and attach them to the products, which can save you a significant amount of time.
Step 1 - Download CSV File
*IMPORTANT NOTE FOR MAC USERS: If you're using a Mac, your file will most likely be opened with the Mac software "Numbers". Once you have finished filling out the spreadsheet, use these steps to make sure that your file will be saved as a .csv file to be compatible with our system.
Use the following steps:
- Click on "File"
- Click on "Export To"
- Click on "CSV"
A window called "Export Your Spreadsheet" will pop up. Do the following:
- Click "Next"
- Click "Export"
Your file is now saved as a .csv file as is ready to be uploaded into our system.
STEP 2 - ADD YOUR PRODUCTS TO THE CSV FILE
The CSV file contains 18 columns that you can fill out for each product.
Some are required. Here are the details for each column:
- SKU – This is the unique identifier for each product.
- Name* – This is the name of the product. (This is a required field)
- Short Description – This is a brief description of the product. You can upload it with the CSV file or add it manually later in your Vendor Dashboard.
- Description – This is the detailed description of the product. You can upload it with the CSV file or add it manually later in your Vendor Dashboard.
- In Stock?* – Enter 1 if the product is in stock and available for purchase, or enter 0 if it is not.
- Stock – If you track inventory, enter the current stock level for the product. If you don’t track inventory, leave this field blank.
- Weight (lbs)** – Enter the weight of the product in pounds. (Please read the note below about weight and dimensions)
- Length (in)** – Enter the length of the product in inches. (Please read the note below about weight and dimensions)
- Width (in)** – Enter the width of the product in inches. (Please read the note below about weight and dimensions)
- Height (in)** – Enter the height of the product in inches. (Please read the note below about weight and dimensions)
- Sale price – If the product is on sale, enter the sale price.
- Regular price* – This is the regular price of the product. (This is a required field)
- Tags – Enter any relevant product tags to help with search functions. You can enter several tags, separated by commas.
- Categories* – Select a category for the product from the List Product Categories Page. (This is a required field)
- Meta: minimum_allowed_quantity – Enter the minimum quantity of the product that can be purchased.
- Meta: maximum_allowed_quantity – Enter the maximum quantity of the product that can be purchased.
- Meta: group_of_quantity – If you want to restrict the product to be sold in groups or bundles, enter the quantity (i.e. 12 for packs of 12, 24, 36, 48, etc.).
(Images have to be entered later, see Step 6)
Alternatively, you can visit our Vendor Custom Onboarding Page if you prefer us to onboard your products for you. By doing so, we will also import all the images from your website and attach them to the products, which can save you a significant amount of time.
* REQUIRED
—–
** IMPORTANT NOTE ON WEIGHT AND DIMENSIONS: Â It is important to enter the correct weight and dimensions of your product for accurate shipping costs. If the information is incorrect, the displayed shipping costs will be wrong and this could discourage buyers from placing an order.
For example:
- If you are listing 50 sunglasses for $100, you should enter the weight and dimensions of the package that contains all 50 sunglasses and not just the weight and dimensions of one pair of sunglasses.
- If you are instead listing the same sunglasses for $2 with a Minimum Order Quantity of 50 pcs, you should enter the weight of one pair of sunglasses and not the weight and dimensions of 50 pairs of sunglasses.
STEP 3 - UPLOAD/IMPORT CSV FILE
To upload/import your completed CSV file, go to the Import CSV File Tool in Vendor Dashboard/Tools.
Click “Choose File” and select the completed CSV file you want to upload. Then click “Continue”
(If this is NOT your first time uploading a CSV file, it is recommended that you check the “Update existing products” tab. This is to avoid duplicate products)
STEP 4 - CONFIRM COLUMN MAPPING
During step 4 you get a preview of what information will get mapped to which columns. (it will only preview 1 product)
If everything looks good, click “RUN IMPORTER” and wait for a few seconds. (It may take up to a minute for larger CSV files)
step 5 - import successful
After the tool has finished importing your CSV file, you will receive a “Import Complete” message. Click “View Products” to go to your products page.
If you received an error message, most likely the CSV file was completed incorrectly. Please double-check your file and try again. If the problem persists, contact us for assistance.
STEP 6 - UPLOAD IMAGES
After your products have been successfully uploaded to your vendor account, you will need to upload images and assign a product category.Â
PRODUCT IMAGES
- Go to one of your products and then click “Upload a product cover image” and upload your main product image (this is the image that will display throughout the website)
- Then click the PLUS sign under the main image and upload the product gallery images.
PRODUCT CATEGORIES
After you have uploaded the product images, assign the correct category to the product.Â
Do this by finding the “Category” drop-down menu while editing the product.
Click on it to open the category popup.
After the drop-down menu has expanded, either scroll or start typing to find the correct product category.
Select the correct category.
After you have added product images, scroll to the bottom of the page and click “SAVE PRODUCT” (wait for a few seconds for it to save)
AND YOU'RE DONE!
That’s it! Your products have now been uploaded using our CSV bulk import tool!
