Users can also have roles, such as Sales or Manager.Īll other tables are lookup tables to join to the three main relational database tables. The Users table holds login information about users of the system such as usernames and passwords. The Notes table stores all sales activity information such as meetings and phone calls. The Contact table contains basic customer information including names, company addresses, project information, and so forth. notes - holds information collection from Contact by sales people.We will start by creating our custom CRM database. Managers have access to reports and sales pipeline information. Login: Salespeople and managers have different roles in the system.They should deliver key information at a glance and provide links to drill down for more details. Dashboard: CRM dashboards are much more than just eye candy.Activities: Tasks, meetings, phone calls, emails and any other activities that allow you to interact with customers.Contact: Information about the people you know and work with. Accounts: Information about the companies you do business with.Here is a list of the essential components of the CRM: We’ll be creating a simple CRM system for salespeople to:ĭownload Demo Files Building Blocks of a CRM In this tutorial, we are going to build a custom CRM in PHP, which a sales team can use to track customers through the entire sales cycle. By Richard Build yourself a simple CRM from scratch in PHP and MySQL Photo by Mike Kononov on UnsplashĬustomer Relationship Management (CRM) is a system that manages customer interactions and data throughout the customer life-cycle between the customer and the company across different channels.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |