csv

Definition of a CSV File

The acronym CSV stands for Comma-Separated Values. In computing and e-commerce development, a CSV file is a plain text format used to store tabular data. Within the PrestaShop ecosystem, the CSV format is the universal standard for massively importing, exporting, and updating large quantities of data, such as product catalogs, combinations, or customer databases.

How a CSV File Works Technically

Although a CSV file opened in a basic text editor (like Notepad) might look like a chaotic string of words, it has a strict logical structure that is perfectly readable by spreadsheet software like Microsoft Excel or Google Sheets.

  • Rows (Records): Every single line in the file corresponds to a unique record. In a catalog upload, each row represents a single product.
  • Delimiters (Fields): Within the same row, different attributes (Name, Price, Quantity) are separated by a special character known as a delimiter. In Europe, the semicolon (;) is widely used to avoid conflicts with decimal commas in prices (e.g., 10,50€).

The Importance of CSV Formatting in PrestaShop

Managing an online store requires handling thousands of SKUs. Manually entering products would take months. Using PrestaShop's native tool (Advanced Parameters > Import), a CSV file drastically cuts down this time.

Common use cases include platform migration (moving data from another CMS to PrestaShop), ERP synchronization, and bulk price updates during promotional sales.

Golden Rules for a Perfect CSV

A poorly formatted file can cause blocking errors. For a safe import:

  • UTF-8 Encoding: The file must be saved in UTF-8. This ensures the server correctly interprets accented letters and currency symbols.
  • Image Handling: You insert the absolute URL of the image into the CSV. PrestaShop will download it and generate the necessary thumbnails automatically.
  • Unique Identifiers: Always use the ID or SKU to update existing products without creating duplicates.

SEO Optimization via CSV

By exporting your catalog as a CSV, you can analyze your entire site structure. You can mass-rewrite Meta Titles, Meta Descriptions, and clean up Friendly URLs all at once, then re-import them, rapidly enhancing the technical SEO quality of your site.