product data are not properly retrieved during excel import

  • Resolved CGC studio

    (@cgc-studio)


    9 years ago

    After exporting my shop’s products in csv file with WooCommerce – Store Exporter, I have 2 major issues (in a Mac config) :

    1/ all the accented characters (Latin) are no well displayed. i get some weird symbols instead !!
    e.g. “??” instead of the french “é”, “?¨ “instead of the french “è” etc.
    I tried each of the 3 settings I have on Excel import process i.e. :
    Macintosh, Windows (ANSi, DOS ou OS/2 (PC-8) but nothing is resolved !

    2/ 2/3 of products data are not displayed in the right column (they’re staggered) !! Importing them in Excel, I tried all possible settings (tab or semicolon or comma with and without space in between) but nothing works properly !!

    Could you help me ?

    TIA

    CGC

    https://www.ads-software.com/plugins/woocommerce-exporter/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter CGC studio

    (@cgc-studio)

    Here’s some further information about issue #2 :

    The problem appears only in “product description” field : as we used html styling inside (e.g. tags) or linebreaks or even commas inside text, ones of these characters seem to break the text flow and stagger/divide it in several column : and that’s precisely the point !!

    If these characters are not responsible of the issue, could it be the weird symbols which appeared instead of accented latin characters which could concerned ??

    The fact is that If I do my products export without this specific field using styling, everything is ok !!!

    Thank you very much for your help

    CGC

    Hi CGC, that’s weird that only the Product Description field is causing this break in the UTF-8 file type, it does seem like HTML formatting could be the culprit here as well as the inclusion of line breaks causing Excel to mis-read our export file. I’d be happy to work with you directly and send you a copy of our Pro Plugin to reproduce this there too, my e-mail is [email protected] ??

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘product data are not properly retrieved during excel import’ is closed to new replies.