Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
userroma
March 22, 2021
Question

Can I change the price of multiple items instead of one at a time?

  • March 22, 2021
  • 19 replies
  • 93 views
No text available

19 replies

katherinejoyceO
katherinejoyceO
Level 9
March 22, 2021

Hello there, @userroma.

 

At the moment, you can only edit each item to adjust the cost. Let me show you the steps on how to edit an item's cost: 

 

  1. Go to the Sales menu, then select Products and Services. 
  2. Look for the first item to edit the cost and click Edit.
  3. Scroll down to the page until you'll see the Cost field. 
  4. Update the cost.
  5. Click Save and close.

 

Please note that the changes made will affect future transactions. Hence, the existing one will still use the old cost.

 

Check out this article for more details on setting up and tracking your inventory in QuickBooks Online. 

 

For future reference, you can also read through this article should you need steps in case you need to modify the quantity on hand of your inventory: Adjust inventory quantity on hand in QuickBooks Online.

 

Let me know if you have other questions. I'll be glad to get back to lend a hand. Take care!

 

 

muenstermann
January 29, 2022

Is there anyway to do a specific % increase across the entire inventory? Almost every vendor we have has a 5% increase Feb 1st and importing and exporting with single or multiple item manipulation is a massive time consuming effort. It would be far easier to plug in a across the board increase and then make individual changes were needed. 

MichelleBh
MichelleBh
Level 8
January 29, 2022

Yes, there's a way to add a specific % increase across the entire inventory in QuickBooks, @muenstermann. Happy to share with you the complete details and steps. 

 

I agree that exporting and importing inventory whenever there are changes is time-consuming. That's why QuickBooks create a Price Rules beta feature. This functionality let you to enter a percentage (decrease and increase) for all of your products and services. 

 

To utilize this, let's turn it on first by following the instructions below: 

 

  1. Go to the Gear icon, then choose Account and Settings. 
  2. Select the Sales tab. 
  3. Turn on the Price rules radio button in the 
  4. Products and services section.
  5. Click Save, then Done. 

 

After that, set up the price rule template. Do the following: 

 

  1. Go to the Gear icon again and select All lists. 
  2. Choose Price Rules and enter a unique name in the box. 
  3. In the Product and services drop-down, pick All inventory.
  4. Pick Percentage in the Price adjustment method field. 
  5. Select Increase by and enter 5% in the Percentage field. 
  6. Pick a Start and End date, then click Apply rule. 
  7. Hit Save and close. 

 

For more knowledge about this feature, check out this link: Set price rules in QuickBooks Online.

 

Further, visit these articles below on how to modify items and run different inventory reports in QuickBooks: 

 

 

Let me know if you need further help in handling your inventory. Just tag my name, and I'll get back to you. Have a nice day ahead, muenstermann.

katherinejoyceO
katherinejoyceO
Level 9
March 23, 2021

Hi userroma,

 

Hope you’re doing great. I wanted to see how everything is going about the changing of multiple items you had yesterday. Was it resolved? 

 

Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

California_diesel
November 22, 2021

Is a faster way? maybe export, correct, import?

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement