Ask AwraIQ about features, pricing, onboarding, login, integrations, security, demos, mobile apps, automation, reports, or support.
Two hundred items, one grid, and a review before anything is saved.
Change a price list, a reorder policy or a category tidy-up the way you would in a spreadsheet — type, paste, fill down — then review every changed cell and apply them as one batch with a change log. The grid knows the master data columns and nothing else: stock quantities and cost are not in it.
- ITM-0412 · Markup %25 → 30OK
- ITM-0412 · Reorder point40 → 60OK
- ITM-0519 · Nairobi max— → 500OK
- ITM-0519 · BarcodeAlready used by another itemRefused
Filter, edit, review, apply.
Filter
Load a page of items by search, category, warehouse, status or type. Pick a warehouse to add its min and max columns, or a price list to add its base price.
Edit like a sheet
Arrow keys, Tab and Enter move; type or F2 edits; Ctrl+C copies as tab-separated text; Ctrl+V pastes from Excel or Sheets; Ctrl+D fills down; Ctrl+Z undoes.
Review
Every changed cell is listed with its old and new value and checked on the server. Anything that would be refused is shown before you apply.
Apply or revert
Apply saves the batch in one transaction. A batch can later be reverted cell by cell, wherever the cell still holds what the batch wrote.
The master data you change in bulk. Not the numbers that are earned.
In the grid
- Name, category, barcode and active for every item.
- Markup %, reorder point and reorder quantity for stock items; selling price for services.
- Minimum and maximum per warehouse, when a warehouse is chosen.
- A price list’s base price, for people who manage price lists.
Never in the grid
- Quantities on hand, which move only through adjustments, receipts, transfers and counts.
- Cost — buying price and moving average — which comes from receipts.
- New items. A pasted code the grid cannot find is reported back, never created.
The rules a single-item edit follows, applied to every cell.
Paste by code
Paste rows into the Code column and the server matches each one by item code or barcode, up to 500 at a time, so a sheet from a supplier lines up with your items.
One validation, twice
Review and apply run the same per-cell checks. If the data changed between them, apply says so rather than saving something you did not review.
Locked cells say why
A column that does not apply to an item’s type is locked in that row, with its reason, so a service never gets a reorder point.
Warehouse pins hold
Someone held to one warehouse edits that warehouse’s min and max only, the same restriction they work under everywhere else.
Sized to be checked
Up to 200 items and 2,000 changed cells per save — enough for a real price change, small enough that the review is read.
A batch you can read later
Every applied batch keeps who changed which cell, from what to what, on a page of its own.
What AWRA OpsHub does today
- A spreadsheet grid over a filtered page of items, with keyboard movement, copy, paste from Excel or Sheets, fill down and undo.
- Name, category, barcode, active, markup, selling price for services, reorder point and reorder quantity.
- Per-warehouse minimum and maximum, and a price list’s base price for people who manage price lists.
- Paste by item code or barcode, with codes that are not found reported back.
- Review then apply, both validated on the server, up to 200 items and 2,000 cells per save, in one transaction.
- A change log per batch and revert cell by cell where the cell still holds the batch’s value.
More we can add to your workspace
- Custom field columns in the grid, beside the standard ones. Commission it
- Purchasing columns such as preferred supplier, lead time and pack size. Commission it
- Scheduled changes that apply on a date, such as a price rise from the first of the month. Commission it
- The same grid for customers and suppliers. Commission it
- An approval step for a batch above a size or a price change you set. Commission it
Where we point you to a specialist
- We will not let the grid change stock quantities. Stock moves through adjustments, receipts, transfers and counts, where each movement has a reason.
- We will not let the grid change cost. Cost is earned from receipts, not typed.
- We will not create an item from a pasted code we cannot find. New items go through the item form and its checks.
- We keep bulk editing on the web, where two hundred rows and their review fit on one screen; the mobile app edits items one at a time.
Custom field columns and scheduled price changes are the two items catalogue owners ask for first. Tell us how you change prices today and we will come back with a written spec, a timeline and a price.
The item master it edits, and the controls around it.
Frequently asked questions
Which item fields can be edited in bulk?
Can it change stock quantities or cost?
Can I paste from Excel?
What happens before changes are saved?
Can a bulk change be undone?
Is bulk edit in the mobile app?
Help Center
Need a quick answer while you read?
Run inventory, procurement, assets, sales, and field work with approved AWRA guidance for setup, migration, integrations, security, pricing, and support.