Link to Excel

hi Arjun

You have to code VBA script inside your Excel file.

1.select JSON format for export
2.(from VBA script) read url https://yourwebsite.com/wp-admin/admin-ajax.php?action=order_exporter_run&method=run_one_job&profile=now
3. parse json , see more https://stackoverflow.com/questions/6627652/parsing-json-in-excel-vba
4. add new records to Excel sheet

thanks, alex

• This reply was modified 7 years, 9 months ago by algol.plus.

Thanks I’ll check this out.

Hi – I struggled a bit with point 2 as I’m not very familiar with VBA. Could you please share some details on how I can select this? Thank you.

hi

I’ve never coded VBA scripts too, so I can’t help you with it.

But we started new version which will add new orders to Google Spreadsheet.
I can provide it for tests.
Please, contact me via Helpdesk system to get beta version.

thanks, alex

Thanks Alex. I’ll try and figure out next steps then.