In Progress

Monthly Sales Database and Report Website

We're looking to generate a web based program that will facilitate our Internet Sales operations, particularly in generating reports from the data entered and sending that automatically via email to a list controlled by an admin.

We already have a CRM so this is a backup to that. We are currently using multiple Excel sheets to track all of this and want to consolidate this to one data point that will allow us to create multiple reports from that.

The data that will be entered daily will be:

*Date Stamped

Choose Store (Drop down Choice of our 6 Dealerships with flexibility to add more as we grow.. editable list)

Customer First and Last Name (open text value)

Customer Phone Number (9 digits, open numerical value)

Email (yes or no selection)

Phone (yes or no selection)

Appointment Set Date (date value)

Appointment Time (12 hr clock, am & pm)

Vehicle of Interest (open text value)

Source (drop down selection - editable list, this is the incoming source of our lead)

Show (yes or no)

Sold (yes or no)

Salesman (Selection from an editable list. Based on selected store. Salesman list also requires a hierarchy that accounts their shows and sales to their sales manager.. i will be happy to explain at length)

This information needs to be input and editable in a quick and easy manner. What I hope, for the user, is to be able to view all their data for the month, and to change it all from that same screen rather then having to open an edit screen. I'd also like them to be able to filter their view based on show, sold, show & sold. They should also be able to filter the dates of the data they're seeing but will be defaulted to the current month ie. I'm always seeing Oct 1-31 but can select sept 15 - oct 31.

I would also like a scoreboard always visible for the users who input the data which will show an the overall values. My vision for this score board is to be a small bar at the bottom of the browser that's always visible and separated into 3 with 3 values each. Those 3 are Month To Date | Current Week (Mon- Sun not past 7 days) | Today, and the 3 values each are Leads, Appointments Shown, Sold Units. This will default to ALL dealerships but there should be a filter to switch between dealerships.

Aside from creating and editing the data the reports we need to generate from the data are:

I have current excel sheets that currently track these that I would be happy to share.

- Overall Summary (total lead count, total appointment set, show, sold, closing & "sold/lead", appointment % "show/lead",

- Overall Daily summary per store (auto emailed daily at 10 pm)

- per dealership summary (same as overall but per dealership, auto emailed on sunday)

- Individual Summary (same as overall but per user and broke down into a summary and per dealership)

- Goals vs Actual (based on user imputed goals values)

- Payroll per user (based on $/show=yes and $/sold=yes + $1000 base, user can view their pay for that month)

- Overall Daily report (emailed daily at 10 pm)

- Daily report / user

- Month to date report per team

- weekly team report (based on what team the sales reps are on, auto emailed each sunday)

- Monthly trend sales data

- archived data and ability to compare data to previous months

- ability to insert historical data to be compared going forward

***these can be blended based on efficiencies, I was simply trying to get them all down

In summary, we're looking to build a data entry website that can be used to generate reports and to hold individual internet sales reps accountable to their performance. It also needs to have the capability to automate and email reports to make it more efficient.

From what I see it looks like we need to have the ability to create and edit:

Users - Internet Sales or Admin

Dealerships

Sales Reps and what team they're on

Teams (teams are per store)

Incoming Lead Source

I'm more then happy to answer questions!!!

Skills: CMS, PHP, Software Architecture

See more: database sales report, what is database entry, what is an operations manager, we want a salesman, web trend, website manager software, website editing software, value website, sun source, store salesman, software and it website, sheets add, score time length, sales re, salesman performance, salesman of the month, quick data entry software, program sales internet, pm sales, php team lead, performance payroll, performance board, payroll accounts, pay entry base data, open source data entry software

About the Employer:
( 6 reviews ) Regina, Canada

Project ID: #1248452

Awarded to:

yunuscse

I could understand your requirements. I can do your work perfectly. I have explained as details in PM. Please view my PM. Thanks

$700 CAD in 10 days
(85 Reviews)
6.4

11 freelancers are bidding on average $466 for this job

adibr70

I have experience working with PHP, JavaScript, MySQL and integrating it all into a site. Check out your Private Message for some example sites that I made using PHP. Adrian

$750 CAD in 30 days
(30 Reviews)
5.5
elabuwa

Hi there, Experienced developer at your service ready to get crackin Please check PMB for more info

$600 CAD in 10 days
(18 Reviews)
5.1
triadb

Hi, please check PM

$480 CAD in 30 days
(10 Reviews)
3.9
galaxianape

Please check Pm for our skills Thanks Ricky

$550 CAD in 30 days
(1 Review)
3.5
rcic710

hello read your requirement fully plz check my pm thanks

$250 CAD in 10 days
(1 Review)
1.0
haroldlamostre

Hi, I am interested to work on your requirements. Based on your posted details I believed I can do it. Thank you.

$500 CAD in 30 days
(0 Reviews)
0.0
sunnynu

I am very good with php and Mysql and i can create this web for you in very efficient way.

$350 CAD in 10 days
(0 Reviews)
0.0
familyman4

Hello, I am new to this website but I have been doing professional web development for 11 years and I have a BS in computer Science. I have done similar projects over the years such as a sales development management s More

$400 CAD in 21 days
(0 Reviews)
0.0
sudhahari91

Hello, I am new to this website but I am in professional web development for many years using PHP,java script .

$250 CAD in 10 days
(0 Reviews)
0.0
DamonD

Recently took multiple spreadsheets a school was using to generate billing for their copiers and created user and admin interface. Users can log in, input readings, view present and past billings, etc. Admin can gene More

$300 CAD in 14 days
(0 Reviews)
0.0