CitrusDB, PHP-based Customer Care And Billing Solution


If you are looking for an easy to use solution including CRM, customer care, and billing; you should definitely try out CitrusDB. CitrusDB is a Web based customer care and billing solution that uses PHP and a database backend to keep track of customer information, operational CRM, services, products, billing invoices and credit cards, and support information. I find it very suitable for small and medium companies.
CitrusDB require PHP 5.0.4 or greater with register_globals turned off in your php.ini, any database supported by ADOdb (MySQL, Oracle, MsSQL, ODBC…). I did not tested security of the application, but there are some recommendation in the website to keep your server secure : in a private LAN with firewall, SSL protected web server with access limited to trusted IP addresses, or A Virtual Private Network or Intranet.

Below features of CitrusDB :

  • Customer Service
    • Track modifications to service records
    • Security and password access to database on a per user level
    • Stores general info, mailing address, billing address, and billing info about each customer
    • Import new customers from online order data
  • Service Management
    • Assign unlimited services or products to a customer record
    • Add custom fields for services/product information
    • Search by specified fields
    • Easy to add and modify services
  • Billing System
    • Custom billing cycles for each product
    • Printed invoices
    • Email invoices
    • Prepayment reminders
    • Credit Card Batches (import/export)
  • Support Tickets
    • Invividual database user notification
    • Group notification
    • Online requests integrated with account records
  • Customization
    • Modular functions to allow new pieces to work along side base functions
    • Works in multiple languages

For more information and download CitrusDB website. A manual that cover the 1.3 release of CitrusDB and written by Paul Yasi, is available here

Previous articleGoto PHP 5.3
Next articleCodeWorks Conference

Hatem Ben Yacoub, PHP expert and PHP5.3 ZCE, Energy engineer, Entrepreneur, ICT & eGov consultant, Senior Systems architect, Independent Open Data expert and Open Source evangelist.