2025-08-08 07:00:01 [INFO]: Execution Started 2025-08-08 07:00:01 [INFO]: old server sucessfully connected 2025-08-08 07:00:01 [INFO]: sqs client sucess created 2025-08-08 07:00:03 [INFO]: Number of messages in the queue: 0 2025-08-08 07:00:23 [INFO]: Execution Started 2025-08-08 07:00:23 [INFO]: Execution Finished 2025-08-08 07:10:01 [INFO]: Execution Started 2025-08-08 07:10:01 [INFO]: old server sucessfully connected 2025-08-08 07:10:01 [INFO]: sqs client sucess created 2025-08-08 07:10:02 [INFO]: Number of messages in the queue: 3 2025-08-08 07:10:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:10:03 [INFO]: item found in queue is 14409 2025-08-08 07:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBIbpXakgyQ+zdLdVwbQR+u6hPXLlpH2jn59DlWi0vbGEP+FTp1yCA1Q6Kcusy0lgOBixVypaOAiwBt2gorO6KOPR4FGUPxBMKNzDD599lj/nswW4t4I4c2VNXdJbvJ4sdQFXGGWRaeZA0eV5HzQiUWRDLZH1B4ODp5glHoi/xkbWm4y0s3GlKOsLCgXacanY7rBrO+CIb6yO6iPR+RPrNRCMMiIzHj0ceV8ISYn+OPEvs+4WfGMwCfLO9zrBgDG1zcVkboJEpTLf5jKoklg2udo6DP3V2Va61EYEzcreTyoqDrkFpk3fDshEu/XvRsKCdXdVHwoTYpigEu4Bkuln1krrlhuBs/mTTDjg/Bk7cya2Ld/PdCus6DH4+paGuYzaP3SzZwKsD7N/ZHZJm8G9pdssbFfTinZKJXej7Flczr4k+AoBIol+NXjmzwiCIUnSv 2025-08-08 07:10:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:10:03 [INFO]: item found in queue is 14409 2025-08-08 07:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNROHkelqx3tWsd5YG5k/3VdHJFV+QWSilWUNjot2+P6p22dau/qB6a5ToDg1AKVppQIcvON1tUWSmxuOM5el/VSXSSpe5ANnh+cObDxrtUkBYa9P4loDJEjs5gUZHo2Hb/g3F8dAgca9DjIYNFtJgjvLHwgmV6dE5luX7dg9VvU0mApxygR4nHekeXHdh0N/P2g1Zu177euTCm8dyI/Sbf7qQQRtD+zP58xq8H5b6WyVCLK4SXU0URibOPpoCkSFD7gKveNw3hAZKIBEYuWE8+fOphp1QBGkednW5gCz3IfpWLcB0mh5tSqperkqQowl6kkgWt4Vo1SxlJW2r8Pf2P8aJ9s2qvgDz+TyHpybm4cROSpo3lrdHGW2mVDdAsHtnategOAKVaLjIutB3mLOnErUquF4Y4AkBVsveoj++5P2eW8tvs17W1ykbM8Ya2cl 2025-08-08 07:10:04 [INFO]: item found in queue is if condition 14409 2025-08-08 07:10:04 [INFO]: item found in queue is 14409 2025-08-08 07:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBrFHG4RZ0PC8c/tRrVv64lKy1gsdOQy+IZtUITfhm98fcF8+hirADajfeu/ANBsr4OdQ3t/o5gPeznRJMNF5SttDXtnMFMAVTkIxJCT30tbLRXdZv1v4S+zT+r28LFzTxxLr8WjEG63dLN/yzSWSeRdmXNiCUzlxXiBm08wiH0FL+cbq1yLRY44WO4IBpEzsi7cZjt8VgrINb5uxu/NPXkcZzc9RsPr1skuIYlv5DlU6bcOWB7KmwsnFMnPLKRRiO78R4L+V4yeQAGV0lUFzhEB7MAUgHOIGCocbNG9vSLvsDe4CXy4u7vuf9G3ChExIIGAUTwcPnaaAstFjfbujBJkGlIK8+PXxLOw1L9Wn8QAv+yvadJbf+cipXMp0ZKmdNLY95U89U2sm0s7EvoFGdVb14G9nFNh/gniV0v4hQI4N+FOkv9siNOX84Bl93ecDr 2025-08-08 07:10:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 07:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 07:10:04 [INFO]: inside itemsold and closed 14409 2025-08-08 07:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:10:06 [INFO]: Ebay item id :: 257054841331 exists in Database 2025-08-08 07:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:10:06 [INFO]: inside itemsold and closed 14409 2025-08-08 07:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:10:07 [INFO]: Ebay item id :: 285465540014 exists in Database 2025-08-08 07:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:10:07 [INFO]: inside itemsold and closed 14409 2025-08-08 07:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:10:09 [INFO]: Ebay item id :: 335232845777 exists in Database 2025-08-08 07:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:10:09 [INFO]: in processold action queue is array for {"44780402":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780402","ebayitemid":"285465540014","shopifyproductid":"8124848341214","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8124848341214","shopifyvariantid":"44340130283742","shopifyinventoryid":"46437831475422","shopifylocationid":"","product_id":"44780402","variant_id":"77688976","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 07:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 07:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:10:09 [INFO]: Shopify Inventory id 46437831475422 2025-08-08 07:10:09 [INFO]: Shopify Location id 58450641063 2025-08-08 07:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:10:09 [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 07:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780402 and user_id = 14409 2025-08-08 07:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77688976 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:10:09 [INFO]: updateIdsQuantity -> ["77688976"] 2025-08-08 07:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0 2025-08-08 07:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77688976 THEN 0 END, quantityflag = CASE WHEN id = 77688976 THEN 0 END WHERE user_id = 14409 AND id IN (77688976) 2025-08-08 07:10:09 [INFO]: QUANTITY Updated IDs: 2025-08-08 07:10:09 [INFO]: Successfully processed data for user 14409 2025-08-08 07:10:09 [INFO]: Execution Started 2025-08-08 07:10:09 [INFO]: Execution Finished 2025-08-08 07:20:01 [INFO]: Execution Started 2025-08-08 07:20:01 [INFO]: old server sucessfully connected 2025-08-08 07:20:01 [INFO]: sqs client sucess created 2025-08-08 07:20:02 [INFO]: Number of messages in the queue: 1 2025-08-08 07:20:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:20:03 [INFO]: item found in queue is 14409 2025-08-08 07:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmu5DHl7ZwyytBNEpbpOYsZ2mVavXsdtMMe290INIsdFuc8GCZd776wuWRBfr8TaMa0CHVunoZkaoJ9Ouz7gAlQBApsMVByYQFfepJN3I4D+h6W6elOeaRoYK4dspNOtlNO+E3n6Xabj78tJzc28rrHe+zarc64Hn1xnezz84h+/5DipDLjW4ByiRshIlEetXhYoBVjJiuYWbrsry6RmwIua32VACedWVHEz4V4XzZOgaZ+fes7M0EpeMbhkDJ2fQYEgpfnUhjI/K5ZDZoLPxzkdIWpX42Lf4//dCXgPlULC1RjqGiyINyVyJyp7avba4fzo2/KDGD/XMHo5w83dEPQBCMWdtOnRItaPP94dnDZYIs8JtDVawTR/V+6KE2vN3XpOoIY8gpzJuycR4UxUXYTiuIR5MyVCStGPMFyYXZs4oM+3XXXqalqp6AhKphYZk 2025-08-08 07:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 07:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 07:20:03 [INFO]: inside itemsold and closed 14409 2025-08-08 07:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:20:05 [INFO]: Ebay item id :: 325933508013 exists in Database 2025-08-08 07:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:20:05 [INFO]: in processold action queue is array for {"44657150":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44657150","ebayitemid":"325933508013","shopifyproductid":"8240482451678","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8240482451678","shopifyvariantid":"44617662300382","shopifyinventoryid":"46715643134174","shopifylocationid":"","product_id":"44657150","variant_id":"77562370","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 07:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 07:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:20:05 [INFO]: Shopify Inventory id 46715643134174 2025-08-08 07:20:05 [INFO]: Shopify Location id 58450641063 2025-08-08 07:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07: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-08 07:20:05 [INFO]: Change: available | Delta: -1 2025-08-08 07:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-08 07:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44657150 and user_id = 14409 2025-08-08 07:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77562370 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:20:05 [INFO]: updateIdsQuantity -> ["77562370"] 2025-08-08 07:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 07:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77562370 THEN 0 END, quantityflag = CASE WHEN id = 77562370 THEN 0 END WHERE user_id = 14409 AND id IN (77562370) 2025-08-08 07:20:05 [INFO]: QUANTITY Updated IDs: 77562370 2025-08-08 07:20:05 [INFO]: Successfully processed data for user 14409 2025-08-08 07:20:05 [INFO]: Execution Started 2025-08-08 07:20:05 [INFO]: Execution Finished 2025-08-08 07:30:01 [INFO]: Execution Started 2025-08-08 07:30:01 [INFO]: old server sucessfully connected 2025-08-08 07:30:01 [INFO]: sqs client sucess created 2025-08-08 07:30:02 [INFO]: Number of messages in the queue: 3 2025-08-08 07:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:30:03 [INFO]: item found in queue is 14409 2025-08-08 07:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPeWBHhyqh/LQct28GCvAGm5/QuJctNx6Z6aEEv4acUMS7y+1lpJczRb1hoqSyXyOdn01YQ9riBcbgUxeOjqPk/BTZMjhhnIqqSbNfocM0Vvk2RhJUT402q743Bll2nVCt/Zfc+sfq3kMaC8p5TccRb8iYw6LXcB/KjtFutG7bvSCCsNBFf0gPcLaVgNWF5pAIXyCmRxH8bu1iRXP5hS5dbAMyUK4k9Skp5l7HXBYwb6Zf5rMTlsRTsOnLBJvbou6IbMUuCjCDwnvbuHeZnBdUWFO8eg8TFyR5Fx/BnzoPwphy9GMCN8iZsObpa8gHXMcMS8YHaT7Qf5u+sle5te2x7oLg5KG+S8cLc+ILZdvxXhpjRusE0hK/KbJneuK4dAESjFqxa2l2w5gaJWwEqAvkomiVVml2ukw3lNZsSON0NzJ+xxljIbxe6SnUze7uQYl 2025-08-08 07:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:30:03 [INFO]: item found in queue is 14409 2025-08-08 07:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBihPZ3vX8XWYG2ePp9ONlFxRId0SWk4Rjc2GrUJn8GU/ZBskmSMocpafeO9HwwNOJMx53y87GWpahvqdWburXILPB4bJJR9rlycutoNddRCxaLxYb/g98USFJg2CfjEznZuk25MWKYxzxAgAPcZlQPPsclDj7mj9ghGca9setejQWuPsgqtHCcNsCSND1TonBiPKaNIKfUtv6lXLY3O6cWtOd2bJ3FptEh0Ws3PDqjRt2veiP1DdSq1B0s4bvI9+r3xKUZMrzkGYietUTKdpSdG8leBJ6HwLF5e8uIKbPaZG1yOCrzuY/ubEAio192TYC94oNxt4o1ro04ceJquvoJSxNuCRaVIRw004zdaOjyEpwKOlJMmOx87H52x2fN0jZkXjyzbMT6NS1yjCNTQh8hKlPyO+m9cEJEVIC6dpRSXQ/rlkCqTf4PZF1GtR9GxTw 2025-08-08 07:30:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:30:03 [INFO]: item found in queue is 14409 2025-08-08 07:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPr87JnqyboW3lhL3wIfeEpiqQcpiSfNzPP7DM6JLHOuUcot5bGC1CmOtQCZVgybvEaeFvt7jEao+eWnlKBr/BqGtziesbepzjFAaTkBQCIt62/PVDhb1wXI61pRzFd7hsvWfNAjeUWcUYUB+9G5LJ+8NPDVe2WE/xXLHwCvga43vlAAE7RTLvR7S1SSIeoNcHvJ3ot2GoqUeZjM46kdckiiL3ATb4wDjU9+tX4BFE8QOlp4cKw4+p4SIqJzsxgzgVxQEri3cJ4Q3Lze6PhP546EvtnwM41BLk3/yBP4Ft0q9+DY2OWjaswfgQgQMIBxfS7hwWM0178n5ToS6Ku6SybkOV0Np53JZLl4q6vyikbS4kTpof0AleD1BZTdsLFy/X3Xp2bbB07Tq6tHQ7P9xzbpWbyBUtfZZph0vNhKup2bo1DfuMRZWDep4W1r38mI9 2025-08-08 07:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 07:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 07:30:04 [INFO]: inside itemsold and closed 14409 2025-08-08 07:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:30:05 [INFO]: Ebay item id :: 326376623848 exists in Database 2025-08-08 07:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:30:05 [INFO]: inside itemsold and closed 14409 2025-08-08 07:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:30:07 [INFO]: Ebay item id :: 325843323869 exists in Database 2025-08-08 07:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:30:07 [INFO]: inside itemsold and closed 14409 2025-08-08 07:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:30:09 [INFO]: Ebay item id :: 326085752505 exists in Database 2025-08-08 07:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:30:09 [INFO]: in processold action queue is array for {"44659026":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44659026","ebayitemid":"326376623848","shopifyproductid":"8771078783198","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8771078783198","shopifyvariantid":"46168390566110","shopifyinventoryid":"48267846123742","shopifylocationid":"","product_id":"44659026","variant_id":"77564246","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44733670":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733670","ebayitemid":"325843323869","shopifyproductid":"8149521957086","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"8149521957086","shopifyvariantid":"44396302794974","shopifyinventoryid":"46494100685022","shopifylocationid":"","product_id":"44733670","variant_id":"77641555","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734712":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734712","ebayitemid":"326085752505","shopifyproductid":"8390882853086","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8390882853086","shopifyvariantid":"45129451864286","shopifyinventoryid":"47227316109534","shopifylocationid":"","product_id":"44734712","variant_id":"77642605","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 07:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 07:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:30:09 [INFO]: Shopify Inventory id 48267846123742 2025-08-08 07:30:09 [INFO]: Shopify Location id 58450641063 2025-08-08 07:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07: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-08 07:30:09 [INFO]: Change: available | Delta: -1 2025-08-08 07:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-08 07:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44659026 and user_id = 14409 2025-08-08 07:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77564246 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:30:09 [INFO]: Shopify Inventory id 46494100685022 2025-08-08 07:30:09 [INFO]: Shopify Location id 58450641063 2025-08-08 07:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07: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-08 07:30:09 [INFO]: Change: available | Delta: -1 2025-08-08 07:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-08 07:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733670 and user_id = 14409 2025-08-08 07:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641555 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:30:09 [INFO]: Shopify Inventory id 47227316109534 2025-08-08 07:30:09 [INFO]: Shopify Location id 58450641063 2025-08-08 07:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07:30:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 07:30:10 [INFO]: Change: available | Delta: -2 2025-08-08 07:30:10 [INFO]: Change: on_hand | Delta: -2 2025-08-08 07:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734712 and user_id = 14409 2025-08-08 07:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642605 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:30:10 [INFO]: updateIdsQuantity -> ["77564246","77641555","77642605"] 2025-08-08 07:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-08 07:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77564246 THEN 0 WHEN id = 77641555 THEN 0 WHEN id = 77642605 THEN 0 END, quantityflag = CASE WHEN id = 77564246 THEN 0 WHEN id = 77641555 THEN 0 WHEN id = 77642605 THEN 0 END WHERE user_id = 14409 AND id IN (77564246,77641555,77642605) 2025-08-08 07:30:10 [INFO]: QUANTITY Updated IDs: 77564246, 77641555, 77642605 2025-08-08 07:30:10 [INFO]: Successfully processed data for user 14409 2025-08-08 07:30:10 [INFO]: Execution Started 2025-08-08 07:30:10 [INFO]: Execution Finished 2025-08-08 07:40:01 [INFO]: Execution Started 2025-08-08 07:40:01 [INFO]: old server sucessfully connected 2025-08-08 07:40:01 [INFO]: sqs client sucess created 2025-08-08 07:40:03 [INFO]: Number of messages in the queue: 3 2025-08-08 07:40:04 [INFO]: item found in queue is if condition 14409 2025-08-08 07:40:04 [INFO]: item found in queue is 14409 2025-08-08 07:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBiH1pJ6pYfVmz1cVjAnvWWEw5oEQpV16Xo7r31fOBN7RL8RNkl2PQdceAtl9I0dYxtXD0ypI4UfiUlXA6Nl4hsiF64kIW+JUX5KHgcjPiTGOLDUj8XlqYX940x9jy2aNM4ntlgd5d4uXzyRTGY/Y70qu97hIxnGQs+ijq1k3JxFE+w0Phbcg8GDSHbHMgKVr1Tsh16p1Px4NMmGELNJzVPx1a0OW61hqnYJ+T4l20gdl4d8Z84qmvtYSMah+i19w8JYmgSZVF2opBce3QzrVacirw394uqx128MXeI7iaGMFkeJov+e40IwC0b3E5lGXipMklk+OHN5178wkC31QsFspH7TOWiV6YRrvgxVVMZeqSG7LcDSIjwUIvv4NzTtFGzo/pTgES9s0uq7WCAashmTywc7x+dPcVV0iZg4YTFnDUz/wRSv51bDwqd44LrlCr 2025-08-08 07:40:04 [INFO]: item found in queue is if condition 14409 2025-08-08 07:40:04 [INFO]: item found in queue is 14409 2025-08-08 07:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBeW6Aa9OY0PBuhkxLG1WKmsShdSluCBgRSh+mqjbOeUXsnYezH3fB+a4xHCd+3Ni6X/c7wfwphp29WwsGdOVewUFWa30g4O8lk8JwzRMR+xuf0Q+vxVDdFIwXGu7L6dNcun0f0u3XE6W9QyNdlSZmC2PP+OeVDqGKUAAXHe0XX/aCsHtdbNoHNqOs79DPbzdtwEykg/ZfePF5hvkhZ3ufgsNha757xdgJK77aeugvJLI/oi35ozuIAAPPzlO5x/z+2rAVddA/+dNd2GBnIzYt4b/Fpy1oKiwZGNKa1wdshmkQbB5FGS8xjl2EmQmhRW5NnGSvdHrWD+FUI8gg1Vlzl5S4xRdc6zPv1khUQ9j1xO4Y5cGz3bz6lkW07+pTAKhXdiSyFJCw4APrvZD5gQGYNu3VGxp0a5wGJjOQbosrpcWYGA2UfHWWPo8L169YtPOZ 2025-08-08 07:40:05 [INFO]: item found in queue is if condition 14409 2025-08-08 07:40:05 [INFO]: item found in queue is 14409 2025-08-08 07:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBI8d9/z6PmzoeniY2cwxU3OKsbhKqGkLQJdpB/vSEH8We0zQFh8ajxXcEI90G1gVunVXI9WloMHhqeYwEb22XuSa7JTQ4X6KX1DhdGw08j2D6gAeKP35o4wbA+NVy0i9r2XcEUDG/CSHLQIYJcC33yLn6vXKGojBE1TflriP4kz/C8wWP7S5rgHt8c75MiNSmNbA/+7HKjcg4IXnvbhTSZ6yUkmCHlYUiwWlbB4+duqlh7Kg3aOpPpHIDyn7lfm9lUXlouohohsw646ZIhw+GSGeP/BdQQ0jNlAhXzNnZ4hWPYtDLDFaHyPUnZIS9ZTv6uFqKOqClpZmi4EsHQE/lENP3UrmhU0lm5bXQ03tza6yvfrjz7Q0WxarohRGPC/K4eWQlgLYZTIpwocpxtaLlP9tMbRnPbQSriZSugQhGon1F+Jv4gjmu1MvYhTu+4u// 2025-08-08 07:40:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-08 07:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 07:40:05 [INFO]: inside itemsold and closed 14409 2025-08-08 07:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:40:07 [INFO]: Ebay item id :: 326166383802 exists in Database 2025-08-08 07:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:40:07 [INFO]: inside itemsold and closed 14409 2025-08-08 07:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:40:09 [INFO]: Ebay item id :: 326307162242 exists in Database 2025-08-08 07:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:40:09 [INFO]: inside itemsold and closed 14409 2025-08-08 07:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:40:10 [INFO]: Ebay item id :: 326231832162 exists in Database 2025-08-08 07:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:40:10 [INFO]: in processold action queue is array for {"44653374":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44653374","ebayitemid":"326166383802","shopifyproductid":"8695009149150","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8695009149150","shopifyvariantid":"45933765034206","shopifyinventoryid":"48032216449246","shopifylocationid":"","product_id":"44653374","variant_id":"77558563","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44654605":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44654605","ebayitemid":"326307162242","shopifyproductid":"8708439277790","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8708439277790","shopifyvariantid":"45966862647518","shopifyinventoryid":"48065607041246","shopifylocationid":"","product_id":"44654605","variant_id":"77559794","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44642807":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642807","ebayitemid":"326231832162","shopifyproductid":"8696075649246","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8696075649246","shopifyvariantid":"45936127934686","shopifyinventoryid":"48034576892126","shopifylocationid":"","product_id":"44642807","variant_id":"77547996","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 07:40:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 07:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:40:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:40:10 [INFO]: Shopify Inventory id 48032216449246 2025-08-08 07:40:10 [INFO]: Shopify Location id 58450641063 2025-08-08 07:40:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07:40:10Z","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 07:40:11 [INFO]: Change: available | Delta: -1 2025-08-08 07:40:11 [INFO]: Change: on_hand | Delta: -1 2025-08-08 07:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44653374 and user_id = 14409 2025-08-08 07:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77558563 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:40:11 [INFO]: Shopify Inventory id 48065607041246 2025-08-08 07:40:11 [INFO]: Shopify Location id 58450641063 2025-08-08 07:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07:40:11Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 07:40:11 [INFO]: Change: available | Delta: -2 2025-08-08 07:40:11 [INFO]: Change: on_hand | Delta: -2 2025-08-08 07:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44654605 and user_id = 14409 2025-08-08 07:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77559794 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:40:11 [INFO]: Shopify Inventory id 48034576892126 2025-08-08 07:40:11 [INFO]: Shopify Location id 58450641063 2025-08-08 07:40:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07:40:11Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-08 07:40:11 [INFO]: Change: available | Delta: -2 2025-08-08 07:40:11 [INFO]: Change: on_hand | Delta: -2 2025-08-08 07:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642807 and user_id = 14409 2025-08-08 07:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547996 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:40:11 [INFO]: updateIdsQuantity -> ["77558563","77559794","77547996"] 2025-08-08 07:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-08 07:40:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77558563 THEN 0 WHEN id = 77559794 THEN 0 WHEN id = 77547996 THEN 0 END, quantityflag = CASE WHEN id = 77558563 THEN 0 WHEN id = 77559794 THEN 0 WHEN id = 77547996 THEN 0 END WHERE user_id = 14409 AND id IN (77558563,77559794,77547996) 2025-08-08 07:40:11 [INFO]: QUANTITY Updated IDs: 77558563, 77559794, 77547996 2025-08-08 07:40:11 [INFO]: Successfully processed data for user 14409 2025-08-08 07:40:11 [INFO]: Execution Started 2025-08-08 07:40:11 [INFO]: Execution Finished 2025-08-08 07:50:01 [INFO]: Execution Started 2025-08-08 07:50:01 [INFO]: old server sucessfully connected 2025-08-08 07:50:01 [INFO]: sqs client sucess created 2025-08-08 07:50:03 [INFO]: Number of messages in the queue: 1 2025-08-08 07:50:03 [INFO]: item found in queue is if condition 14409 2025-08-08 07:50:03 [INFO]: item found in queue is 14409 2025-08-08 07:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBs51da08nOAtAMZ99nLi/Ne0zyai/8x+6Xpf8LbKUyt66aBVUXn0U16Yi013Cu7gvbCki+skyj8tYNm2p1HUVqhD+AaOwOAHm9jN6cU0/VTTmckU3PZRto+3GNZUYT1DrxafQRALn1UaVjUKI/XO/sC00yZs6vBpjMVpQeJTfBNuDmk2wQIc+IgEbfJwcUoJP+w7YOXsJqB+HoErM++hgKyRrdAv2mb4wu00kXY3w1E9XSl3v7duBLxV81evF0mqDMQAZWXQ2d3+Y1hRDgAKbaXtI7Bv/8u6mCxksH8sZZYtTecNc19/98kHhs5ZlOHyU/lY6MAWFqYF/yc4i7SAdUeIeggpI++8RO+3UJQf/YeM8Joxl0DBtP4dY928x6HfpHeWOf/S3uSdbFPE+5BN6N1Deouu8HXxg/ZOWuGfEBCUDRe/bunH8xnUfwwq5VeLM 2025-08-08 07:50:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-08 07:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-08 07:50:04 [INFO]: inside itemsold and closed 14409 2025-08-08 07:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-08 07:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-08 07:50:06 [INFO]: Ebay item id :: 226158542488 exists in Database 2025-08-08 07:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-08 07:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-08 07:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-08 07:50:06 [INFO]: in processold action queue is array for {"44669562":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669562","ebayitemid":"226158542488","shopifyproductid":"8501281947870","variants":[{"price":"54.99","quantity":0,"weight":"2","shopifyproductid":"8501281947870","shopifyvariantid":"45411429744862","shopifyinventoryid":"47509407629534","shopifylocationid":"","product_id":"44669562","variant_id":"77574782","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-08 07:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-08 07:50:06 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-08 07:50:06 [INFO]: Shopify Inventory id 47509407629534 2025-08-08 07:50:06 [INFO]: Shopify Location id 58450641063 2025-08-08 07:50:06 [INFO]: QUANTITY FOR UPDATE 0 2025-08-08 07:50:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T07:50:06Z","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 07:50:06 [INFO]: Change: available | Delta: -1 2025-08-08 07:50:06 [INFO]: Change: on_hand | Delta: -1 2025-08-08 07:50:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-08 07:50:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669562 and user_id = 14409 2025-08-08 07:50:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77574782 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-08 07:50:06 [INFO]: updateIdsQuantity -> ["77574782"] 2025-08-08 07:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-08 07:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77574782 THEN 0 END, quantityflag = CASE WHEN id = 77574782 THEN 0 END WHERE user_id = 14409 AND id IN (77574782) 2025-08-08 07:50:06 [INFO]: QUANTITY Updated IDs: 77574782 2025-08-08 07:50:06 [INFO]: Successfully processed data for user 14409 2025-08-08 07:50:06 [INFO]: Execution Started 2025-08-08 07:50:06 [INFO]: Execution Finished