2025-08-05 19:00:01 [INFO]: Execution Started
2025-08-05 19:00:01 [INFO]: old server sucessfully connected
2025-08-05 19:00:01 [INFO]: sqs client sucess created
2025-08-05 19:00:03 [INFO]: Number of messages in the queue: 3
2025-08-05 19:00:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:00:03 [INFO]: item found in queue is  14409
2025-08-05 19:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1P5ByQx/4cWq/gkFimovHsfAuntOVJhCS4IIzl3b3bA71fUCED1qAw1RRx0P7mdJ4vxH3SM9BXEd0sJGGq+LynAWarDaL45/snGczLO5RKEpGiYKIy7+mDnIGDOtuwz5MgG87rLwqXslB05hGORfFjkCLFxxpsXiO9kftHjB1MbHdDS81vH+PSI1EuFMVmqMNj8cRQ/GO8a7WP3qx3KA3IvIfGOWQqmIBElBtcy0tOMcqvP8+DPjPGx8QWAEge7lGMA+11lQ497FE39mWDLEtyQbg4ccH2Sc7QQOta6oVfXfeTLJ939zhKfxd97gAdexiLLpIw4MWUXqDywlUEDLKKFSVNBQWKEGKg2bYeFEEvlFbYIK/PgpzB/R9KNwgb/Ouo4+ocCOWpER7UuX/qfJKBCBafVlIW1c6quGucRmQgMPYXilBMBVVpC5wmN60kKO
2025-08-05 19:00:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:00:03 [INFO]: item found in queue is  14409
2025-08-05 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6bjZlmSe0jVRAoBv0W4SjW4DY4/QjIYosfRckr/X6vrxcgOXOWwlL2Ux0obmFsP80xED1LNsYlidIS4hRWqjan473oMfYBGzDQzvUMTCmsml938WEOIkS8QElOKiu27J09zI6R5FK+yGPudasTSN6UEbJl02zDYLXGMjmrr4NiMg3Fqg0s16Z0pzbZW8vQjLVKHpRKPHk9NWcbFmpPlAUdf5LkmEJf/xUBOwpCrfUpzUsSHUHSdcnMHF7E2vwq+KU0p8D7/JaGFtVr8bHQzFMF/kvhcuhvDQGmbjn/j1RDzm15XecGT4FhhMESB8FL3do2zXJBvdsAiQOBLCn6y5ckk6gzOZw5WyD4Jh7ZKUNoc72eNRqjhSFwC4lJSvZe9Nfs1jJqboG+h28139OrFS7hJkraA6cmQXitDeM2MsL/IzdYbP/OfmDyovnZapNUEm
2025-08-05 19:00:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:00:04 [INFO]: item found in queue is  14409
2025-08-05 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBv7d2sltUGAP2jRHqG1xvXpdoD2koUKWCZoXbhIvk74FcQmGMEqwi2XmrTo8F4JHtzyI6SV1IXuOo8ZL3Kfitmn4OseqvcbF/l82oicC2tLzbyHEAzvOLFRvgI0X6dO9XniKNY/qF4z5CTifdknizZBFqmR5jy074Go9MB+bFUMCTt60EhcpNFbMpnO7GSoGerijeQuRFv0TDIac7iI3ayM6R6XMgUhiyS6MdjD9lji9SGh4+O8KTyp+uMZcEHA9hSTe+0101X5QrWIFACw+R443hHRPOFOcVj/mI/bTGRTPc58suz8usRYz2R+qQ0yjkDz88wpx5barm9x9vpLMzClwhRwGUpcmB3dfDylKceDaP2uqjP+3n7ki0Ai6QkzjxHiCSVFhDy8F2vbTc3D+GHgpescbrgMLZFdE5oPCbfADcfExWKmj1o3EVod9bie77
2025-08-05 19:00:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 19:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 19:00:04 [INFO]: inside itemsold and closed 14409
2025-08-05 19:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:00:06 [INFO]: Ebay item id :: 335361252726 exists in Database
2025-08-05 19:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:00:06 [INFO]: inside itemsold and closed 14409
2025-08-05 19:00:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:00:07 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:00:07 [INFO]: Ebay item id :: 326397177981 exists in Database
2025-08-05 19:00:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:00:07 [INFO]: inside itemsold and closed 14409
2025-08-05 19:00:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:00:09 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:00:09 [INFO]: Ebay item id :: 335366838403 exists in Database
2025-08-05 19:00:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:00:09 [INFO]: in processold action queue is array    for {"44586838":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586838","ebayitemid":"335361252726","shopifyproductid":"8436111048926","variants":[{"price":"311.99","quantity":0,"weight":"2","shopifyproductid":"8436111048926","shopifyvariantid":"45248180945118","shopifyinventoryid":"47346096308446","shopifylocationid":"","product_id":"44586838","variant_id":"77479547","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44736506":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736506","ebayitemid":"326397177981","shopifyproductid":"8784632971486","variants":[{"price":"24.99","quantity":0,"weight":"3","shopifyproductid":"8784632971486","shopifyvariantid":"46206104207582","shopifyinventoryid":"48305925521630","shopifylocationid":"","product_id":"44736506","variant_id":"77644443","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44591736":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591736","ebayitemid":"335366838403","shopifyproductid":"8163375415518","variants":[{"price":"84.99","quantity":0,"weight":"2","shopifyproductid":"8163375415518","shopifyvariantid":"44432341827806","shopifyinventoryid":"46530058322142","shopifylocationid":"","product_id":"44591736","variant_id":"77484445","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 19:00:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 19:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:00:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:00:09 [INFO]: Shopify Inventory id 47346096308446
2025-08-05 19:00:09 [INFO]: Shopify Location id 58450641063
2025-08-05 19:00:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:00:09Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 19:00:09 [INFO]: Change: available | Delta: -1
2025-08-05 19:00:09 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586838 and user_id = 14409 
2025-08-05 19:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479547 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:00:09 [INFO]: Shopify Inventory id 48305925521630
2025-08-05 19:00:09 [INFO]: Shopify Location id 58450641063
2025-08-05 19:00:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19: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-05 19:00:10 [INFO]: Change: available | Delta: -1
2025-08-05 19:00:10 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736506 and user_id = 14409 
2025-08-05 19:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644443 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:00:10 [INFO]: Shopify Inventory id 46530058322142
2025-08-05 19:00:10 [INFO]: Shopify Location id 58450641063
2025-08-05 19:00:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:00:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:00:10Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 19:00:10 [INFO]: Change: available | Delta: -3
2025-08-05 19:00:10 [INFO]: Change: on_hand | Delta: -3
2025-08-05 19:00:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:00:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591736 and user_id = 14409 
2025-08-05 19:00:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484445 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:00:10 [INFO]: updateIdsQuantity -> ["77479547","77644443","77484445"]
2025-08-05 19:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 19:00:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77479547 THEN 0 WHEN id = 77644443 THEN 0 WHEN id = 77484445 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77479547 THEN 0 WHEN id = 77644443 THEN 0 WHEN id = 77484445 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77479547,77644443,77484445)
2025-08-05 19:00:10 [INFO]: QUANTITY Updated IDs: 77479547, 77644443, 77484445
2025-08-05 19:00:10 [INFO]: Successfully processed data for user 14409
2025-08-05 19:00:10 [INFO]: Execution Started
2025-08-05 19:00:10 [INFO]: Execution Finished
2025-08-05 19:10:01 [INFO]: Execution Started
2025-08-05 19:10:01 [INFO]: old server sucessfully connected
2025-08-05 19:10:01 [INFO]: sqs client sucess created
2025-08-05 19:10:02 [INFO]: Number of messages in the queue: 1
2025-08-05 19:10:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:10:03 [INFO]: item found in queue is  14409
2025-08-05 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBI/CatOIwNoQF7Nz2j+h9GQK6ND3mJbFGZahodnCQYLe1eii9H/V1A1FlDdtYynT+cZogn//lNHc/GuzqZ/Zpjt4aB3bZRdoMWEoaJYhERv/tXCA0rDuPokZGlr9JOBeenX2K6xeH0/x0WHUyiFTGuv9tI3oD80OpQ/sgfY4Fr3I0Sc0FaUdmj8Gj/SAuDGvxswk1v2nd2mUZqDPGs3kX4YfBe5f+reWl7691VjMQILrqKwE8//7vAw9ZxwxrnvLoyD2Suq6UcG2JpQuLUnF6KnOT2o0dpdfq4/HJHkbJE9iP+qFeMEnlxbwHVkQitET0BpfcV3E3NSz9sBctaYwggZrtxj4BXnr52bn1JFpdcGbzjvrneUN/mP4ln/HCSIvhKgzqILUjI/ohxSm2BCPmWeQP+xdcnljvCVvJ57Q5j1vmmzcTlLmnuFkChWqI5yva
2025-08-05 19:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-05 19:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 19:10:03 [INFO]: inside itemsold and closed 14409
2025-08-05 19:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:10:05 [INFO]: Ebay item id :: 335372259752 exists in Database
2025-08-05 19:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:10:05 [INFO]: in processold action queue is array    for {"44597173":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597173","ebayitemid":"335372259752","shopifyproductid":"8458885365982","variants":[{"price":"119.99","quantity":0,"weight":"2","shopifyproductid":"8458885365982","shopifyvariantid":"45299002015966","shopifyinventoryid":"47396925079774","shopifylocationid":"","product_id":"44597173","variant_id":"77489882","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 19:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 19:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:10:05 [INFO]: Shopify Inventory id 47396925079774
2025-08-05 19:10:05 [INFO]: Shopify Location id 58450641063
2025-08-05 19:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:10: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-05 19:10:05 [INFO]: Change: available | Delta: -1
2025-08-05 19:10:05 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597173 and user_id = 14409 
2025-08-05 19:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489882 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:10:05 [INFO]: updateIdsQuantity -> ["77489882"]
2025-08-05 19:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-05 19:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77489882 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77489882 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77489882)
2025-08-05 19:10:05 [INFO]: QUANTITY Updated IDs: 77489882
2025-08-05 19:10:05 [INFO]: Successfully processed data for user 14409
2025-08-05 19:10:05 [INFO]: Execution Started
2025-08-05 19:10:05 [INFO]: Execution Finished
2025-08-05 19:20:01 [INFO]: Execution Started
2025-08-05 19:20:01 [INFO]: old server sucessfully connected
2025-08-05 19:20:01 [INFO]: sqs client sucess created
2025-08-05 19:20:02 [INFO]: Number of messages in the queue: 3
2025-08-05 19:20:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:20:03 [INFO]: item found in queue is  14409
2025-08-05 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1iRUjPvm+BOCeAhWYDD4YleHuKM6W41D0fQS9zzXv/e6xCcAxbAwa/eOssimx9dnmF61t8Dcg43H++qT9peJUfy36X2HGm/gHyQzeTg5A2qj9Vethf4cNYQjSBu2dHPhIwc3i/ghE09cVBJFlYfvCn26JWCSRx07mSRkGmt1TgayeojQAuxmyLzLjf0pfCZaD7fhzuJxhksssz9kYAemik/FPHNPcO6gjHBlAGVNeZ7/SZnSfZuCrTSE94GFNBjnB/7ZDudu//6MbSK0xkjBBRdBqZfonpwwfpzjqpEMZtbeqzQS0aeJdKMQGFNCfGpBKvylK/lKJlzuXiFJACO85pUhBhHTaMk//dXGDfpY82UAVkzHVpcjCtT3MJCVM654cTYf2fpiYY65PVjGRVKR+MrLVbyNgR1vAxtp5osA94kJrfe1Tn17lut+EnHuRa60
2025-08-05 19:20:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:20:03 [INFO]: item found in queue is  14409
2025-08-05 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBMDL298bjGpyvCEtIEr6OJfZ7smfJVhqYAXTNlXYUhke+5S7mQL988Xv/Di0cOYjkSU0SdENNc2w1M9yn7fMvvQ4bcWIfIBykeoJVw0aZmjyDTaxVGQ8ci+48YbCdmCLlWV0dT26dp60em3yQ922IKGa4OJ2nOLjKqsa/2tIIcE8d8luNRh4PB2ZkO/bh4AoX/7RkZMdcuANFkS2riR42x+nm57JxLyauPOe/Z5JCIB/VN1We8tpLnryCa4jNJKopXKYSHLAm4DG99DHvI6DyixSPjstVQaMuGdG+bkFSmzsjU4aIoLX5Tbkx+1PkGu7xqA3jM1tgKwysbW2wJYSRyd3E0oiwXzJMTElsO3F+dQyYg15C7FI+cfCdTWUSrQki7uoNAuataoZSmO1e2GZZFjU8/VjaJArsG/s9AYeaGBAjUcma6ciSCcNyqGNjBNVc
2025-08-05 19:20:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:20:04 [INFO]: item found in queue is  14409
2025-08-05 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBw5WY7Icmjsz09Px4/9qBFPcq20r0vU/sWGJ63NRcvajSnkhhk4dGodD8khFEs0cNkvOot0NIvxRphZtgPTwhTM7LwpJXsEP0amyJlkBmtRJxmW7kO+Hl3dtnqMOrnZnjW6B/bNYKrQrpurGQEgdc2LUjydakHqThUPSQ5bIuKUVdrdYO3P7hDGY4I8+GxxSZ6IQ7Bmz7ETOr236A1KSZnrgI8lgg/qF2m/GRu6Ey6fkmFAYrrTYpHlGAm+/Tv7+NIm4IpPVB2RPmANQz2JS0578pBtLOIaKF3dd3X/WEZbTuIzt/NVP2Uz7DRNzOXbIX9gI0tQds+E4e7E2g5JCaMlpmp2GXP+QbNwxPwgzqZi8J6V06Gz/jQclOF5M/BN7m4mdooyyU6bzn222hJe9945majPmcyAcZs8ybP+i6rU4q2WV9d48BZH7JMji60Viz
2025-08-05 19:20:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 19:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 19:20:04 [INFO]: inside itemsold and closed 14409
2025-08-05 19:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:20:06 [INFO]: Ebay item id :: 285838185533 exists in Database
2025-08-05 19:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:20:06 [INFO]: inside itemsold and closed 14409
2025-08-05 19:20:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:20:08 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:20:08 [INFO]: Ebay item id :: 306348428829 exists in Database
2025-08-05 19:20:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:20:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 19:20:08 [INFO]: inside itemsold and closed 14409
2025-08-05 19:20:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:20:09 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:20:09 [INFO]: Ebay item id :: 285840021238 exists in Database
2025-08-05 19:20:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:20:09 [INFO]: in processold action queue is array    for {"44598034":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598034","ebayitemid":"285838185533","shopifyproductid":"7853636845790","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"7853636845790","shopifyvariantid":"43583770165470","shopifyinventoryid":"45679428927710","shopifylocationid":"","product_id":"44598034","variant_id":"77490743","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45113760":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113760","ebayitemid":"306348428829","deleted":1}},"44600119":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600119","ebayitemid":"285840021238","shopifyproductid":"8461623656670","variants":[{"price":"50.99","quantity":0,"weight":"2","shopifyproductid":"8461623656670","shopifyvariantid":"45305959973086","shopifyinventoryid":"47403884708062","shopifylocationid":"","product_id":"44600119","variant_id":"77492828","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 19:20:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 19:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:20:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:20:10 [INFO]: productIds WHich are having null productid -> [45113760]
2025-08-05 19:20:10 [INFO]: ebayItemIds WHich are not imported-> ["306348428829"]
2025-08-05 19:20:10 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 19:20:10 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 19:20:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113760)
2025-08-05 19:20:10 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 19:20:10 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 19:20:10 [INFO]: Transaction committed successfully.
2025-08-05 19:20:10 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 19:20:10 [INFO]: Shopify Inventory id 45679428927710
2025-08-05 19:20:10 [INFO]: Shopify Location id 58450641063
2025-08-05 19:20:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:20: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-05 19:20:10 [INFO]: Change: available | Delta: -1
2025-08-05 19:20:10 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598034 and user_id = 14409 
2025-08-05 19:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490743 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:20:10 [INFO]: Shopify Inventory id 47403884708062
2025-08-05 19:20:10 [INFO]: Shopify Location id 58450641063
2025-08-05 19:20:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:20:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:20: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-05 19:20:10 [INFO]: Change: available | Delta: -1
2025-08-05 19:20:10 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:20:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:20:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600119 and user_id = 14409 
2025-08-05 19:20:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492828 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:20:10 [INFO]: updateIdsQuantity -> ["77490743","77492828"]
2025-08-05 19:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-05 19:20:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77490743 THEN 0 WHEN id = 77492828 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77490743 THEN 0 WHEN id = 77492828 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77490743,77492828)
2025-08-05 19:20:10 [INFO]: QUANTITY Updated IDs: 77490743, 77492828
2025-08-05 19:20:10 [INFO]: Successfully processed data for user 14409
2025-08-05 19:20:10 [INFO]: Execution Started
2025-08-05 19:20:10 [INFO]: Execution Finished
2025-08-05 19:30:01 [INFO]: Execution Started
2025-08-05 19:30:01 [INFO]: old server sucessfully connected
2025-08-05 19:30:01 [INFO]: sqs client sucess created
2025-08-05 19:30:02 [INFO]: Number of messages in the queue: 10
2025-08-05 19:30:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:03 [INFO]: item found in queue is  14409
2025-08-05 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwRmutshGBugzW87ZtsJdEYuyGsskRPC372FxhX2EJ+Mp5zWeVXEHaV4b9fxtVvhicVKXLTNy0PxsKzv1KQuh4s+YKwcLHlxBXAI5MCC5i4Lp6P6LB1U+MmCg6AR691Q4ibbDh3+VwV/wKv6yzoREckxUA1iyaDuiqp0v02kfZAhzgpjEOXGrZRe/syYARvsX6KR/8JXd/9DERHdahCsCkHMJAk1V0BGiuzSPjWLnrnyjCbYEKbWZqhvVP6SlJnzf4A0BoWtvd24uaYVCYY/c6fBKD+cT3ujUqbO2Z4LreGHVIK6l0dcHZoWp3Uqm1itFn8mKVLHOqHHRZyge0AHEp8K267ovWpfCFTGb3J1IA3CqiN5//1nA6mlrG2NZHNm2CTodTjx5HUtfNRCE2aFwI1bLYozVGf9Yf5WzZybKc/5Kc7lGIUkHn8FrOcbTo/UF
2025-08-05 19:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:04 [INFO]: item found in queue is  14409
2025-08-05 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPcpbtYjlPRNkSjIm1di4dK8PBpmyeEyNZhiksXAErygnBJ4C+xpC+OvI62BuFhhF98GbtvoTBH3GFk1tTTbWH1do5xp3XUJrDQqa0HMpod8dIDcqg8RaWGgTDpSklPwQCUnVjGPYdm3xKRNHHD6WN+Mk0dBs5JNhDgMH9IP/ZHdItp42tlkj4yxRBzmR/DQfpH4eA3NFl0AhxKbKWIB9SkvSVYiLIIRgEVmcHv6K5/t3ArMRn8r+sR6L3TmoJIiTlNN8IVc1zffo+5zGejYeI5mAK2G1G8QytBzg/t8BCy57GJk1YQ0NPPO9M4n9j4XPhcrJYkF3CAOcCLe+JVM4BR3LhK0K3HHCv0yMs7yN82RAnOtSseZ+HR1up0okcSJtgKWNqezzZtATKySrOb9ZFdw7BVAjNEwsLifSBbfL+pURusv4pgnwEmt7LTW2nol4
2025-08-05 19:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:04 [INFO]: item found in queue is  14409
2025-08-05 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBpnJN9Y8+x4SAJ+muFSRdHlr1pN30808UKqICRTdHe3wxZWa/OYMt4uP0Xi/yzYSblxP+TDbFZgt+k7nIU8sRIkVQlZK+27LtWU9YQXRVWnXJVp2LWihL6ojldvkrzXKNv+ZZ/RlkFRarUYKCjhtNlRwN8KCcsUYrBRbLzmCN8ib6s8pGxbbtvEj+JqsL8DgDEB33Yeqr0VGagprSfuKSk6AcJjI2e8BmMXVBF+7n8kTKeoIzKIMT9IS4kwwsl2QWK03ixkH9q3ze2CcBsz4ilg+JjtomMd2THiYAo94MkNQ5Mrd9VLy9QaCe14cMoGBLbzLEUtyZyVfywZE0QsktHaRAoVNTxv6CtCjM8HGg145kCKTSRBQVVUhVV80jHcmRpknXWsXtdtlegBCwjHkgVz0zfvVPmvFYxs3EVf141DgXp0L/xSAYEQms3nFuYlMM
2025-08-05 19:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:04 [INFO]: item found in queue is  14409
2025-08-05 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBUR19I63jARnLQYJBxJGlOjbuI1uBj3lO0JlCqwk+OBALlLa2eUcQfCjohGuAAWIgu72gdpOaTipGkQeAPerqs1+oRrTqw2AsV0pAC6BPubgVIpp7QHFqW7pljU7S+NHlxbS4m272xvscvV8sQ7zE4SrFoLFKSr1tpB3AlpV3xZMUptSjXfF6zZHcKlKoEpnfI5WwJPPxGf4Bkx9rTDHa20JcpUnbS2FuCrhvhGqAD3Mnks8d5NP7W/MZsSHjj5nvfm2uiAOM36hesXuFTTxgfcDsZISbo2r32S0KjU4yia0vg43PlAr72w7zj1iLhbsUd9anN+vsDAd7YWtbN3wuskmv653ZUbMn2av7LDylABMxZ3XsdBnHTrn80OwMphW82aHYemDX/p7CYeo/TwzP85RbieeztmqyLnzqyVlgoMznTqP8u9tP01QKU/g3BEsd
2025-08-05 19:30:04 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:04 [INFO]: item found in queue is  14409
2025-08-05 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBonKv3IhOs9827suRIiZPLFMrgCOvAvorUXfYBk5n/r2FHh52bCwsYiP9wujsDEoSS6Jbs5zDM2mum/4QV9mv/sTxN4szSedoII/prNpTEiupfPs/w0hVYKNjijrrpiFGABaWAb5XyoRmxzCmBD1/bsn0MDrhdfL3F/lT6Twv8wKDqRJ9RlpgYkoNRnCX9sae1MWoYz3Nx+Y9VlVHavT6ZwWxmifbOnbswEytrnQWyJKYHetFptPJlwZSZ/sbB9TC3oLadAZH2ju7boSXomHS9U669TV8OCc0/WKEPgedrDrtLGBgjq95qAw9GQvfb7dwAGezz8szyvtPaTuKtF6Moa42zxycJbyEWSPBNkLpl5+URa3iXDCcpq8ctW+MIpxnnftcXNwgFLbbhwb6wESYMbflM6wiiatD87Bwxosn0xgpMeAY4Mm2Wbhqv5YSy39m
2025-08-05 19:30:05 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:05 [INFO]: item found in queue is  14409
2025-08-05 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBw39yqok+XzAkFOWhF3KTwbq9CIZV8bG6qiVNHPTJc9+aAf1sjd+evzkEGTWocpCkvq7buDznIFBVjQvgH0W5dU2InS0/vbmeFIBwj6xkXTSMu3jBgyet0XngM2FLxn0k33R8EL6THqGeKHh6VlZIdgNK2GKOdu8ovi9svBfzEtnuw9J/I9sOzN+8RQI7LjRHYTdLK5ySePuaQs2u/MaCAhoalpg5zijcLnka2hPvv93XLs2zZ495yWh3FLG8f7ljYg/dUUGy93ptja9OcshQlgTOu7S4F8MaRAQdgCHqhL+aMwMijTfPVg0c0+SXAVted/b515Sw46GdK0GIALdvakXHGNapaPBizX58bdjYElt0v77LWDfjruD43MtO+JvZ/hCFhnqfHXYRj4Bx4wsrSV01aavHqVHfhsLwd9rZpWDQxa5IiqbBMct/fDrmbQLW
2025-08-05 19:30:05 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:05 [INFO]: item found in queue is  14409
2025-08-05 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBz5H/G5/F0bX1crO6eB/zJEvtBhxxQcquhc+ZPvDrfMUCTbErhvCrf8cMQKFiql/gLZ7O1+TiQdya9cwQWOQyns1jPAkGbHRf0E15Lu4geq0aqo0hxZ8eE21f4jQ91fEr4t9Fmq5yQ/IT6kgD+4tYuayQhpdKD4unOm/M+ULeasgvB7aISLgeQ0JsBl6dnb8qO/udtxCLq7ip1mjFV06elbR+acqoQMbIJTK5O8NhYL+3LenPHnWsQ9R9jCF4uz66JKix201FFEv9gUo/5TTvZX2JcgyqjEW4lfvRble7tqhp6TVHaeLZ50Ae9CKbVB741G5berQeZPEi9uGXIxrCBKggRm2E0+gZnnszjAjljoj8UkKwYd5+q+OQV8hlYjGZjltDPW/0lASvHNajh+qfURd461X6T/Z3SBHjYkFpfBui8GFuqM5JfgDh6fhm2efI
2025-08-05 19:30:06 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:06 [INFO]: item found in queue is  14409
2025-08-05 19:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBH8HAvGeuAQzPbT5ugWcEsJNWy17iMLuePQgIAwS0+R1BC8742MKVJB6SOQa2Bp8l4s6IpoGFGlCv8WTdm9ZhU2RdsqbyNG32pzwAtcP1bq3V3aX/H9ifW1kc85gAj/YdHuUIHUUuTIZ+ExB/i7fs+HxNY3AQk2zKHLl2qMmvMYQKqorBMFAOO4+1SNbHXtCAOOtQouaaJX6ZX+yipZj2uh7BFZ82CH/N+FBVgaC/d7gao+/pqbnVQwD1SSD5QVh2jC5lt55V6reFlKDC1DBkR09fDXWnfXMpXNcqYha5h3ZVmDDPVYnxal3O0WOfnsVwXt56aUm42jCAEJL38pn+KEZ7g30QogV0jH/Y3yv5FgG0gFhHv7vTF8GL39fGSGfBRdmMBhh7iYH5pgLNsQ3SGuqb7+MuReHtYt4QnEP1UoUJlW0L1Lz3lzerrZdwkJTE
2025-08-05 19:30:06 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:06 [INFO]: item found in queue is  14409
2025-08-05 19:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBVj8auQzYGAZDoEAxh71ktXVd8/voIzG4miohNZnOo+X8XbYTx5o2wZRMZV+FeU7ASjL42mNEKYExGl0abYKcN0QoEkr/kiiGT7PtxgveYejiQILku8rDonJdgqJcXQI876p9vyDuvywcfJcJexuNkSj4BkEa6hXcGyNKQss7T9LMch9PR+PFd/rF3j6lB+1ohf8GjeqDfWFCCGaAmYx+U7qcpOEN2rY1aYy0NjByvGLeV5P+HaROJFSeGBnUi/zxQYb/Y5uuUKen0wK4nuPEUlbPgn80c2F2w1xMklZyaKu772+AMd1B5BW91OXM+h4ALysBZnu1GT8DryCsbe2DRexgW6RsWLRgNvX3bxYVqncCQhOpHRcNKPA4F4nrScdahOP7Stv6DqycqsQnnZKYtqnncF/LfHpKo84LRLfwKaR1+oOjuehUVRb541m0zsuA
2025-08-05 19:30:06 [INFO]: item found in queue is if condition  14409
2025-08-05 19:30:06 [INFO]: item found in queue is  14409
2025-08-05 19:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBjeEg/J+dvai6DUGIvSI9f7XXQjSs9QzEw7v5kuoJczlsIvJE1q3YaGlAIBY/zuUK9LAvX4Ris37zbict1dgXg1gUhR1el/GFFGglDau6tfAidlbwSHEaCBDUmq67XkmXs/mbkpgrXYhW3fCM61UCFW2KsgiIQl8SFKPu+njdtkuY0W3HkH1EkjWY57lCU60WxrUkkCcTn4cQqydn4n6NdPPUmqo4Cendf4pswViMZTqr+eVO7zq/CywFE6KCEDMlGnkWSRhYtdm8nWHuLdrXjRCKbp7rVlqBSHzyLf00iY953+nqisCFO/RcpunV4FS1pVHFY2KoGdaYerCzhYOd53XbU4xFh/4jEiZA1+6QfdjxLZAp+Qgec5LlZ5u03pL2evKS0YOcwxX/BkQgkFllhDmGpPZR13/55RbgWueEu2bmSENmj2QQWp/5c2kwfKML
2025-08-05 19:30:07 [INFO]: Processed 10 messages, reached the limit of 10.
2025-08-05 19:30:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 19:30:07 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:08 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:08 [INFO]: Ebay item id :: 225706583049 exists in Database
2025-08-05 19:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:08 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:10 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:10 [INFO]: Ebay item id :: 226384376023 exists in Database
2025-08-05 19:30:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:10 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:12 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:12 [INFO]: Ebay item id :: 335447270468 exists in Database
2025-08-05 19:30:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:12 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:14 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:14 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:14 [INFO]: Ebay item id :: 326701430483 exists in Database
2025-08-05 19:30:14 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 19:30:14 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:15 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:15 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:15 [INFO]: Ebay item id :: 305567880007 exists in Database
2025-08-05 19:30:15 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:15 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:17 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:17 [INFO]: Ebay item id :: 326293240005 exists in Database
2025-08-05 19:30:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:17 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:19 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:19 [INFO]: Ebay item id :: 326152291358 exists in Database
2025-08-05 19:30:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:19 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:20 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:20 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:20 [INFO]: Ebay item id :: 225773705417 exists in Database
2025-08-05 19:30:20 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:20 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:22 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:22 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:22 [INFO]: Ebay item id :: 326668107972 exists in Database
2025-08-05 19:30:22 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:22 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-05 19:30:22 [INFO]: inside itemsold and closed 14409
2025-08-05 19:30:24 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:30:24 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:30:24 [INFO]: Ebay item id :: 326415969179 exists in Database
2025-08-05 19:30:24 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:30:24 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:30:24 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:30:24 [INFO]: in processold action queue is array    for {"44733328":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733328","ebayitemid":"225706583049","shopifyproductid":"8102451282142","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8102451282142","shopifyvariantid":"44295755137246","shopifyinventoryid":"46393024512222","shopifylocationid":"","product_id":"44733328","variant_id":"77641213","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735698":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735698","ebayitemid":"226384376023","shopifyproductid":"8705742438622","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8705742438622","shopifyvariantid":"45960593375454","shopifyinventoryid":"48059263910110","shopifylocationid":"","product_id":"44735698","variant_id":"77643605","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44578854":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44578854","ebayitemid":"335447270468","shopifyproductid":"8694965371102","variants":[{"price":"245.99","quantity":0,"weight":"15","shopifyproductid":"8694965371102","shopifyvariantid":"45933660930270","shopifyinventoryid":"48032112115934","shopifylocationid":"","product_id":"44578854","variant_id":"77471561","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45289359":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45289359","ebayitemid":"326701430483","deleted":1}},"44573744":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573744","ebayitemid":"305567880007","shopifyproductid":"8486478119134","variants":[{"price":"44.99","quantity":0,"weight":"2","shopifyproductid":"8486478119134","shopifyvariantid":"45372698951902","shopifyinventoryid":"47470664581342","shopifylocationid":"","product_id":"44573744","variant_id":"77466451","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735696":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735696","ebayitemid":"326293240005","shopifyproductid":"8705779630302","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8705779630302","shopifyvariantid":"45960699838686","shopifyinventoryid":"48059370340574","shopifylocationid":"","product_id":"44735696","variant_id":"77643603","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734976":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734976","ebayitemid":"326152291358","shopifyproductid":"8696068669662","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"8696068669662","shopifyvariantid":"45936109551838","shopifyinventoryid":"48034558476510","shopifylocationid":"","product_id":"44734976","variant_id":"77642869","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44648183":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44648183","ebayitemid":"225773705417","shopifyproductid":"8129353122014","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8129353122014","shopifyvariantid":"44348558311646","shopifyinventoryid":"46446319534302","shopifylocationid":"","product_id":"44648183","variant_id":"77553372","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45185680":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45185680","ebayitemid":"326668107972","deleted":1}},"44671336":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671336","ebayitemid":"326415969179","shopifyproductid":"8792216502494","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8792216502494","shopifyvariantid":"46225339941086","shopifyinventoryid":"48325569282270","shopifylocationid":"","product_id":"44671336","variant_id":"77576556","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 19:30:24 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:30:24 [INFO]: productIds WHich are having null productid -> [45289359,45185680]
2025-08-05 19:30:24 [INFO]: ebayItemIds WHich are not imported-> ["326701430483","326668107972"]
2025-08-05 19:30:24 [INFO]: Entered in bulkUpdateProducts function
2025-08-05 19:30:24 [INFO]: Transaction started for bulkUpdateProducts
2025-08-05 19:30:24 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45289359,45185680)
2025-08-05 19:30:24 [INFO]: Query executed successfully. Affected rows: 0
2025-08-05 19:30:24 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-05 19:30:24 [INFO]: Transaction committed successfully.
2025-08-05 19:30:24 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-05 19:30:24 [INFO]: Shopify Inventory id 46393024512222
2025-08-05 19:30:24 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:24 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:25 [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-05 19:30:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733328 and user_id = 14409 
2025-08-05 19:30:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641213 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:25 [INFO]: Shopify Inventory id 48059263910110
2025-08-05 19:30:25 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:25 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:25 [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-05 19:30:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735698 and user_id = 14409 
2025-08-05 19:30:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643605 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:25 [INFO]: Shopify Inventory id 48032112115934
2025-08-05 19:30:25 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:25 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:25 [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-05 19:30:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44578854 and user_id = 14409 
2025-08-05 19:30:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471561 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:25 [INFO]: Shopify Inventory id 47470664581342
2025-08-05 19:30:25 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:25 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:25 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:30:25Z","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-05 19:30:25 [INFO]: Change: available | Delta: -1
2025-08-05 19:30:25 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:30:25 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:25 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573744 and user_id = 14409 
2025-08-05 19:30:25 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466451 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:25 [INFO]: Shopify Inventory id 48059370340574
2025-08-05 19:30:25 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:25 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:26 [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-05 19:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735696 and user_id = 14409 
2025-08-05 19:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77643603 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:26 [INFO]: Shopify Inventory id 48034558476510
2025-08-05 19:30:26 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:26 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:26 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:30:26Z","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-05 19:30:26 [INFO]: Change: available | Delta: -1
2025-08-05 19:30:26 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734976 and user_id = 14409 
2025-08-05 19:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642869 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:26 [INFO]: Shopify Inventory id 46446319534302
2025-08-05 19:30:26 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:26 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:26 [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-05 19:30:26 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:26 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44648183 and user_id = 14409 
2025-08-05 19:30:26 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77553372 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:26 [INFO]: Shopify Inventory id 48325569282270
2025-08-05 19:30:26 [INFO]: Shopify Location id 58450641063
2025-08-05 19:30:26 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:30:27 [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-05 19:30:27 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:30:27 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671336 and user_id = 14409 
2025-08-05 19:30:27 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576556 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:30:27 [INFO]: updateIdsQuantity -> ["77641213","77643605","77471561","77466451","77643603","77642869","77553372","77576556"]
2025-08-05 19:30:27 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 8. Affected rows: 8
2025-08-05 19:30:27 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77641213 THEN 0 WHEN id = 77643605 THEN 0 WHEN id = 77471561 THEN 0 WHEN id = 77466451 THEN 0 WHEN id = 77643603 THEN 0 WHEN id = 77642869 THEN 0 WHEN id = 77553372 THEN 0 WHEN id = 77576556 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77641213 THEN 0 WHEN id = 77643605 THEN 0 WHEN id = 77471561 THEN 0 WHEN id = 77466451 THEN 0 WHEN id = 77643603 THEN 0 WHEN id = 77642869 THEN 0 WHEN id = 77553372 THEN 0 WHEN id = 77576556 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77641213,77643605,77471561,77466451,77643603,77642869,77553372,77576556)
2025-08-05 19:30:27 [INFO]: QUANTITY Updated IDs: 77641213, 77643605, 77471561, 77466451, 77643603, 77642869, 77553372, 77576556
2025-08-05 19:30:27 [INFO]: Successfully processed data for user 14409
2025-08-05 19:30:27 [INFO]: Execution Started
2025-08-05 19:30:27 [INFO]: Execution Finished
2025-08-05 19:40:01 [INFO]: Execution Started
2025-08-05 19:40:01 [INFO]: old server sucessfully connected
2025-08-05 19:40:01 [INFO]: sqs client sucess created
2025-08-05 19:40:02 [INFO]: Number of messages in the queue: 3
2025-08-05 19:40:02 [INFO]: item found in queue is if condition  14409
2025-08-05 19:40:02 [INFO]: item found in queue is  14409
2025-08-05 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEB35BTukrt+UF+ekx67XCfl8NILAQCMsBiG2ZZ00IXUOLAMnntqz8MwX7+GSpB/7PDgezr2pMxbI9mQyWP94hJambZDkbtEMysFyaoNUQ9ChM8dgUhii/T7j5CYZcVuQhLD0ZYm2h46iwucMictqzfopuXpsL5j+hOBWjM761myEFs0MGEw5im0RWX45SPw3o312TjGTX/LLTdkp44mXUJxaqObSu1hzRZrQsa/U0GsKgM9XYg+9yUdt3ketfnw0zdvbIVMUOGwUUnzDLaqB/sZDg/1M/g707RVMXqhV68HY8LhJyQMH2YDDzW0UtBtaG+l3d24ipBWteaczttGkm7p5CkG2lBZmzGVXHKfaAdOPkA6uy8Qf9Cw4iTRLEVInX9RcLSH8P0CKgLk7PM9E6dNr6eCCx8qKqznzV6yjsoGsiotJs42D194GtEOmj/nmKO
2025-08-05 19:40:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:40:03 [INFO]: item found in queue is  14409
2025-08-05 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBpBTfCkQDMleN+5hlNr5VacuM5PZk9yut47aPgpsHxTLqqNvM5R5atzgaptpJcKxFliKDp/HjIUNMvVk6xen19uLss/WsfyJ3+phT9VQdvT6S5vhuFNNaEbNIu5fZzgDLFtKK39RCIHcqtu4CI3v0qGWHEsXX04uyG2civaSXMtu/2dhCjmCHMRjlLfCJWz/CJut5EBcljA+o1sy4SNKLsOVHe2086aq2KbOQL3d2t7YEvE5Mr7UK8+zRIDpZY8TI5NqSGg9Rg+EyAjwc/b4f0Pm8XLDQEfE52RHwactP8INtpANZ+1mLjjGBXMJB5JyfwzuhdmSVhzdFVkdUko/b36LMVl7PiCPzeXXgTmD2Y8OWxAepBEas3BbRaZ0PbUEsbluawv8edx1fiKbX50qUF7kxetbKE5Y0loj4wr8aPtFxFqlIEUgBrLtHdtvEFkgH
2025-08-05 19:40:03 [INFO]: item found in queue is if condition  14409
2025-08-05 19:40:03 [INFO]: item found in queue is  14409
2025-08-05 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSCqDGeKpYnL2dAkpa06GxSriX2P6lGEwL41z4M8XaUjbXFgcxlR2eOESR36tSJtL4xu5Iu/i46gSgyT9+wlizNp1ioNyo+TwWb2ntZbOAFsgJ68QkdbCvHzmG4pgNSWmTjJQKOrgAWEYOG3r5+PhesroZx9Rv6uBLvLmwHMgZ1mqQWXdyioqG0G58eQhTxSFaomDPBVO5XT0bN7qgdpydPRS+vWl3E3nMMFDi1+4rcx/oKh5kT9J58R0J4byfRyzv7BG4v1jjLZbMCU45qltbWyyEXNzc+MaTZAxmqHS/t3lppZ59wz5+u6s6MaFH58qRUMYR0m+07RYlaljAyqDeHlr4ZygJGo839aF5vWxVN8crQG8R6d4M5kpfW5JFWWfGxICKUA41H54eNl16qNJgYtYmUztrXr+gjjmNnsJJo6tYlnWg35aNz5s8jtNV0QA
2025-08-05 19:40:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-05 19:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-05 19:40:04 [INFO]: inside itemsold and closed 14409
2025-08-05 19:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:40:06 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:40:06 [INFO]: Ebay item id :: 335383435400 exists in Database
2025-08-05 19:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:40:06 [INFO]: inside itemsold and closed 14409
2025-08-05 19:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:40:07 [INFO]: Ebay item id :: 223244843491 exists in Database
2025-08-05 19:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:40:07 [INFO]: inside itemsold and closed 14409
2025-08-05 19:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-05 19:40:09 [INFO]: autolink for user_id 14409 is 1
2025-08-05 19:40:09 [INFO]: Ebay item id :: 284476057824 exists in Database
2025-08-05 19:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-05 19:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-05 19:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-05 19:40:09 [INFO]: in processold action queue is array    for {"44562430":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44562430","ebayitemid":"335383435400","shopifyproductid":"8473915785438","variants":[{"price":"71.99","quantity":0,"weight":"2","shopifyproductid":"8473915785438","shopifyvariantid":"45334826877150","shopifyinventoryid":"47432763441374","shopifylocationid":"","product_id":"44562430","variant_id":"77455110","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44667683":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44667683","ebayitemid":"223244843491","shopifyproductid":"6634129686695","variants":[{"price":"9.67","quantity":0,"weight":"0.5","shopifyproductid":"6634129686695","shopifyvariantid":"39653082202279","shopifyinventoryid":"41747725484199","shopifylocationid":"","product_id":"44667683","variant_id":"77572903","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44754537":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44754537","ebayitemid":"284476057824","shopifyproductid":"7084679790759","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7084679790759","shopifyvariantid":"41481179070631","shopifyinventoryid":"43577635831975","shopifylocationid":"","product_id":"44754537","variant_id":"77663060","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-05 19:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-05 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-05 19:40:09 [INFO]: Shopify Inventory id 47432763441374
2025-08-05 19:40:09 [INFO]: Shopify Location id 58450641063
2025-08-05 19:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:40:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:40:09Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 19:40:09 [INFO]: Change: available | Delta: -1
2025-08-05 19:40:09 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44562430 and user_id = 14409 
2025-08-05 19:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455110 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:40:09 [INFO]: Shopify Inventory id 41747725484199
2025-08-05 19:40:09 [INFO]: Shopify Location id 58450641063
2025-08-05 19:40:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:40:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T19:40:10Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-05 19:40:10 [INFO]: Change: available | Delta: -1
2025-08-05 19:40:10 [INFO]: Change: on_hand | Delta: -1
2025-08-05 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44667683 and user_id = 14409 
2025-08-05 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77572903 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:40:10 [INFO]: Shopify Inventory id 43577635831975
2025-08-05 19:40:10 [INFO]: Shopify Location id 58450641063
2025-08-05 19:40:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-05 19:40:10 [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-05 19:40:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-05 19:40:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44754537 and user_id = 14409 
2025-08-05 19:40:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77663060 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-05 19:40:10 [INFO]: updateIdsQuantity -> ["77455110","77572903","77663060"]
2025-08-05 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-05 19:40:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77455110 THEN 0 WHEN id = 77572903 THEN 0 WHEN id = 77663060 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77455110 THEN 0 WHEN id = 77572903 THEN 0 WHEN id = 77663060 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77455110,77572903,77663060)
2025-08-05 19:40:10 [INFO]: QUANTITY Updated IDs: 77455110, 77572903, 77663060
2025-08-05 19:40:10 [INFO]: Successfully processed data for user 14409
2025-08-05 19:40:10 [INFO]: Execution Started
2025-08-05 19:40:10 [INFO]: Execution Finished
2025-08-05 19:50:01 [INFO]: Execution Started
2025-08-05 19:50:01 [INFO]: old server sucessfully connected
2025-08-05 19:50:01 [INFO]: sqs client sucess created
2025-08-05 19:50:02 [INFO]: Number of messages in the queue: 0
2025-08-05 19:50:22 [INFO]: Execution Started
2025-08-05 19:50:22 [INFO]: Execution Finished