Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

Import/export customers via from csv or excel

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › Import/export customers via from csv or excel

Tagged: export CSV to local file, local file download

  • This topic has 10 replies, 5 voices, and was last updated 12 years, 3 months ago by wpsadmin.
Viewing 11 posts - 1 through 11 (of 11 total)
  • Author
    Posts
  • May 16, 2010 at 1:34 pm #1208
    eugene17
    Member

    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!

    May 17, 2010 at 3:36 am #20596
    amin007
    Participant

    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

    May 17, 2010 at 4:47 am #20597
    eugene17
    Member

    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!

    May 17, 2010 at 2:37 pm #20598
    amin007
    Participant

    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 #20599
    frantv
    Member

    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
    amin007
    Participant

    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
    wpsadmin
    Member

    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 #20602
    admin
    Keymaster

    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.

    February 1, 2013 at 2:35 am #20603
    wpsadmin
    Member

    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 #20604
    admin
    Keymaster

    We will add that in.

    February 2, 2013 at 9:27 am #20605
    wpsadmin
    Member

    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
Viewing 11 posts - 1 through 11 (of 11 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