orders Exporter 0.1

This thread is for "Mat's Orders Exporter," correct?

Is there a way to include the PayPal transaction ID for each order? I see "txn_id" in the paypal_payment_status_history" table and the "paypal" table. I'd love some help including this in the export. Thanks!

I'm stuck.

Need order total in full export, but when I try editing the code it either won't work or gives me a "cannot find header information" or whatever it says.

downloaded latest version of OrderExporter today and installed.

Why was the customer's State (as in geographic, not the state of the order) eliminated from the output?

i have been using Mats order exporter for a while now and love it.

I have added another field to the exporter for quantity and works great.

I have recently had the need to add another but am not sure of the field i need to add.

I need to add the special comments field to the end of the spreadsheet but am running into trouble.

i get the error : There is an error in one of the sql statements - That's unlucky, see below...
1054: Unknown column 'comment' in 'field list'

here is a snippit of my code:

'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_price'  => $iii++,
'v_products_name'    => $iii++, 
'v_products_options'    => $iii++, 
'v_products_options_values'    => $iii++, 
'v_orders_comment'     => $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_quantity as v_products_quantity,
products_price as v_products_price,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values,
comment as v_orders_comment
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
		";
		break;

Any help would be grately appreciated :bigups:

FYI i have fixed my problem but i thought some of you guys might be interested in how i did it.

The 'comments' field was in a different table called 'ORDER_STATUS_HISTORY and had to connect that table to the order exporter before i could reference it.

corrected working code snippet below:

	case 'full':
		// The file layout is dynamically made 
		$iii = 0;
		$filelayout = array(
	//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_price'  => $iii++,
'v_products_name'    => $iii++, 
'v_products_options'    => $iii++, 
'v_products_options_values'    => $iii++, 
'v_orders_comment'     => $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_quantity as v_products_quantity,
products_price as v_products_price,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values,
osh.comments as v_orders_comment		
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, ".TABLE_ORDERS_STATUS_HISTORY." osh
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id
";
		
		break;

I need to add the products images field (Call to field products.products_image) to the end of the spreadsheet but am running into trouble.
here is my code:

'v_date_purchased'    => $iii++, 
'v_orders_status_name'	=> $iii++,
'v_orders_id'     => $iii++, 
//'v_customers_id'    => $iii++, 
'v_register_name'    => $iii++, 
'v_customers_email_address'    => $iii++, 
'v_customers_name'    => $iii++, 
//'v_customers_street_address'    => $iii++, 
//'v_customers_city'    => $iii++, 
//'v_customers_state'    => $iii++, 
'v_customers_country'    => $iii++, 
//'v_customers_postcode'    => $iii++, 
'v_customers_telephone'    => $iii++, 
'v_products_quantity'    => $iii++, 
'v_products_model'    => $iii++, 
'v_products_price'    => $iii++, 
//'v_products_name'    => $iii++, 
'v_products_options'    => $iii++, 
'v_products_options_values'    => $iii++, 
'v_producs_images'    => $iii++,

			);

	$filelayout_sql = "SELECT 
date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_register_name,
customers_email_address as v_customers_email_address,
delivery_name as v_customers_name,
delivery_street_address as v_customers_street_address,
delivery_city as v_customers_city,
delivery_state as v_customers_state,
delivery_country as v_customers_country,
delivery_postcode as v_customers_postcode,
customers_telephone as v_customers_telephone,
zop.products_quantity as v_products_quantity,
zop.products_model as v_products_model,
zop.products_price as v_products_price,
products_options as v_products_options,
products_options_values as v_products_options_values,
os.producs_images as v_producs_images
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, ".TABLE_PRODUCTS."os ON(zop.products_id=os.products_id)
WHERE zo.orders_id = zop.orders_id
AND zos.orders_status_id = '2'
AND zo.orders_status = zos.orders_status_id
		";

Thanks

I need to add the name of the buyer (ie: under billing address) which often differs from the name of the recipient of the shipping address. I would also like to add the SKU (which was part of another mod add on along with UPC). I send a portion of my orders over to a drop shipper and I need the SKU (ie: the drop shippers order number) to appear in the spreadsheet.

We are currently doing this manually but as you can imagine, it's quite tedious.

Any help would be appreciated

will this work with 1.3.9h?

I installed orders exporter in Zen Cart 1.5.4

and this is what I get when I export the orders

Success File ordersExpFull2015Feb28-1010.txt successfully exported! The file is ready for FTP download in your /oexport/ directory.
Warning There is an error in one of the sql statements - That's unlucky, see below...
1045: Access denied for user ''@'localhost' (using password: NO)

Any ideas how I can fix it?

anyone?

Can anyone help with this, I have the same issue!

Thanks

Cliff

I tried using this and all I get when I download are the table names and no information. Has anyone else seen this issue?

If so, please reply. I really need to export all order information from my store.

YES! I have the same problem, in the end I gave up and used Export Shipping & Order Information - https://www.zen-cart.com/downloads.php?do=file&id=406

And it works well!!

I am getting blank page when I click on the SHOW ME THE MONEY button.

i am using Zencart v 1.5.4
please help

There have been several new versions of this mod since 0.1, and the thread where thy have been discussed is here:
https://www.zen-cart.com/showthread.php?193168-Orders-Exporter-Module/page3
The most recent v2.1 is attached to post 109. I will be folding in DrByte's v1.5.4+ updates before I post it to the download page.