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 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 are 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.
For more information about how to schedule report generation, see Scheduling 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_
    Visa Acceptance Solutions
    official_order
     table in the
    PrestaShop
     database.
  5. The original decision and the new decision are updated and displayed in the
    ps_
    Visa Acceptance Solutions
    official_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).
RELATED TO THIS PAGE