Creating Reports Using Affiliate Extension Fields

Can I create a report using fields from Affiliate extension?

Since v.2.5.0 Affiliate extension is compatible with Custom Reports Builder module, enabling Affiliate entities for report creation. You can find the 'amasty/module-affiliate-to-builder-by-amasty' package for installing in composer suggest. Please note that the module is available as a part of an active subscription. Compatibility is only supported when both the Affiliate extension and Custom Reports Builder module extensions are installed.

To create a report, kindly navigate to Reports > Custom Report Builder, when adding a New report, Affiliate entities would be available in the Main Entity drop-down: 



Kindly note that for Amasty Affiliate Account, the Account ID will be pre-selected in the Chosen options, for Amasty Affiliate Banner - Banner ID, for Amasty Affiliate Program - Program ID, for Amasty Affiliate Sales Order - Entity ID, since these fields are essential, they cannot be removed from the report, while the other fields can be customized based on business needs:





      • Related Articles

      • Advanced Reports API

        We have created a public API collection for Advanced Reports module with all available queries and sample data that you can both test via our demo endpoints and copy to run local tests in your Magento environment. More details about using public ...

      • How do I approve and manage affiliate accounts?

        From version 2.3.0, the store admin can approve customers manually, as well as specify the exact customer groups which members are allowed to request for applying to the Affiliate Program. The features are available within an active subscription and ...

      • Can I add information about gift cards to my report?

        Starting from version 1.7.0 of the Custom Reports Builder module, it is possible to use Amasty Gift Card entities for report creation. (Both modules should be installed). To enable the functionality, you need to install the ...

      • Why do Magento Sales report and Orders report by Advanced Reports contain different data?

        By default, data in Magento reports does not align with the data in our Advanced Reports module. This discrepancy arises from the differences in how data is displayed across various reports within Magento. The Sales Orders Report can be found under ...

      • Why is the affiliate discount not working and/or no commission is added to affiliate balance?

        To ensure that affiliate discounts are working correctly and commission is granted accordingly, it is recommended to follow certain steps. If you have issues with the discount/commission application, please check the following settings. Cart Price ...