How to change CSV separator

  • Resolved pepito84

    (@pepito84)


    6 years ago

    Hi there,

    as my subject alreadys says I want/have to change separator from comma to semicolon otherwise I can’t create an feed for CHECK24.

    How can I do this?

    Thank you!

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support C S Sultan

    (@sultan00rextheme)

    6 years ago

    Hi, can you collect the instructions for feed specification from Check24 and give it to us? Then we can work on creating the structure for you.

    Thanks.

    Thread Starter pepito84

    (@pepito84)

    6 years ago

    This is an example feed from CHECK24 in german:
    EAN;"Eindeutige ID";Lieferzeit/Verfügbarkeit;"Preis in Euro (inkl. MwSt.)";"Versandkosten in Euro";Bestand;Hersteller;"Kategorie im Shop";"Link Produktdetailseite";Produktname;Produktbeschreibung;"URL Produktbild"
    4211129051101;1254679;"sofort lieferbar";69.99;13.99;200;WMF;Küchengeräte;http://www.ihr-shop.de/produkt/wmf-toaster.html;"WMF Toaster Lineo";"Langschlitztoaster im Edelstahl-Design";http://www.ihr-shop.de/produkt/bilder/wmf-toaster.jpg

    I translated the columns headers for your better understanding:

      (m) = Mandatory
      (o) = Optional

    EAN (m);unique ID (m);delivery time/availabilty (m);price in euro (incl. Tax) (m);shipping cost in euro (m);stock (o);manufacturer (o);category in shop (o);link to product (o);productname (m);product description (m);URL product image (o)
    4,21113E+12;1254679;sofort lieferbar;69.99;13.99;200;WMF;Küchengeräte;http://www.ihr-shop.de/produkt/wmf-toaster.html;WMF Toaster Lineo;Langschlitztoaster im Edelstahl-Design;http://www.ihr-shop.de/produkt/bilder/wmf-toaster.jpg

    Ordering of columns is as it is from example csv from CHECK24.

    • This reply was modified 6 years ago by pepito84.
    • This reply was modified 6 years ago by pepito84.
    Plugin Support C S Sultan

    (@sultan00rextheme)

    6 years ago

    Thanks. I have forwarded these data to our developers. I will give you an update on it soon.

    Plugin Support C S Sultan

    (@sultan00rextheme)

    6 years ago

    Hi @pepito84 , we looked into it. It seems setting up a semi-colon separator will take some time.

    For now, what you can do is, you can generate a CSV file, then use any converted to change the delimiters. (Here’s an online tool that might work.)

    I will inform you when we are able to release the update with the proper format for semi-colon CSV.

    Thanks.

    Thread Starter pepito84

    (@pepito84)

    6 years ago

    @sultan00rextheme Thank you for your support!

    Plugin Support C S Sultan

    (@sultan00rextheme)

    6 years ago

    You’re welcome. Feel free to let us know if you face any more issues. Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘How to change CSV separator’ is closed to new replies.