How can I report on the Product Catalog?

Hi All,

Just want to know if is there any way to enable Product Catalog module in Reports.

On checking it in core code it seems there's no upgrade safe way to do so as SugarCRM by default not allow to create report for Product Catalog module.
Parents
  • To add the modules ProspectLists, CampaignTracker and ProductTemplates to the list of reportable modules just create a file custom/modules/Reports/metadata/reportmoduledefs.php with the following code (or add it to existing file):

    //add  Prospectlists

    $additionalModules[] = 'ProspectLists';

    foreach ($exemptModules as $k => $v)

       if ($v=='ProspectLists')

          unset($exemptModules[$k]);

    //add CampaignTrackers

    $additionalModules[] = 'CampaignTrackers';

    foreach ($exemptModules as $k => $v)

       if ($v=='CampaignTrackers')

          unset($exemptModules[$k]);

    //add  ProductTemplates

    $additionalModules[] = 'ProductTemplates';

    foreach ($exemptModules as $k => $v)

       if ($v=='ProductTemplates')

          unset($exemptModules[$k]);

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Reply
  • To add the modules ProspectLists, CampaignTracker and ProductTemplates to the list of reportable modules just create a file custom/modules/Reports/metadata/reportmoduledefs.php with the following code (or add it to existing file):

    //add  Prospectlists

    $additionalModules[] = 'ProspectLists';

    foreach ($exemptModules as $k => $v)

       if ($v=='ProspectLists')

          unset($exemptModules[$k]);

    //add CampaignTrackers

    $additionalModules[] = 'CampaignTrackers';

    foreach ($exemptModules as $k => $v)

       if ($v=='CampaignTrackers')

          unset($exemptModules[$k]);

    //add  ProductTemplates

    $additionalModules[] = 'ProductTemplates';

    foreach ($exemptModules as $k => $v)

       if ($v=='ProductTemplates')

          unset($exemptModules[$k]);

    Harald Kuske
    Principal Solution Architect – Professional Services, EMEA
    hkuske@sugarcrm.com
    SugarCRM Deutschland GmbH

Children
  • The product catalog is now available for reporting from Summer 2018 release (Version 8.1 on the cloud) onwards. On prem customers will have this feature available from Version 9.0. 

    Deepak Deolalikar

    Senior Director Product Management

  • Hi Harald,

    I'm leaving the below message just for information, but I now have it working.

    I hadn't formed the .php file with a php header so it wasn't picking up the code correctly.   (<?php needed adding at the top)

    Thanks for your solution

    I'm trying your method with the exempt loop but it is not working.

    Initially I used another recommendation to comment out the ProspectLists module from the exempt list in the core file, and this worked to bring Target Lists module into Reports, but to make it upgrade safe I prefer the custom approach.

    I think there may be a miss-spelling in your original post ?

    "To add the modules ProspectLists, CampaignTracker and ProductTemplates to the list of reportable modules just create a file custom/modules/Reports/metadata/reportmoduledefs.php with the following code (or add it to existing file):"

    reportmoduledefs.php

    should read reportmodulesdefs.php

     

    However, with either spelling it is not working for me - Target Lists not showing up after this mod and QRR

    Version is 8.03 on premise in Windows and MS SQL platform

    Here is my custom file in <instance>\custom\modules\Reports\metadata\reportmodulesdefs.php

    // Customise the reports module

    // add Target Lists as reportable module
    // Note - base exempt modules are defined in : modules/Reports/metadata/reportmodulesdefs.php

    $additionalModules[] = 'ProspectLists';
    foreach ($exemptModules as $k => $v)

    if ($v=='ProspectLists')

    unset($exemptModules[$k]);

    I'm assuming I don't need to bring in the original exempt list from the core file as otherwise I could bring that in an simply comment out the ProspectLists line

    Thanks

    Neil