How do I reconcile my Paygate payments with orders on Shopify?
Reconciliations between Shopify orders and Paygate payments are usually straightforward. Once a payment is successfully processed through Paygate, the corresponding order in Shopify will automatically update. This eliminates the need for manual matching in most cases.
Important Notes:
- All payment references sent to Paygate are generated by Shopify, not Paygate.
- Shopify Order IDs don’t appear in the Paygate Dashboard because Shopify doesn’t share this information. Instead, you’ll use the Reference field, which contains a unique provider reference number, for reconciliation.
If you need to reconcile payments, there are three methods you can use:
- Batch reconciliation using CSV files
- Manual reconciliation for individual orders
- Searching Shopify orders using the Reference field
Option 1: Batch Reconciliation Using CSV Files
This method is ideal for reconciling multiple orders at once:
- Export Orders from Shopify:
- Log into your Shopify admin panel.
- Use the export function to download orders as a CSV file.
- Open the file in Excel and locate the ‘Payment ID’ column. This is the unique reference generated by Shopify.
- Download Transactions from Paygate:
- Log into your Paygate Dashboard.
- Navigate to Reporting -> Search and export your transactions as a CSV file.
- Open the file in Excel and locate the ‘Reference’ column, which contains references sent by Shopify
3. Match the Data:
- Compare the ‘Payment ID’ from your Shopify file with the ‘Reference’ in the PayFast file.
- Use Excel functions like MATCH or VLOOKUP to quickly reconcile the two datasets.
Option 2: Manual Reconciliation for Individual Orders
Follow these steps to reconcile payments for specific orders:
- Find the Payment ID in Shopify:
- Open the relevant order in Shopify.
- In the Order Timeline, find the line that says: ‘A R_ ZAR payment was processed on Paygate’.
- Click this line, then select ‘Information from the gateway’ in the dropdown.
- Copy the ‘Payment ID’ provided.
- Locate the Transaction in Paygate:
- Log into your Paygate Dashboard and navigate to Reporting -> Search and click the More button.
- Under Optional Fields, enter the Payment ID from Shopify into the Reference field and click the Search button.
- Find the transaction details by clicking View on the right-hand side.
- Match this reference with the Payment ID from Shopify.
Option 3: Search Shopify Orders Using the Reference field
This method works well for finding orders using the Reference field:
- Locate the Reference in Paygate:
- After processing a payment, locate the Reference field in the transaction details on your Paygate Dashboard.
2. Search in Shopify:
- Copy the Reference field.
- In Shopify, paste it into the search bar under Orders.
- Locate the matching order and confirm the details.
FAQs
1. Why don’t Shopify Order IDs appear on Paygate?
Shopify doesn’t share Order IDs with payment gateways. Instead, it provides unique references like Reference for tracking and reconciliation.
2. Can reconciliation be automated?
While full automation isn’t available yet, the methods outlined above make reconciliation efficient. Future updates will simplify the process further by improving how Shopify references are displayed in Paygate.
Need Help?
If you have any questions or need assistance, our support team is here to help. Contact us at support@payfast.io.
Related Articles
How to Access and Log Into the Merchant Access Portal (MAP)
The Merchant Access Portal (MAP) is a secure, web-based platform that allows Paygate merchants to manage their Payfast accounts, monitor transactions, access reports, and more, all in one place. How to Locate the MAP Login Page Follow these steps to ...Accessing and Managing Invoices On MAP
The Invoices section provides access to all invoices & statements issued by Payfast for the products and services you receive, as outlined in your MOA (Memorandum of Agreement). This includes monthly base fees and payment method fees. The section ...How to Change Your Password in the Merchant Access Portal (MAP)
Maintaining a strong, secure password is critical to protecting your account and customer data. This guide walks you through the steps to update your password within the Paygate Merchant Access Portal (MAP), along with important security reminders. ...Administration Overview: Managing Users, Permissions, and Company Configurations
The Administration section, accessible via the side navigation bar, serves as the central hub for managing users, permissions, and company configurations. Access to this section is permission-restricted, allowing you to control which user groups can ...Dashboard Overview: Managing Transactions and Activity Insights in the Merchant Access Portal (MAP)
MAP Dashboard The Dashboard gives an overview of your transaction activity and can be customized to display data for Today, 1 Week, or 1 Month. After logging in, you will land on the Dashboard—your home page in MAP. To return here at any time, click ...