Reporting

The plugin provides reporting functionality for merchants who also use the Cybersource
Business Center
. You can import these reports from the
Business Center
into OpenCart:
  • 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 OpenCart. 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 OpenCart. There are some Cron Job modules available for OpenCart, such as the Cron Tab, that support reporting. Merchants can use any Cron Job module that OpenCart 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 OpenCart using this workflow:
  1. Orders with an
    AUTHORIZED_PENDING_REVIEW
    or
    AUTHORIZED_RISK_DECLINED
    status are included in the
    ps_cybersourceofficial_order
    table in the OpenCart 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 OpenCart Back Office Orders page.
  3. The merchant uses the
    Business Center
    to accept the order that is in review, and, if not already enabled, 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
    op_cybersourceofficial_order
    table in the OpenCart database.
  5. The original decision and the new decision are updated and displayed in the
    op_cybersourceofficial_conversion_detail_report
    table in the OpenCart database.
  6. The order is updated as
    Awaiting payment
    status for the authorization and displayed on the OpenCart 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).