Wholesale Producer Directory Website Database and Integration Build Services

Provecho Collective is seeking a vendor to develop a wholesale producer directory website, complete with a cloud-based PostgreSQL database, management tools, and integration services. The project involves designing the relational database schema with key entities such as producer contacts, attributes, certifications, product lists, service areas, and verification statuses. The database must also include comprehensive metadata tracking, role-based access control, and audit logging to ensure robust data security and transparency.

The selected vendor will create a database management tool that enables Provecho Collective administrators to efficiently manage and update data. This tool should incorporate stored functions, procedures, and triggers to streamline maintenance and usability for internal teams. In addition, the website's codebase must feature a seamless integration layer, supporting workflows such as 'claim profile' invitations, verifications, and approvals, as well as manual data imports and user-specific access controls.

This opportunity requires expertise in cloud-hosted PostgreSQL databases, web integration, and the development of secure, user-friendly management tools tailored for data-intensive directory applications.