Duplicate Locations

  • Resolved richjame

    (@richjame)


    9 years, 5 months ago

    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

    (@tijmensmit)

    9 years, 5 months ago

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

    (@tijmensmit)

    9 years, 5 months ago

    How did you add the data in the first place?

    Thread Starter richjame

    (@richjame)

    9 years, 5 months ago

    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

    (@dagigt)

    9 years, 4 months ago

    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.
Viewing 4 replies - 1 through 4 (of 4 total)

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