Orderzy: Retail Management System

Abstract

Retail management refers to the process which helps the customers to purchase their desired resources from any sort of store service. Online Retail Management System allows the customers to have a good experience and leave the store with a smile. It helps them to shop without any difficulty. It saves the time of customers since they will be able to buy their desired items in one stretch. One can design a ‘Retail Management’ application to help a store gain more customers by increasing their shopping experience to a greater extent. Through this project, the customer will be able to easily login to the application after filling a short and easy registration form, and will be issued with a unique password each time he/she logs in, which is also one of our USP, so in this way no one would have to remember a fixed password, they won’t have to go through long processes to retrieve or create a new password. Your password will be a click away. Browsing through the application is amazingly easy as we have provided different categories on the main screen which on a click show the products available in that category. We at Orderzy, provide our very own payment method through a wallet that can store an amount you would like to use for future purchases.

Introduction

I. INTRODUCTION

A. Problem Definition

Python Project on Retail Management System using SQL

The Retail Store Management System is a system designed for managing i.e., for ordering, arranging and selling goods using E-commerce portal. In this project we have worked on how a user can purchase on a commercial website like Orderzy with different ranges of products and prices. To store the data, we have used SQL along with Tkinter for GUI.

B. What our program basically is…

Electronic commerce, or eCommerce, refers to the purchasing and selling of goods or services via electronic means, such as the Internet or mobile phone applications. It may also refer to the process of creating, marketing, servicing and paying for services and goods. Businesses, governments and the public can participate in eCommerce transactions.

II. IMPLEMENTATION

A. Language Used

1. Python: Python is an interpreted, high-level and general-purpose programming language. Python's design philosophy emphasizes code readability with its notable use of significant whitespace. Its language constructs and object-oriented approach aim to help programmers write clear, logical code for small and large-scale projects.

B. Technology Used

1. IDE(PYCHARM)

a. PyCharm : It is an integrated development environment (IDE) used in computer programming, specifically for the Python language. It is developed by the Czech company JetBrains. PyCharm is cross-platform, with Windows, macOS and Linux versions, but IDE may also be used to develop applications in other programming languages via plug-ins, including Ada, ABAP, C, C++, C#, Clojure, COBOL, D, Erlang, Fortran, Groovy, Haskell, JavaScript, Julia, Lasso, Lua, NATURAL, Perl, PHP, Prolog, R, Ruby (including Ruby on Rails framework), Rust, Scala, and Scheme.

b. Python  for Artificial Intelligence: We use Python because Python programs can be close to pseudo-code. It is designed for humans to read. Python is reasonably efficient. Efficiency is usually not a problem for small examples. If your Python code is not efficient enough, a general procedure to improve it is to find out what is taking most of the time, and implement just that part more efficiently in some lower-level language. Most of these lower-level languages interoperate with Python nicely. This will result in much less programming and more efficient code (because you will have more time to optimize) than writing everything in a low-level language. You will not have to do that for the code here if you are using it for course projects.

c. MySQL: MySQL is the most popular Open-Source Relational Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming.

d. Operating System: Microsoft Windows, commonly referred to as Windows, is a group of several proprietary graphical operating system families, all of which are developed and marketed by Microsoft. Active Microsoft Windows families include Windows NT and Windows IoT; these may encompass subfamilies, e.g. Windows Server or Windows Embedded Compact.

2. Python TKINTER(GUI): Python offers multiple options for developing GUI (Graphical User Interface). Out of all the GUI methods, tkinter is the most commonly used method. It is a standard Python interface to the Tk GUI toolkit shipped with Python. Python with tkinter is the fastest and easiest way to create GUI applications. Creating a GUI using tkinter is an easy task. Tkinter provides various controls, such as buttons, labels and text boxes used in a GUI application. These controls are commonly called widgets.

III. PYTHON CODE & OUTPUT

A. Python Code for Registration Page

B. Python Code for Login Page

C. Python Code for Account Settings Page

IV. MySQL TABLES

Conclusion

In this Python project, we have successfully implemented a prototype of an e-commerce application with the current accuracy being 80%. All the features as seen have been tried multiple times to bring out the best possible solution, the future enhancements would include a mobile application, a website and other algorithms to increase the productivity and usability of the application.

References

[1] https://patents.google.com/patent/US5510979A/en [2] https://www.sciencedirect.com/science/article/abs/pii/S096969891830643X [3] https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=retail+technology+for+stores&btnG= [4] https://www.tutorialspoint.com/ [5] https://stackoverflow.com/ [6] https://www.w3schools.com/

Copyright

Copyright © 2022 Sanyam Aware, Rashi Agarwal, Prof. Gurunath Waghale. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.