importing categories with commas in the csv file

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

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

Open Support Ticket
  • Author
    Posts
  • November 14, 2014 at 9:30 am #21493

    Kenny Eliason
    Expired Member
    Post count: 54

    Hey-o! Thans for the great plugin and the extra great support you all provide!

    On this one, I’m trying to import listings using the importer tool you all provide. For the category section, your example csv shows a comma separated list of categories in the category column.

    My import has numerous categories that contain commas inside the category name. For example, “Hot Rods, Street Rods, Etc.” would be one category, not three. I’ve properly wrapped any category that contains a comma inside of double quotes, but they’re not importing any of the categories that are wrapped in quotes. Do you have another way I should wrap the categories that contain a comma?

    Hopefully that makes sense. Let me know if not and I’ll try and clarify more!

    November 14, 2014 at 4:18 pm #21528

    Paolo
    Site Admin
    Post count: 31206

    Have you tried importing using the category slug instead of the name?

    It should work…

    p.s. it is unclear in your post if you have or not categories created in advance. That is mandatory.

    Let us know,

    Thx

    November 14, 2014 at 5:25 pm #21540

    Kenny Eliason
    Expired Member
    Post count: 54

    Categories are already imported, sorry should have said that. Here’s a sample import file, let me know if you see any issues with the category column specifically, before I try and match up the slugs (which would be significantly more complicated)…

    November 14, 2014 at 6:59 pm #21550

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    we just looked into it in details and currently there is no way to import categories with commas in their name via csv file, because we use explode to separate the categories delimited by commas and explode does not recognise escape characters.

    Slugs will not work either, it only work by category name.

    The only quick solution would be to avoid using commas in categories (if are to be imported via csv).

    Or modify the category name removing all commas before importing and than add them back after import is done.

    Thx

    November 14, 2014 at 7:26 pm #21556

    Kenny Eliason
    Expired Member
    Post count: 54

    Freak, that’s a bust. I’ll work through those then. Bummer.

    November 14, 2014 at 7:26 pm #21558

    Kenny Eliason
    Expired Member
    Post count: 54

    Can’t import with the category ID, can we?

    November 14, 2014 at 7:34 pm #21563

    Paolo
    Site Admin
    Post count: 31206

    nope sorry, only name.
    thx

    November 14, 2014 at 11:28 pm #21588

    Kenny Eliason
    Expired Member
    Post count: 54

    Okay, I’m going to replace all commas with ” – “, we’ll survive that. So question then, you said to first import the categories. Since I have to re-import the categories at this point, want to make sure I do it right. How do you recommend importing all the categories?

    Thank you so much for all the help, seriously.

    November 14, 2014 at 11:32 pm #21589

    Kenny Eliason
    Expired Member
    Post count: 54

    My category import file (attached).

    November 14, 2014 at 11:36 pm #21591

    Paolo
    Site Admin
    Post count: 31206

    Categories can’t be imported, they have to be created in advance.

    Thx

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

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

Open Support Ticket