CSV Manager

CSV Manager

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 *.

CSV Manager Import

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.

CSV Manager Map

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.

CSV Manager Export

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.

Changelog
Version 1.1.3 - November 10, 2017
  • Fixed: Compatibility issue with PHP 7.1+.
  • Fixed: Spaces in CSV headers breaking the field mapping.
Version 1.1.2 - February 22, 2017
  • Fixed: Prevented the import from breaking on hosts that uses object caching.
Version 1.1.1 - November 21, 2016 Version 1.1.0 - November 6, 2016
  • 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.
Version 1.0.2 - January 25, 2016
  • Changed: Order the items in the export dropdowns alphabetically.
Version 1.0.1 - January 8, 2016
  • Fix: PHP 5.2 compatibility issue.