Online Sales And Product Management System

ONLINE SALES AND PRODUCT MANAGEMENT SYSTEM ABSTRACT

This project is aimed at developing an online Sales and Product Management System (SIMS) for a departmental store. This system can be used to store the details of the product, update the product based on the sale details, produce receipts for sales, generate sales and product reports periodically etc. This is one integrated system that contains both the Employee component (used by employee, add employee , product managers, add product, add product category etc) and the admin component (used by the administrators for performing admin level functions such as adding new products , changing the price of an product etc).

CHAPTER I 1. INTRODUCTION

1.1 ABOUT OUT COMPANY

1.2 ABOUT OUR PROJECT Sales and product management system is a software-based business solution used to simultaneously track sales activity and product. Manufacturers and trade resellers can both benefit from a thorough solution, where single transaction entry records necessary details on the customer, products purchased, price and date while also updating product levels.

CHAPTER II 2. SYSTEM STUDY 2.1 EXISTING SYSTEM In the existing system the sales can purchase the products only manual nothing but he went to the supermarket buying the goods in this no reliability after buying the products some time returns is not allowed or if allow every we need go to shops return to the goods it is time consuming process. In farmer days online shopping sites not maintain the all much products. When we want to purchase the products redirect into different sites and buying in case the Employee need to maintain all sites transaction. It is not easy to handle. DRAWBACKS OF EXISTING SYSTEM 

System Crash One of the biggest problems with any computerized system is the potential for a system crash. A corrupt hard drive, power outages and other technical issues can result in the loss of needed data. At the least, businesses are interrupted when they are unable to access data they need.



Complexity



Limited elimination of business risk



Expensive

2.2 PROPOSED SYSTEM This project is to developed for an online Sales and Product Management System (SIMS) for a departmental store. This system can be used to store the details of the product , update the product based on the sale details, produce receipts for sales, generate sales and product reports periodically etc. This is one integrated system that contains both the Employee component (used by employee, add employee , product managers, add product, add product category etc) and the admin component (used by the administrators for performing admin level functions such as adding new products to the product , changing the price of an product etc).

ADVANTAGES of PROPOSED SYSTEM      

Reduced risk of overselling. Greater cost-savings. Avoidance of stock-outs and excess stock. Improved business negotiations. Better product visibility in the event of a recall. The ability to make more profitable business decisions.

CHAPTER III 3. SYSTEM SPECIFICATION 3.1 HAREDWARE REAUIREMENTS Pentium processor

:

233 MHZ

RAM Capacity

:

128MB

Hard Disk

:

20GB

Floppy disk

:

1.44 MB

CD-ROM Drive

:

32 HZ

KEYBOARD

:

3.2

108 Standard

SOFTWARE REQUIRMENT OPERATING SYSTEM : WINDOWS 8 FRONT END

:

PHP

BACK END

: MYSQL

PHP PHP: Hypertext Preprocessor, is a widely used, general-purpose scripting language that was originally designed for web development, to produce dynamic web pages. It can be embedded into HTML and generally runs on a web server, which needs to be configured to process PHP code and create web page content from it. It can be deployed on most web servers and on almost every operating system and platform free of charge. PHP was originally created by Rasmus Lerdorf in 1995 and has been in continuous development ever since. The main implementation of PHP is now produced by The PHP Group and serves as the de facto standard for PHP as there is no formal specification.PHP is free software released under the PHP License, which is incompatible with the GNU General Public License (GPL) because of restrictions on the use of the term PHP

PHP has evolved to include a command line interface capability and can also be used in standalone graphical applications. USAGE PHP is a general-purpose scripting language that is especially suited for web development. PHP generally runs on a web server. Any PHP code in a requested file is executed by the PHP runtime, usually to create dynamic web page content. It can also be used for command-line scripting and client-side GUI applications. PHP can be deployed on most web servers, many operating systems and platforms, and can be used with many relational database management systems. It is available free of charge, and the PHP Group provides the complete source code for Employees to build, customize and extend for their own use. PHP primarily acts as a filter, taking input from a file or stream containing text and/or PHP instructions and outputs another stream of data; most commonly the output will be HTML. Since PHP 4, the PHP parser compiles input to produce byte code for processing by the Zend Engine, giving improved performance over its interpreter predecessor Originally designed to create dynamic web pages, PHP now focuses mainly on server-side scripting, and it is similar to other server-side scripting languages that provide dynamic content from a web server to a client, such as Microsoft's Active Server Pages, Sun Microsystems' Java Server Pages and mod_perl. PHP has also attracted the development of many frameworks that provide building blocks and a design structure to promote rapid application development (RAD). Some of these include CakePHP, Symfony, CodeIgniter, and Zend Framework, offering features similar to other web application frameworks.

About HTML HTML, which stands for Hyper Text Markup Language, is the predominant markup language for web pages. It provides a means to create structured documents by denoting structural semantics for text such as headings, paragraphs, lists etc as well as for links, quotes, and other products. It allows images and objects to be embedded and can be used to create interactive forms. It is written in the form of HTML elements consisting of "tags" surrounded by angle brackets within the web page content. It can include or can load scripts in languages such as JavaScript which affect the behavior of HTML processors like Web browsers; and Cascading Style Sheets (CSS) to define the appearance and layout of text and other material. The W3C, maintainer of both HTML and CSS standards, encourages the use of CSS over explicit presentational markup. Hyper Text Markup Language (HTML) is the encoding scheme used to create and format a web document. A Employee need not be an expert programmer to make use of HTML for creating hypertext documents that can be put on the internet. Most graphical e-mail clients allow the use of a subset of HTML (often ill-defined) to provide formatting and semantic markup not available with plain text. This may include typographic information like coloured headings, emphasized and quoted text, inline images and diagrams. Many such clients include both a GUI editor for composing HTML e-mail messages and a rendering engine for displaying them. Use of HTML in e-mail is controversial because of compatibility issues, because it can help disguise phishing attacks, because it can confuse spam filters and because the message size is larger than plain text. NAMING CONVENTIONS The most common filename extension for files containing HTML is .html. A common abbreviation of this is .htm, which originated because some early operating systems and file systems, such as DOS and FAT, limited file extensions to three letters.

HTML APPLICATION An HTML Application is a Microsoft Windows application that uses HTML and Dynamic HTML in a browser to provide the application's graphical interface. A regular HTML file is confined to the security model of the web browser, communicating only to web servers and manipulating only webpage objects and site cookies. An HTA runs as a fully trusted application and therefore has more privileges, like creation/editing/removal of files and Windows Registry entries. Because they operate outside the browser's security model, HTAs cannot be executed via HTTP, but must be downloaded (just like an EXE file) and executed from local file system ABOUT JAVASCRIPT JavaScript is an object-oriented scripting language used to enable programmatic access to objects within both the client application and other applications. It is primarily used in the form of clientside JavaScript, implemented as an integrated component of the web browser, allowing the development of enhanced Employee interfaces and dynamic websites. JavaScript is a dialect of the ECMAScript standard and is characterized as a dynamic, weakly typed, prototype-based language with first-class functions. JavaScript was influenced by many languages and was designed to look like Java, but to be easier for non-programmers to work with. PROTOTYPE-BASED JavaScript uses prototypes instead of classes for inheritance. It is possible to simulate many class-based features with prototypes in JavaScript. Functions double as object constructors along with their typical role. Prefixing a function call with new creates a new object and calls that function with its local this keyword bound to that object for that invocation. The constructor's prototype property determines the object used for the new object's internal prototype. JavaScript's built-in constructors, such as Array, also have prototypes that can be modified.

Unlike many object-oriented languages, there is no distinction between a function definition and a method definition. Rather, the distinction occurs during function calling; a function can be called as a method. When a function is called as a method of an object, the function's local this keyword is bound to that object for that invocation. USAGE The primary use of JavaScript is to write functions that are embedded in or included from HTML pages and interact with the Document Object Model (DOM) of the page. Because JavaScript code can run locally in a Employee's browser (rather than on a remote server) it can respond to Employee actions quickly, making an application feel more responsive. Furthermore, JavaScript code can detect Employee actions which HTML alone cannot, such as individual keystrokes. Applications such as Gmail take advantage of this: much of the Employee-interface logic is written in JavaScript, and JavaScript dispatches requests for information (such as the content of an e-mail message) to the server. The wider trend of Ajax programming similarly exploits this strength. A JavaScript engine (also known as JavaScript interpreter or JavaScript implementation) is an interpreter that interprets JavaScript source code and executes the script accordingly. The first JavaScript engine was created by Brendan Eich at Netscape Communications Corporation, for the Netscape Navigator web browser. A web browser is by far the most common host environment for JavaScript. Web browsers typically use the public API to create "host objects" responsible for reflecting the DOM into JavaScript. 4.3 MySQL: Overview of the MySQL Database Management System What is MySQL? MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.

