2025-08-12 21:00:01 [INFO]: Execution Started
2025-08-12 21:00:01 [INFO]: old server sucessfully connected
2025-08-12 21:00:01 [INFO]: sqs client sucess created
2025-08-12 21:00:02 [INFO]: Number of messages in the queue: 3
2025-08-12 21:00:03 [INFO]: item found in queue is if condition  14409
2025-08-12 21:00:03 [INFO]: item found in queue is  14409
2025-08-12 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBTZfJu2PCgMi5D8D+pm8yEIF9MIeHI82kybqqRsX8Q/fILtQbGC+mh61mduJJ9M+p7UJLKTBqPb7/tjAX7jHXnW0HsGnO1tJIxveWY4eTdKH363waKVQuJRI3d5xmxTf64LHD27iuDm0aBts/rH81w853zleoSxzoezQQDA1YWr10TXRYZ95DR0376DJtTGYI8A1LmLVeXLEaE0CngDDtIjKMg9VGFydeXmDkb0OZoaqBIgePKTwyP5S1Lkk02jE1pTsvvK4lgmo/02Y1N3bLe3thXcKzRpSao1mzSWDKz2m1ARioWwgDS7Z4MZd4Ey4EMb0/rLdkRbPBLEjrzl1MZCT/OLcf0agNVoCHKdocYauYqxh/mNkyN16zz2us8bos2gSF268MI2pZeP8LR6o4IewLtacNWWeJrEuUgz0nlNSsvtghO7AnRbeNpi+77Op8
2025-08-12 21:00:03 [INFO]: item found in queue is if condition  14409
2025-08-12 21:00:03 [INFO]: item found in queue is  14409
2025-08-12 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBXPvaYBX2uZoud445myvvyoTsjSGDGt/JsFnodCgrR0dM1hUuiRA2U36KEUw1UBtQ30G2G9OH0D7f0ZzRWFWMWBruJm6udWsRWQgoUJEE1iS08QCNf94NEh5RhwGRhyQQrZUEhQIVaZfImu5vpyRu5N1HLWg2nB+AuUnNvLKt3F5kBr0A8QyoBUb9tfph7xzNCTxwdNquQk7TMOzCSAgmzeaULZ4oPVuiGysmA0Vw9SO3XYLUU9sRJ2rQWWaJOi/i+JNtQf/eMhUu7THDJOWMBwboDwSTKR8spMd2KMaWfZ4+aSC6QK4v3HOaE8vCbXp4QJNnNUC59Ld7xP3OpRdcQPiWddxQI6EGDRNlCJugLbIoMGZR4OxyMYV+AU3+Z0Qa03rcHhPGjqvnWq7wBXaUU/3o135ZzlrkL9NZHKj2lpaBV9ZcgIQMOm2xOSFiTbiF
2025-08-12 21:00:03 [INFO]: item found in queue is if condition  14409
2025-08-12 21:00:03 [INFO]: item found in queue is  14409
2025-08-12 21:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvm7ozrsJPsyNsLGlF6Gcmz+alTg/Plib6/NrUYsmq3ts/HpjFrIDHaXkUaG/zh22MQjvr5h1GJO2mX6wVoKR1fYl2/egY4eiKbyPBOKj+S7VnjMtcJbhNNDQ+byYeVjzcQ/IuHCv5Lwc2oKvhX7Hl0iGzicbqa6Yj5aErXIk6rQliPBWGGBb5gmc0k1TIodj0busy358dtPg3L2Q3N0GNeQQIy8Ahqx5zAV+sIQvboVOPxn00SYa9qBjteoWYw5FviZHpzrlYMjdTheMzjkMh016uwQmaZavjcp8ozo1kvtxMGQKqj+3Zl4LnnqrLTyY4iGT7SJrdeXtxsKrUsy1PpX9DmuNsc9iz4bKlE6ydgrgqrbuOxjAB0+1RQpyZXazP8Q+5t0c/EXfdm6VywpMJuiD5PGx3RhcbOcP53Sg73+yJSa5hZp2FiMNVIEUf9Pg
2025-08-12 21:00:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-12 21:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 21:00:04 [INFO]: inside itemsold and closed 14409
2025-08-12 21:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:00:06 [INFO]: Ebay item id :: 335559920436 exists in Database
2025-08-12 21:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:00:06 [INFO]: inside itemsold and closed 14409
2025-08-12 21:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:00:08 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:00:08 [INFO]: Ebay item id :: 335324412209 exists in Database
2025-08-12 21:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:00:08 [INFO]: inside itemsold and closed 14409
2025-08-12 21:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:00:10 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:00:10 [INFO]: Ebay item id :: 305763796862 exists in Database
2025-08-12 21:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:00:10 [INFO]: in processold action queue is array    for {"44555449":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555449","ebayitemid":"335559920436","shopifyproductid":"7684530012382","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7684530012382","shopifyvariantid":"42932525924574","shopifyinventoryid":"45027552919774","shopifylocationid":"","product_id":"44555449","variant_id":"77448129","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44709696":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44709696","ebayitemid":"335324412209","shopifyproductid":"8347314553054","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8347314553054","shopifyvariantid":"45002313302238","shopifyinventoryid":"47100107522270","shopifylocationid":"","product_id":"44709696","variant_id":"77617302","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44555439":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555439","ebayitemid":"305763796862","shopifyproductid":"7660685492446","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7660685492446","shopifyvariantid":"42834082922718","shopifyinventoryid":"44928693829854","shopifylocationid":"","product_id":"44555439","variant_id":"77448119","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 21:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:00:10 [INFO]: Shopify Inventory id 45027552919774
2025-08-12 21:00:10 [INFO]: Shopify Location id 58450641063
2025-08-12 21:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:00: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-12 21:00:10 [INFO]: Change: available | Delta: -1
2025-08-12 21:00:10 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555449 and user_id = 14409 
2025-08-12 21:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448129 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:00:10 [INFO]: Shopify Inventory id 47100107522270
2025-08-12 21:00:10 [INFO]: Shopify Location id 58450641063
2025-08-12 21:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:00:11Z","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-12 21:00:11 [INFO]: Change: available | Delta: -1
2025-08-12 21:00:11 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44709696 and user_id = 14409 
2025-08-12 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617302 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:00:11 [INFO]: Shopify Inventory id 44928693829854
2025-08-12 21:00:11 [INFO]: Shopify Location id 58450641063
2025-08-12 21:00:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:00:11Z","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-12 21:00:11 [INFO]: Change: available | Delta: -1
2025-08-12 21:00:11 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555439 and user_id = 14409 
2025-08-12 21:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448119 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:00:11 [INFO]: updateIdsQuantity -> ["77448129","77617302","77448119"]
2025-08-12 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-12 21:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77448129 THEN 0 WHEN id = 77617302 THEN 0 WHEN id = 77448119 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77448129 THEN 0 WHEN id = 77617302 THEN 0 WHEN id = 77448119 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77448129,77617302,77448119)
2025-08-12 21:00:11 [INFO]: QUANTITY Updated IDs: 77448129, 77617302, 77448119
2025-08-12 21:00:11 [INFO]: Successfully processed data for user 14409
2025-08-12 21:00:11 [INFO]: Execution Started
2025-08-12 21:00:11 [INFO]: Execution Finished
2025-08-12 21:10:01 [INFO]: Execution Started
2025-08-12 21:10:01 [INFO]: old server sucessfully connected
2025-08-12 21:10:01 [INFO]: sqs client sucess created
2025-08-12 21:10:02 [INFO]: Number of messages in the queue: 5
2025-08-12 21:10:02 [INFO]: item found in queue is if condition  14409
2025-08-12 21:10:02 [INFO]: item found in queue is  14409
2025-08-12 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoTKwy5jfmDV6LzusbbJs79duT55/s3/o2i/eAxVmP31A2QLAwWUoNLxc4XEcl2Idx1f4u97RKS8oMwm8+1G9oxbFEjpISJtM1YbRrJvtortJb957she+GWVwX65L0xukUrEdOHcE5J2lI/NSRd187iGpT2xLjhSKQ5cPkd//cv2IGRRsxzGxqUlTTVh2nuSuTwFPbusJu9YvmsMSspJzHcZLf+NBF6WV6lsyZwe5Ti95t9iDIY6GVkQWHMBNeSdYYWrW4Uu+3YuSfjuMz3gF63P86aM4FAOFnWSVUHxUh0/XcELERqXcTHSwJmPpvfF2J3zta88cA3JBRmOH4IeQQ/jicdbfHSGt2PmZNWWZhg2cxNo0WWGfVl9K3mfr4SaYs2xVJ0ZFG4whtPnVSMxoOlmPCSGA7a8RE5IX2eAycBGgCA4mfF0u1hIz5u0/yZve
2025-08-12 21:10:03 [INFO]: item found in queue is if condition  14409
2025-08-12 21:10:03 [INFO]: item found in queue is  14409
2025-08-12 21:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7q+Ead1A0zoFPPhm1PjMiUZxVjgRvwE0Hr1vhQvgc9aiJnxsFEfYhPh8c6o15cPdb+RrQXNmQH1J0QsyHltRkblYT6hflJ6aqqMJhTfUARkHWjCM+6pUhurYXqH8nUY9JiQQJ8ch3byP2s1OCqrrb98chFBq0NFLyw/5S3pJvHU97dMmlaziEFYkoeZP2EoIuvWpBYCJYS+7hpqrXftfGyEoCPGi2zht9hkOA2QSC0FbR6V+p8Y2hH2Qoy1mIavf4DZej+74PKQQAoC9HxLOEmZ3DAcD+deILa8Sd3sPv2Cebg2FKfuCHNowYDOcQMGD6wIV7UGCIZlfdtdkUkFnlZsiTkaGFTEs/CucNWI8FlRBAtbQWMF3X/SGv+aRUgbFU6J24LdfcqTaJVlDZYOiRi3tH3V25Pc95NXkNsXugm/gAsaInKI0cR8z1UPmFNVt
2025-08-12 21:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 21:10:04 [INFO]: item found in queue is  14409
2025-08-12 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBRYCDrVHADinjf91rRAZkC4/WUsqoQMNNEJuMAlKvxXVY4rnWH7YaTuhozVzZ7kDjhhWFmt1NZKdtkvoHYnMbvh76mjFI3UwzdohlZ3ZMUVywEXsHZPrKLFpoUWVDHNuFImIl28MwOmQvCxiW6rSlHD7Icvn3u+gic4Gk/ek4hdZxS3LtpUrWWoH4atOE5KL2zs8cwYLtH3CEFT49+uRNiAC6NfveWCw8fyPd4VK+u5dpB+mJF7dFaHuWMbCtJBQ+xGsbfP+ecaicX/Buk2J+h25ES12GTTw4lAAVLr38XgysH8//0OPN3M79BzpKg+w3cBEl8xTEJuoqED/4zxaCEsn5AQjTpE/Xrle+NzgMknh9sDuIDmzdUElM7/zCwduhZjLsty5ybuw9BVXXy5OhBGqScxxFQBlhWjLtnf06wqYrL6KzxNSLWppLoocjva0I
2025-08-12 21:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 21:10:04 [INFO]: item found in queue is  14409
2025-08-12 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBaOFDpgTlPuTGubh563B0FIj4+eSBQacgt3wUCPZof0wQZ7WdRJL5cnS9cvmcvkKG47ZMffBryKf/9t/wCPW4ObuYPWwSZO8ZPkfHPwylzg8tP3XOtzIuCa3DEgXrum1qeXiE/7sMfzu0Ulx8y1Uahjen5ByDCdyKbwQmSLYhfmMjiTDAXKadPhSQFKnjXjPnBIVOfhRAuyEZ0T4l7U/ZZEAYslqkAcU3QGjHuBDcKHvq3sqvsYjL9XVKoGoSPPWLNmcpcVjXoz5Ro/4cOVnzA0GlQWf0yDY2G7SdHLMuu+xA1NNN1tvbTpdHaWE4T6WWagxRU/grJw9Pf7jV4ujGf7yPoRb9e85ozGybgNcmI79x5V2iBIVRtPXED/6pgKT69G4idYbjecfLR7IWI1m3nz2Rue+8IzDelrhvrG7vQPagRs0FQUKLmiTtAGvyl1pO
2025-08-12 21:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 21:10:04 [INFO]: item found in queue is  14409
2025-08-12 21:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEB0qgipAmGrKprNgx75F4YvnUMbgcOTr2jikfaz+Et5plJxW+MrG695lgk5L4mnQ67Jwvop35EwSYrltEtPqgrTmBvKizROLL50w61G6Ia237otwdABUf+2ssSMGMDq8whbA27zii7iwt9lTEnKsapkc+x8HKlHGVisOJPFgleBbyqcNYnyjC4dnLFxP3KgpRv+1tO02QIbRQ/sotIqYUkJXBnnuxi6iqiA42pGVCsu17EXCUOFRvRY2is9UNHnQvG5xgJUcq5ukz5X+acVEFD7mFIjCmgSzvwjn+UPBqRKPQ4Iqpr9CMMfRr9OuVywxB0L3tWinwj3w48Zjyp8M4hNnxV2zs+Elp5OGA8Ww+uXb7cOlF6RrXEV6sEXld6HhT9bMCfOEBMP/V8kMKaqp907uZLj4opGsWhy3NCiy1LaK9CTT9LTcsvmNSuSRQkkjz0
2025-08-12 21:10:05 [INFO]: Processed 5 messages, reached the limit of 5.
2025-08-12 21:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 21:10:05 [INFO]: inside itemsold and closed 14409
2025-08-12 21:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:10:06 [INFO]: Ebay item id :: 306324677074 exists in Database
2025-08-12 21:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:10:06 [INFO]: inside itemsold and closed 14409
2025-08-12 21:10:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:10:08 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:10:08 [INFO]: Ebay item id :: 323471831675 exists in Database
2025-08-12 21:10:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:10:08 [INFO]: inside itemsold and closed 14409
2025-08-12 21:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:10:10 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:10:10 [INFO]: Ebay item id :: 286081049172 exists in Database
2025-08-12 21:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:10:10 [INFO]: inside itemsold and closed 14409
2025-08-12 21:10:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:10:11 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:10:11 [INFO]: Ebay item id :: 283246628575 exists in Database
2025-08-12 21:10:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:10:11 [INFO]: inside itemsold and closed 14409
2025-08-12 21:10:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:10:13 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:10:13 [INFO]: Ebay item id :: 403098354791 exists in Database
2025-08-12 21:10:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:10:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:10:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:10:13 [INFO]: in processold action queue is array    for {"44891741":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44891741","ebayitemid":"306324677074","shopifyproductid":"8929147453662","variants":[{"price":"664.05","quantity":0,"weight":"40","shopifyproductid":"8929147453662","shopifyvariantid":"46853081432286","shopifyinventoryid":"48964518904030","shopifylocationid":"58450641063","product_id":"44891741","variant_id":"77804060","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44683546":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683546","ebayitemid":"323471831675","shopifyproductid":"6635137728679","variants":[{"price":"9.67","quantity":0,"weight":"0.9375","shopifyproductid":"6635137728679","shopifyvariantid":"39656554234023","shopifyinventoryid":"41751224090791","shopifylocationid":"","product_id":"44683546","variant_id":"77588771","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44685070":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685070","ebayitemid":"286081049172","shopifyproductid":"8923159757022","variants":[{"price":"41.99","quantity":0,"weight":"2","shopifyproductid":"8923159757022","shopifyvariantid":"46827942805726","shopifyinventoryid":"48926404837598","shopifylocationid":"58450641063","product_id":"44685070","variant_id":"77590295","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673417":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673417","ebayitemid":"403098354791","shopifyproductid":"6986651238567","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6986651238567","shopifyvariantid":"41040874012839","shopifyinventoryid":"43136909738151","shopifylocationid":"","product_id":"44673417","variant_id":"77578637","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 21:10:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 21:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:10:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:10:13 [INFO]: Shopify Inventory id 48964518904030
2025-08-12 21:10:13 [INFO]: Shopify Location id 58450641063
2025-08-12 21:10:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:10:13 [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-12 21:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44891741 and user_id = 14409 
2025-08-12 21:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77804060 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:10:13 [INFO]: Shopify Inventory id 41751224090791
2025-08-12 21:10:13 [INFO]: Shopify Location id 58450641063
2025-08-12 21:10:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:10:14 [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-12 21:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683546 and user_id = 14409 
2025-08-12 21:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588771 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:10:14 [INFO]: Shopify Inventory id 48926404837598
2025-08-12 21:10:14 [INFO]: Shopify Location id 58450641063
2025-08-12 21:10:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:10: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-12 21:10:14 [INFO]: Change: available | Delta: -1
2025-08-12 21:10:14 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685070 and user_id = 14409 
2025-08-12 21:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590295 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:10:14 [INFO]: Shopify Inventory id 43136909738151
2025-08-12 21:10:14 [INFO]: Shopify Location id 58450641063
2025-08-12 21:10:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:10:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:10: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-12 21:10:14 [INFO]: Change: available | Delta: -1
2025-08-12 21:10:14 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:10:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:10:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673417 and user_id = 14409 
2025-08-12 21:10:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578637 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:10:14 [INFO]: updateIdsQuantity -> ["77804060","77588771","77590295","77578637"]
2025-08-12 21:10:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3
2025-08-12 21:10:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77804060 THEN 0 WHEN id = 77588771 THEN 0 WHEN id = 77590295 THEN 0 WHEN id = 77578637 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77804060 THEN 0 WHEN id = 77588771 THEN 0 WHEN id = 77590295 THEN 0 WHEN id = 77578637 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77804060,77588771,77590295,77578637)
2025-08-12 21:10:14 [INFO]: QUANTITY Updated IDs: 77804060, 77588771, 77590295, 77578637
2025-08-12 21:10:14 [INFO]: Successfully processed data for user 14409
2025-08-12 21:10:14 [INFO]: Execution Started
2025-08-12 21:10:14 [INFO]: Execution Finished
2025-08-12 21:20:01 [INFO]: Execution Started
2025-08-12 21:20:01 [INFO]: old server sucessfully connected
2025-08-12 21:20:01 [INFO]: sqs client sucess created
2025-08-12 21:20:02 [INFO]: Number of messages in the queue: 0
2025-08-12 21:20:22 [INFO]: Execution Started
2025-08-12 21:20:22 [INFO]: Execution Finished
2025-08-12 21:30:01 [INFO]: Execution Started
2025-08-12 21:30:01 [INFO]: old server sucessfully connected
2025-08-12 21:30:01 [INFO]: sqs client sucess created
2025-08-12 21:30:02 [INFO]: Number of messages in the queue: 0
2025-08-12 21:30:22 [INFO]: Execution Started
2025-08-12 21:30:22 [INFO]: Execution Finished
2025-08-12 21:40:01 [INFO]: Execution Started
2025-08-12 21:40:01 [INFO]: old server sucessfully connected
2025-08-12 21:40:01 [INFO]: sqs client sucess created
2025-08-12 21:40:02 [INFO]: Number of messages in the queue: 1
2025-08-12 21:40:03 [INFO]: item found in queue is if condition  14409
2025-08-12 21:40:03 [INFO]: item found in queue is  14409
2025-08-12 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBGQshRFkKZzfL1yOiujMggxGNru8SqTnhZDAqU3RmGkoapckZRRrhQ/9uUP+3IJ+5qqGvbSvPB/6gHcHOdDJu5VMgxbS+sYyIUDbhilnDJUC8YUT5YOA0MI+Ypu7/+Rdcu4SY7kyz7FWTAom4+4S3BxdK0ZkUh6wRNdZE8ow7LGcnFAt3Lz6CFHDujjpNwJigZCwGWXK2yAHCqYW8rEnZAkbM8ssyPAYHd6hK82Xcnwh3QWNreFiwUTXxh/2Gdyo8UwElIy3WBZnsa4BIBrJ4pjnatwFkw316boRR8an/SWFZp5JnM29Hw29axzoCmagaUpo8/zxrCz9FrT16ruV7OIb45MUV+UBucwMSR9mlxxZ+5MDRiiVK96q+FGkE7P9GtR4V+zhueqhevvECgHax/1/wPGqBXF0XmTims7GnlFie7p6AiSKjPdoXvb+WKyUU
2025-08-12 21:40:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 21:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 21:40:03 [INFO]: inside itemsold and closed 14409
2025-08-12 21:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 21:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-12 21:40:05 [INFO]: Ebay item id :: 286742536567 exists in Database
2025-08-12 21:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 21:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 21:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 21:40:05 [INFO]: in processold action queue is array    for {"45313018":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313018","ebayitemid":"286742536567","shopifyproductid":"8976622387422","variants":[{"price":"26.99","quantity":0,"weight":"3","shopifyproductid":"8976622387422","shopifyvariantid":"47204136091870","shopifyinventoryid":"49315978084574","shopifylocationid":"58450641063","product_id":"45313018","variant_id":"78265531","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 21:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 21:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 21:40:05 [INFO]: Shopify Inventory id 49315978084574
2025-08-12 21:40:05 [INFO]: Shopify Location id 58450641063
2025-08-12 21:40:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 21:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T21:40:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-12 21:40:05 [INFO]: Change: available | Delta: -1
2025-08-12 21:40:05 [INFO]: Change: on_hand | Delta: -1
2025-08-12 21:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 21:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313018 and user_id = 14409 
2025-08-12 21:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265531 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 21:40:05 [INFO]: updateIdsQuantity -> ["78265531"]
2025-08-12 21:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 21:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78265531 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78265531 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78265531)
2025-08-12 21:40:05 [INFO]: QUANTITY Updated IDs: 78265531
2025-08-12 21:40:05 [INFO]: Successfully processed data for user 14409
2025-08-12 21:40:05 [INFO]: Execution Started
2025-08-12 21:40:05 [INFO]: Execution Finished
2025-08-12 21:50:01 [INFO]: Execution Started
2025-08-12 21:50:01 [INFO]: old server sucessfully connected
2025-08-12 21:50:01 [INFO]: sqs client sucess created
2025-08-12 21:50:02 [INFO]: Number of messages in the queue: 0
2025-08-12 21:50:22 [INFO]: Execution Started
2025-08-12 21:50:22 [INFO]: Execution Finished