2025-08-08 04:00:01 [INFO]: Execution Started
2025-08-08 04:00:01 [INFO]: old server sucessfully connected
2025-08-08 04:00:01 [INFO]: sqs client sucess created
2025-08-08 04:00:02 [INFO]: Number of messages in the queue: 0
2025-08-08 04:00:22 [INFO]: Execution Started
2025-08-08 04:00:22 [INFO]: Execution Finished
2025-08-08 04:10:01 [INFO]: Execution Started
2025-08-08 04:10:01 [INFO]: old server sucessfully connected
2025-08-08 04:10:02 [INFO]: sqs client sucess created
2025-08-08 04:10:03 [INFO]: Number of messages in the queue: 1
2025-08-08 04:10:03 [INFO]: item found in queue is if condition  14409
2025-08-08 04:10:03 [INFO]: item found in queue is  14409
2025-08-08 04:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBb+HamO+WriW4nro0+PVciE9WD5kaTOuBgh6xOoxhqXXzh+goHEjINgqVcyJAMo4cG0NfB+p8VLZ37S+lSZOC1entLndTXMEHJceVUTZfUOHyHbz2qkQ6N/g7MiWZdFDfQDgXv8cA99H21JqdZw+fPmlq1ZYZkFTAH278l2gLNhMKMgpm+m5HfaVojiN7no2Urpwko8Zg6ByQQ1SY2EyeH5YwJlXEzWm0wvrU1w6NZ3gIW3mpHdttrz9ViFZ061UWjv5LLvnW1OkCfaii5UpyDaiZeHTGghRHn1JyS5Tlsaib/Mw/fSSsFCeSmVxYH+nwGKnbkXbL8oL71afBZmmyNr3RM7KY77KmzfAPJOeVUS10bnNB+FbghwUmZjzLU+GT3qddCsBuEcSAMHBGXE3PUTWeSNyPBfL8SH+4pIrcRi/udV4AZucZgviFe4bJu3JF
2025-08-08 04:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 04:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 04:10:03 [INFO]: inside itemsold and closed 14409
2025-08-08 04:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 04:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 04:10:05 [INFO]: Ebay item id :: 256835395765 exists in Database
2025-08-08 04:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 04:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 04:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 04:10:05 [INFO]: in processold action queue is array    for {"44685764":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685764","ebayitemid":"256835395765","shopifyproductid":"8179354829022","variants":[{"price":"22.99","quantity":0,"weight":"3","shopifyproductid":"8179354829022","shopifyvariantid":"44465106616542","shopifyinventoryid":"46563034955998","shopifylocationid":"","product_id":"44685764","variant_id":"77590989","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 04:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 04:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 04:10:05 [INFO]: Shopify Inventory id 46563034955998
2025-08-08 04:10:05 [INFO]: Shopify Location id 58450641063
2025-08-08 04:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 04:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-08 04:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 04:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685764 and user_id = 14409 
2025-08-08 04:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590989 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 04:10:05 [INFO]: updateIdsQuantity -> ["77590989"]
2025-08-08 04:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 04:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77590989 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77590989 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77590989)
2025-08-08 04:10:05 [INFO]: QUANTITY Updated IDs: 77590989
2025-08-08 04:10:05 [INFO]: Successfully processed data for user 14409
2025-08-08 04:10:05 [INFO]: Execution Started
2025-08-08 04:10:05 [INFO]: Execution Finished
2025-08-08 04:20:01 [INFO]: Execution Started
2025-08-08 04:20:01 [INFO]: old server sucessfully connected
2025-08-08 04:20:02 [INFO]: sqs client sucess created
2025-08-08 04:20:03 [INFO]: Number of messages in the queue: 2
2025-08-08 04:20:03 [INFO]: item found in queue is if condition  14409
2025-08-08 04:20:03 [INFO]: item found in queue is  14409
2025-08-08 04:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBbvWxs55+SobvzTuJ0jrON7OqBDupngZdYdDHxlRr8Hhnx/e4oJQFIN6DDznPtsfMlkCrBw688isaRXv12pNG4/EMtRkJ6UAZiDxEQxgwVQhUiuChFzt1Pti1yWmpYOObBLS4VsCF3hhFk9TfS7G74OShFVJHTZfQobqggG91059q2SFqb1jJ4wVfXMmq/uWzzXeBgxbVzJ6SfWn5xAmE9CRGbjbB3fGu5hT4Z9QiP9JDgfmDh8r3s2BLkQmEDIrmN9Ie1FDlyZB9nijO2WlsEN0TguPPC0P4+ECmudikJnI3cJOomegDdNBJfvAIETgbkRtICh7Qe838u6JmpXEaykmBT4OdH940sRxq1bMH1RvTR6wR/ReqIln7bzq9V4/r1UXhj5nuo4L3UXfQvEzegNNaM6a+QGTt2C7Dae4a93rjs7cTOPle/n+avBZLTo5O
2025-08-08 04:20:03 [INFO]: item found in queue is if condition  14409
2025-08-08 04:20:03 [INFO]: item found in queue is  14409
2025-08-08 04:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBQRCAxlC+zw2xsomPUnqGwnVb2ocy98JesQdoGwOUxzCgprU3rDNfUt7wrbnv6MfkUMyCjNK+A6zgCaup/eyfwLGbJzqPQbilExiTTNHQr8Ly1qwgKfVEppmW3i7DKevsNoey2Fs/QYLepNznVEIjf/lZYwQ0azIwVsSACFINDFYXiggoKG84rRMS0GzsiuayMgskak9SI8GCvSpfjpFGXl2ObevDEDHeAEamS0Su88XXoVim/7f4dWODeHmhn3gGahICBLCSZvA/XcmcwU6E0RoyleCAP87apcPBLvI7sqLO+1g4IodP90K5MrYvr1XmDBnBs1ufqirSuSxJJEtnz57EtDzzOaLN7MzEtK/pEsowq0hPr85Rhsy+zxsNZcEMwjOcICLZSs9txX4+/eJvc1X1JAISwgx0A1vwQ/Rkgz8GSH1GIpLS+CFy2uAAWsRg
2025-08-08 04:20:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-08 04:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 04:20:04 [INFO]: inside itemsold and closed 14409
2025-08-08 04:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 04:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-08 04:20:05 [INFO]: Ebay item id :: 335970835631 exists in Database
2025-08-08 04:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 04:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 04:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 04:20:05 [INFO]: inside itemsold and closed 14409
2025-08-08 04:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 04:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-08 04:20:07 [INFO]: Ebay item id :: 286324904424 exists in Database
2025-08-08 04:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 04:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 04:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 04:20:07 [INFO]: in processold action queue is array    for {"44805797":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44805797","ebayitemid":"335970835631","shopifyproductid":"8926411194590","variants":[{"price":"28.99","quantity":0,"weight":"0.75","shopifyproductid":"8926411194590","shopifyvariantid":"46838138929374","shopifyinventoryid":"48936627962078","shopifylocationid":"58450641063","product_id":"44805797","variant_id":"77716238","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570191":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570191","ebayitemid":"286324904424","shopifyproductid":"8817221435614","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8817221435614","shopifyvariantid":"46289377460446","shopifyinventoryid":"48390301581534","shopifylocationid":"","product_id":"44570191","variant_id":"77462875","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 04:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 04:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 04:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 04:20:07 [INFO]: Shopify Inventory id 48936627962078
2025-08-08 04:20:07 [INFO]: Shopify Location id 58450641063
2025-08-08 04:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 04:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T04:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 04:20:07 [INFO]: Change: available | Delta: -1
2025-08-08 04:20:07 [INFO]: Change: on_hand | Delta: -1
2025-08-08 04:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 04:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44805797 and user_id = 14409 
2025-08-08 04:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77716238 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 04:20:07 [INFO]: Shopify Inventory id 48390301581534
2025-08-08 04:20:07 [INFO]: Shopify Location id 58450641063
2025-08-08 04:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 04:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-08 04:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 04:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570191 and user_id = 14409 
2025-08-08 04:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462875 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 04:20:08 [INFO]: updateIdsQuantity -> ["77716238","77462875"]
2025-08-08 04:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-08 04:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77716238 THEN 0 WHEN id = 77462875 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77716238 THEN 0 WHEN id = 77462875 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77716238,77462875)
2025-08-08 04:20:08 [INFO]: QUANTITY Updated IDs: 77716238, 77462875
2025-08-08 04:20:08 [INFO]: Successfully processed data for user 14409
2025-08-08 04:20:08 [INFO]: Execution Started
2025-08-08 04:20:08 [INFO]: Execution Finished
2025-08-08 04:30:02 [INFO]: Execution Started
2025-08-08 04:30:02 [INFO]: old server sucessfully connected
2025-08-08 04:30:02 [INFO]: sqs client sucess created
2025-08-08 04:30:03 [INFO]: Number of messages in the queue: 0
2025-08-08 04:30:23 [INFO]: Execution Started
2025-08-08 04:30:23 [INFO]: Execution Finished
2025-08-08 04:40:01 [INFO]: Execution Started
2025-08-08 04:40:01 [INFO]: old server sucessfully connected
2025-08-08 04:40:01 [INFO]: sqs client sucess created
2025-08-08 04:40:03 [INFO]: Number of messages in the queue: 0
2025-08-08 04:40:23 [INFO]: Execution Started
2025-08-08 04:40:23 [INFO]: Execution Finished
2025-08-08 04:50:01 [INFO]: Execution Started
2025-08-08 04:50:01 [INFO]: old server sucessfully connected
2025-08-08 04:50:01 [INFO]: sqs client sucess created
2025-08-08 04:50:02 [INFO]: Number of messages in the queue: 1
2025-08-08 04:50:02 [INFO]: item found in queue is if condition  14409
2025-08-08 04:50:02 [INFO]: item found in queue is  14409
2025-08-08 04:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEBANpW+noFkIldsPtaUvAZxUU6VqnWNi7u0xvav25sRD7bIj0ESlSukc7Klof6yCQwSIyzP8ULiP0BJWaWBbw/xtrLOM19lKYJi3CwZLcM3j/lIzxeFqIxHb0Lg5dlg2cohyTW7c8NhzZ55B3JqJx+shQYusbuQPAZE6E0KUYjD33ku8eaWEY0x0uc6c4FJmCguqf5+UKrWNFw9IJceebO0SEZ6VSDfRhHIAg2sLxe6ERuhtpv6GoHtsShxJVFxxJ2fZgR6RSKt5REL7zRfHSql9PppQS0L5xHFb24dxy4KENaZE/h5btXGdPQqCh7xcEW7XKz3CZN8afuJ7emUshQcCOeKI5S+S0okes3yj5BWJ0fC9ZO+udV8U4R4k9+zj8e4RG0SbK6PUWnRrmeSTFDsLaTqmEluC0Dnr8Gvj++xjhPQV83C+V98cBAVLvLlNLn
2025-08-08 04:50:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 04:50:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 04:50:02 [INFO]: inside itemsold and closed 14409
2025-08-08 04:50:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 04:50:04 [INFO]: autolink for user_id 14409 is 1
2025-08-08 04:50:04 [INFO]: Ebay item id :: 306399777076 exists in Database
2025-08-08 04:50:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 04:50:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-08 04:50:04 [INFO]: in processold action queue is array    for {"45240667":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45240667","ebayitemid":"306399777076","deleted":1}}}
2025-08-08 04:50:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 04:50:04 [INFO]: productIds WHich are having null productid -> [45240667]
2025-08-08 04:50:04 [INFO]: ebayItemIds WHich are not imported-> ["306399777076"]
2025-08-08 04:50:04 [INFO]: Entered in bulkUpdateProducts function
2025-08-08 04:50:04 [INFO]: Transaction started for bulkUpdateProducts
2025-08-08 04:50:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45240667)
2025-08-08 04:50:04 [INFO]: Query executed successfully. Affected rows: 0
2025-08-08 04:50:04 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-08 04:50:04 [INFO]: Transaction committed successfully.
2025-08-08 04:50:04 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-08 04:50:04 [INFO]: Successfully processed data for user 14409
2025-08-08 04:50:04 [INFO]: Execution Started
2025-08-08 04:50:04 [INFO]: Execution Finished