public void receiveShipment(String shippingID)
    {
	// The replenishment of the product from the shipping notice is added 
	// to the items current quantity
	
	// Assumes that a new product in the shipment is already inserted in the ProductDepot
	// table in receiveShippingNotice
	
	System.out.println("Receiving shipment...");
	
	String queryShipID = "SELECT * FROM ShippedItems s WHERE s.shipID = '" + shippingID + "'";
	
	
	
	try {
	    Statement stm = custConn.getConnection().createStatement();
	    ResultSet rs = stm.executeQuery(queryShipID);
	    while(rs.next()) 
		{
		    
		    System.out.println("hey");
		    String manu = rs.getString("manufacturer");
		    String modelNum= rs.getString("model_number");
			
		    String keep = "UPDATE ProductDepot p SET p.quantity = p.max_stock_level WHERE p.manufacturer = '" + manu + "' AND p.model_numer = '" + modelNum + "'";

		    String update = "UPDATE ProductDepot p SET p.quantity = p.quantity + p.replenishment, p.replenishment = 0 WHERE p.manufacturer = '" + manu + "' AND p.model_number = '" + modelNum + "'"; 
		
		    String check = "SELECT p.quantity, p.max_stock_level FROM ProductDepot p WHERE p.manufacturer = '" + manu + "' AND p.model_number = '" + modelNum + "'";
	
		    try {
			//Statement st = custConn.getConnection().createStatement();
			int rst = stm.executeUpdate(update);
		      	System.out.println("please work");
		    } catch (Exception e) {
			System.out.println("Error updating product quantity. Exiting");
			System.exit(1);
		    }
		    try {
		    	ResultSet r = stm.executeQuery(check);
		    	System.out.println("whats going on");
		    	//while(r.next()) {
		    	    System.out.println("yo");
		    	    System.out.println("quantity: " + r.getInt("quantity"));
		    	    int qq = r.getInt(1);
		    		System.out.println("good");

		    	    int max = r.getInt("max_stock_level");
		    	    System.out.println("ok");
		    	    if (qq > max) {
		    		System.out.println("good");
		    		try {
		    		    int rr = stm.executeUpdate(keep);
		    		    System.out.println("better");
		    		} catch (Exception e) {
		    		    System.out.println("Error setting stock level to max level. Exiting");
		    		    System.exit(1);
		    		}
		    		System.out.println("too far");
		    	    }
		    	    else
		    		continue;
		    	    //	}
		    } catch (Exception e) {
		    	System.out.println("Error checking max stock level. Exiting");
		    	System.exit(1);
		    }
			
		}
	} catch (Exception e) 
	    {
		System.out.println("Error receiving shipment. Exiting.");
		System.exit(1);
	    }


	 System.out.println("Received shipment successfully!");

    }