Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
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).
"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.
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).
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?
"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.
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.
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:
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.
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here