Reports for the backend... to query on upcoming expiring adverts etc

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Author

Posts
November 12, 2014 at 9:39 am #21240

adriangraham
Expired Member

Post count: 426

Hi Guys,

I understand that there are no built in reports in GeoDirectory, but as a business owner/website admin it’s so important to be able to see who’s expiring, who’s expired, who created an account but no advert etc etc…. it’s what makes this a business instead of a website.

Are there any plugins that might provide this information from GeoDirectory data tables?

Thanks a mil,

Adrian

November 12, 2014 at 10:51 am #21245

Stiofan O’Connor
Site Admin

Post count: 22956

Hi Adrian,

There is not as yet but this would be a good one to add to requests: https://wpgeodirectory.com/requests/

Stiofan

November 12, 2014 at 10:57 am #21246

adriangraham
Expired Member

Post count: 426

Great. I’ll add there.

I will write my own SQL queries and try to get them loading in dashboard…. looking at the data model… I can not see the join between wp_users (the listing owner) and geodir_gd_place_detail (the listings).

Can you let me know how they are joined?

Thanks a mil,

Adrian

November 12, 2014 at 11:10 am #21250

adriangraham
Expired Member

Post count: 426

Think I found it… wp_posts and geodir_gd_place_detail are joined by ID… and the author is in wp_posts right?

November 12, 2014 at 11:16 am #21252

Stiofan O’Connor
Site Admin

Post count: 22956

yup 🙂

November 12, 2014 at 11:18 am #21254

adriangraham
Expired Member

Post count: 426

Great. I will share here if I get reporting working using my own SQL and some 3rd party tools. Cheers
Author

Posts