2025-08-11 20:00:01 [INFO]: Execution Started 2025-08-11 20:00:01 [INFO]: old server sucessfully connected 2025-08-11 20:00:01 [INFO]: sqs client sucess created 2025-08-11 20:00:03 [INFO]: Number of messages in the queue: 0 2025-08-11 20:00:23 [INFO]: Execution Started 2025-08-11 20:00:23 [INFO]: Execution Finished 2025-08-11 20:10:01 [INFO]: Execution Started 2025-08-11 20:10:01 [INFO]: old server sucessfully connected 2025-08-11 20:10:01 [INFO]: sqs client sucess created 2025-08-11 20:10:02 [INFO]: Number of messages in the queue: 0 2025-08-11 20:10:22 [INFO]: Execution Started 2025-08-11 20:10:22 [INFO]: Execution Finished 2025-08-11 20:20:01 [INFO]: Execution Started 2025-08-11 20:20:01 [INFO]: old server sucessfully connected 2025-08-11 20:20:01 [INFO]: sqs client sucess created 2025-08-11 20:20:02 [INFO]: Number of messages in the queue: 1 2025-08-11 20:20:02 [INFO]: item found in queue is if condition 14409 2025-08-11 20:20:02 [INFO]: item found in queue is 14409 2025-08-11 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBFCoKqm5eQT6+mtdv+ILbkcgQXi4X+6AvTyfEPe5ob6c+nzbcsKntFcKlXnqmDtT1Kf0UBq4ynZE7PbXz827atdwqYI6qNge7ZAs5GFegdDAcCBck7pgyworeuqxdE4NCnXIKCmjhvXvPJSc1fwBGKAlvBGFdPi3Duk917/J+PytgHl6p2AyAHFqhaBfQ4Bub02koCCm07z1Ec/1duLq1/2wawpcv4JrS0QvhB6IAV8ewp4kR80CtD9XM0VnjXD95oHX3v8yCTFObZ6KBWYH19FFJF/C5tLcTeOelKTEDDhXbgZ/L0LqrOmHdRDYRC/S6LgW8TNV1ChNv3GC7eX5x+mpgSVN8D92LVgsIZrYN0OerffzCRTNwg3ZJl26Ng5OjXzen0MmqsGuGg7xnGDYEPtLUow1C8RGuuL3GFxaGb7y00SLLp/S42du7UYsSqJ8R 2025-08-11 20:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 20:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 20:20:03 [INFO]: inside itemsold and closed 14409 2025-08-11 20:20:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:20:04 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:20:04 [INFO]: Ebay item id :: 335356795650 exists in Database 2025-08-11 20:20:04 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:20:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 20:20:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 20:20:04 [INFO]: in processold action queue is array for {"44582308":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582308","ebayitemid":"335356795650","shopifyproductid":"8423529185502","variants":[{"price":"49.99","quantity":0,"weight":"1","shopifyproductid":"8423529185502","shopifyvariantid":"45228237193438","shopifyinventoryid":"47326148722910","shopifylocationid":"","product_id":"44582308","variant_id":"77475017","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 20:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 20:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 20:20:05 [INFO]: Shopify Inventory id 47326148722910 2025-08-11 20:20:05 [INFO]: Shopify Location id 58450641063 2025-08-11 20:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 20:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T20:20:05Z","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-11 20:20:05 [INFO]: Change: available | Delta: -1 2025-08-11 20:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-11 20:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 20:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582308 and user_id = 14409 2025-08-11 20:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475017 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 20:20:05 [INFO]: updateIdsQuantity -> ["77475017"] 2025-08-11 20:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 20:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475017 THEN 0 END, quantityflag = CASE WHEN id = 77475017 THEN 0 END WHERE user_id = 14409 AND id IN (77475017) 2025-08-11 20:20:05 [INFO]: QUANTITY Updated IDs: 77475017 2025-08-11 20:20:05 [INFO]: Successfully processed data for user 14409 2025-08-11 20:20:05 [INFO]: Execution Started 2025-08-11 20:20:05 [INFO]: Execution Finished 2025-08-11 20:30:01 [INFO]: Execution Started 2025-08-11 20:30:01 [INFO]: old server sucessfully connected 2025-08-11 20:30:01 [INFO]: sqs client sucess created 2025-08-11 20:30:02 [INFO]: Number of messages in the queue: 3 2025-08-11 20:30:02 [INFO]: item found in queue is if condition 14409 2025-08-11 20:30:02 [INFO]: item found in queue is 14409 2025-08-11 20:30:02 [INFO]: Message deleted from the queue for receipt handle: AQEBYJEBUpPrBZAmpvgTpE+qKO67DDjvGw3s0g1Wvhq3b8TyRkmB9LIrNS5XYPsFJ4kJRPw5wVtoNq7va1ccNOnaMkSavbNFD5sHzTRY/XYIO+5OewRRhWXXAn0Iu2qpN5h2Rhx1wHCBOdHvHfxZmkQVtADHzsGfnMN0ABfn0lghpU02SeuqdCfNyAZciIatKEFSdRiVpf3p5cs8GEgdrD4CIp2Jb+M22UFq+AESy8RwLS28macuftwhA52cHBpPUye5/Pc9grgPRD5//WBtVLkWm+gKCStGfm8YzE6YH8xhwpYARtlOlHCxBEuoMFBMnGZaONmctBF9OaTzqQv69pdxXI/NUfjMWmZkK7tkCmiYOB2b6svYJ2MOY95cfW3BvWYX+OnCzvexCIFvA/CNw8DSfeDsehf1E5c8tYQc5DVsq9YqauI8l7v6v4fbBLAQHZRZ 2025-08-11 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 20:30:03 [INFO]: item found in queue is 14409 2025-08-11 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB5CV8wYOhdezXdLGT1pg4hT2/E22SJOdot2XalZxPUIr/npWavHBfEahTDZ9X2/WNjkZ2WBK7DLHwtoJX4CIJ6C7FtFx3Q06fvynhmmhIaQH0El7Sj306cAHq2rviTebzsDY9QfouJVvc9WceJV20LlhK0UPpqaMsXwlbeo6AfxnhvjfhdSbUqYcZHrmOzPcqYJrbaGGfAI7oDVzinsnzDzDZe/Hkox7QDp6fK3fvq2xpsiAxtG+ZmH94ZkPMFFw7h/bk/UXyoR6wrMTLhQj0GPHjMIMshLcZ2qAjcP2unKk3Xm9y3HyliCbCMyn4qEMLp7snVWZleAECP9oCMjNHjZWRskUPDFpRVCmgX7IrXppmTWYgGIkHVM8CDgz7YPI2O+NG0NU99v5QPlrQRR4fULGqrxPbp5fdlu6L0piTJI+KmpDraZGz7dtqesmBQBbl 2025-08-11 20:30:03 [INFO]: item found in queue is if condition 14409 2025-08-11 20:30:03 [INFO]: item found in queue is 14409 2025-08-11 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLqrBShNi8WfwdhPIQ/OUN9fWGNNhwRMNDveH/KiukJQBJleLhvQ2MfcHe7KgLiKrNJjLDnJIMZL32iYdStecYwZrcUNRbLR9YYEnxKbIQTFz/AGeL44uibcvnygWX4Kb+q/ljnJLAd+TEVtgtwf8jANEEZqdro31BH7lhgwi29pwSIhDfs2xgQzE+8clCswd/9P2uBuq8yKFjPGcr9Odc3lFytxzpCAEmuZLHNKBPLkQ2pxwnqsYaXeFqlIoHLZX3x9vA759vitCanPauxX8cwPVdJd4fldeHgVMSMNYmtKGhD64ao7E1AbNB466b4BELiRBvpYtc7FiP7YMOLfBReKdeO/1AXw0CwolWfxpq+kCoYrMZ0zCu3PDXdWGOyMq1zseV0kTgoru60TWMhMsiQ4Np9GKJfhfGAiS0Jmg43rRCIAjTuDc22chcKkYTlBs 2025-08-11 20:30:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 20:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 20:30:03 [INFO]: inside itemsold and closed 14409 2025-08-11 20:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:30:05 [INFO]: Ebay item id :: 335600745877 exists in Database 2025-08-11 20:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 20:30:05 [INFO]: inside itemsold and closed 14409 2025-08-11 20:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:30:07 [INFO]: Ebay item id :: 226804236364 exists in Database 2025-08-11 20:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:30:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 20:30:07 [INFO]: inside itemsold and closed 14409 2025-08-11 20:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:30:09 [INFO]: Ebay item id :: 286676649228 exists in Database 2025-08-11 20:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:30:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 20:30:09 [INFO]: in processold action queue is array for {"44780592":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780592","ebayitemid":"335600745877","shopifyproductid":"8696084398302","variants":[{"price":"59.99","quantity":0,"weight":"3","shopifyproductid":"8696084398302","shopifyvariantid":"45936146055390","shopifyinventoryid":"48034595012830","shopifylocationid":"","product_id":"44780592","variant_id":"77689166","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45106284":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45106284","ebayitemid":"226804236364","deleted":1}},"45171668":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45171668","ebayitemid":"286676649228","deleted":1}}} 2025-08-11 20:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 20:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 20:30:09 [INFO]: productIds WHich are having null productid -> [45106284,45171668] 2025-08-11 20:30:09 [INFO]: ebayItemIds WHich are not imported-> ["226804236364","286676649228"] 2025-08-11 20:30:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 20:30:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 20:30:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45106284,45171668) 2025-08-11 20:30:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 20:30:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 20:30:09 [INFO]: Transaction committed successfully. 2025-08-11 20:30:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 20:30:09 [INFO]: Shopify Inventory id 48034595012830 2025-08-11 20:30:09 [INFO]: Shopify Location id 58450641063 2025-08-11 20:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 20:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T20:30:09Z","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-11 20:30:09 [INFO]: Change: available | Delta: -1 2025-08-11 20:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-11 20:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 20:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780592 and user_id = 14409 2025-08-11 20:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689166 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 20:30:09 [INFO]: updateIdsQuantity -> ["77689166"] 2025-08-11 20:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 20:30:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77689166 THEN 0 END, quantityflag = CASE WHEN id = 77689166 THEN 0 END WHERE user_id = 14409 AND id IN (77689166) 2025-08-11 20:30:09 [INFO]: QUANTITY Updated IDs: 77689166 2025-08-11 20:30:09 [INFO]: Successfully processed data for user 14409 2025-08-11 20:30:09 [INFO]: Execution Started 2025-08-11 20:30:09 [INFO]: Execution Finished 2025-08-11 20:40:01 [INFO]: Execution Started 2025-08-11 20:40:01 [INFO]: old server sucessfully connected 2025-08-11 20:40:01 [INFO]: sqs client sucess created 2025-08-11 20:40:02 [INFO]: Number of messages in the queue: 3 2025-08-11 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 20:40:03 [INFO]: item found in queue is 14409 2025-08-11 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB2PbEpv1tQDJxGdz/lneppFYT32tpIo9qfz4WDbVKdU9FpeupTotMv8Y/nmeUbHcq6x/knT6bhzaS34i4DAs7sIjP/gULsRz8qF3AQxQfc1IB0IyI0Lud9CqRd3oxpsPDv0cwuEXzG6vdvBzcDzvPpQXtD+D1jgwaEQ3xoVQfIdk6ih7mrjbPiItXeG5cTxKWNLJKWYYj3+V+p4DKwPNWw5DhJzwMLMkcYh0D9Hk37me1GmbpcrSSA60j2eY0KtQSbIQqusIhqsU+GNNtZc869kx7QvbEW5cnnVfygg45QmbrF553aSTpvZHvbC1/WvuRLG0BM3VvHN4G0WIyFxjlUCKJfTUVtRRLExAaaYNYJe8vw5hQzUcb4yDKS413OP939xVy9XLW5wqjIgho1yUV12a9zo5H0NX89mNJgrXjI3/Ph3duVqsl2f1vImQRZAN0 2025-08-11 20:40:03 [INFO]: item found in queue is if condition 14409 2025-08-11 20:40:03 [INFO]: item found in queue is 14409 2025-08-11 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBzbiqaWEPui+doRCZ+SOkFchoHJaLKsPRwEMIt7y3QPK72jVz8KoIcmajZ2cwl9ND1WFen5Xnag3f2q9upPPUY+T0l6EEjD9+XeO2SdsCgANi47zeTtvUEWc9lwm0DXi1rXo8acwQvPBUmjEWnQbZpv8sUltDsDmAkO14JLwxlhG8dhfuaBKIYQX8w/Yc7ubBKr57d1hfjTodFF6DFONKqX7AscVdFUzyFy/JPFPak3gHhEVPm+mHnw0Wqhqp+bIG/uTVpO8eM3cQG0YooPXv25HMswmHz8x2Iqo9odpRLyCiqhx4q3TAGGYs4Agz+lO7Pb3NeInVQ1uPOOJGYHQFX97w0lyk7zM+UU2r6AihMBwpTZPAiK5A45dJ9ji3cXqW7hU9dvIlkx2Lmo+4ifK3c9wJctUOZHCI1shJBZpuBjM/jUZ0yoBFfKXEq6wIihwj 2025-08-11 20:40:04 [INFO]: item found in queue is if condition 14409 2025-08-11 20:40:04 [INFO]: item found in queue is 14409 2025-08-11 20:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJT9T1Xc+kLMJrl13hm0xDVRbllblMPdSN2czxzMdGbWNFKaOLmsHq6L6RcFN24rQ99ltGhElPi1OcqXY2En9Qs82WcpZ7+EUxMuBzVcmTPbOqTI1ononzzrfEbFV8T3+cN/BYNGx39pmCETjusGBzWKWnzOIjrAXA4FOHPLmnNCmfBPdcfCVwdypfV+gHQqKMrW/kw6GIPE80Fe166aZvikM7teRxGydE59lKNxMHCCZStk+r4R5Cz7UJQNwKDzdoZVDkCemwEyj1/kpmXDZBJ9t8o0Qan38nxkbwjZ4jlage7urbtmFS1vmC/pBEkBf505ajhI3ftPHnvRxzkvzaAjsLN/Vezx6T03hjhfVuhs9NI6DiW0eHTWA0yG3fLxAPKwd6NbcYfeLo8vz9660A3IUgqe21ivasrXrBt7kncC/onkukQ6GwW8pxKbkUt1e 2025-08-11 20:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-11 20:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 20:40:04 [INFO]: inside itemsold and closed 14409 2025-08-11 20:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:40:06 [INFO]: Ebay item id :: 286585856930 exists in Database 2025-08-11 20:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 20:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 20:40:06 [INFO]: inside itemsold and closed 14409 2025-08-11 20:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:40:07 [INFO]: Ebay item id :: 326690208802 exists in Database 2025-08-11 20:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:40:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-11 20:40:07 [INFO]: inside itemsold and closed 14409 2025-08-11 20:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:40:09 [INFO]: Ebay item id :: 225774026666 exists in Database 2025-08-11 20:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 20:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 20:40:09 [INFO]: in processold action queue is array for {"44823035":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44823035","ebayitemid":"286585856930","shopifyproductid":"8926429675742","variants":[{"price":"10.99","quantity":0,"weight":"0.75","shopifyproductid":"8926429675742","shopifyvariantid":"46838174744798","shopifyinventoryid":"48936663843038","shopifylocationid":"58450641063","product_id":"44823035","variant_id":"77733627","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45240443":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45240443","ebayitemid":"326690208802","deleted":1}},"44648934":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44648934","ebayitemid":"225774026666","shopifyproductid":"8129426620638","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8129426620638","shopifyvariantid":"44348710125790","shopifyinventoryid":"46446471348446","shopifylocationid":"","product_id":"44648934","variant_id":"77554123","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 20:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 20:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 20:40:09 [INFO]: productIds WHich are having null productid -> [45240443] 2025-08-11 20:40:09 [INFO]: ebayItemIds WHich are not imported-> ["326690208802"] 2025-08-11 20:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-11 20:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-11 20:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45240443) 2025-08-11 20:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-11 20:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-11 20:40:09 [INFO]: Transaction committed successfully. 2025-08-11 20:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-11 20:40:09 [INFO]: Shopify Inventory id 48936663843038 2025-08-11 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-11 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 20:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T20:40:09Z","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-11 20:40:09 [INFO]: Change: available | Delta: -1 2025-08-11 20:40:09 [INFO]: Change: on_hand | Delta: -1 2025-08-11 20:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 20:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44823035 and user_id = 14409 2025-08-11 20:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77733627 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 20:40:09 [INFO]: Shopify Inventory id 46446471348446 2025-08-11 20:40:09 [INFO]: Shopify Location id 58450641063 2025-08-11 20:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 20:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-11T20:40:09Z","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-11 20:40:10 [INFO]: Change: available | Delta: -1 2025-08-11 20:40:10 [INFO]: Change: on_hand | Delta: -1 2025-08-11 20:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 20:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44648934 and user_id = 14409 2025-08-11 20:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554123 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 20:40:10 [INFO]: updateIdsQuantity -> ["77733627","77554123"] 2025-08-11 20:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-11 20:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77733627 THEN 0 WHEN id = 77554123 THEN 0 END, quantityflag = CASE WHEN id = 77733627 THEN 0 WHEN id = 77554123 THEN 0 END WHERE user_id = 14409 AND id IN (77733627,77554123) 2025-08-11 20:40:10 [INFO]: QUANTITY Updated IDs: 77733627, 77554123 2025-08-11 20:40:10 [INFO]: Successfully processed data for user 14409 2025-08-11 20:40:10 [INFO]: Execution Started 2025-08-11 20:40:10 [INFO]: Execution Finished 2025-08-11 20:50:01 [INFO]: Execution Started 2025-08-11 20:50:01 [INFO]: old server sucessfully connected 2025-08-11 20:50:01 [INFO]: sqs client sucess created 2025-08-11 20:50:02 [INFO]: Number of messages in the queue: 1 2025-08-11 20:50:03 [INFO]: item found in queue is if condition 14409 2025-08-11 20:50:03 [INFO]: item found in queue is 14409 2025-08-11 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPkF/mdTuhJzN1lJdmOQxOlugK7h8Qs6hspMwV8OtLMMuQZT+CbIN+bzbiejPhFdBOSaaxrxnm9dDuAvYCoTuZ3AXV2f1Z3kpkfvnZ3rknH1uRBbZhGK9aVXY511vkN77O/OIT9NW+60KS8vWhVMjbeT0LZdI3BUpmd5fALHppDtoT/dsKTd5sHv/CHK1jHp5wgzs2LwYHo1qHTRrZ6K8JTa1v/EOzddTGfsK6oOtqkDb2wtMD2EvfYEOnB0BcNbCUQ78tQ9xzTnNmaXVLFT2wlX1vNmEtBkpxsDUJAQe5MMI/dAoe3Dyl8Uy92mfi489Ak0oJUsGklWCaClXyTbD4Xs9WLUj8wLMVK3/FqJM038gJyzIgVqzrtx1WGwPbp41my4ptDjnW8K0DtA03qiAs309Sok26Eo9jxn15RdQi2t2kBmDRYnKbYjj/ksGTP+q 2025-08-11 20:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-11 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-11 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-11 20:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-11 20:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-11 20:50:05 [INFO]: Ebay item id :: 335974179030 exists in Database 2025-08-11 20:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-11 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-11 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-11 20:50:05 [INFO]: in processold action queue is array for {"44836458":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44836458","ebayitemid":"335974179030","shopifyproductid":"8927144083678","variants":[{"price":"14.99","quantity":0,"weight":"0.75","shopifyproductid":"8927144083678","shopifyvariantid":"46845872177374","shopifyinventoryid":"48956046803166","shopifylocationid":"58450641063","product_id":"44836458","variant_id":"77747392","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-11 20:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-11 20:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-11 20:50:05 [INFO]: Shopify Inventory id 48956046803166 2025-08-11 20:50:05 [INFO]: Shopify Location id 58450641063 2025-08-11 20:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-11 20:50: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-11 20:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-11 20:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44836458 and user_id = 14409 2025-08-11 20:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77747392 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-11 20:50:05 [INFO]: updateIdsQuantity -> ["77747392"] 2025-08-11 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-11 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77747392 THEN 0 END, quantityflag = CASE WHEN id = 77747392 THEN 0 END WHERE user_id = 14409 AND id IN (77747392) 2025-08-11 20:50:05 [INFO]: QUANTITY Updated IDs: 77747392 2025-08-11 20:50:05 [INFO]: Successfully processed data for user 14409 2025-08-11 20:50:05 [INFO]: Execution Started 2025-08-11 20:50:05 [INFO]: Execution Finished