I would like to add UPC numbers to my items, as well as update prices and add missing data to many of my inventory items. I have 6000+ items. I have used IIF in export mode, so I am familiar with the inventory file. After I have updated my items in the IIF file thru Excel, can I import just the changed items (ie., partial file update), or should I import the entire IIF file? I am using QB Pro Desktop 2016.
Welcome and thank you for posting here in the Community, @zippospeedcat.
Let me help share information about importing/exporting Intuit Interchange Format (.IIF) files.
Yes, you can import just the changed items as long as you don't make any changes on other fields or other items. On the other hand, you can also import the entire IIF file.
In addition, you can modify items in the Add/Edit Multiple List Entries page under the Lists menu if the columns are available under Customize Columns.
For additional reference about importing/exporting IIF files, you can check this article: Export or import Intuit Interchange Format (.IIF) files.
Feel free to add a comment below if you have any other concerns about importing IIF files. I'll be happy to help you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.