We have product IDs that contain text but the "item ID" field in the database tables only accept integers. Would it be possible to change the field type to text? Or is it not wise to do so because of all the table fields that would have to be changed?

Nevermind, guess I answered my own question, I got someone here to change the product IDs to integers.