Adding multiple items from excel, U/M error

Thanks for posting here, @RoyWeiss,

If you're using the advanced import to QuickBooks Desktop, we have an ongoing issue for users being unable to import items in Excel.

To add your account to the list of affected users and get email notifications, I highly recommend contacting our Support Team. To get our support, follow the steps below:

1. Open QuickBooks and click the Help menu.
2. Select QuickBooks Desktop Help.
3. On the pop-up screen select Contact us.
   
4. Click the Search for Something else button then type your concern in the Ask us anything box.
5. Hit Search then scroll down to get your contact options.

Provide the investigation number INV-37720 to our representatives for faster tracking.

Refer to this article to learn more about our contact options and support availability: Contact QuickBooks Desktop support

As a workaround, you can use the Add/Edit Multiple List Entries or import the items using an IIF file.

The first option allows you to add and edit multiple customers, vendors, and items. Here's how to do it:

1. From the Lists menu, select Add/Edit Multiple List Entries.
2. Select the List dropdown and choose the list you want to work with.
3. Filter the list to see a particular record.
4. (Optional) Select the Customize Columns button to choose which columns you want to see in the Add/Edit Multiple List Entries window. This way, you can easily work on the columns you need. Select the Default button to return to the preset columns for the list.
   1. To add: from the left pane, select a column and select Add.
   2. To remove: from the right pane, select a column and select Remove.
   3. To rearrange the column order: from the right pane, select the column and select Move Up or Move Down.
   4. Select Ok.
      Note: Columns like customer or vendor name are required and cannot be removed. You can only change their order.
5. Add or edit the entries by clicking the appropriate fields. Note that you can copy (Ctrl+C) data from Excel and paste (Ctrl+V) it into this window. You can also Copy down and Duplicate rows (highlight any field and select Copy Down and Duplicate Row)
6. Select Save Changes.

For the complete process of the Advance Import, see this link: Import or export MS Excel files

After saving your changes, you will receive a warning telling you the number of records saved. QuickBooks will also tell you if there are errors that need to be fixed.

For the latter option, follow the steps below:

1. Go to the File menu then Utilities.
2. Pick Import then IIF Files.
3. Use the Import it for me. I'll fix it later link at the bottom.
   
4. Once done, press Import IIF.

Kindly update me on how it goes. I want to make sure you're able to update your items in QuickBooks. Have a good one!