The WordPress location finder and directory building plugin, Store Locator Plus, released version 4.2.43 today. The new release adds improved import notices and works in tandem with both the Pro Pack and Tagalong add-on packs to provide better notification of problem imports. The new release is also better at testing CSV headers and file formats and stopping the import process before grinding through thousands of potentially errant data entries.
CSV import processing allows businesses to load thousands of locations at once into the locator plugin. Sites employing a Google Business or OEM license can load and geocode up to 100,000 locations per 24 hour period. Sites using the standard, and no-cost, Google API service that is built into the product can import and geocode up to 2,500 locations per day.
Store Locator Plus provides the “enter your zip code and get a map of our locations” feature for web sites and mobile apps. The product requires little-to-no technical knowledge to list locations and implement the interactive search-and-map interface. Over 10,000 active installations range from small businesses with “a handful of locations” to organizations with over 250,000 locations being served.
Pro Pack brings the “enterprise-level” services to the free Store Locator Plus base plugin. The Pro Pack includes CSV import for locations, the location sensor that allows the web pages to get GPS coordinates from a mobile device or GPS-aware desktop web browser, and search-and-results reporting. Pro Pack version 4.2.08, being released in tandem with the Store Locator Plus update, utilizes the new features in the base plugin to extend the processing and reporting of location imports.
Tagalong brings location categorization features to locations. Businesses with multiple types of locations can allow users to filter the search results based on what segment of the business is being served. Manufacturers use this feature to show which retail outlets carry specific lines of a product offering. Medical services mark various providers by their areas of expertise. Tagalong can also provide custom map markers and per-location icons based on the categories assigned to a location.
Dropped slpplus.initOptions() support. Some older SLP add ons may be deactivated and require an upgrade to a newer version.
Dropped slpplus.is_Extended() support. Some older SLP add ons may be deactivated and require an upgrade to a newer version.
Dropped slplus.register_addon support. Some older SLP add ons may be deactivated and require an upgrade to a newer version.
Dropped slplus.versionCheck() support. Some older SLP add ons may be deactivated and require an upgrade to a newer version.
Added query_slug to slp_location_filters_for_AJAX filter. Default slug is 'standard_location_search'.
Added query_slug to slp_location_having_filters_for_AJAX filter. Default slug is 'standard_location_search'.
Added query_slug to slp_ajaxsql_fullquery filter. Default slug is 'standard_location_search'.
Added query_slug to slp_ajaxsql_queryparams filter. Default slug is 'standard_location_search'.
Added query_slug to slp_ajaxsql_results filter. Default slug is 'standard_location_search'.
Add slp_ajax_execute_location_query_start and slp_ajax_execute_location_query_end actions for AJAX query handling.
Updated symlink path testing.
Add layout support for 3rd party buttons for UML/GFI add on.
Improved WPML support.
The Google Map now responds to changes in the WPML selected language on the user interface.
Drop find label button support for legacy Enhanced Search versions prior to 4.3. Will need to upgrade ES to 4.4+ or use MySLP.
Drop defunct getWPMLText() function, may require legacy add ons to be updated to latest version.
Drop the unused slp_generalsettings_modify_adminpanel filter.
Drop the slplus->addons property. Make break older legacy add on packs. Upgrade the add on packs to version 4.5+.
Drop CSVImport base class. Pro Add On and Tagalong Add On will need to be updated to version 4.5.07.
Search Form Radius selector label is assigned a class of 'empty' or 'text length_<#>' where <#> is the number of characters in the radius label for easier CSS formatting.
Search Form Input boxes now have a class assigned based on whether or not the label is empty. label_empty and label_text make it easier to change the input width based on whether or not a label is present.
Updated Twenty Sixteen Plugin Style to Rev 05. Leverages the new label and input CSS rules.
Restore Store Pages to sidebar menu when active.
Add on framework no longer preloads csl-script (slp.js) when loading the userinterface.js files.
Add a slp_radius_selections filter for Experience add on to augment radius selector drop down with a first entry.
Reduced overhead on admin pages.
Extended Data display on add/edit locations addressed for older extended data manager installations.
Fix blog switching error on multisite installs using Network Activate.
Note: Network Activated Multisite installs using paid add ons should have an active Premier Subscription for proper multisite licensing.
Turn off SSL validation of peers on the update server. If your server's SSL cert is expired/invalid the version check on add on packs will now run anyway.
Save changed to default country conversion to the CCTLD as the slug.
Delete location fully on first attempt when Pages add on is active.
Do not run upgrade of settings overhead when deactivating the plugin.
Multisite installs with Network Activation on the SLPLUS plugin properly migrates all subsite options to the latest release.
Add support for add on pack Apply To All actions
Fix private property warning on upgrade.
New filter slp_extended_data_update to be triggered any time extended location data is being updated.
Eliminate duplicate data save call when updating locations with extended data.
Add a popup notice when the reset manage locations button finishes processing.
Locations / Manage display drop down now warns if you select more than 500 locations at one time.
Locations / Manage display is now an instant-action drop down.
SLP records the active version of jQuery running on the UI on the page with the [slplus] shortcode.
Manage Locations Apply To All button allows actions to run on all locations for addons that are SLP 4.5 aware.
No country index 'unitedstates' on Country Manager when installing in some languages.
Fix Italy CCTLD to 'it' was incorrectly set to 'il'.
If the language translation file for the 'km' setting was not done consistently the km distance calculations would be incorrect.
The 'miles' and 'km' setting for the search form radius setting has moved to the Text Manager class for consistency. Non-English installs will need to update their translations at the MySLP site.
If you create a new translation set for Store Locator Plus for the following languages, please notify firstname.lastname@example.org: de_DE, es_ES, fr_FR, it_IT, ja_JP, lt_LT, pt_BR, sr_RS, zh_CN, zh_TW.
The latest version of the Pro Pack, 4.2.07, has been released with some new features including a “Recode All Uncoded” and “Load Data CSV Import”.
Recode All Uncoded
The Recode All Uncoded bulk action under Manage Locations will automatically select all of the uncoded (missing latitude and/or longitude coordinates) locations without the need to check the boxes. The process will automatically select all of the uncoded locations and re-submit them to Google for geocoding.
This will not magically fix addresses that Google cannot find. It is meant to assist sites that have more locations than the daily Google geocoding limit will support. The free Google Maps API limits location geocoding requests to 2500 per day per server. On a shared hosting server this can be a few hundred location “lookups” if other sites on the same server are using Google Maps. Recode All Uncoded will help quickly re-run locations that were previously imported but exceeded the geocoding limit for the day.
If you have Pro Pack version 4.2.06+ and Store Locator Plus version 4.2.41+ you can use the Load Data option with CSV Import. This feature uses the MySQL Load Data command is is 10-50x faster than WordPress / PHP CSV file parsing, with the typical Google Geocoding limitations on performance and record counts if you are not supplying the latitude/longitude data. This feature will only import basic location data. It does not import extended data fields or Tagalong category data. If you use this along with having pre-entered latitude and longitude values you can import 100,000 locations in less than 10 minutes on a basic web server. The column headers should be included in the file and should match the basic fields. You do NOT need to include all columns.
You can build a CSV-import ready export directly from MySQL if your MySQL user account has the GRANT FILE privilege on the WordPress Store Locator Plus file. You’ll typically need to login to MySQL from an administrative account to grant file to the WordPress or other user as follows:
> GRANT FILE ON wordpress.* TO 'wpuser'@'localhost';
You will replace wpuser with your WordPress username and ‘localhost’ with your MySQL server hostname or IP address.
With the file privilege set you can then export a CSV file for import with the following MySQL command:
SELECT * INTO OUTFILE 'geocoded_locations.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
This will create a geocoded_locations.csv file in the default MySQL WordPress files location, typically /var/lib/mysql/wordpress/ on a Linux system. You can specify a fully-qualified URL for the output file. The details on where the file is written by default and how to specify the full URL will depend on your web server settings.
You can now import the basic file using the Store Locator Plus Pro Pack by using the Load Data option with “first line has field names” and “skip geocoding” if you have the following CSV file header:
This will import the primary fields and ignore the secondary data fields that you will want to have re-created automatically.
Export All Hosted CSV
A new experimental feature has also been added. It is deemed “experimental” as it works on some systems but will not work on all systems due to directory security limitations. If this feature gets a lot of interest from the users it will be refined and kept in the product. Export All, Hosted CSV is a new CSV export feature that works much like the Export Locations download feature.
The Export Locations feature that existed in the past, and is now labelled “Export All, Download CSV” fetches the location data in CSV format and sends it to the browser for immediate download. This can be a time consuming process as not only does the server need to process the location list and write the data, but your browser needs to open up a local file on your device and write the data locally. Depending on how much memory you have on your device and the speed of your local drive the direct download process can be slower.
The Export All, Hosted CSV option keeps everything on the server. Your browser connection will remain active as Store Locator Plus reads all of the location records on the server and writes them to a disk file on the same server, however there is no browser download. For SOME users this will be faster, especially if you are on an older laptop or desktop. The file is written the the WordPress temporary storage directory on the server. For most Linux based hosts that will be in the /tmp directory which you may not have access to depending on your host. Some hosts will put temporary files in a local folder under your hosting account with the file name slplus_locations.csv. If there is enough interest, this option will be refined to allow users to specify the destination directory and filename. Site administrators can access the local server file using their hosting solution file manager or standard FTP/SFTP applications, which can be faster than browser-based downloads.
Pro Pack Change Log
Search Pages & Posts
Like what you are reading? Consider making a donation today. Most people donate $5 to $25, but any amount is appreciated!
Or send something on my Amazon Wish List!