cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
mcdopck
Level 1

How to raise prices to all items in the product list ?

linearly and automatically (not one by one)
4 Comments 4
AlcaeusF
Moderator

How to raise prices to all items in the product list ?

Hello @mcdopck,

 

Thank you for getting in touch about the task you want to perform for your inventory prices. Allow me to help you update your items in QuickBooks Online.

 

You can export your inventory list to Excel and import the data back to QuickBooks with the updated prices. Our system overwrites the information of the products and services based on the changes from the file.

 

The item names in Excel should match with the ones in our system to avoid duplicates. Here's how to export your list:

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Products and Services.
  3. Press the Export to Excel icon to download the list.

 

Once you have the copy, please open the downloaded file and update the prices. After you make the necessary changes, upload it back into your account.

 

You can follow these steps:

 

  1. Click the Gear icon in the upper-right corner.
  2. Select Import.
  3. Choose the file and select Next.
  4. Map the file and choose Next.
  5. Confirm that everything looks accurate and place a box next to  Overwrite all values for each product or service that you import with the identical name. (This can't be undone.).
  6. Hit Import.

 

Also, you can export non-posting transactions and attachments to Excel. For more information about the process, check out this article: Export data, reports, lists, and more from QuickBooks Online.

 

Let me know by leaving a comment if you have additional questions about updating item prices. We're available 24/7 here in the Community. Take care.

mcdopck
Level 1

How to raise prices to all items in the product list ?

Thank you!

 

Mike-S1mmons
Level 1

How to raise prices to all items in the product list ?

Sounds a lot more risky than the way it was possible to do with the desktop version, which sadly became extinct in the UK although I gather the US parent company still offers.  Sad but I think I will take the long-winded line by line option as will feel safer.

 

 

Deity Alpha
Level 4

How to raise prices to all items in the product list ?

@Mike-S1mmons 

You can use an inventory management app to sync with QBO and update/import the list price regularly in bulk easily. Otherwise, you can still purchase QB Desktop US version.