Skip to main content
U
user35184
January 16, 2020
Question

How do I change Items prices in Bulk?

  • January 16, 2020
  • 3 replies
  • 0 views
Original commenter did not share additional details

3 replies

JaneD
JaneD
January 16, 2020

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.

N
NicoleZimbo
January 27, 2020

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

Kristine Mae
Kristine Mae
January 27, 2020

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. 

    R
    Riaan v A
    January 26, 2023

    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?

    R
    richlang
    June 25, 2023

    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...

    MJoy_D
    MJoy_D
    June 25, 2023

    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!

    Terms & ConditionsAccessibility statement