The CSV Manager provides an user-friendly way to bulk import, export, and update the location data.
Import
You can import the address, opening hours, store categories, featured images, custom meta fields, and other details for multiple locations via a CSV file. If no coordinates are provided, then the location is automatically geocoded *.
After you have uploaded the CSV file, you can map the CSV headers to the WPSL fields. This is done automatically as long as the CSV headers match the names of the WPSL fields.
Export
The exporter enables you to export all the locations at once, or use one of the filters to export the locations by category, city, or country.
Update
If you want to update existing locations, you will need to first create a CSV export, then update the data, and then re-import the updated CSV file.
* Restrictions exist for usage of the Geocoding API.
- Fixed: Prevented the import from breaking on hosts that uses object caching.
- Fixed: Made sure terms exist before running wp_update_term_count_now. Otherwise a SQL error shows up when all the locations are bulk deleted. Via Benjamin Borowski.
- Added: A tools section where you can bulk delete all existing locations.
- Added: The option to export locations by state.
- Added: Three new capabilities for the Store Locator Manager role ( wpsl_csv_manager, wpsl_csv_manager_export and wpsl_csv_manager_tools ) that lets you restrict access to the different sections of the CSV Manager.
- Added: A check if the required fields ( name, address and city ) are set after uploading the file. If not, then an error notice is shown.
- Changed: The opening hours are only included in the export file if they are enabled on the WPSL settings page.
- Changed: Use get_sites instead of wp_get_sites for WP 4.6+ sites.
- Fixed: A foreach error that was triggered by incorrect opening hours data during an export.
- Changed: Order the items in the export dropdowns alphabetically.
- Fix: PHP 5.2 compatibility issue.