SQL Query for extracting Order & Customer Details?

[Rony]

I am trying to build a simple web-page to fetch & display "Order & Customer Details" on a web-page and finally save that info into an "Excel Sheet". There are many "add-ons" available to do this, but I didn't found any "add-on" that also include "Customer-Fax".

I have found a SQL query. Can anyone plz suggest how should I modify this to include "Customer-Fax" details ...!

-----------------------------------

SELECT
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
date_purchased as v_date_purchased,
comments as v_comments,
products_name as v_products_name,
products_quantity as v_quantity,
products_options as v_products_options,
products_options_values as v_products_options_values


FROM zen_orders_products zop LEFT JOIN zen_orders_products_attributes opa
ON(zop.orders_products_id = opa.orders_products_id), zen_orders zo, zen_orders_status_history zosh
WHERE zo.orders_id = zop.orders_id
AND zo.orders_id = zosh.orders_status_history_id;

-------------------------------------

Many thanks in advance.

[Rony]

Any SQL Expert, Plz help...!

[Flipside]

customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_fax as v_customers_fax,
customers_email_address as v_customers_email_address,

[Rony]

customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_fax as v_customers_fax,
customers_email_address as v_customers_email_address,

Nice, But its not that easy .....

This is the ERROR you receive if you try to run the query...

"[Err] 1054 - Unknown column 'customers_fax' in 'field list'"

You got to reference/call/join the table "customers" somewhere in the FROM clause ......

[apsona]

I am trying to build a simple web-page to fetch & display "Order & Customer Details" on a web-page and finally save that info into an "Excel Sheet". There are many "add-ons" available to do this, but I didn't found any "add-on" that also include "Customer-Fax".

You might try Apsona ShopAdmin. It includes features for the kinds of reporting you indicate here.

Apsona

[Rony]

You might try Apsona ShopAdmin. It includes features for the kinds of reporting you indicate here.

Apsona

I tried "apsona", but it shows incorrect "Order Totals" for Hybrid orders.

[Rony]

Darn.... 111 Views and still no answer ....

I didn't knew it was so tough.

All I wanted is to include "Customer-Fax" in my query result ....

[apsona]

I tried "apsona", but it shows incorrect "Order Totals" for Hybrid orders.

Could you please send a screen shot with the incorrect "Order Total". Curious to see why it is happening.

apsona