Order Detail

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

Back

Order Fields

Old order ID29902 DateDec 29, 2024 ParentAudrey Rickert Emailasl113@aol.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Sela RickertEnglish Comprehensive ReviewEnglish Comprehensive Review$75.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal7TS65154YN611345B$75.002024-12-29 14:53:2330411

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid883
created_at2024-12-29 22:52:54
date1735512774
finish0
id29902
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48653
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\\":55562331,\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":169},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"gmizzell@bellsouth.net\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.407000000000000028421709430404007434844970703125}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}},{\\"reference_id\\":20674047,\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":75},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.125}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAN1Gmw2tTLhzfTle0W8kQ_CQK156Q-hTyBog6NC4bFGC4jMuruXoTvhOR7xwwVXkCdlilpJe9q0LHq747SZ0XrrMOZ9rg\\",\\"Content-Length: 817\\"]\"}
paypal_response{\"id\":\"7TS65154YN611345B\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"asl113@aol.com\",\"account_id\":\"84ZBWJ2TASK58\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Audrey\",\"surname\":\"L Rickert\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"20674047\",\"shipping\":{\"name\":{\"full_name\":\"Audrey L Rickert\"},\"address\":{\"address_line_1\":\"3575 Altadena Park Ln\",\"admin_area_2\":\"Vestavia\",\"admin_area_1\":\"AL\",\"postal_code\":\"35243-2922\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"0RE174707X291302U\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"75.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"75.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"3.11\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"71.89\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0RE174707X291302U\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0RE174707X291302U\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7TS65154YN611345B\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-12-29T22:53:18Z\",\"update_time\":\"2024-12-29T22:53:18Z\"}]}},{\"reference_id\":\"55562331\",\"shipping\":{\"name\":{\"full_name\":\"Audrey L Rickert\"},\"address\":{\"address_line_1\":\"3575 Altadena Park Ln\",\"admin_area_2\":\"Vestavia\",\"admin_area_1\":\"AL\",\"postal_code\":\"35243-2922\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"15778342LT5918038\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"169.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"169.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"6.39\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"162.61\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/15778342LT5918038\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/15778342LT5918038\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7TS65154YN611345B\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2024-12-29T22:53:17Z\",\"update_time\":\"2024-12-29T22:53:17Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Audrey\",\"surname\":\"L Rickert\"},\"email_address\":\"asl113@aol.com\",\"payer_id\":\"84ZBWJ2TASK58\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7TS65154YN611345B\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2024-12-29 22:52:54
userid19609
video_access_date0000-00-00