Kiran

Hello,

Use following code snippet to get latitude & longitude.

	
global $gd_session;
$location = array();
if ( ! empty( $gd_session ) && ( $gd_country = $gd_session->get( 'gd_country' ) ) && ( $gd_region = $gd_session->get( 'gd_region' ) ) && ( $gd_city = $gd_session->get( 'gd_city' ) ) && $gd_session->get( 'gd_multi_location' ) ) {
	global $wpdb;
	$location = $wpdb->get_row( $wpdb->prepare( "SELECT country, region, city, city_latitude, city_longitude FROM " . POST_LOCATION_TABLE . " WHERE country_slug = %s AND region_slug = %s AND city_slug = %s", array( $gd_country, $gd_region, $gd_city ) ) );
}

if ( ! empty( $location ) ) {
	$latitude 		= $location->city_latitude;
	$longitude 		= $location->city_longitude;
	$country 		= $location->country;
	$region 		= $location->region;
	$city 			= $location->city;
} else {
	$latitude 		= '';
	$longitude 		= '';
	$country 		= '';
	$region 		= '';
	$city 			= '';
}

echo '<br>latitude : ' . $latitude;
echo '<br>longitude : ' . $longitude;
echo '<br>country : ' . $country;
echo '<br>region : ' . $region;
echo '<br>city : ' . $city;

Kiran

Hi Sonya,

1) get an email to say it’s Post Submitted Successfully

This mail sent to the customers when they submits the listing from front end. The customers will receive another email “Listing Published Successfully” when listing get published after successfull payment or manually published by admin.

2) there is nothing in the back end of the site telling me that the user has not paid.
There are two ways that indicates invoice is not paid.

– In list Invoices page all the invoices with pending status has a pending payment. (yoursite.com/wp-admin/edit.php?post_status=wpi-pending&post_type=wpi_invoice)
– In listing edit page there a metabox that will list all the invoices related to this listing. (this feature will be in next version, but i have updated on your site)

3) How do the owner then know they have to pay if they have clicked off it? Where does the user pay of they click off it.

There is a page “Invoice History” to list all the invoices from the user. Here user can see paid, pending, renewal etc invoices.
You can add “Invoice History” page to menu from Appearance > Menus

I have a subscription package set up for £200 but I get the error message
Error: The subscription plan in Stripe could not be created, please try again.

There is an upgrade in recent Stripe API, we have fixed it and now it is working fine.

Let us know.

Thanks,
Kiran

Hello,

Please provide us your site admin credentials, FTP credentials & database access in a private reply.
We need to look into there.

Kiran

Hello,

Can you please let me know if I can use mysql dump directly in the location table or I need to update the table via the import&export csv?

You can only mysql dump directly in the location table if the you have same structure and data. We have slug fields in location manager and those are generated dynamically.
So you should go it via import & export standard way. You can download sample csv from Import / Export location section,to make csv with correct structure and data.
If you have problem importing 2 million items one time on your server then you can split to csv with 50000 rows to each.

In Location Manager>Location Settings>Enabled selected Cities. That page is trying to load all the cities that I have. My browser can’t handle 2 million lines of select menu.

Selected cities options should be used when you want your directory restricted to some cities. For 2 million cities you should use multi city option. Or you can apply restriction to the region by selecting regions in Selected Regions.

Thanks,
Kiran

Hello,

If a parent listing is claimed then branches also claimed automatically.

Can the invoicing system accommodate custom invoices: e.g if I talk to a client – can I then strike a deal and create a custom invoice for only that listing and their branches (where I upload and activate it all from the backend as agreed with a client? If so – how will renewal work?

We have already one feature that will meet your requirements. There is a feature “Generate invoice for the listing.”.

Steps:
1) Create a one paid package with free franchise fee.
2) From backend create a draft listing with the package created in 1).
3) Enable franchise for the listing, choose appropriate post author(client), tick claimed > Yes, fill listing details and save the listing as a draft.
4) Add number franchises under this main listing.
5) Go to main listing edit page
6) Click on “Create Invoice for this Listing” button (see 1st attachment). After invoice created successfully it will show invoice link (see 2nd attachment). Click on this invoice link will takes you to the invoice page.
7) Now on invoice page there will be a button “Resend Invoice”. Click on this button to send invoice to the author via email.
8) Author will receive a invoice email with links to proceed for the payment.

Once client pay for this invoice, the renewal process will continue after end of cycle automatically.

Let us know.

Thanks,
Kiran

Thanks for letting us know 🙂