public  static void SetProductAttributeValueByReference(long productID, string attributeReference, string attributeValue) {
     try {
         using (SpHandler sph = new SpHandler("setProductAttributeValueByReference", new SqlParameter("@productID", productID), new SqlParameter("@attributeReference", GetCleanReference(attributeReference)), new SqlParameter("@attributeValue", attributeValue.Trim()))) {
             sph.ExecuteNonQuery();
         }
     } catch (Exception e) {
         LogManager.GetLogger(typeof(Product)).Error(e);
     }
 }