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

Use the All Products single sheet when you want to quickly update existing products and variants in bulk using one spreadsheet. This format is helpful if you prefer to work in a single table or use your own formulas and macros.

For the multi sheet workflow, see How to manage products and variants in bulk (multi sheet).

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 an All Products spreadsheet.
2. Open the spreadsheet on your local device.
3. Update the spreadsheet.
4. Upload the updated spreadsheet.

Generate an All Products 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:
   1. Multi Sheet: Separate sheet per category. Learn more. 
   2. Single Sheet: All products in one sheet. This is the setting we want for our current workflow.
      
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.
   

Update the spreadsheet

The single sheet workbook contains three sheets.

• Usage Guide: Explains how the workbook works and links back to the bulk manage products article in the Help Center.
• All Products: Lists all exported products and variants in one table.

  • You can sort, filter, and search across all products at once.

  • Category and option fields are included as columns, but there are no dropdown menus.

  • Column headers that are bold and marked with a red asterisk (for example Brand *) are mandatory fields and must have values when you upload the file.

• Data: Locked and contains reference data such as category names and option values. Use it to check valid values if you are unsure about spelling or naming. You do not edit this sheet.

Update existing products in the All Products sheet

1. Go to the All Products sheet and use filters or search to find the products you want to update.

2. Edit the cells for the fields you want to change, such as prices, stock levels, SKUs, external IDs, or visibility, keeping other fields unchanged.

3. Enter values carefully for categories, option names, and option values, and match the exact naming used in your marketplace because there are no per cell dropdowns.

4. Make sure all mandatory fields remain populated for the rows you are updating, because clearing a required value will cause an error during upload.

5. Leave cells blank if you do not want to change those values; empty cells are ignored during upload and do not overwrite existing data.

6. If you need to clear a value in the system, enter DELETE_VALUE in the cell so the upload removes the stored value.

Add new products and variants in the All Products sheet

You can create new products in the All Products sheet, but for larger new ranges or more complex option setups it is usually easier to use the multi sheet spreadsheet.

1. In the All Products sheet, go to a blank row at the bottom of the table.

2. In the Ad ID column, enter new to mark the row as a new product.

3. Enter values for all mandatory fields and any optional fields you require for that product.

4. To create variants for the same product, add additional rows directly under the new product row and enter variant in the Ad ID column for each variant row.

5. Complete the variant specific fields, such as size or colour, for each variant.

The values new and variant are case sensitive.

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.