cancel
Showing results for 
Search instead for 
Did you mean: 
MaryLandT
Moderator

Can i import an inventory file in to update the inventory in Quickbooks?

You got it right, howardse.

 

You need to navigate the Add/Edit Multiple List window and modify multiple existing product names after importing them.

 

I've added this link for additional information: Add, edit, and delete items.

 

You can also use the IIF file to move item list to QuickBooks. Check out this article for instructions: Export, import, and edit IIF files.

 

Stay in touch with me if you have followup questions about this by commenting below. I'll be right here to help you.

Page Custom Supply LLC
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

Are these instructions for the Desktop Version? I am using the Online Version and I have 8000 Product Names that imported incorrectly and I need a quick way to overwrite them.

MaryLandT
Moderator

Can i import an inventory file in to update the inventory in Quickbooks?

Yes, those instructions are for the Desktop version of QuickBooks, Page Custom Supply LLC.

 

I can provide the steps for the Online version of your account. When you import products and services in QuickBooks Online, there's an option

to Overwrite all values for each product or service that you import with the identical nameDoing this will merge any imported Product or Service with the same name as an existing one. Here's how you can achieve this:

 

Importing Products and Services

  1. Click the Gear ⚙ icon, then Import Data.
  2. Select Products and Services. 
  3. Click Browse and find the file containing your items.
  4. Follow the on-screen instructions to map and upload your data.
  5. On the screen that lists all of the Products and Services to be imported, check the box at the bottom if you'd like to Overwrite all values for each product or service that you import with the identical name.
  6. Once finished, click Import.

The system will create an automatic Inventory Adjustment if a different quantity is being imported. Check out this link for your reference: Import products and services from Excel.

 

Also, you can use the audit log to see how it affects the existing product.

 

Leave a comment again if you need anything else. I'll always up to help you with importing products and services in QuickBooks.

Page Custom Supply LLC
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

My Problem is the Name. I need a way to overwrite the name. All other information is correct. 

SashaMC
Moderator

Can i import an inventory file in to update the inventory in Quickbooks?

Thank you for reaching back out to the Community, Page Custom Supply LLC. Although you have the ability to overwrite the value for the products and services, the option to overwrite names is unavailable. This would have to be done manually. However, I will take note of this and send this suggestion to our Product Developers. They are always looking for ways to enhance your business experience. I invite you to follow our blog to stay up to date. I hope you enjoy the rest of your day!

Page Custom Supply LLC
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

It looks like I am not the only one having the problem so anything you guys can do to help would be great. We chose Quickbooks because it is very intuitive and well known company thinking that anytime we ran into a problem you guys would have a solution. Maybe we chose the wrong software.

 

Changing the name on 8000 products would take way too many man hours. 

 

Reuploading them and creating all new products would leave us having to delete or as Quickbooks calls it make inactive 8000 wrong named products. It looks like that is not an easy task either.

 

Fiat Lux - ASIA
Level 15

Can i import an inventory file in to update the inventory in Quickbooks?

...

Page Custom Supply LLC
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

Thank you :-)

SkeeterJohn
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

I uploaded 4,000 skus with an "as-of-Date" sku date of 10/1/21 as type "non-inventory". I know see that invoices can't access those skus unless the invoice is after the 10/1/21 "as of date", further that in the skus loaded the sku has the date as "start". How can I change the Start Date, in bulk (4,000 skus). The import will not allow a "as of date" prior to the 10/1/21 from the prior import. Is there an inventory adjustment import like I would use on an annual inventory?

Mark_R
Moderator

Can i import an inventory file in to update the inventory in Quickbooks?

I've got you covered, @SkeeterJohn.

 

While changing the start date of the inventory in bulk isn't available, you may want to edit each of them.

 

