Visual Integrator Imports can "alter" existing records and can "create" new records.  It can not remove an existing records. They have to be removed manually from the front end or you have to export all the data, manipulate in excel, reinitialize the data table (using extreme caution); then import in fresh data.  Always in a test company first and always with proper backups. 

Visual Integrator Imports can "alter" existing records and can "create" new records.  It can not remove an existing records. They have to be removed manually from the front end or you have to export all the data, manipulate in excel, reinitialize the data table (using extreme caution); then import in fresh data.  Always in a test company first and always with proper backups. 

Thanks for the notes. I use it regularly.

Was hoping for a way like: Update [PriceCode]="A"

I was able to export the records to a csv, made my changes to the csv file, and imported.

All good now.

Thanks again for your comments.

You can, by Product Line...

For VI, use an ODBC source with a silent DSN, pointing at CI_Item (filtered to exclude non-inventory item types)... then hard code the new column value into the import job.