Question

Bulk edit

Forum|Forum|2 years ago
February 22, 2024
2 replies
43 views

I spent days trying to bulk edit existing products in QuickBooks Online, then the Customer Support confirmed that it is not an existing feature. All I can do is update the thousands of items' sales and purchase prices one by one. The import csv/xls function doesn't work, as it keeps giving me the error message that these items already exist.
It's such an essential feature. These data keep changing all the time. How can users deal with this issue? Profit and Loss reports will give a false result if these data can not be updated.
Am I missing something?

QuickBooks Online

JaeAnnC

Level 6

Hello there, @TimiAdler.

Currently, batch editing your existing products and services in QuickBooks Online (QBO) is unavailable. However, you can update their costs and prices by uploading a CSV file into the program. Make sure to tick the Overwrite all values for each product or service that you import with the identical name checkbox so you won't be prompted with an error message.

Here's a detailed step-by-step guide:

Go to the Gear icon and select Products and Service.
Click the New dropdown, then Import.
Select Browse to upload the CSV file, then click Next.
Review the mapping of the column headers, and click Next.
On the import stage, check the Overwrite all values for each product or service that you import with the identical name box.
Click Import.

I'll share this reference for your guide: Import products and services into QuickBooks Online.

I understand the need for the bulk editing feature in QBO to streamline the process of updating your products and services. Please know that we listen to customer feedback to help enhance your QBO experience. That said, let me help you relay your valuable insight to our software engineers by clicking the Gear icon and selecting Feedback. This way, they can review your suggestion and may consider incorporating it in our future product updates.

Additionally, you can set price rules in QBO to control the prices of your items. By doing so, you can offer discounts or charge different rates based on which employee did the work.

Keep in touch if you have additional concerns about importing your products and services. The Community team is here to offer you a helping hand. Stay safe.

D

Dura Trailers

It would be great if you could bulk edit the products and services. I tried the feedback button a couple of times in the past as well, however nothing happens when I click on the button. I must be honest there where much nicer features on the desktop system. It would be nice when you are in an expense or bill and you could click on the item and edit it from there as well

J

JamaicaA

QuickBooks Team

Editing products and services in bulk, as well as modifying transaction items, can greatly enhance efficiency, Dura. Let's collaborate to perform some troubleshooting to ensure we can send your feature request successfully.

I truly appreciate your efforts to provide feedback. Since the button is currently unresponsive, please try accessing your QuickBooks account via an incognito or a private window. This mode doesn't retain cache, so it's a good place to verify a webpage issue. Here are the keyboard shortcuts you can use:

For Firefox, press Ctrl + Shift + P
For Chrome, press Ctrl + Shift + N
For Safari, hold down Command + Shift + N

If it works, I recommend clearing your browser's cache to start fresh. Additionally, consider utilizing other supported browsers as an alternative to your regular one.

Moreover, QuickBooks Online and the Desktop version are different products, which is why there are variations in their features. Meanwhile, I encourage you to resend your suggestions to our Product Development Team. Your ideas are valuable to us and help improve our processes. I'll show you how:

Go to the Gear icon at the top.
Under the Profile column, select Feedback.
Share your recommendation with the product, then click Next.

For reference, you can save these instructions on offering discounts or changing rates by item: Set price rules in QuickBooks Online.

Scan this article to understand the taxability of items further: Add a sales tax category to products and services in QuickBooks Online

We aim to cater to your needs and provide convenience. For any other concerns about items, expenses, and bills, add them below. We'll be here to assist you.

E

EvethC

QuickBooks Team

Thank you for participating in this thread, @CJ Consulting1. Managing a business requires significant responsibilities, and keeping organized records can greatly simplify the task. Don't worry, everything will work out fine. We're in this together and will overcome this challenge as we have with others.

The "Also update this account in historical transactions" option for overwriting details of existing items with the same name and category specifically applies to service and non-inventory items. This checkbox does not appear for inventory items because historical transactions for inventory automatically update when the account is changed.

I'd be happy to provide you with an image to visually demonstrate this feature.

I will also attach an article that will guide you whenever you need to add a sales tax category to products and services in QuickBooks Online.

Before making any changes, it is recommended to seek advice from an accounting professional or a QuickBooks expert to ensure that the method you choose adheres to your specific needs and complies with accounting standards.

In case you require additional assistance with your products and services, this article offers more insights and instructions, along with detailed steps to ensure you are well-guided: Manually add transactions to account registers in QuickBooks Online.

We'd love to hear about your progress. Please feel free to click the Reply button below and keep in touch with the Community for any further assistance you may need with updates on your products and services. We are here to support you.

C

CJ Consulting1

I know how to do this on a product-by-product basis, with the screens you showed. But we want to do a bulk update, and actually, it's only for non-inventory items (there were just earlier comments from users with inventory items on this thread about bulk updates). What we do want is to do a bulk update by importing a CSV file, and in doing so, also the account in historical transactions. I don't see a checkbox for that on the import screen.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded