I need to bulk edit my products, is there an easy way to do this? I need to change the VAT code... theres over a 1000 products

I'll help with your question about editing products in QuickBooks Online, mandragula.

For now, the Batch Action feature for inventory items only include making them inactive, adjusting quantity on hand, reordering, and making them into non-inventories or service items. In the meantime, you'll need to open each item and make your changes one at a time.

Here's how:

1. Go to the Gear icon and select Products and Services.
2. Select a product or service that you want to edit, then click Edit under the Action column.
3. Go to the VAT code section and make your changes.
4. Click Save and close afterwards.

Let me share these articles about managing products and services for more details:

• Edit A Stock Quantity Adjustment
• Change Product And Service Item Types In QuickBooks Online
• Change The Account For A Product/service item

As always, you can count on us anytime you need help with QuickBooks.

@mandragula 

QBO has a limited feature for inventory management. Once you manage more than 100 products, consider having an inventory management app.

thank you, I didn't know such a thing existed. Do you have an app recommendation?

thank you for your response.

The work around I was trying is to download the products onto a spreadsheet, edit the spreadsheet and then upload it again. However there is not an option to 'update existing products with the same sku' the file will not upload because the products already exist in QBO. I tried to make products in QBO inactive but the new products with the same name did not 'replace' the previous products so all the previous sales data on the products was lost. I can see that it is not possible at the moment to do this but if there was a button when importing a spreadsheet that can be ticked to say 'update existing products with the same sku' then that would be extremely useful - is it possible to put this idea forward?

---

@mandragula wrote:

thank you, I didn't know such a thing existed. Do you have an app recommendation?

---

Intuit has acquired one inventory management app as part of the family recently.

https://go.tradegecko.com/register?code=fiat-lux

You may compare it with another app

https://www.zaperp.com/ref/25/

---

@mandragula wrote:

thank you for your response.

The work around I was trying is to download the products onto a spreadsheet, edit the spreadsheet and then upload it again. However there is not an option to 'update existing products with the same sku' the file will not upload because the products already exist in QBO. I tried to make products in QBO inactive but the new products with the same name did not 'replace' the previous products so all the previous sales data on the products was lost. I can see that it is not possible at the moment to do this but if there was a button when importing a spreadsheet that can be ticked to say 'update existing products with the same sku' then that would be extremely useful - is it possible to put this idea forward?

---

We are unable to delete any List data or modify it in bulk. We have yet to find any workaround to solve this issue.

These are nonsense recommendations - and require spending even more money on another application that QBO should have as standard.

These are selling shops.....and not what we need....As the authors has said - they want to export to Excel and upload the changes as we and all the other stock users want....

These are nonsense recommendations - and require spending even more money on another application that QBO should have as standard - 

These are selling shops.....and not what we need....As the author of the questions has said - they want to export to Excel and upload the changes as we and all the other stock users want....

Hello Community Users, We just wanted to add to this thread that some bulk edits can be done by your accountant, using the reclassify tool. It is possible to bulk reclassify VAT on  transactions but not products. We'll leave a link to the reclassify article here  which may be helpful.