Order Detail

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

Back

Order Fields

Old order ID31174 DateJun 16, 2025 ParentPandi Dean Emailpandi.dean@gmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Parker DeanBirmingham ACT Foundations Prep Course (MS) (for July 12th, 2025 Test)Birmingham ACT Foundations Prep Course (MS) (for July 12th, 2025 Test)$395.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal2X6409629M763370C$395.002025-06-16 12:34:5631683

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid992
created_at2025-06-16 19:33:26
date1750102406
finish0
id31174
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id49153
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\\":11294674,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":395},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":3.08499999999999996447286321199499070644378662109375}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAOrh1q5tIH_TyRTHm2QUkrogEyTZBfUebx5q5W6YB_9qJoviyzEdlO23eLIpcqWKYYFMms3KRGFxwnX379Nc9_Gp2zwzg\\",\\"Content-Length: 540\\"]\"}
paypal_response{\"id\":\"2X6409629M763370C\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"pandi.dean@gmail.com\",\"account_id\":\"S497JVB7Q2WT2\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Pandora\",\"surname\":\"Dean\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"11294674\",\"shipping\":{\"name\":{\"full_name\":\"Dean Pandi\"},\"address\":{\"address_line_1\":\"267 Shore Front Lane\",\"admin_area_2\":\"Wilsonville\",\"admin_area_1\":\"AL\",\"postal_code\":\"35186\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"9T211668M5484413G\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"395.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"395.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"14.28\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"380.72\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/9T211668M5484413G\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/9T211668M5484413G\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/2X6409629M763370C\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-06-16T19:34:55Z\",\"update_time\":\"2025-06-16T19:34:55Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Pandora\",\"surname\":\"Dean\"},\"email_address\":\"pandi.dean@gmail.com\",\"payer_id\":\"S497JVB7Q2WT2\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/2X6409629M763370C\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-06-16 19:33:26
userid20318
video_access_date0000-00-00