Is it possible to make bulk edits to Inventory with a spreadsheet?

Good day, miketropical.

The option to edit multiple inventory items using the spreadsheet is unavailable. You can use the Batch Actions drop-down to adjust the quantity or reorder point.

Here's how:

1. Go to the Gear > Products and Services.
2. Click the Filter icon and select Inventory from the Type drop-down menu.
3. Select Apply.
4. Put a check mark on the inventory items you want to modify, and then click the Batch Actions drop-down menu.
5. Choose Adjust quantity or Reorder.
6. Make the changes and hit the Save and Close button.

I've got a sample screenshot for reference:

Furthermore, you can edit the item one at a time.

I'm just a few clicks away if you need more help with QuickBooks Online. Take care and stay safe.

@miketropical 

Utilize TP Importer

https:// transactionpro.grsm.io/qbo

Hi There,

I have imported inventory via qbo spreadsheet but forgot to add categories. Can I update my spreadsheet and upload everything again with the spreadsheet to override previous import?

Yes, you can update it, Nicolene.

Once you uploaded a file that contains products that are already in QuickBooks Online, you'll receive this message: Overwrite all values for each product or service that you import with the identical name. All you have to do is check the box below the message before clicking Import.

If the file you're going to re-import has a different quantity, QuickBooks Online will create an automatic Inventory Adjustment. You can check the detailed steps here: Import products and services into QuickBooks Online.

I'd be glad to help you if you have other concerns. Have a great day!

I don't see a way to edit the reorder point. When I select inventory and click the Adjust Quantity batch action, it doesn't have a place to edit the reorder point in the Inventory Quantity Adjustment page. And the Reorder batch action creates a purchase order to buy more, which I don't want to do. I just want to bulk adjust the Reorder Point setting.

How can I do that?

Thanks,

Don

Hello there, @donkiely. I got here steps to help you adjust the reorder point of your inventory in QuickBooks Online (QBO).

The option to bulk edit the reorder point of the inventory list is unavailable in QBO. You can only edit the reorder point settings for each item manually. Here's how:

1. Select the Sales menu and choose Products and Services.
2. From there click the Edit option of the inventory item you need to edit.
3. Then, go to the Reorder point section and enter the new information.
4. Once done, select Save and Close. 

For reference, feel free to check this article: Reorder inventory or supplies from vendors.

It's also easy to monitor your inventory item by running the Inventory Valuation Detail report.

If you have any other concerns managing your inventory in QBO, please don't hesitate to leave a reply below. Have a good one and stay safe.