-
Re: 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!
-
Re: orders Exporter 0.1
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.
-
Re: orders Exporter 0.1
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?
-
Re: orders Exporter 0.1
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:
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:
-
Re: orders Exporter 0.1
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:
Code:
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;
-
Re: orders Exporter 0.1
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:
PHP 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
-
Re: orders Exporter 0.1
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
-
Re: orders Exporter 0.1
will this work with 1.3.9h?
-
Re: orders Exporter 0.1
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?
-
Re: orders Exporter 0.1