cancel
Showing results for 
Search instead for 
Did you mean: 
wgrieves
Level 2

Good morning, does anyone know a way to do a bulk inventory cost update?

 
Solved
Best answer February 28, 2020

Best Answers
vpcontroller
Level 11

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

Unfortunately, there is no batch action to update the Cost field (or Sales Price field) at this time.

You will need to upload the CSV file to the Products and Services list page. 

(Gear icon > Lists > Products and Services > Select Import from the drop-down arrow next to New button).

 

import-list.png

View solution in original post

vpcontroller
Level 11

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

"Can I download my existing inventory csv, make changes and then upload the updated file to overwrite"

 

That's how you normally do it. You can click Export to Excel link from the same Products and Services page.

 

"will that mess up all my inventory, cost of goods, ect?"

 

Always a risk, you need to be extra careful, with some expertise would be helpful. Suggest importing a few items first and see how it works.

 

 

View solution in original post

6 Comments 6
vpcontroller
Level 11

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

Unfortunately, there is no batch action to update the Cost field (or Sales Price field) at this time.

You will need to upload the CSV file to the Products and Services list page. 

(Gear icon > Lists > Products and Services > Select Import from the drop-down arrow next to New button).

 

import-list.png

wgrieves
Level 2

Good morning, does anyone know a way to do a bulk inventory cost update?

Can I download my existing inventory csv, make changes and then upload the updated file to overwrite or will that mess up all my inventory, cost of goods, ect?

vpcontroller
Level 11

Good morning, does anyone know a way to do a bulk inventory cost update?

@wgrieves 

 

"Can I download my existing inventory csv, make changes and then upload the updated file to overwrite"

 

That's how you normally do it. You can click Export to Excel link from the same Products and Services page.

 

"will that mess up all my inventory, cost of goods, ect?"

 

Always a risk, you need to be extra careful, with some expertise would be helpful. Suggest importing a few items first and see how it works.

 

 

hugh-cox
Level 2

Good morning, does anyone know a way to do a bulk inventory cost update?

I tried this solution in QuickBooks online and it wants me to change the name of all of my products.  I want to update all products by 10%.  I downloaded the existing data into a csv file using the download link.  I updated all items to the new price. Saved the file and tried to import.  QBO tried to do the import and responded that 0 of my items were imported and that If I really wanted to do it, I had to change the fields highlighted.  The name field was what was highlighted.

Jen_D
Moderator

Good morning, does anyone know a way to do a bulk inventory cost update?

Thanks for joining this discussion, Hugh.

 

Allow me to join the thread and share some insights on how to import the items successfully. If the name field is highlighted red and won't let you go through, make sure it is formatted correctly.

 

For a Product/Service Name, there is a 100 character limit without any special characters. See the approved characters list for more info.

 

Check out this article to learn more about the process: Import products and services into QuickBooks Online

 

If you're still getting the same problem after several tries, please reach out to our Support Team to get further assistance. This way we can report this to our engineers for a fix. Here's how to contact us: 

 

  1. Go to the Help menu in QuickBooks, then choose the Search tab.
  2. At the bottom click on Contact us.
  3. Enter the keyword Account Management and Billing in the What can we help you with? box.
  4. On the next screen, scroll down to How would you like to connect with us section.
  5. Choose Chat with us to initiate a discussion with a live agent.
  6. Enter you account contact information then press Get a chat.
  7. When using this option, make sure to enable pop-up windows. The chat box will appear at the bottom right section of your monitor, and an agent will be with you shortly after. See this:

In addition to that, you can also consider checking out for third-party importer apps that handles data import. That way you can reimport whatever data is missing. Visit our applications website here: https://apps.intuit.com/app/apps/home

 

For other questions about this products and services import or if you need help with other things in QuickBooks, connect with me again. I'll be right here to help you anytime.

 

Salman Lunat
Level 1

Good morning, does anyone know a way to do a bulk inventory cost update?

Hii All. The solution is simple. ( For which I spend hours.) There should be a check mark at the bottom of the list which need to be checked off to allow overwriting already existing product. Thanka

Need to get in touch?

Contact us