2025-08-06 10:00:02 [INFO]: Execution Started
2025-08-06 10:00:02 [INFO]: old server sucessfully connected
2025-08-06 10:00:02 [INFO]: sqs client sucess created
2025-08-06 10:00:03 [INFO]: Number of messages in the queue: 1
2025-08-06 10:00:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:00:03 [INFO]: item found in queue is  14409
2025-08-06 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBG0Ijr2tDvtVv+m0VoEJnIvPCJEK/4O62iRjnCUbuWfdEAgJSuioLJgvSIOdzkJbdS9T7osPJQFGbJ9QHrpKNsgOvSdd4KB5hQ7TuHS+BJo5Z3QuBa3F4QPv3EydTNbEeji1SH8toiDi+LF+ozh8pAoZ0xVaqVoLMMJ8VupbLRHb4FwqAPNfwbbfLAIzZkEMLqS+ujdG+hIkVZwLZqNXQPOkTKaH+bQ0sTKGBDSlwO+kGco2RuZV/ZamV9xpnhsuguPWFI/evOAS6jNeFhXc3csbGfW/C0aFaQMG5AXH1pxWRqhqyJ+O28Pe+GwTwnL9W5G+Vtgy6hGqH4HDuVmoKISKpkrirtRT/OUEGs5HrYhdl9T1u2jb1YAPJsRWhkyNdQsgcuuve2mYUsHaYruml0JQh1o76x9374CSh9+mWLwenyA1UPpeiHP+vSUtfD68a
2025-08-06 10:00:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-06 10:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:00:04 [INFO]: inside itemsold and closed 14409
2025-08-06 10:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:00:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:00:06 [INFO]: Ebay item id :: 324116976028 exists in Database
2025-08-06 10:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:00:06 [INFO]: in processold action queue is array    for {"44680296":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44680296","ebayitemid":"324116976028","shopifyproductid":"6634612719783","variants":[{"price":"19.66","quantity":0,"weight":"2","shopifyproductid":"6634612719783","shopifyvariantid":"39654728433831","shopifyinventoryid":"41749374107815","shopifylocationid":"","product_id":"44680296","variant_id":"77585516","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:00:06 [INFO]: Shopify Inventory id 41749374107815
2025-08-06 10:00:06 [INFO]: Shopify Location id 58450641063
2025-08-06 10:00:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:00:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:00:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 10:00:06 [INFO]: Change: available | Delta: -1
2025-08-06 10:00:06 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44680296 and user_id = 14409 
2025-08-06 10:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77585516 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:00:06 [INFO]: updateIdsQuantity -> ["77585516"]
2025-08-06 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-06 10:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77585516 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77585516 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77585516)
2025-08-06 10:00:06 [INFO]: QUANTITY Updated IDs: 77585516
2025-08-06 10:00:06 [INFO]: Successfully processed data for user 14409
2025-08-06 10:00:06 [INFO]: Execution Started
2025-08-06 10:00:06 [INFO]: Execution Finished
2025-08-06 10:10:01 [INFO]: Execution Started
2025-08-06 10:10:01 [INFO]: old server sucessfully connected
2025-08-06 10:10:01 [INFO]: sqs client sucess created
2025-08-06 10:10:03 [INFO]: Number of messages in the queue: 4
2025-08-06 10:10:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:10:03 [INFO]: item found in queue is  14409
2025-08-06 10:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBaT9c9d4c1jn6WxNZjthun5tlFjYco3dfNHh5dar3It9bPI4JI9NPmX1FaacBrTO/8BSqcqmkW62czYkjvcrsWZW6VgtF8JC1m/cyifjEa6+dTLmEtJSzeVWQReq2Mlve6dkskFkHFlvPrn2cMWHm/Y7IaJtwlbhaluGgmTMUrpA7tE64QeuzkZ/k3noa7Bkk/ODlSAVqkS1Wx+o1WQSz2yKRNIM0nj5TnB1GAcS/yqVzhMRW8wB72P3R6z6thX7BTR1sHJhN1RHNrc4+d5Eppzy8KGfgw4F2tX6egD5tn6c2qnwAyzqvT/Zq7eTGtl8rfl/6vZwaOzRBYcKoBcEreUZVqbimRGJu3FhZJYiQEJIZTIchWUM4AfeV3Ugxs73/rXC6SVG0JyGtdBz9u3lEVRQXXga1Fm02OhwOm7RFOskNXdcBHx6foCxKUoC1FwQ0
2025-08-06 10:10:04 [INFO]: item found in queue is if condition  14409
2025-08-06 10:10:04 [INFO]: item found in queue is  14409
2025-08-06 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBIxzEw/auADPYcx87EJuMfe2GHS9Y0DpIr9hhxxrhBB5ApVMilXEcpEqEHLR3uIqB6LLM9ov0sit9VBzlUIFglnkReskPw5KPSCq3wSuh0sr+FkOIXSF5K5oc3k7VOPvYCpk+xTtN+SpLPGDqSo9WNCEKXPA0GMk6w9jKLVuEOpLMttKITJ4AemInXDS4SplYm4H11F0FosNXIvI5d8WzQrXVI+kxuv/Tux2vXaP3LxNrV468zbUehqcSvaL4hHbxs/HdUiE/UkNfvxo81jGp9iY6b11/+873xGmpXXF/VwsPB2G0Z5JSj/W/AuoQFiOPlLlkipBTd4B71lrl525KqGP4Jj4ySHDwHSSA+2Wv/yK0x/u7x3ZdnsRjwfYBSL3M6v4FyDkUvxkpp61dA7PUZ+OApUl56inMkXcduc9JYgRF7F+8b10MgVzeGOqBl0to
2025-08-06 10:10:04 [INFO]: item found in queue is if condition  14409
2025-08-06 10:10:04 [INFO]: item found in queue is  14409
2025-08-06 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB3nY3yzVcPRd3qsndpp4JAkL8dUXC7/dyIcN7CWMyiH2wuuUHOvG7vxditD+dR1vz7sALOmT/d4SYE8fUiJNY7NQxGQbDNsYEXKyxsOFELLCXLAHZIdNOPSa/tasQ/bUPcRwp7bKnmCKJcd+6kayU263vjZHBsXTo2VjtWnwby3tc/lve7Q3R12K07AiHFRjUnqlbNP0GI5Np1t6VOVMfWXg4VEZatGKm+Bfwmq1r7bHR4fZ/iHSEn/Vpywwd6Pcv7MIdhHP8y1pIeC1cImx00sTrkpqNjPWd2i0DmSPQcOOtO+tlt0eJRbz49RGKM8eGaylBHkblY9Mks6QEX2AWVaPBJE96FKaaxYItVYxsuQN1D4v9mF329nxEQKrhQi5zZLasH++/jEMthFfQFhr644ZCGiVNqyvbei5i+w6kZTERag35RayUJPFZDpi2T2MR
2025-08-06 10:10:05 [INFO]: item found in queue is if condition  14409
2025-08-06 10:10:05 [INFO]: item found in queue is  14409
2025-08-06 10:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBruTHxJvzMUhgSLOKv+XV7Mn9xALEn4+c6bBnMHY4qkwRs+rWcX4Z61UC3tvBH5QCjXyno5eZAPgRaowrudCLDZQpTRKqQi0eB78YB6QKgT+P0DNK2GyC1kUebBNe47oJQ1QBvGuofWlRiyuEKX8lR85AE+/Oy2F9j1Qu4K2HpmaB2gNB6+6nGNKfgbeGP3VUPsfKbN0ZSUGjcN3f/Fq59iKWrolj0/4i0JsnbkLiICIggJXRkb6RoKUod6SFJcSyzv0R2LEyeK7csRyqS/J2kXwhNtDVT5m5ylVuevNTH0CNmj3es66Pg3G2l1IEmoD3UyR6JC2/icheigImSB5pSgBFR2lHxJQQsvRY/fnW0LyDrynC2unxaL+zzjFk5id+pURsrKnHt2UStDwJ0ICthhWGysprrjbBAJHi5wJEARSGhaX3LK7Qllghyl227877
2025-08-06 10:10:05 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 10:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:10:05 [INFO]: inside itemsold and closed 14409
2025-08-06 10:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:10:07 [INFO]: Ebay item id :: 226175979760 exists in Database
2025-08-06 10:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:10:07 [INFO]: inside itemsold and closed 14409
2025-08-06 10:10:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:10:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:10:09 [INFO]: Ebay item id :: 325868142097 exists in Database
2025-08-06 10:10:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:10:09 [INFO]: inside itemsold and closed 14409
2025-08-06 10:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:10:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:10:10 [INFO]: Ebay item id :: 326040452013 exists in Database
2025-08-06 10:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:10:10 [INFO]: inside itemsold and closed 14409
2025-08-06 10:10:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:10:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:10:12 [INFO]: Ebay item id :: 325868142097 exists in Database
2025-08-06 10:10:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:10:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:10:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:10:12 [INFO]: in processold action queue is array    for {"44734926":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734926","ebayitemid":"226175979760","shopifyproductid":"8334576681182","variants":[{"price":"14.99","quantity":0,"weight":"0.75","shopifyproductid":"8334576681182","shopifyvariantid":"44959580782814","shopifyinventoryid":"47057363730654","shopifylocationid":"","product_id":"44734926","variant_id":"77642819","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688340":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688340","ebayitemid":"325868142097","shopifyproductid":"8179105562846","variants":[{"price":"33.99","quantity":0,"weight":"1","shopifyproductid":"8179105562846","shopifyvariantid":"44464745054430","shopifyinventoryid":"46562673393886","shopifylocationid":"","product_id":"44688340","variant_id":"77593586","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734379":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734379","ebayitemid":"326040452013","shopifyproductid":"8925402857694","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8925402857694","shopifyvariantid":"46835457589470","shopifyinventoryid":"48933945344222","shopifylocationid":"58450641063","product_id":"44734379","variant_id":"77642272","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:10:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:10:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:10:12 [INFO]: Shopify Inventory id 47057363730654
2025-08-06 10:10:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:10:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:10:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:10:12Z","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-06 10:10:12 [INFO]: Change: available | Delta: -1
2025-08-06 10:10:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:10:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:10:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734926 and user_id = 14409 
2025-08-06 10:10:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642819 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:10:12 [INFO]: Shopify Inventory id 46562673393886
2025-08-06 10:10:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:10:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:10:12Z","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-06 10:10:13 [INFO]: Change: available | Delta: -1
2025-08-06 10:10:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688340 and user_id = 14409 
2025-08-06 10:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593586 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:10:13 [INFO]: Shopify Inventory id 48933945344222
2025-08-06 10:10:13 [INFO]: Shopify Location id 58450641063
2025-08-06 10:10:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:10:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:10:13Z","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-06 10:10:13 [INFO]: Change: available | Delta: -1
2025-08-06 10:10:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:10:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:10:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734379 and user_id = 14409 
2025-08-06 10:10:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642272 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:10:13 [INFO]: updateIdsQuantity -> ["77642819","77593586","77642272"]
2025-08-06 10:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 10:10:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77642819 THEN 0 WHEN id = 77593586 THEN 0 WHEN id = 77642272 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77642819 THEN 0 WHEN id = 77593586 THEN 0 WHEN id = 77642272 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77642819,77593586,77642272)
2025-08-06 10:10:13 [INFO]: QUANTITY Updated IDs: 77642819, 77593586, 77642272
2025-08-06 10:10:13 [INFO]: Successfully processed data for user 14409
2025-08-06 10:10:13 [INFO]: Execution Started
2025-08-06 10:10:13 [INFO]: Execution Finished
2025-08-06 10:20:01 [INFO]: Execution Started
2025-08-06 10:20:01 [INFO]: old server sucessfully connected
2025-08-06 10:20:01 [INFO]: sqs client sucess created
2025-08-06 10:20:03 [INFO]: Number of messages in the queue: 4
2025-08-06 10:20:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:20:03 [INFO]: item found in queue is  14409
2025-08-06 10:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBAYf5g+5SNcuTRJCf1CgtF70V/gicXh6ncvmPfQ9dz34chEo9Sl0FEZyqlDkCbSkRcNtWaY5dkYOw1yplv1XEKmv0tA3qBhyf8N+sxaOIrZ/72/29eQnTDO+GHH/VsNA6O18MPN1IKf+0MBUFGPasDdVUsimUqif07TFMYFJUdjV1X6L1nqQd7tdQJwXzKXlkYhegA7HOVylWPDW1V6KbitQFk7cELgccMv3twtlei5s1tDtubDJ+x6Ze7KCvxYLsLLBq471mZVT0yvcnmaQxtANsBrzE2z0Y8nCdntVA9MivR+RVifqq3OGN2ut79TCZaG5Fy8B2mj0P9QY4/LtojXDXsv+nXlx7yWYuoVxrjWn9ycfUypp3iv/L4LEJMSSROIlZ6FHGkVFlSX9KCRd2LEitn1r9br0rX5gDDJDdU7Nj7Q0OdvwgXrzzI/ddJxFT
2025-08-06 10:20:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:20:03 [INFO]: item found in queue is  14409
2025-08-06 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSJXfZjOOW8d/LOgzWbGa93CE4XtwP1RjQSpFztKpeJBDhWdVUTEs0GLK1sZ3jl5F8pgXEpSMhXBYEyhpWOANsrJK0QQjcXlEq5yBgBcjtMkZIH5Mkwf678+lQxwQJB8gtEwQgsKPbCM1ulLwY9dyZb3vV4myeHavW4v1UhbFdSVUc5n77MOe69VHJ7lX+CEXqh/684DqaHWY/YvgKeONTj+MMlaAG9OUP8+2mAu6SKKYCOTxywlAoqNEcGVv/x3qfCn+kSKiUAvdigiZKHXJ0BnISNycIrLlgPnTNU9D36/4xiMeZoALRH3iiChHURrOSce31PyZIl5ShwzlGVSCZgY5XmGKiSWUhsdASgQxvs8piE+xFY2RYUl6O2UN3bRRgsWwRrcVIJeI1PJRITjMLOT4/8c07HZzEqhQUeB0RH74b0gGgnjXssQXTZA2pr28
2025-08-06 10:20:04 [INFO]: item found in queue is if condition  14409
2025-08-06 10:20:04 [INFO]: item found in queue is  14409
2025-08-06 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBcN9BcUlTyBGwJKVExBB/P0qEM7LIUMhVH5C8R1X6T/mp7TTimXjSM+i9nrrk8GDpp6VXhQGQA6j/dWa9F+kb1avUlArkE0+lgl0gfPnojsjzikMZwdDvKiQOhuFHzwF009SOH3iyAroKvF4jX2gJqxUnSPXhul3Ce46l+HOF+6ZgGBbv9qZjEzXuRkt956AVo1xUuPnphxLZqGG8yuwJZP8x5cMKp9sW9qI5xoKIDUu9xZDucBqCRLOw5JwUcB+e8uIsR4OQErFbnVG3N135+xj2MADINr683FP4YbUoE6dVodxgbsrRK373ZDR9mgLBssXWzrN+xJuTymFIdP2IcpiuohEOWPVoG8+qLIttAHHKRBo2brvkPXFcezf4drbnMRIJNZ5Y9AusmFkeoOJ/1RNxb/0WRRe/XzpbsaTC0S5U/1/Mm+8LcrZYngeYrhrS
2025-08-06 10:20:05 [INFO]: item found in queue is if condition  14409
2025-08-06 10:20:05 [INFO]: item found in queue is  14409
2025-08-06 10:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEB5fi46zFpdcxTwQsFDNrvERkXEX3RJiTw3qQzRRGTU4Ktdyfs/Fno6tEsgskxGOS2rFyKUXFgEpOd/kwIKbg0mwriH0e9FqtoqsTBEyuEUwHYklOQQ00MpIkjpaL+1msy2a0MPn45VtInUAjy+XZ2ObfH40P7C0noYRNw/EhSpdhfEc95ds2FPKMO0qhhdUyrfKk/jUlijrhgfq1BvzyBdYvAIx94Yl9Y4NOHn586GMIcoGKyjWQCwccrdze9suY8EEBcQT+IdGUWGJgur9b1oaU/gNdLEuB1rKvrEjCnM0J3+pKCYYbQzNFZBu29QNefBbqitYxyX52nUUWQ+qUj0a3Rs+EIiX+eHzqT4liMIezF7/CjuDWjG95z0lu/gATnVrf0lXMZ+ucAvUnn0b3ogVF5q7jnN7ftCqycKvdvo2F/2pPBAiMveyk0OqOw73UD
2025-08-06 10:20:05 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 10:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:20:05 [INFO]: inside itemsold and closed 14409
2025-08-06 10:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:20:06 [INFO]: Ebay item id :: 324487046356 exists in Database
2025-08-06 10:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:20:06 [INFO]: inside itemsold and closed 14409
2025-08-06 10:20:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:20:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:20:08 [INFO]: Ebay item id :: 324657592502 exists in Database
2025-08-06 10:20:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:20:08 [INFO]: inside itemsold and closed 14409
2025-08-06 10:20:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:20:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:20:10 [INFO]: Ebay item id :: 325300455388 exists in Database
2025-08-06 10:20:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:20:10 [INFO]: inside itemsold and closed 14409
2025-08-06 10:20:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:20:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:20:11 [INFO]: Ebay item id :: 224456760862 exists in Database
2025-08-06 10:20:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:20:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:20:11 [INFO]: in processold action queue is array    for {"44648447":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44648447","ebayitemid":"324487046356","shopifyproductid":"6634020241575","variants":[{"price":"19.67","quantity":0,"weight":"2","shopifyproductid":"6634020241575","shopifyvariantid":"39652693541031","shopifyinventoryid":"41747336462503","shopifylocationid":"","product_id":"44648447","variant_id":"77553636","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44729681":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44729681","ebayitemid":"324657592502","shopifyproductid":"6811353874599","variants":[{"price":"19.66","quantity":0,"weight":"2","shopifyproductid":"6811353874599","shopifyvariantid":"40245276573863","shopifyinventoryid":"42340548116647","shopifylocationid":"","product_id":"44729681","variant_id":"77637566","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44732087":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44732087","ebayitemid":"325300455388","shopifyproductid":"7756266668254","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7756266668254","shopifyvariantid":"43251753091294","shopifyinventoryid":"45346901164254","shopifylocationid":"","product_id":"44732087","variant_id":"77639972","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44729613":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44729613","ebayitemid":"224456760862","shopifyproductid":"6739808813223","variants":[{"price":"19.67","quantity":0,"weight":"2","shopifyproductid":"6739808813223","shopifyvariantid":"40055906042023","shopifyinventoryid":"42151127974055","shopifylocationid":"","product_id":"44729613","variant_id":"77637498","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:20:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:20:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:20:12 [INFO]: Shopify Inventory id 41747336462503
2025-08-06 10:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:20:12Z","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-06 10:20:12 [INFO]: Change: available | Delta: -1
2025-08-06 10:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44648447 and user_id = 14409 
2025-08-06 10:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77553636 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:20:12 [INFO]: Shopify Inventory id 42340548116647
2025-08-06 10:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:20:12Z","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-06 10:20:12 [INFO]: Change: available | Delta: -1
2025-08-06 10:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44729681 and user_id = 14409 
2025-08-06 10:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77637566 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:20:12 [INFO]: Shopify Inventory id 45346901164254
2025-08-06 10:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:20:12Z","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-06 10:20:12 [INFO]: Change: available | Delta: -1
2025-08-06 10:20:12 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44732087 and user_id = 14409 
2025-08-06 10:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639972 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:20:12 [INFO]: Shopify Inventory id 42151127974055
2025-08-06 10:20:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:20:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:20:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:20:13Z","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-06 10:20:13 [INFO]: Change: available | Delta: -1
2025-08-06 10:20:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:20:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:20:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44729613 and user_id = 14409 
2025-08-06 10:20:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77637498 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:20:13 [INFO]: updateIdsQuantity -> ["77553636","77637566","77639972","77637498"]
2025-08-06 10:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-08-06 10:20:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77553636 THEN 0 WHEN id = 77637566 THEN 0 WHEN id = 77639972 THEN 0 WHEN id = 77637498 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77553636 THEN 0 WHEN id = 77637566 THEN 0 WHEN id = 77639972 THEN 0 WHEN id = 77637498 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77553636,77637566,77639972,77637498)
2025-08-06 10:20:13 [INFO]: QUANTITY Updated IDs: 77553636, 77637566, 77639972, 77637498
2025-08-06 10:20:13 [INFO]: Successfully processed data for user 14409
2025-08-06 10:20:13 [INFO]: Execution Started
2025-08-06 10:20:13 [INFO]: Execution Finished
2025-08-06 10:30:01 [INFO]: Execution Started
2025-08-06 10:30:01 [INFO]: old server sucessfully connected
2025-08-06 10:30:01 [INFO]: sqs client sucess created
2025-08-06 10:30:02 [INFO]: Number of messages in the queue: 2
2025-08-06 10:30:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:30:03 [INFO]: item found in queue is  14409
2025-08-06 10:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBfkkdLDKQnQiMKOxSxgkCYd9KcB5BLxowxYQlV17NpHarnqah25IpzCREYJsoh0S6LPLyXfVrKcLMzTuNoJIS9/U3KmdxedXs4iXqJeY0X5pDm10bdPpcb4qmQA45zRBqhvIDN95VtoeZzoebQ/HJXfekzAdAEHGykJrAKcqAg5ndoLmCcYtM6gyzS3e0xiXfVWi55qftyG7Uo4EgccgbQOuyLN/vm//1hNiZGBZITDmKmqdGz8o7rN7Sz/3xhrZ0U56SfvRkBFfYtqoiURBN7pyO4Mmtu5eD5xxdg0M3NlZNv6xe8XHGssr+EYKumcj9RXrP98aYtrLfZCCN9zJavuIKQvP/m9Pmp0Kt0ag0J+XIePg7HzOw7dcU+1SaL4/UN8eUb0fVN9IKQx3IJBQ+jX2XBa/XxzjFkyJ58vJ3CPxx2retup2q2fWYs7FxqRcz
2025-08-06 10:30:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:30:03 [INFO]: item found in queue is  14409
2025-08-06 10:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBk/ayuNxvPNh9IiTgwn3I2KV9JvNVEwoxZat2r0WtmQO71uMbQ0VecWFnKhSp8ikzoGuWyxJDQqY19apUq146+kM66U+vUt6JZRurNUADSZjTEr6tnOkvl4j3AatK+hlpkwJCEa95PHs5gfT3EOv7RAIHEH5kIbmFLK49vymlaZt6rIQUyBNMDlw9BA7yRi48ERklH87Ri3Tab7OFOXXm/gvfyibFZJ9wktEbnICdZgcs8AhdSKZd18bgMVpLLwBXZSLWSTai20L182H3D4z8bqItFE+Ej+M+k8eonYWj31IZqJSntnQiiZIn3BC4c3fthkS911dmpSSrZTVLF7gzn7XG4ev3OQTLQGi0oQCMihYl5E+UbQWWYrizdfhT/mqzbshHTK68Ee+BXpbc0QqGi6USzUfsYuwj/WzzO9A+eZS5bS5XrfyCnrfqzy9vktQP
2025-08-06 10:30:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-06 10:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:30:03 [INFO]: inside itemsold and closed 14409
2025-08-06 10:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:30:05 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:30:05 [INFO]: Ebay item id :: 226056292217 exists in Database
2025-08-06 10:30:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:30:05 [INFO]: inside itemsold and closed 14409
2025-08-06 10:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:30:07 [INFO]: Ebay item id :: 325506088164 exists in Database
2025-08-06 10:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:30:07 [INFO]: in processold action queue is array    for {"44664896":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664896","ebayitemid":"226056292217","shopifyproductid":"8334455177438","variants":[{"price":"15.99","quantity":0,"weight":"1","shopifyproductid":"8334455177438","shopifyvariantid":"44958806081758","shopifyinventoryid":"47056589717726","shopifylocationid":"","product_id":"44664896","variant_id":"77570116","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44661955":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661955","ebayitemid":"325506088164","shopifyproductid":"7935115296990","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"7935115296990","shopifyvariantid":"43913829581022","shopifyinventoryid":"46010017415390","shopifylocationid":"","product_id":"44661955","variant_id":"77567175","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:30:07 [INFO]: Shopify Inventory id 47056589717726
2025-08-06 10:30:07 [INFO]: Shopify Location id 58450641063
2025-08-06 10:30:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:30:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 10:30:07 [INFO]: Change: available | Delta: -1
2025-08-06 10:30:07 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664896 and user_id = 14409 
2025-08-06 10:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77570116 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:30:07 [INFO]: Shopify Inventory id 46010017415390
2025-08-06 10:30:07 [INFO]: Shopify Location id 58450641063
2025-08-06 10:30:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:30:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 10:30:07 [INFO]: Change: available | Delta: -1
2025-08-06 10:30:07 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661955 and user_id = 14409 
2025-08-06 10:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77567175 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:30:07 [INFO]: updateIdsQuantity -> ["77570116","77567175"]
2025-08-06 10:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-06 10:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77570116 THEN 0 WHEN id = 77567175 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77570116 THEN 0 WHEN id = 77567175 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77570116,77567175)
2025-08-06 10:30:07 [INFO]: QUANTITY Updated IDs: 77570116, 77567175
2025-08-06 10:30:07 [INFO]: Successfully processed data for user 14409
2025-08-06 10:30:07 [INFO]: Execution Started
2025-08-06 10:30:07 [INFO]: Execution Finished
2025-08-06 10:40:01 [INFO]: Execution Started
2025-08-06 10:40:01 [INFO]: old server sucessfully connected
2025-08-06 10:40:01 [INFO]: sqs client sucess created
2025-08-06 10:40:02 [INFO]: Number of messages in the queue: 4
2025-08-06 10:40:03 [INFO]: item found in queue is if condition  14409
2025-08-06 10:40:03 [INFO]: item found in queue is  14409
2025-08-06 10:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBs6c41NUJNJkO99AhjTAz7I4n3TOQTtaLzXAZ+ooSFuCC/dHW1rlxmnb2BtGGxK94I9PvAD+9rh23kwqfrbdE6GKwDk36sWRxeio9rdmIkgVc6sJVxGv9fljbhl5J+nqbQ7KEKTUFiN4pZuYg54tfxzUN3clrHGxmbqIMS04K0WvsziMcmh5V+79Wk+PugNiPo0iYypnNMiDofqiga+afhj7SAdKgQC5lKLb+qE9HR1IyLP/Og4/q/P3FwFJRWPAWgS3uBVwUEqRrRFhci/K4PnhQg9QzM23oWbqOBfvlCOblBwyBCMDqzUG/j52ZXtSy0t2pzg343xpRY5mqaCOkUrhkknJvkkZApqA+JgSAtyMIVjU06EWf10IxLzA4eb0OqYeRHYR1mBQaIeGWa5DL0h6jNxzw3+xIWMfjj3jMDOKNMmeFOZJ4a9467ZGx6IzM
2025-08-06 10:40:04 [INFO]: item found in queue is if condition  14409
2025-08-06 10:40:04 [INFO]: item found in queue is  14409
2025-08-06 10:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB7DMRyLUuEU2bXqCHvarbn/qOxXWdFJoWYZCGApqaoPLaFhuyqgl3c4HsJUnED1vtG0JNBGbz9A3boohBzXcMwc74i3SOA4qvsEMerD/OBk1XoEC2bZTycgNThLFrOh0e7hQdCO84zGDFUeNWtWC8jAxs9nrVRjGFGSfMmYAOFbCyP1dPCc2SU4UN2+nzGm/y+FAq8QvrM5XiWDoSBU+t3WrmLTgp7zev70An8xLrXQ5G1l3FXJuAFC1sFk+NsBuvbC0gZzZBjoGmumXqVWM2NLI0sBXlNxk/P4zUyUV2QoOjZQKHGEmYCH5aOidkxuoDPFc1MZZAfdAyWSlNLq2RRgS5ptwqFcJRg5/C1mGl5+wH4urILnqDezaKDA84kXVBC7fNr30rBRcZ3R1GC2iC31pTwS4x5zXD7mXl4Is08QFPTJpl9OpjwuyBBRmdINxf
2025-08-06 10:40:05 [INFO]: item found in queue is if condition  14409
2025-08-06 10:40:05 [INFO]: item found in queue is  14409
2025-08-06 10:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEB669W9JyWL3u6YuNARNZK7ovj0k9SjXCM5hj6xOCgCrT+EmiIoGdfP6h/MhHYNJCSAkdY5Tunf89VQGDsAaK/25Y/zsuSqPDDkB7JSWR6A8XnrzLoW+nEZIFqybN+ofRfVcU4SCH0Lhcn4VxLHg/D4sruD5CEd9J9Aa2SnDi0DceRFmvTB+Q/xcPHgDuxnv6KoykuF6TW0Pqgk5FC9p5B3kN9JvrDsqHwFMbeWCY5YYSw5SHcodLo3GG15q4pljFlsrSXet+IqX4Ie5AAxkRA6u9sBNEz4DmjC74VotMV9ZDHWh6Q1ouHjSyFS7d0/9f4XeHWbo9bOokBmwU8G7nHpLHroqDAFDDxPRFG2llZJmTyzs5LNKTpEC9Hgwg9F+tsepkn5GMnnTkmA0wPkcSi2qVNo6nUn0yozEDQsr4FMsTdAnlRz+dlBmIT9EKwq6Kf
2025-08-06 10:40:06 [INFO]: item found in queue is if condition  14409
2025-08-06 10:40:06 [INFO]: item found in queue is  14409
2025-08-06 10:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBIcsmmBjiMqezzzThjTHM/iGdIQfcet04csV72Hnd3teLF4XEduwz3FM4DnwbKxVsoDDjnm3Hb62vm1xnKKlm9riDk61FUGVnBNVXNLRHN20TvCY3W3K1ggCjMnVkuhv6YJkZXiRvKUAI9gm5L27okiBaw4AeOKhWkJB051YgMUPyWk7KexnrEoFTAgyp3vhfYMNX4gZkD5XWl5RgxtJB9BBQel5iFho95IQtAE3dy74VcS+9yK/jbZP3bb+dzZRVhVxaAhm/QpRzBzmLIWKW6NE+cTNLue4MrwX0OZQfiFcPMiw+ONWm+LT5LmUI9+BO31JhV0Uqc0J4HO/iMf8ZsgyU4UbJHyWVxX2w9wZqtn6nCt2VKkmzQPejleYWQmBkBtTgIC7HypjHjvHnhdl/eMLO2ty/JBpvblxdkz3b1PppAS+8pmf4wwc9erRfwUP4
2025-08-06 10:40:06 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-06 10:40:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:40:06 [INFO]: inside itemsold and closed 14409
2025-08-06 10:40:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:40:08 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:40:08 [INFO]: Ebay item id :: 325837630735 exists in Database
2025-08-06 10:40:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:40:08 [INFO]: inside itemsold and closed 14409
2025-08-06 10:40:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:40:10 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:40:10 [INFO]: not in db for user_id 14409 and the ebayitemid226906295232
2025-08-06 10:40:10 [INFO]: inside itemsold and closed 14409
2025-08-06 10:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:40:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:40:11 [INFO]: Ebay item id :: 286524395301 exists in Database
2025-08-06 10:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:40:11 [INFO]: inside itemsold and closed 14409
2025-08-06 10:40:13 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:40:13 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:40:13 [INFO]: Ebay item id :: 225809948734 exists in Database
2025-08-06 10:40:13 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:40:13 [INFO]: in processold action queue is array    for {"44733625":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733625","ebayitemid":"325837630735","shopifyproductid":"7955783483614","variants":[{"price":"133.99","quantity":0,"weight":"2","shopifyproductid":"7955783483614","shopifyvariantid":"43996602171614","shopifyinventoryid":"46093123616990","shopifylocationid":"","product_id":"44733625","variant_id":"77641510","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44592891":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592891","ebayitemid":"286524395301","shopifyproductid":"8886649520350","variants":[{"price":"123.49","quantity":0,"weight":"10","shopifyproductid":"8886649520350","shopifyvariantid":"46643707773150","shopifyinventoryid":"48746676846814","shopifylocationid":"","product_id":"44592891","variant_id":"77485600","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44733657":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733657","ebayitemid":"225809948734","shopifyproductid":"7909789466846","variants":[{"price":"117.99","quantity":0,"weight":"2","shopifyproductid":"7909789466846","shopifyvariantid":"43788950929630","shopifyinventoryid":"45885012574430","shopifylocationid":"","product_id":"44733657","variant_id":"77641542","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:40:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:40:13 [INFO]: Shopify Inventory id 46093123616990
2025-08-06 10:40:13 [INFO]: Shopify Location id 58450641063
2025-08-06 10:40:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:40:13Z","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-06 10:40:14 [INFO]: Change: available | Delta: -1
2025-08-06 10:40:14 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733625 and user_id = 14409 
2025-08-06 10:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641510 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:40:14 [INFO]: Shopify Inventory id 48746676846814
2025-08-06 10:40:14 [INFO]: Shopify Location id 58450641063
2025-08-06 10:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-08-06 10:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592891 and user_id = 14409 
2025-08-06 10:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485600 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:40:14 [INFO]: Shopify Inventory id 45885012574430
2025-08-06 10:40:14 [INFO]: Shopify Location id 58450641063
2025-08-06 10:40:14 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:40:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 10:40:14 [INFO]: Change: available | Delta: -1
2025-08-06 10:40:14 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733657 and user_id = 14409 
2025-08-06 10:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641542 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:40:14 [INFO]: updateIdsQuantity -> ["77641510","77485600","77641542"]
2025-08-06 10:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 10:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77641510 THEN 0 WHEN id = 77485600 THEN 0 WHEN id = 77641542 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77641510 THEN 0 WHEN id = 77485600 THEN 0 WHEN id = 77641542 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77641510,77485600,77641542)
2025-08-06 10:40:14 [INFO]: QUANTITY Updated IDs: 77641510, 77485600, 77641542
2025-08-06 10:40:14 [INFO]: Successfully processed data for user 14409
2025-08-06 10:40:14 [INFO]: Execution Started
2025-08-06 10:40:14 [INFO]: Execution Finished
2025-08-06 10:50:02 [INFO]: Execution Started
2025-08-06 10:50:02 [INFO]: old server sucessfully connected
2025-08-06 10:50:02 [INFO]: sqs client sucess created
2025-08-06 10:50:04 [INFO]: Number of messages in the queue: 3
2025-08-06 10:50:05 [INFO]: item found in queue is if condition  14409
2025-08-06 10:50:05 [INFO]: item found in queue is  14409
2025-08-06 10:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEB1E3JM2C9xMETNE7b+SGKGG0Ju+zdDMpAFc9wnTCUziIcHwYkpebbCyxLdh6h9Q2+HYmL+CPrKISYWC8uoZ5S0X2H2Z9hBud1+J2M0jiJj7GB6BTllRPF/8Vb5BdMPLH34lTGNfPVMGGyksZ95r4kS+BmSRd2N4W7udc7uZXL5vBusq9ABVauZYduom33D/oIcTI2/E38VtH6pJUSHKEFlMSsFRXDnssXNcJaYfJ03Tmkg1RQO1ZlAsAIBdnmiYdBdBI/6GeUZwjFvZSnG6b7rm/ZGQGwJmeJpv8z0Jd8ZbQYENo43CKS3zRxpgSR7rtfgsMljCCIrYMb4iQV2WWms2CDpdUJBbkQ5xDSzIlgZG3EP+x4VJ3fmqoC+orIAeApc3n0pk+Y1j+76CfDlNtVPC08dkso39goxdvW3yRZZgqiiNYCzevrdt5sfAM054E7
2025-08-06 10:50:06 [INFO]: item found in queue is if condition  14409
2025-08-06 10:50:06 [INFO]: item found in queue is  14409
2025-08-06 10:50:06 [INFO]: Message deleted from the queue for receipt handle: AQEB/3DqMvAxEORfxVe7V4DzvkZ5qyCQA5+gnAjHep2SGWMsFDI8VmHH0kLxlb2lSiCphWpaiPnJOVpwZ/tSmn+elp/j45LsKWyKsBlsF3+TK1vX7iw9v4mEI8xLqVGNlTuElLzd5EbLfU24Y5IerwUQMtQiOLAdD/s/vx8JGhrC10iVj+itNjXvhuKnlG5kzN4plUGnAxBRHTzTZvrgjPPOcPElMwAnxlHlbQ9pjtvHCK+Q/qyBC2ChMPKyGbmMHOrFYXPoZu+XLAZKBLc1Lf1WzgMTkx0c0AKGIaYYkrHW1uuvWvF1ckjoFJSieK40roDZky01DxQv4wRWSos/k+KWqiSjjVq5ENGCUaBgX9JOK21pE6fI8FLHQ9VE7hcXirM3h1RvyTKCJidIC5BM2wUIPnwm0RC/UpDzWqUDoiwRZM6GDxtE+6+10o+vgYqG7rwJ
2025-08-06 10:50:07 [INFO]: item found in queue is if condition  14409
2025-08-06 10:50:07 [INFO]: item found in queue is  14409
2025-08-06 10:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBMfn88PhoMIzhPICUdtSmqaZIFRnKBDSoMv40IdDRQphnGCXC/h9h4pIt9zWOy+CBaV9BWpzOpjYpAHeo1mCz49mkVp8/zzQc+rkpB8q0lGUMPDml1aQtoVmAeBTcfzNAGCDXWA0LOW3nxXywCT5RMpFeXSP37O0xq/ongZAlEzTt99fgJL+Yk6/MBK9VdGhH4j6q4VzZwicdgnsGSVLXPgurOcaan5l0k0vFeTz8+J2VdnCh/f1Ih2RNmJ1I/2jGX4goarnrJie3267ifYSmvnH3DUTgJilndWJicYLR3lTIs74dKmNJpCUIKvNIHQgLAk+1CVPWg0DD4J1LE3vN9koLKHQ7YaB9syjE7s5tYNJuW8/NXXwqFIxm4A0WHjk+IHaVbDn8Ys7dPFi6byVjBwUZSWFWV+z+RCJXtnR2BwcK+KWRNB+B0r8+XMe3+kOm
2025-08-06 10:50:07 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-06 10:50:07 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-06 10:50:07 [INFO]: inside itemsold and closed 14409
2025-08-06 10:50:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:50:09 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:50:09 [INFO]: Ebay item id :: 225825213413 exists in Database
2025-08-06 10:50:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:50:09 [INFO]: inside itemsold and closed 14409
2025-08-06 10:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:50:11 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:50:11 [INFO]: Ebay item id :: 325860649242 exists in Database
2025-08-06 10:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:50:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:50:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:50:11 [INFO]: inside itemsold and closed 14409
2025-08-06 10:50:12 [INFO]: autodelete for user_id 14409 is 0
2025-08-06 10:50:12 [INFO]: autolink for user_id 14409 is 1
2025-08-06 10:50:12 [INFO]: Ebay item id :: 225833920419 exists in Database
2025-08-06 10:50:12 [INFO]: Item is reliested  ::  exists in Database
2025-08-06 10:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-06 10:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-06 10:50:12 [INFO]: in processold action queue is array    for {"44658542":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658542","ebayitemid":"225825213413","shopifyproductid":"8161564197086","variants":[{"price":"25.99","quantity":0,"weight":"2","shopifyproductid":"8161564197086","shopifyvariantid":"44428904595678","shopifyinventoryid":"46526660149470","shopifylocationid":"","product_id":"44658542","variant_id":"77563762","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673633":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673633","ebayitemid":"325860649242","shopifyproductid":"8166983467230","variants":[{"price":"47.99","quantity":0,"weight":"2","shopifyproductid":"8166983467230","shopifyvariantid":"44444473163998","shopifyinventoryid":"46542403502302","shopifylocationid":"","product_id":"44673633","variant_id":"77578853","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673592":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673592","ebayitemid":"225833920419","shopifyproductid":"8166919569630","variants":[{"price":"578.99","quantity":0,"weight":"2","shopifyproductid":"8166919569630","shopifyvariantid":"44444385312990","shopifyinventoryid":"46542315651294","shopifylocationid":"","product_id":"44673592","variant_id":"77578812","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-06 10:50:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-06 10:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-06 10:50:12 [INFO]: Shopify Inventory id 46526660149470
2025-08-06 10:50:12 [INFO]: Shopify Location id 58450641063
2025-08-06 10:50:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:50:13Z","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-06 10:50:13 [INFO]: Change: available | Delta: -1
2025-08-06 10:50:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658542 and user_id = 14409 
2025-08-06 10:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563762 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:50:13 [INFO]: Shopify Inventory id 46542403502302
2025-08-06 10:50:13 [INFO]: Shopify Location id 58450641063
2025-08-06 10:50:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:50:13Z","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-06 10:50:13 [INFO]: Change: available | Delta: -1
2025-08-06 10:50:13 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673633 and user_id = 14409 
2025-08-06 10:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578853 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:50:13 [INFO]: Shopify Inventory id 46542315651294
2025-08-06 10:50:13 [INFO]: Shopify Location id 58450641063
2025-08-06 10:50:13 [INFO]: QUANTITY FOR UPDATE 0
2025-08-06 10:50:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T10:50:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-06 10:50:14 [INFO]: Change: available | Delta: -1
2025-08-06 10:50:14 [INFO]: Change: on_hand | Delta: -1
2025-08-06 10:50:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-06 10:50:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673592 and user_id = 14409 
2025-08-06 10:50:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578812 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-06 10:50:14 [INFO]: updateIdsQuantity -> ["77563762","77578853","77578812"]
2025-08-06 10:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-06 10:50:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77563762 THEN 0 WHEN id = 77578853 THEN 0 WHEN id = 77578812 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77563762 THEN 0 WHEN id = 77578853 THEN 0 WHEN id = 77578812 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77563762,77578853,77578812)
2025-08-06 10:50:14 [INFO]: QUANTITY Updated IDs: 77563762, 77578853, 77578812
2025-08-06 10:50:14 [INFO]: Successfully processed data for user 14409
2025-08-06 10:50:14 [INFO]: Execution Started
2025-08-06 10:50:14 [INFO]: Execution Finished