CSV Import – Bulk Delete

This topic contains 5 replies, has 2 voices, and was last updated by  Paolo 6 years, 7 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • September 19, 2017 at 2:37 am #396364

    Craig Fryer
    Expired Member
    Post count: 110

    Looking for confirmation:
    From my searching of the forum it would appear that there is no way to do a selective bulk delete of items previously imported.

    For example: https://www.gojapango.com/tours/tour/
    380 tours and I need to remove 81 as they are no longer available.

    May be an alternative might be to change the listings Status from published to draft. Alternatively Visibility from Public to Private. This might be a better option as some of these tours may become available again.

    If bulk deleting is the best option, could it be done via MySQL queries?

    I see there is the table: wp_geodir_gd_tours_detail
    What other tables would need to have their entries updated?

    September 19, 2017 at 4:48 pm #396463

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    the other table would be wp_posts.

    However for 81 listings, I wouldn’t do it via database, I’d use the bulk delete option of WordPress.

    Thanks

    September 20, 2017 at 3:35 am #396544

    Craig Fryer
    Expired Member
    Post count: 110

    Thanks, I hadn’t realised there were Bulk Delete Plugins.

    September 20, 2017 at 6:17 pm #396622

    Paolo
    Site Admin
    Post count: 31206

    I wasn’t talking about that and I fear a plugin will not remove listings from the GD tables too.

    I was talking about this:

    September 21, 2017 at 12:29 am #396685

    Craig Fryer
    Expired Member
    Post count: 110

    Thanks Paolo,

    I realised this after I had installed the plugin. Fortunately I hadn’t used it yet.

    I found the easiest option was to do an over write csv import, but with the expiry date set to a recent date in the past. From there it was easy to do it the way you have suggested.

    September 21, 2017 at 6:28 pm #396810

    Paolo
    Site Admin
    Post count: 31206

    You are welcome 🙂

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket