Update products in bulk using the Legacy Bulk Product Uploader

Bulk update products using the Legacy Bulk Product Uploader

To edit multiple products, you can download the list as CSV or XLS, edit product details, and upload the file back to the seller portal. You can also edit product details manually. 

There are currently two locations where you can download a product list: Bulk Upload Products and Manage Products.

Download a product list from Bulk Upload Products

1. Go to the Products menu and select Bulk upload products. 

2. Click Generate under the file format you prefer. You can select between these export files to generate:

   • Existing products: Contains your existing products with their details and any errors.
   • Products with errors: Contains only your products with errors.
3. Follow the displayed link or go to Imports & exports to access the file.
4. Locate your download in the list.
5. Once the file is generated, select the file name to download the file. 

Download a product list from Manage Products

You can export with or without filters.

1. Go to Products > Manage Products.
2. Select the Show Filters button. Narrow down your search using different filter options and select Search. Select Export results in the bottom left of the filter panel.
   
3. In the Export Product Data window, select from the following options:
   • File format: CSV or XLSX.
   • Type of product data to export: All product data or only product/variant data with errors.
   • Customize columns: Choose which data to include from multiple selections.
4. Select Export spreadsheet.
5. Click the generated link in the notification or go to Imports & Exports from the side nav.
6. Once the file is generated, select the file name to download the file.

Edit products in bulk

1. After you download the selected export file, open the CSV or XLS in a spreadsheet program.
   See About the bulk product upload spreadsheet for information on the columns and data requirements for the spreadsheet.

2. Edit the product details you want to update or correct. 

3. Upload the updated products list back to the Seller portal.

Delete products in bulk

1. After downloading the selected export file, open the CSV or XLS file in Excel and remove any products you want to delete.
2. Upload the updated file. Follow the steps in the Upload the product changes in bulk section.
3. Before uploading back the file, ensure to select the Tick if you would like to remove all products and variants from your account which are not included in the uploaded CSV file checkbox.

Upload the product changes in bulk

1. Go to the Products menu and select Bulk upload products.
2. Select Upload Spreadsheet.
3. Select the CSV or XLS file you want to upload.
4. Select Open. 

5. Above the Upload button, there's a checkbox to delete all your current products and replace them with the uploaded file's contents. You might do this, for example, if you have made a lot of changes.

   Important: Only enable this option if you want to replace all your existing products in the marketplace.
6. Select Upload to complete the upload. Once the upload is complete, your product list is updated.

Checking import status after bulk upload

When the import is completed, the Seller Portal and Operator Portal display feedback on import errors, which includes catalog rule errors.

1. Sign in to the Operator portal.
2. Go back to Bulk Upload Products and scroll down to Recent Import History.
3. On the Results column, you can view the errors and the Download products with errors, which you can click to download and view the errors in detail.
4. Update the product/detail with errors and re-upload the file.