select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTA2NTYwNTgxODEyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNTo1NDo1MS4wNTc2MDkifQ==eyJsYXN0X2lkIjo1OTA2NTYwNTgxODEyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNTo1NDo1MS4wNTc2MDkifQ==SRI#98471 processing
halaassile@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/7361864204468','halaassile@gmail.com', 'Michael', 'Assile', '', '2018889654', '2018889654', '21 McGregor Ave ', 'Mt Arlington','07856', 'New Jersey', 'United States', '1', '2025-01-06 09:52:11')gid://shopify/Order/5906584142004Exported
New Cursor --eyJsYXN0X2lkIjo1OTA2NTg0MTQyMDA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjowOTo0NS4yMTk2NDYifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5906584142004' ,`newSystemOrderNumber`='SRI#98471' ,`newSystemCustomerID`='gid://shopify/Customer/7361864204468' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-16 09:09:48' ,`newSystemCustomerEmail`='halaassile@gmail.com' ,`order_completed`='2024-09-16 09:09:45' ,`currency`='USD' ,`order_total`='255.89' ,`order_subtotal`='239.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='15.9' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTA2NTg0MTQyMDA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjowOTo0NS4yMTk2NDYifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5906584142004
[newSystemProductId] => gid://shopify/LineItem/14361724059828
[stockCode] => SRI-DryQ-Ver2
[actualCIStockCode] => SRI-DryQ-Ver2
[quantity] => 1
[unitPrice] => 229.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5906584142004' ,`newSystemProductId`='gid://shopify/LineItem/14361724059828' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='229.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7361864204468' ,`newSystemOrderID`='gid://shopify/Order/5906584142004' ,`deliveryFirstName`='Hala' ,`deliveryLastName`='Assile' ,`deliveryPhone`='2018889654' ,`deliveryStreet`='21 McGregor Ave ' ,`deliverySuburb`='' ,`deliveryPostCode`='07856' ,`deliveryCountry`='United States' ,`deliveryCity`='Mt Arlington' ,`deliveryState`='New Jersey' ,`store`='SRI'SRI#98472 processing
amyhyatt@tds.net processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7327024709812','amyhyatt@tds.net', 'Amy', 'Hyatt', '', '7064552244', '7064552244', '5724 Hardscrabble Road ', 'Mineral Bluff','30559', 'Georgia', 'United States', '1', '2025-01-06 09:52:11')gid://shopify/Order/5906589384884Exported
New Cursor --eyJsYXN0X2lkIjo1OTA2NTg5Mzg0ODg0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjoxMjo1Mi4wODg5MDAifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5906589384884' ,`newSystemOrderNumber`='SRI#98472' ,`newSystemCustomerID`='gid://shopify/Customer/7327024709812' ,`shopify_recommendation`='MEDIUM' ,`order_created`='2024-09-16 09:12:52' ,`newSystemCustomerEmail`='amyhyatt@tds.net' ,`order_completed`='2024-09-16 09:12:52' ,`currency`='USD' ,`order_total`='0.0' ,`order_subtotal`='0.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='0.0' ,`coupon_code`='ABANDONSURVEY923' ,`coupon_amount`='39.99' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTA2NTg5Mzg0ODg0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjoxMjo1Mi4wODg5MDAifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5906589384884
[newSystemProductId] => gid://shopify/LineItem/14361733071028
[stockCode] => SRI-DailyFacialCleanser-Ver1-X1
[actualCIStockCode] => SRI-DailyFacialCleanser-Ver1-X1
[quantity] => 1
[unitPrice] => 39.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5906589384884' ,`newSystemProductId`='gid://shopify/LineItem/14361733071028' ,`stockCode`='SRI-DailyFacialCleanser-Ver1-X1' ,`actualCIStockCode`='SRI-DailyFacialCleanser-Ver1-X1' ,`quantity`='1' ,`unitPrice`='39.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7327024709812' ,`newSystemOrderID`='gid://shopify/Order/5906589384884' ,`deliveryFirstName`='Amy' ,`deliveryLastName`='Hyatt' ,`deliveryPhone`='7064552244' ,`deliveryStreet`='5724 Hardscrabble Road ' ,`deliverySuburb`='' ,`deliveryPostCode`='30559' ,`deliveryCountry`='United States' ,`deliveryCity`='Mineral Bluff' ,`deliveryState`='Georgia' ,`store`='SRI'SRI#98473 processing
amydlanders@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/7361882226868','amydlanders@gmail.com', 'Amy', 'Landers', '', '2083600707', '2083600707', '4785 Tanglewood Drive ', 'Idaho Falls','83406', 'Idaho', 'United States', '1', '2025-01-06 09:52:11')gid://shopify/Order/5906605965492Exported
Warning: Trying to access array offset on value of type null in /home/nepsols/sri.nepsols.com/old/api-orders.php on line 605
New Cursor --eyJsYXN0X2lkIjo1OTA2NjA1OTY1NDkyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjoyMjozNC4wNjc4MjgifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5906605965492' ,`newSystemOrderNumber`='SRI#98473' ,`newSystemCustomerID`='gid://shopify/Customer/7361882226868' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-16 09:22:36' ,`newSystemCustomerEmail`='amydlanders@gmail.com' ,`order_completed`='2024-09-16 09:22:34' ,`currency`='USD' ,`order_total`='17.0' ,`order_subtotal`='17.0' ,`total_items`='1' ,`shipping_methods`='' ,`total_shipping`='0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='0.0' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='UNFULFILLED' ,`shipping_country`='' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTA2NjA1OTY1NDkyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xNiAxNjoyMjozNC4wNjc4MjgifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5906605965492
[newSystemProductId] => gid://shopify/LineItem/14361766789300
[stockCode] => Warranty
[actualCIStockCode] => Warranty
[quantity] => 1
[unitPrice] => 17.00
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5906605965492' ,`newSystemProductId`='gid://shopify/LineItem/14361766789300' ,`stockCode`='Warranty' ,`actualCIStockCode`='Warranty' ,`quantity`='1' ,`unitPrice`='17.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7361882226868' ,`newSystemOrderID`='gid://shopify/Order/5906605965492' ,`deliveryFirstName`='Amy' ,`deliveryLastName`='Landers' ,`deliveryPhone`='2083600707' ,`deliveryStreet`='4785 Tanglewood Drive ' ,`deliverySuburb`='' ,`deliveryPostCode`='83406' ,`deliveryCountry`='United States' ,`deliveryCity`='Idaho Falls' ,`deliveryState`='Idaho' ,`store`='SRI'