Export PrestaShop accounts created with Facebook Login

Basic tutorials 21.11.2019 customer, export, facebook, mysql, SQL

Export customer accounts created with Facebook

If you are looking for a guide about exporting customer accounts (that were created with Facebook Login) - check this step by step tutorial.

If you are looking for a way to export Customer accounts created with our facebook login module dedicated for PrestaShop 1.7, 1.6 and 1.5 - this is the article that will help you. To achieve this we will use default prestashop's features - in this case the feature is "Database manager" that is available under "advanced paramters" menu in shop's back office.

Export accounts created with facebook login

Go to advanced parameters > DATABASE

Create there sql query (there is a button + add new sql query - just hit it)

SELECT * FROM ps_customer c INNER JOIN ps_fblogin fb ON fb.id_customer = c.id_customer

then on list of created queries click on "EXPORT" near the query you created:
prestashop will prepare csv file with customer accounts created with export module