public void receiveShippingNotice(String shipID, String manu, ArrayList<Item> items)
    {
	    // This will have information to populate the Products Depot table, specifically, the 
	    // replenishment amount.

	    // If a new product, have to insert all values. Otherwise, only need to update replenishment.
	for (int i = 0; i < items.size(); i++) {
	    String modNum = items.get(i).modNum;
	    int q = items.get(i).qty;

	    String qry = "SELECT COUNT(*) as count FROM ProductDepot p WHERE p.manufacturer = '" + manu + "' AND p.model_number = '" + modNum + "'";
	    Statement s = null;
	    int c = 0;
	    ResultSet rs;
	    try {
	    	s = custConn.getConnection().createStatement();
	    	rs = s.executeQuery(qry);
	    	while (rs.next()) {
	    	    c = rs.getInt("count");
	    	} 
	    } catch (Exception e) {
	    	System.out.println("Unable to run query. Exiting.");
	    	System.exit(1);
	    }

	    if (c == 0 ) {               //new product
	    	int random1 = (int)(Math.random()*9 + 1);
	    	int random2 = (int)(Math.random()*9 + 1);
	    	int random3 = (int)(Math.random()*9 + 1);
	    	int random4 = (int)(Math.random()*9 + 1);
	    	int random5 = (int)(Math.random()*9 + 1);

	    	String loc = "B" + random3;
	    	String stockNum = "ab" + random1 + random2 + random3 + random4 + random5;
		System.out.println("stock number: " + stockNum + "   manufacturer: " + manu + "    model_number: " + modNum);
	    	String newProd = "INSERT INTO ProductDepot(stock_number, manufacturer, model_number, quantity, min_stock_level, max_stock_level, location, replenishment) VALUES ('" + stockNum + "', '" + manu + "', '" + modNum + "', 0, 1, 10, '" + loc + "', '" + q + "')";
	    	try {
		    //Statement st = custConn.getConnection().createStatement();
	    	    rs = s.executeQuery(newProd);
	    	} catch (Exception e) {
	    	    System.out.println("Unable to insert new product");
	    	    System.exit(1);
	    	}
	    }

	    else {
	    	String updateRep = "UPDATE ProductDepot p SET p.replenishment = '" + q + "' WHERE p.manufacturer = '" + manu + "' AND p.model_number = '" + modNum + "'";
	    	try {
	    	    int rst = s.executeUpdate(updateRep);
		    System.out.println("shipping notice filled replenishment");
	    	} catch (Exception e) {
	    	    System.out.println("Unable to update replenishment");
	    	    System.exit(1);
	    	}
	    }
	}
    }