Order Detail

Order, class registration, and linked PayPal/payment import rows.

Back

Order Fields

Old order ID29915 DateJan 3, 2025 ParentAmy Stephens Emailakstephens1@hotmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Tyler StephensRocket Reader Speed Reading CourseRocket Reader Speed Reading Course$20.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal5L1026578T619134S$20.002025-01-08 10:15:5430424

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid668
created_at2025-01-03 21:14:48
date1735938888
finish0
id29915
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48714
payment_mode4
paypal_post_request{\"CURLOPT_URL\":\"https:\/\/api-m.paypal.com\/v2\/checkout\/orders\",\"CURLOPT_RETURNTRANSFER\":1,\"CURLOPT_POST\":1,\"CURLOPT_POSTFIELDS\":\"{\\"intent\\":\\"CAPTURE\\",\\"application_context\\":{\\"return_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/doPayment\\",\\"cancel_url\\":\\"https:\\\/\\\/www.allpencilsdown.com\\\/api\\\/cancelPayment\\"},\\"purchase_units\\":[{\\"reference_id\\":43188439,\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":20},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":1.95999999999999996447286321199499070644378662109375}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}},{\\"reference_id\\":77544912,\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":195},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.484999999999999875655021241982467472553253173828125}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAOBAr7FpR5xVjveA49VJXkE8y6yd7F_8IIpR6dM1iQLdmeGB9Ma9YCGNzU1hQaXjDwMlZuX34e2DrHEDwV60OMujer8QQ\\",\\"Content-Length: 867\\"]\"}
paypal_response{\"id\":\"5L1026578T619134S\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"akstephens1@hotmail.com\",\"account_id\":\"QHVH7WGYMGCW6\",\"account_status\":\"UNVERIFIED\",\"name\":{\"given_name\":\"Amy\",\"surname\":\"Stephens\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"77544912\",\"shipping\":{\"name\":{\"full_name\":\"Amy Stephens\"},\"address\":{\"address_line_1\":\"3969 Haddon Circle\",\"admin_area_2\":\"Hoover\",\"admin_area_1\":\"AL\",\"postal_code\":\"35226\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"0D487114DT281091T\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"195.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"195.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"7.30\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"187.70\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0D487114DT281091T\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0D487114DT281091T\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5L1026578T619134S\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-01-08T18:15:53Z\",\"update_time\":\"2025-01-08T18:15:53Z\"}]}},{\"reference_id\":\"43188439\",\"shipping\":{\"name\":{\"full_name\":\"Amy Stephens\"},\"address\":{\"address_line_1\":\"3969 Haddon Circle\",\"admin_area_2\":\"Hoover\",\"admin_area_1\":\"AL\",\"postal_code\":\"35226\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"7LL91746TY015072M\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"20.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"20.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"1.19\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"18.81\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/7LL91746TY015072M\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/7LL91746TY015072M\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5L1026578T619134S\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-01-08T18:15:50Z\",\"update_time\":\"2025-01-08T18:15:50Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Amy\",\"surname\":\"Stephens\"},\"email_address\":\"akstephens1@hotmail.com\",\"payer_id\":\"QHVH7WGYMGCW6\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5L1026578T619134S\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-01-03 21:14:48
userid19759
video_access_date0000-00-00