AWRA OpsHub Search
Inventory · Item bulk edit

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.

Paste from Excel or Sheets Revert a batch Quantities and cost untouchable
From Items → Bulk edit

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 columns

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.
Why it is safe to hand to a buyer

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.

Item bulk edit — what ships today, and what we can add

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.

Frequently asked questions

Which item fields can be edited in bulk?
Name, category, barcode and the active flag for every item; markup percentage, reorder point and reorder quantity for stock items; selling price for services; minimum and maximum per warehouse when a warehouse is chosen; and a price list’s base price for people who manage price lists.
Can it change stock quantities or cost?
No. Neither is a column the grid knows. Quantities move only through adjustments, receipts, transfers and counts, and cost comes from receipts.
Can I paste from Excel?
Yes. Copy cells from Excel or Google Sheets and paste them into the grid. Pasting rows into the Code column matches each one to an item by code or barcode; codes that are not found are reported back, never created.
What happens before changes are saved?
Review lists every changed cell with its old and new value and checks it on the server. Apply runs the same checks again and saves the valid changes as one batch in one transaction.
Can a bulk change be undone?
Yes. Each batch keeps a change log, and reverting it puts each cell back wherever the cell still holds the value the batch wrote.
Is bulk edit in the mobile app?
No, on purpose. The grid and its review are on the web, where two hundred rows fit on a screen; the mobile app edits items one at a time.

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.

Search all approved AWRA public help articles.

Open Help Center