Yes, you canimport inventory items in QuickBooks Online. You can also override the existing quantity of these items. Here's how:
If you have any questions, please let me know. I'm here to help.
I want to overwrite the "name" field for several items using and upload in bulk.
I just want values in that field to be overwritten, is there a way to do that through and upload without affecting anything else (i.e. cost, QTY on hand, etc)?
Thank you for getting back to us, @casimoran.
When you import an item with the same name and let it overwrite all the values, this will merge any imported Product/Service, but will not affect the cost, QTY, etc.
For more information about this, see this article: Import products and services from Excel.
Let us know by leaving a comment below if you still have questions. Please know that I'm always here to assist. Enjoy the rest of the week.
Explore the importer tool. You may import data of inventory adjustment and transfer inventory (Enterprise only).
Hope it helps.
I tried overwriting the value, however, my upload didn't reflect the value changes for any of the inventory accounts except for one. Ive tried using their sample template, researching, breaking up my data (I only have 55 lines so shouldn't be an issue) and nothing works.
This is my attempt to create beginning inventory balances and all of the balances show up as zero even though my upload template reflects the quantities on hand as well as the purchase price.
Thank you for joining the thread, @peridott2283.
Whatever information that is showing up on your file or when manually overwriting the details should reflect on the products/services under the Products and Services page. When uploading the file, be sure to use the correct format and complete details when mapping the items/services.
For now, I recommend checking your inventory using a private window. The stored cache of the browser you're using may cause this unusual behavior.
To save you time, you can use either of these shortcut keys:
If you're getting the same experience, I encourage to manually update your inventory under the Products and Service page.
For additional details about importing products and services from Excel, read this article: Import products and services from Excel.
You can always add a comment below if you have any other questions. I'm always here to help. Happy weekend!