2025-07-31 20:00:01 [INFO]: Execution Started
2025-07-31 20:00:01 [INFO]: old server sucessfully connected
2025-07-31 20:00:01 [INFO]: sqs client sucess created
2025-07-31 20:00:02 [INFO]: Number of messages in the queue: 2
2025-07-31 20:00:02 [INFO]: item found in queue is if condition  14409
2025-07-31 20:00:02 [INFO]: item found in queue is  14409
2025-07-31 20:00:02 [INFO]: Message deleted from the queue for receipt handle: AQEB4gwyVQ22cvVdS18OA48JeFKQQXo5G2j+vWokSC4h7ADBcjQZ9HpvmdevtdcvN79MIzjPdtZk2a9c4Ar9yzwirKv3DudhxWCA1qG1e8MicFAlRZkfyyh+Cl9ZhuDeWnaXP0MbDdf99E/WYRuCBaMq4ANUTGQqhzuzmlrFE+ODSV3OBAwVoTgyxDIpRgIgVweALD46pDz0acG8FTgqcYa1Ib50b8BC0ifhEhiohIzKtAJgTMWJ50ucjXEPj94Wrp1CSTNrtXN9Wtp8xHvv64SBd9+2XiaGJ8561Ojhy8A2LrF849Vrw6PZ2eyfVjjbrXO2TW7CvwPtiSMd6oWbXwyE6xbEmmzWKxNtRNS/brBj96rnQoKrrUAm1Bc0sePf6H9/IEUxnnPELtK72v0pwNY4d9evCG7Yx9jSJpBu11/6Vw+xEx+cuuo15Kk2bOnwl96P
2025-07-31 20:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:00:03 [INFO]: item found in queue is  14409
2025-07-31 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwEA65IkW18AengvUtwvQ6d3wl6vdDWcAO+5aj2fBQuYgr9NPqkXyc27FNRejR/9WsuxHIXtnYQ3D3u3iywUDcUpKdEwogcyUDczCGyZvK+384s+hlF4r/0yycWIMPttHQZMwjlh8q8GLPHn5ha4EdinDdJ1iEo7N5VXuE5WWEwPVsxIhC+cBCjyRrbBhYtaFMtGUtI7k62NuaDNWe6OwbvL/lKKihQiw0GXVcORZ7vDA2Zx4hyupbSPJK0Fu7RSiYg77NHzswz/CyOtHjzAqKCzl7r3IYoEs6x21bkzxEg1+/2mcqewnS2s4m6tbi/33jJMnzTefvvbZnBCy+wh9LhjwOF4s7JXmNmDVmfEpL2LSo2Dcm1rRg6LJ3NsX7oFdZsWCVS6/QldV3RJaYZbrNF3gor22/GC/rNMphg2YacnsSIcimIMXAqlsG7thBOb+
2025-07-31 20:00:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 20:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:00:03 [INFO]: inside itemsold and closed 14409
2025-07-31 20:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:00:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:00:05 [INFO]: not in db for user_id 14409 and the ebayitemid406087803455
2025-07-31 20:00:05 [INFO]: inside itemsold and closed 14409
2025-07-31 20:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:00:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:00:06 [INFO]: Ebay item id :: 335362366477 exists in Database
2025-07-31 20:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:00:06 [INFO]: in processold action queue is array    for {"44587463":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587463","ebayitemid":"335362366477","shopifyproductid":"8438108061918","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8438108061918","shopifyvariantid":"45251180527838","shopifyinventoryid":"47349096841438","shopifylocationid":"","product_id":"44587463","variant_id":"77480172","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:00:06 [INFO]: Shopify Inventory id 47349096841438
2025-07-31 20:00:06 [INFO]: Shopify Location id 58450641063
2025-07-31 20:00:06 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:00:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:00: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-07-31 20:00:07 [INFO]: Change: available | Delta: -1
2025-07-31 20:00:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:00:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:00:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587463 and user_id = 14409 
2025-07-31 20:00:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480172 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:00:07 [INFO]: updateIdsQuantity -> ["77480172"]
2025-07-31 20:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-07-31 20:00:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77480172 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77480172 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77480172)
2025-07-31 20:00:07 [INFO]: QUANTITY Updated IDs: 77480172
2025-07-31 20:00:07 [INFO]: Successfully processed data for user 14409
2025-07-31 20:00:07 [INFO]: Execution Started
2025-07-31 20:00:07 [INFO]: Execution Finished
2025-07-31 20:10:02 [INFO]: Execution Started
2025-07-31 20:10:02 [INFO]: old server sucessfully connected
2025-07-31 20:10:02 [INFO]: sqs client sucess created
2025-07-31 20:10:03 [INFO]: Number of messages in the queue: 2
2025-07-31 20:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:10:03 [INFO]: item found in queue is  14409
2025-07-31 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWocDoMqG+nflxkQ55rQIPP0hEnYACi+D/fxWAOBsExxx4c9T0f0wUBF0CkpiBEO4UiKCuJwvk0ml4vFhycOa1PbI6povkYV3REMEDEBzudSk3b7Tms71UsPSwhkQ1bsQWpgkJH4YnmXtmGwf0UM78QKczhjEHMS82dMlc+P/xVBc083TYlSXGl4maXvZuFLrNeRVfpeUXfPZaTK+QkY7K6xfsviXm9S+SYskOTMuhcXeCcclTgD9pyNt+L1dLcMI13WgKFN1r56CT7vU8A7tMp5ihTvpIwDNr7VP+Vk7OLssWSaUZqE1PLYT34+OCHRAraVCRIWJRFy70GJiGxr9g63f/GWuivnGm6jizET2QDV81VZW0CC6jBFBD8lNw515ZnzmeUoJR8zKbpLd+VRJJQZfl2QnkTcqW9LD06+j56Z2LLK+O+8jo/dvTLUJ7zBH
2025-07-31 20:10:04 [INFO]: item found in queue is if condition  14409
2025-07-31 20:10:04 [INFO]: item found in queue is  14409
2025-07-31 20:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBk+1tymCKByG4M9JpFEDOSTejBNuva/X0BCkG30nmr2JhrZFGTVKRk7Kv7v0PLJkd0tzOl3N3L1/v/dQLmdZFHAHgLayTfjkq+UcSaYNqjFFMB7PhjK8twgBKB34y+UoA1PjsMM5QWVITtQd352GluY4laTbhC48t8faoYe0kuDDmY3DlMMyahUvbn6Nl4Ck7Q6RgXu/SRoRAkvHINvlMyQuT2Hdu7ir06pRbGOyZg6ajFopwMLgnKqp4jZxzJzP93kUeMLacfyYSmtPAhyrZEE4ccRwjJA7gqWNqWlYDby1SHw2PgeqCljlecJLO0YGjv5i0+iF7QRIfUFdl77Wgx6SaQOQUmVnsfIyPGJvY+wIZvjL+8UrU06Yb0XDmibKsAQVF/igiqvgrcXcI8dwoG/slxAeHTCbgCZ4ZInWH5mIZHWXu1u6BEOjn/wq2hSyl
2025-07-31 20:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 20:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:10:04 [INFO]: inside itemsold and closed 14409
2025-07-31 20:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:10:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:10:06 [INFO]: Ebay item id :: 305768311509 exists in Database
2025-07-31 20:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:10:06 [INFO]: inside itemsold and closed 14409
2025-07-31 20:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:10:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:10:07 [INFO]: Ebay item id :: 305499763193 exists in Database
2025-07-31 20:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:10:07 [INFO]: in processold action queue is array    for {"44559778":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44559778","ebayitemid":"305768311509","shopifyproductid":"8696077713630","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8696077713630","shopifyvariantid":"45936131735774","shopifyinventoryid":"48034580693214","shopifylocationid":"","product_id":"44559778","variant_id":"77452458","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44562651":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44562651","ebayitemid":"305499763193","shopifyproductid":"8378672349406","variants":[{"price":"64.99","quantity":0,"weight":"2","shopifyproductid":"8378672349406","shopifyvariantid":"45094597296350","shopifyinventoryid":"47192460427486","shopifylocationid":"","product_id":"44562651","variant_id":"77455331","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:10:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:10:08 [INFO]: Shopify Inventory id 48034580693214
2025-07-31 20:10:08 [INFO]: Shopify Location id 58450641063
2025-07-31 20:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:10:08Z","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-07-31 20:10:08 [INFO]: Change: available | Delta: -1
2025-07-31 20:10:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44559778 and user_id = 14409 
2025-07-31 20:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77452458 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:10:08 [INFO]: Shopify Inventory id 47192460427486
2025-07-31 20:10:08 [INFO]: Shopify Location id 58450641063
2025-07-31 20:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:10:08Z","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-07-31 20:10:08 [INFO]: Change: available | Delta: -1
2025-07-31 20:10:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44562651 and user_id = 14409 
2025-07-31 20:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455331 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:10:08 [INFO]: updateIdsQuantity -> ["77452458","77455331"]
2025-07-31 20:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 20:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77452458 THEN 0 WHEN id = 77455331 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77452458 THEN 0 WHEN id = 77455331 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77452458,77455331)
2025-07-31 20:10:08 [INFO]: QUANTITY Updated IDs: 77452458, 77455331
2025-07-31 20:10:08 [INFO]: Successfully processed data for user 14409
2025-07-31 20:10:08 [INFO]: Execution Started
2025-07-31 20:10:08 [INFO]: Execution Finished
2025-07-31 20:20:01 [INFO]: Execution Started
2025-07-31 20:20:01 [INFO]: old server sucessfully connected
2025-07-31 20:20:01 [INFO]: sqs client sucess created
2025-07-31 20:20:02 [INFO]: Number of messages in the queue: 7
2025-07-31 20:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:03 [INFO]: item found in queue is  14409
2025-07-31 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSP7n8zW7SUQdYZsOFBW8r4ncg5t1nuzLiNRr8yJnlHqlyK14C1DRVcOJ7f5Y06+SdGAFByraNN+/XF+Z+LFyx1aUe1RdEO92k43DrVMCqKmdFYKiV0KBpDnGYTswVodvRuzT8gIwjxHq3uPHLYuJRGbd3rGGrU2YZdiriMutneD6ZUUGMui2Dr9RZNxt5R2INz8xxpL1ec747lyyYA73u8IlcxHKix8RYr+nhJTJH+ssHTnixLmwMie0b1L+x4QGKVM/m569n1xU/o0YkrQT5/3t0Wf+wSt4qLtXXj0hLYUqKtBivTAl/MT/siRQFZJFlXlzt2wfT2f24GIykKnhMTIkw3bKiSGE2Ztnrt/9owAnyI0W8pQzfmfmwxrJJ1IDhngVfycTsloA+EErwB5BZ4SC9R8CZ2YNe0OtL02lp9RB/EiW0wlrf3dg9mp2RkDN
2025-07-31 20:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:03 [INFO]: item found in queue is  14409
2025-07-31 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBv+yQIsVbv9ILLyd0mG9cMUUZNeh1fmnh80SmjI8KHTw/oE5xBw17GR9dN3pgGp8RwWFS7WPbMh5axU82U6cO1XB+8XJc2/ZBUdAylhOV+sfbjaNmg8Xoz8TrZc/ZYNeWdS5c3eO1dfuIY4nJpIxR3qeVppLbKJaWZdnG/AVH9WfrmW7J3Abk4n8IUIf6qjTfuIwsGFt/HKhQsyYzzjqKGGPciDoXdXY5D706Q/kN5YGsYCvUIUcmOZl2pzGMPW6YDR5qEn22dedtnrF8k+Ax4T+SNwDYG1HonNQ/SNygYriIT6mFf1BFim93FoCOiq5wPDTnuuejkAV7IK44JjJ4f7qa2KifT5ByjNqLlKmWii1ewSqwGwPFE1f66uV+C0tiEAMKd2ioL43pLYWqnexcYrqYlO9tMFYQin/PHe9sPpqm8qDWA7ExonFQMKWXoGov
2025-07-31 20:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:03 [INFO]: item found in queue is  14409
2025-07-31 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE2VZsYnlsAeJ8X5XQVyWEoyDD65osHg/mEgQ8M7RmN6RWhJeM96UGiwF/Qqt4MrI9M0/HW56nJqCLiZucuMSe1EikpzGkxnaQLwTlm4cxLJdfSlrli/088dc+WRqJhQCx6CF5/y9HHgc1AWStNXR+dqQ5MILt3NC2Fw2WzEkITzPi7tFAzYx1crf8Pn1HyAVfzcvRgTl2qWl5siL+ksU8YcGyZUEDJFzR6IFckErfMYdKmWb0GmM//64uHMjw7Hl0CfVrXG+XPSEijj11Es1uxp1e7ql1NtHd2E4WkE9iySvlxuGE409xeykFIr+Fav+QsjoYteHjyQp7rFoki5b+gTDRkk73/h7LV5KTfK2dBY0Cs/KooNCkyZ98/za6OUTiJucqSyPtSItcE/dRgVOd4uLXMcGK/d2dGg3XP0HfAudRFuktdrE+uZs9cdf+DDM
2025-07-31 20:20:04 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:04 [INFO]: item found in queue is  14409
2025-07-31 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBT3thWemQ5GhTm92EZbbHyCYpy3r5PRHrQdz4ZmrwygfLKTHUBOqF4gRO02DC/HGvUa2Cz+vo5sK3LtA7JMtrWkxriafvfYcKSqkmLcai4vWfPslDUomaOsb69Di37Bsbrw6HRWmSgAeKIDl+6qHglC/6QhaEEl8NnIBHMW2XHLm4sADTc0UmfI/l8/Zost4y+3b1GYHQvA7sUptegvwilhFiyNfqd8BNwhn8YL0qIPL48rQa+7YNJBjldjQlQ1GEQ6T++XU8xi6Y+hcRsS8HXtS40NwSFpo//3Pt9Oi68u03I1ZqDdCNL/5ZRHEb2C7WqlFCyo1xvdS7yg7s6NRRVZtmxl5/doldVFXDHagmkeuCd5zYV9riOafEAASiAHAIHQJUhpydGoeVPpXVEemims2IWg9fiZ9fXGMDY9TKxDPuK9+E2idZrecS+ZHGXcPT
2025-07-31 20:20:04 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:04 [INFO]: item found in queue is  14409
2025-07-31 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBDEhsRPd0i70EzDp0dcvM1ith6HJboOyqnCX9Pa4aaIm6O4v0k6csAdgOWZUqtTTMSNwtjlXhlaH0axDRTwd+lnI3KiYRQ1/K7pz9OZhdLDUvQ0VUW336nps8jzSO8k7XSMBuZuKMcFkAru9CcgMS9PZmdnajcXfhWTB7yXi5VdPNfJIIViC7nfYDKRM9uT4goybJpzi4uV1lk20SlPsOhyKr85iUMX1i5FBUohM/TNGhocKmf7NBH9r4w26fCPB1goCgRGoARA44mvCf6k+6uBqVojphfPGAvR/hIm7TfN7KMvMm9Yn1/5biFKlF2hXFUs1vS0L/+t9YxxEAgbVcbl2krZqP5azUG3SiNe9X2jJI4qlm7t6i10qXyqDlUojU1aQI2IZ+iBFIbL+OxduebzTi1fxv1tpX0URuHZwGn9kbynk+bEeRETt3aXGdipAj
2025-07-31 20:20:04 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:04 [INFO]: item found in queue is  14409
2025-07-31 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBKzqpgivRyXe5qRsF2Xq56isgV/psZpQanZrBMbeuPkSufw64cnughSooKi1OvTBu/OWgTbHOXe0ifiXUPXJdYQzd6t0QlS6fDLDPufwgcmg0PKht9MofupzqqQH+9tbuHqpA0SQ64EFgauHD7XOKL+LXp8Rt2S6kGwUssMMnqY2WN4bcFWbZqfPIKXXElVkXiNTBf4+ZKtXAmxY31+Aa9LVF5mGk3/x805oasPObpwaZVsOw9TC1zkJ2he5aOqQAbfxgjaCLwNfBKc/bt7h0hApaVOyzXZM+L3nAAUMYdOQMfc8MwgMVKFbSUy+TQAzPgslbBtQLijZAxFT6TKvi5CUGxm8n6HOAz3rf7B/JdIqXlZgeErASvsRjkW73smhV2RWScLdqNJBAvgEWUvTxaKbSoecwFxou0Aq9cyTqTP7W4jqTZptE/bQTMllFYxzb
2025-07-31 20:20:05 [INFO]: item found in queue is if condition  14409
2025-07-31 20:20:05 [INFO]: item found in queue is  14409
2025-07-31 20:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBis9rWYxDr7Kqca746U+mOojpcgKwuvtMT2YWmYJ0jT5WJZrU+K8eikt8z6lqNTKDVbZy9kf2J+0b7JldvzF7Vpn1ZR7un8t5+1y1drrtf3u52F4TfvlbFYbETUVcZogjZ9y+NDzJaziU0IHhXOoTIGdGiy6bTXKS8tAz5kZ9wSfG8filSkfK9KftSfyinpILLGLlYFt2L+NbdKCz/xSVuTYkGdHS0GKKb7eZEx1IwPFYLUtSx+BxIULmIeVxA8/LVn4BO7wLzsOApAMFQTFlORmIGgfMhdBdpEh7ItqcdEBFsWK58mGSB+7E1X4MEIhows9PWvoKNK/QVgMK6HCteGKUfxmQ8skgVpH9Ww9VqENF2Mg7C1HNJTpWWPCaQZ605bdelCZ+ffCMeEssS0zH8EaafOKCpeMOuyL13H848Vm/4LOWAHjSKgNDswMglEag
2025-07-31 20:20:05 [INFO]: Processed 7 messages, reached the limit of 7.
2025-07-31 20:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:20:05 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:07 [INFO]: Ebay item id :: 257012058867 exists in Database
2025-07-31 20:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-07-31 20:20:07 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:09 [INFO]: Ebay item id :: 286740634965 exists in Database
2025-07-31 20:20:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-07-31 20:20:09 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:10 [INFO]: Ebay item id :: 335374202629 exists in Database
2025-07-31 20:20:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:20:10 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:12 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:12 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:12 [INFO]: Ebay item id :: 286727342529 exists in Database
2025-07-31 20:20:12 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:12 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-07-31 20:20:12 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:14 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:14 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:14 [INFO]: Ebay item id :: 286148500864 exists in Database
2025-07-31 20:20:14 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:20:14 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:16 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:16 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:16 [INFO]: Ebay item id :: 335500945910 exists in Database
2025-07-31 20:20:16 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:20:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:20:16 [INFO]: inside itemsold and closed 14409
2025-07-31 20:20:17 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:20:17 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:20:17 [INFO]: Ebay item id :: 305773082430 exists in Database
2025-07-31 20:20:17 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:20:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:20:17 [INFO]: in processold action queue is array    for {"45215965":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45215965","ebayitemid":"257012058867","deleted":1}},"45312918":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45312918","ebayitemid":"286740634965","deleted":1}},"44600015":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600015","ebayitemid":"335374202629","shopifyproductid":"8461640597726","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"8461640597726","shopifyvariantid":"45305980027102","shopifyinventoryid":"47403904762078","shopifylocationid":"","product_id":"44600015","variant_id":"77492724","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45288234":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45288234","ebayitemid":"286727342529","deleted":1}},"44560549":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44560549","ebayitemid":"286148500864","shopifyproductid":"8727064674526","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8727064674526","shopifyvariantid":"46015942885598","shopifyinventoryid":"48114468913374","shopifylocationid":"","product_id":"44560549","variant_id":"77453229","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44589794":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589794","ebayitemid":"335500945910","shopifyproductid":"8697470025950","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8697470025950","shopifyvariantid":"45939248595166","shopifyinventoryid":"48037705056478","shopifylocationid":"","product_id":"44589794","variant_id":"77482503","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44564117":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44564117","ebayitemid":"305773082430","shopifyproductid":"8696055070942","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8696055070942","shopifyvariantid":"45936033300702","shopifyinventoryid":"48034482225374","shopifylocationid":"","product_id":"44564117","variant_id":"77456797","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:20:18 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:20:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:20:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:20:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:20:18 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:20:18 [INFO]: productIds WHich are having null productid -> [45215965,45312918,45288234]
2025-07-31 20:20:18 [INFO]: ebayItemIds WHich are not imported-> ["257012058867","286740634965","286727342529"]
2025-07-31 20:20:18 [INFO]: Entered in bulkUpdateProducts function
2025-07-31 20:20:18 [INFO]: Transaction started for bulkUpdateProducts
2025-07-31 20:20:18 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45215965,45312918,45288234)
2025-07-31 20:20:18 [INFO]: Query executed successfully. Affected rows: 0
2025-07-31 20:20:18 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-07-31 20:20:18 [INFO]: Transaction committed successfully.
2025-07-31 20:20:18 [INFO]: Transaction ended for bulkUpdateProducts
2025-07-31 20:20:18 [INFO]: Shopify Inventory id 47403904762078
2025-07-31 20:20:18 [INFO]: Shopify Location id 58450641063
2025-07-31 20:20:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:20: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-07-31 20:20:18 [INFO]: Change: available | Delta: -1
2025-07-31 20:20:18 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600015 and user_id = 14409 
2025-07-31 20:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492724 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:20:18 [INFO]: Shopify Inventory id 48114468913374
2025-07-31 20:20:18 [INFO]: Shopify Location id 58450641063
2025-07-31 20:20:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:20:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:20: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-07-31 20:20:18 [INFO]: Change: available | Delta: -1
2025-07-31 20:20:18 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:20:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:20:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44560549 and user_id = 14409 
2025-07-31 20:20:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77453229 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:20:18 [INFO]: Shopify Inventory id 48037705056478
2025-07-31 20:20:18 [INFO]: Shopify Location id 58450641063
2025-07-31 20:20:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:20:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:20: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-07-31 20:20:19 [INFO]: Change: available | Delta: -1
2025-07-31 20:20:19 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:20:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:20:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589794 and user_id = 14409 
2025-07-31 20:20:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482503 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:20:19 [INFO]: Shopify Inventory id 48034482225374
2025-07-31 20:20:19 [INFO]: Shopify Location id 58450641063
2025-07-31 20:20:19 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:20:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:20:19Z","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-07-31 20:20:19 [INFO]: Change: available | Delta: -1
2025-07-31 20:20:19 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:20:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:20:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44564117 and user_id = 14409 
2025-07-31 20:20:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77456797 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:20:19 [INFO]: updateIdsQuantity -> ["77492724","77453229","77482503","77456797"]
2025-07-31 20:20:19 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-07-31 20:20:19 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77492724 THEN 0 WHEN id = 77453229 THEN 0 WHEN id = 77482503 THEN 0 WHEN id = 77456797 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77492724 THEN 0 WHEN id = 77453229 THEN 0 WHEN id = 77482503 THEN 0 WHEN id = 77456797 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77492724,77453229,77482503,77456797)
2025-07-31 20:20:19 [INFO]: QUANTITY Updated IDs: 77492724, 77453229, 77482503, 77456797
2025-07-31 20:20:19 [INFO]: Successfully processed data for user 14409
2025-07-31 20:20:19 [INFO]: Execution Started
2025-07-31 20:20:19 [INFO]: Execution Finished
2025-07-31 20:30:01 [INFO]: Execution Started
2025-07-31 20:30:01 [INFO]: old server sucessfully connected
2025-07-31 20:30:01 [INFO]: sqs client sucess created
2025-07-31 20:30:02 [INFO]: Number of messages in the queue: 1
2025-07-31 20:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:30:03 [INFO]: item found in queue is  14409
2025-07-31 20:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBo5Lt/IlEUiqJuI7Faq3vGQs0mNhnw1FZFv9VoHcPzGFAO7DzifNpCqrpVaCbYx3RoiH/lZ0U4EXTpXr8qrLkHmYmHuv7ldqNB8JGndQLgEowZkxudA5GGLUxQpvyXEE25P9Ax+DM64425Gne27IWrTfTx+MwD0pKUCVQHObENODcqJhcUUov9S8U8tV8+oQQyldwGjMy3wQ9szmfQIx5a+Ku6nI43j91ctzhVCnaXSAWkWApu/6WHP4BMEkKAtZbxnXOtDixYQtv4FapkdqnCcvzAYcueCW7KnooGxfm8JfU2dzWA1rc5XDi0sAKADVwgkfOfwZT9iSerax1RvFGZGDI+bYQr01c1UOG085pciJXQaiRwZdLgvndcCVTwI2QmBzBksJj4p61uPFSTGrDeoznZHXjMMxiAKlLAX/YfxbEIcLXfLgjXvEiU8EyhNZ1
2025-07-31 20:30:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-07-31 20:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:30:03 [INFO]: inside itemsold and closed 14409
2025-07-31 20:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:30:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:30:05 [INFO]: Ebay item id :: 305481580587 exists in Database
2025-07-31 20:30:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:30:05 [INFO]: in processold action queue is array    for {"44596679":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596679","ebayitemid":"305481580587","shopifyproductid":"7888535486686","variants":[{"price":"45.99","quantity":0,"weight":"2","shopifyproductid":"7888535486686","shopifyvariantid":"43706409320670","shopifyinventoryid":"45802231005406","shopifylocationid":"","product_id":"44596679","variant_id":"77489388","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:30:05 [INFO]: Shopify Inventory id 45802231005406
2025-07-31 20:30:05 [INFO]: Shopify Location id 58450641063
2025-07-31 20:30:05 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:30: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-07-31 20:30:05 [INFO]: Change: available | Delta: -1
2025-07-31 20:30:05 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596679 and user_id = 14409 
2025-07-31 20:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489388 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:30:05 [INFO]: updateIdsQuantity -> ["77489388"]
2025-07-31 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-07-31 20:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77489388 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77489388 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77489388)
2025-07-31 20:30:05 [INFO]: QUANTITY Updated IDs: 77489388
2025-07-31 20:30:05 [INFO]: Successfully processed data for user 14409
2025-07-31 20:30:05 [INFO]: Execution Started
2025-07-31 20:30:05 [INFO]: Execution Finished
2025-07-31 20:40:01 [INFO]: Execution Started
2025-07-31 20:40:01 [INFO]: old server sucessfully connected
2025-07-31 20:40:01 [INFO]: sqs client sucess created
2025-07-31 20:40:02 [INFO]: Number of messages in the queue: 2
2025-07-31 20:40:02 [INFO]: item found in queue is if condition  14409
2025-07-31 20:40:02 [INFO]: item found in queue is  14409
2025-07-31 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBnnosIWrfRhmfS6YN6pCoPE8n8uKL7Y/oSJ/uceP0jzDcO+xM5Dwe37rIxKY+s2ZFGrwZPPHD013hHcf6RUM00aZFs8FEt4AvmwuNcpe8VwaNAymS5UVVI8RIJ9G29eXU+3g5MLSt+V32YsmEpQSOLFlJ2hHw2T5ipCn4HraaiuvTAaOaFBFYIEpU+aOThH8AkdZ+ExlcPjGVn0g5HrdqEgr60Wxkz2IkXSv8/CeoqQTi6lmayBkHkCgTRJKkTu1Jz9nWhJQAP8AztazZtCiVOnmB2+5HkJOzbP0Fo0578URKUvw8NBgMhNSvSRBDjQZiC1vXFn+Cu61Mu9Sd1YkiErdMDEgTmHukN7DMPOXesNY0fRLlfG8RroNCsrHR1mrexWtaAK7b0gxW3FI4+37pVbIY438uF1VLJMzF85Hrpzq2Ss/KvGGe6r9syDamJN8J
2025-07-31 20:40:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:40:03 [INFO]: item found in queue is  14409
2025-07-31 20:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBhISupfD7XnCcgFVlZ1tDaJA5IcKL7i4gYXrpOf1y1M13bpRU9+WKMj4lYwKWqIhvsFgHu2wWRK3U9FkqjXiAQOijoZ2nSbwRc+5uu51JNwvKhLlguJlgJOAM4bFFlylYmAfelN8sM52f37iFtLYC0898JaUyFzZcimgXCBK+Wfs8HkLHrJrJoJeaBpLzqiwGDyaY1Zlas8/oofBsl0aDNEI866sGel96DXDopiBSCd2zTU3yjM3IF0eakOjf1mgezUgy0hKrtRuXblnfoH+2Jky9btitiA7Xd6QvJH1tdU3q+P+eg2SQJSAWMM1ftUUNnkLu5LIgpYi4GXO/IrA6moWGD/MruJofacFCwSBzeIGixtfJzDNbyqrZ8faJGzihUWp16rxUyahAh+HszNzGaZtQHCumiw2+W8eWPHVXy7kLBGDDp5HZLwHKrWfilAhf
2025-07-31 20:40:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 20:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:40:03 [INFO]: inside itemsold and closed 14409
2025-07-31 20:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:40:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:40:05 [INFO]: Ebay item id :: 286218203111 exists in Database
2025-07-31 20:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:40:05 [INFO]: inside itemsold and closed 14409
2025-07-31 20:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:40:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:40:07 [INFO]: Ebay item id :: 305370529962 exists in Database
2025-07-31 20:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:40:07 [INFO]: in processold action queue is array    for {"44575667":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575667","ebayitemid":"286218203111","shopifyproductid":"8766506565854","variants":[{"price":"38.99","quantity":0,"weight":"2","shopifyproductid":"8766506565854","shopifyvariantid":"46158730854622","shopifyinventoryid":"48258064548062","shopifylocationid":"","product_id":"44575667","variant_id":"77468374","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44590471":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44590471","ebayitemid":"305370529962","shopifyproductid":"7897485902046","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"7897485902046","shopifyvariantid":"43726420934878","shopifyinventoryid":"45822295572702","shopifylocationid":"","product_id":"44590471","variant_id":"77483180","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:40:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:40:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:40:07 [INFO]: Shopify Inventory id 48258064548062
2025-07-31 20:40:07 [INFO]: Shopify Location id 58450641063
2025-07-31 20:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:40: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-07-31 20:40:07 [INFO]: Change: available | Delta: -1
2025-07-31 20:40:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575667 and user_id = 14409 
2025-07-31 20:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468374 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:40:07 [INFO]: Shopify Inventory id 45822295572702
2025-07-31 20:40:07 [INFO]: Shopify Location id 58450641063
2025-07-31 20:40:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:40:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:40: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-07-31 20:40:07 [INFO]: Change: available | Delta: -1
2025-07-31 20:40:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:40:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:40:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44590471 and user_id = 14409 
2025-07-31 20:40:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77483180 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:40:07 [INFO]: updateIdsQuantity -> ["77468374","77483180"]
2025-07-31 20:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 20:40:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77468374 THEN 0 WHEN id = 77483180 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77468374 THEN 0 WHEN id = 77483180 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77468374,77483180)
2025-07-31 20:40:07 [INFO]: QUANTITY Updated IDs: 77468374, 77483180
2025-07-31 20:40:07 [INFO]: Successfully processed data for user 14409
2025-07-31 20:40:07 [INFO]: Execution Started
2025-07-31 20:40:07 [INFO]: Execution Finished
2025-07-31 20:50:01 [INFO]: Execution Started
2025-07-31 20:50:01 [INFO]: old server sucessfully connected
2025-07-31 20:50:01 [INFO]: sqs client sucess created
2025-07-31 20:50:02 [INFO]: Number of messages in the queue: 2
2025-07-31 20:50:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:50:03 [INFO]: item found in queue is  14409
2025-07-31 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB9Abm6EBCzSn1C7Xxz/51+9PG8tZOCzJJuOuBdw3wj+5MVSgFWALwtCQ3z7Lv4DFmkNu/SolSFlbdyI6nQvZ+mZ9nb/HUSQvmB+/BSgaUyMNjOsD0Z1DK8etLs6dWK8geo5O36ICiUhDWDhc2wXzCrj9r5MOPmpf2xjdgQk58BocG1qAfRvn3I03151sDV64wWuDte/xyH7QnaDtun1A6kDPU5jg4wSAf0w7RPHvsSEZvB79lvfAZdhhspyS55gdn954hgXjmIJ20RiY+fwr23KF0Zy2FSSd2T7YbHL7qRo3U0sEMmlMfDgK3OemCy5MruXO4hYVJnIUFlgn09sj/hWBoD8iJbqS7Jsk2DJ9MAE6qyviFkgJkd+8yXB7SrBnAd85ho2hjSUV7539/8pytfzNAE8XT7eEgjP9AQVqOx122fyzWgmJLgxgL+3QZpHn0
2025-07-31 20:50:03 [INFO]: item found in queue is if condition  14409
2025-07-31 20:50:03 [INFO]: item found in queue is  14409
2025-07-31 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB604rT6sNhxmUZD+X1UBLNmYHtC3pOOb5JfeLDqZpDzCE/mNjAvNaLxWRLo2zK1SLEC5kYeKFnfhzlHhoIsmXyGIfilInO5K6vXORkMB441LNmvbR0oihPZYoQARBh51sldcBg/v02TdAun0p0ASWmnTvfBkjtyQ7tcPau+EO7Y0FyNhbbNFj6fZv/GIzhAlJgeZwOLFkr/sHZpWMKGIeGU1gIT8VqeqQxgERY+OtAjdmLmAoVjPHPlCOvq748Fr3I1NO7qu5UsUeJ51oCpaEmb83hF+9cNL2kZMJleAVaTJPzb5xzWQJAgAmEjkqc8j6NIPK/LmWxFozDZEpHygZr1OQSO66CV9ndM2ksnSO2GCFdSvYS5Fk9tD4JuWqzr66Zt8jNXElSintDBLubKKqAJa+17wdWT39UpB3YqZ+dQZ6WeHNTuTdg9JDm2ddHqkS
2025-07-31 20:50:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 20:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 20:50:03 [INFO]: inside itemsold and closed 14409
2025-07-31 20:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:50:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:50:05 [INFO]: Ebay item id :: 305462624595 exists in Database
2025-07-31 20:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:50:05 [INFO]: inside itemsold and closed 14409
2025-07-31 20:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 20:50:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 20:50:07 [INFO]: Ebay item id :: 285804507110 exists in Database
2025-07-31 20:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 20:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 20:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 20:50:07 [INFO]: in processold action queue is array    for {"44582075":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582075","ebayitemid":"305462624595","shopifyproductid":"8331920638174","variants":[{"price":"36.99","quantity":0,"weight":"2","shopifyproductid":"8331920638174","shopifyvariantid":"44945059381470","shopifyinventoryid":"47042839380190","shopifylocationid":"","product_id":"44582075","variant_id":"77474784","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44563175":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44563175","ebayitemid":"285804507110","shopifyproductid":"8379316142302","variants":[{"price":"35.99","quantity":0,"weight":"2","shopifyproductid":"8379316142302","shopifyvariantid":"45098820698334","shopifyinventoryid":"47196683993310","shopifylocationid":"","product_id":"44563175","variant_id":"77455855","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 20:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 20:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 20:50:07 [INFO]: Shopify Inventory id 47042839380190
2025-07-31 20:50:07 [INFO]: Shopify Location id 58450641063
2025-07-31 20:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20: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-07-31 20:50:07 [INFO]: Change: available | Delta: -1
2025-07-31 20:50:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582075 and user_id = 14409 
2025-07-31 20:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77474784 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:50:07 [INFO]: Shopify Inventory id 47196683993310
2025-07-31 20:50:07 [INFO]: Shopify Location id 58450641063
2025-07-31 20:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 20:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T20:50:08Z","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-07-31 20:50:08 [INFO]: Change: available | Delta: -1
2025-07-31 20:50:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 20:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 20:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44563175 and user_id = 14409 
2025-07-31 20:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455855 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 20:50:08 [INFO]: updateIdsQuantity -> ["77474784","77455855"]
2025-07-31 20:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 20:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77474784 THEN 0 WHEN id = 77455855 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77474784 THEN 0 WHEN id = 77455855 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77474784,77455855)
2025-07-31 20:50:08 [INFO]: QUANTITY Updated IDs: 77474784, 77455855
2025-07-31 20:50:08 [INFO]: Successfully processed data for user 14409
2025-07-31 20:50:08 [INFO]: Execution Started
2025-07-31 20:50:08 [INFO]: Execution Finished