Version 7.1
Version 7.1
Contents of this Topic: Show
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. The changes entered in Edit
Products mode take effect immediately and can not easily be un-done!
To access the Multi-Record & Price Editor go to Main Menu>Settings>Inventory Functions>Multi-Record & Price Editor link.
When the screen opens, the Local SKU field all of the products currently defined in the program are listed at the bottom of the screen. This field is the only field that cannot be removed from the display at the bottom of the screen.
To select additional fields to be modified, manually check each of the appropriate boxes on any of the five tabs: Standard Fields, Boxes, Custom Fields, Web & Miscellaneous, and Price Changes; or use the Select All button.
To limit the product records to be affected by the changes, use the Filter button in the upper right-hand corner of the screen, which opens the Select Items screen.
Enter data in the desired fields on that screen and press Enter to see the list of matching records.
Click the Edit Selected Items button, which closes the Select Items screen, and adds the matching records to the Multi-Record & Price Editor display.
At the bottom of the screen, click in one of the cells containing data to be modified and make your change.
**Please note that changes are saved as soon as you leave the current row and cannot be undone.
For Yes/No fields, enter Yes or No, or enter 1 or -1 for Yes and 0 (zero) for No.
Use the Enter or Tab keys to move to the next column or row to make changes to other records in the list.
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. The changes entered in Add Products mode take effect immediately
and can not easily be un-done!
To access the Multi-Record & Price Editor go to Main Menu>Settings>Inventory Functions>Multi-Record & Price Editor link.
When the screen initially opens it is in Edit Product mode. Click the Add Product button.
To choose fields to be included in the new product records, check the appropriate boxes on any of the five tabs: Standard Fields, Boxes, Custom Fields, Web & Miscellaneous, and Price Changes. The program requires a value in the Local SKU, Item Name and Primary Supplier fields when creating a new product record. If system parameter TrackInventoryFIFO is set to TRUE, it will also require a value in the Unit Cost field.
Click in the empty cells and begin entering data in the selected fields.
When you tab to a new row, the product record of the previous row is created.
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 as a precaution. All price changes
made at this screen must be Tested
before they can be Saved. It is
possible to edit the new values before saving them, or close the form
without saving the changes to abandon them.
To access the Multi-Record & Price Editor go to Main Menu>Settings>Inventory Functions>Multi-Record & Price Editor link.
When the screen opens, it defaults to Edit Products mode. If the screen was already opened and is in Add Products mode, click the Edit Products button in the upper right-hand corner of the screen because the Price Changes tab is not visible in Add Products mode.
Click on the Price Changes tab.
Choose one of the following radio buttons to determine the method in which prices are changed:
Increase by a percentage or a specific dollar amount
Decrease by a percentage or a specific dollar amount
Markup by a percentage or a specific dollar amount (based on the Primary Supplier unit cost or that of the lowest cost supplier)
Set the selected price field to a specific dollar amount; or the same value as a different price field, Plus or Minus a percentage (%) or dollar amount ($)
Enter the percentage or dollar amount in the appropriate fields for the selected price change method. Only one amount type can be chosen, even though all of the fields are enabled. When a value is entered into one of the fields, any existing values in the other amount fields will be cleared.
Click the Test button to preview the price changes at the bottom of the screen. The program displays the SKU, Item Name, Cost, Old Price, New Price and Reg. Price Margin fields. If the projected changes are not correct, simply enter the desired value in the New Price field.
When the price changes are correct, click the Save button.
Note: The Reg. Price Margin field was added in the OMS 5.8XX Beta series.
Created:
Revised:
Published: 04/14/16