Hello! 

We run QuickBooks Enterprise Solutions: Retail on Desktop.

We have about 5,000 items for which we need to change only our Cost, Price and List Price values. We have a third-party import solution that, while it has worked well in the past, is throwing errors and while we have been working with that utility vendor's tech support, that process is taking too much time and it's important that I get these changes made ASAP.

I have already attempted to accomplish this process using the native QB  via File>Utilities>Import>IFF Files path where I downloaded a full IFF item file, made the necessary changes only to those values, and uploaded the new IFF file, but the results were not good (the pre-existing values in other pre-existing fields in which no changes were made were wiped out entirely, etc.). So I rolled back to my backup and need to start again some other way.

Is there another way I can update the values on these three fields for these 5,000 Items quickly and accurate without messing up any other values for these Items? Thanks!

EDIT: I subsequently discovered the Add/Edit Multiple List Entries functionality. However, while it seems like very easy to use this to Add a large number of new items, using it to Edit existing items seems more difficult (unless you consider "mulitple items"defined as 10 or 20 that you can do manually on the screen, instead of the 4,000 unique prices that need to be changed, as in my case.)