How to Export Products from PrestaShop (2026 Guide)

Open your browser and navigate to your PrestaShop admin URL, typically at yoursite.com/admin or a custom admin path. Enter your administrator email and password to access the Back Office dashboard.

In the left sidebar menu, click on Catalog to expand the submenu, then click on Products. This opens the product listing page showing all your store products with their ID, image, name, reference, category, price, quantity, and status.

At the top-right of the product list page, look for the Export button (sometimes shown as a gear icon or an Exporter button depending on your PrestaShop version). In PrestaShop 1.7 and later, this is typically a clearly labeled Export button in the top toolbar area.

Depending on your PrestaShop version, you may see options to filter which products to export. You can limit the export to products in a specific category or matching certain criteria. In some versions, the export begins immediately with all products when you click the button.

Tip: PrestaShop uses semicolons as the default CSV delimiter instead of commas. If your spreadsheet application shows all data in a single column, try re-importing with semicolon as the delimiter.

Click the Export button to generate the CSV file. PrestaShop will create the file and prompt your browser to download it automatically. The export includes all product fields such as ID, Name, Reference (SKU), Price, Quantity, Categories, Descriptions, and Images.

Warning: PrestaShop exports may use semicolons instead of commas as delimiters. When opening in Excel or Google Sheets, make sure to select the correct delimiter to avoid data appearing in a single column.

Open the downloaded CSV in Google Sheets or a spreadsheet application. Verify that product names, references, prices, quantities, and categories are correctly populated. Category paths use a hierarchical format like Home > Clothing > T-Shirts.

PrestaShop uses specific formatting conventions in its CSV export. Boolean fields use 0 and 1 values. Category and tag fields use comma or semicolon separation depending on the version. The Feature column uses a structured format of Name:Value:Position:Customized. Familiarize yourself with these formats before processing the data.

Tip: If you need to re-import updated products, keep the ID column intact and match it to existing products. The Reference field serves as the SKU for inventory tracking.