The MySQL Web site (http://www.mysql.com/) provides the latest information about MySQL software. 

MySQL is a database management system.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications. 

MySQL databases are relational A relational database stores data in separate tables rather than putting all the data in one big storeroom. The database structures are organized into physical files optimized for speed. The logical model, with objects such as databases, tables, views, rows, and columns, offers a flexible programming environment. You set up rules governing the relationships between different data fields, such as one-to-one, one-to-many, unique, required or optional, and “pointers” between different tables. The database enforces these rules, so that with a well-designed database, your application never sees inconsistent, duplicate, orphan, out-of-date, or missing data. The SQL part of “MySQL” stands for “Structured Query Language”. SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax. SQL is defined by the ANSI/ISO SQL Standard. The SQL standard has been evolving since 1986 and several versions exist. In this manual, “SQL-92” refers to the standard released in 1992, “SQL: 1999” refers to the standard released in 1999, and “SQL: 2003” refers to the current version of the standard. We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time.



MySQL software is Open Source. Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.

The

MySQL

software

uses

the

GPL

(GNU

General

Public

License),http://www.fsf.org/licenses/, to define what you may and may not do with the software in different situations. If you feel uncomfortable with the GPL or need to embed MySQL code into a commercial application, you can buy a commercially licensed version from us. See the MySQL Licensing Overview for more information (http://www.mysql.com/company/legal/licensing/). 

The MySQL Database Server is very fast, reliable, scalable, and easy to use. If that is what you are looking for, you should give it a try. MySQL Server can run comfortably on a desktop or laptop, alongside your other applications, web servers, and so on, requiring little or no attention. If you dedicate an entire machine to MySQL, you can adjust the settings to take advantage of all the memory, CPU power, and I/O capacity available. MySQL can also scale up to clusters of machines, networked together. You can find a performance comparison of MySQL Server with other database managers on our benchmark page. MySQL Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years. Although under constant development, MySQL Server today offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.



MySQL Server works in client/server or embedded systems.

The MySQL Database Software is a client/server system that consists of a multithreaded SQL server that supports different back ends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs). We also provide MySQL Server as an embedded multi-threaded library that you can link into your application to get a smaller, faster, easier-to-manage standalone product. 

A large amount of contributed MySQL software is available. MySQL Server has a practical set of features developed in close cooperation with our Employees. It is very likely that your favorite application or language supports the MySQL Database Server. The official way to pronounce “MySQL” is “My Ess Que Ell” (not “my sequel”), but we do not mind if you pronounce it as “my sequel” or in some other localized way.

CHAPTER IV 4. SYSTEM DESIGN

4.1 INPUT DESIGN Input design is a part of overall system design. The main objective during the input design is as given below: 

To produce a cost-effective method of input.



To achieve the highest possible level of accuracy.

To ensure that the input is acceptable and understood by the Employee Input design is a part of overall system design. The main objective during the input design is as given below: 

To produce a cost-effective method of input.



To achieve the highest possible level of accuracy.

To ensure that the input is acceptable and understood by the Employee The main input stages can be listed as below:  Data recording  Data transcription  Data conversion  Data verification  Data control

 Data transmission  Data validation Data input design is a part of overall system design. The main objective during the input design is as given below:

Keeping in view the above description of the input types and input media, it can be said that most of the inputs are of the form of internal and interactive. As Input data is to be the directly keyed in by the Employee, the keyboard can be considered to be the most suitable input device. 4.2

OUTPUT DESIGN In general are:  External Outputs whose destination is outside the organization.  Internal Outputs whose destination is within organization and they are the Employee’s main interface with the computer. Outputs from computer systems are required primarily to communicate the results of processing to Employees. They are also used to provide a permanent copy of the results for later consultation. The various types of outputs  Operational outputs whose use is purely within the computer department.  Interface outputs, which involve the Employee in communicating directly with the system.

