Is it possible to mass update Item records by adding a prefix to the Item Name/Number field?

Question

I would like to add a two-letter prifix and dash to the beginning of certain Item Records in the Item Name/Number field. For example, any items from product line A would have Item Name/Numbers that start with PA-

Is there a way to do that in a mass update? Maybe a formula that includes the prefix, then the itemid field?

JohnCirocco · Accepted Answer

@User_1I8SP

You can definitely do this using a CSV import.  Just create a search for the product line you want to change and export to CSV.  Make sure to include the Internal ID and Name field.

Edit the Name to add your Prefix and do a csv import using UPDATE

User_1I8SP · Accepted Answer

Thank you so much! That's what I'll do.