Bulk Product Editor

You can use Ecwid’s Bulk Product Editor to mass update products in your online store. This tool allows you to edit multiple product properties, including name, SKU, images, price, stock, shipping settings, and more. You can also edit product variations with it.

Bulk Product Editor is available from the Catalog → Products page in your Ecwid admin. It’s also possible to instantly enable, disable, or delete selected products, to change prices and to assign/remove categories in bulk on this page.

Choosing products for mass update

You can edit the following product properties using Bulk Product Editor:

Before entering the Bulk Product Editor, you need to choose which products you want to update. You can either mass update all the products in your Ecwid store or select several items.

It’s possible to update no more than 100 products at a time.

To choose all the products for mass update:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Click Bulk Update:

    Bulk_Product_Editor__2_.png

  3. In the dropdown menu, choose Edit All.

After you do that, you will be redirected to the Bulk Product Editor page, where you can edit properties for all the products in your store.

To choose several products for mass update:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Tick the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).
  3. Click Bulk Update:

    Bulk_Product_Editor__1_.png

  4. In the dropdown menu, choose Edit Selected.

After you do that, you will be redirected to the Bulk Product Editor page, where you can edit properties for all the selected products.

Editing product properties

Once you select products for editing and proceed to the Bulk Product Editor page, you will see these products (as well as their variations) listed in a table. Products are table rows, and product properties are table columns:

Bulk_Product_Editor__3_.png

Tick the properties you want to edit in the Columns menu on the left to add the corresponding columns to the table and untick the ones you don’t need to make the table easier to manage. You can deselect all the columns except for the column with product images.

To edit a property for a particular product/product variation:

  1. Click on the cell of this property in the row of the product/product variation.
  2. Make the necessary changes.
  3. Click Save.

The products that you have edited will be marked by a dot until you save the changes:

Bulk_Product_Editor__4_.png

You can change the properties that are not yet available in the Bulk Product Editor when you edit products one by one on their product detail pages in Catalog → ProductsEdit Product.

Tips and shortcuts

You can edit the cells that have a white background in the table. Cells with a grey background are not available for editing.

Click the column name to sort products based on this property.

By default, the Columns menu is expanded, but you can always collapse it by clicking the Columns button to have more space to edit your products. You can unfold the menu back at any time.

To navigate the table, you can either click on the cell that you need with a cursor or use your keyboard:

  • Press Tab to select a cell and switch into keyboard navigation mode.
  • Use arrow keys (→, ←, ↑ or ↓) to move to the next/previous cell in the row/column (available after pressing Tab).
  • Press Enter to enter changes into the cell and move to the next cell in the column. You can also press Enter to start editing the selected cell.
  • Press Esc to discard the ongoing changes in the cell.
  • Press Spacebar to put a tick in the cell/to untick it.

Instantly updating product accessibility

You can also quickly enable, disable, or delete selected products even without entering the Bulk Product Editor. For example, if you want to temporarily hide a seasonable category or you stop selling some product line forever and need to delete the items.

To instantly update selected products:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Tick all the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).
  3. Click Bulk Update:

    Bulk_Product_Editor__1_.png

  4. In the dropdown menu, choose Enable or Disable → Enable Selected, Enable or Disable → Disable Selected or Delete Selected.
  5. If you chose Delete Selected, click Yes in the popup.

The changes will be saved automatically.

On the Catalog → Products page, you can also add, update or remove ribbons in bulk for the selected products.

Changing prices in bulk

You can easily increase or reduce prices for several products at once by a fixed value or by a percentage of the current price. For example, if you run a storewide sale or you need to raise prices a little to cover your expenses.

To change product prices:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Tick all the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).
  3. Depending on your case, click Bulk Update → Change Prices → Increase Prices for Selected or Bulk Update → Change Prices → Reduce Prices for Selected.
  4. In the dropdown menu, choose whether you want to change the price by a percentage or by an absolute value:

    Changing_prices_in_bulk.png

  5. If you choose to change the price by a percentage, click Select a rounding method to choose how your prices will be rounded after recalculation. By default, they are rounded up to the nearest dollar (or any other currency you use in your store).
  6. Enter the price change value.
  7. Click Apply.

The changes will be saved automatically.

If you’re running a sale, you can also add ribbons (e.g., “15% Off”) to the products to notify customers about the lowering of the price.

Assigning and removing categories in bulk

You can instantly assign and remove categories in bulk for selected products. For example, if you want to create a new system of categories in your store.

You need to create at least one category in your store (on top of the default Store front page category) before it becomes possible to assign or remove categories.

To assign or remove categories in bulk:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Tick all the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).
  3. Click Bulk Update → Assign or Remove Categories.
  4. Tick or untick the categories in the list:
    Bulk_Product_Editor__5_.png
  5. Click Apply.

The changes will be saved automatically. The categories will be assigned to/removed from all the selected products.

More options with the app

If you want to edit more properties for several products at once, you can enhance your store with the Bulk Product Editor app from the Ecwid App Market. With the help of this app, you can also:

  • Add downloadable files
  • Change prices for products by % or by a fixed sum
  • Create bulk discounts
  • Add, remove and rename options and choices for them (with or without price modifiers)
  • Add/change product types
  • Manage product attributes
  • Generate, update and delete product variations
  • Add/remove related products
  • Delete all gallery images and delete all downloadable files for selected products
  • Replace texts (e.g., product names and descriptions)
  • ...And more
Ecwid’s built-in import tool will help you bulk update even more product properties (shipping settings, subtitles, and more) via CSV files.
Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
10 out of 15 found this helpful
10
We use cookies and similar technologies to remember your preferences, measure effectiveness of our campaigns, and analyze depersonalized data to improve performance of our site. By choosing «Accept», you consent to the use of cookies.
Accept cookies Decline