#set($distributorsearcher = $searcherManager.getSearcher($catalogid, "distributor")) #set($level = $context.getRequestParameter("level")) #set($goodlist = $context.getRequestParameter("goodlist")) #set($badlist = $context.getRequestParameter("badlist")) #set($totalsize = $badlist.size() + $goodlist.size())

Total Number of Products - $totalsize

Search Criteria - $level #if($level != "0") or less #end

Bad Product List - Total Number of Products - $badlist.size()

#foreach($product in $badlist) #set($id = $product.getId()) #set($name = $product.getName()) #set($d = $distributorsearcher.searchById($product.get("distributor"))) #set($dname = $d.getName()) #set($rogerssku = $product.get("rogerssku")) #set($manusku = $product.get("manufacturersku")) #set($upc = $product.get("upc")) #set($item = $product.getInventoryItem(0)) #set($qty = $item.getQuantityInStock()) #end

Product ID	Product Name	Distributor	Rogers SKU	Manufacturer SKU	UPC Code	Qty in Stock
$id	$name	$dname	$rogerssku	$manusku	$upc	$qty

Good Product List - Total Number of Products - $goodlist.size()

#foreach($product in $goodlist) #set($id = $product.getId()) #set($name = $product.getName()) #set($d = $distributorsearcher.searchById($product.get("distributor"))) #set($dname = $d.getName()) #set($rogerssku = $product.get("rogerssku")) #set($manusku = $product.get("manufacturersku")) #set($upc = $product.get("upc")) #set($item = $product.getInventoryItem(0)) #set($qty = $item.getQuantityInStock()) #end

Product ID	Product Name	Distributor	Rogers SKU	Manufacturer SKU	UPC Code	Qty in Stock
$id	$name	$dname	$rogerssku	$manusku	$upc	$qty