Find Jobs
Hire Freelancers

Customer management and billing system for a small hosting company

$750-1500 USD

Closed
Posted over 6 years ago

$750-1500 USD

Paid on delivery
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.
Project ID: 15899787

About the project

41 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
41 freelancers are bidding on average $2,040 USD for this job
User Avatar
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 you demo or if you want to add or remove anything we will do it. If you ask us or any other freelancer to develop from scratch then it will cost you around 10 k usd. Awaiting your response. Many Thanks DH
$3,529 USD in 30 days
4.8 (152 reviews)
8.8
8.8
User Avatar
A proposal has not yet been provided
$3,000 USD in 30 days
5.0 (192 reviews)
7.9
7.9
User Avatar
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 different database structure that will allow changing customer data without affecting previous proforma invoices and fiscal invoices, without losing any data as well as you want to change the hosting account username and main domain name without facing any problem. Rest tasks also will be run in the clear and specific way. Me and my full time working team would like to haul all our efforts and time to accomplish this work for you. Please give us your valuable time to enhance our working relationship. Kind Regards, Sanat V.
$2,000 USD in 15 days
4.9 (258 reviews)
8.2
8.2
User Avatar
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 project management tools in all projects. Please check my reviews, i guarantee you an enjoyable development process Please message me for more details
$1,323 USD in 20 days
5.0 (171 reviews)
8.2
8.2
User Avatar
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 system is working current and I can see that there are a lot of improvements required. Before I confirm the Cost and time estimate I would like to review the system so we can give you an effective estimate of cost and time. Looking forward to discussing this project specification in detail via freelancer Chat. Thanks Mirth
$2,117 USD in 45 days
4.8 (237 reviews)
8.1
8.1
User Avatar
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 need. Our team have gained years of experience with CMS, Frameworks, Mockup Designs, Template Customizations, PHP/PHP5, Sql/MySql databases, APIs, JavaScript, jQuery, HTML5, CSS, Responsive,Bootstrap. You can see our portfolio in freelancer. We are glad to chat with You and discuss all in details.
$1,529 USD in 25 days
4.9 (146 reviews)
8.1
8.1
User Avatar
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 of experience with more than 600+ successful projects. Please come in private chat to discuss in detail about your website and I am ready to start your project right now.
$1,323 USD in 20 days
5.0 (383 reviews)
7.7
7.7
User Avatar
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 in 7 days
5.0 (179 reviews)
7.3
7.3
User Avatar
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 with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Regards Dsv Infosolutions Pvt. Ltd.
$1,470 USD in 20 days
4.8 (152 reviews)
7.7
7.7
User Avatar
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!
$1,000 USD in 20 days
5.0 (54 reviews)
7.0
7.0
User Avatar
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 mentioned in project scope. Ping me via freelancer chat box so that we can discuss our queries and which technology you will prefer for development we have team of exp developers and user interface designer in our company with 3-7 years exp and we will deliver you quality and professional work Looking forward to hear on same Regards Sam
$3,000 USD in 50 days
4.9 (110 reviews)
7.3
7.3
User Avatar
Hi I would love to discuss your needs further. I am a full stack developer with 10+years experience and extensive experience building optimized web applications for small to large scale businesses. I strive to offer a professional service, deliver quality work, and communicate effectively. I am available to chat about this project now and look forward to hearing more. Thank You
$2,852 USD in 40 days
5.0 (42 reviews)
6.4
6.4
User Avatar
Hi, I am a web development expert. I have a lot of experience in building websites and I also have a team of expert web developers who work with me on different projects. We have been creating awesome websites for various clients around the world. We focus on great user experience and efficient code in order to optimize the sites both for speed and performance. I have gone through your requirements and I feel that I am the perfect candidate for this project as I can create a customer and billing management system for your hosting company with all your mentioned features as it is in my expertise area. I have done such projects earlier too. My team's expertise areas are - PHP, HTML, CSS, Bootstrap, Javascript, Jquery, Angular JS, Node JS, C programming, Python, Java. We also have fine hands on open source frameworks like Wordpress, Drupal, Joomla, Laravel, Zend, Symphony, Django, Express NodeJS, MVC, ASP.Net etc. I will ensure great communication throughout the project and since I will be working with my team, we will be able to work on your project keeping the strict deadline in mind. Teamwork accelerates the workflow and ensures success. I am looking forward to working with you on this project. Ping me and let's discuss. Thanks a lot.
$1,000 USD in 20 days
4.6 (38 reviews)
6.7
6.7
User Avatar
Greetings! My name is Moeez. I’ve a very good understanding of your project so I'll be glad to discuss the arrangement in detail to ensure we are on the same page. I am highly experts in the following fields. - GRAPHIC DESIGN - WEBSITE DESIGN - RESPONSIVE WEB DEVELOPMENT - E-COMMERCE SOLUTIONS - CMS WEBSITE DESIGN - MOBILE SOLUTIONS - INTERNET MARKETING - SEO At Creativeart, you will experience outsourcing at its best! Superior quality, quick response time, strong communication skills & a team which makes you feel at home. If quality is something which you are seeking, then we are the team to hire. Our portfolio, 5/5 feedback will speak volumes of the same. I am available on Skype throughout the designing process to take your feedback and suggestions rapidly. I offer 1 month free technical support and delivery of 100% print ready vector files. Current price is tentative (will dependent on the project scope). Being highly confident we look forward to your response to proceed accordingly. Best Regards Moeez Ahmed | Creative Director Creativeart
$1,588 USD in 26 days
4.9 (56 reviews)
6.4
6.4
User Avatar
Hello There, On reading the whole description, What I understood is the issue is mainly the duplication of data due to having multiple orders of same customers, which cause the system being inaccurately managed. and As mentioned yes it's must be an issue from database keys (foreign key to be used in several sections/tables). As far as my knowledge says, Your take is correct to make it from scratch by standardizing the complete database again keeping things normalized. and I assure you for this, You will get delivery of complete a new system. We will make sure to make system better from UI prospect as well so that you can manage things easily. I do have analyzed and did some inventory, invoicing, sales/orders projects, because of which I'm confident and clear with my understanding on same. Let me know if you are interested, Awaiting your response. Sherin
$1,500 USD in 45 days
5.0 (18 reviews)
5.8
5.8
User Avatar
depending on your website setup. you may be able to use Microsoft Access. I believe you can add to your server on a share point. I am an expert in Access. I know microsoft Access can accomplished your list of requirements. My passion is building Custom Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. Some of the databases I have built include Production, Inventory, Scheduling, time-clock, Book-Keeping, facilities management, and many custom databases I am bidding on your project because I feel my experience and education has prepared me well for it. My strong desire to become one of the best in my field is my motivation to excel as an Access Developer and I would appreciate the opportunity to put my skills and experience to work for you. What you get if you allow me to do your project. The Database to your vision. I will create the database and continue to change upon your input until it is what you in vision. I will offer lifetime support for the database; I will give all my contact information if chosen to complete your Project. I if there are any bugs or issues to the original Database I will fix free of charge. Thank you for your time.
$2,500 USD in 30 days
5.0 (9 reviews)
4.6
4.6
User Avatar
Hi, Good Day! Thank you in advance for your time and consideration. I have reviewed your job description as well and very confident to handle this project perfectly. As we have great experts in web design and development, I can strongly assure that we can build your Customer management and billing system for a small hosting company based on your interest. I ensure you to deliver the whole completed project as a dynamic one with Top quality. We will be giving you a detailed project proposal, and "Trello" will be used for Project management. Please do contact me for further discussions in order to start the project right away. Best Regards, Anushyaa M
$2,207 USD in 19 days
5.0 (15 reviews)
4.4
4.4

About the client

Flag of ROMANIA
Galati, Romania
0.0
0
Payment method verified
Member since Nov 12, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.