Product Type change in Asset Management in mass?

For a long time our company has been using asset management wrong and i'm trying to clean it up. As such people didn't often care which product type they chose when issuing a PO. For instance our Facilities department would use Building Contractor for everything they did because it sounded closest to facilities.

Now i need to clean this up. I have created the new Product Types and want to assign former products to them. Often times we'll order the same thing over and over, so rather than have the users reenter all the information i would like to just take the product and change it to the new type.

I have found how to do this on a one by one basis, Admin -> Assets -> Products (Select the product), Change the drop down for product type. This works great, but facilities has 1800 products, so it is impossible for me to change them all manually, is there a way to change the in mass, like select a all change product type?

This might not be the best idea, but can i manipulate the database?