2025-08-07 07:00:01 [INFO]: Execution Started 2025-08-07 07:00:01 [INFO]: old server sucessfully connected 2025-08-07 07:00:01 [INFO]: sqs client sucess created 2025-08-07 07:00:03 [INFO]: Number of messages in the queue: 3 2025-08-07 07:00:04 [INFO]: item found in queue is if condition 14409 2025-08-07 07:00:04 [INFO]: item found in queue is 14409 2025-08-07 07:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBXdZBT+WVVA0gaBqBUwJxPNOtCvwUdTZpZWDtYkGSUkbWsKdIPh0Gl+QHtu+zolabSvu6dVKlRYCcoh2wTCGx3svKN7tfrQGJQaP9FDLyOI7jACdG7APbEkcVBG1hYg87YXZKL1G3h+z4mF2iZzP7t/FglcM39/m4L/jg0yJ6mlIQlzlmilgMYe6Aw6OFWk5J1JjAiY8N32ACCqxSpb3GinJYc7N139gs6N+wGnuF0H/BEY1s7P7vZByFPm25n0oMlsGV8j2BhlgrdDXMgqZWe+brl72We3Huxp93IqDmMopCRevfpzEtVvtvBWwerZGC6dVQn3X58AOHeZ6JTDV2I7L6IRbTtgEePN3j3YCYWS+ZPMpF4O9gjZYjRoQECJWXf8PjTs5LpTXGPyspTy446B6wOckx0zt1cWRn5rs5NEGrx9CWzOlFMPq49+oBfEnj 2025-08-07 07:00:06 [INFO]: item found in queue is if condition 14409 2025-08-07 07:00:06 [INFO]: item found in queue is 14409 2025-08-07 07:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEB1yAc2iA1eJdDSdIMJtrBN5WDrDhBnE8vyJF17VX82ZwlRk3egR64s5b6cQmJso6BqKH7iRTCufa2eQfdbledcmC3TRjv6DQYG6zIj15MGND0IK1+oZfJ9AWT9lIcM9tgAe/XTUVRuJq6/VAcrp28GLRCubY72mayUhIl2DpDmReGf1vrJZiTmFBh1O6YHkcB5NgjaAxsYEZ81bUNmBNF0aw+3/56pTwmdrr9S5M/VkBOnJ/oEM4XjU4hfpPko2mBXTfcTnIWq/e/CuUeEXdABWdsq3p7WX6z7NneYrM2xvu4fDh71Y3N9J6cHXC4A6+A/BtuO8UqTV/xd4r50zJnsvnaDdXhaZO9w3JlxoquSWLRVur54Mm0gdVDh1/l02JiwCl6LCXtg3mg2bxyDYG+Jw9ScjeUrAoJJGgcwrD57wVcc6toTlNvr1aDWDj+Rlp3 2025-08-07 07:00:07 [INFO]: item found in queue is if condition 14409 2025-08-07 07:00:07 [INFO]: item found in queue is 14409 2025-08-07 07:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEB20Qs8U1L6ck2YojDUtZZGQ+MhnypfMO42kilHJyaBOx0C2O0QgB1jodztp7McLJCmtdafNaUeChlSKWgVPlzrrW7S1S28rBHbG71uoL09xFsEoXbmB4EFeUF9piiLTR+8YkheCFECZ56Sf+Z1V8hECjD7d1+VaA1IKIbCqUy4qcvY1acEyFI/mKN9WYbulruyXdwx2T74D/7s3tfPcd8N7KZb0IfnzX0RnJwZAWVwDnARtV9FqB0vviLgJIhJFDnvDDFtfXTgrfJjwg6Qkjs6iM7QFcCyWRQgENyqORXWAe5EqStp2C77QI/1mTXTkCBf+Em9TPTHq/eVJc+4J6NKcy1+JnBaZ26dq2I6GKYH0IE616hmc71pXtk4V38oMjvVaV0RW3/9ccflmtw82AcDdFMw6NApDnWLuYJxLMXSouSxCEvaDqnybRTmg1Uad7x 2025-08-07 07:00:08 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 07:00:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:00:08 [INFO]: inside itemsold and closed 14409 2025-08-07 07:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:00:10 [INFO]: Ebay item id :: 224465792171 exists in Database 2025-08-07 07:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:00:10 [INFO]: inside itemsold and closed 14409 2025-08-07 07:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:00:13 [INFO]: Ebay item id :: 225932273024 exists in Database 2025-08-07 07:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:00:13 [INFO]: inside itemsold and closed 14409 2025-08-07 07:00:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:00:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:00:14 [INFO]: Ebay item id :: 326135000004 exists in Database 2025-08-07 07:00:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:00:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:00:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:00:14 [INFO]: in processold action queue is array for {"44655888":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44655888","ebayitemid":"224465792171","shopifyproductid":"6746922811559","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"6746922811559","shopifyvariantid":"40066668462247","shopifyinventoryid":"42161894260903","shopifylocationid":"","product_id":"44655888","variant_id":"77561077","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44678219":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44678219","ebayitemid":"225932273024","shopifyproductid":"8243759186142","variants":[{"price":"319.99","quantity":0,"weight":"2","shopifyproductid":"8243759186142","shopifyvariantid":"44628888551646","shopifyinventoryid":"46726870139102","shopifylocationid":"","product_id":"44678219","variant_id":"77583439","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44666019":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666019","ebayitemid":"326135000004","shopifyproductid":"8495982903518","variants":[{"price":"319.99","quantity":0,"weight":"2","shopifyproductid":"8495982903518","shopifyvariantid":"45402487849182","shopifyinventoryid":"47500466454750","shopifylocationid":"","product_id":"44666019","variant_id":"77571239","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:00:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:00:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:00:14 [INFO]: Shopify Inventory id 42161894260903 2025-08-07 07:00:14 [INFO]: Shopify Location id 58450641063 2025-08-07 07:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:00:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:00:15Z","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-07 07:00:15 [INFO]: Change: available | Delta: -1 2025-08-07 07:00:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44655888 and user_id = 14409 2025-08-07 07:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561077 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:00:15 [INFO]: Shopify Inventory id 46726870139102 2025-08-07 07:00:15 [INFO]: Shopify Location id 58450641063 2025-08-07 07:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:00:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:00:15Z","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-07 07:00:15 [INFO]: Change: available | Delta: -1 2025-08-07 07:00:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44678219 and user_id = 14409 2025-08-07 07:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77583439 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:00:15 [INFO]: Shopify Inventory id 47500466454750 2025-08-07 07:00:15 [INFO]: Shopify Location id 58450641063 2025-08-07 07:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:00:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:00:15Z","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-07 07:00:15 [INFO]: Change: available | Delta: -1 2025-08-07 07:00:15 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:00:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:00:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666019 and user_id = 14409 2025-08-07 07:00:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571239 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:00:15 [INFO]: updateIdsQuantity -> ["77561077","77583439","77571239"] 2025-08-07 07:00:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 07:00:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77561077 THEN 0 WHEN id = 77583439 THEN 0 WHEN id = 77571239 THEN 0 END, quantityflag = CASE WHEN id = 77561077 THEN 0 WHEN id = 77583439 THEN 0 WHEN id = 77571239 THEN 0 END WHERE user_id = 14409 AND id IN (77561077,77583439,77571239) 2025-08-07 07:00:15 [INFO]: QUANTITY Updated IDs: 77561077, 77583439, 77571239 2025-08-07 07:00:15 [INFO]: Successfully processed data for user 14409 2025-08-07 07:00:15 [INFO]: Execution Started 2025-08-07 07:00:15 [INFO]: Execution Finished 2025-08-07 07:10:01 [INFO]: Execution Started 2025-08-07 07:10:01 [INFO]: old server sucessfully connected 2025-08-07 07:10:01 [INFO]: sqs client sucess created 2025-08-07 07:10:04 [INFO]: Number of messages in the queue: 8 2025-08-07 07:10:06 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:06 [INFO]: item found in queue is 14409 2025-08-07 07:10:07 [INFO]: Message deleted from the queue for receipt handle: AQEBJx+pQ2bb18J+ekahCSDDCrrV32EuvqzPOM4lBjQYpUezWfAFUPO4/mzlWfa9w2bhGSGTATRY2mzdw81CWNMZsqxaaZdpwOmgBCHwEKHMZdgV/QomCWdqWiCCdmfqcVcPcy3unbZivG2/sD7PMGLsjOz+SU7kvPeeIXLnbeIfewrjYplVp18hfEnbUFg/mrc+w6ZxH1ZL1RaoDaZNBy1JJQttE9x0H2XHScwGXQUMwBMQ7iBnnVeK4ekymJ0lM1e9xq5PpSG1xYJxMnWb7Ja3F960PLhsllRbM2upj/I1GEhj6xVTag49fzQNe4Qw+cLA7SGPOic7XLlLAKE9av+ul1fZLrVixlQX9nGRuq7d7Kf5Ro2ZUCjk/xQkH3If/LVoszs6ksutYLFxsibmXr8i8TYyt+zpBUMighgdmszc5NoUD/XZyTSUxKiQYMXsnctC 2025-08-07 07:10:08 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:08 [INFO]: item found in queue is 14409 2025-08-07 07:10:09 [INFO]: Message deleted from the queue for receipt handle: AQEBMp3+H1SiD/DmN7yKKUXMbKqXeDOW8tVGWBhYvFIQtL6Jog0SLEeURSoKEZh9qPztNPgg93Z2VX4ksSBwYfo0O4M3eSu6azd//5S/qv9Wa19wGC5cPfeLWcfi6caNrxrUwWHJUrWqwlywGGUBdA99qSm24bXCPKqyXOwCS83VEL5eRT73B0NJSyRSBeX1KpxTB8Cgw7Wkom0QL8pXwJ6JpKm4XrOSJtH7KqXkp21PTZhQsUxgev0LUeOfxlhJtrjt0pITlApTBRtg8gPCNXHGTmdhEekVd5OGLosUErVJj8JVc+cvk3zgasK9eVRhAA3NoFrGq5eytPyYseDgaufK9vonlaTOsRNvMDJJFjCUHfUnh3APbZSiVZYVGdKEx3GEtOzuWvayfAf++miVN/GMQYLl0Rv9zh31Ui/xNZ+DbWPWY4+V1OQAnmqPDlKyHU2K 2025-08-07 07:10:11 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:11 [INFO]: item found in queue is 14409 2025-08-07 07:10:12 [INFO]: Message deleted from the queue for receipt handle: AQEBy3VTlJwNWswHfDF2ijwFfnzTNykswfk6uejYfxv9hgGnbuH+92VbEyFLoNtZH/NikiB4nZb8ARIE7JrGWgDH/ZKBwTHscFBp8zWA/nCDDMMjyKnamc8q5E9H6Y8VAMkKtFYazg8t2bpWZMRsRx/j+Z2hTebxXcBD0idk3cTgbYMBrOSAWJuj2RZChsJgMxllDsUhu4+bUUs8ITJDyLYOMAiUJ4Csu6bJNQsQZxL/QsktGonriEmD+lVWwIwoXEj/k/lIS5cTRMmIfOcmo+pkjxOLq4bvhONCFUh8oLNHT4uaibKRYKKNBK2gQuh+a4qKAGpv63OBkuuL3X1tIMPoNbZt5LNHayzWtfVcfPKC1FGHABcRlGD/lgpotaCoqrt2T8elgvO/YOjk9jwj4efdi7lvGxEyhA1sItLQvOiF05UL6un9LT/Fi5ScuCKUZTNN 2025-08-07 07:10:12 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:12 [INFO]: item found in queue is 14409 2025-08-07 07:10:12 [INFO]: Message deleted from the queue for receipt handle: AQEBR5hs+YrnbEcWDKqoqgkZGBm25JpafE0xtkyKd9CqysFCVKY6Z7IzYdSyWNZeHdigT2XdggzWEvkpI2yGuVZpnF7GBoW+AFO2tseNw45PsU+RA/1RUpogz/kYQ5VYF+DxYo2OHByANU+T0xnAVxHYTavam7GAWrzmVVprlGdgKKgalak1+LwnKmvN86GHjKAio53ya3fbk8vX2z4cBH71jbc8rVtZIyPy/HM7H55PotTpI+oT3ytD6hjOyAPerxzJ7m43h/VrOlLrd1xzcJjxhuO3mD2gHuMSS/RT8jSwWOiKWcnUioCKH2lv0QDw1/9/WU+88UyxVDUpbdpTqHsvakRO0KM7l4yZdQdtbx9cK0qcxpQNBcYB6g45c2Ch4TY12ls3I+Sz3l7CYATO+LI/Wu2TK9wix0YGtoda/9uWDWeVpYWeqiTglYmi+RN3lXY7 2025-08-07 07:10:13 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:13 [INFO]: item found in queue is 14409 2025-08-07 07:10:14 [INFO]: Message deleted from the queue for receipt handle: AQEBXGoSkyEBuYPPmGWD29H/Uc1ddAhiX44AA6MlYYdx3fY6/1ko9uJZDeSHlMk4HHbyoskopl6yC+K6syoJnD1XdUi9CsWpDO9yZcurRQYTwZMTlH+yD5Sw/e5a0pd8RrEW+gDR0AJBQ/3w65bj4UXkIZOKkdcnfcjpLV7EEPTSfY9k2MyaWSIbO59Yk56NGfIMB7g9/ywxBTgaU0bNLvA9mPbKTcK3uOu20gIAzjUMnMtBSr7E3zEYfZSTWAhbjFSRLarQMSB7nIKl9Y+UR52FfLnvGLh+k8owz8UWHI2UXwoK/7Nnth2U5D9OWgbCe+A5HVhjvTD5WVgB+dHvdEhIDqCWO+z8M8WWuVdHwwY1/XFvc17V17aJLgeG5XNrHnQlrRaRDMajt3OQLCySwoOYUuvTN+9rdCiAjwzq6cYe9R1hAJx+YXBpKMbf8SERobSG 2025-08-07 07:10:14 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:14 [INFO]: item found in queue is 14409 2025-08-07 07:10:14 [INFO]: Message deleted from the queue for receipt handle: AQEBZv06gxqfxzff5AXaXqxFoItGDdIVXqzgEso/wavXX3u97sRiCqMpG5y25FgSIpXiu4HsQcTqDB9NM7dStzwPKTEeCOQzYXULI9iuMuMRxwCvK1ZM6mLJrD2mYSAZl0eQ5RWsZG2FT+Vf1qIOsUEQAxKa0FbCPn07itmFTOGCWu+sRZ3YJOsWilt7CAOoolN6HE9ATLeT8L6a1Sb6DqjLX2X5clPNOOnxuiaJYdf9F9KyRYD0XOZ6duJl0vxMJTH25bwOnqLCSYZCcI73xZw5tChckGHqlfcdSh/uvXJkjr/JkoSwKzWrXkfupjw/pehEgMsshf/5vxgYeQY9h3Fz3hXNTyE0tvL4OXbTxbqyfhpQtMKGjqyZ7IxIKoJwX7aSAtf/jnIcJUmfZGFIbwv91TMRUKj6P7CikVhSh+m5PbksJ5v4bt7IqjCA5rSh4Gez 2025-08-07 07:10:15 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:15 [INFO]: item found in queue is 14409 2025-08-07 07:10:16 [INFO]: Message deleted from the queue for receipt handle: AQEBbCXO2dKDTVN6OiPoObnGZAQLjknLz4GD4euCDW5lPOOXzIf/I+TV1b8YpUVC2OhlwfH0mZ/6IL5q2+fZS/lL6Ass80d9x2kDGnX2g50hGijiFcr8BKpQ1aNHhgxOVfKLDwVguZiktFWklCyIGziihDKUXk9P8Mm4xWLWUfVB4JqSYasiu2DeZBqCLkY6YqRp1h0r0IY5D4+/ghLVHrqSkcYaxXnW+VfWwYNH3g56UBklcdCAJe+kgjnMT7UjOljl6alTqzm3Yixf7HuApoO4zAuDB9AnFhnelye/4Jqmk63nHky/QSewhgoo8CoAs5xhz2zAbcThfbo/WORKYGquv6GZKg39WU1AR9K+aFIuVxA2tvW8qUKaPycoJEWJBMeAmuqYaefCR/gjYo1jaR3SakLYnkq+M0OIW/7YbjASp7yDcYU7Bip5O4FFyyx1gxRY 2025-08-07 07:10:16 [INFO]: item found in queue is if condition 14409 2025-08-07 07:10:16 [INFO]: item found in queue is 14409 2025-08-07 07:10:16 [INFO]: Message deleted from the queue for receipt handle: AQEB59uamHnJkmI0QTTSv8ki1/f+mbOmdUmjM6QQjow9s//HPYP26q0hr7LPjd+qtjCMu6k5YrC01vykpqzDOfyZNkSqHLEU/8lbefTOvov5R7n9ZyOpIcQFgUM9dyRzQWFQcQ7B2/mg8zGZDFeoTn9o5gAey6Zr+qFkpcP/HJFX+fcdx1e+YV/Fq5ScF17ObZoetER2CQl6h3YONyrbz64gSswf2Ja90mjclIacKNX3G/+dyGHdy1Q+/9FTXpQEhzNh/IzbWq3WUtr9ldEEUWYPBr5+xkLmGisa1AafzinsXSjzuZkqKE78vLa4cQF5E9K9OAvMow9En9OzgS3liSd/asPH5pj13zZKafjY7bhOGJa8b+bqxApdbKEdB1twnn1o+gxQ+UjdE9hF9i2pfSFwLxWFPkDnNWgKjxFdRZaBbOrNiMmatwBWLJCuJZXmd3Cr 2025-08-07 07:10:16 [INFO]: Processed 8 messages, reached the limit of 8. 2025-08-07 07:10:16 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:10:16 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:18 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:18 [INFO]: Ebay item id :: 326383297793 exists in Database 2025-08-07 07:10:18 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:18 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:20 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:20 [INFO]: Ebay item id :: 326266817004 exists in Database 2025-08-07 07:10:20 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:20 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:21 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:21 [INFO]: Ebay item id :: 226120419392 exists in Database 2025-08-07 07:10:21 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:21 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:23 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:23 [INFO]: not in db for user_id 14409 and the ebayitemid326267829072 2025-08-07 07:10:23 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:25 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:25 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:25 [INFO]: not in db for user_id 14409 and the ebayitemid226262107516 2025-08-07 07:10:25 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:27 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:27 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:27 [INFO]: Ebay item id :: 326382409583 exists in Database 2025-08-07 07:10:27 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:27 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:27 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:27 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:29 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:29 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:29 [INFO]: Ebay item id :: 226121351023 exists in Database 2025-08-07 07:10:29 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:29 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:29 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:29 [INFO]: inside itemsold and closed 14409 2025-08-07 07:10:31 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:10:31 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:10:31 [INFO]: Ebay item id :: 326383358759 exists in Database 2025-08-07 07:10:31 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:10:31 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:10:31 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:10:31 [INFO]: in processold action queue is array for {"44675576":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675576","ebayitemid":"326383297793","shopifyproductid":"8784513269982","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8784513269982","shopifyvariantid":"46205926080734","shopifyinventoryid":"48305746411742","shopifylocationid":"","product_id":"44675576","variant_id":"77580796","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735636":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735636","ebayitemid":"326266817004","shopifyproductid":"8705154547934","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8705154547934","shopifyvariantid":"45959092928734","shopifyinventoryid":"48057725518046","shopifylocationid":"","product_id":"44735636","variant_id":"77643543","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687294":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687294","ebayitemid":"226120419392","shopifyproductid":"8458002333918","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8458002333918","shopifyvariantid":"45296846667998","shopifyinventoryid":"47394769731806","shopifylocationid":"","product_id":"44687294","variant_id":"77592519","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673582":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673582","ebayitemid":"326382409583","shopifyproductid":"8784629989598","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8784629989598","shopifyvariantid":"46206099259614","shopifyinventoryid":"48305920573662","shopifylocationid":"","product_id":"44673582","variant_id":"77578802","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688028":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688028","ebayitemid":"226121351023","shopifyproductid":"8458885464286","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8458885464286","shopifyvariantid":"45299002212574","shopifyinventoryid":"47396925276382","shopifylocationid":"","product_id":"44688028","variant_id":"77593274","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44675838":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44675838","ebayitemid":"326383358759","shopifyproductid":"8784497049822","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8784497049822","shopifyvariantid":"46205898326238","shopifyinventoryid":"48305718657246","shopifylocationid":"","product_id":"44675838","variant_id":"77581058","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:10:31 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:10:31 [INFO]: Shopify Inventory id 48305746411742 2025-08-07 07:10:31 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:31 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:31 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:31Z","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-07 07:10:31 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:31 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:31 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:31 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675576 and user_id = 14409 2025-08-07 07:10:31 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77580796 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:31 [INFO]: Shopify Inventory id 48057725518046 2025-08-07 07:10:31 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:31 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:31 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:31Z","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-07 07:10:31 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:31 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:31 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:31 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735636 and user_id = 14409 2025-08-07 07:10:31 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643543 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:31 [INFO]: Shopify Inventory id 47394769731806 2025-08-07 07:10:31 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:31 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:32Z","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-07 07:10:32 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:32 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687294 and user_id = 14409 2025-08-07 07:10:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592519 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:32 [INFO]: Shopify Inventory id 48305920573662 2025-08-07 07:10:32 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:32Z","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-07 07:10:32 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:32 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673582 and user_id = 14409 2025-08-07 07:10:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578802 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:32 [INFO]: Shopify Inventory id 47396925276382 2025-08-07 07:10:32 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:32Z","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-07 07:10:32 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:32 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688028 and user_id = 14409 2025-08-07 07:10:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593274 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:32 [INFO]: Shopify Inventory id 48305718657246 2025-08-07 07:10:32 [INFO]: Shopify Location id 58450641063 2025-08-07 07:10:32 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:10:33 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:10:32Z","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-07 07:10:33 [INFO]: Change: available | Delta: -1 2025-08-07 07:10:33 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:10:33 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:10:33 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44675838 and user_id = 14409 2025-08-07 07:10:33 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77581058 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:10:33 [INFO]: updateIdsQuantity -> ["77580796","77643543","77592519","77578802","77593274","77581058"] 2025-08-07 07:10:33 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6 2025-08-07 07:10:33 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77580796 THEN 0 WHEN id = 77643543 THEN 0 WHEN id = 77592519 THEN 0 WHEN id = 77578802 THEN 0 WHEN id = 77593274 THEN 0 WHEN id = 77581058 THEN 0 END, quantityflag = CASE WHEN id = 77580796 THEN 0 WHEN id = 77643543 THEN 0 WHEN id = 77592519 THEN 0 WHEN id = 77578802 THEN 0 WHEN id = 77593274 THEN 0 WHEN id = 77581058 THEN 0 END WHERE user_id = 14409 AND id IN (77580796,77643543,77592519,77578802,77593274,77581058) 2025-08-07 07:10:33 [INFO]: QUANTITY Updated IDs: 77580796, 77643543, 77592519, 77578802, 77593274, 77581058 2025-08-07 07:10:33 [INFO]: Successfully processed data for user 14409 2025-08-07 07:10:33 [INFO]: Execution Started 2025-08-07 07:10:33 [INFO]: Execution Finished 2025-08-07 07:20:01 [INFO]: Execution Started 2025-08-07 07:20:01 [INFO]: old server sucessfully connected 2025-08-07 07:20:01 [INFO]: sqs client sucess created 2025-08-07 07:20:04 [INFO]: Number of messages in the queue: 1 2025-08-07 07:20:05 [INFO]: item found in queue is if condition 14409 2025-08-07 07:20:05 [INFO]: item found in queue is 14409 2025-08-07 07:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBBmbcx0YKUDqwbXiiuod+0BUomzyR+m42KWwH/8JRa1URH/sKBICzsCvT52Bw84avTdnmdQYNhojsDmupKnxSfFJV1mkLCHSvSOgQT+iQyCIC+x27meLQV3zQIGg4FAtDtjoQbfGVA8NKIpUEiT40YWvpUcVxR9wQlRMAvmpHIppiKT0B7cJRd87j6a47Yg9QgzMvuRaeWEKpA/9XWe62eAS2KzzKxnb1Fy9c71id5+Vfkzfnc+rGkeX4HrGUtp+335zBO90/E9Uu4B42Q+C5EbmXzDWNoMRFpqrEKba2FkpErnl2dYPlM8004h8naXARjZ7gLl0R5zSZJaE6F9uvNa8JsurBSl+roeJq84oCvX3YGGHidVlJ8dCeZTe7WDBQp/R43tq4Uq4VugS4at2mTthzbgWkLt9J/IL9LlymCSbz7yQbNdCqWP+LiS3x+jNi 2025-08-07 07:20:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 07:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:20:05 [INFO]: inside itemsold and closed 14409 2025-08-07 07:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:20:07 [INFO]: Ebay item id :: 225926355812 exists in Database 2025-08-07 07:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:20:07 [INFO]: in processold action queue is array for {"44666237":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44666237","ebayitemid":"225926355812","shopifyproductid":"8081337254110","variants":[{"price":"557.99","quantity":0,"weight":"2","shopifyproductid":"8081337254110","shopifyvariantid":"44261391499486","shopifyinventoryid":"46358482256094","shopifylocationid":"","product_id":"44666237","variant_id":"77571457","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:20:07 [INFO]: Shopify Inventory id 46358482256094 2025-08-07 07:20:07 [INFO]: Shopify Location id 58450641063 2025-08-07 07:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07: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-07 07:20:07 [INFO]: Change: available | Delta: -1 2025-08-07 07:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44666237 and user_id = 14409 2025-08-07 07:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77571457 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:20:07 [INFO]: updateIdsQuantity -> ["77571457"] 2025-08-07 07:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 07:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77571457 THEN 0 END, quantityflag = CASE WHEN id = 77571457 THEN 0 END WHERE user_id = 14409 AND id IN (77571457) 2025-08-07 07:20:07 [INFO]: QUANTITY Updated IDs: 77571457 2025-08-07 07:20:07 [INFO]: Successfully processed data for user 14409 2025-08-07 07:20:07 [INFO]: Execution Started 2025-08-07 07:20:07 [INFO]: Execution Finished 2025-08-07 07:30:01 [INFO]: Execution Started 2025-08-07 07:30:01 [INFO]: old server sucessfully connected 2025-08-07 07:30:01 [INFO]: sqs client sucess created 2025-08-07 07:30:04 [INFO]: Number of messages in the queue: 3 2025-08-07 07:30:06 [INFO]: item found in queue is if condition 14409 2025-08-07 07:30:06 [INFO]: item found in queue is 14409 2025-08-07 07:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBwnFLWB6krob2jAoMiQJnQYYDD/1pG1t8g2GRneMqj2c1J5PWFOP6jCeO1lch4NHnV6LqwbY6OiwZu0CNzQn3RBR22BoJve0jEP/W/tgnUqyrrHkG7zZxGKbC7hDnHuk8MeiiEj4j6lYNM0X8KdEXRazvfcQM/k51HVKqqiQngbsQeNEKs4IRGUd70Swx8dnvViFA+Qa/l4DF/a2Y28WA/K4CmC5mZ5zYD99ndHJKoFtst9Wa8mddrqfaLhxIf327oVRc1E7RIZN66zTip8AmpUU4AYPF3DOWQ8bUMK6do0KDtThw3LjYXXJaMe8gri1G7iF0+KWP9Dcib+riHrLEA3yTqBhh3wesmN2PGSYv5FdDjwt+ttUnqNESIYgvDTzrzYlC5GruDwOyHBEtr61BVNJnvgLEqKBrR3Gx+NRYJZGJQ9qox/LbonWJBm1QOG18 2025-08-07 07:30:07 [INFO]: item found in queue is if condition 14409 2025-08-07 07:30:07 [INFO]: item found in queue is 14409 2025-08-07 07:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBU29lxeHBPJ0yTbHPfkj5Ukz9Br6rs+DtCu2xGrvCAVJtv5ZH71xcgIGcyB8/5h0kakIbY3sBdq49nzBGQU8PevEIx0RVAFpVWd8qeaWvYEO8bld0W9oh+sy2/Rk6DrTzZVTKn8sIgTLkO2pYu4xED5QtNokc5sYQii1YxNtpcZby6/mz3T9p7ha9xqW+reUAIPZZ078ZtJT5/tAsXUhP8DHpkUg0xKUgsv54htqBDAjjPA3dNxVN9qKU49r9z+P2/g8aJxYyX0b0+xjvHEQs/+IkKwsds8kqAbaHYJVflce+SvWMfokN5vnHd/P0y01j2VoVbyZpKSBdN6rrXOC5Lei3TK9498HuLp6g+ACdNlkPiB2yi4jJ79Xs41LzJY7XUbxPVdV0TShWTzRXkJR6srjDkbirRSLVGmQwELWy5HULJph6wTVEAIo41F7lOEVy 2025-08-07 07:30:07 [INFO]: item found in queue is if condition 14409 2025-08-07 07:30:07 [INFO]: item found in queue is 14409 2025-08-07 07:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEB7toPZuWmX2bXi4/uFLPAZhfbzmGcvAEO3R4IcwO/JOBmqYSRmFGb5DKmp3Dok47V/6TX5QtiaC42WnEKZIj/S4gOEU+m7ymQy+3bY8x3wNE0XP/ljhX1tFlMGiGvwSq9PO3ibWjaQFvPhiqimpK6WgZvGnD9wKnvUDtXakWZTCpLam9Nqpm0SF1aCg5y1pvaOdPAKOxvcnMuZfAGvEVxjzdrBfzsMv7tchsiVibCnHid5Bf1klIG2Ll3eJwC4nkiSWh7tsQU+1RR26y72dtCpoqRretsAoTCQvajNaDY615RhhTn/UItMllPH3Yy3A3t4T6X/tzDzYzErLcr8qySd5w5nbtHFpAzwn9punL9tEM++agrFg+nVjwmNkcIWCSEg9wAhJVrUmGNRFMLDFdo4AZGFw0iZF0hD67lJyL8HczXLsuj8DZbbrsk4kTVm+NU 2025-08-07 07:30:08 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-07 07:30:08 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:30:08 [INFO]: inside itemsold and closed 14409 2025-08-07 07:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:30:10 [INFO]: Ebay item id :: 325962312768 exists in Database 2025-08-07 07:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:30:10 [INFO]: inside itemsold and closed 14409 2025-08-07 07:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:30:12 [INFO]: Ebay item id :: 325962312768 exists in Database 2025-08-07 07:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:30:12 [INFO]: inside itemsold and closed 14409 2025-08-07 07:30:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:30:13 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:30:13 [INFO]: Ebay item id :: 326431869399 exists in Database 2025-08-07 07:30:13 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:30:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:30:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:30:13 [INFO]: in processold action queue is array for {"44734087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734087","ebayitemid":"325962312768","shopifyproductid":"8250164674782","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8250164674782","shopifyvariantid":"44656399843550","shopifyinventoryid":"46754389786846","shopifylocationid":"","product_id":"44734087","variant_id":"77641972","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44736918":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736918","ebayitemid":"326431869399","shopifyproductid":"8811479072990","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8811479072990","shopifyvariantid":"46274720006366","shopifyinventoryid":"48375501127902","shopifylocationid":"","product_id":"44736918","variant_id":"77644855","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:30:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:30:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:30:13 [INFO]: Shopify Inventory id 46754389786846 2025-08-07 07:30:13 [INFO]: Shopify Location id 58450641063 2025-08-07 07:30:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:30:14Z","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-07 07:30:14 [INFO]: Change: available | Delta: -1 2025-08-07 07:30:14 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734087 and user_id = 14409 2025-08-07 07:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641972 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:30:14 [INFO]: Shopify Inventory id 48375501127902 2025-08-07 07:30:14 [INFO]: Shopify Location id 58450641063 2025-08-07 07:30:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:30:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:30:14Z","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-07 07:30:14 [INFO]: Change: available | Delta: -1 2025-08-07 07:30:14 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:30:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:30:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736918 and user_id = 14409 2025-08-07 07:30:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644855 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:30:14 [INFO]: updateIdsQuantity -> ["77641972","77644855"] 2025-08-07 07:30:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-07 07:30:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641972 THEN 0 WHEN id = 77644855 THEN 0 END, quantityflag = CASE WHEN id = 77641972 THEN 0 WHEN id = 77644855 THEN 0 END WHERE user_id = 14409 AND id IN (77641972,77644855) 2025-08-07 07:30:14 [INFO]: QUANTITY Updated IDs: 77641972, 77644855 2025-08-07 07:30:14 [INFO]: Successfully processed data for user 14409 2025-08-07 07:30:14 [INFO]: Execution Started 2025-08-07 07:30:14 [INFO]: Execution Finished 2025-08-07 07:40:02 [INFO]: Execution Started 2025-08-07 07:40:02 [INFO]: old server sucessfully connected 2025-08-07 07:40:02 [INFO]: sqs client sucess created 2025-08-07 07:40:05 [INFO]: Number of messages in the queue: 4 2025-08-07 07:40:06 [INFO]: item found in queue is if condition 14409 2025-08-07 07:40:06 [INFO]: item found in queue is 14409 2025-08-07 07:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBQeUQGelhWArttBOwjjvggmRvVsQ1qqwUVWVJgvSKPHHlyKH+JroL5/HO3bVQRlFwDXEnf3g312tLGavnOmod0nQy4N9yLtQ3KahBWS/rAETc2GS+QCO+B+LQNsjnvQwukM6bKJwXhvsHvoKjVPVhXwCmeqiT7KICX7uh9G/tg+Mur1Cwrb9HREZJHRoW7/irRQFZUNAPtcR+TmPAHxUQABhyS0AKK/Tx5yJblDqq9X8fvkb9N/1Nctv2ZscH70CALjIHUUZdjsMGh0wn1VXDX5QnBTFKpgvlcuI5l2loTdHcgxCkpFhfdIiB90T1e0McIXpt3p0d+8h8Ksu/wuT/5qRH+LhoejhWabST58gJ1I4i0SguEtVQtZHwi1ru9uLTPnUHrmIfTbhJvSktSiHRXDVEsFNca0AWNiGOLK7ZFw0mUbN0vX5qPv0yEx4kZX1g 2025-08-07 07:40:06 [INFO]: item found in queue is if condition 14409 2025-08-07 07:40:06 [INFO]: item found in queue is 14409 2025-08-07 07:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEB4Xg9rrXUtSMfI3zzRZ3IQOcI6HYP32m2bIN/eCd8CfR2v7HHhu+boAVQN4Q0kV8O34H7kCZs0kznPdUdePdyOwO8dq/fO+PCBEQpcqDlCJQO8UDEZAA1Jlc+r40uYYBXAanST22nTOX3Y8tphyRRf9PXr9YsflpSMmJhiPRZeRSOXcxI+oqUKNvgXa4Kj4xLDJ8MF9JwUk0NLi71YBSjgQ2F154SGNV1idOBTUIyz3TzB7zFYFrjwy9xCaVvB4JyClLLZM4TQC9UUtOMclKMI9iiv+Z9tzMkQTrlXa0XuYPY3AtwnsjDkKrOvoB/8/OgvMr6CyaAmYrguJlr+WsTncmJQAYNhnZOW4wldfEKcv+T9h1+wiyjFdgiSE/67VysanYCdS1TLoSbwZxN/3wHKwsb+gRR77Qhqh4i+y8z3wvcK6BrfwlkW6TMt2gGhhY4 2025-08-07 07:40:09 [INFO]: item found in queue is if condition 14409 2025-08-07 07:40:09 [INFO]: item found in queue is 14409 2025-08-07 07:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBWxjUJ1+W15kTkGXHTUxJC1ewIrvt8KIbS2mfz/Nu+NHuL7Cp5ROtcYg+eEfoPmb94HGYOIYMgTfk7zyC3s7uj9dlTvu80WBvyYeppXXW8BiOJBG9YlTPnAW33VNjf4lcKXkHPnknjKGvHvnwBFW2nZ9gKST80swVzHdgGZRayFNTkyOBnO2QxHP6lg96I6B0c6yjZ+GiuQsqq1L6DFVg2z6EEPWx/G9fATyGYL3hZmVCh5X/SsqlRXQEeQAO4sw57wnK2OotcNtInB03O27uPZnHMLnl0/RdO4o68bwaqD7EakecXeuOSzqYrM32YZzveYGbSs/t5Nky6gyORTVlBuZW7Sq0XGcCtzc54hbbAK7HuD8ASiNDgySEFWko/GKpqvd3i2r/LzFswUqdX8d/mf4cHb151yWdsfRcjtskn3SfFJLqn5EPRgxB0diN7JXZ 2025-08-07 07:40:10 [INFO]: item found in queue is if condition 14409 2025-08-07 07:40:10 [INFO]: item found in queue is 14409 2025-08-07 07:40:10 [INFO]: Message deleted from the queue for receipt handle: AQEBxBO7k4V+kzeA61vHMG27fKcM9V/+9L/QPzro33c4YPbwVuHKX4UcPtyPDhoHW3cSl45SOUrKHSqEubaiI0OuRsNxB0SSSuzqVOhRV8roRtu0JhgeGhSebi7jppsRU21iM3dCmYYURVJJGQDxRnTSYFZAstJmZ/eCUBOp6B68RxyQd1tCiffEQE9xWKt0XKTtgznS+/GUc2PIEkaSBmpV0GYOEQCV63IP7nn9g+F5HFhNXb0NMvud9cmztkjwktGzjH1V5bAcjJ5NpTglSrUZ8bdusLlhadQn6UKUZ5+bmA3L6poYDNMEESvTFiHWmm6gr/AYRabDeMOvqzDfp5ID4NdPsWuEwM1hQ+/npE2qRb2ekhCQiVtIaElSULA+W/ITg4Zq0v/scSlItFrvCV+cSbi0RvflaY060CyxGtoMw2guf2NiiW3EQrae7rrd61/+ 2025-08-07 07:40:10 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-07 07:40:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:40:10 [INFO]: inside itemsold and closed 14409 2025-08-07 07:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:40:12 [INFO]: Ebay item id :: 225933678239 exists in Database 2025-08-07 07:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:40:12 [INFO]: inside itemsold and closed 14409 2025-08-07 07:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:40:14 [INFO]: Ebay item id :: 225962153220 exists in Database 2025-08-07 07:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:40:14 [INFO]: inside itemsold and closed 14409 2025-08-07 07:40:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:40:15 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:40:15 [INFO]: Ebay item id :: 225962153220 exists in Database 2025-08-07 07:40:15 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:40:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:40:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:40:15 [INFO]: inside itemsold and closed 14409 2025-08-07 07:40:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:40:17 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:40:17 [INFO]: Ebay item id :: 325953245907 exists in Database 2025-08-07 07:40:17 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:40:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:40:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:40:17 [INFO]: in processold action queue is array for {"44681511":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681511","ebayitemid":"225933678239","shopifyproductid":"8244287832286","variants":[{"price":"284.99","quantity":0,"weight":"2","shopifyproductid":"8244287832286","shopifyvariantid":"44631213310174","shopifyinventoryid":"46729194111198","shopifylocationid":"","product_id":"44681511","variant_id":"77586736","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44651671":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44651671","ebayitemid":"225962153220","shopifyproductid":"8254836146398","variants":[{"price":"179.99","quantity":0,"weight":"2","shopifyproductid":"8254836146398","shopifyvariantid":"44676601741534","shopifyinventoryid":"46774560456926","shopifylocationid":"","product_id":"44651671","variant_id":"77556860","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44712479":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44712479","ebayitemid":"325953245907","shopifyproductid":"8249499877598","variants":[{"price":"495.99","quantity":0,"weight":"2","shopifyproductid":"8249499877598","shopifyvariantid":"44653879296222","shopifyinventoryid":"46751868846302","shopifylocationid":"","product_id":"44712479","variant_id":"77620092","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:40:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:40:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:40:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:40:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:40:17 [INFO]: Shopify Inventory id 46729194111198 2025-08-07 07:40:17 [INFO]: Shopify Location id 58450641063 2025-08-07 07:40:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:40:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:40:17Z","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-07 07:40:18 [INFO]: Change: available | Delta: -1 2025-08-07 07:40:18 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:40:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:40:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681511 and user_id = 14409 2025-08-07 07:40:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586736 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:40:18 [INFO]: Shopify Inventory id 46774560456926 2025-08-07 07:40:18 [INFO]: Shopify Location id 58450641063 2025-08-07 07:40:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:40:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:40:18Z","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-07 07:40:18 [INFO]: Change: available | Delta: -1 2025-08-07 07:40:18 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:40:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:40:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44651671 and user_id = 14409 2025-08-07 07:40:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77556860 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:40:18 [INFO]: Shopify Inventory id 46751868846302 2025-08-07 07:40:18 [INFO]: Shopify Location id 58450641063 2025-08-07 07:40:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:40:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:40:18Z","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-07 07:40:18 [INFO]: Change: available | Delta: -1 2025-08-07 07:40:18 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:40:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:40:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44712479 and user_id = 14409 2025-08-07 07:40:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77620092 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:40:18 [INFO]: updateIdsQuantity -> ["77586736","77556860","77620092"] 2025-08-07 07:40:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 07:40:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77586736 THEN 0 WHEN id = 77556860 THEN 0 WHEN id = 77620092 THEN 0 END, quantityflag = CASE WHEN id = 77586736 THEN 0 WHEN id = 77556860 THEN 0 WHEN id = 77620092 THEN 0 END WHERE user_id = 14409 AND id IN (77586736,77556860,77620092) 2025-08-07 07:40:18 [INFO]: QUANTITY Updated IDs: 77586736, 77556860, 77620092 2025-08-07 07:40:18 [INFO]: Successfully processed data for user 14409 2025-08-07 07:40:18 [INFO]: Execution Started 2025-08-07 07:40:18 [INFO]: Execution Finished 2025-08-07 07:50:01 [INFO]: Execution Started 2025-08-07 07:50:01 [INFO]: old server sucessfully connected 2025-08-07 07:50:01 [INFO]: sqs client sucess created 2025-08-07 07:50:04 [INFO]: Number of messages in the queue: 1 2025-08-07 07:50:05 [INFO]: item found in queue is if condition 14409 2025-08-07 07:50:05 [INFO]: item found in queue is 14409 2025-08-07 07:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBbJVo1YHfS5ASebGPXsiKrxIbtc68Mp62/oT9sKPAwpi6amKyLYLKxTgMPwbjmVV19KSk6ye9ddWa2sTpUEwsddUPjTY0qRmE2ZO2+DLDDcytdd/cDCq1djfSN5bPe3gIlMN3lKyXJzqmIqCoqLpkNw4hELNf9V035cs7q9+N18iKYpu28KfOqLvgvUyrTfwsY+BO1otO2DBIAgve78nbaWH51nW8vRfZpOL0my2hhIleMN8MTKAHAKKeBWX+fCuX40LS4SJl8Ddd1Sjp4BVgOTopYYyYintVY3eNg9lCAPQnD7uxqGXSBiHm/05h315J0ByP0XUefrgQfkJ7+172lOSgtA/ztQSmhChfkWUCbDEHUiaA+QtCF9EPEpR8nWAvuLFEAPPDS+gBod7g/fucJNbYk7d/gXjgortlq1ODasbmIkx//M2mTxdrugOlPi/1 2025-08-07 07:50:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 07:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 07:50:05 [INFO]: inside itemsold and closed 14409 2025-08-07 07:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 07:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 07:50:07 [INFO]: Ebay item id :: 225966061140 exists in Database 2025-08-07 07:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 07:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 07:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 07:50:07 [INFO]: in processold action queue is array for {"44658630":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658630","ebayitemid":"225966061140","shopifyproductid":"8257092255966","variants":[{"price":"317.99","quantity":0,"weight":"2","shopifyproductid":"8257092255966","shopifyvariantid":"44684404359390","shopifyinventoryid":"46782365237470","shopifylocationid":"","product_id":"44658630","variant_id":"77563850","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 07:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 07:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 07:50:07 [INFO]: Shopify Inventory id 46782365237470 2025-08-07 07:50:07 [INFO]: Shopify Location id 58450641063 2025-08-07 07:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 07:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T07:50: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-07 07:50:07 [INFO]: Change: available | Delta: -1 2025-08-07 07:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-07 07:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 07:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658630 and user_id = 14409 2025-08-07 07:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563850 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 07:50:07 [INFO]: updateIdsQuantity -> ["77563850"] 2025-08-07 07:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 07:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77563850 THEN 0 END, quantityflag = CASE WHEN id = 77563850 THEN 0 END WHERE user_id = 14409 AND id IN (77563850) 2025-08-07 07:50:07 [INFO]: QUANTITY Updated IDs: 77563850 2025-08-07 07:50:07 [INFO]: Successfully processed data for user 14409 2025-08-07 07:50:07 [INFO]: Execution Started 2025-08-07 07:50:07 [INFO]: Execution Finished