In the United States many northeastern postal codes start with zero. Many sheets, Microsoft Excel in particular, LOVE to leave off the leading zero if you enter a zip code as 03907 and save as CSV.
In Excel, and many other apps, you can force a field where you are typing in numbers to be text by starting your entry with an apostrophe (‘). Type ‘03907 when entering the data NOT 03907.
A good test to see if this is happening to you, open your CSV file in Google Sheets and see what it looks like. Does it look like the sheet above missing a zero and right aligned?
Another indicator that this column is set to a numeric type and not an text type is the data is on the RIGHT SIDE of the cell. Text is left-justified (like sl_state) and numbers are right-justified.
If you are using the WPSLP “do it yourself” plugin with Power add-on and you have not included the latitude and longitude and require geocoding , make sure you have a Google API account and have checked off the Maps and Geocoding APIs in your library.
The Locations panel in Store Locator Plus is where you add, manage, edit and/or delete locations.
Actions and Filters
Under the Manage Locations panel there are drop down fields and filters that can be applied to display the pagination interface. If you have a large number of locations, bulk actions can be a very useful tool. If you have more locations than can fit on the display, you can set the display filter to show more locations. You may also use filters to display and manage non – geocoded locations, or show locations with certain properties. The display can be adjusted to suit your needs but configuration constraints and/or server constraints may effect your outcome.
Not all Bulk actions will appear if you have only the base plugin installed. Bulk action filters for removing Tags, performing Exports, geocoding all uncoded, and bulk categorize certain locations will be shown if you have the WPSLPPower add-on or Power level Plan for MySLP
The default number of locations that will be displayed on the admin user Interface is 10. Selecting a large number to display can be useful to view or manage but if your server capacity cannot handle it or changes and you go back to manage locations months or years later and try to access your locations panel, you may see no locations panel. If you see the wheels churning on your computer with no results this could be the reason. If you are not sure of the capabilities of your server, browser and various other factors that effect memory, and inhibit loading and displaying fields, err on the side of caution and set the Filter Display locations back to a manageable size before leaving the panel. If you are migrating servers from a “heavy duty” server to a less robust server, or if your memory becomes an issue you will need to reset the display to a manageable number. If you do not take this precaution , the only way to reset the display field is by using Janitor. See Troubleshooting for more info.