Searching...

Bulk Update Products


Overview

The Bulk Update feature allows you to update product information using a file upload so that you can update multiple products simultaneously.

Certain product updates cannot be executed through the Bulk Update tool. For example, inventory levels cannot be set or updated through the Bulk Update tool but through the Import Inventory Info function. The same goes for updating product attributes, images, etc., which can be done via Import Product Information instead.

Check out this short tutorial on creating new products or updating existing ones using the Bulk Update tool in Sellercloud’s new interface:

Update Products in Bulk

  1. Go to Catalog > Tools > Import Product Info > Bulk Product Update.
  2. Click on Generate Template to create a new template or use a saved one. To create a new one, select Create New Template > Choose Format > Add Columns to Template.
    1. Templates can be saved for future use. At this stage, you can also Choose Existing Template. On the next page, you will be able to add or remove columns. Check Save Template to overwrite it.
  3. If you are creating a new product, check the Create Products That Don’t Exist box.
    If you create a new template, the file will have the ProductID (SKU) as the first column by default. Users can update existing products with their UPC as the first column, but must also include the ProductName, which is used to clarify the products you are updating.
  4. Add columns to update. Show me the definitions of these column headers. At minimum, you must create ProductID and ProductName columns.
  5. Click Download Template. Below is a sample template downloaded as an Excel file:
    sellercloud alpha excel template file example
  6. After entering the necessary information, save the template, and Upload it in Sellercloud.
  7. A queued job will be generated. You can schedule a bulk update for off-hours, which is convenient and efficient for large jobs. Click the Schedule For Later checkbox to see a date and time scheduler.bulk update products delta

Bulk Update Log

The Bulk Update Product Log option records changes to product attributes that are updated with a file import. It allows you to view the status of your job and of each individual product in that job. It also displays errors. For example, if a column header was entered incorrectly, an error message will display Column does not exist.

Access the Bulk Update Log

The bulk update log can be accessed by following the steps below:

  1. After executing a bulk update, a queued job notification will appear. Click on it.
  2. Alternatively, you can go to Queued Jobs > Search for scheduled jobs. Press a Job ID to view details > Toolbox > Bulk Update Log.bulk update log

Overview

The Bulk Update feature allows you to update product information using a file upload, so that you can update multiple new or existing products simultaneously.

Certain functions cannot be executed through Bulk Update. For example, inventory levels cannot be set or updated through Bulk Update but through the Warehouse Inventory Import tool. The same goes for updating product attributes, images, etc., which can be done via Import Product Info instead.
You can save templates for future use. If you want to overwrite an existing template, select it from the Dropdown, adjust the columns, and check Overwrite Template before saving.

Check out this short tutorial on creating new or updating existing products using the Bulk Update feature in Sellercloud’s Alpha interface:

Tagged:

Was this article helpful?

Yes No
Need Support?
Can't find the answer you're looking for?
Contact Support