[2025-03-02 00:06:15] =========erp data start========== [2025-03-02 00:06:15] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"paypal","total_amount":52.97,"discount":60.01,"currency":"USD","email":"amlara@att.net","order_time":1740845136,"pay_status":"paid","bank_account":"254764631@qq.com","payment_number":"1740845136760210","transaction_number":"5UY467512R970032K","customer_account":"amlara@att.net","pay_price":52.97,"shipping_address":{"id":15885,"order_id":18884,"zip":"93927","city":"GREENFIELD","name":"Marisol Lara","phone":"8312566620","company":null,"country":"US","address1":"PO BOX 3707","address2":null,"province":"CA","last_name":"Marisol","first_name":"Lara","country_code":"US","create_time":"2025-03-02 00:06:14"},"line_item":[{"id":33841,"order_id":18884,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":1,"price":100,"discount_price":39.99,"custom_info":null,"create_time":"2025-03-02 00:05:36"},{"id":33842,"order_id":18884,"title":"1 Year Extended Warranty","sku":"WARRANTY","variant_id":null,"num":1,"price":13.98,"discount_price":6.99,"custom_info":null,"create_time":"2025-03-02 00:05:36"}],"order_bn":"1740845136760210","shipping_fee":5.99} [2025-03-02 00:06:15] =========erp data start========== [2025-03-02 00:06:15] {"code":200,"msg":"success","data":"1740845136760210"} [2025-03-02 07:40:58] =========erp data start========== [2025-03-02 07:40:58] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"paypal","total_amount":130.96,"discount":190.01,"currency":"USD","email":"Carmec@me.com","order_time":1740872411,"pay_status":"paid","bank_account":"254764631@qq.com","payment_number":"1740872411670210","transaction_number":"6L1503399S267284F","customer_account":"Carmec@me.com","pay_price":130.96,"shipping_address":{"id":15886,"order_id":18887,"zip":"33156-4711","city":"Pinecrest","name":"Carmen Capo","phone":"3059158535","company":null,"country":"US","address1":"11300 SW 67th Ave","address2":null,"province":"FL","last_name":"Carmen","first_name":"Capo","country_code":"US","create_time":"2025-03-02 07:40:57"},"line_item":[{"id":33846,"order_id":18887,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":3,"price":100,"discount_price":109.99,"custom_info":null,"create_time":"2025-03-02 07:40:11"},{"id":33847,"order_id":18887,"title":"1 Year Extended Warranty","sku":"WARRANTY","variant_id":null,"num":3,"price":13.98,"discount_price":20.97,"custom_info":null,"create_time":"2025-03-02 07:40:11"}],"order_bn":"1740872411670210","shipping_fee":0} [2025-03-02 07:40:58] =========erp data start========== [2025-03-02 07:40:58] {"code":200,"msg":"success","data":"1740872411670210"} [2025-03-02 07:44:49] =========erp data start========== [2025-03-02 07:44:49] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"paypal","total_amount":52.97,"discount":60.01,"currency":"USD","email":"Carmec@me.com","order_time":1740872670,"pay_status":"paid","bank_account":"254764631@qq.com","payment_number":"1740872670894510","transaction_number":"6XB633928Y277620D","customer_account":"Carmec@me.com","pay_price":52.97,"shipping_address":{"id":15888,"order_id":18889,"zip":"33156-4711","city":"Pinecrest","name":"Carmen Capo","phone":"3059158535","company":null,"country":"US","address1":"11300 SW 67th Ave","address2":null,"province":"FL","last_name":"Carmen","first_name":"Capo","country_code":"US","create_time":"2025-03-02 07:44:48"},"line_item":[{"id":33850,"order_id":18889,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":1,"price":100,"discount_price":39.99,"custom_info":null,"create_time":"2025-03-02 07:44:30"},{"id":33851,"order_id":18889,"title":"1 Year Extended Warranty","sku":"WARRANTY","variant_id":null,"num":1,"price":13.98,"discount_price":6.99,"custom_info":null,"create_time":"2025-03-02 07:44:30"}],"order_bn":"1740872670894510","shipping_fee":5.99} [2025-03-02 07:44:49] =========erp data start========== [2025-03-02 07:44:49] {"code":200,"msg":"success","data":"1740872670894510"} [2025-03-02 07:47:55] =========erp data start========== [2025-03-02 07:47:55] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"paypal","total_amount":52.97,"discount":60.01,"currency":"USD","email":"Carmec@me.com","order_time":1740872863,"pay_status":"paid","bank_account":"254764631@qq.com","payment_number":"1740872863282910","transaction_number":"42X407822P376564B","customer_account":"Carmec@me.com","pay_price":52.97,"shipping_address":{"id":15889,"order_id":18890,"zip":"33156-4711","city":"Pinecrest","name":"Carmen Capo","phone":"3059158535","company":null,"country":"US","address1":"11300 SW 67th Ave","address2":null,"province":"FL","last_name":"Carmen","first_name":"Capo","country_code":"US","create_time":"2025-03-02 07:47:54"},"line_item":[{"id":33852,"order_id":18890,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":1,"price":100,"discount_price":39.99,"custom_info":null,"create_time":"2025-03-02 07:47:43"},{"id":33853,"order_id":18890,"title":"1 Year Extended Warranty","sku":"WARRANTY","variant_id":null,"num":1,"price":13.98,"discount_price":6.99,"custom_info":null,"create_time":"2025-03-02 07:47:43"}],"order_bn":"1740872863282910","shipping_fee":5.99} [2025-03-02 07:47:55] =========erp data start========== [2025-03-02 07:47:55] {"code":200,"msg":"success","data":"1740872863282910"} [2025-03-02 07:53:47] =========erp data start========== [2025-03-02 07:53:47] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"paypal","total_amount":130.96,"discount":190.01,"currency":"USD","email":"Carmec@me.com","order_time":1740873212,"pay_status":"paid","bank_account":"254764631@qq.com","payment_number":"1740873212052110","transaction_number":"57624944GA768163M","customer_account":"Carmec@me.com","pay_price":130.96,"shipping_address":{"id":15890,"order_id":18891,"zip":"33156-4711","city":"Pinecrest","name":"Carmen Capo","phone":"3059158535","company":null,"country":"US","address1":"11300 SW 67th Ave","address2":null,"province":"FL","last_name":"Carmen","first_name":"Capo","country_code":"US","create_time":"2025-03-02 07:53:46"},"line_item":[{"id":33854,"order_id":18891,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":3,"price":100,"discount_price":109.99,"custom_info":null,"create_time":"2025-03-02 07:53:32"},{"id":33855,"order_id":18891,"title":"1 Year Extended Warranty","sku":"WARRANTY","variant_id":null,"num":3,"price":13.98,"discount_price":20.97,"custom_info":null,"create_time":"2025-03-02 07:53:32"}],"order_bn":"1740873212052110","shipping_fee":0} [2025-03-02 07:53:47] =========erp data start========== [2025-03-02 07:53:47] {"code":200,"msg":"success","data":"1740873212052110"} [2025-03-02 13:01:07] 174089162947731080000:Transaction Approved [2025-03-02 13:01:07] =========erp data start========== [2025-03-02 13:01:07] {"web_url":"https:\/\/gadgets.pleasantonstore.com","payment_method":"oceanpayment","total_amount":45.98,"discount":60.01,"currency":"USD","email":"tmmaples13@gmail.com","order_time":1740891629,"pay_status":"paid","bank_account":"251704","payment_number":"1740891629477310","transaction_number":"250302130104518300317","customer_account":"tmmaples13@gmail.com","pay_price":45.98,"shipping_address":{"id":15891,"order_id":18892,"zip":"37863","city":"PIGEON FORGE","name":"TammyMaples","phone":"+18656617898","company":null,"country":"US","address1":"3062 VETERANS BLVD,Check in office","address2":null,"province":"TN","last_name":"Maples","first_name":"Tammy","country_code":"US","create_time":"2025-03-02 13:00:29"},"line_item":[{"id":33856,"order_id":18892,"title":"1X Saker Vacuum Cleaner","sku":"CP37149-C1034","variant_id":null,"num":1,"price":100,"discount_price":39.99,"custom_info":null,"create_time":"2025-03-02 13:00:29"}],"order_bn":"1740891629477310","shipping_fee":5.99} [2025-03-02 13:01:07] =========erp data start========== [2025-03-02 13:01:08] {"code":200,"msg":"success","data":"1740891629477310"} [2025-03-02 13:01:56] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'keystone.sp_order_upsell' doesn't exist