Zen Cart Logo
Forums / All Other Contributions/Addons / order exporter help

order exporter help

Locked

Views: 605

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
23 Feb 2010, 11:52 PM
#1
vipoptics avatar

vipoptics

New Zenner

Join Date:
Sep 2009
Posts:
17
Plugin Contributions:
0

order exporter help

K, I am looking for a way to download certain info to excel.
I know that I can download certain info with orderexport, but it doesn't have the taxes, product attribute prices, or an discounts on the orders. This is how it looks:

'v_date_purchased' => $iii++,
'v_orders_status_name' => $iii++,
'v_orders_id' => $iii++,
//'v_customers_id' => $iii++,
'v_customers_name' => $iii++,
//'v_customers_company' => $iii++,
//'v_customers_street_address' => $iii++,
//'v_customers_suburb' => $iii++,
//'v_customers_city' => $iii++,
//'v_customers_postcode' => $iii++,
'v_customers_state' => $iii++,
//'v_customers_country' => $iii++,
//'v_customers_telephone' => $iii++,
//'v_customers_email_address' => $iii++,
'v_products_model' => $iii++,
'v_products_name' => $iii++,
'v_products_options' => $iii++,
'v_products_options_values' => $iii++,
);

$filelayout_sql = "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,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id
";

If I knew the codes, I think it would be an easy fix... Anybody know the right codes????
Thanks in advance!
VIP