select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID  desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTE1MTM5NTM5MTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo0NTo0Ny42NTI1MDAifQ==eyJsYXN0X2lkIjo1OTE1MTM5NTM5MTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo0NTo0Ny42NTI1MDAifQ==
SRI#99059 processing
danalockee@gmail.com processing
INSERT INTO `newsystem_customers`  ( `newSystemMemberID`,  `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`,  `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`)  VALUES ( 'gid://shopify/Customer/7387885371572','danalockee@gmail.com', 'Dana', 'Lockee', '', '4024304643', '4024304643', '2388 S 162nd St ', 'Walton','68461-9510', 'Nebraska', 'United States', '1', '2026-08-25 14:33:47')
gid://shopify/Order/5915152711860Exported

New Cursor --eyJsYXN0X2lkIjo1OTE1MTUyNzExODYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo1Mjo0MC4wMDAwMDAifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5915152711860' ,`newSystemOrderNumber`='SRI#99059' ,`newSystemCustomerID`='gid://shopify/Customer/7387885371572' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-21 14:52:42' ,`newSystemCustomerEmail`='danalockee@gmail.com' ,`order_completed`='2024-09-21 14:52:40' ,`currency`='USD' ,`order_total`='242.64' ,`order_subtotal`='229.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='12.65' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTE1MTUyNzExODYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo1Mjo0MC4wMDAwMDAifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5915152711860
    [newSystemProductId] => gid://shopify/LineItem/14379570069684
    [stockCode] => SRI-DryQ-Ver2
    [actualCIStockCode] => SRI-DryQ-Ver2
    [quantity] => 1
    [unitPrice] => 227.99
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5915152711860' ,`newSystemProductId`='gid://shopify/LineItem/14379570069684' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='227.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/7387885371572' ,`newSystemOrderID`='gid://shopify/Order/5915152711860' ,`deliveryFirstName`='Dana' ,`deliveryLastName`='Lockee' ,`deliveryPhone`='4024304643' ,`deliveryStreet`='2388 S 162nd St ' ,`deliverySuburb`='' ,`deliveryPostCode`='68461-9510' ,`deliveryCountry`='United States' ,`deliveryCity`='Walton' ,`deliveryState`='Nebraska' ,`store`='SRI'SRI#99060 processing
shaggydaken@yahoo.com processing
UPDATE `newsystem_customers`   SET `emailAddress`='shaggydaken@yahoo.com', `firstName`='Ken', `lastName`='Heimerman', `tradingName`='', `homePhone`='7154327492', `mobile`='7154327492',  `street`= '1212 Arthur Street ', `city`='Wausau', `postCode`='54403', `state`='Wisconsin', `country`='United States', `pending`='1', `middleEntryDate`='2026-08-25 14:33:47' where `newSystemMemberID`='gid://shopify/Customer/6493956964532'
gid://shopify/Order/5915157299380Exported

New Cursor --eyJsYXN0X2lkIjo1OTE1MTU3Mjk5MzgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo1NTowOC4wOTg4OTUifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5915157299380' ,`newSystemOrderNumber`='SRI#99060' ,`newSystemCustomerID`='gid://shopify/Customer/6493956964532' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-21 14:55:11' ,`newSystemCustomerEmail`='shaggydaken@yahoo.com' ,`order_completed`='2024-09-21 14:55:08' ,`currency`='USD' ,`order_total`='82.26' ,`order_subtotal`='77.97' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='4.29' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='REQUEST_DECLINED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTE1MTU3Mjk5MzgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAyMTo1NTowOC4wOTg4OTUifQ==' ,`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/5915157299380
    [newSystemProductId] => gid://shopify/LineItem/14379581178036
    [stockCode] => SRI-RenewGlow-Veg-X3
    [actualCIStockCode] => 
    [quantity] => 1
    [unitPrice] => 
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5915157299380' ,`newSystemProductId`='gid://shopify/LineItem/14379581178036' ,`stockCode`='SRI-RenewGlow-Veg-X3' ,`actualCIStockCode`='' ,`quantity`='1' ,`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