I have set up my online store using Wix Store (the one accessible from Wix dashboard).
I need to use PayPal’s Instant Payment Notification (IPN) functionality to do order post-processing.
I basically had to set up our PayPal account to send emails to a service address that copies the email to our sales inbox and to our linux server. The server will parse all incoming emails and if it finds an email from paypal with transaction ID, it will attempt to use PayPal’s /v1/reporting/transactions API to verify that the transaction exists and get the order cart from it (it would return a JSON).
I’m still not very happy with it, as it takes 2+ hours for PayPal to propagate transactions created in GUI to be accessible via the API. Sometimes it can take 8 hours or even more than that.
If Wix had finally implemented post-insert hooks for the store database, you can use those, as rows will only be inserted into that database if transaction was created (and order was paid, presumably). Back when I was working on this problem, post-commit hooks were not available for the store tables.
@eugene Thank you! Sadly the Wix Store DBs are still a black box. I am trying to link an order to a record in a private DB, and it is proving difficult. I also want to use something like drip to run email campaigns based on an order. Just can’t get the data where it needs to do. Will keep working at a solution.
@pgiesin You have to use the events.js file in the backend for onNewOrders event. Then you can map those orders to your own collection. I helped someone else with the same type of setup.