How to change CSV separator

  • Resolved pepito84

    (@pepito84)


    4 years, 10 months 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)

    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)

    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;https://www.ihr-shop.de/produkt/wmf-toaster.html;"WMF Toaster Lineo";"Langschlitztoaster im Edelstahl-Design";https://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;https://www.ihr-shop.de/produkt/wmf-toaster.html;WMF Toaster Lineo;Langschlitztoaster im Edelstahl-Design;https://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 4 years, 10 months ago by pepito84.
    • This reply was modified 4 years, 10 months ago by pepito84.
    Plugin Support C S Sultan

    (@sultan00rextheme)

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

    Plugin Support C S Sultan

    (@sultan00rextheme)

    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)

    @sultan00rextheme Thank you for your support!

    Plugin Support C S Sultan

    (@sultan00rextheme)

    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.