Available in Sage 50 Premium Accounting and higher.

Update the Prices on a Price List

ClosedBefore you can perform this task

Switch to single-user mode

To update prices in a price list:

ClosedSome prices in the list

ClosedUpdate prices inside the program

  1. In the Home Window, on the Setup menu, choose Settings.
  2. On the left side of the window, click Inventory & Services and then Price Lists.
  3. Click Update Price Lists, and in the Set box select the price list in which you want to change prices.
  4. In the Show section on the right side of the window, choose the item type that will be displayed in the list. You can also choose whether to show inactive items.
  5. In Set Prices For, select the currency that will be affected by the price changes.
  6. For each item you want update, type a new price in the New Price column.
  7. Click the Save Prices button.
  8. Click OK.

ClosedUpdate prices in a spreadsheet outside the program

If you want to modify some, but not all, prices in any of your price lists, you can export the data to a spreadsheet program, where you can use any combination of formulas to the update the prices.

ClosedStep 1: Export a price list out of Sage 50 Accounting

  1. In the Home window on the File menu, choose Import/Export, and then Export Records.
  2. Select Export price lists and click Next.
  3. In the Export File window:
  1. Enter a name for the file you are exporting.
  2. Enter a destination for the file you are exporting, or click Browse to navigate to a destination.
  3. Click Next.
  4. Enter the following details and then click Next.
  1. If you use more than one currency, choose the currency in which you want to export the prices.
  2. Choose the types of items for which you want to export prices: Inventory, Service, or both.
  3. Select the items you want to export by clicking the column beside each item. Click Select All to choose everything in the list.
  4. (Optional) To include inactive items, select the box.
  5. To select the price list(s) you want to export, click the column beside each list, or click Select All to choose all the price lists. Then click Next.
  6. Review the export log for errors. If the export was successful, click OK to save the file.
  7. Click Finish to close the wizard.

ClosedStep 2: Modify the exported price list in a spreadsheet program

  1. The exported file was saved in a .TXT format. Rename it as a .CSV file to open it in a spreadsheet program.
  2. Open the file in the spreadsheet program and modify as required.
  3. Save the updated file.

ClosedStep 3: Import  the new prices back into Sage 50 Accounting

  1. Choose Import/Export from the File menu in the Home window, then Import Records.
  2. Select Updated price lists and click OK.
  3. (Optional) To back up your company, click Back Up. Click Next when the back up completes.
  4. Enter the location of the file you want to import, or click Browse to locate it, and then click Next.
  5. Review the import log for errors and then click OK.
  6. Click Finish to close the wizard.

ClosedAll prices in the list

  1. In the Home Window, on the Setup menu, choose Settings.
  2. On the left side of the window, click Inventory & Services and then Price Lists.
  3. Click Update Price Lists, and in the Set box select the price list in which you want to change prices.
  4. In the Show section on the right side of the window, choose the item type that will be displayed in the list. You can also choose whether to show inactive items.
  5. Select how you want to modify the price list:
  1. In the Prices By box, select whether you would like to increase or decrease prices. In the box on the right side of Prices By, select the price list you would like to use as the basis for the price change. For example, you might set prices for the Preferred price list by taking 10% off the Regular price list.

Note: If you are using FIFO inventory costing, prices based on Cost always use the most recent purchase cost to calculate price. (Sage 50 Premium Accounting)

  1. In the Prices box, select whether you would like to change the prices by a percentage or a fixed amount. In the box on the right side of Prices, enter a number by which you would like to increase or decrease the price.
  1. (Optional) To round prices to the nearest cent or dollar, select the Round Prices box, and select how you would like to round the final price.
  2. In Set Prices For, select the currency that will be affected by the price changes.
  3. Click to select all the items on the list, or place checkmarks beside the items you want to modify.
  4. Click the Calculate button to calculate the new prices.
  5. (Optional) You can make changes to the calculation settings (by changing the percentage or amount, for example) and recalculate the prices.
  6. Click the Save Prices button.
  7. Click OK.

What do you want to do?

Add, change, or remove a price list

Import or export a price list

Select a price list for a customer

Modify the price lists report