Location Import Process Improved With Power 4.9

With the release of the WordPress plugins version 4.9 of Store Locator Plus and the Power add on we focused on improving the location import process for large lists.      MySLP Power users will see this release by the end of the year after it has passed full testing on our SaaS platform.

Why Did We Change The Process?

Prior to version 4.9 there were a number of limitations that could prevent larger lists of locations from importing properly.    For the fastest servers with lots of memory and super-fast networking as well as a premium tier on the Google API service, Store Locator Plus could import 40,000 locations without any problem.

As WordPress started adding more network overhead, all those update notifications and the news feed in the WordPress dashboard comes from somewhere, the network started to become an issue.   On top of that Google started tracking every single map request so they could start charging people using their maps on a per-lookup basis.     Both of these changes increased the network traffic, slowing down how quickly Store Locator Plus could get a latitude/longitude for those new locations being imported.

Often your server would give up, saying “you had your 30 seconds of my time” and stopping the import mid-stream.    The PHP time limitation on processing is often the first thing that “gives out” when importing large lists of locations.   For most shared hosts the limit is 30 seconds.   Even on a dedicated host it is good practice to not let a PHP process consume more than 120 seconds of CPU time.  This prevents “runaway” processes that take over the entire server which can grind EVERYTHING to a halt forcing a server restart.

The bad news is that if you are importing 10,000 locations and the process gives up after 9,800 locations you have to start over.   At least that is how it USED TO BE with SLP 4.8 and earlier.

How Imports Improved In Power 4.9

With version 4.8 the location import process was “tied to the browser” until it was complete.    When you clicked the “upload CSV” button your browser would sit there attached to the website while the file was uploaded, read line-by-line, each location sent to Google to get a latitude and longitude and then get added to the Store Locator Plus locations list.     If the network was slow this could take a long time, often 10 minutes or more.   That is FOREVER to keep a browser window open these days.

With Power 4.9 we split this process into 3 stages.

Stage 1 : Get The File On The server

This is the only step of the process that stays “attached to your browser”.    The browser will bar processing the page while the file is copied from your laptop to the web server.   This is typically a quick process even for a file with 250,000 locations.    The time it takes depends on how fast your local network and ISP connection is.

Previous versions stored  the uploaded location files in a “hidden” SLP-specific directory under WordPress uploads.   Version 4.9 stores them in the media library.     This gives you an easy way to see that the file was uploaded properly, see what the current import state is, and later download or delete the files when the import is complete.

Stage 2 : Import The Locations Into SLP

After the file is uploaded a detached process starts to work on the actual location import. This ensures your browser doesn’t time out as this part happens in the background.    Your browser is “free to go” while your server does the work of loading in the locations.

It runs a WP Cron job in the background to import the locations WITHOUT geocoding. This is much faster and ensures the import doesn’t disconnect partway through.

As part of improving visibility into this process, Power 4.9.1 will be out soon and will be included in our end-of-year MySLP update.  It includes a cool interactive progress bar as well showing you how many records have been read.

Power 4.9.2 Import Processing Progress
Power 4.9.2 Import Processing Progress Bar

If your server times out before our background location loader finishes reading the file , SLP remembers the last record read and re-spawns a new background job to pick up where it left off. It will do this until it reaches the end of the file no matter how often PHP times out.

Stage 3: Geocode The Locations

AFTER the file has been loaded it will then geocode all uncoded locations.   That means you may catch SLP with a list of locations none of which are geocoded and not showing up on the map.  This is a temporary state while SLP talks to Google.    Since that is always the slowest part of an import we decided to do this in a separate process so at least SOME locations start showing up right away and eventually of them are loaded.

Power 4.9.2 Geocoding Progress
Power 4.9.2 Geocoding Progress

This is similar to the import. It does it in the background and if PHP times out it will re-spawn itself until it has tried to geocode very location at least once. This is a big step toward not having an import time out. It also keeps you from manually having to re-geocode if you hit your daily 2500 location limit and didn’t opt for a paid API key.

Store Locator Plus and WordPress 4.9.1 Updates

It has been a busy week for WordPress and all the updates and patches going around.    For those on our MySLP managed service, sit back and relax.  You’re good.    While you may wait a little longer for some new features and a couple of minor patches you are not going to be affected by software updates.   You’re good.

For WordPress users we’ve been busy chasing down some notable functionality issues with Store Locator Plus and the Add Ons for WordPress since WordPress 4.9 and 4.9.1 hit the update queue on your sites.

Location Sensor Can Help Visitors Find Your Store

Finding  Locations Near You

How important is it for people to find a location nearest them?  “Near Me” has been a top-ranked search term on Google for the past seven years. This may be the number one reason to use a location sensor.  Research indicates that the common phrases of “near me” in Google searches is a top-ranked query.   The phrase “handyman near me” might return a  cloud based app that in turn redirects  the users search to some  popular apps but how does your browser,  Google Maps or other platform know where you are?

Location Sensor

Enter location sensor, a browser-based tool that detects where a user is at the time of search.  On GPS-enabled mobile devices it returns the precise location using the device’s built-in GPS sensor.  For the Store Locator Plus users the location sensor can be enabled by checking a box under General Settings.   WordPress Plugin users will need the Power add on.   MySLP service users will need to be subscribed to the Power, Professional, or Enterprise plan.

Mobile App using location sensor
Location sensors in mobile apps can guide people to your store.

Using HTTPS Improves Sensor Performance

Google Chrome’s v 50 and higher ( the most popular browser with the largest market share  at this time)  requires site urls to be served over a secured site before it will allow the location of the user to be transmitted.  They have stated that location is sensitive data and determined that HTTPS versus HTTP  be  required to protect the privacy of your users’ location data.  Other popular browsers , such as Mozilla Firefox, may submit a pop-up box asking the user to grant permission for their location to be known.

In short, if your site is using the location sensor feature it must get an SSL certificate and be serving pages on an https address.   Many browser disable multiple features if you are not a secure site, including the location sensor.   It won’t be long before ALL browsers disable location sensor support if you are not hosting an https site.

Location Sensors Can Increase Sales

If you have a physical location that counts on people walking in the door to make a sale, adding Google Maps and employing the location sensor can have a notable impact on your walk-in traffic.    Your first step is to get an SSL certificate on your site so you can serve secure pages; This also helps boost your Google search rank.   Once you have that completed put Google Maps software that supports the locations sensor on your site.     Add a couple of posts to your site that relate to your business such as “Boutique Near Me” and drop the map code on that post.   It won’t happen overnight, but as your site starts to generate traffic the map will lead people to your store.

 

Have questions?   Contact us.