Enterprise Customer Relation  Ship Management

About The Project

This project is developed for the automation process of  Enterprise customer relation ship management through online i.e through web. In merchant  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 mainly contains 3 modules like Merchant 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 will go to shop manually 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 manuwally 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 Enterprise customer relation ship management 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 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.
15. Merchant 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.

Advantages of the Proposed System

1.      Inter-Department Communication using Intranet Mailing Services (emails)Tracking the mails received from the customers as complaints and using them for appraisal and audit purpose purposes.

2.      Customized and adhoc reports for the MIS for decision-making.

3.      Order indent-automation from the direct sales dept.

4.      Shop Inventory Database updates.

5.      Stock in shop  information

Communication with the customers regarding the orders and complaints and tracking them for the future purposes.

Application Portfolio

It is recommended that the organization takes up the following four functional areas for automation

• Merchant department
• customer department
• Stores department
• Billing, shipping  Information System

The reasons for selecting the above are that firstly they directly address the problems enumerated. Secondly, together they forma cohesive set of well-integrated application with one system acting as the feeder system for the other.

MODULE

Merchant Module

Merchant will enter into the next form by entering username,password in this login page,after entering into  next page marchant  will add new products, categories, different different items what are all the items available in that store,and if he wants he will modify the things,he will delete things

And maintains everything by date wise. (i.e)

1.Enhancing stores

2.update stores

3.delete from stores

2. Customer Module:-

Customer first login into valid username and password. If customer  is not registered , then customer first register the his details. After the  login the Customer , customer search the  require goods  after words he selection the goods .

3. Invoice Module:-

After the selecting the goods , customer must enter the his credit card number. In this Module , checking the credit card no it is valid or not, and also maintain   the Collection of the payments by the customers.

Software and Hardware Requirements

The following software and hardware are recommended for the company.

Hardware Requirements:

Processor                     :                       Pentium

Speed              :                    233 MHz

Monitor                       :                       samtron

HardDisk                    :                       4.2 GB

RAM               :                       128 MB

Software Requirements:

Operating                    :                  SystemWindows NT

Language                    :                  JAVA (JSP, JDBC).JDK 1.4

Backend                      :                  ORACLE