How to manage products and variants in bulk (multi sheet)

You can update multiple products at once by downloading a bulk upload spreadsheet in Bulk Manage Products. The spreadsheet is generated based on your existing categories and includes the fields and dropdowns you need to complete. This makes it easier to change product details in bulk while keeping your data accurate.

You can choose between a multi-sheet spreadsheet and an single sheet when you download the manage product spreadsheet.

Multi Sheet vs Single Sheet

Use Single Sheet when you want to:

• Update prices, stock levels, SKUs, external IDs, or visibility for many products at once.

• Work with all products and variants in one table.

• Filter, sort, and run formulas across the full range.

Use Multi Sheet when you want to:

• Create a new range of products in specific categories.

• Configure option types per category using dropdowns.

• Work in separate sheets per category instead of one large table.

Workflow overview

These are the general steps to bulk update products. Learn more here about bulk creating products.

1. Generate a Manage product spreadsheet.
2. Open the spreadsheet on your local device.
3. Update the spreadsheet.
4. Upload the updated spreadsheet.

Generate a Manage product spreadsheet

1. In the Seller Portal, go to Products > Bulk Manage Products.
   
2. Select Manage product information.
   
3. Click the Download button.
   
4. In the Manage product information window, choose how you want to generate the spreadsheet:
   • Multi Sheet: Separate sheet per category. This is the setting we want for our current workflow.
   • Single Sheet: All products in one sheet. Learn more.
     
5. Select the product information you want included in the spreadsheet. Learn more.
6. Click Download at the lower right.
7. Track the file in the Recent imports & exports table, where all current and previous files appear.
8. Select the filename to download.
   

After downloading the file, you can update the spreadsheet on your local device.

Update the spreadsheet

If you selected the Single Sheet sheet style, your workbook layout will be different from the multi sheet version described in this section. For that workflow, see How to manage products and variants in bulk (single sheet).

Use the generated spreadsheet to bulk edit information, add new images, delete optional values, or assign products to a category.

The spreadsheet has four key sections:

• Usage Guide sheet: Offers instructions on how to use the file. It also includes a "table of contents" listing all the dynamically generated category sheets.
• Missing Category sheet: Allows you to assign uncategorized products to the correct categories. This step is optional and can be completed now or later.
• Category sheets: Correspond to specific product categories and allow sellers to input details for their products.
• Data sheet: A locked sheet containing reference data for consistent inputs. No action is required here.

How to edit existing products and variants

Category sheets are named after your existing categories. In this article, we refer to them generically as “category sheets.”

For example, if you have any products assigned to a category, say — Womens > Boots > Ankle boots — then the generated spreadsheet will have a sheet titled womens-boots-ankleboots.

For this example, we’ll add products using a spreadsheet generated with only the required fields (Step 4, Generate a Manage product spreadsheet).

1. Find the product.
   • Select the category sheet you want to add a new product to.
     
   • Find the product row using the Ad ID column.
     
2. Edit the necessary fields.
   • Update only the fields that need modification.
   • Do not change system-generated fields such as the Category number and Category hierarchy.
     
   • Delete optional values.

3. Use dropdown options.
   • Select predefined values from dropdown menus for fields like Brand.

   • Dropdowns pull values from the Data sheet for accuracy.
     

     Tip: For multi-select columns, hover over the column header to view all allowed values and enter multiple values in a cell separated by | (pipe).
     
4. Manually input additional data.
   • For fields without dropdowns, type the required details (e.g., SKU, Product Description).
   • Check for typos or formatting errors before saving.
   • Add images.
5. Save your file.

How to add images

1. In the spreadsheet, go to the Image 1* column and enter a public URL for at least one product image.
2. (Optional) Add more images in the Alt Image 2–20 columns.

3. Make sure all image URLs are public. Thumbnails or non-public links are not supported.

   Note: Image links from Google Drive and Dropbox are supported.
4. Save your file. 

How to delete optional values

Use the keyword DELETE_VALUE in a generated spreadsheet to remove existing values from optional fields. This makes it easier to clear data in bulk without editing each product one by one.

1. In the spreadsheet, go to the optional field you want to clear (for example: Additional Colour) and type DELETE_VALUE in the cell.
   • The keyword is case-sensitive.
   • Deleted values cannot be restored.
2. Do not use DELETE_VALUE in mandatory fields (for example: Title, Description, Price).
   • If used, the system blocks the upload with an error.
3. If you leave a cell blank, nothing changes.

How to assign products to a category

1. In the spreadsheet, go to Missing Category.
   
2. Use the dropdown to assign a brand (required).
   
3. Use the dropdown to assign a category (required).
   
4. Save your file and upload the updated spreadsheet.

Upload the updated spreadsheet

1. In the Seller Portal, go to Products > Bulk Manage Products.
   
2. Select Manage product information.
   
3. In the Manage product information page, select Upload spreadsheet.
   
4. Select the updated spreadsheet in your local device.
5. Wait for the system to validate the upload. Fix errors and re-upload if necessary.