Order Detail

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

Back

Order Fields

Old order ID33108 DateMay 29, 2026 ParentSusan Guillen Emailsusanmguillen@aol.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Gabrielle GuillenEnglish Workshop (for June 13, 2026 test)English Workshop (for June 13, 2026 test)$250.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal9JK27566W52174149$250.002026-05-29 13:16:4933618

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid1024
created_at2026-05-29 20:16:11
date1780085771
finish0
id33108
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id49072
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\\":40749262,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":250},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.649999999999999911182158029987476766109466552734375}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AANZjJ90jd6Z9H6eSEtTA9D_SFI1P6GeV4nYKLq4rD4zZ3LPN2g__LaQovkyt0PxEotQaCYUMMezYIG8-a5_-xRei38aKg\\",\\"Content-Length: 541\\"]\"}
paypal_response{\"id\":\"9JK27566W52174149\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"susanmguillen@aol.com\",\"account_id\":\"YDQ9JC8HVCAMU\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Susan\",\"surname\":\"Guillen\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"40749262\",\"shipping\":{\"name\":{\"full_name\":\"Madeline Guillen\"},\"address\":{\"address_line_1\":\"1048 Kingston Rd\",\"admin_area_2\":\"Chelsea\",\"admin_area_1\":\"AL\",\"postal_code\":\"35043\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"0M374007WG552193R\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"250.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"250.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"9.22\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"240.78\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0M374007WG552193R\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0M374007WG552193R\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/9JK27566W52174149\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2026-05-29T20:16:49Z\",\"update_time\":\"2026-05-29T20:16:49Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Susan\",\"surname\":\"Guillen\"},\"email_address\":\"susanmguillen@aol.com\",\"payer_id\":\"YDQ9JC8HVCAMU\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/9JK27566W52174149\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2026-05-29 20:16:11
userid20215
video_access_date0000-00-00