Order Detail

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

Back

Order Fields

Old order ID30071 DateJan 27, 2025 ParentKandi Williams Emailkandi.williams.rn@gmail.com Payment modepaypal Payment status
Transaction ID

Items

StudentCourseProductAmountStatus
Parker WilliamsGrammar Online WorkshopGrammar Online Workshop$25.00enrolled

Payment Rows

ProviderTransaction / Payment IDAmountStatusDateOld Payment ID
paypal7VK08459NS019212E$25.002025-01-27 17:50:2330580

Raw Old Order Fields

Old FieldImported Value
comment_date
courseid603
created_at2025-01-28 01:48:57
date1738028937
finish0
id30071
is_deleted0
is_new_order1
live0
onlineclass
ord_comments
order_type0
paid1
paid_resp
paid_status0
parent_id48828
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\\":29898970,\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":25},\\"platform_fees\\":{\\"payee\\":{\\"email_address\\":\\"lljrolltide@aol.com\\"},\\"amount\\":{\\"currency_code\\":\\"USD\\",\\"value\\":1.9749999999999998667732370449812151491641998291015625}},\\"payment_instruction\\":{\\"disbursement_mode\\":\\"INSTANT\\"}}]}\",\"headers\":\"[\\"Content-Type: application\\\/json\\",\\"Authorization: Bearer A21AAOaoc9Cgo8zBvaVb9tR3YNdCHnrYPQ3mpubqTNPJbagA0S6sEpRH2zKiblNsb0I9-QmlCbjW0q6V5Le3NHACCOF1q8SYQ\\",\\"Content-Length: 529\\"]\"}
paypal_response{\"id\":\"7VK08459NS019212E\",\"status\":\"COMPLETED\",\"payment_source\":{\"paypal\":{\"email_address\":\"kandile@aol.com\",\"account_id\":\"22CUYZ54C9MNS\",\"account_status\":\"VERIFIED\",\"name\":{\"given_name\":\"Kandi\",\"surname\":\"Williams\"},\"address\":{\"country_code\":\"US\"}}},\"purchase_units\":[{\"reference_id\":\"29898970\",\"shipping\":{\"name\":{\"full_name\":\"KANDI WILLIAMS\"},\"address\":{\"address_line_1\":\"515 Bagley Dr\",\"admin_area_2\":\"Anniston\",\"admin_area_1\":\"AL\",\"postal_code\":\"36201-3901\",\"country_code\":\"US\"}},\"payments\":{\"captures\":[{\"id\":\"6P813190FJ013804L\",\"status\":\"COMPLETED\",\"amount\":{\"currency_code\":\"USD\",\"value\":\"25.00\"},\"final_capture\":true,\"seller_protection\":{\"status\":\"ELIGIBLE\",\"dispute_categories\":[\"ITEM_NOT_RECEIVED\",\"UNAUTHORIZED_TRANSACTION\"]},\"seller_receivable_breakdown\":{\"gross_amount\":{\"currency_code\":\"USD\",\"value\":\"25.00\"},\"paypal_fee\":{\"currency_code\":\"USD\",\"value\":\"1.36\"},\"net_amount\":{\"currency_code\":\"USD\",\"value\":\"23.64\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/6P813190FJ013804L\",\"rel\":\"self\",\"method\":\"GET\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/payments\/captures\/6P813190FJ013804L\/refund\",\"rel\":\"refund\",\"method\":\"POST\"},{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7VK08459NS019212E\",\"rel\":\"up\",\"method\":\"GET\"}],\"create_time\":\"2025-01-28T01:50:22Z\",\"update_time\":\"2025-01-28T01:50:22Z\"}]}}],\"payer\":{\"name\":{\"given_name\":\"Kandi\",\"surname\":\"Williams\"},\"email_address\":\"kandile@aol.com\",\"payer_id\":\"22CUYZ54C9MNS\",\"address\":{\"country_code\":\"US\"}},\"links\":[{\"href\":\"https:\/\/api.paypal.com\/v2\/checkout\/orders\/7VK08459NS019212E\",\"rel\":\"self\",\"method\":\"GET\"}]}
paypal_token[redacted]
pu_date
sent1
start0
transid
updated_at2025-01-28 01:48:57
userid19830
video_access_date0000-00-00