How to Edit Multiple Items (Bulk Item Editor)

It is more efficient to edit a group of items that share common fields at one time as opposed to editing each item individually.  FieldStack allows you to do multi-item edits in a grid which makes it easy to change things like item Name, Manufacturer, Product Source Group, Price, Start or Stop Sell Date and most other fields found in a single item edit screen.

This form is especially helpful for:

• Changing the Product source group on a selection of items
• Renaming a group of variants
• Changing abbreviations that came in from a vendor feed or vendor file
• Setting a Stop Sell Date on a group of items
• Updating cost or list price on a group of items
• Making Category and Type fields consistent across a group of items
• Adding box quantities
• Changing taxability

Editing multiple items

1. Once you have your item list on screen, use Click + Shift + Click or Click + Ctrl + Click to multi-select the items you need to edit.
2. Right-Click a single line in your item list
3. Select Edit [X] Items

The resulting form is a grid containing nearly all fields contained within the item edit screen. Attributes and images are excluded. All fields except UPC may be edited.

To edit a single field, type directly into that field to edit or add text.

…or use the dropdowns to change things like Category, Type, Start Sell Date etc.

All fields that you’ve edited will turn yellow.

To change all fields to the same value, alter the first field:

Right click and choose Set All:

The value will populate to the whole column and will change all items in your grid.

If you want to update some, but not all, listings with the information, use CTRL + CLICK on each listing to be updated, then right-click on the field with the new information and choose Set Selected.

NOTE: Fields containing check boxes may be unselected to nullify their functions, but deleting information from the In Box Item Quantity or date fields, will not remove the information from the listings.  Nullifying these previously defined fields can only be accomplished on the Item Edit screen of an individual item.

When all fields have been appropriately updated, check Update (x) and click Add to Database.

The form will refresh showing which lines were updated in the Status column:

The lower right will show the total Success and Error rate.

Remove Processed Rows will remove all updated line items from the form. If there are remaining line items (showing in red), they could be exported to excel and that file could be used as a guide to update the items individually.