Import/export customers via from csv or excel

[eugene17]

hi guys,

is it possible to export the customers from the manage customers to a csv or excel file?

subsequently, is it possible to upload customers from a csv file?

would be really helpful as we have a physical store and we want to manage all the customers via wpestore.

thanks!

[amin007]

Yes, you can export the customer details from the “manage customers” to a CSV or Excel file from your PHPMyAdmin (you can access it from cPanel).

Simply go to your PHPMyAdmin and find the following database table inside your WordPress database:

wp_wp_eStore_customer_tbl

Now, click on “Export” and choose “CSV” then hit “Go” and it should take care of it.

This video tutorial maybe very helpful:

http://www.tipsandtricks-hq.com/how-to-easily-import-or-export-any-of-your-wordpress-database-content-using-phpmyadmin-3415

Also, To upload customers data from a CSV file to eStore’s manage customer you can use this “wp-csv-to-database-plugin” plugin:

http://www.tipsandtricks-hq.com/wp-csv-to-database-plugin-import-excel-file-content-into-wordpress-database-2116

[eugene17]

hi amin!

thanks for the reply. really helpful. is there no way to do that via the wp dashboard? unfortunately, i’ll be handing down the project to non-techies and it might be hard for them to manually go to phpmyadmin to this. (morely scared that they might mess it up)

Thanks for the help!

[amin007]

I don’t know of any way to export wordpress database content to a CSV file from the WordPress Dashaboard. I could write a plugin but it will take some time (I have lot on my plate).

[frantv]

My products are not showing up when I click Manage Products. I got a “data has been uploaded” but products aren’t in there. Does it take time to propagate or what?

[amin007]

Which method are you trying? Did u use the plugin or did u directly upload in PHPMyAdmin?

[wpsadmin]

I have finally located the Customers.csv file that was downloaded when I clicked on the “Export Customers Data to a CSV File” button, but I wanted to know if there is a way for a WP user to export it to a CSV file on their own PC.

Like eugene17 above, I will be handing over responsibility for managing my webstore to a non-techie, who won’t have cPanel access, and would be terrified of PHPMyAdmin.

I see that amin007 said (2 years ago) they don’t know how to export WP database content to a CSV file, and I wondered if this is still the case.

I am using the “Newsletter” plugin for sending emails to my subscribers, and I can download to a local CSV file (C:UsersusernameDownloadssubscribers.csv) using functionality within this plugin, so it must be technically possible.

[admin]

Hi, We have added a feature in the plugin that allows you to export all the customer details into a CSV file. Do the following to use it:

1) Go to WP eStore -> Manage Customers Menu

2) Scroll down to the bottom and click on the “Export Customers Data to A CSV File” button.

3) A message should tell you that the data was exported with a link to the CSV file. Right click and save that CSV file to your computer.

[wpsadmin]

Managed to do this export. However, although the export file contains the “Purchased Product ID” and the “Sale Amount” it doesn’t contain the Quantity purchased or Unit Price. So, to work out how many items were purchased (for order fulfilment purposes) we need to divide the “Sale Amount” by the unit price (which I have to store offline in a separate spreadsheet).

Could you please include the Quantity and Unit Price fields in both the “Manage Customers” menu and in the CSV extract? I’m happy to raise a development request via your support portal, if you require it.

[admin]

We will add that in.

[wpsadmin]

Thanks so much for the latest version of the plugin, which now contains the Unit Price and Quantity fields in the export of sales/customer data. Fantastic, prompt response. Thank you very much.

[Author]

Posts