ABSTRACT

          This project is developed for the automation process of  shopping throw  online i.e  through web. In marchant  module adding the catogories, products,      itemSales, giving  orders, Stock maintenace , creating  invoice(bill) for orders,  shipping of items order given by customer. creation,   details , and other  transactions like automatic increment,decrement  of stock,  paid  invoice(amount),shipping invoice And all other transactions for large scale    whole sale or retail sales, very big shops, or organizations.this project is  developed in N- Tier arcitecture and  distributed environment using distributed  technologies like EJB etc.  

           This project mainly contains 3 modules like Marchant module, Customer  module, invoice module. In customer module customers will give orders for  items  which are being available in that shop. In our project that order is  processed and details are stored in data  base. In invoice module total bill for  ordered items will be created. In case if the ordered items are not being  shipped at a time then the pending order details will be processed and the bill  for the pending order will be created. In Marchant Module  products are being  maintained in category wise and product wise, item wise and up to date stock  will be maintained in computerized manner. And up to date order given by the  customer through online web status will be shown with help of dynamic web  pages by getting data from database.

 

Existing System:

          In existing system every thing is manual like customer have to go to shop physically and he/she selects items which are available in shop and the marchant will calculate the bill for products selected by the customer and then shipping process will take place.

Existing System is manual, every thing we have to do manually i.e.

1.  Displaying items

2. Selecting items

3. Billing process

4. Shipping

Problems in present system:

1. Could not synchronize the Outward information to shopping order details.
2. No track of the complaints and replaced goods after ordering
3. Order status is updated manually using Order Confirmation.
4. Very high levels of effort for preparing invoices and dispatch related documents and routing them to relevant departments or locations and high levels of clerical activity on account of applicability of different customers and products.
5. Increased levels of expectation from customers with respect to prompt delivery of items.
6. Inability to accurately judge changing patterns of fast and slow moving items on account of large volumes of data, and inability to track goods in transit.
7. Difficulties in handling customer queries pertaining to consignments in-transit and partial dispatches.
8. Important orders not discriminated from others since all orders since all orders were processed on a FIFO basis-hence need to be able to prioritize and process orders on a preferential basis (for high value orders or important customers), if required.
9. Increase in frequency of goods returned on account of damage leading to high stock levels of damaged goods in the factory.
10. Discrepancy between ordered and invoiced quantities on account of either partial availability of stocks or clerical oversights.
11. Insufficient checks in the current system for ensuring customer credit limits are not exceeded.
12. Sales data not analyzed properly to streamline production volumes. This is primarily on account of varying sales patterns across the year and high volumes of transaction.
13. Customers could communicate to the Sales people but no information is kept in track for future references.
14. Marchant or Management couldn’t not have any information regarding latest sales reports unless requested and taken it for Spreadsheet applications.

              Marchant or Management requires the Quality information updates against the complaints and quality measures and metrics, which the current system couldn’t provide such facilities.

               The end user of this product is a departmental store where the application is hosted on the web and administrator maintains database. This application, which is deployed at the departmental store, will automate the following process.

1. The customer details are appended to the customer database.
2. The details of the items are brought forward from the database for customer’s view based on the selection through the menu.
3. Database of all the products are products are updated at the end of the each transaction.

SOFTWARE REQUIREMENTS:
• Web Technologies : HTML, CSS, JS. JSP
• Programming Language : Java
• Database Connectivity : JDBC
• Backend Database : MySQL
• Operating System : Windows 08/10
HARDWARE REQUIREMENTS:
• Pentium processor : Core I3
• RAM Capacity : 2GB
• Hard Disk : 250GB
• Monitor : 15’’ Color Monitor