Two Hundred Prices Before Lunch
A price rise across two hundred items should take a morning, not a week of opening records one at a time. A grid you can paste into from Excel, a review of every change before it is saved, a batch you can put back — and two columns it will never let you touch.
A plumbing and electrical wholesaler in Kampala gets the new price list from its main pipe supplier on a Friday afternoon: 214 lines, up between four and eleven per cent, effective Monday. The buyer has the figures in Excel within the hour. Getting them into the item records used to mean opening 214 records, one at a time, and hoping nobody typed 1,450 where 14,500 was meant.
For the buyer
Items › Bulk edit opens a page of up to 200 items as a grid. Paste a block from Excel or Google Sheets, or paste whole rows matched by item code or barcode. Review shows every changed cell, old and new, and every error, before anything is written. Save applies the lot in one transaction as a numbered batch with a change log, and the batch can be reverted cell by cell. Quantities and cost are not columns on the grid, so they cannot be changed from it.
What the grid edits
| Column | Applies to |
|---|---|
| Name, Category, Barcode, Active | Every item |
| Markup % | Stock items, whose selling price follows their cost |
| Selling price | Service items, which have no cost to mark up |
| Reorder point, Reorder qty | Stock items |
| Price on a chosen price list | Every item, when you pick a price list |
| Min and Max at a chosen warehouse | Stock items, when you pick a warehouse |
Filter first — by search, category, status or item type — so the grid shows the 214 pipe items rather than the whole catalogue. Pick the supplier’s price list and its column appears; pick the Kampala warehouse and its minimum and maximum appear. A user pinned to one warehouse sees only that warehouse.
The two columns that are not there
Quantity and cost are left off on purpose, and not as a setting someone can switch back on. Stock moves only through adjustments, transfers, receipts and sales, each with its own reason and its own posting; a quantity typed into a grid would be stock appearing from nowhere. Cost comes from what you paid: the buying price and the moving average are set by receipts. A grid that let someone type a cheaper cost would let them type a bigger margin. Neither is a column the editor knows, so no paste and no crafted request can reach them.
The grid edits what you decide. It never edits what the warehouse and the supplier decided for you.
Paste, review, save
-
Paste
Paste a rectangle of cells from Excel or Sheets into any cell and it fills across and down. Paste into the Code column and rows are matched to items by item code or barcode, up to 500 at once; codes that match nothing are listed.
-
Review
Every changed cell is listed with its old and new value, and any cell that fails validation is marked with the reason. Nothing is saved yet.
-
Save
Up to 2,000 changed cells are applied in one transaction. Either all of them are saved or none are.
Review and save run the same checks, so a review that showed no errors and a save that refuses can only disagree when the data moved in between — another person edited one of the items — and then the save says which. A save where every value already matches is refused with “Nothing to save”, rather than recording an empty batch.
The Kampala price rise, Friday 4 pm
The one refused cell is fixed in the grid before saving; nothing was half-applied while it was found.
A batch you can put back
Each save is a batch with its own page: who saved it, when, how many items and changes, and every cell old and new. If Monday morning shows the supplier’s list was the wrong version, revert the batch. It puts back each cell that still holds what the batch wrote and skips any cell someone has changed since, and tells you how many it skipped. A revert is itself a batch, linked to the one it undid, so the history only grows. Moving items in from a supplier file for the first time is a different job; that is in bulk data import templates.
Why it is on the web only
The grid is a desktop tool: a 200-row spreadsheet is not something to edit on a phone. The app shows every value the grid writes, so a price changed on Friday is the price on the till on Monday.
The editor needs the permission to edit items, and saves are rate-limited per user. More on the screen on the item bulk edit page.
Bulk changes that fit your pricing routine
The grid, paste matching, review, batches and revert are in place. These extensions come from how buyers and pricing teams use it.
A percentage change across a filter
Raise every price on a list for one category by a percentage, previewed and saved as a batch like any other.
A batch that takes effect on a date
Prices saved on Friday and applied on Monday morning, so the till and the price list change together.
A second approver on large batches
A batch above a number of changes held until another person approves it.
Opening cost and quantity by reviewed import
For a first load only, through an import that posts its own adjustments and journal, never through the grid.
Three questions before your next price change
If we change 200 prices, can we see them all before they go live?
What you will probably hear
We check a few after.
How to read it
A review of every changed cell before saving catches the typo the spot check misses.
If the list was wrong, how do we put it back?
What you will probably hear
Type the old prices in again.
How to read it
Then the old prices need to be somewhere. A batch should carry them.
Could a bulk tool change stock or cost?
What you will probably hear
Only if someone is careless.
How to read it
Quantities and cost belong to movements and receipts, and a bulk tool should not reach them at all.
What AWRA OpsHub does today
- A grid of up to 200 items for names, categories, barcodes, markup, service prices, reorder levels, the active flag, a price list’s prices and a warehouse’s min and max.
- Paste from Excel or Sheets, and paste whole rows matched by item code or barcode.
- Review before save, with every change and every error listed.
- One transaction per save, up to 2,000 cells, recorded as a batch with a change log.
- Revert a batch cell by cell where the cell still holds what the batch wrote.
- No quantity and no cost columns, by design.
More we can add to your workspace
- Percentage price changes across a filter, previewed as a batch. Commission it
- A batch scheduled to apply on a date. Commission it
- A second approver on batches above a size. Commission it
- The bulk grid in the mobile app, for tablets at the counter. Commission it
- Opening cost and quantity loaded by a reviewed import that posts its own adjustments. Commission it
Where we point you to a specialist
- Your prices are your decision. The grid records who changed what and lets you put it back; it does not check a price against the market or the law on price display.
Percentage changes across a filter are the extension buyers ask for first.
See item bulk edit
Edit prices, categories and reorder levels like a spreadsheet, review every change, and keep a batch you can revert.
Explore bulk editFrequently asked questions
Can the bulk edit grid change stock quantities?
No. Quantities change only through adjustments, transfers, receipts and sales. Quantity is not a column on the grid.
Can it change an item’s cost?
No. Buying price and moving average cost come from receipts, and cost is not a column the grid knows.
How many items can I edit at once?
Up to 200 items on a page and up to 2,000 changed cells in one save.
Can I undo a bulk change?
Yes. Revert the batch and every cell that still holds the value the batch wrote is put back. Cells changed since are skipped and counted.
Is bulk edit in the mobile app?
No, it is a web tool. The app shows every value the grid saves.