Bulk Update Products Overview

Bulk Update Tutorial

To upload multiple new products or update multiple existing products at one time, use the Bulk Update Products feature. Navigate to Inventory > Bulk Update Products. On this page you can create and upload a bulk update template file to which you will add products and attributes that to update or create. 

If you want to build your own template with only the fields you want to update please refer to the Custom Export option.

  1. The file must have the ProductID (SKU) or UPC as the first column. Make your selection by checking the appropriate check boxes.
    Please Note: While existing products can be updated with the UPC, new products can only be created with a SKU as the first cloumn.
  2. If you are creating a new product check the Create new product if none exists checkbox.
    Note: Minimum Required Columns for creating a new product are: ProductID, ProductName.
  3. Click Get Template File to open the template generator window.
  4. Select a file format from the drop down - tab delimited, CSV, or Excel.
  5. Select column headers you want to update from the drop down menu and click Add To List. Repeat until you have all the properties you need. 
  6. Click Download Template.

Note: When adding new products, vendors and manufacturers that are not in the system can be created as well by selecting those actions from the drop down.
Note: Inventory levels cannot be set or updated through Bulk Update. To update inventory use the Warehouse Inventory Import tool. 

Below is a sample file template (Excel Format): 

After entering the products and information, select the template using the Choose File button on the Bulk Update Product page. Select a format type and click submit. After the upload is complete, a log is generated to show which changes were applied successfully.

Schedule a Bulk Update

Bulk update can be scheduled. This can be helpful to schedule heavy jobs for off hours for efficiency. Click on the Schedule Bulk Update checkbox to reveal a date and time scheduler.

Product Name in Bulk Update

Most of the export options available in SellerCloud normally include the ProductID and ProductName columns. The ProductID is mandatory when bulk updating products, while the ProductName is added to make it more clear which products you are updating. The client setting Ignore ProductName column in Bulk update for Existing Products controls if the ProductName updates when there are any changes in the imported file for this column.

Read the sub-page for an explanation of the column headers:

Bulk Update Products

Bulk update and custom export column headers

How did we do?