Reporting

The plugin provides reporting functionality for merchants who also use the
Business Center
. You can import these reports from the
Business Center
into PrestaShop:
  • Transaction Request Report:
    includes details for individual transactions that are processed each day.
  • Payment Batch Detail Report:
    includes transactions that are processed with the applications. This report is available shortly after captured transactions are batched.
  • Conversion Detail Report:
    includes Case Management changes recorded in the
    Business Center
    to ensure that updated orders are also included in PrestaShop. This report is generated at regular intervals and includes the results of the converted orders for each reviewer. This information provides an overview of all orders that were not immediately accepted.

Scheduling

The Plugin reporting functionality works with a system scheduler to generate and update reports for PrestaShop. There are some Cron Job modules available for PrestaShop, such as the Cron Tab, that support reporting. Merchants can use any Cron Job module that PrestaShop supports or any other online Cron service provider to generate reports.
See Scheduling Report Generation for information about how to schedule report generation.

Workflow

The reports are processed and orders are updated in PrestaShop as described in this workflow:
  1. Orders with an
    AUTHORIZED_PENDING_REVIEW
    or
    AUTHORIZED_RISK_DECLINED
    status are included in the
    ps_cybersourceofficial_order
    table in the PrestaShop database.
  2. If a review is trigged for an order based on the profile rule in Decision Manager, a
    Payment pending for review
    order status displays for that order on the PrestaShop Back Office Orders page.
  3. The merchant uses the
    Business Center
    to accept the order that is in review, and, if not already enabled, the merchant enables the reports using the Report Settings on the Plugin Configuration page.
  4. The scheduler runs the report at regular intervals according to the intervals the merchant configured. The order is accepted or rejected by the merchant in the
    Business Center
    , is retrieved, and the new status is updated as
    AUTHORIZED
    or
    DECLINED
    . The updated order status displays in the
    ps_cybersourceofficial_order
    table in the PrestaShop database.
  5. The original decision and the new decision are updated and displayed in the
    ps_cybersourceofficial_conversion_detail_report
    table in the PrestaShop database.
  6. The order is updated as
    Awaiting payment
    status for the authorization and displayed on the PrestaShop Back Office Orders page. The payment is accepted for the sale and any associated follow-on transactions (capture, void capture, refund, void refund, and full authorization reversal).