When editing a location with custom map markers available, the custom marker is not saved.
Steps To Reproduce
Make sure the Experience add on is active.
Edit an existing location.
Change the map marker via the map marker selector, a built-in marker is fine.
Save the location.
The map marker is not changed or saved to the database.
Resolution
Have \SLP_Admin_Locations_Actions::save_edited_location to call \SLP_Data_Extension::set_cols(true) after reading the pre-existing record in order to force the valid extended data fields to the full array.
While changed settings is an issue and still needs to be investigated, the main culprit here is the upgrade from MySQL 5 to MySQL 8. Servers were upgraded to MySQL 8 as the prior release we no longer supported. Amazon RDS services dropped support for the older MySQL version with a hard cut off in the fall of 2024. As such we were forced to upgrade MySQL; A good thing overall but it involved a lot of data query and code updates and testing.
MySQL added the work “rank” as a reserved word. This conflicts with our Professional an Enterprise feature that has used rank as a standard field name for a decade. Turns out we missed on location where we need to specially mark this field in the data query.
Any sites that have, or had, a location with the rank field set may experience an issue with initial location results not appearing.
Resolved in the 2502.24.01 update to the Experience module. Testing underway 25/02/24 13:00 EST. On production as of 25/02/24 14:45 EST.
Location categories provides a way to place categories into groups that can be filtered via the administrative tools and on the front end user experience.
Managing categories is provided by the Power add on.
Technical Implementation
The underlying technology uses the built-in WordPress category management system. Some of the core functionality of adding, removing, and assigning categories is managed by WordPress and thus requires additional testing whenever WordPress posts a new release.
The Power add on extend this default functionality to provide custom administrative and user interactions with location categories.
Testing Environment (July 2022)
WordPress 6+ Store Locator Plus 5.13+ Power Add On 5.11+
Related Use Cases
The use cases are based on the WordPress plugins. Most of the processes described within apply to the MySLP SaaS implementation as well.
Assumptions
WordPress environment is setup and configured including activation of the following plugins
Store Locator Plus®
SLP Power add on
In addition map service (Google API keys) should be in place and some locations should be added to the system.
A page has been created with the [slplus] shortcode present and the map is rendering properly.
Users are logged in as a WordPress administrator (the process will be slightly different for SaaS users).
Adding Categories To Locations
Objective
Create a location category and attach it to an existing location.
User Action: Add A Location Category
Click on Store Locator Plus® | Categories in the WordPress sidebar menu.
In the left “Add New Category Form”…
Type a category name. (Restaurant)
Click Add New Category
Result
The new category should appear on the category list on the page.
Category list after adding the restaurant category.
User Action: Attach Category To Location
Click on Store Locator Plus® | Locations in the WordPress sidebar menu.
Click the Edit action icon on the first location.
Check off the box next to “Restaurants” in the Power | Categories section of the form.
Click Save.
Result
The category is assigned to the location and appears on the location table.
The location with an assigned restaurant category. This view is showing fewer columns as the Screen Options was updated to removed unused columns from the table view.
User Action: Show Category Select On Front End
Click on Store Locator Plus® | Settings in the WordPress sidebar menu.
Change the Category Selector setting to “Single Drop Down”.
Click Save
On the front end, go to the page that has the [slplus] shortcode.
Result
The search form for the map should show a category drop down.
The front end page with the [slplus] shortcode, showing the category selection filter.
User Action : Filtering Locations With Category
On the front end, go to the page that has the [slplus] shortcode.
Enter an address, choose a category.
Click “Find Locations”.
Result
Only the locations that match the search criteria, including the category filter, should be shown.
