1 reply to this topic

[pixelteam]

I need a solution to the problem of the mismatch that appears in the CSV files when I use this module to export the products. I have not heard back from you, you have not responded to the emails I have sent you. I don't understand, why? Where is the technical support?

 

The module does not work properly when there is a line break in the product description, the CSV columns are all moved. It doesn't work properly. Can you please fix it or at least answer? 

 

Could someone help me? Thank you. Best regards.

 

Enrique

 

[pixelteam]

Could someone help me? Thank you. Best regards.

 

Enrique

[Janet scott]

It looks like Enrique is encountering a common issue with PrestaShop's CSV export module, where line breaks in product descriptions cause misalignment of CSV columns. This typically happens because CSV files use commas or other delimiters, and line breaks (e.g., \n or \r\n) within a field can disrupt the structure unless properly escaped.

In PrestaShop, to address this:

• Ensure the product description field is enclosed in double quotes (") in the CSV file to handle line breaks correctly.
• When exporting, use a text editor or spreadsheet software (like Excel or LibreOffice Calc) to check and adjust the CSV encoding (e.g., UTF-8) and delimiter settings.
• If the module itself is the issue, it might need a custom fix. PrestaShop’s default export tool should handle this, but if it doesn’t, consider:
  • Editing the module’s PHP code to escape line breaks (e.g., replace \n with a space or remove them) before export.
  • Contacting the module developer or PrestaShop support with details of the issue.