2025-08-15 03:00:02 [INFO]: Execution Started 2025-08-15 03:00:02 [INFO]: old server sucessfully connected 2025-08-15 03:00:02 [INFO]: sqs client sucess created 2025-08-15 03:00:03 [INFO]: Number of messages in the queue: 0 2025-08-15 03:00:23 [INFO]: Execution Started 2025-08-15 03:00:23 [INFO]: Execution Finished 2025-08-15 03:10:01 [INFO]: Execution Started 2025-08-15 03:10:01 [INFO]: old server sucessfully connected 2025-08-15 03:10:01 [INFO]: sqs client sucess created 2025-08-15 03:10:02 [INFO]: Number of messages in the queue: 2 2025-08-15 03:10:03 [INFO]: item found in queue is if condition 14409 2025-08-15 03:10:03 [INFO]: item found in queue is 14409 2025-08-15 03:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFnIrK8da+dyVs3f4Zf+l++zDxtg2+nEpw3vbB55uldbmZcrbqsOQV2QE0tIsMNjlJ0y9DBF/T0/lshZ0v45yv6TiYb9E4mXVpijxo8M4PGEh04M7POuyZknrGp1O30eETDg4LmBIounp/p96LQXeZvlXrlkkES3ZCzCsgnD2GsiMMHwMw6wii66pER5p9hqbnLjApey9l3D93916kAaWstuWj1vqFYPuK2SazlqU69tcue2vNPfHpzS3S7MUTvoqchlnBPVaRVtOU+XF4dp1pQCrqf8qb9eew+oYbawehgjIwj5FGu6sqrAOcENIkWrl2mdKJYo2VLbylBc8PX3mXaAiUSZfHzP6UaAdpk9ZlsKV6DgFKNfI723XM4tw+jEaRTnO0CygYxRxHEP/KTa9LRdsv2bTLRnVFc8eOvd7SPLO+qZxQNz3Bn+tEBOk7+xr 2025-08-15 03:10:03 [INFO]: item found in queue is if condition 14409 2025-08-15 03:10:03 [INFO]: item found in queue is 14409 2025-08-15 03:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBAXHyZjJzwU3Rx16e8iZ77ICleG0C/zQ5fvFSJjofrnrhJQJIV0yWEXBYdlTXdk35tVsu1ThMauSHV2ZwKPi0nBH6BxtV2MpuZOSmaRqI8+wafrVdOaVVrBKYUb43X8ef6bTxRG+jkEj8WrI4uH6Pep/UjprgpY1pEjlzZVlE7hQrNfkwODC+AXmnFyhSSaxh0nH+cE4wpO9/aWU49OREsdJ4L/jI8vpIB1wBWBhYDNnRPdIDCO5VLacKvQtScG1+R/eeaGo6flDzzSs1c32CPsbmjz9BQALt/xY7zu8eu1UBBgM0q8CpjKAFAUHfoSnKEZXN4axZHD63BY5Zx4SIErzQpskJJf5TsLE3DkNnHj8J+/zHzVv/JqqKb8CBvNR1OZUDBVq2Hzu0UuPFiR6ujcrQtbaO7FNJFju3ZA18+06b/OwfqcFjeHssuEISdmQS 2025-08-15 03:10:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-15 03:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-15 03:10:03 [INFO]: inside itemsold and closed 14409 2025-08-15 03:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-15 03:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-15 03:10:05 [INFO]: Ebay item id :: 336032181080 exists in Database 2025-08-15 03:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-15 03:10:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-15 03:10:05 [INFO]: inside itemsold and closed 14409 2025-08-15 03:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-15 03:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-15 03:10:07 [INFO]: Ebay item id :: 335429890148 exists in Database 2025-08-15 03:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-15 03:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-15 03:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-15 03:10:07 [INFO]: in processold action queue is array for {"45157725":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45157725","ebayitemid":"336032181080","deleted":1}},"44561611":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44561611","ebayitemid":"335429890148","shopifyproductid":"8707725295838","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8707725295838","shopifyvariantid":"45965117391070","shopifyinventoryid":"48063854575838","shopifylocationid":"","product_id":"44561611","variant_id":"77454291","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-15 03:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-15 03:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-15 03:10:07 [INFO]: productIds WHich are having null productid -> [45157725] 2025-08-15 03:10:07 [INFO]: ebayItemIds WHich are not imported-> ["336032181080"] 2025-08-15 03:10:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-15 03:10:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-15 03:10:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45157725) 2025-08-15 03:10:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-15 03:10:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-15 03:10:07 [INFO]: Transaction committed successfully. 2025-08-15 03:10:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-15 03:10:07 [INFO]: Shopify Inventory id 48063854575838 2025-08-15 03:10:07 [INFO]: Shopify Location id 58450641063 2025-08-15 03:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-15 03:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1988,"restoreRate":100}}}} 2025-08-15 03:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-15 03:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44561611 and user_id = 14409 2025-08-15 03:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77454291 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-15 03:10:07 [INFO]: updateIdsQuantity -> ["77454291"] 2025-08-15 03:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0 2025-08-15 03:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77454291 THEN 0 END, quantityflag = CASE WHEN id = 77454291 THEN 0 END WHERE user_id = 14409 AND id IN (77454291) 2025-08-15 03:10:07 [INFO]: QUANTITY Updated IDs: 2025-08-15 03:10:07 [INFO]: Successfully processed data for user 14409 2025-08-15 03:10:07 [INFO]: Execution Started 2025-08-15 03:10:07 [INFO]: Execution Finished 2025-08-15 03:20:01 [INFO]: Execution Started 2025-08-15 03:20:01 [INFO]: old server sucessfully connected 2025-08-15 03:20:01 [INFO]: sqs client sucess created 2025-08-15 03:20:02 [INFO]: Number of messages in the queue: 0 2025-08-15 03:20:23 [INFO]: Execution Started 2025-08-15 03:20:23 [INFO]: Execution Finished 2025-08-15 03:30:02 [INFO]: Execution Started 2025-08-15 03:30:02 [INFO]: old server sucessfully connected 2025-08-15 03:30:02 [INFO]: sqs client sucess created 2025-08-15 03:30:03 [INFO]: Number of messages in the queue: 0 2025-08-15 03:30:20 [INFO]: item found in queue is if condition 14409 2025-08-15 03:30:20 [INFO]: item found in queue is 14409 2025-08-15 03:30:20 [INFO]: Message deleted from the queue for receipt handle: AQEBvA4iseBMZE1aCwPeDf5J1uHKeWwAvuZvsnikPupggKt47EJPoD8FJiDxZoeNpyklJgtOBk5snh2u3zHGL4ZYCAkqj73MNh3Ss+De2h61Tl3mlsYh4FGRE4fPPIGZzg31aB47sxPVoIjfoFk9L3Fr9QOb1Pgn3sKVe5dQdhKNjC15sZrITp7u2Dpu8aOrqCa4McDDw+0iWMzIeM2ccdXLaWOf6vtzcJ107UIzoyJeIsEphiel83cAAWHRUeomTYuDZFFpPRJeBq5R/qfiQ0K/pXuoYbRjSVRsSa3okrrpyR4QRyMN7khdyJUvnvhJzxPZWHO/8qDMIlRoW49g2IFdevY8fJUYtQz0huckCjLtNPJfX/1t5pFYvhI8Jl97Kj7LTiOJ1SFJwAzE269DjcUexpas/3TUkiREpVBROeeh510C0haCWYQHTQrRwk0s0+7F 2025-08-15 03:30:20 [INFO]: Processed 1 messages, reached the limit of 0. 2025-08-15 03:30:20 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-15 03:30:20 [INFO]: inside itemsold and closed 14409 2025-08-15 03:30:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-15 03:30:22 [INFO]: autolink for user_id 14409 is 1 2025-08-15 03:30:22 [INFO]: Ebay item id :: 286519821988 exists in Database 2025-08-15 03:30:22 [INFO]: Item is reliested :: exists in Database 2025-08-15 03:30:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-15 03:30:22 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-15 03:30:22 [INFO]: in processold action queue is array for {"44678985":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678985","ebayitemid":"286519821988","shopifyproductid":"8156886073566","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8156886073566","shopifyvariantid":"44416421855454","shopifyinventoryid":"46514176196830","shopifylocationid":"","product_id":"44678985","variant_id":"77584205","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-15 03:30:22 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-15 03:30:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-15 03:30:22 [INFO]: Shopify Inventory id 46514176196830 2025-08-15 03:30:22 [INFO]: Shopify Location id 58450641063 2025-08-15 03:30:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-15 03:30:23 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-15T03:30:22Z","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-15 03:30:23 [INFO]: Change: available | Delta: 1 2025-08-15 03:30:23 [INFO]: Change: on_hand | Delta: 1 2025-08-15 03:30:23 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-15 03:30:23 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678985 and user_id = 14409 2025-08-15 03:30:23 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77584205 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-15 03:30:23 [INFO]: updateIdsQuantity -> ["77584205"] 2025-08-15 03:30:23 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-15 03:30:23 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77584205 THEN 0 END, quantityflag = CASE WHEN id = 77584205 THEN 0 END WHERE user_id = 14409 AND id IN (77584205) 2025-08-15 03:30:23 [INFO]: QUANTITY Updated IDs: 77584205 2025-08-15 03:30:23 [INFO]: Successfully processed data for user 14409 2025-08-15 03:30:23 [INFO]: Execution Started 2025-08-15 03:30:23 [INFO]: Execution Finished 2025-08-15 03:40:01 [INFO]: Execution Started 2025-08-15 03:40:01 [INFO]: old server sucessfully connected 2025-08-15 03:40:01 [INFO]: sqs client sucess created 2025-08-15 03:40:02 [INFO]: Number of messages in the queue: 1 2025-08-15 03:40:03 [INFO]: item found in queue is if condition 14409 2025-08-15 03:40:03 [INFO]: item found in queue is 14409 2025-08-15 03:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSW++zhXesyHPSYEyY0PjK4G6GzrYHKgtBRfATNOmCnnF3xVcmoPDOcpN2LKkmsqilLG+RdsZBjGz4YypR5A3Yu6c8YPkd7abZkE1Ui+UMfZECSLWPG6VF5PSDT5tk1q4otFpp2VW6xxMKWT3+Ix9YaROCUF7rFvUnlcIjJda/+8q/VAPyV9+lhDF8WT1N6prDZyXJDE/KDbju1cnwlCGTwuZkanI8C05Vjkazdo25Hxeb0ccXXT7gBUHtDF2Xsbyn15/E9YMUG/eiIQwcYgN5qC8wHVfrjh6zG386PdVjRh9+JKT7g/K/9GR2i1S3XxgxBgOMHVV7kh3Syz3GWF6gQ9cKd0iiCgtqv3ruBDRStDheh/JMpP1is6iLa0Gx6Q6utiyvEtjhtmgHae+wNRuZUpAO7yZMI5dFgzSkRjYpag6l0vzdbFeRQKyyJX9T4X7 2025-08-15 03:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-15 03:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-15 03:40:03 [INFO]: inside itemsold and closed 14409 2025-08-15 03:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-15 03:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-15 03:40:05 [INFO]: Ebay item id :: 286564868194 exists in Database 2025-08-15 03:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-15 03:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-15 03:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-15 03:40:05 [INFO]: in processold action queue is array for {"44780998":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780998","ebayitemid":"286564868194","shopifyproductid":"8917821718750","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8917821718750","shopifyvariantid":"46726825246942","shopifyinventoryid":"48825313853662","shopifylocationid":"58450641063","product_id":"44780998","variant_id":"77689572","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-15 03:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-15 03:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-15 03:40:05 [INFO]: Shopify Inventory id 48825313853662 2025-08-15 03:40:05 [INFO]: Shopify Location id 58450641063 2025-08-15 03:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-15 03:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-15T03:40:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1986,"restoreRate":100}}}} 2025-08-15 03:40:05 [INFO]: Change: available | Delta: -1 2025-08-15 03:40:05 [INFO]: Change: on_hand | Delta: -1 2025-08-15 03:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-15 03:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780998 and user_id = 14409 2025-08-15 03:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689572 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-15 03:40:05 [INFO]: updateIdsQuantity -> ["77689572"] 2025-08-15 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-15 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77689572 THEN 0 END, quantityflag = CASE WHEN id = 77689572 THEN 0 END WHERE user_id = 14409 AND id IN (77689572) 2025-08-15 03:40:05 [INFO]: QUANTITY Updated IDs: 77689572 2025-08-15 03:40:05 [INFO]: Successfully processed data for user 14409 2025-08-15 03:40:05 [INFO]: Execution Started 2025-08-15 03:40:05 [INFO]: Execution Finished 2025-08-15 03:50:01 [INFO]: Execution Started 2025-08-15 03:50:01 [INFO]: old server sucessfully connected 2025-08-15 03:50:02 [INFO]: sqs client sucess created 2025-08-15 03:50:03 [INFO]: Number of messages in the queue: 0 2025-08-15 03:50:23 [INFO]: Execution Started 2025-08-15 03:50:23 [INFO]: Execution Finished