Child pages
  • CSV Import Parameters

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

CSV is an acronym of "Comma-separated values". It is a popular plain-text format when there is a need to import, export or simply store data in a non-proprietary format. Almost all data handling tool support CSV format, in various incarnations. You can read more about the CSV format on Wikipedia: http://en.wikipedia.org/wiki/Comma-separated_values.

Image RemovedImage Added

The import process requires preparation, and starts with a form made of primary settings:

  • What kind of Entity entity would you like to import?. Entities are the types of data that you can import. The "Available fields" on the right updates when you choose an entity, so that you know the kind of data that your CSV file should contain.
    PrestaShop enables you to import the following types of data:
    • Categories,
    • Products,
    • Combinations,
    • Customers,
    • Addresses,
    • Manufacturers,
    • Suppliers,
    • AliasAliases,
    • Supply order orders (if Advanced Stock Management is enabled),
    • Supply order details (if Advanced Stock Management is enabled).
  • Select your a CSV file to import. You can import more than one file at a time, but make sure that they all contain the same type of data.

    Tip

    You can download sample files for each type of data from the "Download sample CSV files" section on the right. This helps you compare these sample files with your own files, so that you can make sure that the files you are about to import are indeed ready to be imported to PrestaShop. These files are actually stored in the /docs/csv_import folder of your installation of PrestaShop.

  • Language of the file. Data can only be imported for a single language at a time. If your data exists in more than one language, you should split it into as many files.

  • ISO-8859-1 encoded file?. By default, the import files should use UTF-8 encoding. But if your files use ISO-8859-1 and you would rather not convert them, you can check this box.
  • Field separator. Not all CSV file use commas to separate their values: some use tabulations, others semicolons, etc. You can indicate what your files use in this field.
  • Multiple value separator. When an attribute can support more than one value, these values need to be separated with a specific separator. After reviewing your files, indicate your separator here.
  • Delete all ___ before import?. This option will erase all previously existing entries of the type of data you are importing. Thus you will start with a clean slate.
  • Use product reference as key?. Product import only. You can choose to have the product key be determined by PrestaShop, or instead use the product's reference as the ID. In this case, make sure the file does contain references for all your importer products.
  • No Skip thumbnails regeneration. Category and product import only. You can choose to have PrestaShop regenerate the thumbnails that are linked from your CSV file (in the "Image URL" or "Image URLs" fields).
  • Force all ID numbers. You can either keep the imported IDs, or let the importer auto-increment them.

...