Adding sale prices through CSV
You can set sale prices in percentage or absolute value on particular products or on all catalog in your store. Products on sale will have the original price struck out, and the lower price will be shown as the main one. The product image will also get the "ON SALE" label.
If you have many products in your store, you can use CSV import to quickly update prices in bulk. 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:
- From your Ecwid admin, go to Catalog → Products.
- 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.
- 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:
- Click Download CSV file.
Step 2 — Edit prices in CSV file
To add your sale prices to the downloaded CVS file:
- 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:
Please note that separator type in the spreadsheet editor should be equal to one in your Ecwid store. In the example above it’s the semicolon. So when you import your data to Google Sheets make sure to choose settings that are right for you:
- 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.
- Save the file in the CSV format.
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:
To import CSV to your Ecwid store:
- Go to Catalog → Products and click Import Products.
- 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:
- Select the delimiter that you’ve used in the exported CSV file (it is semicolon by default).
- Remember to uncheck the Delete all products/categories before import checkbox at the bottom of the window.
- Choose the edited CSV file from your computer.
- Click on the Import button.
After the import is complete, prices in your store will be updated automatically.