GD WP Import formatting issue

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

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

Open Support Ticket
  • Author
    Posts
  • December 7, 2019 at 3:38 pm #520415

    riobravomedia
    Expired Member
    Post count: 361

    Hey Support,

    Hoping you can help me. Just so you know the GeoDirectory WP All Import plugin is working awesome now! Thanks guys for getting that sorted! I am not very good with CSV files and am running into an issue with Category ID’s. Let me explain

    When I download or export current listings, so that I can see the header columns etc. the categories are listed like “,81,9,12” in the post_category column. Right?

    My problem comes in when I try to paste a column of categories like this as it puts them into different columns… comma separated. You probably know this, right?

    Also if I put ,9 into the main category and then drag to copy.. I get addition hence ,9,10,11 etc. Also not what I want, right?

    My question is how can I edit these columns without having these issues so that my import will go smoothly? otherwise my options that I see now are to manually edit each column or have to manually edit each listing (which I sure am trying to avoid)

    I am using the Mapping Categories option. See screenshot. Is there a different way to do this?

    December 7, 2019 at 5:47 pm #520430

    Alex Rollin
    Moderator
    Post count: 27815

    Hello,

    You are asking about copy/pasting into a spreadsheet?
    Or into the WP All import pro settings?

    December 7, 2019 at 6:39 pm #520441

    riobravomedia
    Expired Member
    Post count: 361

    Columns… CSV’s…. etc = A spreadsheet.

    A spreadsheet is where I am having trouble… setting it up before importing it into GD using WP All Import and GD WP All import Plugin.

    December 9, 2019 at 8:35 am #520575

    Alex Rollin
    Moderator
    Post count: 27815

    I understand what you mean, I will pass on your feedback to the developers. At this time I don’t have any advice about how to make that easier, though.

    December 9, 2019 at 1:09 pm #520604

    riobravomedia
    Expired Member
    Post count: 361

    Alex,

    In my case I have 305 or so restaurants to edit. That is going to be very time-consuming to edit them manually. Let me ask you a question.

    Do you know if it is possible to do a reverse mapping in WP All Import. Maybe that is not the right word to describe it.

    But in the screenshot that I attached above…could I reverse those columns where in the column “In My file” I could put the name of the category and in the “Translated To” column that I could put the category ID. Would that work?

    December 9, 2019 at 3:17 pm #520630

    riobravomedia
    Expired Member
    Post count: 361

    Alex, how do I connect with @picocodes (Brian) to ask him about this? He helped with the GD WP all Import plugin issue recently and helped me get that sorted. Wondering if he has any ideas on this. Thanks.

    December 11, 2019 at 6:34 pm #521037

    riobravomedia
    Expired Member
    Post count: 361

    I was able to figure it out. I used a pipe symbol “|” and then did a copy and replace in the csv and that worked.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 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