Tables and Category Data System

Posted by cici in Our Add Ons, Professional

Table

There are components of the Power Add-on that use the built-in WordPress category system involving several tables.   When moving sites over or combining sites, whether it be from a staging site, or  an older site  to a live site , getting the data in wp_slp_tagalong to match up with a pre-existing site that has pre-existing category data (taxonomies) will be a chore.

For example,

Under a Current site , there may have been an assigned Category “A” ID # 3 at the time the category was created in the taxonomy table but  Live may already be using that ID, therefore when you create a  Category “A” it may be assigned ID #19.

In order to “just move tagalong /categories over” you would need to edit every entry in the “wp_slp_tagalong” table and change ID # 3 to ID #19. To do so, you need to first let WordPress create all of the categories (you could do this with a category-only import) second look up all the ID numbers of the assigned categories, third edit the wp_slp_tagalong exported data from Current to change all of the ID numbers from the “old” WordPress site to be the ID# assigned on the “new (Live)” WordPress site. If you only have 2 or 3 categories it may not be a chore but it can get out-of-hand very quickly. If you make any editing mistakes you will have various issues.

WordPress table descriptions can be found under the WordPress Codex page Database Descriptions

The two tables that would be employed by WordPress when creating or maintaining a category:

wp_terms = the category information itself

wp_term_taxonomy = the metadata that tells WordPress about different category groupings, in other words “this category is for posts”, “this category is for Store Locator Plus locations”, “this category is for videos”, etc. You will not need to export/import this but you WILL need to know what the old (Current) system assigned as the SLP Locations taxonomy ID and what it is on the new WP system. When you export wp_terms from the old system you will need to edit that export and change the taxonomy ID from what it was on Current to what it is on Live.

Search and Results Report (Legacy: pre-2208.15)

Posted by lcleveland in Professional, Reports

The Power Add On for the self managed plug-in, or the Professional Level or higher of the MYSLP SaaS subscriptions include basic search and results reports.  When  enabled you will see a new Report tab on the Store Locator Plus admin pages. This tab is where you can view and generate locator search reports. See what visitors are searching for and what results are being returned.

Read More “Search and Results Report (Legacy: pre-2208.15)”

Directory City/State/Country Filters

Posted by lcleveland in Professional, Professional, Search, Settings

The directory feature of the Power add on allows you to quickly build a directory-style listing on your pages to show a list of cities, states, or countries where you have locations.

The [slp_directory] shortcode used to build this listing can be combined with a landing_page attribute to quickly refer your site visitors to an interactive map showing your locations in the selected city, state, or country.

Read More “Directory City/State/Country Filters”

Importing Large Lists into WP Store Locator Plus

Posted by cici in Locations, Our Add Ons, Professional

Hints for the WordPress Store Locator Plus stand alone, self managed plugin with Power add-on. Import features available with the Power Add-on

Load Data

If checked , use the faster MySQL Load Data method of file processing. Only base plugin data can be loaded, see the approved field name list.

This feature uses the MySQL Load Data command and is much faster than WordPress / PHP CSV file parsing, with the typical Google Geocoding limitations on performance and record counts (if you are not supplying, filling in the latitude/longitude data fields). This feature will only import basic location data. It does not import extended data fields or category data. If you use this along with  per-entered latitude and longitude values you can import 100,000 locations in less than 10 minutes on a basic web server. The column headers must be included in the file and must match the basic fields. You do NOT need to include all columns.

Read More “Importing Large Lists into WP Store Locator Plus”

Q: Can a store or location have more than one category assigned to it?

Posted by cici in FAQ

Can the stores be categorized by more than one taxonomy? Not multiple tags in a single taxonomy, but multiple tags from multiple taxonomies?

A: Stores only have one categorization class – the store page taxonomy.
However, WordPress Taxonomies are hierarchical. Therefore, you are able to assign all the attributes you need to your locations and use the parents of the branches to drive the user experience. The Power add-on has several UX components such as “drill down” menus that allow users to select a specific category by selecting a parent first then a child.

Read More “Q: Can a store or location have more than one category assigned to it?”

Adding Locations with additional features

Posted by cici in Enterprise, Extended Data Manager, Locations, Our Add Ons, Professional, Professional

If you have any of the Store Locator Plus featured Add-ons such as Power, Experience, or Premier add-ons , or if you have the MySLP Saas Professional or Enterprise level plan you will see additional sections when Adding (or managing) a Location.

You can opt to fill in all the rows and info that determine the Location and geocoding and hit Add button if you are done entering information. Or you can opt to continue to the next section, whether it be featured, tags, categories, or other functions that are in separate sections on the Location Add Tab.Click the “Add button” at the bottom of the next section instead.

For example, I want to add a location that also is going to have a category assigned to it. I have the latest version of the Power Add-on activated. After adding all the Location information, I do not click on the Add button under the location information but continue on down to the next section called “Power” and add whatever pertinent information I wish to add there. Once I am satisfied and have no additional data to add, I click on the Add Button under the Power section of the Locations Panel to create the location that I have just added.

The category or other additional data you just associated will appear when you review the Locations Page.When to click the add buttonaddlocationa nd acategories

Categories

Posted by cici in Data, Our Add Ons, Professional

The ability to categorize your locations using the WordPress category (taxonomy) system.  The Categories Manager (Formerly known as Tagalong) is part of the Power Add-on   for  WPSLP self managed customers, and available for the MYSLP Professional or higher plans)  It builds on the Store Locator Plus store_page taxonomy that is also used with the Pages portion of the Power Add-on (for WPSLP stand alone).  Build a “simple flat list” of categories or a hierarchical (parent/child) category structure. Once you’ve categorized locations you will find other added benefits on the user interface.

Read More “Categories”