Sample Order CSV Export Formats
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQAR
1
order_id
order_number
datestatus
shipping_total
shipping_tax_total
fee_total
fee_tax_total
tax_total
discount_total
order_totalrefunded_totalorder_currency
payment_method
shipping_method
customer_id
billing_first_name
billing_last_name
billing_company
billing_emailbilling_phone
billing_address_1
billing_address_2
billing_postcode
billing_citybilling_statebilling_country
shipping_first_name
shipping_last_name
shipping_address_1
shipping_address_2
shipping_postcode
shipping_cityshipping_state
shipping_country
shipping_company
customer_noteline_itemsshipping_itemsfee_itemstax_itemscouponsorder_notes
download_permissions_granted
2
1821822016-06-29 13:57refunded8.990000037.9937.99USDchequeUS 2-day2WalterWhite
heisenberg@mailinator.com
5558675309
308 Negra Arroyo Lane
87104AlbuquerqueNMUSWalterWhite
308 Negra Arroyo Lane
87104AlbuquerqueNMUS
name:Ninja Silhouette|sku:|quantity:1|total:20.00|refunded:20.00|refunded_qty:-1|meta:|tax:0.00;name:Woo Album #2|sku:|quantity:1|total:9.00|refunded:9.00|refunded_qty:-1|meta:|tax:0.00
method:US 2-day|total:8.99
Order exported to CSV and successfully downloaded.|Refunded order minus shipping; items no longer wanted.|Order status changed from Completed to Refunded.|Order status changed from Processing to Completed.|Order status changed from On Hold to Processing.|Awaiting check payment Order status changed from Pending Payment to On Hold.
1
3
1801802016-06-29 13:53completed000002680USD
authorize_net_aim
Local Pickup Plus (save $2.00)
5HankSchraderDEA
schraderbrau@mailinator.com
5558675309
4901 Cumbre del Sol Ct NE
87111AlbuquerqueNMUSHankSchrader
4901 Cumbre del Sol Ct NE
87111AlbuquerqueNMUSDEA
name:Happy Ninja|sku:|quantity:1|total:34.00|refunded:0.00|refunded_qty:0|meta:Pickup Location=Los Pollos Hermanos\, 12000 – 12100 Coors Rd SW\, Albuquerque\, NM 87045|tax:0.00;name:Patient Ninja|sku:|quantity:1|total:34.00|refunded:0.00|refunded_qty:0|meta:Pickup Location=Los Pollos Hermanos\, 12000 – 12100 Coors Rd SW\, Albuquerque\, NM 87045|tax:0.00
method:Local Pickup Plus (save $2.00)|total:0.00
code:wc_local_pickup_plus_0_2016_06_29_01_52|description:|amount:2.00
Order exported to CSV and successfully downloaded.|Order status changed from Processing to Completed.|Authorize.net AIM Capture of $68.00 Approved (Transaction ID 2260381230)|Order status changed from On Hold to Processing.|Authorize.net AIM Test Authorization Approved: Visa ending in 0027 (expires 01/17) (Transaction ID 2260381230)|Authorize.net AIM Transaction Held for Review (Authorization only transaction) Order status changed from Pending Payment to On Hold.
1
4
1791792016-06-29 13:51on-hold8.9900.9900036.980USDchequeUS 2-day3JessePinkman
capncook@mailinator.com
5558675309
9809 Margo Street
87104AlbuquerqueNMUSJaneMargolis
323 Terrace St SE
87104AlbuquerqueNMUS
Yo this is a gift, no prices please
name:Happy Ninja|sku:|quantity:1|total:18.00|refunded:0.00|refunded_qty:0|meta:|tax:0.00;name:Woo Album #1|sku:|quantity:1|total:9.00|refunded:0.00|refunded_qty:0|meta:|tax:0.00
method:US 2-day|total:8.99
name:checkout add on-1|total:0.99|tax:0.00
Order exported to CSV and successfully downloaded.|Awaiting check payment Order status changed from Pending Payment to On Hold.
0
5
1781782016-06-29 13:48processing001.9900270.490USD
authorize_net_aim_echeck
Local Pickup Plus (save $2.00), Free Shipping!
2WalterWhite
heisenberg@mailinator.com
5558675309
308 Negra Arroyo Lane
87104AlbuquerqueNMUSWalterWhite
308 Negra Arroyo Lane
87104AlbuquerqueNMUS
name:Ship Your Idea|sku:|quantity:1|total:31.58|refunded:0.00|refunded_qty:0|meta:color=Blue,size=Medium,Pickup Location=Los Pollos Hermanos\, 4257 Isleta Blvd SW\, Albuquerque\, NM 87105|tax:0.00;name:Happy Ninja|sku:|quantity:1|total:17.49|refunded:0.00|refunded_qty:0|meta:|tax:0.00;name:Ninja Silhouette|sku:|quantity:1|total:19.43|refunded:0.00|refunded_qty:0|meta:|tax:0.00
method:Local Pickup Plus (save &#36\;2.00)|total:0.00;method:Free Shipping!|total:0.00
name:checkout add on-1|total:1.99|tax:0.00;name:checkout add on-2|total:0.00|tax:0.00
code:wc_local_pickup_plus_0_2016_06_29_01_46|description:|amount:2.00
Order exported to CSV and successfully downloaded.|Authorize.net AIM eCheck Check Transaction Approved: checking account ending in 5309 (Transaction ID 2260380943)|Order status changed from Pending Payment to Processing.
1
6
1761762016-06-29 12:12completed000000.32.70USD
authorize_net_aim_echeck
3JessePinkman
capncook@mailinator.com
5558675309
9809 Margo Street
87104AlbuquerqueNMUSJessePinkman
9809 Margo Street
87104AlbuquerqueNMUS
name:Woo Single #1|sku:|quantity:1|total:2.70|refunded:0.00|refunded_qty:0|meta:|tax:0.00
code:10off|description:|amount:0.30
Order exported to CSV and successfully downloaded.|Authorize.net AIM eCheck Check Transaction Approved: checking account ending in 5309 (Transaction ID 2260382223)|Order status changed from Pending Payment to Completed.
1
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu