Closed

Administrative database system

Background:

We are a small starting Dutch company (currently only 2 of us working part-time) that helps independent professionals (our customers) increase their sales via the internet. Regular HTML/CSS, SEO and marketing are our forte, Database and PHP coding unfortunately aren't. That's where you hopefully come in.

Project

We are looking for someone to develop an online administrative system/database in which our customers every week submit the number of sales we have managed to realize for them in that specific week, which could/should automatically lead to invoice generation for their specific sales number and an e-mail with this invoice of ours being send to them.

In a bit more detail. this system should meet the following requirements:

Core functions:

- Separate user accounts with unique logins;

- Possibility to add customers/users via an admin page;

- Automated e-mail sending, e.g. at the end of every week my customers should receive a simple email with the link to the database login-pagina saying its time for them to fill out the weekly form;

- When logged in, users should see their own personalized page (i.e. their name displayed) and be able to get:

an overview of which weeks they still have to submit.

if clicked on an "open" week, they should see the simple form where they tell how many customers they have received through us, and be able to press a "submit" button that saves this information into the database.

an overview of past invoices with the ability to download them.

- When a customer hasnt filled out the form of a respective week more than 7 days later, they should automatically get a reminder email;

- The possibility for the admin-user to see statistics and customer reports, e.g. selecting a number of weeks and seeing per customer the number of sales realized and their totals. I.e. using various filters simultaneously;

- For the admin to see an overview of which users/customers have not yet filled in certain week forms.

- And ofcourse: be secure

Additional features:

- Automated monthly invoice generation based on the amount of sales customers/users have had from us, as per their weekly submitted forms. (Parsing monthly total into a pre-exisiting MS Word-document??)

- Automated montly sending of this invoice-file to the specific user.

- Users and admin should be able to see past invoices and be able to download these.

- Related to the invoice generation: the possibility to set different prices per customer segment. Also, the possibility for the admin to change these prices.

- When the customer submits the weekform, the time and date of submitting the form are also saved and shown in their overview.

- When a new customer/user is added by the admin, he will automatically get an email with his login details and the link to the login-page.

- The possibility of making a backup of the database (and to put it back, e.g. upload the database-file, in case something went wrong).

- Users should preferably see a number of tabs (or just links to separate pages) once logged in: e.g. a "homepage" tab in which the "open week forms" can be seen", a tab with previous week forms, a tab with invoices, etc.

- This is because after say 2 years, I don't want customers to see all 100+ weekforms.

- We should be able to edit certain HTML/CSS properties of the system.

Despite (or because of?) the rather detailed brief above, we think this is actually a relatively easy task for professionals. We look forward to seeing your quotations.

Skills: MySQL, PHP, Web Security

See more: administrative database, wrong invoice, web press login, web page making easy, starting an online sales company, starting an online marketing, sending invoices, sending invoice, sending an invoice, security company sales, prices for lead generation, possibility of internet marketing, pagina web marketing, online marketing statistics, not yet received, looking for online lead generation, lead generation through online marketing, lead generation system, i want to edit word document, how to send an invoice, how to develop own web page, get web statistics, coding security system, look for professionals online

About the Employer:
( 0 reviews ) Netherlands

Project ID: #4684859

28 freelancers are bidding on average $557 for this job

NetzPro

Dear Sir, We would love to get this opportunity of working with you. We can assure you that we will provide you with a very nice website. Regards NetzPro

$644 USD in 30 days
(348 Reviews)
8.5
buraqtech

Check your PMB for details!!!

$706 USD in 18 days
(68 Reviews)
7.7
ranganalx

I'm bidding to get the core functions done inclusive of the intuitive UI for both front-end and back-end, for the additional request, it's possible and will have to quote more. Hoping to hear from you. Thanks!

$876 USD in 25 days
(250 Reviews)
6.5
sainathkohta

Dear Sir, we have lot of experience. We are interested and ready to start straight away. We will deliver you the best if you give us a chance. Please let us know if you need any more information. Thanks

$444 USD in 7 days
(36 Reviews)
6.5
santoshfree

Hi,We will give you a complete satisfied and professional solution as your requirement.please check message.

$450 USD in 15 days
(61 Reviews)
6.3
samitXI

Kindly check your inbox. Thanks

$421 USD in 3 days
(48 Reviews)
6.1
seekdeveloper

Hi, I have read your requirements and I am very confident to do this project from start till end. I can guarantee complete satisfaction if you select me to execute this project. Please check your private message board. More

$567 USD in 6 days
(28 Reviews)
6.1
expertonphp

Respected Sir, First of all thanks for taking time to read our initial post. We have checked your initial project requirement and wants to discuss further more via Freelancer Message board. Thanks ExpertonPHP !!

$1000 USD in 25 days
(63 Reviews)
5.8
stdhtelkom

Hello, I am understood and would love to working with you. Please check pmb for more information. All the best, Steve.

$750 USD in 20 days
(17 Reviews)
5.7
vaquan

Hi RAW85, I have a lots of experience in database/backend system like this project. I also worked on similar projects like yours. Let me help you. Thanks, Quan.

$526 USD in 15 days
(9 Reviews)
5.2
adelline

Hi! I have experience with creating PHP/MySQL administration interfaces and i would like to work on your project. I have a few questions about it, please read the private message.

$736 USD in 8 days
(57 Reviews)
5.1
netinfinity

Certified IT Professionals with 10+ years of experience in delivering enterprise class web solutions, intranets, portals and business workflow solutions to clients worldwide. Please review the PMB for more information.

$555 USD in 7 days
(16 Reviews)
5.1
miniric3

Kia ora! On2itonline.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$515 USD in 21 days
(5 Reviews)
4.9
arslannasir92

Hi , Expert Here , check PM,thanks

$526 USD in 30 days
(4 Reviews)
4.0
vickkey7

I am ready to start this project....

$470 USD in 10 days
(5 Reviews)
3.7
gr8light

Hi, I gone through your instruction carefully. pls. check PMB for more details. Thanks, Gr8light

$555 USD in 15 days
(2 Reviews)
3.5
santosoftvw

Dear Client, I have 6 years of experience in software engineering. I am expert in Zend PHP, Codeigniter PHP, jQuery, HTML5, CSS, Ajax. I have similar applications successfully. Please check my customer's review for th More

$333 USD in 30 days
(8 Reviews)
3.6
Senan2010

Ready for work

$700 USD in 14 days
(6 Reviews)
3.5
nittilegupta

Hi, I have good command over designing. Expert hands in HTML 5 and CSS 3 & responsive web designs. I am good at PSD to HTML jobs too. I am the winner of the design contest in freelancer. I would like to be invi More

$473 USD in 9 days
(2 Reviews)
3.4
irajhedayati

As I found you just need a simple website to interact your customers. A dashboard can help you to make it better and simpler. PHP built-in email sender is a good way to manage automatic email sending.

$421 USD in 7 days
(1 Review)
1.3