IPN Notification Data in MySQL or MSSQL

Yes, that would be no problem at all. The data is actually already getting saved to MySQL since it’s in WordPress, of course. Are your other tables part of the same database? If so you may be able to setup relationships that make the data available via queries without moving it anywhere else at all.

If you’d rather move the data into your own tables in that same DB, or if you’re moving to a separate DB, then you would just need to create queries that update that DB accordingly.

Did you take a look at our developer guide for the plugin? It covers how to create hook functions and utilize the data available in the IPN. So you would just take the parsed data and use it to build your SQL queries however you need to.

Does that make sense?

I have not heard back from you on this, so I’m going to go ahead and close this thread. Let me know if you have any follow-up questions, though.

Hi Sorry, I only just saw your response it went into my spam box.

OK, which table will the transactions be in as I cannot see the data anywhere?

We want the data to be moved to MSSQL and yes I have spent too much time looking at your developer’s guide but can’t seem to understand which file to update with the SQL.

I look forward ton both responses. Thank you.

You would need to create your own plugin file or place some code into your theme’s functions.php file. The hook function template provided in the IPN details will get you started with that pretty easily.

So then within your own plugin/theme function you could use the IPN data to build your own queries and update your database however you want.

So there isn’t an existing file that you would update. You need to create your own plugin or theme function. Are you familiar with that?

Great, thank you. I’m not familiar with that but should be fine.

Also, where is the data currently saved?

One of the more powerful features of WordPress is the Custom Post Type. The IPNs are saved as Posts in WordPress using a custom post type. You can interact with that data the same way you would any other custom post type within a plugin. It’s best to work with hooks, though, which is what we’ve provided here to make it easy on you to trigger your own events based on various IPN types or payment status.