Select All Customer Info with Magento Query

customercustomer-addressMySQL

I am looking for a query with all the customer info that I can dump into a CSV from SQL. I am working with a broken site and the customer wants all the customer info.

Please don't write one yourself as I can do that, just seeing if anyone has one already written.

Best Answer

Just dump the SQL from

Mage::getResourceModel('customer/customer_collection')->addAttributeToSelect('*')->load(true);

Related Solutions

Magento – How to retrieve full customer name with SQL

Since attribute ids for first and last name vary between magento instlalations it would be wise to select attribute_id values for first name and last name from eav_attribute and write the query for retrieving first and last name in a single row like this:

SELECT entity_id, group_concat(VALUE SEPARATOR ' ') AS fullname 
FROM customer_address_entity_varchar AS val
INNER JOIN eav_attribute AS attr ON attr.attribute_id  = val.attribute_id
WHERE attr.attribute_code IN ( 'firstname',  'lastname' ) 
GROUP BY entity_id

MySQL Query – How to Get Number of Times Ordered

SELECT 
    customer_email, customer_firstname, customer_lastname,
    SUM(subtotal_invoiced) AS total_of_orders,
    MIN(created_at) as first_order_date,
    COUNT(*) as num_of_orders
FROM sales_flat_order
GROUP BY customer_email

Best Answer

Related Solutions

Magento – How to retrieve full customer name with SQL

MySQL Query – How to Get Number of Times Ordered

Related Topic