Request for Developing a Stock Management Program

[AMGhanou]

Hello,

I would like to develop a simple program to manage my stock. Below are the main features I need:

1. Serial Number Tracking
   Each product should be registered with a unique serial number.
   The serial number will be used to track the history of purchases and sales.
2. Core Features
   a. Purchase Management
   Entering a new product during purchase, with the following details:
   Product Name (automatically generated once the serial number is entered).
   Serial number.
   Purchase date.
   Supplier (name or related information).
   b. Sales Management
   Recording a sale with the following details:
   Serial number (the product will be automatically identified using this number).
   Customer (name or related information).
   Sale date.
   Sale price.
   c. Stock Consultation
   Display products in stock with their serial numbers.
   Filter products by name or addition date.
   d. Transaction History
   Display the complete history of purchases and sales.
   Search by serial number to view the history of a specific product.
3. User Interface
   A simple and intuitive interface, which can be:
   A desktop application (e.g., using Python with Tkinter or PyQt).
   A web application (e.g., using Django or Flask).
4. Database
   Use of a database to store the information:
   SQLite for a lightweight solution.
   MySQL or PostgreSQL for a more robust solution.
5. Reports
   Generate simple reports:
   List of products in stock.
   Summary of sales and purchases over a specified period.
   Please provide a proposed solution, including a development timeline and cost estimate.

Best regards,