I understand that you have uploaded 4000 SKUs. However, editing the start date for each inventory is the only way we can consider right now. Here's how:

 

  1. Sign in to your QuickBooks Online (QBO) account.
  2. Click the Gear icon, then select Products and Services.
  3. Select each inventory you want to edit.
  4. Under the Action column, select Edit.
  5. On the Quantity on hand section, click Starting value.
  6. Select the Got it button.
  7. Change the date under As of date.
  8. Click Save and close.

 

Also, I encourage submitting feedback directly to our product engineers. They may look into this suggestion and consider adding the option in the future update. To send your feedback, you can go to the Help menu and select Send Feedback Online. Then, enter your product suggestion in the field and click Submit.

 

You might also want to adjust the inventory quantity on hand in the future. This article will guide you through the steps: Adjust inventory quantity on hand in QuickBooks Online.

 

Please know that I'm just a reply away if you need any further assistance managing your inventory in QBO. Have a good one.

Svgg
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

Hello,

I tried to import dat to quickbooks online, I wrote Wholesale Candy as Product and Services and added 94 different candy name Sales Description part but whenever I click import button it only imported one data. Why is that happening?

ChristieAnn
QuickBooks Team

Can i import an inventory file in to update the inventory in Quickbooks?

Hi there, Svgg.

 

Thank you for visiting the QuickBooks Community. I'll be sharing troubleshooting steps to ensure that you'll be able to import all your data in QuickBooks Online.

 

Whatever information 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, please make sure to use the correct format and complete details when mapping the items/services to ensure everything is accurate. You can click this article to view further details and how to correctly import data in QBO: Import products and services into QuickBooks Online.

 

If the issue persists, it could be the cache is full, which is why when you click the import button it only imported one data. I recommend logging in to your QuickBooks account using a private browser. Then, import your data from there. This is to rule out the possibility of a webpage issue, and private browsing doesn't store local files or cache.

 

Use these keyboard shortcuts based on the browser you're using.

 

  • For Firefox or Microsoft Edge, press Ctrl + Shift + P.
  • For Chrome, press Ctrl + Shift + N.
  • For Safari, hold down Command + Shift + N.

 

If it works in incognito, I suggest clearing the cache of your regular browser. This removes the history or log of sites so you can start with a clean slate. You can check this article to see the steps: Clear cache and cookies to fix issues when using QuickBooks Online.

 

If the steps above didn't work, use another supported browser as alternatives.

 

Lastly, you may open this article to view different details about importing data to QuickBooks and how it works with various scenarios: Common questions about importing data to QuickBooks Online.

 

You can always add a comment below if you have any other questions about importing data to QBO. I'm always here to help. Take care!

Svgg
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

Hello,

 

Thank you for your fast answer but it didn’t work too. I opened a private browser as you described and uploaded the docs again and quickbooks imported only one of them again. I clicked overwrite all values for each product. I don’t know why is not working, everybody do it in that way for bulk products.

Jen_D
Moderator

Can i import an inventory file in to update the inventory in Quickbooks?

Thank for joining this discussion again, @Svgg.

 

I hear you and we're not taking this lightly. Since the troubleshooting steps you've tried for this issue did not work for you, calling our Support Team would be ideal to get further technical assistance.

 

You can reach our Live Support through these steps:

 

  1. Go to the (?) Help menu and click on Contact Us.
  2. Type the keyword Account Management and Billing in the What can we help you with? box.
  3. On the next screen, scroll down to the Choose a way to connect with us section.
  4. Choose Start messaging to initiate a discussion with a live agent or Get a call for callbacks.

 

 

To ensure we address your concern on time, check out our support hours.

 

I'd like to ensure you're taken care of, so let me know how the call goes. Add a new comment here or mention my name in the thread to notify me. I'm always here to help. Have a nice day!

jaslyncakes
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

hi, if i incorrectly key in date-as-in, how can i amend the date? because i cannot link with my storehub as the date was later than the transaction occur

DebSheenD
QuickBooks Team

Can i import an inventory file in to update the inventory in Quickbooks?

Thanks for bringing your concern to our attention and for joining in on the thread, @jaslyncakes.


