An example Ticket Tailor order export

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ
1	Label:	Order ID	Total paid	Credited in amount	Order value	Order date	Order items	Tickets purchased	Payment method	Transaction ID	Order cancelled	Refunded amount	Credited out amount	Remaining order value	Referral Tag	Tax description	Exclusive tax amount	Inclusive tax amount	Tax paid amount	Tax credited in amount	Tax refunded amount	Tax credited out amount	Discount code	Voucher codes	Voucher codes amount	Donation description	Donation amount	PAYG fees	Ticket credits	Event ID	Event name	Event start	Event end	Name	First Name	Last Name	Email	Mobile number	Address 1	Address 2	Address 3	Postcode / Zip	Store name
2	Description:	Unique number an order is given when made on Ticket Tailor.	Total paid by the ticket buyer who made the order.	Credit applied to orders (e.g. from rescheduled orders or refunds to a voucher).	Total value of the order after voucher codes and discount codes have been applied.	Date and time the order was placed.	List of items charged in the order.	Number of tickets purchased.	The payment processor that received the ticket money. (Free tickets are marked as NO_COST).	The ID your payment processor gave to this transaction.	"0" if the order hasn't been canceled; "1" if the order has been canceled.	Amount refunded (excluding refund via voucher).	Amount credited out from this order (e.g. to a 'refund to voucher', or a rescheduled order)	Order value after the "Refunded amount" and "Credited out amount".	Where the ticket buyer bought their ticket, recorded if you're using referral tags or the widget.	The name you set as your tax description in your 'Settings'.	The amount of tax that has been charged in addition to the item price.	The amount of tax that is already included in the item price.	The amount of sales tax paid.	Tax amount from "Credited in amount".	Amount of tax that has been refunded.	Portion of tax from "Credited out amount".	The name of your discount code (not the code entered by the ticket buyer at checkout) .	The name you gave your voucher, and the code entered at checkout.	The amount deducted from the order total using voucher(s).	The description you added in 'Advanced settings' when creating your event and adding a donation.	The amount donated by the ticket buyer.	The Pay as you sell fees for this order.	The number of ticket credits used for this order.	The unique event ID (Automatically assigned).	The name of your event.	The time you set your event to start when creating it.	The time you set your event to end when creating it.	The full name of the ticket buyer who placed the order.	The first name of the ticket buyer who placed the order.	The last name of the ticket buyer who placed the order.	The email of the ticket buyer who placed the order, and where the confirmation email was sent.	The mobile number of the ticket buyer who placed the order. (Blank if this question was hidden).	The address of the ticket buyer who placed the order. (Blank if this question was hidden).				The name of your store if a product was purchased there.

3	Related help centre articles:								How to take payments						How to create referral and affiliate links	Where can I configure sales tax/VAT?							How to create discount codes.	How to create voucher codes.		How to accept donations for your event.		How do ticket fees work?	Buy ticket credits.									How to edit your checkout form.
4	Example(s):
5	Example order 1:	12656954	0	0		Tue, 15 Dec 2020 15:55:53	1 x Adult ticket	1	NO_COST	--	1								0						0		0	0	0	450629	Pottery class	Wed, 16 Dec 2020 0:00:00	Wed, 16 Dec 2020 15:00:00	Jean-Michel Basquiat	Jean-Michel	Basquiat	hi@tickettailor.com	1234567890	Unit 219, Mare Street	LONDON	London	E8
6	Example order 2:	15133300	0	0		Tue, 15 Jun 2021 15:17:31	1 x General Admission 1 x 10 voucher (1223445) 1 x 10 voucher (1223455) 1 x Please add a donation	1	NO_COST	--	0								0					10 voucher (1223445) 10 voucher (1223455)	-11	Please add a donation	1	0	1	804701	Charity dinner	Sat, 29 Mar 2025 18:00:00	Sat, 29 Mar 2025 22:30:00	Mark Rothko	Mark	Rothko	hi@tickettailor.com
7	Example order 3:	16266621	117.45	0		Tue, 17 Aug 2021 20:27:33	1 x VIP 1 x Transaction charge 1 x Sales Tax (8.25%)	1	STRIPE	ch_3JPdZ4B2yG3Wc2NB1BpiASq1	0				website_widget	Sales Tax (8.25%)			8.95						0		0	0	1	902559	Climate conference	Fri, 3 Sep 2021 19:00:00	Fri, 3 Sep 2021 23:45:00	Georgia O'Keeffe	Georgia	O'Keeffe	hi@tickettailor.com	1234567890
8	Example order 4:	16897642	11	0		Wed, 8 Sep 2021 17:35:43	2 x General Admission 1 x Example vouchers (1223445) 1 x Please add a donation	2	OFFLINE		0				website_widget				0					Example vouchers (1223445)	-10	Please add a donation	1	0	2	804701	Charity dinner	Sat, 29 Mar 2025 18:00:00	Sat, 29 Mar 2025 22:30:00	Yayoi Kusama	Yayoi	Kusama	hi@tickettailor.com		Unit 219, Mare Street	LONDON	London	E8
9	Example order 5:	16697704	6	0		Wed, 8 Sep 2021 17:39:37	1 x General Admission (inc. 50% off) 1 x Please add a donation	1	OFFLINE		0				website_widget				0				50% off		0	Please add a donation	1	0.6	0	804701	Charity dinner	Sat, 29 Mar 2025 18:00:00	Sat, 29 Mar 2025 22:30:00	Frida Kahlo	Frida	Kahlo	hi@tickettailor.com		Unit 219, Mare Street	LONDON	London	E8
10	Example order 6:	48167952	16	0	16	24 Sep 2024 2:48 PM	1 x General admission - with headphones 1 x General Admission - no headphones (General admission - with headphones) 1 x Headphones (General admission - with headphones)	1	OPERATOR		0	0	0	16		VAT	0	1.45	1.45	0	0	0			0		0	0	2	4465388	Silent disco with the turbines	Mon, 30 Sep 2024 18:00:00	Mon, 30 Sep 2024 23:30:00	Admin Order	Admin	Order	hi@tickettailor.com
11	Example order 7:	43985259	0.5	0	0.5	6 Jun 2024 15:12	1 x General Admission	1	SQUARE	blQsPrUHxj4mb9lG3DXpb7LCrfMZY	1	0.5	0	0			0	0	0	0	0	0			0		0	0	1	2092259	Beach visit	Sat, 22 Jun 2024 12:00:00	Sat, 22 Jun 2024 18:00:00	Marina Abramović	Marina	Abramović	hi@tickettailor.com		Unit 219, Mare Street	LONDON	London	E8
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