Manually change a product price

You can change the price of a product or group of products by a dollar amount or percent, while viewing the old and new price. You can also adjust the price rollup schedule for a single product or entire group.

Use this method of price change if you want precise control over each price, rather than price formulas, which apply rules to large groups of products.

If you want to change the price of a single product, and you do not need to view history, see Add main product and price information.

1. Go to Sale > Pricing > Price Change.

   

2. From the Select C/L Column list, select the Cost or List price column that you want to modify. For more information, see Learn about cost and list prices.
3. From the Change Date calendar, choose the date on which you want the price change to take effect.
4. Add the products whose price you want to change

   • To add products one at a time, click the Add Product button, and then type or search for the product in the Product column of the Products grid.
   • To add a group of products, click the Select Products button. Choose the criteria, and then click OK to populate the Products grid. For more information, see Selecting data.
5. If you are maintaining the product cost by warehouse, choose the Warehouse in which you want to apply the change, or All Warehouses to update them all at once. If you are not maintaining cost by warehouse, this option doesn't appear.
6. There are two ways to change prices:
• To change one price at a time:

  1. If you want the new price to use margin pricing, clear the New M Price Disabled check box. This setting applies strictly to this price change, and will not be saved in the Product Master for future changes.

     

     To permanently disable the margin price for a product, go to File>Product>Master: Setup, General, and select the Disable Margin Price check box.

     This field will not display if you are not using Last Price Paid as your default price for customers.

  2. In the New Value box, type the new price.
  3. Repeat for each product.
• To change all prices by a specific percent:

  Warning: If you choose All, this option overwrites any values entered in the New Value column The "From Here" option will only affect products listed below the currently selected product.

  1. Click the Percent Increase button.

     

  2. On the Adjust All Prices pop-up, choose whether to change All prices, or From Here, which affects only prices from the selected product down.
  3. In the Price Adjustment box, type the percent change to apply to all products. Type a dash before the number to decrease the price by that percentage.
  4. Click OK.
7. Review all price changes that appear in the Pricing table.

   

8. From here you can also Set a price roll-up schedule for products
9. Click Save.

   If your price change is set to become effective on a future date, you can make changes to the prices by selecting the same group of products, cost or price column, and date. If your price change is set to become effective immediately (on your current date), the next time you select the same group of products, cost or price column, and date, the new values will appear in the Current Value column.