MarketPress Order Storage Database

Hi guys

I want to create a way to retrieve and show MarketPress orders in MS Excel for those clients who are more familiar with MS Excel. My idea is to set up a static IP and use it to access the remote db to retrieve chosen information via a query.

I saw that an order looks as follows in the MarketPress database:

a:1:

{

i:45;

a:1:

{

i:0;

a:6:

{s:3:”SKU”;

s:0:””;

s:4:”name”;

s:31:”Apple Rings: Apple Rings – 100g”;

s:3:”url”;

s:65:”https://www.locarnodriedfruit.co.za/store/products/apple-rings-2/”;

s:5:”price”;

s:5:”11.20″;

s:8:”quantity”;

i:1;

s:8:”download”;

b:0;

}

}

}

a:11:

{

s:5:”email”;

s:19:”tjohannvr@gmail.com”;

s:4:”name”;

s:0:””;

s:8:”address1″;

s:0:””;

s:8:”address2″;

s:0:””;

s:4:”city”;

s:0:””;

s:5:”state”;

s:0:””;

s:3:”zip”;

s:0:””;

s:7:”country”;

s:2:”CA”;

s:5:”phone”;

s:0:””;

s:20:”special_instructions”;

s:4:”test”;

s:16:”mp_custom_fields”;

a:1:

{

s:6:”1:45:0″;

a:1:

{

i:0;

s:0:””;

}

}

}

Is there any algorithm already in existence to retrieve these orders – I expect it to be available in MarketPress already but just need to know where exactly.

Thanks!

Johann