Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I was attempting to do this in the Paste from Excel feature, and using the copy down option. But it copies all the way to the end of the item list. I'm not sure if this is the ideal place to do this, but it is what I was attempting.
Solved! Go to Solution.
Ok, then some things I would try; But make a backup first so you can go back if you mess things up!!
Using the Add/Edit multiple lists feature:
If you know you have 100 subitems that need a different parent item, make sure those subitems are all grouped together in the Add/Edit feature. Then in excel, make a column of 100 cells (exactly the same number as in QB's) that contain the NEW parent name. Select all of those, and Copy. then in QB's, select the first 'subitem OF' name that you want to change, and paste. It will paste exactly as many down as you copied from excel.
Ok, then some things I would try; But make a backup first so you can go back if you mess things up!!
Using the Add/Edit multiple lists feature:
If you know you have 100 subitems that need a different parent item, make sure those subitems are all grouped together in the Add/Edit feature. Then in excel, make a column of 100 cells (exactly the same number as in QB's) that contain the NEW parent name. Select all of those, and Copy. then in QB's, select the first 'subitem OF' name that you want to change, and paste. It will paste exactly as many down as you copied from excel.
You change them one at a time, either in the Table view, by Pasting into Subitem of; or, you edit each and mark Subitem of; or, you Drag their little handles. Or, you export the list, change there, and reimport the list.
Nothing does a Batch, when every time we offer a tool to use, you tell us it is a Subset.
If you go to the Item list, and make sure it is in hierarchical view, then you will see a diamond in front of the items name. If you click a sub item's diamond, and drag it left, it is no longer a sub. Then you can drag it up UNDER the item you want it to be a sub of, and then drag it right to make it a sub.
In the Add/Edit view, select the item type and bring the Subitem OF column into your view. Assign the Parent, right click and Copy Down. Save.
I have the same issue. When I go to Edit > Add/Edit Multiple List Entries ... the "Subitem Of" column I want to edit is greyed out and I cannot make any changes. How can I mass update this field without having to go into each item??
Thanks for joining the thread, @lhoatmaho.
The multi-user mode maybe turned on. This is the possible reason the Subitem Of column is greyed out when editing item lists in QuickBooks Desktop (QBDT). We'll have to ensure your QBDT is in single-user mode as mentioned by @ron4. Here's how to verify it:
Once done, you can now edit the item lists under the Subitem Of column.
Also, you can follow the useful steps suggested by @qbteachmt and @chipoffblock to mass edit these item lists.
Then, you'll want to run the Item Listing report so you can keep track of the latest item info such as their price, cost, quantity on hand, etc. I'll guide you with the steps how:
Also, you're able to customize your reports to get the personalized details and info you want that matter most to your business. Please refer to this awesome resource for the steps on how to do it: How to Customize reports in QBDT?.
Click the Reply button if you need more help with managing your item lists or anything else related to QuickBooks. I'll be here to assist you. Take care and have a great day.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here