SugarCRM customization for advertising and online marketing agency

Client: omitted for confidentiality reasons

This project consisted in performing out a thorough SugarCRM customization to provide it with several features specifically tailored to customer requirements and not provided by SugarCRM CE, as different automatically calculated fields, complex data validations based on states and values of related modules, image galleries, multimedia support to host and manage video and audio files from SugarCRM, etc.

In the interest of confidentiality we are unable to disclose the name of the company, but the customization and personalization made on SugarCRM was focused to meet the needs of an advertising and online marketing agency with high volume of customers.

Below is a series of screenshots of the most interesting features, though it became also a great deal of customization in other common areas, such as contracts management, invoices, documents, accounts, contacts, etc.

Error: Your Requested widget " ai_widget-6" is not in the widget list.

• [do_widget_area above-nav-left]
• [do_widget_area above-nav-right]
• [do_widget_area footer-1]
  • [do_widget id="wpp-4"]
• [do_widget_area footer-2]
  • [do_widget id="recent-posts-4"]
• [do_widget_area footer-3]
  • [do_widget id="recent-comments-3"]
• [do_widget_area footer-4]
  • [do_widget id="archives-4"]
• [do_widget_area logo-bar]
  • [do_widget id="oxywidgetwpml-3"]
• [do_widget_area menu-bar]
  • [do_widget id="search-3"]
• [do_widget_area sidebar]
  • [do_widget id="search-4"]
  • [do_widget id="ai_widget-2"]
  • [do_widget id="categories-5"]
  • [do_widget id="ai_widget-3"]
  • [do_widget id="ai_widget-4"]
  • [do_widget id="ai_widget-5"]
• [do_widget_area sub-footer-1]
  • [do_widget id="text-4"]
• [do_widget_area sub-footer-2]
• [do_widget_area sub-footer-3]
• [do_widget_area sub-footer-4]
• [do_widget_area upper-footer-1]
  • [do_widget id="search-2"]
  • [do_widget id="recent-posts-2"]
  • [do_widget id="recent-comments-2"]
  • [do_widget id="archives-2"]
  • [do_widget id="categories-2"]
  • [do_widget id="meta-2"]
• [do_widget_area upper-footer-2]
• [do_widget_area upper-footer-3]
• [do_widget_area upper-footer-4]
• [do_widget_area widgets_for_shortcodes]
  • [do_widget id="search-5"]
  • [do_widget id="ai_widget-6"]
• [do_widget_area wp_inactive_widgets]
  • [do_widget id="wpp-2"]
  • [do_widget id="text-1"]
  • [do_widget id="recent-posts-3"]
  • [do_widget id="categories-3"]
  • [do_widget id="archives-3"]
  • [do_widget id="icl_lang_sel_widget-3"]

Ads

Given our client’s nature, an advertising and marketing online agency, one of the most significant issues of customization work we undertake on their SugarCRM instance is the implementation of multimedia capabilities as advanced image, audio clips and video support in order to store them and relate different Sugar modules with our client banners, ads and commercials.

All multimedia elements displayed on the following screenshots are perfectly playable from SugarCRM and can be easily added to each module records too.

Advertisers

Custom module created from scratch with many calculated fields and automatic functions wich cause changes depending on its status and force validations of certain values or other related modules records. As an example of calculated fields worth mentioning drop-down fields automatically generated (commercial agent) with the appropriate options depending on the value of another field (marketer), blocking and filling fields (in gray) as a result of selecting other related fields from other modules (NACE code, NACE description), generation of unique identification codes from the value of another field or fields when saving a record (reference code and tax ID), etc.

————————————————————–

Campaigns and subcampaigns

Custom modules including a number of calculated fields as main hightlight feature: Commercial Agent drop-down filled from the selected Marketer, automatic calculation of subcampaign costs from a set of constraints specified by users and from current prices published in specific related modules (Ad Types).

Other modules

Some native SugarCRM modules were also customized, and new ones were created in order to manage master data, such as NACE codes from different customers and suppliers, as well as different ad types handled by the agency.