Locations import error

This topic contains 5 replies, has 3 voices, and was last updated by  Kiran 6 years, 4 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • August 16, 2018 at 4:33 pm #442739

    coreyhammond
    Full Member
    Post count: 58

    I am trying to import locations across the US. I have the file formatted, but its skipping about 1/3 of my locations saying they’re duplicates:

    Total 29545 item(s) found.

    18621 / 29545 item(s) added.

    10917 / 29545 item(s) ignored due to already exists.

    7 / 29545 item(s) could not be added due to blank/invalid address(city, region, country, latitude, longitude).

    Why would it be doing this? For example, it imported Cleveland, Alabama – but skipped Cleveland, Ohio

    August 16, 2018 at 4:35 pm #442740

    coreyhammond
    Full Member
    Post count: 58
    This reply has been marked as private.
    August 17, 2018 at 6:10 am #442774

    Kiran
    Moderator
    Post count: 7069

    Hello,

    I looked csv file you have attached. I am sure you have ticked option “Ignore item if item with location_id/city_slug already exists.” during location import (see screenshot attached).
    If location id or city_slug already exists then it will choose appropriate step either update or ignore.

    Now look at the city_slug column in your csv there are many city with duplicate city_slug. Ex; There are around 18 rows with city_slug cleveland. Add region code to make city slug unique when there are many city with same name/slug. Ex: cleveland-al for Cleveland, Alabama & cleveland-oh for Cleveland, Ohio.

    FYI: If you enable debugging via config.php file then it will log there about which raws has issue during import.

    Thanks,
    Kiran

    August 17, 2018 at 10:03 am #442787

    Alex Rollin
    Moderator
    Post count: 27815

    Instructions for diagnosing import issues with debugging can be found here:
    https://wpgeodirectory.com/docs/core-export/#debug

    August 17, 2018 at 12:58 pm #442816

    coreyhammond
    Full Member
    Post count: 58

    The problem is I want as clean of URLs as possible, and I have permalinks setup to be /us/ohio/cleveland and /us/alabama/cleveland

    If I have a unique location id, why can’t the slugs be the same?

    August 17, 2018 at 1:05 pm #442819

    Kiran
    Moderator
    Post count: 7069

    Hello,

    Cities with same slug may have issue in retrieving correct city. Even WordPress adds “-1” “-2” to post and category/tags slugs when threr duplicate slugs.

    See https://wpgeodirectory.com/docs/faqs/#qafp-faq59

    Thanks,
    Kiran

  • 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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount