Sale prices for products

You can manually set sale prices in percentage or absolute value on individual products in your store.

When you put a product on sale for a lower price, that value will override the default price. So the original price will be shown struck out, and the product image gets the label "ON SALE".


Setting a ”Compare to” price

To show a sale price in your online store, your product details need to include a sale price and the original price, called the "Compare to" price.

To set up a sale price:

  1. From Ecwid admin, go to Catalog → Products.
  2. Open the product you want to edit.
  3. Click Manage pricing options next to the price.
  4. Add the "Compare to" price. This price must be higher than the actual price you sell for:

Add the Compare to price

  1. Save the changes.

And here how it looks on the product page:

Sale price in the product page

You can change the color of the ON SALE label to any color of your choice with the help of CSS code. See Change the color of "On sale" tag in the Ecwid CSS Cookbook.

Customizing sale prices

You can set the display options and rename "compare to" phrase:

  1. From your Ecwid admin, go to Settings → General → Cart & Checkout.
  2. Scroll down to the "Compare to" price section.
  3. Make the necessary changes.

Sale price settings

To change the "On sale" text:

  1. From Ecwid admin, go to Settings → Edit Store Labels.
  2. Type "On sale" in the search field.
  3. In the found labels, type the text that you want to show instead of "On sale". Changes are saved automatically:


Adding or updating sale prices in bulk

To offer the storewide discounts, for example if you want to run a Holiday sale, you can add sale prices in bulk in two ways: with the help of the Bulk Product Editor or by importing a CSV file.

Adding sale prices through the Bulk Product Editor

You can apply discounts to your products in bulk using the Bulk Product Editor tool right in your Ecwid admin.

First, you will need to select the products that you want to update prices for.

To select products for 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:


  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 prices for all the selected products.

Second, you will need to enter sale prices and original prices for your products.

To enter new prices for the selected products:

  1. On the Bulk Product Editor page, click the Price cell in the row of the product and enter the sale price.
  2. Click the "Compare at" price cell in the row of this product and enter the old price before sale.
  3. Click Save.

That’s it! Now prices for selected products in your catalog are updated and your customers will see sale prices in your online shop.

Adding sale prices through CSV import

To add (or edit) sale prices in your Ecwid store via CSV file, you need to download a file with your product data from your store, make changes to it using a text editor or a spreadsheet, and then import the file back into your store.

Step 1 — Export products to CSV file

To get the file with your product data from your store:

  1. From your Ecwid admin, go to Catalog → Products.
  2. If you want to change sale prices for all products, click Export All below your product list.
    If you need to edit prices for particular products, you can select them in the list and then click Export Selected.
  3. Select columns for export. Product name, SKU, Price and “Compare to” price will suffice, but you can choose other columns as well if you need them:


  4. Click Download CSV file.
The file will be exported with the semicolon delimiter unless you pick another delimiter (comma or tab) in the export dialog.

Step 2 — Edit prices in CSV file

To add your sale prices to the downloaded CVS file:

  1. Open the downloaded file in a plain text editor or in a spreadsheet. Use the same delimiter that you’ve used for export.

Here’s how the same data looks like in different editors after you open your CSV file in them:


If there are SKU in your store that start with zero, they may be truncated in your spreadsheet (e.g. '0005' becomes '5' when considered a number). This may cause some issues during import, like duplication of store products.To avoid that make sure to use ‘text’ format for your data instead of ‘numbers’ format.
  1. Add your sale prices. The "recommended_price" column in the editor is equal to the “compare to price” in your Ecwid store. So you need to move your old bigger prices to the “recommended_price” column and add your sale prices to the "price" column. You can do it manually, for example, by cutting and pasting all the prices from one column to another. Or you can simply rename the "price" column to "recommended_price" and "recommended_price" to "price", then add new sale prices under the "price" column.

    You can use formulas to calculate the discount. For example, you want to offer your customers 20% off all the current prices. If you are on Google Sheets, simply put the cursor to the cell where you want the new price to appear. Type “=” and then click on the cell with the current price for the item. Type “*” symbol for multiplying and then type 0.8 (to get 20% off the number) and click Enter. You’ll automatically get the new price with 20% off:


    Point your mouse to the lower right corner of the formula cell. The pointer changes into a fill handle (black plus symbol) that you can drag to the last row of the sheet. The fill handle will copy down the formulas to all the adjacent cells.
  2. Save the file in the CSV format.
To easily change all the prices in your store at once, you can keep both CSV files — one with original prices and one with sale prices. Use the file with lower prices during Holiday seasons and after it’s over import back the CSV file with original prices. Keep the “Holiday CSV” to use it any time you need.

Step 3 — Import CSV file into Ecwid store

Now you can upload your edited CSV file back to your Ecwid store to add sale prices to the products in your storefront:

  1. Go to Catalog → Products and click Import Products.
  2. Select the columns that you are going to import — Name, SKU, Price, “Compare to” price and uncheck the unnecessary columns. Important: the column order must be the same as in the CSV file, please re-arrange them if needed. You can drag-and-drop the list items:


  3. Select the delimiter that you’ve used in the exported CSV file (it is semicolon by default).
  4. Remember to uncheck the Delete all products/categories before import checkbox at the bottom of the window.
  5. Choose the edited CSV file from your computer.
  6. Click on the Import button.

After the import is complete, prices in your store will be updated automatically.

Was this article helpful?

Awesome! Thanks for your feedback!

Thanks for your feedback!

Sorry about that! What went wrong?
66 out of 105 found this helpful
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