# Update prices in bulk and set up discounts

> Change one price or thousands with Update Price, and create automatic discounts by product, brand, category, location and dates for the POS and website.

Source: https://docs.smartposhub.com/catalog/prices-and-discounts/  
Last updated: 2026-10-30  
Product: SmartPOS Hub (https://smartposhub.com)

This page explains how to set and change selling prices, one by one or in bulk with a spreadsheet, and how to run automatic discounts such as "10 % off fresh fruit this weekend" in the POS and on your website. For different price lists per customer type, see [Selling price groups](https://docs.smartposhub.com/catalog/price-groups/).

## Change one product's price

Open the product (**Products › List Products › Actions › Edit**), go to **Pricing** (or **Variations & pricing**), change the purchase price, margin or **Default Selling Price**, and click **Update**. See [Add a product](https://docs.smartposhub.com/catalog/add-products/).

## Change many prices with Update Price

1. Open **Products › Update Price**.
2. **Step 1 – Export prices**: click **Export product prices**. You get a file with every product, its SKU and its current prices, plus a column for each active selling price group.
3. **Step 2 – Edit prices**: change the selling price (including tax) and any group prices. Do not change any product name, SKU or headers. Leave a price-group cell empty to keep its current price.
4. **Step 3 – Upload**: drag the file onto the upload area and click **Import file**.
5. **Step 4 – Review & import**: every row is checked first. If one row has a problem, nothing is saved and you see the row to fix.

![Update Price page with steps Export prices, Edit prices, Upload and Review & import, the Export product prices button, the warning Do not change any product name, sku & headers, and the upload area](https://docs.smartposhub.com/_astro/update-price.Crj4yWa9.png) (web app page: `/update-product-price`)
*Export, edit, upload: the fastest way to reprice after a supplier price change.*

**Tip:** 
After a [Product Library](https://docs.smartposhub.com/catalog/product-library/) import every price starts at 0. Export, fill the selling prices in the spreadsheet and import them back in one go.

## Automatic discounts

Discounts live in **Sell › Discounts**. It is the one place for every offer: a discount here applies automatically in the POS and, if you choose, on your website, where the old price is shown crossed out.

![Discounts page listing Accessory Bundle Week 15%, Ramadan Pantry Saver 8% and Weekend Fresh Fruit Deal 10% with start and end dates, priority and category, plus Add Discount and Deactivate Selected](https://docs.smartposhub.com/_astro/discounts-list.DW0PFMuI.png) (web app page: `/discount`)
*Active and scheduled discounts with dates, amount, priority and what they apply to.*

### Create a discount

1. Open **Sell › Discounts** and click **Add Discount**.
2. Type a **Name** customers and staff will recognise, for example "Weekend Fresh Fruit Deal".
3. Choose what it applies to: specific **Products**, or a **Brand** and/or **Category**.
4. Pick the **Location** where it runs.
5. Set the **Priority** (higher wins when two discounts match).
6. Choose the **Discount Type** (fixed amount or percentage) and the **Discount Amount**.
7. Set **Starts At** and **Ends At**.
8. In **Where it applies**, choose **POS and website**, **POS only (in store)** or **Website only (online store)**.
9. Optionally limit it to a **Selling Price Group**, or tick **Apply in customer groups**.
10. Keep **Is active** ticked and click **Save**.

![Add Discount window with Name, Products, Brand, Category, Location, Priority, Discount Type, Discount Amount, Starts At, Ends At, Where it applies set to POS and website, Selling Price Group All, Apply in customer groups and Is active](https://docs.smartposhub.com/_astro/discount-add-modal.CtdeqfyN.png) (web app page: `/discount`)
*Add Discount: what, where, how much, when, and on which channel.*

To stop a discount early, edit it and untick **Is active**, or tick several in the list and click **Deactivate Selected**.

## Other ways to give a lower price

| Need | Use |
|---|---|
| A different price list for wholesale, staff or corporate customers | [Selling price groups](https://docs.smartposhub.com/catalog/price-groups/) |
| An automatic % for a group of customers | **Customers › Customer Groups** – see [Customer groups](https://docs.smartposhub.com/customers/customer-groups/) |
| A one-off discount on a single sale | The discount field in the POS, limited by the user's maximum discount – see [POS overview](https://docs.smartposhub.com/selling/pos-overview/) |
| A manufacturer's list price shown crossed out on the website | The RRP / list price option in the product's Online store card |

## Related pages

  - [Selling price groups](https://docs.smartposhub.com/catalog/price-groups/) — Wholesale, staff and other price lists.
  - [Import products from Excel](https://docs.smartposhub.com/catalog/import-products-excel/) — Prices for new products.
  - [POS overview](https://docs.smartposhub.com/selling/pos-overview/) — Discounts at the till.
  - [Online store](https://docs.smartposhub.com/online/online-store/) — Prices and offers on your website.

## Frequently asked questions

### How do I change the price of many products at once?

Open Products › Update Price, click Export product prices, edit the selling prices in the file without changing names, SKUs or headers, and upload it with Import file.

### Do discounts apply automatically at the till?

Yes. An active discount applies by itself to matching products in the POS during its dates and in the chosen location. You can choose POS only, Website only, or POS and website.

### What if two discounts match the same product?

The discount with the higher Priority wins. Priority is not considered when a discount names the exact product.

### Can a discount be only for wholesale or member customers?

Yes. Pick a Selling Price Group on the discount, or tick Apply in customer groups so it also applies to customers in a customer group.

### Can cashiers give their own discount?

Yes, if their role allows it, cashiers can add a line or order discount at the POS, up to the maximum discount set on their user. Automatic discounts are set here.

### Where do I set the crossed-out price on my website?

You don't need to. While a discount runs on the website, the old price is shown crossed out automatically.