retrieve product by pid
function to delete product by PID