On This Page

Reporting

The plugin provides reporting functionality for merchants who also use the
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).