# Bulk Price Change and Quick Price Edit

Section: Products and prices. Address: https://vende.id/docs/produk-dan-harga/mengubah-banyak-harga?lang=en

Raise the prices of a whole category at once by a percentage, or type many prices in one table like in Excel.

There are two ways to change many prices at once. Both are at the top of the **Master Data → Products** list.

- **Bulk Price Change**: raise or lower the selling prices of many products by a percentage or an amount.
- **Quick Price Edit**: type prices one by one in one table, for every unit and customer group.

## Bulk Price Change

1. Open **Master Data → Products**, then press **Bulk Price Change**.
2. Under **Products**, choose **All products**, **One category** or **One brand**.
3. When the shop has several branches, choose **Branch**. Leave it empty to change the selling price for every branch.
4. Choose **Direction**: **Raise** or **Lower**.
5. Choose **Method**: **Percentage (%)** or **Amount (Rp)**, then fill in **Change By**.
6. Choose **Rounding** if needed, for example **Round to Rp 500**. Prices are rounded up when raised and down when lowered.
7. Leave **Move prices of other units along** on when the prices of other units, such as a box, should move too. Percent raises every unit by the same percent. Amount raises every unit by the amount times its size: Rp 250 per piece means Rp 2.500 per box of 10. Rounding applies per unit.
8. Leave **Move group prices along** on when the group prices, quantity prices and branch prices of that unit should move too.
9. Press **Next**. In the **Preview** step, check the old and new price of each unit, and the warnings.
10. Press **Save New Prices**.

Example: the Drinks category goes up 10%, rounded to Rp 500. A price of Rp 4.300 becomes Rp 4.730, then is rounded up to Rp 5.000.

Things to know:

- A unit without a price of its own follows the base unit, so it changes with it without a separate record. A unit with an automatic price is not changed.
- If you tick only the parent of variants, the unit prices of the variants that follow it change too, shown in the preview as "S, HITAM: Lusin". A unit priced only in one branch moves in that branch when **Move group prices along** is on.
- With **Move prices of other units along** off, the prices of other units stay and the preview warns about them.
- The channel prices do not change.
- Automatic prices worked out from the cost are not changed, because they follow their own formula.
- Group prices that would fall below the cost are not moved, and a warning is shown.
- More than 500 products are changed in the background. The outcome comes to the bell.

To change only a few chosen products, tick them in the list, then press **Bulk actions** and choose **Change Prices**.

## Quick Price Edit

1. Open **Master Data → Products**, then press **Quick Price Edit**.
2. Search for products by name, code or barcode. Filter by category or brand if needed.
3. When the shop has several branches, choose **All branches** or one branch.
4. Type the price in its cell, then press Enter to go down to the next row.

   ![The Quick Price Edit screen with the Cost, Wholesale, Regular and General columns and one changed price in yellow](https://vende.id/images/docs/en/produk-dan-harga/mengubah-banyak-harga-ubah-harga-cepat.webp "A changed price stays yellow until it is saved")

5. Press **Save** below the table, or Ctrl+S.

One row is one unit, for example Pieces and a Box of 12. One column is one customer group. The General column in the base unit is the product's Selling Price.

- A changed price turns yellow until it is saved.
- A grey number is not filled in and follows another price, for example the General price.
- The **Cost** column only shows to someone who may see costs.
- Warnings show under the product name, for example a price below the cost. Warnings do not stop you saving.
- The **Quantity prices** button under the unit name opens the quantity prices of that row.

Keyboard keys: Enter goes down, Shift+Enter goes up, Tab goes right, Esc brings back the original price.

One save holds at most 500 prices. When some are left, press **Save** again.

### From the Cost rose notice

After a purchase is saved, Vende checks the selling price of the goods whose cost rose. When the selling price (the General price of the base unit in the purchase's branch) ends up below the cost, or its margin is under the **Thin Margin Limit** in **Settings → Alerts**, the bell tells whoever may change prices in that branch: **Cost rose, check the sell price**. It holds the purchase number, the product with the lowest margin, and how many other products there are. The old cost, the new cost and the margin are only written for someone who may see costs.

Press **Change prices** in the notice. **Quick Price Edit** holds only the products to check (at most the 50 with the lowest margin). In a shop with several branches the screen opens on the purchase's branch and the branch choice stays, so you can switch to **All branches**. In a one-branch shop, it is the product's own sell price that changes. Press **Show all products** to go back to the usual list.

- One notice per purchase. Saving the same purchase again does not send a second one.
- A price you already filled in the **Selling Price** column of the purchase note counts, so a product whose price has gone up is not listed.
- Products with an automatic price (the **Automatic price** feature) are skipped, because their price follows the cost by itself. See [Automatic prices from the cost](https://vende.id/docs/produk-dan-harga/harga-otomatis?lang=en).
- The first purchase of an item (cost 0 before) and a purchase that lowers the cost send no notice.

> **Tip:** When someone else has just changed the same price, nothing is saved. Those rows are loaded again so you can check them, then save again.
