select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEzMDk3ODk2MTE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoxMzoyNS43NzY4NDQifQ==eyJsYXN0X2lkIjo1OTEzMDk3ODk2MTE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoxMzoyNS43NzY4NDQifQ==SRI#98918 processing
emichele22@hotmail.com processing
UPDATE `newsystem_customers` SET `emailAddress`='emichele22@hotmail.com', `firstName`='Erin', `lastName`='Roberts', `tradingName`='', `homePhone`='6164504436', `mobile`='6164504436', `street`= '2929 Quigley Road ', `city`='Langley', `postCode`='98260', `state`='Washington', `country`='United States', `pending`='1', `middleEntryDate`='2026-06-20 21:00:42' where `newSystemMemberID`='gid://shopify/Customer/7002845085876'gid://shopify/Order/5913109495988Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMTA5NDk1OTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoxOTo0NC44MTg1MzUifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913109495988' ,`newSystemOrderNumber`='SRI#98918' ,`newSystemCustomerID`='gid://shopify/Customer/7002845085876' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:19:48' ,`newSystemCustomerEmail`='emichele22@hotmail.com' ,`order_completed`='2024-09-20 11:19:44' ,`currency`='USD' ,`order_total`='374.08' ,`order_subtotal`='338.99' ,`total_items`='2' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='35.09' ,`coupon_code`='' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMTA5NDk1OTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoxOTo0NC44MTg1MzUifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5913109495988
[newSystemProductId] => gid://shopify/LineItem/14375184990388
[stockCode] => SRI-DryQ-Ver2
[actualCIStockCode] => SRI-DryQ-Ver2
[quantity] => 1
[unitPrice] => 219.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5913109495988' ,`newSystemProductId`='gid://shopify/LineItem/14375184990388' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='219.99' ,`discountAmount`='0.0' ,`store`='SRI'Array
(
[newSystemOrderID] => gid://shopify/Order/5913109495988
[newSystemProductId] => gid://shopify/LineItem/14375202521268
[stockCode] => SRI-InfraStyler-Ver2-TE-X1
[actualCIStockCode] => SRI-InfraStyler-Ver2-TE-X1
[quantity] => 1
[unitPrice] => 169.00
[discountAmount] => 70.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5913109495988' ,`newSystemProductId`='gid://shopify/LineItem/14375202521268' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`actualCIStockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`quantity`='1' ,`unitPrice`='169.00' ,`discountAmount`='70.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7002845085876' ,`newSystemOrderID`='gid://shopify/Order/5913109495988' ,`deliveryFirstName`='Erin' ,`deliveryLastName`='Roberts' ,`deliveryPhone`='6164504436' ,`deliveryStreet`='916 SW Austin St ' ,`deliverySuburb`='' ,`deliveryPostCode`='98106-2040' ,`deliveryCountry`='United States' ,`deliveryCity`='Seattle' ,`deliveryState`='Washington' ,`store`='SRI'SRI#98919 processing
slywkad@yahoo.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7381911765172','slywkad@yahoo.com', 'Donna', 'slywka', '', '+14255315534', '+14255315534', '17143 133RD AVE NE APT362', 'WOODINVILLE','98072-3522', 'Washington', 'United States', '1', '2026-06-20 21:00:42')gid://shopify/Order/5913115885748Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMTE1ODg1NzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoyMzoyMy42ODQxNjEifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913115885748' ,`newSystemOrderNumber`='SRI#98919' ,`newSystemCustomerID`='gid://shopify/Customer/7381911765172' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:23:28' ,`newSystemCustomerEmail`='slywkad@yahoo.com' ,`order_completed`='2024-09-20 11:23:23' ,`currency`='USD' ,`order_total`='49.56' ,`order_subtotal`='39.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='4.99' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='4.58' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMTE1ODg1NzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoyMzoyMy42ODQxNjEifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5913115885748
[newSystemProductId] => gid://shopify/LineItem/14375199113396
[stockCode] => SRI-DailyFacialSun-X1
[actualCIStockCode] => SRI-DailyFacialSun-X1
[quantity] => 1
[unitPrice] => 39.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5913115885748' ,`newSystemProductId`='gid://shopify/LineItem/14375199113396' ,`stockCode`='SRI-DailyFacialSun-X1' ,`actualCIStockCode`='SRI-DailyFacialSun-X1' ,`quantity`='1' ,`unitPrice`='39.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7381911765172' ,`newSystemOrderID`='gid://shopify/Order/5913115885748' ,`deliveryFirstName`='Donna' ,`deliveryLastName`='slywka' ,`deliveryPhone`='+14255315534' ,`deliveryStreet`='17143 133RD AVE NE APT362' ,`deliverySuburb`='APT362' ,`deliveryPostCode`='98072-3522' ,`deliveryCountry`='United States' ,`deliveryCity`='WOODINVILLE' ,`deliveryState`='Washington' ,`store`='SRI'SRI#98920 processing
msmlhense@gmail.com processing
UPDATE `newsystem_customers` SET `emailAddress`='msmlhense@gmail.com', `firstName`='M L', `lastName`='Hense', `tradingName`='', `homePhone`='6783136230', `mobile`='6783136230', `street`= '1801 Macy Drive ', `city`='Roswell', `postCode`='30076', `state`='Georgia', `country`='United States', `pending`='1', `middleEntryDate`='2026-06-20 21:00:42' where `newSystemMemberID`='gid://shopify/Customer/6493941006516'gid://shopify/Order/5913122144436Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMTIyMTQ0NDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoyNjo1OC40MjM5NjgifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913122144436' ,`newSystemOrderNumber`='SRI#98920' ,`newSystemCustomerID`='gid://shopify/Customer/6493941006516' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:27:01' ,`newSystemCustomerEmail`='msmlhense@gmail.com' ,`order_completed`='2024-09-20 11:26:58' ,`currency`='USD' ,`order_total`='168.03' ,`order_subtotal`='155.94' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='12.09' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMTIyMTQ0NDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODoyNjo1OC40MjM5NjgifQ==' ,`store`='SRI'
Warning: Trying to access array offset on value of type null in /home/nepsols/sri.nepsols.com/old/api-orders.php on line 632
Warning: Trying to access array offset on value of type null in /home/nepsols/sri.nepsols.com/old/api-orders.php on line 632
Array
(
[newSystemOrderID] => gid://shopify/Order/5913122144436
[newSystemProductId] => gid://shopify/LineItem/14375214645428
[stockCode] => SRI-RenewGlow-Veg-X3
[actualCIStockCode] =>
[quantity] => 2
[unitPrice] =>
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5913122144436' ,`newSystemProductId`='gid://shopify/LineItem/14375214645428' ,`stockCode`='SRI-RenewGlow-Veg-X3' ,`actualCIStockCode`='' ,`quantity`='2' ,`unitPrice`='' ,`discountAmount`='0.0' ,`store`='SRI'
Fatal error: Uncaught mysqli_sql_exception: Data truncated for column 'unitPrice' at row 1 in /home/nepsols/sri.nepsols.com/old/config.php:511
Stack trace:
#0 /home/nepsols/sri.nepsols.com/old/config.php(511): mysqli_query(Object(mysqli), 'INSERT INTO `ne...')
#1 /home/nepsols/sri.nepsols.com/old/api-orders.php(642): createDatas('newsystem_order...', Array, false)
#2 {main}
thrown in /home/nepsols/sri.nepsols.com/old/config.php on line 511