Order Detail

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

Back

Order Fields

Old order ID31972 DateNov 5, 2025 ParentRaven Oltremari EmailNikkioltremari@yahoo.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Saydee OltremariTuscaloosa ACT Intensive Course (for December 13th, 2025 Test)Tuscaloosa ACT Intensive Course (for December 13th, 2025 Test)$295.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal5BD36712K5564762P$295.002025-11-05 11:01:2832481

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid1007
created_at2025-11-05 19:00:46
date1762369246
finish0
id31972
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id49424
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\\":47109087,\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":295},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"george@allpencilsdown.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":2.785000000000000142108547152020037174224853515625}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAMmv4HbuALZPpdOKQRVS9J8Sbi25C4LmisOH2JEY1bcdayHykYYjTt1xX87uDIlA7BFg6pwDEnowI3-jb2JJDbyksgCHA\\",\\"Content-Length: 538\\"]\"}
paypal_response{\"id\":\"5BD36712K5564762P\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"nikkioltremari@yahoo.com\",\"account_id\":\"FZLL3FLF63ZXN\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Raven\",\"surname\":\"Oltremari\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"47109087\",\"shipping\":{\"name\":{\"full_name\":\"Raven Oltremari\"},\"address\":{\"address_line_1\":\"8569 Lizelia Rd\",\"address_line_2\":\"8569 Lizelia Rd\",\"admin_area_2\":\"Meridian\",\"admin_area_1\":\"MS\",\"postal_code\":\"39305-9489\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"0RE020866L8032526\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"295.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"295.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"10.79\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"284.21\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0RE020866L8032526\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/0RE020866L8032526\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5BD36712K5564762P\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-11-05T19:01:28Z\",\"update_time\":\"2025-11-05T19:01:28Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Raven\",\"surname\":\"Oltremari\"},\"email_address\":\"nikkioltremari@yahoo.com\",\"payer_id\":\"FZLL3FLF63ZXN\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/5BD36712K5564762P\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-11-05 19:00:46
userid20621
video_access_date0000-00-00