Change prices for many products
When a supplier raises prices or you reorganise your list, change many products at once instead of opening each one.
Before you start
- You need the right Edit products.
Steps: change prices or categories
- Open Inventory → Product list. Use Search, Category and Filters to narrow the list, then select Apply.
- Tick the products you want to change.
- Under With the selected:, select Bulk edit & price change. The page says how many products are selected.
- In Price change, choose Percent % or Fixed amount and type the Value. A negative value lowers prices.
- In Round to, pick a rounding step, or No rounding.
- Select Show the preview to see each product's old and new price.
- To move the products as well, pick a category in Move to category. To show or hide them, use Visible.
- Tick Apply to variants too if the products have variants.
- Select Apply.
[SHOT inventory-bulk-price 1440x900]Screenshot to come: Bulk edit & price change with 24 products selected: Percent % 10, Round to 0.25, and the preview table of old and new prices
Steps: tidy your categories
- Open Inventory → Categories.
- Type a name in New category and select Add.
- On the category's line, select Rename / Merge into.
- To rename it, type the new name and select Rename.
- To join it with another category, choose the target in Merge into and select Merge into again to confirm. Its products move to the target category.
Steps: fill wholesale prices
- Switch on Wholesale price level in Settings → Features.
- Open Inventory → Price levels. Each product shows its Retail price and its Wholesale price.
- Type wholesale prices one by one, or use Fill wholesale by % of retail: type the Percent %, choose Round to, and select Apply.
- Select Save.
[SHOT inventory-price-levels 960x600]Screenshot to come: Price levels: Retail and Wholesale price columns, and the Fill wholesale by % of retail box with -12 % and Round to 0.5
Good to know
- If a change would make prices 0 (−100 % or lower), the page asks you to confirm by ticking a box first.
- The Wholesale clients list on the Price levels page shows the customers marked as wholesale. On a Books invoice, such a customer gets the wholesale price by default; a product without a wholesale price falls back to retail.
- To keep a margin when a supplier's cost rises, see Act on cost rises and slow stock.
Was this page helpful?
Thank you. Your answer helps us improve this page.
Still need help?
Chat with us on WhatsApp. Tell us what you were doing and, for an error, the code after the # in the link.