I'd be glad to assist you in changing the date of your inventory items in QuickBooks Online (QBO).

We can make some changes to the item by clicking Starting value option for you to be able to enter the correct date.

Note that doing this will affect the initial value of your inventory. Here's how to do it:
 

  1. Click Sales on the left menu and go to the Products and Services tab.
  2. Look for the inventory item and click Edit.
  3. In the Product/Service information window, click the Starting value hyperlink.
  4. Click Continue and it will route you to the Inventory Starting Value page.
  5. Change the As-of date and other inventory details if necessary.
  6. Click Save and close.


For more tips and guides while managing your inventory items, we can check this link: Manage your inventory, products, and services in QuickBooks.
 

Additionally, I've added these articles to learn more about the inventory feature in QuickBooks Online:

 

 

You can always get back to us if you need additional assistance with your inventory. Have a great day!

bartymi
Level 1

Can i import an inventory file in to update the inventory in Quickbooks?

if i want to import 100 new product in an on going inventory will it delete my current inventory or it will just update new inventory when i use the import function of quick book online.

Irene R
QuickBooks Team

Can i import an inventory file in to update the inventory in Quickbooks?

Welcome to the Community, @barytmi.

 

Allow me to share information about inventory in QuickBooks Online (QBO).

 

In QBO, when you import 100 new products into an ongoing inventory, it will not delete your current inventory. Instead, new products will be added to the existing inventory list. 

 

Here's how:

 

  1. Sign in to your QuickBooks Online account.
  2. At the upper right corner of your screen, click the Gear icon ⚙.
  3. Under the Tools select Import data.
  4. Pick Products and Services.
  5. To upload your Excel or CSV file, select Browse to upload the file from your computer. Choose the file, and then select Open.
  6. Tap Next.
  7. Map your information. The header of your spreadsheet represents Your Field. Select the one that corresponds to a field in your QBO from each drop-down ▼ menu.
  8. Select Next.
  9. If you notice red marks on the cells, this means that the cell is invalid. Try importing them again after checking the cells in your spreadsheet.
  10. To replace the details of existing items in your account, select Overwrite all values for each product or service with the same name. Make sure everything is correct since we can’t undo it.
  11. Once everything's settled, click Import.

 

Please know that once you have imported the list, it can't be undone. You can only import a thousand rows at a time. If your list is longer than that, split it into multiple and smaller files.

 

You can check this article for more information on importing your product and services list in your QBO account: Import products and services into QuickBooks Online.

 

Moreover, I’ll be adding this article for you to check out on frequently asked questions when importing data in QBO: Common questions about importing data in QuickBooks Online. 

 

Feel free to click "Reply" if you have more questions about importing your data into QBO. I am always here to assist you. Have a great day!

kdy1
Level 2

Can i import an inventory file in to update the inventory in Quickbooks?

I have tried this and I can not get file to overwrite. It just keeps adding another one.

CamelleT
QuickBooks Team

Can i import an inventory file in to update the inventory in Quickbooks?

Allow me to help you overwrite your inventory file, kdy1.

 

In QuickBooks Online (QBO), selecting Overwrite all values for each product or service with the same name replaces the details of the existing item instead of creating a new one. Since this isn't working on your end, I suggest performing basic troubleshooting steps. The stored cache in your browser could be causing this behavior. Start by opening your QBO account in a private or incognito window. Use either of these shortcut keys:

 

  • Mozilla Firefox: press Ctrl Shift P
  • Internet Explorer: press Ctrl Shift P
  • Safari: press Command Shift +N

 

Once you can overwrite the file, return to your regular browser and clear its cache to refresh the system and start with a clean slate. If it still doesn't work, use other supported browsers.

 

For further details about importing a list of your products and services, refer to this link: Import products and services into QuickBooks Online.

 

Moreover, I'll share this article to help you change product and service item types in QBO: Modify item types.

 

I'll be here if you have other questions about updating your inventory or importing data in QBO. Just add a reply below. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us