Bulk update Titles and URLS

This topic contains 4 replies, has 3 voices, and was last updated by  P O 6 years, 1 month ago.

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

Open Support Ticket
  • Author
    Posts
  • January 21, 2019 at 10:32 am #464396

    P O
    Expired Member
    Post count: 501

    I need to update a lot of places titles and URLS. This are hotels and all of them start equal.

    Brand, Hotel name

    So I have something like this:

    Titles
    Brand name 1
    Brand name 2
    Brand name 3
    Brand name 4
    Brand name 5
    And so on.

    URLS
    brand-name-1
    brand-name-2
    brand-name-3
    brand-name-4
    brand-name-5
    And so on.

    I need to add the word “Hotel” before Brand in all places to Titles and URLs to end with something like this:

    Titles
    Hotel Brand name 1
    Hotel Brand name 2
    Hotel Brand name 3
    Hotel Brand name 4
    Hotel Brand name 5
    And so on.

    URLS
    hotel-brand-name-1
    hotel-brand-name-2
    hotel-brand-name-3
    hotel-brand-name-4
    hotel-brand-name-5
    And so on.

    Please share those two SQL Querys to update Titles and URLs.

    Thank you.

    January 21, 2019 at 11:31 am #464408

    Guust
    Moderator
    Post count: 29970

    Is the category called Hotels?
    Then the Meta and Title settings should be able to fix something similar?

    Thanks

    January 21, 2019 at 11:33 am #464409

    P O
    Expired Member
    Post count: 501

    Yes, the category is Hotels in Spanish: Hoteles

    Thank you.

    January 21, 2019 at 5:45 pm #464507

    Paolo
    Site Admin
    Post count: 31211

    This is easier done via Export / Edit CSV / Import back to update.

    We don’t provide SQL queries as part of support.

    Thanks

    January 21, 2019 at 6:32 pm #464516

    P O
    Expired Member
    Post count: 501

    Actually it is a lot easier with a query. The import – export, with special formats, special apps, 8 warnings telling you if a comma is wrong you will destroy your site and so on, it is not easy at all, actually scary and for sure the site ends in a mess using that.

    Can anyone please share a database query?

    Thanks.

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

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount