Update Quickbooks Item and MPN Fields With Upload

Hi there, DCBUS.

I'm aware that importing files can save time when it comes to updating the information. I can share information about this that can help.

Yes, it's possible. When importing Excel files, the software finds duplicate entries automatically. The following option will be offered to you:

• Keep the existing data and discard the import data.
• Replace the existing data with import data, ignoring blank fields.
• Replace the existing data with import data, including blank fields.

After that, you can choose the appropriate option. Please ensure that your Excel files include the most recent Manufacturer's Part Number(MPN). Also, create a backup copy of your company file before importing to make sure you have a file to refer to if something goes wrong.

For your convenience, I've got this article for more information and guide: Import or export MS Excel files.

In addition, you can review this resource to learn how to updates the inventory quantities and value as you track every purchase and sales: Adjust your inventory quantity or value in QuickBooks Desktop.

You're always welcome to post a reply if you need further assistance managing your inventory items. I'll get back to you as soon as possible. Stay safe!

Hello,

Thank you for the suggestion, but it did not work. Please see image attached. Prior to my import, the Item and MPN was (FMh- Alberto Fermani-FE5787). I wanted to import and change them to (FMH-SHOES-17). But after the import, it actually created a new listing with the Item and MPN (FMH-SHOES-17). I did not get a popup to ask to replace.

Thank you JR

Thanks for coming back here and for including a screenshot, DCBUS.

I've looked into the details of the screenshot, and it seems that no details of the old item are included. For example, the item's old name or MPN. This might be the reason why you're not getting any prompt to replace, and QuickBooks added the item as a new listing.

Since the item is already added in QuickBooks, what you can do is edit or delete it. 

Here's how:

1. Go to Lists located at the top.
2. Select Item List.
3. Right-click on the item and choose either Edit Item or Delete Item.

For reference, check out this guide: Add, edit, and delete items.

In the meantime, you can copy your data from Excel. Then, paste it into the Add/Edit Multiple List Entries window to expedite the process. Here's an article for the instructions: Add and edit multiple customers, vendors, and items.

Please don't hesitate to reach out to us again. Me and my colleagues are here to help. Stay safe!