Skip to main content
November 3, 2024
Question

How do I update the prices for hundreds of products? Using an excel file.

  • November 3, 2024
  • 1 reply
  • 0 views
These are existing products that I already have in the system.  I just need to update the price field for hundreds of products at once.

1 reply

November 3, 2024

I've got a way for you to update the prices in bulk using an Excel file, Stewart. Let me get this into detail and help you achieve this.

 

You can export your current product list from QuickBooks Online (QBO) to Excel so that the prices of the products will be updated.

 

It's my pleasure to show you how:

 

  1. On the upper right corner, look for the Gear icon.
  2. Select Products and Services.
  3. Choose Import Data.
  4. Click Export to download the current product list.
  5. Open the exported file in Excel and update prices.
  6. Once done, click the Excel file to save.

 

Moreover, it's important to know that updating prices for products and services will not impact your past transactions. Only future transactions will show the new prices.

 

If you need additional support or clarification regarding your products and services in QuickBooks Online, please don't hesitate to reach out. I'm always eager to lend my expertise to support your business growth.