{"id":1933,"date":"2026-07-22T09:12:37","date_gmt":"2026-07-22T06:12:37","guid":{"rendered":"https:\/\/presta.site\/blog\/?p=1933"},"modified":"2026-07-22T09:28:27","modified_gmt":"2026-07-22T06:28:27","slug":"prestashop-export-csv","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/en\/prestashop-export-csv\/","title":{"rendered":"PrestaShop Export CSV: How to Download Products, Customers &#038; More"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A <strong>PrestaShop export CSV<\/strong> download is how most merchants pull products, customers, or orders out of the Back Office for spreadsheets, accounting, or a quick backup of a filtered list. Unlike import, there is no single Advanced Parameters screen that dumps the whole shop &#8211; each list has its own export control.<\/p>\n\n\n<!--more-->\n\n\n<p class=\"wp-block-paragraph\">Need to <em>load<\/em> a file into the catalog instead? That uses Advanced Parameters \u2192 Import. See the full <a href=\"https:\/\/presta.site\/blog\/en\/quick-guide-to-importing-and-exporting-data-in-prestashop\/\" data-wpel-link=\"internal\">PrestaShop CSV import guide<\/a> for file prep, column mapping, and common import errors. This article covers export only.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Export vs import (and vs a real backup)<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Export<\/strong> &#8211; download what you see (or can filter) on a Back Office list, usually as CSV.<\/li>\n<li><strong>Import<\/strong> &#8211; upload a prepared file through the Import wizard to create or update data.<\/li>\n<li><strong>Backup<\/strong> &#8211; database + files so you can restore the shop. A CSV of products is not a restore plan. Use a proper <a href=\"https:\/\/presta.site\/blog\/en\/how-to-create-a-backup-in-prestashop\/\" data-wpel-link=\"internal\">PrestaShop backup<\/a> before risky changes.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Also: a list export is often <strong>not<\/strong> shaped exactly like an import sample. If you plan to edit and re-import, expect to remap columns (and check separators\/encoding) on the import screen.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to run a PrestaShop export CSV from a list<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the list for that entity (for example Catalog \u2192 Products, or Customers \u2192 Customers).<\/li>\n<li>Optional but recommended: use search and filters so the grid only shows the rows you need (one brand, one category, inactive products, and so on).<\/li>\n<li>Click the <strong>gear \/ settings<\/strong> icon at the top right of the grid.<\/li>\n<li>Choose <strong>Export<\/strong> to download a CSV of the current view.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1371\" height=\"392\" src=\"https:\/\/presta.site\/blog\/wp-content\/uploads\/2023\/06\/Screenshot_1-1.png\" alt=\"PrestaShop export CSV - Export button in the product list gear menu\" class=\"wp-image-769\" srcset=\"https:\/\/presta.site\/blog\/wp-content\/uploads\/2023\/06\/Screenshot_1-1.png 1371w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2023\/06\/Screenshot_1-1-300x86.png 300w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2023\/06\/Screenshot_1-1-1024x293.png 1024w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2023\/06\/Screenshot_1-1-768x220.png 768w\" sizes=\"auto, (max-width: 1371px) 100vw, 1371px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Repeat the same pattern on other grids that offer Export (orders, categories, and similar, depending on your version and modules). If the gear menu has no Export entry, that screen simply does not ship a native CSV download &#8211; use SQL Manager (below) or a module.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What a PrestaShop export CSV is good for<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Price or stock reviews in Excel \/ Google Sheets<\/li>\n<li>Handing a filtered product set to a colleague or agency<\/li>\n<li>A starting file before a careful re-import (after remapping)<\/li>\n<li>Quick checks after a migration or bulk edit<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Customer and address exports contain personal data. Store them securely, limit who receives the file, and follow GDPR rules if the data leaves the shop environment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Filters, multistore, and \u201cmissing\u201d rows<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Export usually follows the <strong>current list context<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Active filters and search reduce the file &#8211; clear them if you expected the full catalog.<\/li>\n<li>In <strong>multistore<\/strong>, switch to the correct shop (or all shops) before exporting. Exporting from the wrong context is a common reason products or prices look \u201cincomplete.\u201d<\/li>\n<li>Pagination does not normally limit modern list exports the way old screens did, but if a file looks truncated, clear filters and try again from the shop context you care about.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Custom columns: SQL Manager<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When the built-in Export columns are not enough (custom joins, only certain fields, a one-off report), use <strong>Advanced Parameters \u2192 Database \u2192 SQL Manager<\/strong>. Save a SELECT query, run it, and download the result. That is still an export workflow, but you control the columns &#8211; and a bad UPDATE\/DELETE query can damage the database, so stick to SELECT unless you know exactly what you are doing.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager-1024x758.png\" alt=\"PrestaShop export CSV - SQL Manager under Advanced Parameters Database\" class=\"wp-image-1936\" width=\"1024\" height=\"758\" srcset=\"https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager-1024x758.png 1024w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager-300x222.png 300w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager-768x568.png 768w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager-851x630.png 851w, https:\/\/presta.site\/blog\/wp-content\/uploads\/2026\/07\/sql-manager.png 1492w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">If you only need connection or host settings for tools outside PrestaShop, that lives elsewhere &#8211; see <a href=\"https:\/\/presta.site\/blog\/en\/how-to-change-database-connection-settings-in-prestashop\/\" data-wpel-link=\"internal\">database connection settings in PrestaShop<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">After you download the file<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open it in a spreadsheet and confirm separators (comma vs semicolon) before you share or re-import.<\/li>\n<li>Save a UTF-8 copy if accents look wrong in your editor.<\/li>\n<li>For a round-trip into the catalog, follow <a href=\"https:\/\/presta.site\/blog\/en\/quick-guide-to-importing-and-exporting-data-in-prestashop\/\" data-wpel-link=\"internal\">PrestaShop CSV import<\/a>: sample columns, mapping, and the \u201cdelete all before import\u201d warning.<\/li>\n<li>For very large order or catalog extracts on a schedule, a dedicated export module may be cleaner than repeating manual list exports &#8211; learn the native path first so you know what \u201cgood\u201d output looks like.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Native PrestaShop export CSV tools are simple on purpose: filter the list, hit Export, get a file. Use import when you need to write data back, and a full backup when you need a restore point &#8211; not a spreadsheet.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>How to export CSV from PrestaShop lists (gear menu), filters and multistore context, SQL Manager for custom reports, and how export differs from import and backups.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-1933","post","type-post","status-publish","format-standard","hentry","category-development"],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1933","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/comments?post=1933"}],"version-history":[{"count":3,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1933\/revisions"}],"predecessor-version":[{"id":1938,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/1933\/revisions\/1938"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=1933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=1933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=1933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}