python Programming

NOTE: Please open the file in python for better understanding.

Stationery Store Management System, designed to manage inventory, sales, and customer transactions. Here's a detailed description:

Purpose

The script is a simple, menu-driven application that helps manage a stationery store's operations. It includes functionalities for administrators to handle inventory and for customers to browse and purchase items.

Key Features

1. Database Management

• Database Initialization:
  • Creates a MySQL database named sales_vdo.
  • Defines three tables:
    • login: Stores admin credentials.
    • purchase: Records customer purchases with details like date, product code, and amount.
    • stock: Tracks inventory with details like product code, name, quantity, and price.

2. Admin Panel

Admins can perform various operations to manage the store:

1. Add New Items:
   • Insert product details (code, name, quantity, price) into the inventory.
2. Update Price:
   • Change the price of an existing product.
3. Delete Items:
   • Remove an item from the stock.
4. View Stock:
   • Display a list of all items, including product codes, names, quantities, and prices.
5. Change Password:
   • Update the admin login password for security.
6. Logout:
   • Exit the admin panel.

3. Customer Section

Customers can interact with the system to:

1. Item Bucket:
   • Add items to their cart by specifying the product code and quantity.
   • Updates the stock quantity automatically after purchase.
2. Payment:
   • Calculates and displays the total amount payable for selected items.
3. View Available Items:
   • Lists all items in stock with their details.
4. Go Back:
   • Navigate back to the main menu.

4. Exit Option

Allows users (both admin and customers) to exit the application.

Technical Highlights

• MySQL Integration:
  • The script uses MySQL for data storage and retrieval, ensuring data persistence and real-time updates.
• Error Prevention:
  • Includes input validation to avoid incorrect data entries.
• Modular Design:
  • Features distinct menus for admin and customer roles, making the program user-friendly and organized.

Use Case

This script is ideal for educational purposes, small-scale stationery stores, or as a prototype for learning inventory and sales management systems. It combines basic CRUD operations with an easy-to-use interface for practical utility.