How To: Update Stock Sell Price en-masse

  1. Open a Promotion screen (show me how).
  2. Select the [ Price Lists | Stock Item/Price List ] tab.
  3. Select the required price list from the drop-down list.
  4. Press Alt+E or click the green triangle icon is the buttonbar's EDIT button to enter edit mode.
  5. Check the Allow editing list prices checkbox.
  6. Press F3 or click the NEW ITEM button has an icon that shows two sheets of paper (identified by having the top right corner folded down), arranged diagonally on the icon from top left to bottom right to add a new item.
    Note: to select all stock items on the system put a % in the Description field and press the Enter or F5 buttons, then select all item in the grid (Ctrl+A) then double click or press Enter to add them to the price list grid.
  7. Press Ctrl+S or click the disk icon is the button bar's SAVE button to save.

There are two options for updating the list buy prices:

  1. Export/Send to Notepad as a .csv and open in Excel making the modifications, saving and then copy the new prices over the originals.
  2. Copy all prices from the List Price column to the Amount column. Use the Update Prices/Discount column to update them then copy all the prices back to the List Price column. This is fine for smaller updates but would become time consuming for a large number of items.

Note: Be careful when copying and pasting cells from Excel into Khaos Control as pasting more than 100 cells of information the system can drop the information.

See Also

Did you find this article helpful?