Multi-Record & Price Editor

Contents of this Topic: ShowHide

Overview

It is highly recommended that this utility is used off-hours when no order processing is in progress and only after a backup copy of the Store Data File has been made. It is not possible to easily reverse changes made at this screen in Add or Edit Product mode!

The Multi-Record & Price Editor allows data in multiple fields of multiple records to be updated simultaneously, rather than on a record by record basis. It can also be used to add new product records. Toggle between editing records and adding records by selecting the Edit Products or Add Products buttons in the upper right-hand corner of the screen.

There are five tabs, Standard Fields, Boxes,Custom Fields, Web & Miscellaneous Fields and Price Changes, which each contain fields which can be altered for all or selected records at once. The label of the currently selected tab is in bold text. 

Notes containing the old and new values of the altered fields are added to inventory records by setting system parameter, LogMultiRecordEditorChanges to TRUE. Only the first 100 characters of Text and Memo fields are included.

This screen does not support the use of a barcode scanner to enter barcode information at this screen.

To access the Multi-Record & Price Editor go to:

Main Menu>Settings>Inventory Functions>Multi-Record and Price Editor

Description of the screen

Global Editor

• opens the Global Editor screen

  

  Global Editor screen

   

   

Add Products/Edit Products

• toggles the screen between editing records and adding inventory records

Filter

• only visible when in Edit Products mode
• opens the Select Items screen which is used to locate existing inventory records to be edited

Standard Fields tab

• refer to the first image in the topic
• select a check box to view one or more fields in the display at the bottom of the screen so that it can be edited for one or more records
• clear the check boxes to remove them from the display

Boxes tab

• as the name suggests, this tab contains fields related to boxes

Web & Miscellaneous Fields tab

• fields related to exchanging data with a Web store are found on this tab
• it also contains other miscellaneous fields such as Serial Numbers, Standard Messages, Single-Unit SKU, to name a few

Price Changes tab

• this tab is not visible when in Add Product mode
• after selecting inventory records to be updated, use the buttons and drop-down lists on this tab to determine the type and amount of the price change
• use the Test button to simulate the projected price changes before making them permanent with the Save button; if changes need to be made, the value can be edited manually in the appropriate cell and then select the Save button

Select All

• selects all fields on every tab when in Add or Edit Products mode

Clear All

• clears all but the Local SKU field on the Standard Fields tab, which cannot be removed

Additional information

Created: 4/30/12

Revised: 8/13/15

Published: 08/19/15