Skip to main content
B
BLS
November 30, 2021
Question

Can you increase the selling price of all your inventory items by a percentage at the same time

  • November 30, 2021
  • 1 reply
  • 0 views
Our vendor is increasing our costs by 5%. Can you increase the items selling price in QBO by a percentage in a mass change

1 reply

H
Henock K
November 30, 2021

Hi BLS.

Welcome to the Community. Being able to adjust your selling price of your inventory items is essential to ensure that the correct information is recorded to your transactions. QuickBooks Online is a great program that offers the ability to simply track your inventories items to keep your books up to date. I'd be glad to point you in the right direction regarding the increase of the selling price of all your inventory items.

In QuickBooks Online, you can increase the sales price of all your inventory by a percentage using the Price Rules feature. If the feature is not active yet, I encourage you to follow these steps to turn it on

 

  1. Click on the Gear icon at the top.
  2. Choose Account and settings.
  3. Select Sales on the left navigation menu.
  4. In the Products and services section, select Edit ✏️.
  5. Select the Turn on price rules checkmark.
  6. Select Save and then Done.

 

Once activated, you can refer to these steps to increase the sales price of your inventory items by a percentage.
 

  1. Click on Sales on the left navigation menu.
  2. Select Price Rules.
  3. Select Create a rule and then New price Rule.
  4. Enter the Rule name and keep the Price adjustment method in percentage.
  5. Select the Product and Service tab.
  6. Choose the Start date and the End date if applicable.
  7. Under the drop-down menu of Product and service at the top right, choose All inventory.
  8. On the Percentage drop down menu, choose Increase by and then enter your percentage.
  9. Sales price will increase by the percentage of your choice under the ADJUSTED PRICE column.
  10. Select Apply Rules .
  11. Click on Save and close.


When creating an invoice, the price rule will automatically be applied as you add items. You can also override the price rule by selecting the rate and seeing all active price rules.

If you'd like to adjust the cost of goods sold for the inventory items, you'd need to manually adjust the price for each of them.

Let me know if you have any questions, I'll be happy to help.

 



 

 

Terms & ConditionsAccessibility statement