cancel
Showing results for 
Search instead for 
Did you mean: 
cma887
Level 2

Update Product and Services in QB Online

Hey there, using QB Online, have a few questions around updating the product and services:

 

1.  I can only seem to export a list from the reports section, but it doesn't have all the columns listed in the import template.  Is there somewhere I can export to excel with the same columns as the import section?

 

2.  I only want to update a certain product line.  Can I select and update only certain Items or will the entire list be replaced when I import?  Can I update by sub categories?

 

I need to do a bulk price update for products that are already in our inventory list, for a specific product line/vendor, was looking to export a current list, update in excel, then import the updated list.  

2 Comments 2
MadelynC
Moderator

Update Product and Services in QB Online

I'm here to provide some insights about updating products and services, @cma887.


When you try to update your products and services, you have the option to modify them each or by bulk.


You can directly export your items list under the Products and Services menu. This way, you can select the columns you need to match the import template. Here’s how:

 

  1. Go to the Sales menu, then choose Product and Services.
  2. Select the Filter option.
  3. Select the Status, Type, and Category.
  4. Press Apply.
  5. Click the Small gear icon.
  6. Select the needed columns that match the template.
  7. Select the Export icon.
    Capture.PNG


Please know that importing can replace your list, sometimes make your existing item inactive, and create duplicates, especially if it imports incorrectly.


You can edit your inventory list manually to update a certain product line. I’ll show you how:

 

  1. Go to the Sales menu, then choose Product and Services.
  2. Select the Filter option.
  3. Select the Status, Type and Category.
  4. Press Apply.
    Capture.PNG
  5. Select Edit in the Action column.
    Capture.PNG
  6. Update the price, then Save and close.


You can visit this reference to learn how to import a list of your products and services from Excel or Google Sheets to QuickBooks Online. This provides complete instructions and formatting tips so your list imports correctly.


I’d be happy to help if you have additional questions or concerns with updating products and services. Just drop a comment below. I’ll be here!

cma887
Level 2

Update Product and Services in QB Online

Thank you!

Need to get in touch?

Contact us