Ditutup

Customer management and billing system for a small hosting company

We need a customer and billing management system for our small hosting company. We already have a management system but it's antiquated and although we have started the work to a better version we don't seem to have enough time to really work on it.

A short description of the current database structure so that you can understand how un-normalized is it. We have around 20 tables:

- customers: many times when a new order is added for an existing customer, the customer is inserted again into the database (usually when the order is placed on our website);

- addresses;

- contracts (foreign key to customers)

- services (foreign key to contracts): this contains the domain name but not the service type (hosting, domain name etc), start timestamp, username and servername

- charges: this contains the various invoice elements (foreign key to services and invoices - it's like a lookup table with more data added to it): contains the package (hosting etc), period, quantity, price etc.

- proforma invoice: just id and issue date;

- fiscal invoice (this is generated when the payment is received

- payments

- noted introduced by the operators for various contracts, customers etc

- etc.

So when an invoice is created, for instance with 2 services (one hosting account and one domain), 2 services are generated, with similar data (usually the same domain name) but with different charges (one charge per service per invoice).

Requirements:

- a different database structure is required with a much better normalization that will allow changing customer data without affecting previous proforma invoices and fiscal invoices and without losing any data; also we need to be able to change the hosting account username and main domain name without causing problems (this is not easy right now)

- the application must be made with reasonably sane OOP, observing best practices like SRP but without going over the top; we do not need 1.000.000 classes as we'll have to perform a full internal audit of the entire code base;

- access for the end-users is very much preferred but of course this presents more security concerns;

- the application needs to be able to connect to our servers, to provision accounts and domain names, to suspend and un-suspend accounts, to automatically issue proforma invoices and when payment is received to automatically generate fiscal invoices, to make various checks etc

- all invoices should be sent as PDF attachments (preferably digitally signed) attached to text and HTML emails;

- internal operator note system invisible to enduser

- logging system for all actions took by each operator and by customers (very verbose)

- a very safe login system with multiple safety systems (anti session hijacking, sql injection protection, etc etc)

- various reports (like when new payments are due for each customer with link to the respective customer / order etc)

- a system for aggregating customers that are added multiple times (but not automatically)

- a migration script for the database is required

- older orders must be present and easily accessible but without taking much space (maybe they should appear un-collapsed as a single row)

- search module by email address, company name, person name, fiscal/SSN number etc.

- parts of the database (like the name not the surname, part of the email address, part of the postal address) will need to be encrypted to comply as much as possible with the new European personal data protection directive (we are located within EU).

While the above requirements are the only ones that I can think about right now, there could be other things. In the end we need a well made, well though of system. We need to work together quite a lot to get there and we are available to fully commit.

I am not sure what the budget should be. Bid according to what you consider fair but please do consider that price although not the first consideration, is a consideration. Milestones will be required.

Kemahiran: HTML, MySQL, PHP, Pengehosan Web, Reka Bentuk Laman Web

Lihat lagi: customer management system company, small flashes company logo, small engineering company find small projects, web based customer management sms, web based customer management system, web hosting company nepal, small software company website, customer management joomla, small construction company website, hsbc customer management, scholarly articles customer management, photo gallery hosting company, hosting company sale, established hosting company sale, template wordpress customer management

Tentang Majikan:
( 0 ulasan ) Galati, Romania

ID Projek: #15899787

41 pekerja bebas membida secara purata $2040 untuk pekerjaan ini

winmaclin

Hi Andrei Banu, After reviewing your details given, We can definitely help you develop your customer & billing management system as per your needs with customization like Database with normalization, reporting, Logg Lagi

$3000 USD dalam 20 hari
(688 Ulasan)
9.1
arhamsoftltd

Greetings, I am glad to share with you that we have complete customer management system and invoice management system. This is a big system we have developed and ready to deploy. Kindly inbox me so i can give y Lagi

$3529 USD dalam 30 hari
(152 Ulasan)
8.8
dreamci

Hello, me and my team ready to help you. I can give you an estimate and we can work on hourly rate 35usd on this project. We are responsible and reliable, we use version control, unit testing, staging servers and pr Lagi

$1323 USD dalam 20 hari
(171 Ulasan)
8.2
TrickyWebtech

HI I checked your requirement which is related to ERP system.I understood most of the things but have few [login to view URL] you allow me then I can work for you.

$2352 USD dalam 30 hari
(301 Ulasan)
7.9
shivmirthyusl

Hi There, Thank you for the opportunity. You are looking to enhance your existing customer and billing management system for your small hosting company. Thank you for the detailed explanation of how your syste Lagi

$2117 USD dalam 45 hari
(237 Ulasan)
8.1
DreamOne

A proposal has not yet been provided

$3000 USD dalam 30 hari
(192 Ulasan)
7.9
webbookstudio

Hello, my name is Victoria. I represent the Ukrainian IT-company "Webbook". I got acquainted with Your description of the task, our devs can start the work with Your customer management and billing system soon as You Lagi

$1529 USD dalam 25 hari
(146 Ulasan)
8.1
xtreemsolution

Hello There Thanks for allowing me to submit my proposal. I have checked your requirement and find that you need to create a customer management and billing system for a small hosting company. I have more tha Lagi

$1529 USD dalam 29 hari
(104 Ulasan)
8.3
gkws

Dear Hiring Manager, ➽ We are a team of Developers, Designers, Testers & PM who are in this field from more than 8 years. We are registered WEB & MOBILE application Design and Development Company providing IT servic Lagi

$1411 USD dalam 20 hari
(358 Ulasan)
8.0
narmadatech

Hey there, I want to make you assure that I have read all the details precisely and believe to explain you back. You have required a customer and billing management system for your hosting company with a differen Lagi

$2000 USD dalam 15 hari
(258 Ulasan)
8.2
dgapscom

Hello I am Ammar and I can design & develop high quality website to fulfill all of your requirements. Our developed & designed cross-browser website would be highly secure from HACKING and spamming. Having 8 years o Lagi

$1323 USD dalam 20 hari
(383 Ulasan)
7.7
ukroficer

Hello! We are a team of web-developers, have over 5 years of experience in web developing. We can develop a full functional website from scratch with all the latest and required features and [login to view URL] need to Lagi

$1323 USD dalam 20 hari
(111 Ulasan)
7.3
augurstech

Dear Employer Many Thanks for giving us chance to submit proposal on your project Coming to your project scope we will develop your customer management and billing system for small hosting company with features menti Lagi

$3000 USD dalam 50 hari
(110 Ulasan)
7.3
ominfowave

Dear Sir, Thank you for posting on freelancer. We guarantee the delivery of your project with your cost and given time. Looking forward to working with you. Below are few recent android and iphone apps developed by Lagi

$1476 USD dalam 38 hari
(102 Ulasan)
7.3
njain0131

GET AN ADVANCED YET SIMPLE & EASY TO USE CUSTOMER & BILLING MANAGEMENT SYSTEM WITH SAFE & SECURE LOGIN SYSTEMS, HIGH-END DATABASE STRUCTURE & ALL YOUR DESIRED FEATURES!! PLEASE READ OUR PROPOSAL!! Hi, After going t Lagi

$1764 USD dalam 30 hari
(100 Ulasan)
7.1
sandyagg

I will manage and develop the customer management and billing system. We are skilled in SQL and PHP. USD $15/hr Let us discuss. Sandeep

$750 USD dalam 7 hari
(179 Ulasan)
7.3
micheal4299

You can also check my portfolio: https://www.freelancer.com/u/micheal4299 I also have experience in working on similar projects. Let me know if you are interested in working with me. Thanks!

$1000 USD dalam 20 hari
(54 Ulasan)
7.0
usatechsoft

HI My Notion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work.: Lets discuss in detail and start now? i Lagi

$1489 USD dalam 20 hari
(129 Ulasan)
7.4
latatestTech

A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. Let's start! To achieve goal wi Lagi

$1470 USD dalam 20 hari
(152 Ulasan)
7.7
webdesign786

HI My Motion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work. Let start now? I am very hard working and always Lagi

$1323 USD dalam 20 hari
(109 Ulasan)
6.9