Newbie wondering how to download contacts to csv file

[dactyl]

Hello,

 

I believe there is an 'add on' I can use to enable me to export my customer list into a csv file (or any other file is fine).  Could someone let me know a step by step way of doing this please?

 

Best wishes,

 

Jeff Hutchings

[MrPhil]

If this is a one-time job, it will probably be easier to use phpMyAdmin to back up (export) that table in CSV format. If you're going to be doing this on a regular basis, maybe there's an add-on for it, but I'm not familiar with it.

[allaboutwicker]

Here is an addon I found that may work for you. You did not mention the oscommece version you have, but this addon has a few different versions for 2.2 and 2.3.1 I think. I have never tried it so not sure. http://addons.oscommerce.com/info/7476

[dactyl]

Thanks both.  I'm afraid my technical expertise with this is nil though.  I've also found an "add on" in the oscom community (similar to yours Leslie) but I have no idea what to do with it!  I've downloaded the file (there's a button that says Download) but I have no idea how to then export my contacts into the file, or make the file work with my contacts.  

http://addons.oscommerce.com/info/2291

 

An 'idiot's guide' would be much appreciated!

 

Best wishes,

 

Jeff Hutchings

[♥14steve14]

I personally use this addon which has already been mentioned http://addons.oscommerce.com/info/7476

 

Once the addon is downloaded open the file and read the instructions. It comes with a simple to follow install instructions, and is so easy to use. I use it to update my mailchimp mailing list. Once you click on the ;ink on the main customers page you are given a list of options, which you need to highlight, then you click the export button. You then choose whether you want to save or open the file. Really easy as I can do it.

 

I have not used the other addon so have no idea how it works or how easy it is to install.

[dactyl]

I've downloaded the zip file.  When I open it there are two folders ('catalog' and 'docs') and an .htm called "install'.  Then I'm stuck.  I don't understand the content of that file.

In Oscom I am logged in and have my main customer's page open which shows all my customers - first name, last name, account created date.  But I have no idea (and can't find the easy installation instructions you mentioned) what to do next!  

I too want to export a list of my contacts as a csv file to use with my Mail Chimp account..

 

Best wishes,

 

Jeff Hutchings

[burt]

1.  get a list of all those people who have subscribed to your Newsletter using PHPMyAdmin

SELECT customers_firstname as FNAME, customers_lastname as LNAME, customers_email_address as email FROM customers WHERE customers_newsletter = 1;

2.  purchase a commercial Mailchimp<>osCommerce addon that from this point forward automatically keeps your site and mailchimp up to date.  When a new customer ticks the Newsletter box on create_account, Mailchimp is updated.  When an existing customer (un)subscribes at your Shop, Mailchimp is updated.  When a Newsletter subscriber unsubs at Mailchimp, your shop is updated.  And so on etc etc.  Oh, and as Mailchimp is so cool, you can have people on your list who are not customers...all done by a (osCommerce) box module. Work Smart...Not Hard.

[♥14steve14]

I've downloaded the zip file.  When I open it there are two folders ('catalog' and 'docs') and an .htm called "install'.  Then I'm stuck.  I don't understand the content of that file.

In Oscom I am logged in and have my main customer's page open which shows all my customers - first name, last name, account created date.  But I have no idea (and can't find the easy installation instructions you mentioned) what to do next!  

I too want to export a list of my contacts as a csv file to use with my Mail Chimp account..

 

Best wishes,

 

Jeff Hutchings

Did you open and read the install file. Hopefully it will tell you how to install the files.

[dactyl]

Hi 14Steve14,

 

Yes I did open the Install file and found it baffling tbh.  It wasn't written in plain English as Step 1, open blah blah, Step 2, click on blah blah.

It instead contains boxes and then text like this below.  Beyond me I'm afraid.       

 

default:

        $customers_query = tep_db_query("select c.customers_id, c.customers_gender, c.customers_firstname, c.customers_lastname, c.customers_dob, c.customers_email_address, a.entry_company, a.entry_street_address, a.entry_suburb, a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id, a.entry_country_id, c.customers_telephone, c.customers_fax, c.customers_newsletter, c.customers_default_address_id from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a on c.customers_default_address_id = a.address_book_id where a.customers_id = c.customers_id and c.customers_id = '" . (int)$HTTP_GET_VARS['cID'] . "'");

        $customers = tep_db_fetch_array($customers_query);

        $cInfo = new objectInfo($customers);

    }

  }