How do I reconcile payments with orders on Shopify?
Orders on Shopify will automatically update when a successful payment completes on Payfast. This means there is no need for you to manually match payments on your Payfast account with your Shopify orders.
Please note: Any references sent to Payfast are configured and generated by Shopify. Payfast has no involvement in the generation of these references.
Should you wish to reconcile payments, you may do so with the following two methods:
Option 1 - Batch reconciliation using CSV:
On your Shopify Portal:
Export the orders from your Shopify store using the export function. You may then open this CSV file in Excel.
Scroll to the far right and you will see a column ‘Payment ID’. This is the unique reference generated by Shopify.
On your Payfast Dashboard:
Navigate to transaction history on your PayFast Dashboard and download the transactions as a CSV.
Open this CSV in Excel and locate the column titled ‘M Payment ID’. This column contains the unique reference sent to PayFast by Shopify and can be reconciled with the Payment ID on your Shopify orders.
Advanced Excel users: You may make use of functions such as MATCH or VLOOKUP on Excel to streamline the reconciliation between the two datasets.
Option 2 - Manual reconciliation:
On your Shopify Portal:
When a payment is processed on Payfast, there's a line in the timeline inside the Shopify Order that says ‘A R_ ZAR payment was processed on Payfast’. Click this to open a drop-down.
In that section, click the drop-down called "Information from the gateway".
Under ‘Payment’ there will be a unique Payment ID value generated by Shopify.
On your Payfast Dashboard:
In your transaction history section, click the three dots on the right and view the transaction details of the payment.
Hover over "Custom Str4" and you will see the reference following this piece of text ‘gid://shopify/PaymentSession/’. This reference can be correlated with the above unique Payment ID generated by Shopify.
Please note: In the future, the Payment ID generated by Shopify will reflect in the “Custom Str1” field. You may use a combination of these methods if required for your reconciliation process.
Related Articles
How do I reconcile subscription payments on Shopify?
Orders on Shopify will be automatically generated when a successful subscription payment completes on Payfast. Should you wish to, you are able to retrieve references for the subscription and relevant payments to reconcile between Shopify and Payfast ...
Why are my Shopify orders not updating to paid status?
Please note that for new orders to automatically reflect as paid after a successful PayFast payment, the payment capture method on Shopify needs to be set to 'Automatic'. This is done by doing the following: Log in to your Shopify store and navigate ...
How do I amend the Shopify Pending Payment email for Cash Alternative Payments?
Cash payment alternatives, such as Mukuru and SCode, allow your customers to pay for their online purchases using cash, debit or credit card across a national network of physical retail payment outlets. PLEASE NOTE: WE DO NOT RECOMMEND ENABLING ...
How do I use Payfast on Shopify?
Allow seamless transacting on your Shopify store by integrating with Payfast's Payments App. Our Shopify Payments App provides rich features and functionality to ensure buyers are able to checkout from your store in a way that suits them best. There ...
Can I test Shopify recurring billing in sandbox mode?
Unfortunately, you will not be able to test recurring billing in sandbox mode. Only once-off payments can be tested in sandbox mode.