The outputs should be defined in terms of the following points:  Sales person details  Sales manager details  changing the price of an product  product details  Admin details  Category details  Add employee details

 Add brand details  Manage category details  Manage product details  View employee incentive details

It is not always desirable to print or display data as it is held on a computer. It should be decided as which form of the output is the most suitable.

CHAPTER V 5. FLOW DIAGRAM

5.1 DATA FLOW DIAGRA A data flow diagram is tool used to describe and analyze more system. And basis form which the other components are developed. The transformation of data from input to output through processed, may be described logically and independently of physical components associated with the system. These are known as the logical data flow diagrams. The development of DFD’S is done in several levels. Each process in lower level diagrams can be broken down into a more detailed DFD in the next level. The top-level diagram is often called a “context diagram”. Context Diagram: It contains a single process, but it plays a very important role in studying the current system. The context diagram defines the system that will be studied in the sense that it determines the boundaries. Anything that is not inside the process identified in the context diagram will not be part of the system study. It represents the entire software element as a single bubble with input and output data indicated by incoming and outgoing arrows respectively

LEVEL 0

LOGIN

Each employee

Login

LEVEL 1

EMP DETAILS

INSERT NEW EMPLOYEE VERIF Y DATA

REGISTRA TION DETAILS VERIF Y DATA

ADMIN

VERIF Y DATA

INSERT

EMP DETAILS

LEVEL 2

EMP DETAILS

DETAILS

VERIFY DATA

Check

VERIFY DATA

EMP DETAILS

Product

Product

VERIFY DATA

Type

CHECK PRODUCT INFO

CHECK VERIFY DATA

FOR PRO DUCT STATUS

VERIFY DATA

CHAPTER VI 6. SYSTEM TESTING AND SYSTEM IMPLEMENTATION

Testing is a process, which reveals errors in the

program. It is the major quality measure

employed during software development. During software development. During testing, the program is executed with a set of test cases and the output of the program for the test cases is evaluated to determine if the program is performing as it is expected to perform. In order to make sure that the system does not have errors, the different levels of testing strategies that are applied at differing phases of software development are: Unit Testing:

Unit Testing is done on individual modules as they are completed and become executable. It is confined only to the designer's requirements. Each module can be tested using the following two Strategies:

Black Box Testing: In this strategy some test cases are generated as input conditions that fully execute all functional requirements for the program. This testing has

been uses to find errors in the

following categories: Incorrect or missing functions Interface errors Errors in data structure or external database access Performance errors Initialization and termination errors. In this testing only the output is checked for correctness. The logical flow of the data is not checked.

White Box testing: In this the test cases are generated on the logic of each module by drawing flow graphs of that module and logical decisions are tested on all the cases. It has been uses to generate the test cases in the following cases:  Guarantee that all independent paths have been executed.  Execute all logical decisions on their true and false Sides.  Execute all loops at their boundaries and within their operational bounds  Execute internal data structures to ensure their validity. Integrating Testing: Integration testing ensures that software and subsystems work together a whole. It tests the interface of all the modules to make sure that the modules behave properly

when integrated

together. System Testing: Involves in-house testing of the entire system before delivery to the user. Its aim is to satisfy the user the system meets all requirements of the client's specifications. Acceptance Testing It is a pre-delivery testing in which entire system is tested at client's site on real world data to find errors. SYSTEM IMPLEMENTATION The user wills entire a uniform resource locator (URL) into his/her browser as a request for a Online sales and product management system webpage. The browser will forward the request to the web server, which will use the path portion of the URL to determine the file to be returned to the browser or the PHP script will be activated, the script will use sql queries to insert, update and retrieve the data from the Online sales and product management system database tables, and return the data to the browser as an html formatted document. The html document will be return

to the browser will contains hyperlink to other html pages to PHP script to the web server. In this way the user will able to navigate among various pages in employee product information management system. The user interface of the Online sales and product management system will consist of any web browser will enable the employee to navigate the website. There are two types of employee associated with in product information process: the employees and admin. Product managers not part of the user since the order of product information is still on manual basis and once order it will be encoded by the administrator. Hence the system will be dividing into two main interfaces. Upon entering the website, employee will be greeted by the homepage the employee

product

information management system, which has a link of the login page of the product information management system. When the user login the system, he/she will be transferred to their respective interface depending on the type of user he/she is. Employee interface 

