order_id,order_number,order_number_formatted,date,status,shipping_total,shipping_tax_total,fee_total,fee_tax_total,tax_total,discount_total,order_total,refunded_total,order_currency,payment_method,shipping_method,customer_id,billing_first_name,billing_last_name,billing_company,billing_email,billing_phone,billing_address_1,billing_address_2,billing_postcode,billing_city,billing_state,billing_country,shipping_first_name,shipping_last_name,shipping_address_1,shipping_address_2,shipping_postcode,shipping_city,shipping_state,shipping_country,shipping_company,customer_note,line_items,shipping_items,fee_items,tax_items,coupon_items,refunds,order_notes,download_permissions_granted
17944,16230,16230,"2019-08-27 11:03:46",cancelled,3.29,0.00,0.00,0.00,7.00,0.00,82.29,0.00,GBP,paypoint,UK,2805,"Caroline A",Armour,"Dalintober Primary School",enquiries-dalintober@argyll-bute.gov.uk,"01586 552053","Dalaruan Street",,"PA28 6HG",Campbeltown,Argyll,GB,"Caroline A",Armour,"Dalaruan Street",,"PA28 6HG",Campbeltown,Argyll,GB,"Dalintober Primary School",,"id:52432|name:An Inspector Calls|product_id:9630|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52433|name:KS2 Book & Audio CD £37|product_id:4831|sku:|quantity:1|subtotal:37.00|subtotal_tax:0.00|total:37.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52434|name:Performance Licence - admission charged|product_id:7986|sku:|quantity:1|subtotal:35.00|subtotal_tax:7.00|total:35.00|total_tax:7.00|refunded:0.00|refunded_qty:0|meta:",id:52435|method_id:table_rate_shipping|method_title:UK|total:3.29,,id:52436|rate_id:1|code:GB-VAT-1|title:VAT|total:7.00|compound:,,,"Unpaid order cancelled - time limit reached. Order status changed from Pending payment to Cancelled.",0
17943,16229,16229,"2019-08-27 10:34:54",processing,3.29,0.00,0.00,0.00,7.00,0.00,76.29,0.00,GBP,paypoint,UK,2804,William,Glennie,"Hythehill Primary School",william.glennie14@moray-edunet.gov.uk,"01343 812014","St Margaret's Crescent",,"IV31 6RF",Lossiemouth,Morayshire,GB,William,Glennie,"St Margaret's Crescent",,"IV31 6RF",Lossiemouth,Morayshire,GB,"Hythehill Primary School",,"id:52427|name:The Stars Come Out For Christmas|product_id:4546|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52428|name:KS2 Book & Audio CD|product_id:3521|sku:|quantity:1|subtotal:31.00|subtotal_tax:0.00|total:31.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52429|name:Performance Licence - admission charged|product_id:7986|sku:|quantity:1|subtotal:35.00|subtotal_tax:7.00|total:35.00|total_tax:7.00|refunded:0.00|refunded_qty:0|meta:",id:52430|method_id:table_rate_shipping|method_title:UK|total:3.29,,id:52431|rate_id:1|code:GB-VAT-1|title:VAT|total:7.00|compound:,,,"Order status changed from Pending payment to Processing.|PayPoint payment completed. Transaction ID: 085920",0
17942,16228,16228,"2019-08-26 11:50:40",completed,0.00,0.00,0.00,0.00,0.80,0.00,4.80,0.00,GBP,paypal,,2802,Margaret,Livingstone,"No school",balmacaan.music@btinternet.com,"01456 450936","Tigh na Allt, 1 Lower Balmacaan",,"IV63 6WU","Lewiston, Drumnadrochit",Inverness-shire,GB,,,,,,,,,,,"id:52423|name:Leavers' Songs|product_id:4649|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52424|name:The End Of The Road|product_id:4614|sku:|quantity:1|subtotal:2.00|subtotal_tax:0.40|total:2.00|total_tax:0.40|refunded:0.00|refunded_qty:0|meta:;id:52425|name:We'll Shine|product_id:4616|sku:|quantity:1|subtotal:2.00|subtotal_tax:0.40|total:2.00|total_tax:0.40|refunded:0.00|refunded_qty:0|meta:",,,id:52426|rate_id:1|code:GB-VAT-1|title:VAT|total:0.80|compound:,,,"Order status changed from Pending payment to Completed.|IPN payment completed",0
17941,16227,16227,"2019-08-26 11:43:06",cancelled,0.00,0.00,0.00,0.00,0.80,0.00,4.80,0.00,GBP,paypoint,,2802,Margaret,Livingstone,"No school",balmacaan.music@btinternet.com,"01456 450936","Tigh na Allt, 1 Lower Balmacaan",,"IV63 6WU","Lewiston, Drumnadrochit",Inverness-shire,GB,,,,,,,,,,,"id:52419|name:Leavers' Songs|product_id:4649|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52420|name:The End Of The Road|product_id:4614|sku:|quantity:1|subtotal:2.00|subtotal_tax:0.40|total:2.00|total_tax:0.40|refunded:0.00|refunded_qty:0|meta:;id:52421|name:We'll Shine|product_id:4616|sku:|quantity:1|subtotal:2.00|subtotal_tax:0.40|total:2.00|total_tax:0.40|refunded:0.00|refunded_qty:0|meta:",,,id:52422|rate_id:1|code:GB-VAT-1|title:VAT|total:0.80|compound:,,,"Order cancelled by customer. Order status changed from Pending payment to Cancelled.",0
17940,16226,16226,"2019-08-25 10:21:11",processing,3.29,0.66,0.00,0.00,25.06,0.00,150.35,0.00,GBP,paypoint,UK,0,Helen,Nudd,"Overstrand, The Belfry, Primary",n.martell5nrp@nsix.org.uk,01263576040,"23, Cromer Road, Overstrand",,"NR27 0NT",Cromer,Norfolk,GB,Natalie,Martell,"11, Chapel Road, Trunch",,"NR28 0QG","North Walsham",Norfolk,GB,"Overstrand The Belfry Primary",,"id:52412|name:It's Chr-i-i-i-stmas!|product_id:11614|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52413|name:CD ROM & Audio CD|product_id:4902|sku:|quantity:1|subtotal:31.00|subtotal_tax:6.20|total:31.00|total_tax:6.20|refunded:0.00|refunded_qty:0|meta:;id:52414|name:It's Chri-i-i-i-stmas! Digital Download|product_id:11688|sku:|quantity:1|subtotal:31.00|subtotal_tax:6.20|total:31.00|total_tax:6.20|refunded:0.00|refunded_qty:0|meta:;id:52415|name:Performance Licence - NO admission charged|product_id:7983|sku:|quantity:1|subtotal:30.00|subtotal_tax:6.00|total:30.00|total_tax:6.00|refunded:0.00|refunded_qty:0|meta:;id:52416|name:Recording & Duplication Licence|product_id:3596|sku:|quantity:1|subtotal:30.00|subtotal_tax:6.00|total:30.00|total_tax:6.00|refunded:0.00|refunded_qty:0|meta:",id:52417|method_id:table_rate_shipping|method_title:UK|total:3.29,,id:52418|rate_id:1|code:GB-VAT-1|title:VAT|total:25.06|compound:,,,"Order status changed from Failed to Processing.|PayPoint payment completed. Transaction ID: 053355|0 Order status changed from Pending payment to Failed.",0
17939,16225,16225,"2019-08-22 20:13:04",completed,0.00,0.00,0.00,0.00,6.20,0.00,37.20,0.00,GBP,paypoint,,0,Jane,Watts,"Islwyn High Special Resource Base",jane.watts43@gmail.com,07877812275,"32 Channel View, Bassaleg",,"NP10 8PJ",Newport,"South Wales",GB,,,,,,,,,,,"id:52409|name:Bethlehem B&B|product_id:17851|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52410|name:Bethleham B&B - Digital Download|product_id:17866|sku:|quantity:1|subtotal:31.00|subtotal_tax:6.20|total:31.00|total_tax:6.20|refunded:0.00|refunded_qty:0|meta:",,,id:52411|rate_id:1|code:GB-VAT-1|title:VAT|total:6.20|compound:,,,"Order status changed from Pending payment to Completed.|PayPoint payment completed. Transaction ID: 022584",0
17938,16224,16224,"2019-08-22 18:00:40",processing,6.50,0.00,0.00,0.00,6.90,0.00,74.40,0.00,GBP,paypoint,EU,0,Brid,Dowling,"St. Mary's P.S.",bridmtdowling@outlook.ie,086-1012380,"3 The Oak, Drumbear Wood",,"H18 KH33",Monaghan,MN,IE,Brid,Dowling,"3 The Oak, Drumbear Wood",,"H18 KH33",Monaghan,MN,IE,"St. Mary's P.S.","Please email a free copy of script to edit as necessary.","id:52403|name:It's Chr-i-i-i-stmas!|product_id:11614|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52404|name:It's Chr-i-i-i-stmas!|product_id:11614|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52405|name:Book & Audio CD|product_id:4901|sku:|quantity:1|subtotal:31.00|subtotal_tax:0.00|total:31.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52406|name:Performance Licence - NO admission charged|product_id:7983|sku:|quantity:1|subtotal:30.00|subtotal_tax:6.90|total:30.00|total_tax:6.90|refunded:0.00|refunded_qty:0|meta:",id:52407|method_id:table_rate_shipping|method_title:EU|total:6.50,,id:52408|rate_id:101|code:IE-VAT-1|title:VAT|total:6.90|compound:,,,"Order status changed from Pending payment to Processing.|PayPoint payment completed. Transaction ID: 215788",0
17937,16223,16223,"2019-08-22 04:56:25",completed,6.50,1.30,0.00,0.00,10.50,0.00,63.00,0.00,GBP,paypoint,International,2801,Jeanette,Walker,"The British International School of Jeddah",walkerj@conti.sch.sa,07437755131,"50 West St Helen St.,",Abingdon,"OX14 5BP",Oxford,"U K",GB,Jeanette,Walker,"Prince Sultan St.,","Al Mohamadeyah District",21442,Jeddah,"Saudi Arabia",SA,"The British International School of Jeddah",,"id:52398|name:Sleeping Beauty - the ugly truth|product_id:6224|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52399|name:Sleeping Beauty-the ugly truth - KS2 Digital Download|product_id:6269|sku:|quantity:1|subtotal:31.00|subtotal_tax:6.20|total:31.00|total_tax:6.20|refunded:0.00|refunded_qty:0|meta:;id:52400|name:Digital Backdrops CD ROM|product_id:8738|sku:|quantity:1|subtotal:15.00|subtotal_tax:3.00|total:15.00|total_tax:3.00|refunded:0.00|refunded_qty:0|meta:",id:52401|method_id:table_rate_shipping|method_title:International|total:6.50,,id:52402|rate_id:1|code:GB-VAT-1|title:VAT|total:10.50|compound:,,,"Order status changed by bulk edit: Order status changed from Processing to Completed.|Order status changed from Pending payment to Processing.|PayPoint payment completed. Transaction ID: 022001",0
17936,16222,16222,"2019-08-21 22:10:59",completed,0.00,0.00,0.00,0.00,0.40,0.00,2.40,0.00,GBP,paypal,,0,Fiona,MacLean,Miss,fimac64@btinternet.com,07749070400,"Bottom Flat, Rockside",Blairmore,"PA23 8TE",Dunoon,Argyll,GB,,,,,,,,,,,"id:52395|name:Harvest Songs|product_id:4640|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52396|name:All Your Gifts|product_id:4602|sku:|quantity:1|subtotal:2.00|subtotal_tax:0.40|total:2.00|total_tax:0.40|refunded:0.00|refunded_qty:0|meta:",,,id:52397|rate_id:1|code:GB-VAT-1|title:VAT|total:0.40|compound:,,,"Order status changed from Pending payment to Completed.|IPN payment completed",0
17935,16221,16221,"2019-08-21 19:28:16",completed,0.00,0.00,0.00,0.00,7.13,0.00,38.13,0.00,GBP,paypoint,,0,conor,murray,"Gurraneasig NS",conormurray665@hotmail.com,0861703801,Kilbrittain,,,Bandon,CO,IE,,,,,,,,,,,"id:52391|name:Gimme, Gimme, Gimme!|product_id:8109|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52392|name:Gimme, Gimme, Gimme!|product_id:8109|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52393|name:Gimme, Gimme, Gimme KS2 Digital Download|product_id:8183|sku:|quantity:1|subtotal:31.00|subtotal_tax:7.13|total:31.00|total_tax:7.13|refunded:0.00|refunded_qty:0|meta:",,,id:52394|rate_id:101|code:IE-VAT-1|title:VAT|total:7.13|compound:,,,"Order status changed by bulk edit: Order status changed from Processing to Completed.|Order status changed from Pending payment to Processing.|PayPoint payment completed. Transaction ID: 551152",0
17933,16219,16219,"2019-08-21 13:59:48",completed,0.00,0.00,0.00,0.00,12.20,0.00,73.20,0.00,GBP,paypoint,,0,Sue,Dale-Heaps,"Greenfields Junior School",adminoffice@greenfields-jun.hants.sch.uk,"01252 843822","Green Lane",,"RG27 8DQ","Hartley Wintney",Hampshire,GB,,,,,,,,,,,"id:52377|name:Gabriel's Big Break|product_id:4378|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52378|name:Gabriels Big Break - KS1 Digital Download|product_id:4737|sku:|quantity:1|subtotal:31.00|subtotal_tax:6.20|total:31.00|total_tax:6.20|refunded:0.00|refunded_qty:0|meta:;id:52379|name:Performance Licence - NO admission charged|product_id:7983|sku:|quantity:1|subtotal:30.00|subtotal_tax:6.00|total:30.00|total_tax:6.00|refunded:0.00|refunded_qty:0|meta:",,,id:52380|rate_id:1|code:GB-VAT-1|title:VAT|total:12.20|compound:,,,"Order status changed by bulk edit: Order status changed from Processing to Completed.|Order status changed from Pending payment to Processing.|PayPoint payment completed. Transaction ID: 035295",0
17930,16218,16218,"2019-08-18 07:01:39",completed,0.00,0.00,0.00,0.00,1.00,0.00,6.00,0.00,GBP,paypoint,,0,Hasina,Gaffar,"Iqra VA Primary School",hgaffar@iqra.lambeth.sch.uk,07578438945,"44 Alton Road",,"SW15 4NH",Roehampton,,GB,,,,,,,,,,,"id:52370|name:Forces - assembly & song download|product_id:6642|sku:|quantity:1|subtotal:0.00|subtotal_tax:0.00|total:0.00|total_tax:0.00|refunded:0.00|refunded_qty:0|meta:;id:52371|name:Forces - assembly & song digital download zip|product_id:6677|sku:|quantity:1|subtotal:5.00|subtotal_tax:1.00|total:5.00|total_tax:1.00|refunded:0.00|refunded_qty:0|meta:",,,id:52372|rate_id:1|code:GB-VAT-1|title:VAT|total:1.00|compound:,,,"Order exported to CSV and successfully downloaded.|Order status changed from Pending payment to Completed.|PayPoint payment completed. Transaction ID: 057951",0