2025-08-05 01:00:01 [INFO]: Execution Started
2025-08-05 01:00:01 [INFO]: old server sucessfully connected
2025-08-05 01:00:01 [INFO]: sqs client sucess created
2025-08-05 01:00:02 [INFO]: Number of messages in the queue: 0
2025-08-05 01:00:23 [INFO]: Execution Started
2025-08-05 01:00:23 [INFO]: Execution Finished
2025-08-05 01:10:02 [INFO]: Execution Started
2025-08-05 01:10:02 [INFO]: old server sucessfully connected
2025-08-05 01:10:02 [INFO]: sqs client sucess created
2025-08-05 01:10:03 [INFO]: Number of messages in the queue: 0
2025-08-05 01:10:23 [INFO]: Execution Started
2025-08-05 01:10:23 [INFO]: Execution Finished
2025-08-05 01:20:01 [INFO]: Execution Started
2025-08-05 01:20:01 [INFO]: old server sucessfully connected
2025-08-05 01:20:02 [INFO]: sqs client sucess created
2025-08-05 01:20:03 [INFO]: Number of messages in the queue: 1
2025-08-05 01:20:03 [INFO]: item found in queue is if condition  14409
2025-08-05 01:20:03 [INFO]: item found in queue is  14409
2025-08-05 01:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBsI6yfrAXTdw8Td5z/YDD7ntks6aDyxRfInU2DA68NjGypSp4ROJGMPeGPoLBDzRiVNJOPO9DjJtZ/ICtvAX5tLNTDQWFkdaaMAwqALx/MeB/iz3zre8JWli1XhDFuu/t1U5ZOcevfMIyprhwwZap0qcCiD5sOxDAB3QK99i42j3JS/Fs5pgziOpJRicJkGVf2w2NxVlYVOVyEWEeRZK3BX/cyy+XCgsW1Mt34gPxScWZovf0aTOez5HLkX1V5kAHK0TytjMfnE7coaYTRd6E+BIp+DaxA1F19fikTha6WPB677JPORm+mN8x/AHkY1Q8LTIjQF8Pwwcaz8tZk8sWdf7vTZ3Aoymivs//PL246ADAxiz5hP6ae5Mk+6nD6JB0CCZrCv/2f6NqiorP3l9sty0ZRl2fIrMdS3yxPLYQQnEAHPc9Kn25nEhsQlY+KXVi
2025-08-05 01:20:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 01:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 01:20:03 [INFO]: inside itemsold and closed 14409
2025-08-05 01:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 01:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 01:20:05 [INFO]: Ebay item id :: 326578383298 exists in Database
2025-08-05 01:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 01:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 01:20:05 [INFO]: in processold action queue is array    for {"44873101":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"44873101","ebayitemid":"326578383298","deleted":1}}}
2025-08-05 01:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 01:20:05 [INFO]: productIds WHich are having null productid -> [44873101]
2025-08-05 01:20:05 [INFO]: ebayItemIds WHich are not imported-> ["326578383298"]
2025-08-05 01:20:05 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 01:20:05 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 01:20:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (44873101)
2025-08-05 01:20:05 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 01:20:05 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 01:20:05 [INFO]: Transaction committed successfully.
2025-08-05 01:20:05 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 01:20:05 [INFO]: Successfully processed data for user 14409
2025-08-05 01:20:05 [INFO]: Execution Started
2025-08-05 01:20:05 [INFO]: Execution Finished
2025-08-05 01:30:02 [INFO]: Execution Started
2025-08-05 01:30:02 [INFO]: old server sucessfully connected
2025-08-05 01:30:02 [INFO]: sqs client sucess created
2025-08-05 01:30:03 [INFO]: Number of messages in the queue: 0
2025-08-05 01:30:23 [INFO]: Execution Started
2025-08-05 01:30:23 [INFO]: Execution Finished
2025-08-05 01:40:01 [INFO]: Execution Started
2025-08-05 01:40:01 [INFO]: old server sucessfully connected
2025-08-05 01:40:01 [INFO]: sqs client sucess created
2025-08-05 01:40:02 [INFO]: Number of messages in the queue: 1
2025-08-05 01:40:02 [INFO]: item found in queue is if condition  14409
2025-08-05 01:40:02 [INFO]: item found in queue is  14409
2025-08-05 01:40:02 [INFO]: Message deleted from the queue for receipt handle: AQEBPSt4V/vLIn6GAD3I7pZt+Qbth148hkHKcuGqEUlRhpPGnJpYnY50Oo48l/NPtvlGJUoQQ51cneoD8ENam22kTx4FXQ0anUoxotcqKbUwlgSvHslD9hQDYyRlW8iYzs2JdwqqAXjMjiur6qDPiqf0b/ZI90UAwSq7MpXWZJ1+wmK2UhVd3DYGvdyENS39jYT8rjVxiwTQcq+bIYp+noYV7laZEY32hC5Wk3XNgAYgnuQYqDsrAnv4QPMSUYy6nfqIHH9nrEyYE4F5j1O4FnNghZpeBBpFncKrKVe04Cxcb1bhDIULx5FM0hBcXWDl8fplBVMXrNRWM6IRz/8UPMecaGc24Nw4dXHa17NpgNC+Pu/24SP0zAf/gI4I4qgapMcUyePB9BKFkMOjXAAzVxvqmktxas94vuOkS8EHuZ5CR4qZOBJ4soNcvsl2cgQan2HQ
2025-08-05 01:40:02 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 01:40:02 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 01:40:02 [INFO]: inside itemsold and closed 14409
2025-08-05 01:40:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 01:40:04 [INFO]: autolink for user_id 14409 is 1
2025-08-05 01:40:04 [INFO]: Ebay item id :: 326686368873 exists in Database
2025-08-05 01:40:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 01:40:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 01:40:04 [INFO]: in processold action queue is array    for {"45224428":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45224428","ebayitemid":"326686368873","deleted":1}}}
2025-08-05 01:40:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 01:40:04 [INFO]: productIds WHich are having null productid -> [45224428]
2025-08-05 01:40:04 [INFO]: ebayItemIds WHich are not imported-> ["326686368873"]
2025-08-05 01:40:04 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 01:40:04 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 01:40:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45224428)
2025-08-05 01:40:04 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 01:40:04 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 01:40:04 [INFO]: Transaction committed successfully.
2025-08-05 01:40:04 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 01:40:04 [INFO]: Successfully processed data for user 14409
2025-08-05 01:40:04 [INFO]: Execution Started
2025-08-05 01:40:04 [INFO]: Execution Finished
2025-08-05 01:50:02 [INFO]: Execution Started
2025-08-05 01:50:02 [INFO]: old server sucessfully connected
2025-08-05 01:50:02 [INFO]: sqs client sucess created
2025-08-05 01:50:03 [INFO]: Number of messages in the queue: 2
2025-08-05 01:50:03 [INFO]: item found in queue is if condition  14409
2025-08-05 01:50:03 [INFO]: item found in queue is  14409
2025-08-05 01:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7hXpsn8AkEjD0NKHcePGNVRPebhhOFyfl2ajVDMTycs8Zn743cwfe/Uuz2geWs+TlMusOeCv1/AWqLHgj4q+CQKtHtMzC9bl2RuJ12wfodOi/lLdOR4TgBcFt6k1iDCEtYsY6qMkEsbLqRrPji2ahHeg+E7oqiTK77/a83i/EEmW855JP95OfMyJjJa/4JrKg49KkLb6YS3j4pmPUwMfiUO42oKkB8hkXY1Og9y1BkNpXH4COzBB/KNrBTE7SwPAEW8zucW1dsqokoShOFVyXws6K3XFX4aNynzDcjI/mvAo4SGZmxQsRaSn7kXajl0s7UAcvjdiORr4PU82V4vgweqGwYeGKR1EJF3WrFEEYiVqyu/qRDDXWqF4w2126gZD7TBY4Gr75Ol2aI32vtnMibjjbLAkp0Ei4W6+mY0JOTdufDdVnKxk+oiFetF9H0fz
2025-08-05 01:50:04 [INFO]: item found in queue is if condition  14409
2025-08-05 01:50:04 [INFO]: item found in queue is  14409
2025-08-05 01:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBAhnNfzlYiOV5rK5IBh2XsbHfUai8zIixmVhjXgFyYyk3rjnnTfSKmFUo91ZsAqMricwclsUdhG5IP9g20kxNQnihQh0BOuIPAnz20cvp7prdF2k/BUtFJOqchNdCCeJ1TEKvzg/ECaqB/ZFLDSavgRouK91LgPrnT1URSZO4LOCtKW/XKRwQDEuAFHTRGGWfZYIE+SbyxnQNjx65KcOLHJYJouQQzY0adly3bABJermluWyOcplTGajUVz/QxuVObaEGPZ9x5Ncd2mt2gYwdB0cJmzZojTjDBRBSrSw1ShTGPQQ4dS4diqKl9IkCezp1iB1WGQpxi9pb5Qx6C7lIYfPfHt63nzJeTs0tTLfg3OjGF80pMyTpSPdgvx4/1oMmIAVArI+QXx0/Cejy5CUb79IS0suyHg8GPbgZSeGFQjAxQTdt/DmKyQh8qBw+IMod
2025-08-05 01:50:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-05 01:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 01:50:04 [INFO]: inside itemsold and closed 14409
2025-08-05 01:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 01:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 01:50:06 [INFO]: Ebay item id :: 225535716794 exists in Database
2025-08-05 01:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 01:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 01:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 01:50:06 [INFO]: inside itemsold and closed 14409
2025-08-05 01:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 01:50:07 [INFO]: autolink for user_id 14409 is 1
2025-08-05 01:50:07 [INFO]: Ebay item id :: 335751021910 exists in Database
2025-08-05 01:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 01:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 01:50:07 [INFO]: in processold action queue is array    for {"44656148":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656148","ebayitemid":"225535716794","shopifyproductid":"8021532082398","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8021532082398","shopifyvariantid":"44152650531038","shopifyinventoryid":"46249618309342","shopifylocationid":"","product_id":"44656148","variant_id":"77561337","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 01:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 01:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 01:50:07 [INFO]: Shopify Inventory id 46249618309342
2025-08-05 01:50:07 [INFO]: Shopify Location id 58450641063
2025-08-05 01:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 01:50: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-05 01:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 01:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656148 and user_id = 14409 
2025-08-05 01:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561337 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 01:50:08 [INFO]: updateIdsQuantity -> ["77561337"]
2025-08-05 01:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-05 01:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77561337 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77561337 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77561337)
2025-08-05 01:50:08 [INFO]: QUANTITY Updated IDs: 77561337
2025-08-05 01:50:08 [INFO]: Successfully processed data for user 14409
2025-08-05 01:50:08 [INFO]: Execution Started
2025-08-05 01:50:08 [INFO]: Execution Finished