How do I change Items prices in Bulk?

You can change items prices by importing products into QuickBooks Online (QBO), user35184.

Let's export items from your account beforehand, so you have a copy of it. 

1. From the Gear icon, choose Products and Services.
2. Select the Filter icon, choose Inventory from the Type drop-down arrow, and choose Apply.
3. Click on the Export icon.

Then, update the price for each item and save the file to your computer. Once done, you can now import the data.

1. Click on the Gear icon and select Import Data.
2. Select Products and Services.
3. On the Import products and services page, select Browse.
4. Choose the file and click on Open.
5. Select Next and map your fields to QuickBooks fields.
6. Click on Next and ensure to check the Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.) box.
7. Select Import.

You can learn more through this link on how to import your products and services from Excel to QBO.

In case you want to merge duplicate items or remove unused ones, refer to this article: Remove or merge a product or service.

Keep us posted if you need anything else. We're here to help.

My product list is almost 1500 items, if I export and change prices as you have suggested can I import all back in one go ? I notice them was no problem in exporting the entire list but originally I had to import in two batches because of the 1000 line restriction. Thanks

You can only import a thousand (1,000) rows at a time, NicoleZimbo.

You'll have to split the items into two files instead. You can follow the steps provided by my colleague, JaneD, so you can export/import items. 

Before you import the items, let's just ensure the format and mapping are correct.

If you have more questions, please feel free to leave a comment below. 

Hi there!

Once the new import is completed, will the existing sales data still be available? As in, when I search a product, will I be able to see which accounts purchased the product prior to this brand new pricing upload? Or will it all start from scratch again?

Thanks for joining the thread, @erins77. 

I'd be glad to answer your question. 

You're right. Importing new products to QuickBooks won't change your existing sales data.

You can utilize the pricing rules feature for your products and services in QuickBooks Online to offer discounts or charge different rates by item.

Here's how:

1. Go to the Gear ⚙ icon.
2. Choose Account and Settings or Company Settings.
3. Select the Sales tab.
4. In the Products and services section, click on Edit ✏️.
5. Tap to put checkmark for Turn on price rules Beta.
6. Select Save and then Done.

For creating price rules, check out this article for more information: Set price rules in QuickBooks Online.

For additional reference about managing your products and services, check out these articles:

• Adding Products and Services, Customers, and Vendors to Lists
• How to set up products & services

Please touch base with us if you need further assistance with inventory in QuickBooks Online. We'll always make sure to get back to you. 

Is there a function to do a bulk increase in price i.e to increase all Sales Prices by 10%  without having to go through line by line?

Rich Lang says" I followed your excellent steps and indeed QBO said 973 of 973 items imported. It then automatically closed the page. However, none of the price changes I made are showing up in QBO! I even did it a second time. I even logged out and came back in.  Suggestion?  Thanks...

Actually, the prices did change when creating an invoice or sales receipt. What did not change were the prices in the Products & Services list. Strange.

I can share some information about updating prices, @richlang.

When importing your products and services, the amounts of products and services that you'd like to overwrite should have an identical name. Also, you should make sure to tick the checkbox for Overwrite all values for each product or service that you import with the identical name. (This can’t be undone.). 

You can go to your Products and services to check your items and your imported file to double-check.

Here's how:

1. Click on the Gear icon and select Import Data.
2. Select Products and Services.

You can refer to this article for more information about updating products and services: Change product and service item types in QuickBooks Online.

In the meantime, here's how you can edit the prices and costs of your items one by one. Here's how:

1. Go to the Gear icon (⚙) and select Products and Services.
2. Find the item you want to change.
3. Select Edit in the Action column.
4. Update the Sales price/rate and Cost fields. 
5. Click Save and close once done.

Here's more information about setting up product and service items you buy and sell: Add product and service items to QuickBooks Online. 

Then, here's how you can use reports to see your sales and inventory status to see your best sellers, what’s on hand, the cost of goods, and more. 

Let me know if you have further questions about updating your items in QuickBooks Online. I'm still here to help you further. Keep safe, and have a great rest of the day!

Is this option only available for QuickBooks online or can it be done in QuickBooks Enterprise desktop as well?  If so what are the steps there?

Suzi T

There's a way for you to make changes in your prices using QuickBooks Desktop (QBDT), Suzi T. 

If you want to update your list in bulk, you'll have to go to the List menu. Once you're there, that's the time where you can edit your entries by clicking the Add/Edit Multiple List Entries. Know that you can also copy your data from your Excel and paste it within the Add/Edit List Entries window. 

Here's how: 

1. Go to the List menu. 
2. Choose the Add/Edit List Entries. 
3. Under the List dropdown, you can select what you want to make changes. May it be the Customers, Vendors, Service Items, Inventory Parts, Non-Inventory Parts, Inventory Assemblies, and Vendor Items. 
4. For you to make an edit in your entries, click a field that you want to make changes. 
5. You can copy the data in your Excel by clicking the Ctrl + C and then Ctrl + V and paste that in the Add/Edit Multiple Entries window.  
6. Press Save Changes once done. 

You can also refer to this article for further information regarding editing multiple data in QBDT: Add and edit multiple customers, vendors, and items.

Furthermore, you may also want to Create, edit, or delete memorized transactions.

I'm always here if you have further concerns or information regarding editing your data in bulk. Have a great day and stay safe.

Thank you for that information!  We have close to 6000 inventory parts.  Is there a way to export the list that shows up in the “Add/Edit Multiple List Entries” to an excel file so that we know we have the same list that we will be importing back in. if there isn’t a way to export THAT list can you tell me where I can find the correct  list that shows the exact same items.  I don’t want to have to go thru all 6000 to compare if need be. 

My other question has to do with the Price Level lists.  We have different discounts off our List Price for certain items.  Is there a way to have the Price Level lists update with the same discount when you change the list price.  For instance, if I have an item that List price was $10 and the discount is 25% which would make it $7.50 and then changed the list price to $12.00 so the discounted price would then be $9.00.  Is there a way for that to automatically change when we change the list price?

Hello there, Suzi. Thank you for getting back to the thread and providing more details. I see you want to export the list in the Add/Edit Multiple List Entries to an Excel file and update Price Level Lists with Corresponding Discounts.

QuickBooks Desktop does not have a direct feature to export the list from Add/Edit Multiple List Entries to an Excel file. However, you can manually copy the data from the Add/Edit Multiple List Entries window and paste it into an Excel file for comparison before making any changes.

In addition, if you change the list price in QuickBooks Desktop, the corresponding discounts in the Price Level lists will not be updated automatically. You have to adjust the discounts manually for each item after changing the list price.

I'm adding these articles you can use in the future:

• How to Add, Edit, and Manage Your Customers List.
• Customize reports in QuickBooks Desktop.

If you need further assistance or clarification on these processes, post them here in the forum. I'll always be around to answer them ASAP! Have a great day ahead!

Copy the information Manually - so you want me to go item by item, column by column for close to 6000 inventory items from the Add/Edit list to an excel file?  That would take quite alot of time that I do not have plus create alot of ways to make an error. 

QuickBooks has been around for a long time I would think this is something you all should work on to be able to create a file out of the Add/Edit location for any reports that are done.  This is not very user friendly in making changes to pricing that we do ANNUALLY.  I cannot imagine that we are the only business out here that would like an easier way to make pricing changes when you have a long inventory list.

I was hoping you all had a better solution to this issue.

Thank you for getting back to me!