Order Detail

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

Back

Order Fields

Old order ID31329 DateJul 1, 2025 ParentHolly Hooks Emailhollymhooks@gmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Spencer HooksBirmingham ACT Foundations Prep Course (AS) (for July 12th, 2025 Test)Birmingham ACT Foundations Prep Course (AS) (for July 12th, 2025 Test)$395.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal7JL03445ER612791Y$395.002025-07-01 19:55:0331838

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid989
created_at2025-07-02 02:51:50
date1751424710
finish0
id31329
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48076
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\\":19273295,\\"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 A21AAMSj_gFvm1RqGWG4pvsbc_Rw1NezXLu9vevh3p6K8CskIcOvXjwnDHW_jZiA_zboNzyEel-yLOQB6btshaUirtd_IHpmQ\\",\\"Content-Length: 540\\"]\"}
paypal_response{\"id\":\"7JL03445ER612791Y\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"jonathanmhooks@att.net\",\"account_id\":\"S4EQR5DU2GWNU\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Jonathan\",\"surname\":\"Hooks\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"19273295\",\"shipping\":{\"name\":{\"full_name\":\"Holly Hooks\"},\"address\":{\"address_line_1\":\"1108 Guinevere Cir\",\"admin_area_2\":\"Hoover\",\"admin_area_1\":\"AL\",\"postal_code\":\"35226-2940\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"07U02694GP0707720\",\"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\/07U02694GP0707720\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/07U02694GP0707720\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7JL03445ER612791Y\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-07-02T02:55:02Z\",\"update_time\":\"2025-07-02T02:55:02Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Jonathan\",\"surname\":\"Hooks\"},\"email_address\":\"jonathanmhooks@att.net\",\"payer_id\":\"S4EQR5DU2GWNU\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7JL03445ER612791Y\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-07-02 02:51:50
userid20368
video_access_date0000-00-00