Skip to main content
L
lynnphtr1
March 11, 2024
Question

Update Inventory Quantity By Importing Excel Worksheet & Bundle Import

  • March 11, 2024
  • 3 replies
  • 0 views

Hi,

 

I have a client that performs an inventory physical count every month. He has hundreds of SKU lines so it would be challenging if I have to manually update inventory quantity in QBO.

He provides us the inventory quantity for each SKU by the end of the month. Is there anyway that we can upload the new Quantity with matching SKU to QBO without doing it manually?

 

I have over 1000 bundles need to enter in QBO as well. I know QBO doesn't have a function to import bundles. Do you recommend any 3-party apps that can help to do that? Manually entering 1000+ bundles will be very time consuming. I see the discussion since 2018 requesting for this but don't know why QBO ignores it. 

3 replies

J
JamesM4
March 11, 2024

Hi tlynnphtr1,

 

Thanks for reaching out to us here. QuickBooks is a versatile program that helps you streamline your work using the powerful features offered in the program. Rest assured, I'll be happy to share more info so you're on the right track. 

 

The function you've described isn't available in QuickBooks. I can see the benefit of having this function and I encourage you to send feedback about this to our engineers. You can send feedback by clicking on the Gear icon and looking for Feedback. New product ideas and improvements are based on the feedback we get from users like you. I also recommend looking into third-party apps on our app store www.apps.com. 

 

Let me know if you have other questions by leaving a comment below. I'll be one message away. 

 

Zed Axis
Zed Axis
April 4, 2024

Hi @lynnphtr1 whilst it is not possible to do that at the moment in QuickBooks Online to import in batch inventory adjustments from an Excel worksheet. 

 

It is possible to do that using one of the data import utilities called Zed Axis that you can find in the QuickBooks apps marketplace , there is a page that describes the process to do that and included all the data values you need.

 

Hope that gives you another option.

G
Grace H
April 4, 2024

Hey @lynnphtr1,

 

You should Contact Direct QuickBooks Help Desk team at 𝟾o o 𝟾𝟺𝟻 𝟿𝟼𝟼𝟼

 

Thanks

Terms & ConditionsAccessibility statement