Changing product details

For every item in your store, you can change prices, images, descriptions, weight or other product details. You can update information about one product or mass update product info for all your catalog.

Updating details for one product

To edit a product:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Click on the product you wish to change.
  3. Update product details.
  4. Save changes.

Saved changes take effect immediately in your online store and sync across all your sales channels.

Updating products in bulk

You can update your product catalog in bulk with:

Bulk Product Editor tool

Ecwid’s Bulk Product Editor tool allows you to edit multiple product properties, including SKU, price, stock, shipping settings, images, and more. You can also edit product variations with it.

To edit products with Bulk Product Editor:

  1. From your Ecwid admin, go to Catalog → Products.
  2. Tick the products you want to update.
  3. Click Bulk Update → Edit Selected. You can also edit all the products in your store by clicking Bulk Update → Edit All.
  4. Make changes and click Save.

Bulk Product Editor app

You can update several products in bulk using the Bulk Product Editor app right in your Ecwid admin.

With the Bulk Product Editor app, you can:

  • Clear image gallery/files
  • Add or remove shipping methods from products
  • Add or remove options/choices for options
  • Add or delete related products

To better understand how the Bulk Product Editor app works, watch this video about changing product details in the Ecwid store with the Bulk Product Editor app.

Export and import

One more way to update several products at once is by using export and import. You can export the products you want to change, edit them in a spreadsheet, and then re-upload them to your store using the import tool.

You will need to follow three steps:

Step 1 — Export the products to a CSV file

  1. From your Ecwid admin, go to Catalog → Products.
  2. Select products that need to be updated. You can use search filters to find the products.
  3. Click Export all selected or Export all depending on whether you want to edit all your products or only some of them.
  4. In the export products popup, mark 'Product name' and 'SKU' columns and the ones you want to edit (e.g., price, product subtitle).
  5. Click Download CSV file and save the resulting file on your computer.

Step 2 — Edit the CSV file in a spreadsheet editor (e.g., Excel or Google Sheets)

Here are some tips to follow while editing:

  • Use tips to quickly edit columns in a spreadsheet. For example, in Google Sheets you can enter the value to the cell and drag it to the whole column.
    You can also apply a formula to change the value in the cell and then drag it so that all values in other cells are changed accordingly. For example, you can add a 10% price markup to all the products — just multiply the whole 'price' column by 1.1. You can check out editing tips for your spreadsheet program on YouTube or refer to your spreadsheet program's documentation for further details on using formulas.
  • Make sure the SKU column in your editor has the 'text' type. Sometimes, spreadsheet editors recognize numeric SKUs as integer numbers and set the 'numeric' format for the SKU column, which results in changing their values. For instance, '0005' becomes '5' when considered a number.
  • This may cause some issues during import, e.g., duplicating of store products. The SKUs in the CSV file must be imported by the spreadsheet editor exactly as you see them in your Ecwid admin.
  • When saving the changed file, you may be prompted to change the format of the file. Proceed with saving to the CSV format, not to the Excel document or Open Document.

Step 3 — Import the edited CSV file back to Ecwid

  1. From your Ecwid admin, go to Catalog → Products.
  2. Click Import products at the top.
  3. In the import settings popup, open the CSV file with the Choose file button.
  4. Select the same delimiter that was used in the exported CSV file.
  5. In the Import columns list, tick the columns that are present in your CSV file.
    The column order must be the same as in the CSV file. Re-arrange them if needed (in order to do it, you should drag-and-drop the list items).
  6. Make sure that the Delete all products/categories before import checkbox at the bottom of the pop-up is unchecked.

Note that you cannot change the SKU for your products using import (it is a key attribute in your catalog), but you can export, edit and then import back all the other attributes/columns. It's better to export only those columns that you want to edit (plus SKU or 'Product name' to identify the product). This way, you will avoid dealing with extra data.

For example, you can export 'Product name', 'SKU', and 'Price' columns and make changes in the 'Product name' and 'Price' fields. After you import back the CSV file with these three columns, the changes will be made only to the name and price of your product. The rest of the product details will remain unchanged.

Example

The Quantity column can be used for updating your store inventory.

To update the number of your products:

  1. Export your products (three columns will be enough: Product name, SKU, Quantity)
  2. Modify the CSV file in your spreadsheet editor (change the product quantities)
  3. Import the file back to your Ecwid store.

The number in the Quantity column will be used to update the quantity of the product with the corresponding SKU or product name. If there is no value in the Quantity column, the Unlimited quantity option will be enabled for the product. Example of a CSV file:

name;sku;quantity
cherry;item132;2
cucumber;item7;
apple;item7635;15

See detailed instructions on importing different product details →

Related articles

Adding product to your store
Deleting products in your store

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
1 out of 2 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