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. From the Gear icon, choose Products and Services.Select the Filter icon, choose Inventory from the Type drop-down arrow, and choose Apply.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. Click on the Gear icon and select Import Data.Select Products and Services.On the Import products and services page, select Browse.Choose the file and click on Open.Select Next and map your fields to QuickBooks fields.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.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.

Question

How do I change Items prices in Bulk?

Forum|Forum|6 years ago
January 16, 2020
4 replies
46 views

No text available

QuickBooks Online

JaneD

Level 6

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.

From the Gear icon, choose Products and Services.
Select the Filter icon, choose Inventory from the Type drop-down arrow, and choose Apply.
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.

Click on the Gear icon and select Import Data.
Select Products and Services.
On the Import products and services page, select Browse.
Choose the file and click on Open.
Select Next and map your fields to QuickBooks fields.
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.
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

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

Moderator

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

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

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

QuickBooks Team

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:

Click on the Gear icon and select Import Data.
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:

Go to the Gear icon (⚙) and select Products and Services.
Find the item you want to change.
Select Edit in the Action column.
Update the Sales price/rate and Cost fields.
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!

K

karcher_man_uk

We really just simply need to add a percentage to all our products once a year loads of quickbooks customers have been asking for this surely it cant be that hard to add it to the software!

Sign up

Login with SSO

Let's get you signed in

Login with SSO