Sage X3

What would be the safest way to mass update the pricing for all the product in the system. On the product site- Under the cost tab I want to update Standard cost for all the products.

One of the department is hoping to update Boms in relation to a particular field. That field is scrap on the BOM. I have access to SQL. But Before I do anything I wanted to know how others have done it or what would be the best practice.