Bulk Update Products

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 a products and attributes that are being updated or created. 

  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 product and information, select the template 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.
  
Read the sub-page for an explanation of the column headers.