If you go into the ordersExport.php file in the admin directory you will see the code below
you can apparently add or delete the database fields to you want displayed in the exported files
and specify the order. You need to replicate it for each form type and you need to add the data field call to each section (line 54):
//all columns:
'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_quantity' => $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_quantity as v_products_quantity,
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
hope that helps..
Dont forget to backup your work


Reply With Quote
