Having troubles with django project on deployment on vercel

This was the problem. Django-heroku comes with psycopg2 therefore you need to uninstall django-heroku for it to work

I recommend you to use the whitenoise library to serve your static files, it works perfectly.

I also wrote a blog about this and provided the solution