Removing Duplicate Rows

Remove Duplicate Option #

Since version 4.7.20, we have included a new option to directly remove the duplicate stores from the stores’ table, you simply need to click on that button to remove the duplicate rows, here are the steps:

• Go to the Import/Export page of the Store Locator
• Click on the Remove duplicates button as in the screenshot below.

Avoid Duplicates during the Import of CSV #

Our import process has a new control added by using that duplicates rows in the CSV file will be skipped and you don’t need to worry about duplicates in the stores’ table, you have to select a filter column that you want to apply during the import process, it can be either the title, phone, email, or coordinates.

Remove Duplicates through CSV #

Before importing a CSV file it is important to make sure that the file does not have any duplicate rows. Furthermore, having duplicate rows means the store’s data will be imported twice.

To remove any duplicate rows from the CSV file, please do the following:

1.  Open the CSV file
2. Remove the duplicate records from the CSV file
3. Delete any previously existing records via the red button on the Import/Export page
4. The last step will be to import the data only once.