While importing a CSV file of products is a built-in feature in PrestaShop, unfortunately, exporting the product catalog is not. There are quite a few modules available for PrestaShop that offer this feature, but finding a free one is definitely a challenge. Most likely this is due to the intricacies of the PrestaShop database table structure. Product data is stored in multiple tables, which means the query to extract that data is not easy to create.

If you are comfortable running SQL queries, you can use the SQL tab of phpMyAdmin in your cPanel to query the database tables for the product information you want to retrieve and export that data as a CSV or other type of file. However, for most people, this will not be a workable solution.

If you simply want to create a backup of your store (including your products) it's actually much easier to make a backup of the entire PrestaShop database. You can backup your database either through the PrestaShop back office or by exporting the database through phpMyAdmin in your cPanel. When saving a backup from phpMyAdmin you will have the option to save the file as a CSV file or other format if you prefer.

Exporting Products with the Free PrestaShop Store Export Module

We were able to find one free PrestaShop export module that does make it easy to download your product catalog data as a CSV (Comma Separate Values) file. The PrestaShop Store Export module, created by Presta Fabrique, makes it possible for you to not only export your product data, but categories and other PrestaShop catalog information as well. Since this module can be a bit difficult to find, we're making it easy for you to download the Store Export module here:

PrestaShop Store Export Module  

NOTE:  As per the screenshot below the Store Export module for PrestaShop is made by Presta Fabrique.  They have graciously provided the free module and only ask for donations should you find that it is a working solution for your shop.  Click on the either the link for the download above or their homepage link for further information.

If you need any assistance installing the PrestaShop Store Export module, please see our article on installing PrestaShop modules.

Once you have installed the PrestaShop Store Export module, click the Configure link to begin using the module.

presta-export-configure

This will take you to the Export options page. Choose the type of data you want to export from the drop down menu beside Select which entity to export:

presta-export-data-options

Click the Export button to begin exporting the product catalog.

presta-start-export

Depending on your browser settings, your file will either be automatically downloaded to your default download folder or you will be prompted to download the file to a folder of your choosing. Once your export is downloaded, you can then open the CSV file with your preferred program (e.g. text editor, spreadsheet program, etc.).

Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve our Help Center:
Email Address
Optional, but our team may contact you for more information.
Did you find this article helpful?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.