Title: Duplicate Locations
Last modified: December 8, 2016

---

# Duplicate Locations

 *  Resolved [richjame](https://wordpress.org/support/users/richjame/)
 * (@richjame)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/duplicate-locations-3/)
 * Somehow every one of my locations is duplicated 4 times. Is there an easy way
   to remove any location that has the same address? There are now over 1800 locations
   and I don’t want to have to go through and individually delete each duplicate.

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/)
 * (@tijmensmit)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/duplicate-locations-3/#post-8532760)
 * They show up as duplicates in the search results, or only in the admin area?
 * I never used it myself, but one possible to way to fix this relatively easy is
   by exporting the store locations with [this](http://www.wpallimport.com/) plugin,
   sort the CSV file by address so you can easily spot the duplicates that you need
   to remove.
 * Then delete all existing locations, before import the modified CSV file with 
   WP All Import.
 * If you’re comfortable with PhpMyadmin, then I can share a SQL query that will
   bulk delete all locations.
 *  Plugin Author [Tijmen Smit](https://wordpress.org/support/users/tijmensmit/)
 * (@tijmensmit)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/duplicate-locations-3/#post-8532764)
 * How did you add the data in the first place?
 *  Thread Starter [richjame](https://wordpress.org/support/users/richjame/)
 * (@richjame)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/duplicate-locations-3/#post-8536540)
 * I was able to fix it by simply removing everything and reuploading.I uploaded
   the data using the CSV plugin that is an upgrade for the WP Store Locator product.
 *  [dagigt](https://wordpress.org/support/users/dagigt/)
 * (@dagigt)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/duplicate-locations-3/#post-8614436)
 * I’m also encountering the same problem. I tried removing all the locations and
   imported them again through the CSV manager but same thing. I have 2 copies of
   each location. I have carefully checked my CSV file so I don’t have any duplicates
   on my end.
    Please let me know what’s going on as soon as possible as I am on
   a deadline to go live.
 * Thank You.
 * P.S. It is a great add on
    -  This reply was modified 9 years, 4 months ago by [dagigt](https://wordpress.org/support/users/dagigt/).

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Duplicate Locations’ is closed to new replies.

 * ![](https://ps.w.org/wp-store-locator/assets/icon-256x256.jpg?rev=1007784)
 * [WP Store Locator](https://wordpress.org/plugins/wp-store-locator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-store-locator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-store-locator/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-store-locator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-store-locator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-store-locator/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [dagigt](https://wordpress.org/support/users/dagigt/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/duplicate-locations-3/#post-8614436)
 * Status: resolved