Question

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

Forum|Forum|5 years ago
October 15, 2020
2 replies
8 views

No text available

QuickBooks Online

JenoP

QuickBooks Team

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:

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

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

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

M

mandragulaAuthor

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?

Fiat Lux - ASIA

Level 14

@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.

Fiat Lux - ASIA

Level 14

@mandragula

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

M

mandragulaAuthor

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

Fiat Lux - ASIA

Level 14

@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/

Sign up

Login with SSO

Let's get you signed in

Login with SSO