--- a/admin/updateUNSPSC.php
+++ b/admin/updateUNSPSC.php
@@ -6,6 +6,22 @@
 $unspscresult = mysql_query ("select * from UNSPSCcategories;");
 while ($row = mysql_fetch_assoc($unspscresult)) {
 	$unspsc[$row['Title']] = $row['UNSPSC'];
+	// some Australian spellings
+	$isiz = str_replace("iz","is",$row['Title']);
+	$unspsc[$isiz] = $row['UNSPSC'];
+	$defence = str_replace("efense","efence",$row['Title']);
+	$unspsc[$defence] = $row['UNSPSC'];
+	$center = str_replace("enter","entre",$row['Title']);
+	$unspsc[$center] = $row['UNSPSC'];
+	// some divergence from standard
+	$tobacco = str_replace("Food Beverage and Tobacco Products","Food and Beverage Products",$row['Title']);
+	$unspsc[$tobacco] = $row['UNSPSC'];
+	$architect = str_replace("Building and Construction and Maintenance Services","Architectural services",$row['Title']);
+	$unspsc[$architect] = $row['UNSPSC'];
+	// some just plain wrong
+	$noOilRigs = str_replace("Building and Construction and Maintenance Services","Management and provision of all facilities engineering modification and maintenance services for a site or platform",$row['Title']);
+	$unspsc[$noOilRigs] = $row['UNSPSC'];
+	
 }
 
 $query = "SELECT CNID,category,value
@@ -28,7 +44,7 @@
 	}
 	} 
 } else echo "error".mysql_error();
-asort($missing);
+asort($missing,SORT_NUMERIC);
 print_r($missing);
 ?>