2025-08-04 17:00:02 [INFO]: Execution Started 2025-08-04 17:00:02 [INFO]: old server sucessfully connected 2025-08-04 17:00:02 [INFO]: sqs client sucess created 2025-08-04 17:00:03 [INFO]: Number of messages in the queue: 5 2025-08-04 17:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:00:03 [INFO]: item found in queue is 14409 2025-08-04 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBCmSUun4Pyi4bwory3IR4LzzK5nktU0DxfN9tvQ/A190EZw68lktJ9973/3j3dKG2tWzhKJUlarssLBekkoGSMl0bpiLx401ZkuLXv62+eWIyWBmCvqEt61x2RFwYi8KoeHFgjh/S81q2fEEHApK1D/Vm7Rqa/9+GdzMoEnKtmVfix23B0qY1n7glR6Z2yotpKBNF3AeRqVRW+86xgU1iIhyy6H9mY3fD1CkNoyd3wUrSjN0JhpnqahWtZdkUlML6XVaZslFawsSfX/fF9MN5xsDvhq2NatWYdZjCXGm6cpCvTns/71LSfpjuB4wMo0FXuixQzVgxWeUQ5zVWIt8FaiXUOZOU9f7VjTWUKoVmW5AkdIAlo5w6K75nbbA/MKCcV9u3mQqgDujlwn3vhOcLRprYpQ9I2IUkWtRGzRE31lFrg82S0cHI3XJb6w0X3KLN 2025-08-04 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:00:04 [INFO]: item found in queue is 14409 2025-08-04 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSLu/1UXG9iUkA4cfimpy94gZyrlBNyqXfc2RBZTRjFWgeCacehjRLu3IAqSArt0bBbvBD0y1F9VX7TGw245ytnhanHO8WjuLxtw+PkcKxrq6TV2RjRONl9w2S3Qu6HloqgixB0AufcCmA9z0JmlvvJWbr0Y/l2XzCe+eCD96FETDVyorrtoTEE90HQIyiLXIyMm7T8Mnd4D9rBDucjE+6637J+1oxF1ErdxfhHM0FoTWAfF7B/K/LbQ9CKwbDcJozL4NImuzC/hDbk5ceHeAP+Yf2jI+ALWnhJFAe2eD3MdIpOy7t4Sqgnocjxhwk4erSvs1w54d0LfSpYeYPPDgxQYBKqIPsrFVvkgaJJT0ehWo6MkCq1iJ0oDINhe8cHxAv/gwN23N50NAgiQk5cp3FgOY4OgnXektcfhdwdxYVaPg5qpMa41ofyJuButFcOEL 2025-08-04 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:00:04 [INFO]: item found in queue is 14409 2025-08-04 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBjXChPhYbc0mn63xbrSnG8XyJVrPOFczy9P4L9G00sL1XRcFu5bKwY9B4vJZjTvG0p/6ayVbMExY0K8VbcxWtNsxtUsLBSHJOKIbEyLrjmumYz2cIxiOH8QRJjXPSzXXfKTE7cfzKIrZpeRB8hsszOO9MzbWTqVt8C+fCCIEbQ7S6wZLU8ogVYDnFif9AVuW4MgmHwBLMxOFDq5g4bYXPv1eWzL+vGXIyXkAh6Wq7OEUCXkc+P6bicgAr8vHtcmPAG9+iTxipXKxmjdB5cxqLc+0WMcSzauWINTFGZIiaGJ39htG3Nu7BGOYc9UtvHlrxZsYN0LRyUCHVzIepEgmRqQiutSBeET18N1S4ckmdyO/CtP+0m52QP4C0MgdqXArjck57j33lesJEoWzsuuEUI0YqBWHQef5JXXiz310pMNW8n6LBKHpGahqQQcIukn/3 2025-08-04 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:00:04 [INFO]: item found in queue is 14409 2025-08-04 17:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBgfdd8HViNes2//qpzvePVl13YQARf3cojloqA6CjYffb0VqqDeQhWTBb75m3uFSTYIv5smXTJmB+lAPxmoH8ipSJCBDjzbxPTSPwe0t1W9U1FVr/jd3Mz2Q0lVZvi43OO4gsUAd5CLYAXy9mXU07ApgX9oA2J4IgKdPs9TQG8zbVy8BT5S6t6w2JLgOUdjxLYY65wiE+dT0mZRY2aZIVfmwqKyw9kHhvAytqP+/5wVlp+cqx0JBw1TFmCDyHGDx2CTu/eHzBFZa9w7801C6tlMZIXNF0tLGK5PNN/0qijChyoBjUN2nKwtuB8JGKZ+Axc/JCxgs1SLRDJNGDrciyLU5Q+Zq0n2l2fk3rgFhJgmb9lXrirOOmzRsSANeuCSNK3tmM1S5o/BKwG7zBNzEpEf/UD2mNXQ5urkfDwIK+nz+iEsdJbEFtRw+u+byQmgiy 2025-08-04 17:00:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:00:05 [INFO]: item found in queue is 14409 2025-08-04 17:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBhLAvT1PwZNllseDBl/5ar2xlkClEq3Yx540ExJ4nYlifLHrAMozFd4afvwce/dCFotkHJzm08PErzSbwZ/rG7nThEx1CieDURU6PEQ8LwpCSXbUigPvEdeBJ7hNeUSZ1qaQ1L6lkpNzwaM9rP31PZTj3ldE6WY//Ek4KfiY8cXD5gOH3/uv9pzTlLUE4VALDbudLCtGb2J6/PAvKyrL+Rz2Pjw0XxWwCezc3u7cSAK1VvqvlUpvRu90bnv45EF041/FXha3x141X75uzHDo9yrJFHyDs4Yf9dP2SFTIh5UEuQMjhQJZ3NeY8Ixs9rnjJhnIBln4/fqrlXwjczlJZr1f8kQNVJMsDHO2NZv5TnWIUs6MKSQfUPstAY9er39eTax3XWiOPfO+SrHC9Gz3WAVYTqQRxV2irxwPVTornFNJRijwiCeXrUtbRFt7zMnJk 2025-08-04 17:00:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-04 17:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:00:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:00:08 [INFO]: Ebay item id :: 305741378224 exists in Database 2025-08-04 17:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:00:08 [INFO]: inside itemsold and closed 14409 2025-08-04 17:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:00:10 [INFO]: Ebay item id :: 306300390099 exists in Database 2025-08-04 17:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:00:10 [INFO]: inside itemsold and closed 14409 2025-08-04 17:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:00:11 [INFO]: Ebay item id :: 286740395707 exists in Database 2025-08-04 17:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:00:11 [INFO]: inside itemsold and closed 14409 2025-08-04 17:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:00:13 [INFO]: Ebay item id :: 283389922375 exists in Database 2025-08-04 17:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:00:13 [INFO]: inside itemsold and closed 14409 2025-08-04 17:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:00:15 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:00:15 [INFO]: Ebay item id :: 225069638131 exists in Database 2025-08-04 17:00:15 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:00:15 [INFO]: in processold action queue is array for {"44585127":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44585127","ebayitemid":"305741378224","shopifyproductid":"8697443614942","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8697443614942","shopifyvariantid":"45939206029534","shopifyinventoryid":"48037662490846","shopifylocationid":"","product_id":"44585127","variant_id":"77477836","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44780999":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780999","ebayitemid":"306300390099","shopifyproductid":"8917821817054","variants":[{"price":"22.99","quantity":0,"weight":"0.75","shopifyproductid":"8917821817054","shopifyvariantid":"46726825443550","shopifyinventoryid":"48825314050270","shopifylocationid":"58450641063","product_id":"44780999","variant_id":"77689573","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45312880":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312880","ebayitemid":"286740395707","shopifyproductid":"8976162062558","variants":[{"price":"99.99","quantity":0,"weight":"3","shopifyproductid":"8976162062558","shopifyvariantid":"47182618919134","shopifyinventoryid":"49294455210206","shopifylocationid":"58450641063","product_id":"45312880","variant_id":"78265393","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44731945":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731945","ebayitemid":"225069638131","shopifyproductid":"7750274711774","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"7750274711774","shopifyvariantid":"43229675552990","shopifyinventoryid":"45324804948190","shopifylocationid":"","product_id":"44731945","variant_id":"77639830","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:00:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:00:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:00:15 [INFO]: Shopify Inventory id 48037662490846 2025-08-04 17:00:15 [INFO]: Shopify Location id 58450641063 2025-08-04 17:00:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:00: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-04 17:00:16 [INFO]: Change: available | Delta: -1 2025-08-04 17:00:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44585127 and user_id = 14409 2025-08-04 17:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477836 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:00:16 [INFO]: Shopify Inventory id 48825314050270 2025-08-04 17:00:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:00:16 [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-04 17:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780999 and user_id = 14409 2025-08-04 17:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689573 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:00:16 [INFO]: Shopify Inventory id 49294455210206 2025-08-04 17:00:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:00:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:00: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-04 17:00:16 [INFO]: Change: available | Delta: -1 2025-08-04 17:00:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:00:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:00:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312880 and user_id = 14409 2025-08-04 17:00:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265393 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:00:16 [INFO]: Shopify Inventory id 45324804948190 2025-08-04 17:00:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:00:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:00:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:00:16Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1983,"restoreRate":100}}}} 2025-08-04 17:00:17 [INFO]: Change: available | Delta: -1 2025-08-04 17:00:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:00:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:00:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731945 and user_id = 14409 2025-08-04 17:00:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639830 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:00:17 [INFO]: updateIdsQuantity -> ["77477836","77689573","78265393","77639830"] 2025-08-04 17:00:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 3 2025-08-04 17:00:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77477836 THEN 0 WHEN id = 77689573 THEN 0 WHEN id = 78265393 THEN 0 WHEN id = 77639830 THEN 0 END, quantityflag = CASE WHEN id = 77477836 THEN 0 WHEN id = 77689573 THEN 0 WHEN id = 78265393 THEN 0 WHEN id = 77639830 THEN 0 END WHERE user_id = 14409 AND id IN (77477836,77689573,78265393,77639830) 2025-08-04 17:00:17 [INFO]: QUANTITY Updated IDs: 77477836, 77689573, 78265393, 77639830 2025-08-04 17:00:17 [INFO]: Successfully processed data for user 14409 2025-08-04 17:00:17 [INFO]: Execution Started 2025-08-04 17:00:17 [INFO]: Execution Finished 2025-08-04 17:10:01 [INFO]: Execution Started 2025-08-04 17:10:01 [INFO]: old server sucessfully connected 2025-08-04 17:10:01 [INFO]: sqs client sucess created 2025-08-04 17:10:02 [INFO]: Number of messages in the queue: 8 2025-08-04 17:10:02 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:02 [INFO]: item found in queue is 14409 2025-08-04 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBXc//S79JuOdLNZgML/dtur2g49utgm6dYEncP3NlmnFklGRlYdP4KpnJMQK517SDDuMRdbUIW1Ny4KJJLlqYl9o5fqCDkKlrizDzbENEQIx5I4Zkv0/yDPjykJujsswqLnUe0UNdC/IjbTLpBpDBbmA87nzZoweJbtS4NIEt1b8zyMnxMqPZzlWS9ifsULqiRWd5SaONcOnRMv7h1kpSHJ5KX/OTcMm/1RmG/Twk2rFodPilGp553qYnH8K4GxxG1tkfnZfIy2u9KYFXtNSfysCTMoXrZtkGPofLALYB54cqIY8cXl1dYGOmrpDoXhXzlLt7JKK+WDMkVZR8ApIbWrVM7epPw5e8xxX4wKR8Bh4GzCPTb27tebD5VMSh+/tF8Cpjop/0DQXwBhv0rFR6xlSCB6xni+0IRyik4gDS8NcnD48/69QGWuLlGWPjD1O7 2025-08-04 17:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:03 [INFO]: item found in queue is 14409 2025-08-04 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB91R/6e5rBrDfsVYei3DNiM6iyZfbSJhtHmna5HiN0r5SZSypX+UlNI72f2l/6OtCvjpCWDQI5owTnl8wTuZNpeD3N14ER7iYG+BywdW83zab31jdsCEecCoAvqxSnG56s4h6MmloBY3WRZ8t5pRYLU0+JPSZzb3Md149ssrEK9Cu+vAxPZcbkxWooqLPYoIR8fMnPRTENpADzREHo3abaa94FgKXm3C3ZsjZnVjT99Pe1FAVpRr2mYEenbKWpjNVgHT5CUcjoTmok5fPzOcRXZ5bV4hLEKjKk6jjOvWpWp0VBSNqJSZnIKmjRoaJyrKE+9flg7BgN3CsbHgfZivaXBFp263YJS171SkHvE4mJERtG1+jbwznZyb8OvExvIDYpT+087mK0nQXBO3PW2XKPXYL5n/fWZRDvIc+RzTU4QFet7Gz3vUPu8SgbFrtbEZa 2025-08-04 17:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:03 [INFO]: item found in queue is 14409 2025-08-04 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBE1AFpcnvl7u+huu6+aq9ci65g16rxFKr1nkXK5liRSF0uKQZg76N261TfBhgO5eulKoHHPh6eNjff1PWKpz2tYAlhlCyh8xaTvgdELUchsyfQt66p8mpxyNMe8rih9VrTvS9gv4gyblOMZatLDIRNFDhedzrmPi7hJAl6007YEV4Whc6U2+NehTLq+nITvyW5lQWNeGINwPXxrTvqyLCr/z90SWnDTodDNHqLE4r+H+gLQTjoIXy79ZMk7AgBICYKEdRAxC1i0YM3arM+OOMwK4OrQqjHxFdc1tp+BhyGEHW5bDbE+hYKXx35GLi7/kA9H5Lxewkvi0/4pYAJsKAtoGui1GBQ+STUWxtjCHagHqzhVo2bul1EjRqH2Y1yHonNK9cR0getHh2VB4yW8xRw2hJR4MFYgJxLjhpH1EKnQnghsw6dOZE4BgHv2pxuZ2h 2025-08-04 17:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:04 [INFO]: item found in queue is 14409 2025-08-04 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBc4RKMtpVXxSa/g9vQ/o23q6SmWK9Wgs4goqes0H+4VRN8oLHfzmOhXVAL+OGCivCbW/3w5o1WDnBiG15uZ2CNTULT6cPXYH1N3Xi2L23BbejboaujpJurU0y4SzwMlRah9d2xE6608IJANcUI2z621SaoCPgHnKudQ7+vYFgKO/7nzcx+mzxTi5/BHEymPLgw6CD4TfeDvgCW1FxBzTj8NyhterC9gYRGE1/ajFDwHfxid/2weFDvjwgWsCHmkUdsmwYmMdYXGGIZzISU2WGfCZRMc7FXx706NsbQgOuvwHhD8PHDLzPRRiXFgI1jkQP8Wck6ybxdm6VhTsx7SJj5eDQcEKASAPiaH8MjViB3cMqXVvDbK7FhXAsiBMi7m/5aS2A/JRT1qRYpKSmUefaCgLpYj1zwhV9FGlw3djgu0tbkOj5LPWygn5Ag32Xx+IT 2025-08-04 17:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:04 [INFO]: item found in queue is 14409 2025-08-04 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBX6MJefPGHblZnECCqMAxit3VwJVJsRrSvxekxO3UluRf0tEmYObZVQpnPy7TINeFLmQi82Hm6TngUF9d8nmTkAYdmFr+trJC5Zns3HBPeVjc/g/SjQXqubwbzksr7ZA7rIe0z4MPH6PiRwb135KDuF5UMJX6ZDb8M04/VtrX7XN/loVWfyfAyT048hjSzePDNGY/JrY6wVC0QfTRYmDEm2YZbwVn4uF81i3S1LiG2J28O2Vaklt2t8yYmqVKROgtWaCmZ0Qky/vC/NtBs8OB/cDK+AkZowr38NWshVD5JP77I6apZvIapIZHg2Ucwpgj6rt6FeMTYa2mlVzQEkYw06zUA9ZbT5GBM6g5QusfZWDaUppyXpITf3AkHe2NYrDa0QJ4fDm7Qt9k70U0uDBuaIZw0ygsPkyPcTn+eyDG+XaERd1eBAQaN2T0ub4g6+5s 2025-08-04 17:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:04 [INFO]: item found in queue is 14409 2025-08-04 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnndqrmPGz4OPlhYrXCuuCSVtJcRogodZU9mPfDVdGZ+ooQrgWg6lXgxsRz7gThAak7JvWSjkTLcxLanTrliGVM5qD0G3sXIJXSUZpD7sZjFSAokd1X6OykHziEk+fRZJLoDMyX1pgRDjCnxPgNBOnF9PDj9lCLsnjfT+d9DlFmGoevDNqYk4m4mpH03/GXud8QmFBM5fIJ6r8QVoHsWA5U7ZkBCWL3mhe2CzSYTNPHVhfGCjd1yo/vT8H3c1WufkIGUiiZWCH2Z+yhbFkBHnlIQJ+dCl8IOlMNDHZra6Rq330aZ+VazArhN6mE1/y5XplF1wPvRJ1ySo9Ow3+8t4WcuZTFD+tJhzxaFrlmOF9yzmCIWivLs02TQ0pSlouJKYx4rG9/nDJNfkTZ+ebAktXGh0WZ9TKa3gwU7T4hM3dxUzHQY9a3lW1mYRSkKigMcg 2025-08-04 17:10:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:05 [INFO]: item found in queue is 14409 2025-08-04 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBcK6FohlBik/iSnNgFvembvflMI6X1AcCaN2Dnv7C8dXYvsnelUfdI5FrbG44wcwexbZ9sN0A2yzjuFrKEmrYfKWbIbgRUwEuLZwOencU2LoXhgVVZAnDWuWWLVXPrszEeBJTl/1j4Ii3rXiXDLMarcO2ZTMnt/5ZRnd/l2jo/OY/+9BW1ZLJnO/CtPq7Omuza16z5xMs6Wln6T4M6imch9AYioz1j0sMYz3GobL6iYBLwoAmBbDny+9roHNpoJ+V13ow9IPsq3FZEudsUXL8wSho4JhoLA2wTM8u2q0J7lJDpSpxhQX33osz+0vaDkKVCd1+vyYwij9Ozk7UK5xu6htqC6ml9aZsiXFPiepFdXdUihgoqMWzQCoYA1cmqv8j4e3+KDmxyUccOYxsHwcHA/5pPVnisnPM5hM4v3pEmiNbdw20OqucHooouMXXfElt 2025-08-04 17:10:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:10:05 [INFO]: item found in queue is 14409 2025-08-04 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBLa0XBCDz+BXBUK6j7ZXmjqXb/Ko9FosIw5GciZOxQcN5J2/Yl8btCagT/T+1ZwlsuenPLfkTNPxE8sm6dgubiGcW8+P40uMs5LCybMaLVRrrmkuhIm3AOjR45pMpNmCNDNtAJs8RLISOd9F5TlzEngVnkfAkbYJHPHrnC3lDH+1TdpsyCDjM3mjBAFEr+bzlL9JVP7VBeMtRuD3LsarjCksS8kpDS9Fu8OuRxoEI9uzhc15O5TihCFR/cHz19XpIawaXHh/vNgtonIrG7OMHG8WmdeRj3oVMdThoVXpN/ZbsXibOpBVbFylxlMu3DWgB42vkTZufJrX3zmSEsPygYdec9kVIDJ7K1IaJw05gEUO2r1oe07CSys6ZaMu4YgClkLIIjE2iYv/Yc+ykUwolIwZEDjTg2SHeETxSVrxhh7gr6xZGEBICSJnZFidhFw+4 2025-08-04 17:10:05 [INFO]: Processed 8 messages, reached the limit of 8. 2025-08-04 17:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:10:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:07 [INFO]: Ebay item id :: 335581409868 exists in Database 2025-08-04 17:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:07 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:09 [INFO]: Ebay item id :: 335355511828 exists in Database 2025-08-04 17:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:09 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:10 [INFO]: Ebay item id :: 225741867600 exists in Database 2025-08-04 17:10:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:10 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:12 [INFO]: Ebay item id :: 225871253833 exists in Database 2025-08-04 17:10:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:12 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:14 [INFO]: Ebay item id :: 226447325146 exists in Database 2025-08-04 17:10:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:14 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:15 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:15 [INFO]: Ebay item id :: 225069699315 exists in Database 2025-08-04 17:10:15 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:15 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:17 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:17 [INFO]: Ebay item id :: 306407727359 exists in Database 2025-08-04 17:10:17 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:17 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 17:10:17 [INFO]: inside itemsold and closed 14409 2025-08-04 17:10:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:10:19 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:10:19 [INFO]: Ebay item id :: 325263856574 exists in Database 2025-08-04 17:10:19 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:10:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:10:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:10:19 [INFO]: in processold action queue is array for {"44582335":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44582335","ebayitemid":"335581409868","shopifyproductid":"7843116253406","variants":[{"price":"27.99","quantity":0,"weight":"2","shopifyproductid":"7843116253406","shopifyvariantid":"43538436194526","shopifyinventoryid":"45634063171806","shopifylocationid":"","product_id":"44582335","variant_id":"77475044","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44579299":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579299","ebayitemid":"335355511828","shopifyproductid":"7848290746590","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"7848290746590","shopifyvariantid":"43559384056030","shopifyinventoryid":"45655023878366","shopifylocationid":"","product_id":"44579299","variant_id":"77472006","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44670300":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670300","ebayitemid":"225741867600","shopifyproductid":"8922092732638","variants":[{"price":"44.99","quantity":0,"weight":"3","shopifyproductid":"8922092732638","shopifyvariantid":"46811500740830","shopifyinventoryid":"48909971030238","shopifylocationid":"58450641063","product_id":"44670300","variant_id":"77575520","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44646718":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44646718","ebayitemid":"225871253833","shopifyproductid":"8017573150942","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8017573150942","shopifyvariantid":"44146427396318","shopifyinventoryid":"46243347562718","shopifylocationid":"","product_id":"44646718","variant_id":"77551907","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44731951":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731951","ebayitemid":"225069699315","shopifyproductid":"8015358492894","variants":[{"price":"12.99","quantity":0,"weight":"0.9375","shopifyproductid":"8015358492894","shopifyvariantid":"44142431273182","shopifyinventoryid":"46239337119966","shopifylocationid":"","product_id":"44731951","variant_id":"77639836","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45273381":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45273381","ebayitemid":"306407727359","deleted":1}},"44731954":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731954","ebayitemid":"325263856574","shopifyproductid":"7750252462302","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"7750252462302","shopifyvariantid":"43229559390430","shopifyinventoryid":"45324688654558","shopifylocationid":"","product_id":"44731954","variant_id":"77639839","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:10:19 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:10:19 [INFO]: productIds WHich are having null productid -> [45273381] 2025-08-04 17:10:19 [INFO]: ebayItemIds WHich are not imported-> ["306407727359"] 2025-08-04 17:10:19 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 17:10:19 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 17:10:19 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45273381) 2025-08-04 17:10:19 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 17:10:19 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 17:10:19 [INFO]: Transaction committed successfully. 2025-08-04 17:10:19 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 17:10:19 [INFO]: Shopify Inventory id 45634063171806 2025-08-04 17:10:19 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:20Z","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-04 17:10:20 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:20 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44582335 and user_id = 14409 2025-08-04 17:10:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77475044 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:20 [INFO]: Shopify Inventory id 45655023878366 2025-08-04 17:10:20 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:20Z","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-04 17:10:20 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:20 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579299 and user_id = 14409 2025-08-04 17:10:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77472006 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:20 [INFO]: Shopify Inventory id 48909971030238 2025-08-04 17:10:20 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:20Z","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-04 17:10:20 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:20 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670300 and user_id = 14409 2025-08-04 17:10:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575520 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:20 [INFO]: Shopify Inventory id 46243347562718 2025-08-04 17:10:20 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:21Z","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-04 17:10:21 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:21 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44646718 and user_id = 14409 2025-08-04 17:10:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77551907 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:21 [INFO]: Shopify Inventory id 46239337119966 2025-08-04 17:10:21 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:21Z","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-04 17:10:21 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:21 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731951 and user_id = 14409 2025-08-04 17:10:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639836 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:21 [INFO]: Shopify Inventory id 45324688654558 2025-08-04 17:10:21 [INFO]: Shopify Location id 58450641063 2025-08-04 17:10:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:10:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:10:21Z","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-04 17:10:21 [INFO]: Change: available | Delta: -1 2025-08-04 17:10:21 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:10:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:10:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731954 and user_id = 14409 2025-08-04 17:10:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639839 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:10:21 [INFO]: updateIdsQuantity -> ["77475044","77472006","77575520","77551907","77639836","77639839"] 2025-08-04 17:10:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6 2025-08-04 17:10:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77475044 THEN 0 WHEN id = 77472006 THEN 0 WHEN id = 77575520 THEN 0 WHEN id = 77551907 THEN 0 WHEN id = 77639836 THEN 0 WHEN id = 77639839 THEN 0 END, quantityflag = CASE WHEN id = 77475044 THEN 0 WHEN id = 77472006 THEN 0 WHEN id = 77575520 THEN 0 WHEN id = 77551907 THEN 0 WHEN id = 77639836 THEN 0 WHEN id = 77639839 THEN 0 END WHERE user_id = 14409 AND id IN (77475044,77472006,77575520,77551907,77639836,77639839) 2025-08-04 17:10:21 [INFO]: QUANTITY Updated IDs: 77475044, 77472006, 77575520, 77551907, 77639836, 77639839 2025-08-04 17:10:21 [INFO]: Successfully processed data for user 14409 2025-08-04 17:10:21 [INFO]: Execution Started 2025-08-04 17:10:21 [INFO]: Execution Finished 2025-08-04 17:20:01 [INFO]: Execution Started 2025-08-04 17:20:01 [INFO]: old server sucessfully connected 2025-08-04 17:20:01 [INFO]: sqs client sucess created 2025-08-04 17:20:02 [INFO]: Number of messages in the queue: 2 2025-08-04 17:20:02 [INFO]: item found in queue is if condition 14409 2025-08-04 17:20:02 [INFO]: item found in queue is 14409 2025-08-04 17:20:02 [INFO]: Message deleted from the queue for receipt handle: AQEBiXSPudviJ1MB3IpcSNQ7Ve9IbPmPVWQUIBOTWMeE1dNCaLvLrArRIgIOCShK9EUEKE1Fjwck6oOErHU7mwLxR6Nut+cMLfMVIhcLU3ZycucNAKHO9X3FDcAzlEx9AFodbfkMMgkBm1DnFgHiI5WPZL6Ura1tFBLMoLwvFEyIjnlHOZ8xkJ3Etj4t3j31fmoHqVKCWSd7ON/mX1Q/FL4ZB83Gw3vOGZrPUxqwE4ZheCGpk6WMHZGr0WKthKbf36vNg/X5jUL7kQvUM+4w+xPxHezLVtBUCl9MCrSqOw1FHI7AGrdAEe9zUiq8WBMlN11ivcaysFAspqWkfmyYcwc+p+lbjzRRps1+cEic7Br1zIaNn1cP59wb54ZbsKVKVtT+bk2o8Z2bNKHs2lrNlOEXsD67F5IPDnWOtcMX/jbXIMxuQlfQrejcI90w+07ouzaK 2025-08-04 17:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:20:03 [INFO]: item found in queue is 14409 2025-08-04 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB6lc7tVMtubcBwufo0Dc692lvWysqjDsYee9lFvFgku8K2MDAgk7IN27HXsZ1CqHy7Tr26WHvB+fkVsgicEq4APvNFp/xhhV3zITl2vmsO/xfUCg5oncB0UTlz9xaReoDRIiPFTyDGaKTfJGFw6geza/RiPn4Du9HLtHuyvk3x922NRGIF2wnCaIJTZy19hC5DeC5jswmREH4AKAPkotJNZ8SN1DRR8ePYMErszrDi2zK5la8Q7Y0j1CI9RR177Nc0cFquOIIK3uskVc2YAv+yuRLmb4NWFxPYFCPlqjOEpaTGyhu6DQ0qO2TywRR95GBEINmXiAUkF2PK5d6g9HAncTeN0eex4CdZp97fuFjT4nEFQDEcX7HejBrwO4vF1iiPlTiX9KWuEVK1rQpzMqvOFuVWQ5+Pmb1p7g/rJGHWWd0tKeFZeZWe/VRIMIs5hQF 2025-08-04 17:20:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 17:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:20:03 [INFO]: inside itemsold and closed 14409 2025-08-04 17:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:20:05 [INFO]: Ebay item id :: 286065219222 exists in Database 2025-08-04 17:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:20:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:20:07 [INFO]: Ebay item id :: 325713872396 exists in Database 2025-08-04 17:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:20:07 [INFO]: in processold action queue is array for {"44577767":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577767","ebayitemid":"286065219222","shopifyproductid":"8016412639454","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8016412639454","shopifyvariantid":"44144783687902","shopifyinventoryid":"46241687699678","shopifylocationid":"","product_id":"44577767","variant_id":"77470474","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687602":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687602","ebayitemid":"325713872396","shopifyproductid":"8923182694622","variants":[{"price":"95.99","quantity":0,"weight":"2","shopifyproductid":"8923182694622","shopifyvariantid":"46828004835550","shopifyinventoryid":"48926466867422","shopifylocationid":"58450641063","product_id":"44687602","variant_id":"77592827","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:20:07 [INFO]: Shopify Inventory id 46241687699678 2025-08-04 17:20:07 [INFO]: Shopify Location id 58450641063 2025-08-04 17:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:20: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-04 17:20:07 [INFO]: Change: available | Delta: -1 2025-08-04 17:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577767 and user_id = 14409 2025-08-04 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470474 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:20:07 [INFO]: Shopify Inventory id 48926466867422 2025-08-04 17:20:07 [INFO]: Shopify Location id 58450641063 2025-08-04 17:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:20: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-04 17:20:07 [INFO]: Change: available | Delta: -1 2025-08-04 17:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687602 and user_id = 14409 2025-08-04 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592827 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:20:07 [INFO]: updateIdsQuantity -> ["77470474","77592827"] 2025-08-04 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77470474 THEN 0 WHEN id = 77592827 THEN 0 END, quantityflag = CASE WHEN id = 77470474 THEN 0 WHEN id = 77592827 THEN 0 END WHERE user_id = 14409 AND id IN (77470474,77592827) 2025-08-04 17:20:07 [INFO]: QUANTITY Updated IDs: 77470474, 77592827 2025-08-04 17:20:07 [INFO]: Successfully processed data for user 14409 2025-08-04 17:20:07 [INFO]: Execution Started 2025-08-04 17:20:07 [INFO]: Execution Finished 2025-08-04 17:30:01 [INFO]: Execution Started 2025-08-04 17:30:01 [INFO]: old server sucessfully connected 2025-08-04 17:30:01 [INFO]: sqs client sucess created 2025-08-04 17:30:02 [INFO]: Number of messages in the queue: 6 2025-08-04 17:30:02 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:02 [INFO]: item found in queue is 14409 2025-08-04 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBn8OQj55W82T9FzPXp77yDR/ADGEP+osla1oM0Reep7FzEMUT7Mf9fdhhEPzndtnEUhbRCrbdWUQseuAnmQNEkmi03FEvWc4Vx88iFN6y71Wn+cwrvokryVMD8kJEqAgkGVIV5A7ldoeTZAmWYOW+WEUFN2aGgz56LJDyOYTd9Sjg8PJ12zEvaAKspvchNxvhdjXelR/tay002lccyyYJOT5B81PkpnzTigrH986ulWugsH2m2tz/PdoQhAMAtegDUxHFBHxCwkPdwI7iz5g7sOXf89vSKmhZ0eglIeco8DgWf0w1Tz8/BjmQYrj23xTea6aHkm8Tv+T+JfROcpdq6s5j4V3qXpbdWk9u1Jt4/gzKp0xGrKNZu4pVwtICsfiV+q5us3xkZ6Kn7E5qxqFDHJG6Wyx/0wZEFb0bZRJxshxawsYTu2NgIwUb9VQXQxL7 2025-08-04 17:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:03 [INFO]: item found in queue is 14409 2025-08-04 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBqn+gtr4a88c8B4Os+1/HEmtBRYpSsuUsLzP2eVhNMY945ypjtl5NBSr2gQc3T8JgtwNljtrK+LV2osIJnRrpqgXoqLZjgKqyCo5kGKkVlDnxe0DGImQQHLEEKscNgQawq3udApNbkD8U8O9V7B06WU9RJ3cjqvYT98o/Uqv2CUuKQXf718I5dFXuWj/oHC8W02SfFykrWiwCqD3/K5q3nLkiID4jWrEEudFTHF3DPwVaYq5/+ZqRxPq7cuWS/Y/1JQymUstwW0mYUl5mCcfB0kSSpKtVrxemlpO8C9KzY3d3KA7YnfPT5qyFl334xxEVswWcNqUOSPHssChl918qq0vLDkFAOUtk5PgGTh/s2QSQa46HWnCXXyhW/ZMwtWVwgsvNk5KT+jFB96s+Hwkv5eufXTc4uIaldpDsTqrHGD2XvMzsSfCBD+ExJliJIzRY 2025-08-04 17:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:03 [INFO]: item found in queue is 14409 2025-08-04 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBXrPi+jMEhtNvzIjiVTVwkAtCDrQwMElVC/wDcR64nR4NLcznFlwEKqDV6Qrp0eaISavxTD0zGMVHoUx4DtBfXcpO9lSrL1sMSW1fzAWIghnIvgjQJyfrdaJqTh4LiAD2wNCrj+FUciDUicn8uRq5u9S2bVvbuqq7clPKYAJESe91zSNP/8+mlEZM6jzOS9H+oT+Ood0u2YzwIra7XII777zmS0EZ+ML5FYqVQIg7XJok8dGonPD6lcNMLw21vJN3/qAIGGsJCEsiJEh57qefczH0AXw62VM7QOjDSAUgsMkk9czh1qZ9eqn906YThYTdRndxRUmiEINMtiTFyNV0u45Uzmk4LegdEzugr0Mcn+RA5tfZboDCY4zFZCSP1gUBGVd82sXFGpFzSk199w7fFBnjT12bO8lh59/SxBIv8Nd2B76zOz9m1/GzQlVAm/OX 2025-08-04 17:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:04 [INFO]: item found in queue is 14409 2025-08-04 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEB0y3oYTDIHf/srSUv64V1GiE44GBqkWFWz3tmpgUC2/pw0J/lDSazxpudcbcheraQJIrXwOA0Ug+GvmiB0Ry5MJvLCrdGhsntZ5XthW0XKX+aDI6cvG9DrEVov1vE+bK/etzqFUgw5mriRecqwKh31SvMtBzPk5YrDCeFubOW+Ty+eIHnVc3uAW1eUMHUsI1cFef02I8xak0MZs8CCa+1wNVU9iuL5ceEK9LI5xPQW4opTjU64lGRqtiM5oJnvB9dfv/96Mbe9smKgR+Rz8Ghs1p1gCAT2Zc/lcHsCIDs0DeBPvsY+nvJpzYNxesDXVTUY8NVw540YqZ5lM4QjI9JoQWM0omqf612I/7jxgl1CyY0gLX7M/8K0PZK1QlYR3liYrFWpVwJHzbgIx0EkzxbMTO2POJDX2g27IGxncXKoCwv3peRzCa02PM63sYId+Lq 2025-08-04 17:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:04 [INFO]: item found in queue is 14409 2025-08-04 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkraznFr76OYcBk6juUx5h1zBlxkswcUFyNlApylXOvqj9qhElHiq/4RZw4CobfPSkEkB7Mh3VnQec25XMPiCzVWvZ9jZnDGasQb4Mfc6yOaejsxglW46s232Sx+DnmMt/BTKntP0vGIpbjnU/V/gjcPaV1jFo/RGcx9kiAmuNf2dgwFiu6DTwSHOStmxeORACA4LxgT1hOvYgJjfZG5k14/VeR/ZhzQAUPaGbs7Wz30UhYZT2la7tAzB/XG33Zzw/1vs9Ggef7i4e2/4UJ2VSaFOj2wuAZP18BRPp8uEsfMaKP/mZ0ti4zJrns8TBdfZZ5HM4Ynz4GPNT/fa5IMpk3mwpBK7qSSmWLLNi5ssvPYt9ZXGSEsbqpxqzdBzA4gN3NG6k2XyFyfYqFRGvC8N5hGWkjvjNrb6Osb2DUV+wvHEBV8eOqOLCcljxVFAxY69 2025-08-04 17:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:30:05 [INFO]: item found in queue is 14409 2025-08-04 17:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBoRXvKFjsKRHpp2p50428pVeXXn1QmmTfMU1wcKknGDkWp2N44KnKbsRv5V1tRTWrLBbFih9gUl2fkAzK35E7yJ9P/xKPF4mNfEbQtcypqsCv4jxuzDzFCc5MBlKbrEK813mAWLE2kKUZsTukJE8HONVX9F9PQdaZI9Re+FwmZOUy5/T6LQ3p/094gNkjYIDyyMg7y+wO92+cp7kY11VpPZtWEoJsEmCD0bAGX0g1lw0t4jcGhwv6xR2fQVoEyciTMgOSj6syyCnVGvO+Wo7Lg6HWYVcZjtpbm0lZ5MVzni3WLZlxBb+qrOt7UQ78GNV5I5fxksm9CjaPpJjZAMK+O8lFwJbuWq3g9HChZQb0KPireXMQEIp59UOF/+L+gEuQN3RVmXPVG4GLbZx7JHEZAOBYFmJJYUrVsuFeEqfb+LrDgWKa2/Dy0geZgjfumflQ 2025-08-04 17:30:05 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-04 17:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:30:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:07 [INFO]: Ebay item id :: 325349638512 exists in Database 2025-08-04 17:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:07 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:09 [INFO]: Ebay item id :: 225733848013 exists in Database 2025-08-04 17:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:09 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:10 [INFO]: Ebay item id :: 224165992724 exists in Database 2025-08-04 17:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:10 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:12 [INFO]: Ebay item id :: 286573130999 exists in Database 2025-08-04 17:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:12 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:14 [INFO]: Ebay item id :: 225741877454 exists in Database 2025-08-04 17:30:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:14 [INFO]: inside itemsold and closed 14409 2025-08-04 17:30:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:30:16 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:30:16 [INFO]: Ebay item id :: 286064646537 exists in Database 2025-08-04 17:30:16 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:30:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:30:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:30:16 [INFO]: in processold action queue is array for {"44661128":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661128","ebayitemid":"325349638512","shopifyproductid":"7805753163998","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"7805753163998","shopifyvariantid":"43422837670110","shopifyinventoryid":"45518227472606","shopifylocationid":"","product_id":"44661128","variant_id":"77566348","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44656437":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44656437","ebayitemid":"225733848013","shopifyproductid":"7805785112798","variants":[{"price":"277.99","quantity":0,"weight":"4","shopifyproductid":"7805785112798","shopifyvariantid":"43422878105822","shopifyinventoryid":"45518267908318","shopifylocationid":"","product_id":"44656437","variant_id":"77561626","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44668014":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44668014","ebayitemid":"224165992724","shopifyproductid":"6636627820711","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"6636627820711","shopifyvariantid":"39661797998759","shopifyinventoryid":"41756481618087","shopifylocationid":"","product_id":"44668014","variant_id":"77573234","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44984073":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44984073","ebayitemid":"286573130999","shopifyproductid":"8937284796638","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8937284796638","shopifyvariantid":"46989706756318","shopifyinventoryid":"49101109887198","shopifylocationid":"58450641063","product_id":"44984073","variant_id":"77903805","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44670330":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670330","ebayitemid":"225741877454","shopifyproductid":"7842715992286","variants":[{"price":"57.99","quantity":0,"weight":"4","shopifyproductid":"7842715992286","shopifyvariantid":"43537135010014","shopifyinventoryid":"45632761430238","shopifylocationid":"","product_id":"44670330","variant_id":"77575550","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44576633":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576633","ebayitemid":"286064646537","shopifyproductid":"8699142996190","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8699142996190","shopifyvariantid":"45943346626782","shopifyinventoryid":"48041837625566","shopifylocationid":"","product_id":"44576633","variant_id":"77469340","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:30:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:30:16 [INFO]: Shopify Inventory id 45518227472606 2025-08-04 17:30:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:30: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-04 17:30:16 [INFO]: Change: available | Delta: -1 2025-08-04 17:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661128 and user_id = 14409 2025-08-04 17:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566348 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:16 [INFO]: Shopify Inventory id 45518267908318 2025-08-04 17:30:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:30: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-04 17:30:16 [INFO]: Change: available | Delta: -1 2025-08-04 17:30:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:30:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44656437 and user_id = 14409 2025-08-04 17:30:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77561626 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:16 [INFO]: Shopify Inventory id 41756481618087 2025-08-04 17:30:16 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:30: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-04 17:30:17 [INFO]: Change: available | Delta: -1 2025-08-04 17:30:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44668014 and user_id = 14409 2025-08-04 17:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573234 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:17 [INFO]: Shopify Inventory id 49101109887198 2025-08-04 17:30:17 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:17 [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-04 17:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44984073 and user_id = 14409 2025-08-04 17:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77903805 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:17 [INFO]: Shopify Inventory id 45632761430238 2025-08-04 17:30:17 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:30: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-04 17:30:17 [INFO]: Change: available | Delta: -1 2025-08-04 17:30:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:30:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670330 and user_id = 14409 2025-08-04 17:30:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575550 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:17 [INFO]: Shopify Inventory id 48041837625566 2025-08-04 17:30:17 [INFO]: Shopify Location id 58450641063 2025-08-04 17:30:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:30:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:30:18Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 17:30:18 [INFO]: Change: available | Delta: -1 2025-08-04 17:30:18 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:30:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:30:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576633 and user_id = 14409 2025-08-04 17:30:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469340 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:30:18 [INFO]: updateIdsQuantity -> ["77566348","77561626","77573234","77903805","77575550","77469340"] 2025-08-04 17:30:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 6. Affected rows: 6 2025-08-04 17:30:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77566348 THEN 0 WHEN id = 77561626 THEN 0 WHEN id = 77573234 THEN 0 WHEN id = 77903805 THEN 0 WHEN id = 77575550 THEN 0 WHEN id = 77469340 THEN 0 END, quantityflag = CASE WHEN id = 77566348 THEN 0 WHEN id = 77561626 THEN 0 WHEN id = 77573234 THEN 0 WHEN id = 77903805 THEN 0 WHEN id = 77575550 THEN 0 WHEN id = 77469340 THEN 0 END WHERE user_id = 14409 AND id IN (77566348,77561626,77573234,77903805,77575550,77469340) 2025-08-04 17:30:18 [INFO]: QUANTITY Updated IDs: 77566348, 77561626, 77573234, 77903805, 77575550, 77469340 2025-08-04 17:30:18 [INFO]: Successfully processed data for user 14409 2025-08-04 17:30:18 [INFO]: Execution Started 2025-08-04 17:30:18 [INFO]: Execution Finished 2025-08-04 17:40:02 [INFO]: Execution Started 2025-08-04 17:40:02 [INFO]: old server sucessfully connected 2025-08-04 17:40:02 [INFO]: sqs client sucess created 2025-08-04 17:40:03 [INFO]: Number of messages in the queue: 4 2025-08-04 17:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:40:03 [INFO]: item found in queue is 14409 2025-08-04 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBVUMnxU8bbCXbkB3I2R3vv/V8X+vDZYHzo7q6qIBrEpPGFUILxqN3Qmmg6NcebSIYx/YscZLIQcgi31RcYMU1jrretP1Wvk/eaR+Nwl6IXl65bCgVrswrqHH98OhPuCbvonho8gn/Qxnqvb11Xd4f0XQebzIKREcMlzIIc81tmlfSjvv1A/9iELnCf7GDfkSTDvRCPMNja7avQvt0FnB++YUl899VkgyAcsMVikBBDbQdcpvJ39EZR/uek6blyLyptW9QwTnrBQu4T+S71ShPZxIitpLW321FZ9KfXVQGkizW5q6bvEV0KUI5Thy+EX0K/A7l081DMV5RrAX/JOoulilrMzQ/S1mEQC/j4T04QYJrepXdWmmU9hhldS3//sPsfnZvIvWlITgLUtQ6nIrI85FZQ241Q/kV9JDgWC9H6J+L2ycHMLAwCmU6Yqp1Goea 2025-08-04 17:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:40:03 [INFO]: item found in queue is 14409 2025-08-04 17:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBeYl7sA8wP9FKQXJOglk1aMG3ESQK+dsqehrkQKfxMdY3qzBj6Pvk8C5UNVOzMG87MDEzmYvz3Ap3vLpmOlLqhdb/FnbEOjHiF32gfdqQe6AGLqmCk0lg0d8SnYztiANA6E8o5FqtbmheD5w8bxM1C4pXiRZa2KpdcWb/wf48JVphJHEvUs7t/i1XSasbaxxw9xuHfPlS08VtFh0nS7cNpMchysheWK9kzSLpOPHG4I7rJoOQFWSQawhFeTuXlG2QJdCUP5dzzunwcETHApGnoNjcxDp4WzrXHRTz/+yq6FVn3+4ZjkqBQy+Hnxqn5M3I+obkjIAlaCFDUGGXzTAa4KCEAGYS3EPa7aOz6yi/Rvd3tDmMIUERPcg5wF4pZCPzuA/045gZakp+lHt92U9qvJm/pQPb31GUqOv/yMaKAa7RAFqOjhK+W0Xq3Ticc+ZG 2025-08-04 17:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:40:04 [INFO]: item found in queue is 14409 2025-08-04 17:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB1TsX2jfJ5JL8+29nWLQgJxdKLB0U5npFh3hOXCP3qy0qEz5wsiY11Mk2C7EKLP/tCQmU7JwWojQLa7rv0DH9Y9Bf8t/26VCPGf9hqy/cF8ky/jRpMoKLCINA33wemeG64FbJCMy5bgFrxrB/oil7emKxeEmiNAz2tk3GcHSx9bL43wD779lbf0YVe0vTDAv/9y6KrTUL+TyAEenyhqkwkNjgoJ0cLzh+t4Z3WVrRvUycrGrE6oG3BfKqvgTdHTcYdCUs3bIDfO9tvwh83ACynNTRnpMbWqPd777CG98dwCGn3byIxbDChk79AtfF/YrbUJAUPSSr9JChyJgJ/zdGRvdl4pz3nyiSI+swh0DjNPcDqp/EcgzGhWcrxdaG/TVmU2vnOAED8pRexapKUkIhG+Y2FqS/otLDyXopVoKjQEilsuKcmUhgxZKmfVzh3lIk 2025-08-04 17:40:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:40:05 [INFO]: item found in queue is 14409 2025-08-04 17:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBxCtBosqDWdru2+F9NupquL7nFmDcUkwizBn4t4iUSoG0eTRfdEEaoRfwQ3d1zV2pDiHshVewCKIzdNpDamXH28zWJi5NSszDuu5iJzXbUEMucD8hD+lujp4WNFYKF+/P9cKlSrYG82Hvvpdq282ANPZFe1SPUpNWla9+IijYXCT0gopQT4TmjVo9Y+f/j064oAnRlrqMlQckadPZSvZJzUVfUTLcU7/9InPCoNb8Ck+IKQPEtBAiB9rb6CDq93W5PsdGcOh38yK8raeHFJ75DkFEuPkq4gNnaHmAD7KXOl1EX3a6KCBWGLIi19nwTZIAbh/ZsPI+hgY0IFCZVaDyN+wXqBcM5ULNrCJz3VtdFb2axYuleFl2TqBSFIpNNKVyanupn/PI2j6cW7GJULPKNjtmNfhD2kk1xnrM4nCzx2593LIu3c0FsiBOirBXfY+P 2025-08-04 17:40:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 17:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:40:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:40:07 [INFO]: Ebay item id :: 324304428211 exists in Database 2025-08-04 17:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:40:07 [INFO]: inside itemsold and closed 14409 2025-08-04 17:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:40:08 [INFO]: Ebay item id :: 325790882942 exists in Database 2025-08-04 17:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:40:08 [INFO]: inside itemsold and closed 14409 2025-08-04 17:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:40:10 [INFO]: Ebay item id :: 324305515284 exists in Database 2025-08-04 17:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:40:10 [INFO]: inside itemsold and closed 14409 2025-08-04 17:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:40:12 [INFO]: Ebay item id :: 335221920061 exists in Database 2025-08-04 17:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:40:12 [INFO]: in processold action queue is array for {"44668081":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44668081","ebayitemid":"324304428211","shopifyproductid":"6636222152871","variants":[{"price":"19.67","quantity":0,"weight":"3","shopifyproductid":"6636222152871","shopifyvariantid":"39660594823335","shopifyinventoryid":"41755276411047","shopifylocationid":"","product_id":"44668081","variant_id":"77573301","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44684094":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684094","ebayitemid":"325790882942","shopifyproductid":"8119042212062","variants":[{"price":"229.99","quantity":0,"weight":"3","shopifyproductid":"8119042212062","shopifyvariantid":"44327274053854","shopifyinventoryid":"46424904040670","shopifylocationid":"","product_id":"44684094","variant_id":"77589319","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44669287":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44669287","ebayitemid":"324305515284","shopifyproductid":"6636801982631","variants":[{"price":"9.67","quantity":0,"weight":"0.5","shopifyproductid":"6636801982631","shopifyvariantid":"39662564245671","shopifyinventoryid":"41757256941735","shopifylocationid":"","product_id":"44669287","variant_id":"77574507","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44586285":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586285","ebayitemid":"335221920061","shopifyproductid":"8261248221406","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8261248221406","shopifyvariantid":"44698363298014","shopifyinventoryid":"46796327190750","shopifylocationid":"","product_id":"44586285","variant_id":"77478994","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:40:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:40:12 [INFO]: Shopify Inventory id 41755276411047 2025-08-04 17:40:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:40: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-04 17:40:12 [INFO]: Change: available | Delta: -1 2025-08-04 17:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44668081 and user_id = 14409 2025-08-04 17:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77573301 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:40:12 [INFO]: Shopify Inventory id 46424904040670 2025-08-04 17:40:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:40: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-04 17:40:12 [INFO]: Change: available | Delta: -1 2025-08-04 17:40:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684094 and user_id = 14409 2025-08-04 17:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589319 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:40:12 [INFO]: Shopify Inventory id 41757256941735 2025-08-04 17:40:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 17:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44669287 and user_id = 14409 2025-08-04 17:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77574507 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:40:13 [INFO]: Shopify Inventory id 46796327190750 2025-08-04 17:40:13 [INFO]: Shopify Location id 58450641063 2025-08-04 17:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17: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-04 17:40:13 [INFO]: Change: available | Delta: -1 2025-08-04 17:40:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586285 and user_id = 14409 2025-08-04 17:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478994 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:40:13 [INFO]: updateIdsQuantity -> ["77573301","77589319","77574507","77478994"] 2025-08-04 17:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-04 17:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77573301 THEN 0 WHEN id = 77589319 THEN 0 WHEN id = 77574507 THEN 0 WHEN id = 77478994 THEN 0 END, quantityflag = CASE WHEN id = 77573301 THEN 0 WHEN id = 77589319 THEN 0 WHEN id = 77574507 THEN 0 WHEN id = 77478994 THEN 0 END WHERE user_id = 14409 AND id IN (77573301,77589319,77574507,77478994) 2025-08-04 17:40:13 [INFO]: QUANTITY Updated IDs: 77573301, 77589319, 77574507, 77478994 2025-08-04 17:40:13 [INFO]: Successfully processed data for user 14409 2025-08-04 17:40:13 [INFO]: Execution Started 2025-08-04 17:40:13 [INFO]: Execution Finished 2025-08-04 17:50:01 [INFO]: Execution Started 2025-08-04 17:50:01 [INFO]: old server sucessfully connected 2025-08-04 17:50:02 [INFO]: sqs client sucess created 2025-08-04 17:50:03 [INFO]: Number of messages in the queue: 4 2025-08-04 17:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:50:03 [INFO]: item found in queue is 14409 2025-08-04 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwIY/nrlpPqc4Ub26T5CUyBmEW+q0dh0uJfDOYxaJzeLA8cHqv1WGVA6dVZJJlEstVLuQoIn/H7puwS3enUItsWpZWcWGCciDBVaw7V5dMIo3qfFnlLqptHQdZs+K95ERKh/1UYvWBDJAov0PIWB4nZQSZfqo4YZvaHsrKCkPfdLdRAe37GK6lz/opauvPDAj3CJbEV1YXH03qMZY8zFcgDpmntSqXTJXbi+3eRAC9mMjJvI4Ki0jAq1KLn5QSkosRpgvPl7Wj0hVlTyctSsU5GA9/pzis6TRYgONTP0uthPw6VTT4GIFb6N+VTpbL/TRQlJ7haULgw87c7qpLVUai1hbtxTQH46Jfiid6pW18ZpZ4q22jWUrO8V1w4Ch85hEF5MgZl8AznjG/rUCPGIVwBdCsS5j6iPBzHjwRw6lm2JJ/8+HLFoxbm7AQliea6DG 2025-08-04 17:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 17:50:03 [INFO]: item found in queue is 14409 2025-08-04 17:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB2/jhV6gZ/n23UPQ5Vk4q3P1NpGfSs+NqPfulfQj4TZC4JLLOGcrxLIbNqTZcflctW4mqOtiHSyF3RtKUj5e17unJRdb27b5Xb5MTKdr5US584T0hWxkxFyRUgdj3XvuqGA/KazKToV57t99K8VlCUgjcBBHnxwfO8Txxe5o1pTZkos3rtkDpaA9N6RoPy4USmPYregbbHORMHPOvoXsRzBQYEdjUisvSchwdbPrgL9sWPOcru97VHnwirVIW1sfOiigO/ATfkoYlb6+bWfl+hoUuKPrNml78D8/cjLOCIDaQQL3zxPNuOQeOfqeCbyavhgCodIG21FoXvkv3FT9RpawVvPsh1gK2mKaMiEaAnKamoi7P27+XuAB9YXitesJuBxP9/aL5jx7Tw2AsInDStrRB22IyXnvSbSILI2uYb5TyRjBNpGDxBiISABiAxE72 2025-08-04 17:50:04 [INFO]: item found in queue is if condition 14409 2025-08-04 17:50:04 [INFO]: item found in queue is 14409 2025-08-04 17:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSH+JbFamTiwCJD8xsOI2u1Pn/2JwXI5gnzMFLWe5AR/rLpvXLUNT63ubbdKMLMRIOOIlsewe84WlsFNTwxy70Iwn+yZFfFG9kI1UXjxs0Z/GxwcEBM+kEFF5hwJYXbsH0CbyME7GvLq5585TbYRuvT00s93sQr0IbpQ6u3E+yKj8xOHrjazvPoCDxpp60WDmYy8+ujGwBCc6HSl3vW3C7bKl9UkoIuFE2dvcky3wJ4tLkjPh3jFVrcgirTetTcjhWRUdL8Y2vqsYD1RlIlUd9kIO0K95+oa+dcsfC3h9MWoWklI21kX+v+9BAOS/dQvH6gLNJq5uWQjg097V7gUV9i/S7lkUdPOjowhX/AxkJRB/vzjAPNUVN5JxVYRM8XBCjRuMSiTQqtWIm3cxhWpRU3EMeCzTjufkpL9Xlux0gTd6u/Hp+L+mOCECCOX5SWRd 2025-08-04 17:50:05 [INFO]: item found in queue is if condition 14409 2025-08-04 17:50:05 [INFO]: item found in queue is 14409 2025-08-04 17:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBuUuc7GC9aQj6rh5KN+dKTnVFlX0aJC4K8pm/PXV0yHNczCQRjyjnbJyvHv6wSS1htiylqyiB+0BqQEH+LeT/zilZWUiCLoI+h+lMfGRaErqVZaIR0WY1vRadScYBc5hWCZvzkySlZg+45uHX4eW4f4hP3NiqsmVU1Mi7o3NSwlDamw4JBilpco5kSlBAvzVbIQ9OLbS7DFBBJTv5nnXo9OcEMWUBpRSX5Dduf8WaxUTOIKrRWQqbcBflme8pZvKT8PoUFniBw9gANqFQTHRjbqdTphxBSZY2YvarqI/ojNANcsMQc3aAUCI4zGqMiHMcfbdbl+E2TSMGFdmlT+JTQJLSDHt9F4WjOsHH7zjRo++bwMoQM4iMv5XInJ93A40dfWOzPsmUB8VP9UKf4E7iNba/Z2TcM2Dw3t/wFM5hStWeWZVZoLkFHqAZUaxPoeMY 2025-08-04 17:50:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 17:50:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 17:50:05 [INFO]: inside itemsold and closed 14409 2025-08-04 17:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:50:07 [INFO]: Ebay item id :: 335502579727 exists in Database 2025-08-04 17:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:50:07 [INFO]: inside itemsold and closed 14409 2025-08-04 17:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:50:08 [INFO]: Ebay item id :: 305840086055 exists in Database 2025-08-04 17:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:50:08 [INFO]: inside itemsold and closed 14409 2025-08-04 17:50:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:50:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:50:10 [INFO]: Ebay item id :: 325908765334 exists in Database 2025-08-04 17:50:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:50:10 [INFO]: inside itemsold and closed 14409 2025-08-04 17:50:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 17:50:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 17:50:12 [INFO]: Ebay item id :: 326154540017 exists in Database 2025-08-04 17:50:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 17:50:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 17:50:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 17:50:12 [INFO]: in processold action queue is array for {"44604520":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44604520","ebayitemid":"335502579727","shopifyproductid":"8700432548062","variants":[{"price":"12.99","quantity":0,"weight":"2","shopifyproductid":"8700432548062","shopifyvariantid":"45946948059358","shopifyinventoryid":"48045505282270","shopifylocationid":"","product_id":"44604520","variant_id":"77499471","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573553":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573553","ebayitemid":"305840086055","shopifyproductid":"8707699048670","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8707699048670","shopifyvariantid":"45965060079838","shopifyinventoryid":"48063797264606","shopifylocationid":"","product_id":"44573553","variant_id":"77466260","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44688475":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44688475","ebayitemid":"325908765334","shopifyproductid":"7850114384094","variants":[{"price":"17.99","quantity":0,"weight":"1","shopifyproductid":"7850114384094","shopifyvariantid":"43568714711262","shopifyinventoryid":"45664359448798","shopifylocationid":"","product_id":"44688475","variant_id":"77593721","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44735026":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44735026","ebayitemid":"326154540017","shopifyproductid":"8699144405214","variants":[{"price":"17.99","quantity":0,"weight":"1","shopifyproductid":"8699144405214","shopifyvariantid":"45943348789470","shopifyinventoryid":"48041839788254","shopifylocationid":"","product_id":"44735026","variant_id":"77642919","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 17:50:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 17:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:50:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 17:50:12 [INFO]: Shopify Inventory id 48045505282270 2025-08-04 17:50:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:50: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-04 17:50:12 [INFO]: Change: available | Delta: -1 2025-08-04 17:50:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44604520 and user_id = 14409 2025-08-04 17:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77499471 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:50:12 [INFO]: Shopify Inventory id 48063797264606 2025-08-04 17:50:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17:50: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-04 17:50:12 [INFO]: Change: available | Delta: -1 2025-08-04 17:50:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573553 and user_id = 14409 2025-08-04 17:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466260 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:50:12 [INFO]: Shopify Inventory id 45664359448798 2025-08-04 17:50:12 [INFO]: Shopify Location id 58450641063 2025-08-04 17:50:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17: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-04 17:50:13 [INFO]: Change: available | Delta: -1 2025-08-04 17:50:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44688475 and user_id = 14409 2025-08-04 17:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77593721 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:50:13 [INFO]: Shopify Inventory id 48041839788254 2025-08-04 17:50:13 [INFO]: Shopify Location id 58450641063 2025-08-04 17:50:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 17:50:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T17: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-04 17:50:13 [INFO]: Change: available | Delta: -1 2025-08-04 17:50:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 17:50:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 17:50:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44735026 and user_id = 14409 2025-08-04 17:50:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642919 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 17:50:13 [INFO]: updateIdsQuantity -> ["77499471","77466260","77593721","77642919"] 2025-08-04 17:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-04 17:50:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77499471 THEN 0 WHEN id = 77466260 THEN 0 WHEN id = 77593721 THEN 0 WHEN id = 77642919 THEN 0 END, quantityflag = CASE WHEN id = 77499471 THEN 0 WHEN id = 77466260 THEN 0 WHEN id = 77593721 THEN 0 WHEN id = 77642919 THEN 0 END WHERE user_id = 14409 AND id IN (77499471,77466260,77593721,77642919) 2025-08-04 17:50:13 [INFO]: QUANTITY Updated IDs: 77499471, 77466260, 77593721, 77642919 2025-08-04 17:50:13 [INFO]: Successfully processed data for user 14409 2025-08-04 17:50:13 [INFO]: Execution Started 2025-08-04 17:50:13 [INFO]: Execution Finished