Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › Import/export customers via from csv or excel
- This topic has 10 replies, 5 voices, and was last updated 10 years, 2 months ago by wpsadmin.
May 16, 2010 at 1:34 pm #1208eugene17Member
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!May 17, 2010 at 3:36 am #20596
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:
Now, click on “Export” and choose “CSV” then hit “Go” and it should take care of it.
This video tutorial maybe very helpful:
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-2116May 17, 2010 at 4:47 am #20597eugene17Member
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!May 17, 2010 at 2:37 pm #20598
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).August 23, 2010 at 10:02 pm #20599frantvMember
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?August 24, 2010 at 1:54 am #20600
Which method are you trying? Did u use the plugin or did u directly upload in PHPMyAdmin?January 29, 2013 at 12:15 pm #20601
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.January 29, 2013 at 11:49 pm #20602adminKeymaster
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 CustomersMenu
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.February 1, 2013 at 2:35 am #20603
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.February 1, 2013 at 10:51 pm #20604adminKeymaster
We will add that in.February 2, 2013 at 9:27 am #20605
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.
- You must be logged in to reply to this topic.