public void fillOrder(String orderNum)
    {
	    
	//Called when a customer checks out
	//Query the Orders table 

	System.out.println("Filling order: " + orderNum);

	String queryOrders = "SELECT o.stock_number, o.quantity FROM Orders o WHERE o.order_number = '" + orderNum + "'";

	Statement stm = null;
	try {
	    stm = custConn.getConnection().createStatement();
		
	    ResultSet rs = stm.executeQuery(queryOrders);

	    while (rs.next()) {
		    
		String stockNum = rs.getString("stock_number");
		int qty = rs.getInt("quantity");
		    
		String updateDepot = "UPDATE ProductDepot p SET p.quantity = p.quantity - '" + qty + "' WHERE p.stock_number = '" + stockNum + "'";
		String lowStock = "SELECT x.manufacturer, x.model_number FROM(SELECT p.manufacturer FROM ProductDepot p WHERE p.min_stock_level > p.quantity GROUP BY p.manufacturer HAVING COUNT(*) > 2)temp                                     , ProductDepot x WHERE temp.manufacturer = x.manufacturer AND x.quantity < x.min_stock_level"; 

		    
		try {
		    int rst = stm.executeUpdate(updateDepot);
		} catch (Exception e) {
		    System.out.println("Unable to update eDepot product quantity. Exiting");
		    System.exit(1);
		}
		try {
		    ResultSet rst = stm.executeQuery(lowStock);
		    while(rst.next()) 
			replenishmentOrder(rst.getString("manufacturer"), rst.getString("model_number"), qty);
		} catch (Exception e) {
		    System.out.println("Error sending replenishment order to manufacturer");
		    System.exit(1);
		}
	    }
	} catch (Exception e) {
	    System.out.println("Unable to fill order. Exiting");
	    System.exit(1);
        }
	
	//query database to find manufacturers with 3 products below their min_stock_level


	System.out.println("Ordered filled successfully!");
	

    }