How to import inventory adjust in a bulk ?

I understand the importance of bulk adjusting your inventory in QuickBooks Online, dchen16. I'd be glad to show you how.

Instead of making inventory adjustments line by line, we can create an Excel file for the items, make any necessary changes, and then upload the data, which would overwrite the previous entries. You can do this by following the steps below:

1. Create an Excel file. You can download our sample file for reference.
2. Once done, go to the Gear icon and then select Import data.
   
3. Choose Products and services.
   
4. Under Select a CSV or Excel file to upload, browse the one you've created, and click Next.
   
5. Make sure the mappings are correct. Then, hit Next.
   
6. In the Step 3 section, place a checkmark beside Overwrite all values for each product or service that you import with the identical name. (This can't be undone.) box. 
7. Once done, select Import.
   

I understand the functionality to make bulk adjustments within your account is beneficial to your business. I encourage sending a feature request directly to our Product Development team. Doing so helps us improve the features of the program. I'll show you how:

1. Go to the Gear menu and then select Feedback.
   
2. Type in your feature request in the description box.
3. Once done, click on Next.

Thanks for posting here on the Community page. I'm committed to providing you with the best possible experience, and I want to ensure that you're completely satisfied with our assistance. If you have any further questions or concerns, please don't hesitate to keep me posted. I'm here to help and look forward to hearing from you soon.

Hello

Thank for your reply.

However, doing an inventory adjustment by" import product" is not a good way.

It still takes a lot of time.  (I need to know current stock and calculate the final stock)

What I want is there is a way just only for importing the number I want to add or reduce. 

If we can have the simple way, it would be very efficently. 

For example

SKU   ajustQTY

ABC   -10

FED   +20

UYT    -5 

I believe I did it.