The Power Add-on Import allows the administrator to schedule your Import process from a remote file retrieval to provide more control over recurring imports from a full url where you CSV file resides and allows flexibility for scheduling the time for daily imports. WordPress cron is not exact, it executes the next time a visitor comes to your site. […]
If you have the Power add-on you will have the ability to import data fields via a properly formatted csv file. All columns MUST have a header row with the field name. All fields are short text fields, up to 255 characters, unless otherwise noted. The header text is NOT case sensitive. If you are using […]
Question: I would like to use your WordPress plugin to add location searching to my site. I would like to be able to rank and even possibly remove locations from the search results. Also, each location offers different products of mine. So, if a user selects a product and a zip code I would like […]
Issue: Exports are Incomplete Multiple large-scale exports (export function is available with Power Add-on ) have been tested on the Store Locator Plus dev site. On a relatively small server, a virtual machine with 2GB RAM running CentOS 6, we have been able to export 10,000 locations within 15 minutes with no issues. Special characters […]
Some clients have datasets of 200,000 locations, none of which include latitude/longitude coordinates, only U.S. street addresses. Often customers want to know import limitations to including Google’s limit of 2,500 daily requests. In order to perform bulk location imports with a CSV file you will need to the Power add-on installed. The following constraints can […]
Import features are 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 Power Add On allows you to import CSV files with several options. One of those options is “duplicates handling”. Duplicates handling determines how to deal with locations in your CSV file that may match pre-existing locations on your site. There are several options available for duplicates handling including Add, Skip, and Update.
People often ask for examples of CSV import files. Here are some examples you can use as a model for your own imports. You will need the Power add-on to import locations. Example of what your Excel or Google Sheets with CORRECT SL_FIELD NAMES in the header rows would look like:
Importing locations with territories follows the same procedure as importing a standard locations file. As with all location files the format must be a proper CSV file exported using the UTF-8 character set with no special or non-printable characters. To load the territory data you must have first enabled the territories feature in the Premier […]
The location imports have been updated with the Power add on in order to simplify and speed up the import process. The CSV file format remains as the preferred import method for locations. CSV File Format The CSV file should be a UTF-8 encoded file with proper quotes around strings and commas between fields. Special […]