fitgura Posted September 11, 2009 Share Posted September 11, 2009 Hello All!Could anybody know a solution, how to export my customers details... like customer ID name address .. etc.to a CSV file???Thanks for a check inn Link to comment Share on other sites More sharing options...
fitgura Posted September 27, 2009 Author Share Posted September 27, 2009 nobody has an idea??? Link to comment Share on other sites More sharing options...
swguy Posted September 27, 2009 Share Posted September 27, 2009 Use phpmyadmin and use a query like this: SELECT * FROM ps_customer c, ps_address a where c.id_customer = a.id_customer and c.active = 1 and c.deleted = 0;export this to a file and then delete the columns you don't want in excel (or change "select * " to "Select your-columns-of-interest"). Link to comment Share on other sites More sharing options...
Recommended Posts