2025-08-07 23:00:01 [INFO]: Execution Started 2025-08-07 23:00:01 [INFO]: old server sucessfully connected 2025-08-07 23:00:01 [INFO]: sqs client sucess created 2025-08-07 23:00:02 [INFO]: Number of messages in the queue: 3 2025-08-07 23:00:02 [INFO]: item found in queue is if condition 14409 2025-08-07 23:00:02 [INFO]: item found in queue is 14409 2025-08-07 23:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB8+AnOkSOm8yhcqTzPPf9nlqckGOnPuaE2azL5TYGY728r99tqhylcK/4ellBQhzxqvJ6LZ63LjvgDy5iQ2+n0+8LOTJudiga9AyMYi3FfHfQzJtiohQPUOFeqOaJheJGXitRMFHQJZ8QTqWCA6bsjC6gUHFFkHSS/3iDT7gjI3VHhS5EZ8OSi+64fQEgY3kOsMMtzJ5O3oPCkGva9iSzVVfakPiUvqxV3npeOsFIWyLPO4scyUvv78Cn7P8YsauBkl0vgcr9ru3dDPg9KUNmKiEPQ0u313YEBHWg2KFPZXnCD7UXkoXsXxEsGD+eVC5EvtY8vPXeNlL2cDAphwZCLN7mbbiLyEVgXmhB0SQhdk1BB+7LtrAkdPqrt4PdeCTcZbfb04GyM0sFK6931VbXQrO0SIUdhyNrDnttQqjQu80YDDHeErcZ9exjPztd1I0j 2025-08-07 23:00:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:00:03 [INFO]: item found in queue is 14409 2025-08-07 23:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQz4gemT7cTGBquIr5sSQmEglWWFiPQpoCk7FoikMlmu17fnMz2x0MA0gW1GSjp1YM5fDyzdVXrNBJPJ/fgsA8ted3l2uh7IZU9+52EQBsOe5Xyw0G3zKLflw1jxwePC+rDDcAOJq7LsEnpAeaQegjFGoAEzfMu2HtcF2AtyqsbKcMjsf/lUIg2Gu6Y8iWXvnIy9EIZH97HgTWa1ilx4Uum3ewuGnCxm+HvPsyheG0IuIXm0f0vSka9LxJ5p1Ky6KAKFkmi3d1ri1dc+BFOC5XePuOvIeZQSSZ2Qg5vr+XHxMKWUkxOGV/w4PuCnO+tO3XdhAf62R9GH0DOI582EDtuSQZLUH2nAMrOnWc92RvsECbMhGEvGABbOZZ4Jcd0GDh/Fdv9hHu5ar26qM1qOrJWGEp+hRbojkQEFuyY/yroU5wUEErO54zT1RiFJXIzFK 2025-08-07 23:00:23 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:00:23 [INFO]: inside itemsold and closed 14409 2025-08-07 23:00:25 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:00:25 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:00:25 [INFO]: Ebay item id :: 286706114384 exists in Database 2025-08-07 23:00:25 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:00:25 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 23:00:25 [INFO]: inside itemsold and closed 14409 2025-08-07 23:00:27 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:00:27 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:00:27 [INFO]: Ebay item id :: 305868022899 exists in Database 2025-08-07 23:00:27 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:00:27 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:00:27 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:00:27 [INFO]: in processold action queue is array for {"45221029":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45221029","ebayitemid":"286706114384","deleted":1}},"44595136":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595136","ebayitemid":"305868022899","shopifyproductid":"7635930448094","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"7635930448094","shopifyvariantid":"42741423931614","shopifyinventoryid":"44835905306846","shopifylocationid":"","product_id":"44595136","variant_id":"77487845","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 23:00:27 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:00:27 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:00:27 [INFO]: productIds WHich are having null productid -> [45221029] 2025-08-07 23:00:27 [INFO]: ebayItemIds WHich are not imported-> ["286706114384"] 2025-08-07 23:00:27 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 23:00:27 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 23:00:27 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45221029) 2025-08-07 23:00:27 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 23:00:27 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 23:00:27 [INFO]: Transaction committed successfully. 2025-08-07 23:00:27 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 23:00:27 [INFO]: Shopify Inventory id 44835905306846 2025-08-07 23:00:27 [INFO]: Shopify Location id 58450641063 2025-08-07 23:00:27 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:00:27 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:00:27Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:00:27 [INFO]: Change: available | Delta: -1 2025-08-07 23:00:27 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:00:27 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:00:27 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595136 and user_id = 14409 2025-08-07 23:00:27 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487845 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:00:27 [INFO]: updateIdsQuantity -> ["77487845"] 2025-08-07 23:00:27 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 23:00:27 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487845 THEN 0 END, quantityflag = CASE WHEN id = 77487845 THEN 0 END WHERE user_id = 14409 AND id IN (77487845) 2025-08-07 23:00:27 [INFO]: QUANTITY Updated IDs: 77487845 2025-08-07 23:00:27 [INFO]: Successfully processed data for user 14409 2025-08-07 23:00:27 [INFO]: Execution Started 2025-08-07 23:00:27 [INFO]: Execution Finished 2025-08-07 23:10:01 [INFO]: Execution Started 2025-08-07 23:10:01 [INFO]: old server sucessfully connected 2025-08-07 23:10:01 [INFO]: sqs client sucess created 2025-08-07 23:10:02 [INFO]: Number of messages in the queue: 5 2025-08-07 23:10:02 [INFO]: item found in queue is if condition 14409 2025-08-07 23:10:02 [INFO]: item found in queue is 14409 2025-08-07 23:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBkJtcx22XTsOo53ChrZNMgBQc6p/WBUO4pDTHxZVXpFlk4O6uXCTxRlwgbJpW6JCereZqfyZLqQnsWucGn40TsT2LaCtl9wO+x755R2LkALqb/lIjW2djdrw8EXe+RhkO1JyAt9fwtgvwy8GK+BjfF/vG6N6VZbe+3t8uKk17TBNNE2v4UKEfRqkvWPoTVBH6N/Zeq0ynG3XCoG4m5R4/trmF2OdjrenKsVJ6aTlOREAU+ZjppSQRU1BEsdxXZJMn2thRB1R1Frbp6fgzZUkvjHrjxn+Ladkxsh+/gzEX/YMmHSu8xlB6tkOGFJLNBJ4URErkQam6lWAd00sejAlkEdHJojw65NaTV3nR/Q6tVBMU7HTgFgHq5jUMRKG226+AyGv3+WT1qggVOsWoYJeWARjOh697FoI/ZxT1mVXwyNA2UhAya2ufefs9ZBxkGXjw 2025-08-07 23:10:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:10:03 [INFO]: item found in queue is 14409 2025-08-07 23:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlECV+i8vXoT+4Q07Do6gSx7aonKhOldJsoWmFDWDjFhqv/Y1gta/J6XZI3WHeO0vBi8flnhDgwa3laD3c8ZlDNOvyVxHIgvSinfu4Ts7Y79IhEsezdO4ILCQs7FsHxrStUzaz28RFFq4kOOfUZZ0+cIQ3UfiWgrn/PsJn7hPOR8J1I3SA1dDuudVavdJqO7cm260/ocpoVUb26p1NTLhvGNa9sVujseZ0btAEQtfbxl9s5cXREITm4aJvWKdz6DJ23Y5jh1fqJib4KW0s1ya8zeRn8beMwBCKneJmpRoqfr8fhD+Q1NiQm8YGFxGSVUPp3Aluq95yfNcDuFzimfDD17dg+5XFoTglI5yCD1/44jNuU12+J9R65RucM+0zGOWbfJjqRbHvMX6BJgfp6Dc5oNn5J2KLc4PvQTnroXIGwgZDNLvjyFuIMAVlfejplB2 2025-08-07 23:10:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:10:03 [INFO]: item found in queue is 14409 2025-08-07 23:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0H1Fow8362hdFV7PEW7iC9Y4fKxW5yP1/3U9YSFt2Ls0+Mx3MZarpkvl1sxhw+xUWBiNERq56oXDo/EjfNQN0JLwL0cTVtmAJed7tT/QxV8nU54YRUB3wcVmm4SD8rlJA0dLLvV1nf0C/OR2DePD3mHQ8I60n+xC7pOAhZJjMJMISkemXAUxq97NGAH+/zC+eB6pW0aHbkgcJQMOE4bVUtnL/G+HDu8wwKjpjV2HJC+CpQkD8MQDJnXb+NsCuJT8pNuFoLM3YIT4suGMLWmrKnzNrb+Tk6UIe7Xr4LZMgx7560WMwn3pOOskBCEqg9EMZyoH1C/tvyYqRAO9+q7c0QpYpQbvrmhRoW+DqTtHDlQC08+ToWqGodTaDijRlQ39jPpF3GhGzcawhCoXqCBuwRzYr/vIYgCEFYlOWaKgaZ8a/LQuf7oKhIiQv3dUTCm4 2025-08-07 23:10:04 [INFO]: item found in queue is if condition 14409 2025-08-07 23:10:04 [INFO]: item found in queue is 14409 2025-08-07 23:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBD/h1bVBhWLqzUAmyH1QMdymCtm7C9x94l1L5yKu+h2bF1i/SKAYNsUm+0IhgUdZ5gW0o3n2LEkjfm5CMyvn24Acl16t+ZrQavKvkanVSxgDOW1MPEFw/7EdK/bUQqrVIZcogXOzJl6q1QzFHkKqB15GKEjtpS01PBAlVlGlWokdBO3Y8Agmpl3GaPiwdLcqr8H+PzRPgfowUnHxirQV9kaPTSpRNI2hcrNSXzF2TLq/0Kz1tGjOlCuCYv6RD/ajdD2W2LQNB255wGHGWjDPOHEkp0GI3zpoEU3gQuJk7tdpWTTZ0Apy9PhC3pRVMNbAC7giHav8t9l+3ePMMz79BSlgpJjhf4V1PvQFrF5DkUR7Pw4cydsQ1C9YJPgivlkFF8DCDUfFUzvULP1aC3h6Od3JVm8pfYps4HLD7Aq6WbGZQ8Cgd4RTT8kyl2apWhdgp 2025-08-07 23:10:24 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:10:24 [INFO]: inside itemsold and closed 14409 2025-08-07 23:10:26 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:10:26 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:10:26 [INFO]: Ebay item id :: 256713139021 exists in Database 2025-08-07 23:10:26 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:10:26 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:10:26 [INFO]: inside itemsold and closed 14409 2025-08-07 23:10:28 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:10:28 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:10:28 [INFO]: Ebay item id :: 286132606181 exists in Database 2025-08-07 23:10:28 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:10:28 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:10:28 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:10:28 [INFO]: inside itemsold and closed 14409 2025-08-07 23:10:29 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:10:29 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:10:29 [INFO]: Ebay item id :: 286144730322 exists in Database 2025-08-07 23:10:29 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:10:29 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:10:29 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:10:29 [INFO]: inside itemsold and closed 14409 2025-08-07 23:10:31 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:10:31 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:10:31 [INFO]: Ebay item id :: 305868034180 exists in Database 2025-08-07 23:10:31 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:10:31 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:10:31 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:10:31 [INFO]: in processold action queue is array for {"44595155":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595155","ebayitemid":"286132606181","shopifyproductid":"6806954606759","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"6806954606759","shopifyvariantid":"40228233314471","shopifyinventoryid":"42323494142119","shopifylocationid":"","product_id":"44595155","variant_id":"77487864","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44557381":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44557381","ebayitemid":"286144730322","shopifyproductid":"8724742242526","variants":[{"price":"109.99","quantity":0,"weight":"2","shopifyproductid":"8724742242526","shopifyvariantid":"46008906744030","shopifyinventoryid":"48107348820190","shopifylocationid":"","product_id":"44557381","variant_id":"77450061","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595148":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595148","ebayitemid":"305868034180","shopifyproductid":"6823423639719","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"6823423639719","shopifyvariantid":"40305477386407","shopifyinventoryid":"42400807911591","shopifylocationid":"","product_id":"44595148","variant_id":"77487857","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 23:10:31 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:10:31 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:10:31 [INFO]: Shopify Inventory id 42323494142119 2025-08-07 23:10:31 [INFO]: Shopify Location id 58450641063 2025-08-07 23:10:31 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:10:31 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:10:31Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:10:31 [INFO]: Change: available | Delta: -1 2025-08-07 23:10:31 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:10:31 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:10:31 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595155 and user_id = 14409 2025-08-07 23:10:31 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487864 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:10:31 [INFO]: Shopify Inventory id 48107348820190 2025-08-07 23:10:31 [INFO]: Shopify Location id 58450641063 2025-08-07 23:10:31 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:10:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:10:32Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:10:32 [INFO]: Change: available | Delta: -1 2025-08-07 23:10:32 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:10:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:10:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44557381 and user_id = 14409 2025-08-07 23:10:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77450061 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:10:32 [INFO]: Shopify Inventory id 42400807911591 2025-08-07 23:10:32 [INFO]: Shopify Location id 58450641063 2025-08-07 23:10:32 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:10:32 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:10:32Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:10:32 [INFO]: Change: available | Delta: -1 2025-08-07 23:10:32 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:10:32 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:10:32 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595148 and user_id = 14409 2025-08-07 23:10:32 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487857 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:10:32 [INFO]: updateIdsQuantity -> ["77487864","77450061","77487857"] 2025-08-07 23:10:32 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-07 23:10:32 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77487864 THEN 0 WHEN id = 77450061 THEN 0 WHEN id = 77487857 THEN 0 END, quantityflag = CASE WHEN id = 77487864 THEN 0 WHEN id = 77450061 THEN 0 WHEN id = 77487857 THEN 0 END WHERE user_id = 14409 AND id IN (77487864,77450061,77487857) 2025-08-07 23:10:32 [INFO]: QUANTITY Updated IDs: 77487864, 77450061, 77487857 2025-08-07 23:10:32 [INFO]: Successfully processed data for user 14409 2025-08-07 23:10:32 [INFO]: Execution Started 2025-08-07 23:10:32 [INFO]: Execution Finished 2025-08-07 23:20:02 [INFO]: Execution Started 2025-08-07 23:20:02 [INFO]: old server sucessfully connected 2025-08-07 23:20:02 [INFO]: sqs client sucess created 2025-08-07 23:20:03 [INFO]: Number of messages in the queue: 6 2025-08-07 23:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:03 [INFO]: item found in queue is 14409 2025-08-07 23:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlx4r8RIeq1Occ8GFm3lgQ8uXL4xc3TR7cg70V8yL1v0n/mhob4SNZAFLPb2900Lec1X4IOF08DlqCseHAG3p+4neK54zUhE2EJ7rjswcl7+ZSHt90bRsxkcqCp0t2zUdTi9cR2IbkQ21sFplugkGs3Iov2Qeja+i8xxyTgzp7It2x7hoGnp/iGbXp+aEvx0hShloeWscXpdFY3ts6OQhpjspKyrxpxYJFfcwK64WKuzzLtarKCFs2VcniSyNln/dcNIDYepJyV6Mdj5v3mE2QZxEKFefM+2UHaAIj5xJmq85WutQIOOq+LAbws+Kt3ajOooB/FCk5B06abWuuagk+UmFHDXMPt9W4Kk0Huy96cESAQ0/7qFSStdMAJKbBo1ycTvqBN9Qo8/AnleMPniLcXhgMZKMociWF1AK6HCFJnfBqX5MTNxQ2inU3mVe/XLQ 2025-08-07 23:20:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:03 [INFO]: item found in queue is 14409 2025-08-07 23:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEB6MVOO8dTXQZotj5gxfwdLHY/wNwssrEqKhVD/GZQzIzDGfL3RDOlpLrBKoCibBn7j/CVnaUYvseASm4GkHbuFTcnq7m1Fm8fu70chM792QyobG2i//N9eBHSm24juM8AuN0xxppZDhnbFtE/+uMKYFFKRUKi2fUUrhnxVEjF4kEdTv2yCQnqXuwqJ2bHzjcEtCVUaA7LtwHR4iGeJtFcLsIe2Uh9PPtjoPxlgghczd616eRrAHBffjlNR9gaENUDVMoI/A4Al6sOdj0XzqZ7vLETTNSJWryfrgtkgihiUd9jxio7L6B4+L1erBdjY1S1lBf3lcwLda3Dd1pV9MvdA5hB+35FxVINleZX6Szl5geJ2RVD1WqS/a8bBLM93a30eSWITU7PS4AVGOJlY5dLb79RgeAvDZ4cqjtE3i0QoYxcyRpHJCV1/vmaIbfv34sm 2025-08-07 23:20:04 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:04 [INFO]: item found in queue is 14409 2025-08-07 23:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvTEKUxxtxO9xypQ73k6Q8DN+yOVNC2si4+jRRFCQ1ArHvGlnB1SlwIzSMDf/yAmdTLE8t1TQ0EWnAetQ31vSQdrzHuSq6fqRXirrW96/kpNCXOywWcxCJevtSDFvZR9fzecYWN6kB7HOZAsQ8KLNeMGAnzNqF5SzDIer8pfSAf/DnGHcMnjL0HDSDXwcJdKzgsWuYfTOhj+Argb7kgH/nG9OrBq1wDVnVb5FVFmO6hTsvIBOQkXurhwJAD2g+q/PZkf0OFXwdrwyhVdFkd/Qy9HnToTqcAnP9VSVtlFYr5jcWZ7UH/ODwMOWTwj68ZFAZKrZG4FY16NDZMxzrjLtijfl2yM0Pqtgx8KEvFxuO1/TVYFeYyrDgJNMYZ/82qKImY5RM8bE1ErOpZh0+C+2NunR2l7mon7OlMNnMsnL72s5dxNDWpIXLez38RydfIqK 2025-08-07 23:20:04 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:04 [INFO]: item found in queue is 14409 2025-08-07 23:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBi2Q7/rjJMa9RlNqMUady7iVUaOZ6ZDBqUHLUzE9HBvq68sjZagosvzVBRD41a7ovIuGZ4yPtRvbCkxJb/ldSCJLgi2wt5hr0LqtmXKdOp7HeQiUx6oqyqQrUh6gfBGzYTUaJ4r7Ms2iLD8/UvitzFgYSJozDchnWopseMAesDuxXya0zhgxoOUym7emtSMubXFsaG+PEy3Q35cFZDTk/j3cArVTb8oZOIBMARxFoKVgHiBAjb9DZnwShF1FTSCJRQ2ocmzsIFZtg5SSRHG2Lp1FU7FWJtNIlgZQbGMKAr3AyNymLQ7obO+ByBhZhujD1dqcNgsIW7NEd2skmZRP8rXjRjDKcZU8TshDQTeyBABUu9Ym5zH77KIt20af01PS16QBI6m41BEU9EqwJpAmdDgv+sS7nsSq0ASMjkBPO/FZoHhF3Pp3vijaeFsxoq08+ 2025-08-07 23:20:04 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:04 [INFO]: item found in queue is 14409 2025-08-07 23:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBmuvF9Gd6+qzdMG4nLXNLf+T4xPXEB8OECiZEmGY5+xQ4W6gatD+/fHUJr4ZlATm/o8tNKLvwqPjs5/CdtA27YyjSsEPWjT99O/JgNqu1mti3mqfNjCVj3zCE4Gmu8Y/B46UOCoxUV0TYPv8kXlXEOOYfKBoKQm2b7t/jZ/VqPVEFYT7XvLAJQ/u7un2shHQkxTWokz8IBf1hlZ2e1CARc84fPUYivqFVZEYgu9ninGgcqqZG/3ft8LduMXfIlAJT7NJCgb0uEqWn6veQ4OhshKYh4Ftd07CNe87HsTelsIS54XW36UO2TSVulsDX+TzIqunk1uMkCqYTLEQ7Iq3xPMxBI8sCuiRjSczo1wg9vidIzI1iPwQI2sem2yniDpFk64QTr6a2iYP7Bf6Mz8Tqp4ox6yHxD8SWGELL55htEbP1fHUArO+o2GI4j6Euocm/ 2025-08-07 23:20:05 [INFO]: item found in queue is if condition 14409 2025-08-07 23:20:05 [INFO]: item found in queue is 14409 2025-08-07 23:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEB3kJ94Jjd1K9AWr+JvyhzzPwqR2oWrngDZ/PuoMw/CSzv5FBLzr+nshMIu4daw11NDDeOoYlBOflHUWyfWMjRYCPrEUG661/Ee8rsAsTmsi9sJvOXelFpy6Qk+ROcKUvqw9USWBdL4O/Yq6T3Mf73FjYUXFJAmj2R7CTqBH2nI4BcwtpVqWle9uptKD0nrXt7gLQUdUY0l16nEdXEEdr0GF1g8qss/u+2NV5/5aZtOLKQOb4SabhfCtzr/IsBgBULzSsYVWUGVHPQB/GMbOVjWQTw2Z0mV6DPQTMisZ2he5OreTxS7FFMyjTxWeeDFQHrVnVBtwoC+ymAQrAIhSyx1qY30+SCIlc9AAXDU+fLlDgpVwwad0w3wI5/jjMVkuyusqU6SMb2TiAj+uOrHr05dJj0s9LhMR+eC4f6cmZh7976OtY9Lj6IlIybGTE+M3QB 2025-08-07 23:20:05 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-07 23:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:20:05 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:07 [INFO]: Ebay item id :: 305908354933 exists in Database 2025-08-07 23:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:07 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:08 [INFO]: Ebay item id :: 335642362857 exists in Database 2025-08-07 23:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:08 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:10 [INFO]: Ebay item id :: 335674408702 exists in Database 2025-08-07 23:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:10 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:12 [INFO]: Ebay item id :: 286163030954 exists in Database 2025-08-07 23:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:12 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:13 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:13 [INFO]: Ebay item id :: 286163175399 exists in Database 2025-08-07 23:20:13 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:13 [INFO]: inside itemsold and closed 14409 2025-08-07 23:20:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:20:15 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:20:15 [INFO]: Ebay item id :: 305908372265 exists in Database 2025-08-07 23:20:15 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:20:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:20:15 [INFO]: in processold action queue is array for {"44572579":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572579","ebayitemid":"305908354933","shopifyproductid":"7136614580391","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7136614580391","shopifyvariantid":"41673562620071","shopifyinventoryid":"43770651050151","shopifylocationid":"","product_id":"44572579","variant_id":"77465263","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44595132":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595132","ebayitemid":"335642362857","shopifyproductid":"7645377462494","variants":[{"price":"34.99","quantity":0,"weight":"2","shopifyproductid":"7645377462494","shopifyvariantid":"42771757039838","shopifyinventoryid":"44866290024670","shopifylocationid":"","product_id":"44595132","variant_id":"77487841","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572601":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572601","ebayitemid":"335674408702","shopifyproductid":"7141224874151","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7141224874151","shopifyvariantid":"41689108676775","shopifyinventoryid":"43786359799975","shopifylocationid":"","product_id":"44572601","variant_id":"77465285","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572463":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572463","ebayitemid":"286163030954","shopifyproductid":"7136146981031","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7136146981031","shopifyvariantid":"41671252541607","shopifyinventoryid":"43768317837479","shopifylocationid":"","product_id":"44572463","variant_id":"77465147","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572587":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572587","ebayitemid":"286163175399","shopifyproductid":"7141213044903","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7141213044903","shopifyvariantid":"41689069617319","shopifyinventoryid":"43786320674983","shopifylocationid":"","product_id":"44572587","variant_id":"77465271","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572592":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572592","ebayitemid":"305908372265","shopifyproductid":"7488210796766","variants":[{"price":"49.99","quantity":0,"weight":"2","shopifyproductid":"7488210796766","shopifyvariantid":"42203218936030","shopifyinventoryid":"44297287499998","shopifylocationid":"","product_id":"44572592","variant_id":"77465276","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 23:20:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:20:15 [INFO]: Shopify Inventory id 43770651050151 2025-08-07 23:20:15 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:15Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:16 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572579 and user_id = 14409 2025-08-07 23:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465263 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:16 [INFO]: Shopify Inventory id 44866290024670 2025-08-07 23:20:16 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:16 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595132 and user_id = 14409 2025-08-07 23:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77487841 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:16 [INFO]: Shopify Inventory id 43786359799975 2025-08-07 23:20:16 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:16 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572601 and user_id = 14409 2025-08-07 23:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465285 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:16 [INFO]: Shopify Inventory id 43768317837479 2025-08-07 23:20:16 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:17Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:17 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572463 and user_id = 14409 2025-08-07 23:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465147 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:17 [INFO]: Shopify Inventory id 43786320674983 2025-08-07 23:20:17 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:17Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:17 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572587 and user_id = 14409 2025-08-07 23:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465271 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:17 [INFO]: Shopify Inventory id 44297287499998 2025-08-07 23:20:17 [INFO]: Shopify Location id 58450641063 2025-08-07 23:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:20:17Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:20:17 [INFO]: Change: available | Delta: -1 2025-08-07 23:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572592 and user_id = 14409 2025-08-07 23:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465276 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:20:17 [INFO]: updateIdsQuantity -> ["77465263","77487841","77465285","77465147","77465271","77465276"] 2025-08-07 23:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6 2025-08-07 23:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77465263 THEN 0 WHEN id = 77487841 THEN 0 WHEN id = 77465285 THEN 0 WHEN id = 77465147 THEN 0 WHEN id = 77465271 THEN 0 WHEN id = 77465276 THEN 0 END, quantityflag = CASE WHEN id = 77465263 THEN 0 WHEN id = 77487841 THEN 0 WHEN id = 77465285 THEN 0 WHEN id = 77465147 THEN 0 WHEN id = 77465271 THEN 0 WHEN id = 77465276 THEN 0 END WHERE user_id = 14409 AND id IN (77465263,77487841,77465285,77465147,77465271,77465276) 2025-08-07 23:20:17 [INFO]: QUANTITY Updated IDs: 77465263, 77487841, 77465285, 77465147, 77465271, 77465276 2025-08-07 23:20:17 [INFO]: Successfully processed data for user 14409 2025-08-07 23:20:17 [INFO]: Execution Started 2025-08-07 23:20:17 [INFO]: Execution Finished 2025-08-07 23:30:01 [INFO]: Execution Started 2025-08-07 23:30:01 [INFO]: old server sucessfully connected 2025-08-07 23:30:01 [INFO]: sqs client sucess created 2025-08-07 23:30:02 [INFO]: Number of messages in the queue: 1 2025-08-07 23:30:02 [INFO]: item found in queue is if condition 14409 2025-08-07 23:30:02 [INFO]: item found in queue is 14409 2025-08-07 23:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBx07vh3M53VBGiY6PRKgt5t/S5ksEKQy3L7XCQbHl8hiQL+7A22UEJI+0p/O2cIjBD4jRbT8pYL1dbIa1z97FhXZjIbTcAW2qVJV+GkwnXZUHyRIrQbmp7sZHC4DgtrvXUsLzeNzLqkfXozGEnLWAN7Pycb7xh6RFxw3bTfjPFcyqb8ZcBYuT99FyaxHNxBiXMwRaaNYvC41q0fVkpfP0SYP3hpF5qPpJ7DKq0LaOACxDYb1tJMDbfvfTuVNQiCozZCXjTaaptBO8C0cIINLW5jfhgQVSbpsTgTfeEBF5DOChCGs5ipogKan/LfDaEgJfqa/1lhmR4Ix8OMkxKPySk1Z/U5lH9ZRkcvFK7Z0HITMhNkdOExXS0x0I5GOrkN1JSTPeaWNggPE9/v5s30nGqY0dUW+STmtgngKiHdDp9P9CxNqnoJ/EnxyGMsPXHF36 2025-08-07 23:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 23:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:30:03 [INFO]: inside itemsold and closed 14409 2025-08-07 23:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:30:05 [INFO]: Ebay item id :: 226114028159 exists in Database 2025-08-07 23:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:30:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:30:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:30:05 [INFO]: in processold action queue is array for {"44710044":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710044","ebayitemid":"226114028159","shopifyproductid":"8450213871838","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8450213871838","shopifyvariantid":"45275419836638","shopifyinventoryid":"47373338771678","shopifylocationid":"","product_id":"44710044","variant_id":"77617657","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 23:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:30:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:30:05 [INFO]: Shopify Inventory id 47373338771678 2025-08-07 23:30:05 [INFO]: Shopify Location id 58450641063 2025-08-07 23:30:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:30:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:30:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:30:05 [INFO]: Change: available | Delta: -1 2025-08-07 23:30:05 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:30:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:30:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710044 and user_id = 14409 2025-08-07 23:30:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77617657 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:30:05 [INFO]: updateIdsQuantity -> ["77617657"] 2025-08-07 23:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 23:30:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77617657 THEN 0 END, quantityflag = CASE WHEN id = 77617657 THEN 0 END WHERE user_id = 14409 AND id IN (77617657) 2025-08-07 23:30:05 [INFO]: QUANTITY Updated IDs: 77617657 2025-08-07 23:30:05 [INFO]: Successfully processed data for user 14409 2025-08-07 23:30:05 [INFO]: Execution Started 2025-08-07 23:30:05 [INFO]: Execution Finished 2025-08-07 23:40:01 [INFO]: Execution Started 2025-08-07 23:40:01 [INFO]: old server sucessfully connected 2025-08-07 23:40:01 [INFO]: sqs client sucess created 2025-08-07 23:40:02 [INFO]: Number of messages in the queue: 1 2025-08-07 23:40:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:40:03 [INFO]: item found in queue is 14409 2025-08-07 23:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSmUoEovBOVoqyjv9RuEl/+aUXvGrphAv0lT6BjxMhopIDlM/MlgXJnDJSzpg82rcOT+5qM57HGUmJWBdQapZOZ/nYvwuUKd0j7QnuBozcHOB0PwXeppsdYieW8+7XORkNjJZMoLxo7xb1Tl/+4EuqSN5MyL+W3Y0pPQ0XV5lz41dHO5/zUhRRSWRGMdPM6UHR8A3O7sUIE3ibbPtRZIK4D4Y0FzQ9ewWH+i2j79+LnN4XlnjHhQ8hBMjHqIj33MbyFBayN3c8ylS+nnwC42hxN7E3DCD+74jZSin779aABnkYvd4acFDc9NO4AeaLNYvbvir9Qmxtuu19RpM+aCipKs2K5MgChRvAdcq3TR7njfBEgENNPRKsxVwApHLkCCDZd4u6hdIqtfxpixF9i2nLHBdOBts85MuGqA3sEHKfaNXbdfdDN2agR1P7b8+imj4 2025-08-07 23:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 23:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:40:03 [INFO]: inside itemsold and closed 14409 2025-08-07 23:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:40:05 [INFO]: Ebay item id :: 286753872540 exists in Database 2025-08-07 23:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-07 23:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-07 23:40:05 [INFO]: in processold action queue is array for {"45313794":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313794","ebayitemid":"286753872540","shopifyproductid":"8983201677534","variants":[{"price":"40.00","quantity":0,"weight":"10","shopifyproductid":"8983201677534","shopifyvariantid":"47431396032734","shopifyinventoryid":"49543213678814","shopifylocationid":"58450641063","product_id":"45313794","variant_id":"78266307","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-07 23:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-07 23:40:05 [INFO]: Shopify Inventory id 49543213678814 2025-08-07 23:40:05 [INFO]: Shopify Location id 58450641063 2025-08-07 23:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-07 23:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T23:40:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-07 23:40:05 [INFO]: Change: available | Delta: -1 2025-08-07 23:40:05 [INFO]: Change: on_hand | Delta: -1 2025-08-07 23:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-07 23:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313794 and user_id = 14409 2025-08-07 23:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266307 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-07 23:40:05 [INFO]: updateIdsQuantity -> ["78266307"] 2025-08-07 23:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-07 23:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78266307 THEN 0 END, quantityflag = CASE WHEN id = 78266307 THEN 0 END WHERE user_id = 14409 AND id IN (78266307) 2025-08-07 23:40:05 [INFO]: QUANTITY Updated IDs: 78266307 2025-08-07 23:40:05 [INFO]: Successfully processed data for user 14409 2025-08-07 23:40:05 [INFO]: Execution Started 2025-08-07 23:40:05 [INFO]: Execution Finished 2025-08-07 23:50:02 [INFO]: Execution Started 2025-08-07 23:50:02 [INFO]: old server sucessfully connected 2025-08-07 23:50:02 [INFO]: sqs client sucess created 2025-08-07 23:50:03 [INFO]: Number of messages in the queue: 1 2025-08-07 23:50:03 [INFO]: item found in queue is if condition 14409 2025-08-07 23:50:03 [INFO]: item found in queue is 14409 2025-08-07 23:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEByEh90F/JB6XU15TjbijbHUO3qkIpAnB57dqljQFPw378+ebODnAOeICmNAdRo60yT8TRt46NJsvhSx0ZBMqG9TOtx9b3z8QJKiECVi1+TCwx+6Kate4oJnGWGtHuJgxK3WmAzM4jEUWW55U9jeRifXJHu9T08HYHor10tjiP6E78mP/OlCy6H2fnqc9AD6S6Mv0R6kGJahaO/U9ZC/R+iWvgAD/wVsVWJ3Up40BiTkKKDRMZDi963Rhk47Ydrd5vtrR/x9z16IQ2ikjtR9QVM0bpIDqrkGyUar4dlIhP3/ut1UJ/pbLQMSANH3azoU5nggelKQmwrWn0bj6vft2kqfKHkeUqv8zbANWfsJSHp5V0Mq1PeSLrpb9C0Md+hmWtqeMZO7nCdRACX9wm9g0kMIVOsIRZWpiYZCqenOjyE38z+Xf5Sq3TlltnVtBO8B6h 2025-08-07 23:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-07 23:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-07 23:50:03 [INFO]: inside itemsold and closed 14409 2025-08-07 23:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-07 23:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-07 23:50:05 [INFO]: Ebay item id :: 226880885905 exists in Database 2025-08-07 23:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-07 23:50:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-07 23:50:05 [INFO]: in processold action queue is array for {"45277863":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45277863","ebayitemid":"226880885905","deleted":1}}} 2025-08-07 23:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-07 23:50:05 [INFO]: productIds WHich are having null productid -> [45277863] 2025-08-07 23:50:05 [INFO]: ebayItemIds WHich are not imported-> ["226880885905"] 2025-08-07 23:50:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-07 23:50:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-07 23:50:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45277863) 2025-08-07 23:50:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-07 23:50:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-07 23:50:05 [INFO]: Transaction committed successfully. 2025-08-07 23:50:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-07 23:50:05 [INFO]: Successfully processed data for user 14409 2025-08-07 23:50:05 [INFO]: Execution Started 2025-08-07 23:50:05 [INFO]: Execution Finished