Login page



Employee information page



Add employee page



Employee incentive page



Add product page



Add order page



Generate report page



Add category details

Administrator interface 

Login page



Home page



Update product information page



Update product list page



Update the order details



Update employee details

CHAPTER VII 7. CODE DESIGN 7.1 SYSTEM MAINTENANCE Automate Your Product and Order Processes, Make Informed Business Decisions. Accounting Integration. Better Shipping Options. Barcode Management. Order Management. Multichannel Selling. CRM Integration. Services: Product Control. 7.2 CODING METHODOLOGY The purpose of code is to make the task easy for identification and retrieval of items of information when there are several items in the group. In any computer system, data to be processed have codes so that sorting, retrieving, storing etc will become efficient. Codes are necessary because •Data is easily identified •Data is simplified and standardized. Hence the numbers of mistakes are reduced to the extent possible. •Data processing operations can be done easily •It helps to make the computer system work more efficiently Online sales and online sales and Inventory management System sufficiently to determine the feasibility and usability of a finished system. The core concept is to track the sale of products from the cash registers with additional features for interpreting the data. It uses a client-server

model with a connected database to allow multiple stores and warehouses to be connected. This allows for later expansion while still supporting the targeted small businesses

CHAPTER VIII 8. CONCLUSION

Online sales and Inventory management has to do with keeping accurate records of goods that are ready for shipment. This often means having enough stock of goods to the inventory totals as well as subtracting the most recent products of finished goods to buyers. Online sales and Inventory management is essential to every company, having inventories. Companies need to have stock, but in such amount to avoid out-of-stock and overstock situations. Online sales and Inventory management can improve company’s inventory control existing situation and decrease costs of the company. Agent system, in turn, proposes the automation of this process, it can support several forecasting methods and it reacts to changes in the environment existing online sales and Inventory management situation is analyzed, twofold improvement is proposed – to use online sales and Inventory management with the aim to decrease company’s inventory level and holding costs by avoiding overstocks and to apply the agent system in order to automate the online sales and Inventory management processes and to timely react to demand deviations from the forecasted demand by making corrections in replenishment policies. According to experiments, it can be concluded that timely reaction to changes in the environment can propose better results. This can be done by a human or decision support system comparing the forecasted demand with real and making corrections in orders, or this can be done by an agent as it is proposed here.

CHAPTER IX 9. APPENDIX 9.1 DATABASE DESIGN A Database is a collection of interrelated data stored with a minimum of redundancy to serve many applications. The database design is used to group data into a number of tables and minimizes the artificiality embedded in using separate files. The tables are organized to: 

Reduced duplication of data.



Simplify functions like adding, deleting, modifying data etc..



Retrieving data



Clarity and ease of use



More information at low cost

Stock storage

Product list

Product name

quantity

Product id

Add

Id

Product id

Deta ils

Bar code

Orders order id date completed date required

Suppli ed

category

Product desc product name

employee Req uest

Emp id Mobile no Age

bar code

Address Has

Gender Emp name

9.1 ER DIAGRAM

TABLE DESIGN

TABLE NAME: ADMIN

Field name

Data type

size

User name

varchar

10

Password

varchar

10

TABLE NAME: EMPLOYEE

field name

Data type

size

Emp id

int

10

Emp name

varchar

250

Salary

Int

10

Mobile

int

10

Gender

varchar

200

Age

int

10

Address

text

-

field name

Data type

size

Product name

varchar

100

TABLE NAME: PRODUCT

Quantity

int

10

brand

varchar

100

category

varchar

100

status

varchar

200

TABLE NAME: CATEGORY field name

Data type

size

Category name

varchar

100

status

text

-

field name

Data type

size

Order date

timestamp

-

Emp id

int

10

quantity

Int

10

Client name

varchar

100

Order date

Time stamp

-

TABLE NAME: ORDER

9.2

FORMS AND DESIGN

Username : admin Password : admin

CHAPTER X BIBLIGRAPHY BIBLIOGRAPHY Book Name: PHP6 and MySQL Author Name: SteveSuehring, TimConverse, and Joyce Park Websites •http://www.w3schools.com •http://www.quibids.com •http://www.ubid.com •http://www.i-bidder.com •http://www.redbid.com