order export csv

21.11.2011 14:06
#1
dilbert
Joomshopping forum user no avatar
Name: Andreas Gruber
11.10.2010
Posts: 170
Quote
order export csv

thx for this great tool, but i need one more field in my exportcsv

this field: define('_JSHOP_EXT_FIELD_1', 'Zusätzliche Feld 1');

where can i do this?

thx

 
22.11.2011 08:58
#2
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: order export csv

file
administrator\components\com_jshopping\importexport\orderexport\orderexport.php

Change code

$head = array("order_id","number","user_id","total","subtotal","tax","shippingprice","paymentprice",
"discount","currency_code","status","date","shipping","payment",
"name","family","title","firma_name","email","street","zip","city","state","country","phone","mobil_phone","fax",
"d_name","d_family","d_title","d_firma_name","d_email","d_street","d_zip","d_city","d_state","d_country","d_phone","d_mobil_phone","d_fax",
"pdf_file","ip",'extfield1');





....
$row[] = utf8_decode($data->ext_field_1);



Letzte Änderung: 22.11.2011 09:00
 
17.02.2012 12:54
#3
dilbert
Joomshopping forum user no avatar
Name: Andreas Gruber
11.10.2010
Posts: 170
Quote
Aw: order export csv

thx,

but now i would need "payment_params"

how can i do this?

 
17.02.2012 15:01
#4
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: order export csv

Will be in new version.

 
22.02.2012 21:28
#5
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: order export csv

"payment_params" Added in "Order CSV Export 1.1.1"

 
27.02.2012 15:35
#6
dilbert
Joomshopping forum user no avatar
Name: Andreas Gruber
11.10.2010
Posts: 170
Quote
Aw: order export csv

THX - GREAT

 
19.05.2012 06:09
#7
divesplash
Joomshopping forum user no avatar
Name: Christine
27.03.2012
Posts: 3
Quote
Aw: order export csv

I need these two lists to be combined so that I can see who ordered which product and the attributes of that product. How can I do this?


Joomla: 2.5
JoomShopping: 3.5.1
PHP: 5
 
19.05.2012 09:01
#8
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: order export csv

CSV example?

1 - order, 1- product - possibly
1 - order, 3- product - not possibly

 
19.05.2012 19:48
#9
divesplash
Joomshopping forum user no avatar
Name: Christine
27.03.2012
Posts: 3
Quote
Aw: order export csv

Im sorry Im not sure what you are saying here.

 
22.05.2012 17:59
#10
divesplash
Joomshopping forum user no avatar
Name: Christine
27.03.2012
Posts: 3
Quote
Aw: order export csv

My website is selling concert tickets and therefore we need to print out a list of who bought each ticket and which performance they chose to attend so that we can check their names when they get to the performance. Therefore having the amount of products purchased on a different list then the people purchasing them does me no good.

All I need is an export that includes: Name, product purchased and product attribute on the same CSV file. Is this possible with this extension?

 
22.05.2012 19:20
#11
admin
(Support Team)
User admin
Name: Admin
05.08.2010
Posts: 25938
Quote
Aw: order export csv

See http://www.webdesigner-profi.de/joomla-webdesign/shop/import-export/export-order-csv.html

export in 2 file.
1. order information
2. product information.

Write to me exactly how you want to.


Now.
1. File csv (list order):
order_id;number;user_id;total;subtotal;tax;shippingprice;paymentprice;discount;currency_code;status;date;shipping;payment;name;family;title;firma_name;email; street;zip;city;state;country;phone;mobil_phone;fax;d_name;d_family;d_title;d_firma_name;d_email;d_street;d_zip;d_city;d_state;d_country;d_phone; d_mobil_phone;d_fax;pdf_file;ip

2. File csv (list order item)
order_id;product_id;ean;name;quantity;price;taxpercent;attributes;freeattributes


Letzte Änderung: 22.05.2012 19:24
 


Copyrights MAXXmarketing GmbH. Alle Rechte vorbehalten
Durch die Nutzung dieser Website stimme ich zu, dass Cookies zur optimalen Gestaltung der Website sowie zur Analyse der Nutzung der Website verwendet werden. Weiterführende Informationen finden Sie hier. OK, einverstanden.