CSV Import Listing Duplication

you would have to run a query to join the two tables and get listings only where they have the same key, then do a foreach to delete them the proper way.

Stiofan

There is no easy way to do this as you need to know what ones to delete, i don’t wan to give you a query to delete things and then it turns out to be the wrong ones

A query like this should identify the duplicatres

SELECT GROUP_CONCAT(post_id), post_title, COUNT(*) geodir_businesskey FROM wp_geodir_gd_place_detail GROUP BY post_title HAVING geodir_businesskey > 1;

From there you could do a few things but only a dev could write something to do it automatically.

Stiofan

I do not think this is a GD problem as no one else has reported it, but i have added a task to add a tool for duplicates, it is an enhancement meaning it will be worked on when all higher priority things are done first: https://github.com/GeoDirectory/geodirectory/issues/394

That query i gave you will allow you to get the IDs of duplicates and maybe there is a plugin or something that can delete by id (not checked)

Thanks,

Stiofan

You too Al 🙂