How do I raise or lower the prices of many items at once?
With Warehouse → Price change. You choose which prices (sales or purchase), which items or families, and how much they go up or down. Before anything changes you see the list of prices with their before and after.
What do I need before starting?
Modify permission on Warehouse. And be sure about the range: the change applies to every item in it and cannot be undone from the screen. If you make a mistake, you will have to make another change in the opposite direction.
How is it done?
- Go to Warehouse → Price change.
- In Prices, choose Sales prices or Purchase price.
- In Price number, choose one or All prices.
- Set the Item range and, if you want, the Family range. Left empty, everything is included.
- For sales prices, choose in Change whether you want “Raise or lower by a percentage” or “Set the profit %”. To raise, type the Increase percentage (negative to lower prices) or a fixed Amount that is added or subtracted. To set it, type the Profit % every item should have.
- For round prices, set Round to multiples of (for example 0.05) and Prices ending in (for example 0.99). For prices from applies that only to prices that reach that figure.
- Press Preview. Every price that would change is listed, with its current and its new value.
- If it looks right, press Apply the change.
If you change any field after the preview, you have to ask for it again: what is applied is always what you have seen.
Which prices am I going to change?
The first two fields decide it. In Prices you choose whether you are touching the Sales prices or the Purchase price, and in Price number, if you have several price lists, which one (or All prices).
Which items are included?
The ones that fall inside the ranges. An empty range does not filter by it, so leaving them all blank brings in every item. Each field has its magnifier to look the code up without knowing it by heart.
How do I see it before applying it?
With Preview: every price that would change comes out, with what it is worth now and what it would be worth. Nothing is touched until you click the apply button, and if you change any detail after seeing it you have to ask for it again, because what gets applied is always what you have seen.
How do I give every item the same profit %?
By choosing “Set the profit %” in Change, for sales prices. The percentage is no longer an increase: it is the profit each item is left with, and its sales price is worked out from the cost.
The calculation is the one in Settings → Sales and documents → Prices → Warehouse price calculation, the same one the item record uses. With a final purchase price of 80 and 20 %, the price becomes 96 with Profit on final purchase price, and 100 with Profit margin on sale price. With Discount on base purchase price it starts from the base purchase price.
- Items without a cost are not touched: there is nothing to work the price out from.
- The cost is the item's cost, the same for its six sales prices.
- An item without a sales price gets one in Price 1.
- With All prices, a price number the item does not use (no price and no profit) stays empty. To start using it, choose that price number.
- Rounding and ending are applied afterwards. If they change the price, the profit saved is the one of the price that remains.
- With margin on sale price or discount on base price, the percentage must be less than 100.
- You need to be able to see cost prices.
What happens to the margin when prices change?
When you raise or lower sales prices, each item's profit is recalculated with the new price.
When the purchase price changes, it depends on the Also change the sales prices box:
- Ticked: the sales price goes up with the purchase price and the profit stays the same.
- Unticked: the sales price is left alone and the profit changes.
There is one purchase price per item, so the change reaches all its sales prices in use, not only Price 1.
Both calculations follow Settings → Sales and documents → Prices → Warehouse price calculation. Items without a purchase price are not touched.
How does the ending work?
The ending replaces the last digits of the price. A price of 12.47:
- with ending 0.09 becomes 12.49;
- with ending 0.99 becomes 12.99;
- with ending 9.00 becomes 19.00.
The percentage or amount is applied first, then the rounding and finally the ending.
More about Warehouse
- How do I view and correct an item’s stock?
- How do I count the warehouse and balance the stock?
- How do I add a warehouse?
- Managing the warehouse
- What batch and traceability reports do I have?
- How do I move stock from one warehouse to another?
- How do I run the stock report?
- How do I follow the traceability of a batch or a serial number?
- How do I work with batches and expiry dates?
- How do I work with serial numbers?
- How do I work with sizes and colours?