Brazil, September, 05
Project Scope: Advanced Online Product Review Platform

NEW ⇒ Click here to access the step-by-step instructions for assembling the system
Development Platform: Scriptcase Framework | Database: MySQL
This document provides a basic outline of the system, but the platform will be developed in stages. We will only proceed to the next stage once the completed one meets all the client’s objectives.
SYSTEM DEVELOPMENT PROPOSAL:
As requested by the Independent Reference team, we are pleased to present our proposal for the provision of system development services as described below.
The activities will be carried out as follows:
Phase 1 – Data Collection: A detailed assessment of all processes and applications will be conducted. Following this assessment, a schedule of activities will be created in collaboration with the company.
Phase 2 – Development: Based on the data collected in “Phase 1,” the development will begin as described below.
Phase 3 – Testing and Validation: As “Phase 2” progresses, the company’s key users will be able to test and validate the system. This approach allows testing to occur before the full development is completed, making the process more accurate and efficient.
- Integration with a Payment Gateway – STRIPE – for charging clients and managing financial control of Accounts Payable and Receivable, as well as generating Reports related to these activities.
- Multilingual Support: Global Expansion Without Borders.
If the system supports multiple languages, it can operate globally without the need for separate systems. This will enable capturing more reviews from around the world in one central location. Pending Analysis: Possibility of universal payment system
DETAILED ACTIVITIES:
➢ DATABASE MODELING: A database will be modeled with the creation of new tables to support the development of the project. These tables will be created with the supervision and authorization of the area responsible for the project.
➢ SECURITY: A security application will be created with login and password fields for system access. Each user will have permissions according to their access profile.
➢ PARAMETERIZATION: Applications will be developed to allow the key user to parameterize certain system requirements without needing to hire additional development for this action.
➢ QUERIES/REPORTS: A filter and query application will be developed to speed up the search for necessary information.
➢ DASHBOARD: A dashboard with charts will be designed to provide better managerial insight.
➢ NAVIGABILITY: The entire system will be web-based and can be accessed from any device with a browser.
Project Modules:
01.1 Material Collection
This refers to the identification and collection of all materials necessary for the project. This may include documents, references, and any resources that will be used in the development process.
01.2 Design / Screen Prototypes
This involves creating the design (templates) and screen prototypes for the system using Scriptcase. It includes the development of layouts, interfaces, and visualization of how users will interact with the system. These screens will be generated through Scriptcase software. If the client requires the screens to align with their visual identity, a separate proposal for this item will be necessary.
01.3 Database Modeling
This refers to the structuring and creation of the database, including the definition of tables, relationships, and the configuration of the database to support the project’s needs. The database used for this project will be MySQL.
- Auxiliary Records (customer groups, products, questions, answers)
This includes the creation and maintenance of auxiliary records in the system, such as customer groups, product categories, and other information that will assist in the system’s operation and management (combobox).
- Users (groups, access control)
This deals with the configuration and management of users, including the creation of user groups and the definition of permissions and access control. - Clients
This module is responsible for registering and managing clients in the system. It includes creating new registrations, updating information, and querying client data. This is fundamental for organizing and personalizing customer service, allowing for better customer relationships. - The Products module handles the registration and management of products in the system. It includes adding new products, defining categories, updating information, and creating custom questions for each product. This is essential to keep the product catalog up-to-date and organized, facilitating reviews and inventory management. It is a central structure and objective of the entire project.
- Interviewees
- This module is dedicated to the registration and management of interviewees for surveys or interviews. It includes adding interviewee information, updating data, and querying interview histories. This is crucial for organizing collected information and facilitating interview scheduling and analysis.
- Interview Scheduling
The Interview Scheduling module manages the scheduling of interviews with interviewees. It allows setting times, defining platforms, and tracking the progress of the interviews. This module is important to ensure that all interviews are conducted as planned, without scheduling conflicts.
09. Reports / Emails
This module handles the generation of reports and sending emails. It includes creating custom reports based on system data, as well as the automated sending of emails to clients or users. It is essential for performance analysis, client communication, and data-driven decision-making.
10. Integrations (Credit Card, Invoices)
The Integrations module connects the system with other platforms and services, such as payments via Credit Card, Stripe and invoice generation. These integrations enable automation and data synchronization between different systems, facilitating financial and operational management.
11. Testing / Implementation / Training
This module covers the system testing process, final implementation, and user training. It involves verifying functionalities, correcting errors, installing the system in the production environment, and training users to efficiently use the system.
For each project delivery, we will conduct a detailed presentation of the developed modules, followed by practical tests to verify the correct functioning of the implemented features. During these tests, considerations and feedback from the involved team will be collected, allowing for adjustments and improvements before proceeding to the next phase. This ensures the system’s quality and alignment with the project’s needs.
CROMOGAMA
- Business Days:
- 1-2 days: Initial Database Modeling (MySQL).
- 3-5 days: Initial Structuring of the Login Screen, Security and Access Routine, and Initial Management Modules.
- 6-10 days: Finalization of Management Modules and Start of Client Modules.
- 11-13 days: Completion of Client Modules and Start of Evaluator Modules.
- 14-18 days: Testing, Validation, and Adjustments.
- 19-24 days: Start of Base Site for Full Solution Functionality.
- 25-30 days: Completion of the Base System Cycle with Site.
- 31-28 days: Aesthetic Enhancements, Corrections, and Adjustments.
- 29-37 days: Start of Modules for Plan Acquisition and Parameters.
- 38-41 days: Integration with Payment Gateway.
- 42-48 days: Financial Modules for Client and Management.
- 49-50 days: Public Access Release (Live) + Presentation, Training, Validation, Final Testing, and Adjustments with the Sponsor and Stakeholders.
PAYMENT TERMS:
- Upon approval – R$ 15.000,00
- After 30 days – R$ 10.000,00
- Final Payment: U$ 9.200,00
**After testing, with the entire structure meeting the desired specifications.
✓ Confidentiality.
The CONTRACTOR, during the term of this contract and for 3 (three) years after its termination or rescission, is obligated to maintain the utmost confidentiality regarding any data, materials, information, documents, technical or commercial specifications, innovations, and improvements obtained from the CONTRACTING PARTY or entrusted to them due to this contract. This includes any information that is of interest to the CONTRACTING PARTY or third parties. Under no circumstances may the CONTRACTOR disclose, reveal, reproduce, use, or share such information with third parties unrelated to this contract without the prior consent and agreement of the CONTRACTING PARTY.
✓ This proposal does not include server/hosting for the system.
The system is scheduled to be hosted on Microsoft Azure, provided by the client.
✓ Important Note: The platform under development provides a robust framework for system security, database protection, and access control. However, it is of utmost importance that the hosting server, provided by the client, also fulfills its security responsibilities, ensuring the protection and integrity of the data.
PÁGINAS E BANCO DE DADOS
PÁGINA INICIAL
- Menu principal
- Imagem de apresentação
- Camadas e colunas com informações distribuidas, como: Quem somos, o que fazemos, etc
- LOGIN \ CADASTRAR
- Formulário para contato
PÁGINA CADASTRAR CLIENTE
(cada etapa de preenchimento concluído, se abre a próxima etapa. Se possível, uma regua mostrando os títulos das etapas)
- Nome do Responsável
- Nome da Empresa/ Marca
- Informações de contato, endereço, CNPJ
- Upload Logo Marca
- Criação de User ID e Senha
- escolher plano, que pode ser upgrade ou downgrade a qualquer momento
- Informar lista de Entrevistados : Nome e email
*(A equipe da IR poderá sugerir entrevistadores) - Enviar para análise
PÁGINA DO CLIENTE
- Data do Cadastro
- Empresa | Logo marca
- Informações de Contato, Endereço
- Produtos cadastrados | Produtos aguardando entrevista | Produtos concluídos | Cadastrar produtos
- Plano atual | renovar | mudar | pausar
- Lista de Entrevistadores | Adicionar | Bloquear (motivo)
PÁGINA CADASTRAR PRODUTO
- Nome
- Descrição
- Categorizar: Marca, Tipo, Ano/Modelo, …)
- Upload imagens
- Escolher Entrevistado(s)










