Skip to main content
November 20, 2022
Question

Can I merge 2 inventory items? If so, how?

  • November 20, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Nicole_N
November 21, 2022

Hi there, @placeintimeclock.


Allow me to provide you with some information about merging inventory items. 

At this time, the system only allows you to merge services and non-inventory items. This is because the inventory items are affecting the Inventory/Asset accounts and have Quantity On Hand that requires correct tracking of your data.

If there are duplicate items that you won't be using in QBO, it'd be best to make them inactive. To do that, follow the steps below.

 

1. Go to the Sales menu.

2. Select Products and Services.

3. Find the product or service that you want to make inactive.

4. From the Action column, drop-down menu, click on Make inactive.

5. Click on Yes.

I appreciate the idea of merging two inventory items. I'll take note of this.

 

Please know that our developers are constantly working and considering new options to be added to the system. This way, we'll be able to make the product work according to your business needs.


Aside from services and non-inventory items, you can also merge lists such as accounts, customers, and vendors in QuickBooks Online.

Feel free to click the REPLY button if you have further questions about merging items in QuickBooks Online. I'd be glad to help you out. Take care and have a good one!

January 19, 2023

Follow up.

 

If you are unable to merge 2 inventory items, and is only allow to Make 1 Inactive.  If both have inventories, do we just make QT 0 for the inactive, and then add QT 10 to the active to balance everything out?

January 19, 2023

Thanks for joining the thread, Erss.

 

I'll chime in and share some information with you. 

 

In QuickBooks Online, since you're unable to merge two inventory items and can only make one inactive, you'll want first to ensure that the inventory quantities for the inactive item are accurate before making it inactive.

 

Then, you can make the inactive item's quantity zero and add that quantity to the active item to balance everything out. This will ensure that your inventory counts and values remain accurate in QuickBooks. I'll show you how: 

 

  1. Select Settings ⚙ and then Products and Services.
  2. Find the inventory item. Then select Edit from the Action column.
  3. In the Quantity on hand section next to Adjust, select Quantity.
  4. In the Inventory Quantity Adjustment window, enter 0 in the New Qty column.
  5. Select Save and close.

 

Once done, continue following the next steps to ensure that your books are balanced. Please refer to the steps under Adjust inventory items in this article: Change product and service item types in QuickBooks Online.

 

You can also visit this article to learn how to group your products and services in QBO: Group your products and services into different categories.

 

Feel free to reach us again for further concerns. Stay safe!