2025-08-12 15:00:01 [INFO]: Execution Started 2025-08-12 15:00:01 [INFO]: old server sucessfully connected 2025-08-12 15:00:02 [INFO]: sqs client sucess created 2025-08-12 15:00:04 [INFO]: Number of messages in the queue: 1 2025-08-12 15:00:05 [INFO]: item found in queue is if condition 14409 2025-08-12 15:00:05 [INFO]: item found in queue is 14409 2025-08-12 15:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBIeyntH/VEf038yzhoi/hWpeB+v9ecNCnJExhjFAYGNaAJl5kPF+q6Qdsn1nS35T/Y8GsIIOob1DwrEJvvDzR8eWu5dCucNlmbB5Au/a5Z6xvxSUmhRy+kA6v8BLJCtaxErM1C8fFshpHXhESkDzBT4VkvwHVF+k7NBti7i1T+eZI+WKV4NRDzUGdWfmxnXEtgnhVxB5h64NXby3EIZ6zRhr0nEXaciPyXRk0Z64HZ4EVnn8g9ufuc/SOHHVpa5TfbOOQUQWpH3zMh4OTcvZgs6MO0lqAluHDyB2vfbp8zW/IN9wzSpf3zqiP02tQvwQ2rGEzZ/ZR2ljvaMJhmNDWlH8Axc0k6POPRlwy4TNEqW7vSM4pVE1PgVPVyNmydD8Dp/84AiAsEr5FelCmbUYT9cINNLg/zjdMI/2lWm4lqX/jFHb340LMJhroda7zVQsG 2025-08-12 15:00:06 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-12 15:00:06 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 15:00:06 [INFO]: inside itemsold and closed 14409 2025-08-12 15:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:00:08 [INFO]: Ebay item id :: 286707020965 exists in Database 2025-08-12 15:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:00:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-12 15:00:08 [INFO]: in processold action queue is array for {"45224432":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45224432","ebayitemid":"286707020965","deleted":1}}} 2025-08-12 15:00:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 15:00:08 [INFO]: productIds WHich are having null productid -> [45224432] 2025-08-12 15:00:08 [INFO]: ebayItemIds WHich are not imported-> ["286707020965"] 2025-08-12 15:00:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-12 15:00:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-12 15:00:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45224432) 2025-08-12 15:00:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-12 15:00:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-12 15:00:08 [INFO]: Transaction committed successfully. 2025-08-12 15:00:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-12 15:00:08 [INFO]: Successfully processed data for user 14409 2025-08-12 15:00:08 [INFO]: Execution Started 2025-08-12 15:00:08 [INFO]: Execution Finished 2025-08-12 15:10:01 [INFO]: Execution Started 2025-08-12 15:10:01 [INFO]: old server sucessfully connected 2025-08-12 15:10:01 [INFO]: sqs client sucess created 2025-08-12 15:10:03 [INFO]: Number of messages in the queue: 0 2025-08-12 15:10:24 [INFO]: Execution Started 2025-08-12 15:10:24 [INFO]: Execution Finished 2025-08-12 15:20:01 [INFO]: Execution Started 2025-08-12 15:20:01 [INFO]: old server sucessfully connected 2025-08-12 15:20:01 [INFO]: sqs client sucess created 2025-08-12 15:20:10 [INFO]: Number of messages in the queue: 2 2025-08-12 15:20:11 [INFO]: item found in queue is if condition 14409 2025-08-12 15:20:11 [INFO]: item found in queue is 14409 2025-08-12 15:20:11 [INFO]: Message deleted from the queue for receipt handle: AQEB71a+HD6QL6leFTEJgk73PqpyJxhlp71yYZ+5A1101zULYntyX8Bje/RFNfn9Yaho2BkdPzai055Xs/qH8fQWwTTFxppwTDh5fkzFlJHxJ116LKV8Fw0w8UcExGaHVgi38/bFjhhCxfkNZKE7/wO3l+sufYnqHnVZ1UwEvWe616Q4YSFGAA8kk0Gd3D/t7UqaarfncPdGdgpglIfZf3nn2/BkaJCswc1X6NJUNJeYuhikM06a0VkCroRy/GRgt084ePosDpFD7szJxvHHzU1w68p/WmXw8cwnobmFJNAYsZ/6in9r4lZbFfQaimeDkitVZQ2hV6UC5ho62EZh0UDzQ7h1i5kUZ5DeYg6LQhv4ewzUIfBtsBvbYP1t0xkuECPAeCDWKzOdetdiYi8P9SQppbKKD4ujA+yVPBGhGE3TL4EuLbIj6vlh+IKDjkxD3+eA 2025-08-12 15:20:13 [INFO]: item found in queue is if condition 14409 2025-08-12 15:20:13 [INFO]: item found in queue is 14409 2025-08-12 15:20:13 [INFO]: Message deleted from the queue for receipt handle: AQEBEJxIUKah4WK1OOMKtPM2vWOZXJ5jlUPxt7QcdXv3p/MgstWSCRGuXSij887WSo/GGyGIU1REUAvM36vZ2atOk0bQA8vI1e1WVuFvZhDXS7HO1h8czzNkHq5pXAZbqeFVIImVopgaj95deljl7MQ8TRY/7yEtTRs/oVeJZUZcQejxPuOxwU4C8RPp2sL5PI9Pem1eMeiQW2iWCwb3TzfwbwXLGLij2ZIfEYPMiYPqFz0fT5uER0QKISyrNqtOosLgKWq5eOfhwMffDYPobYxtzrdi9n+6JZAUokvPCMBe+XTwAwQJdLMEFnd93c7FJhe7xnSnKEmcAYqhdGTCP4aidOkBmKJmJzSg4c6xtlGsLwTl+lXw5O5Vxk6vE+ArCkwELl5bow2YdoXPF7YYxwsQ+lK1oJZy3pgpBPs9TAt0pnsBJBQagNc6ZGsBzaHTNGAN 2025-08-12 15:20:13 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 15:20:13 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 15:20:13 [INFO]: inside itemsold and closed 14409 2025-08-12 15:20:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:20:15 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:20:15 [INFO]: Ebay item id :: 404954531208 exists in Database 2025-08-12 15:20:15 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:20:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:20:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:20:15 [INFO]: inside itemsold and closed 14409 2025-08-12 15:20:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:20:17 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:20:17 [INFO]: Ebay item id :: 284417592233 exists in Database 2025-08-12 15:20:17 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:20:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:20:17 [INFO]: in processold action queue is array for {"44772916":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772916","ebayitemid":"404954531208","shopifyproductid":"8463034089694","variants":[{"price":"69.99","quantity":0,"weight":"2","shopifyproductid":"8463034089694","shopifyvariantid":"45307492565214","shopifyinventoryid":"47405417300190","shopifylocationid":"","product_id":"44772916","variant_id":"77681458","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 15:20:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 15:20:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:20:17 [INFO]: Shopify Inventory id 47405417300190 2025-08-12 15:20:17 [INFO]: Shopify Location id 58450641063 2025-08-12 15:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15: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-12 15:20:17 [INFO]: Change: available | Delta: -1 2025-08-12 15:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772916 and user_id = 14409 2025-08-12 15:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681458 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:20:17 [INFO]: updateIdsQuantity -> ["77681458"] 2025-08-12 15:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-12 15:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77681458 THEN 0 END, quantityflag = CASE WHEN id = 77681458 THEN 0 END WHERE user_id = 14409 AND id IN (77681458) 2025-08-12 15:20:17 [INFO]: QUANTITY Updated IDs: 77681458 2025-08-12 15:20:17 [INFO]: Successfully processed data for user 14409 2025-08-12 15:20:17 [INFO]: Execution Started 2025-08-12 15:20:17 [INFO]: Execution Finished 2025-08-12 15:30:01 [INFO]: Execution Started 2025-08-12 15:30:01 [INFO]: old server sucessfully connected 2025-08-12 15:30:01 [INFO]: sqs client sucess created 2025-08-12 15:30:03 [INFO]: Number of messages in the queue: 3 2025-08-12 15:30:04 [INFO]: item found in queue is if condition 14409 2025-08-12 15:30:04 [INFO]: item found in queue is 14409 2025-08-12 15:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBfP7w0cZXPoTzhPMeCIs4+ImwcpwFfiXZ2vSD+h2thE8NfMiS0KtYvxIaooj8M20SKPFBEc/yPvuWBYqvuivqqzbI5vyfQiarWrfQfNGOBpFgMswb4ZGvFDWXPpAg47vAfiE3lk+58XdIU9FcXm/+ZlksrnSuY2ZQo4AIChDH63kHpImNbks6rFVSQ1nEUr9OW0A9e1nIw5sLU5f6s80FEqZTbDRElEDNBjR0aiDKFFwnjkIrjCj4flarFEMzSVa/O/s+V65HMW0ZAQwJlLg1yMVjAUMBSboedmv24utLEbAnD3+rn4JbXRo+NqyfqrqtGgdusbCiMRqePXiLZbLlvKAVBC4BMaKkgA01ZJ9GTcRVmfp0seiEHUU9Pq4lLRITpVQ7I3FPF5g9nk4gudkp7y5zMhKQnaVbLqmkfXmz6RisV0vwIg+bRIgMz7Q0letk 2025-08-12 15:30:05 [INFO]: item found in queue is if condition 14409 2025-08-12 15:30:05 [INFO]: item found in queue is 14409 2025-08-12 15:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBQ01oySL/mp4Ihkb2qsPyM0Ob5mvNI6U62Gz6p7Tt6zYKHSo+0Vxf+AJfRpnKfqQDEW5MyjX8iAS9Y3wgW9O7ABenbZUCa9veajBL6WmXZhAbzdaZDMOoxSmtlKHrgU191ddtBcQVbkSTZlipzq6ngK+MC+dR/YoYbDb2aGYf6exiOjsGEeRgEncMdqEmVqqXJPHAhiGH9m8wIhxUbIQWZ39lKtk6QzzJmOqfrXzAuVIuwZCRJWTRiRG2YFEEx8LEF05fDHZC+wVpg6z2uu9NVwl0eWJUkrudZSzQIvqCXvBy3qxOUSeHZzTJHc/W43eqqmKOc52EYND+0VhowygWFqMnngBclsk5vczoQ0pwz05ygW8BHD8gLDhjUwdteqwthJeSsw0qbx594zFciTkmKxQbU8b9lBvGyz/Fq5PC+whi995d0tvKthpZ1sdcxcCI 2025-08-12 15:30:06 [INFO]: item found in queue is if condition 14409 2025-08-12 15:30:06 [INFO]: item found in queue is 14409 2025-08-12 15:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBwuVXIkK2QqSaSdXnD0vvoPW432m/2100+cpCSH7GM7K4SKWLxhcApixjgRNX9opSL3XG8dV9nxLaq2qAZNsjDBE03fqUVW/6cBqXvBSURbQMdxhJJF5AptUClSQ6MfcFOABsGha8NIOdX0VKLNZ1Lw/vKvFoMtKc6SivM1DHn43citZN00eqKfK0ug8D5R7znT7dWKka6CpkKCOHzdQL5NeUKwdV9ovsNHfrdEOzUga165GXot33oSVZ/N+h2z4LtybFqTs5pFhq5EE1WNpARyLEvLOGdPhEOWPXW7kVycFH37dajkUhlQVe8W7PvdFPqFBDa/ZBSIi3ySBpgH3e8WNzW8QvGlGVUOtsMqQZZvH1LFxzUzgPJQdChBdyHuw15hwU5gq3AYmPnXQTx4PMxNtKQPEpJ+lkUVTOVy/Iov7QIPfKn7aHEr7206YVnk8g 2025-08-12 15:30:07 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-12 15:30:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 15:30:07 [INFO]: inside itemsold and closed 14409 2025-08-12 15:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:30:08 [INFO]: Ebay item id :: 256503394628 exists in Database 2025-08-12 15:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:30:08 [INFO]: inside itemsold and closed 14409 2025-08-12 15:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:30:10 [INFO]: Ebay item id :: 285844240960 exists in Database 2025-08-12 15:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:30:10 [INFO]: inside itemsold and closed 14409 2025-08-12 15:30:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:30:12 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:30:12 [INFO]: Ebay item id :: 405132715185 exists in Database 2025-08-12 15:30:12 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:30:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:30:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:30:12 [INFO]: in processold action queue is array for {"44773051":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773051","ebayitemid":"256503394628","shopifyproductid":"8473636208862","variants":[{"price":"59.99","quantity":0,"weight":"2","shopifyproductid":"8473636208862","shopifyvariantid":"45333604303070","shopifyinventoryid":"47431540867294","shopifylocationid":"","product_id":"44773051","variant_id":"77681593","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772985":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772985","ebayitemid":"285844240960","shopifyproductid":"8468257898718","variants":[{"price":"149.99","quantity":0,"weight":"2","shopifyproductid":"8468257898718","shopifyvariantid":"45317785157854","shopifyinventoryid":"47415716446430","shopifylocationid":"","product_id":"44772985","variant_id":"77681527","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44774271":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44774271","ebayitemid":"405132715185","shopifyproductid":"8696079974622","variants":[{"price":"66.99","quantity":0,"weight":"2","shopifyproductid":"8696079974622","shopifyvariantid":"45936135733470","shopifyinventoryid":"48034584690910","shopifylocationid":"","product_id":"44774271","variant_id":"77682813","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 15:30:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 15:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:30:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:30:12 [INFO]: Shopify Inventory id 47431540867294 2025-08-12 15:30:12 [INFO]: Shopify Location id 58450641063 2025-08-12 15:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15:30: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-12 15:30:12 [INFO]: Change: available | Delta: -1 2025-08-12 15:30:12 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773051 and user_id = 14409 2025-08-12 15:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681593 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:30:12 [INFO]: Shopify Inventory id 47415716446430 2025-08-12 15:30:12 [INFO]: Shopify Location id 58450641063 2025-08-12 15:30:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15:30: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-12 15:30:13 [INFO]: Change: available | Delta: -1 2025-08-12 15:30:13 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772985 and user_id = 14409 2025-08-12 15:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681527 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:30:13 [INFO]: Shopify Inventory id 48034584690910 2025-08-12 15:30:13 [INFO]: Shopify Location id 58450641063 2025-08-12 15:30:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:30:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15:30: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-12 15:30:13 [INFO]: Change: available | Delta: -1 2025-08-12 15:30:13 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:30:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:30:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44774271 and user_id = 14409 2025-08-12 15:30:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77682813 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:30:13 [INFO]: updateIdsQuantity -> ["77681593","77681527","77682813"] 2025-08-12 15:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-12 15:30:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77681593 THEN 0 WHEN id = 77681527 THEN 0 WHEN id = 77682813 THEN 0 END, quantityflag = CASE WHEN id = 77681593 THEN 0 WHEN id = 77681527 THEN 0 WHEN id = 77682813 THEN 0 END WHERE user_id = 14409 AND id IN (77681593,77681527,77682813) 2025-08-12 15:30:13 [INFO]: QUANTITY Updated IDs: 77681593, 77681527, 77682813 2025-08-12 15:30:13 [INFO]: Successfully processed data for user 14409 2025-08-12 15:30:13 [INFO]: Execution Started 2025-08-12 15:30:13 [INFO]: Execution Finished 2025-08-12 15:40:01 [INFO]: Execution Started 2025-08-12 15:40:01 [INFO]: old server sucessfully connected 2025-08-12 15:40:01 [INFO]: sqs client sucess created 2025-08-12 15:40:06 [INFO]: Number of messages in the queue: 2 2025-08-12 15:40:07 [INFO]: item found in queue is if condition 14409 2025-08-12 15:40:07 [INFO]: item found in queue is 14409 2025-08-12 15:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBXLWvojJF85eVfB1maUBO1z+lsZwqDmY5+5Pxw+bp9VXjW2rBo9u3AvgFgeBOm7atXjvVcjHYSqTgoXaNh3IS7PF9W2gkxcPx5JfiPNZsLsRa+07em/tgF/170J9EKoHxHMzOwqxO9iGeA8XpCUfYpusmgytpxU48S3bIetU+S3bGR9GOlczCVJkRjzptUexRKyVvGCSPq0LpUYA8n4V2H9oju/naYJj9hM6FfOZXqa7yG/vRml6faOmDn73Why6dIxLaoha3rfQZ6yyQ+4FyWb3AV2Yx5WsB5rshGxNJEhb8R7dAzKcnfjvPyIfEJAl8O0Rlz2V0J4Ui1iNaIZu7wP7+iWt074b09gwczuZ4jzwoMRUqoIC3vzjtt4boLUF+69sTNU/p53Eo+ULGk+UDTHeHdR1WbcBwsgH2Zz4b/jdK0UAaqz8sBdxPVCbQNdVE 2025-08-12 15:40:09 [INFO]: item found in queue is if condition 14409 2025-08-12 15:40:09 [INFO]: item found in queue is 14409 2025-08-12 15:40:10 [INFO]: Message deleted from the queue for receipt handle: AQEBvzSQ+/V4cZ6JgdB1EAkKgznM43Wac4L9scie2SUPeekdb2XjK2qMLzBUfUusSJ4HzXFutWC6kTrCX7vdvCgP97uMwrVJxNfrb5DdegyhkJkWgQP/6/ForX75+nxajRaTPED0M1qw5pKB6iQOqUv07wnnFv6goIlVNGtKrJzQZIIKuRNIl9b4zMkHssZum3zjPgd26SBfzkyzVFm2ac7vMVkwbPWyHAIG0SvVgIDXI/pkbehuJ9gGaDauk2aNSIwY5Mty2dlifG2vrF7BhlRoleRAv2EaiarP14tFsP+OT4y1AOOrE8CMXzI9cYTdoeo7vppZYdmKX8QRMNE5BswGnZTbE22yrucVYxpNVyWHwePDbDo5MieafvdbqPpDOPjW+Glzb9Nqqnh6H8l9xAVcMD9dc3dkK6tPZda2XwOTdL8jTa+WIbiU/2zMO1tGeSSO 2025-08-12 15:40:10 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-12 15:40:10 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-12 15:40:10 [INFO]: inside itemsold and closed 14409 2025-08-12 15:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:40:12 [INFO]: Ebay item id :: 404968791303 exists in Database 2025-08-12 15:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:40:12 [INFO]: inside itemsold and closed 14409 2025-08-12 15:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-12 15:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-12 15:40:14 [INFO]: Ebay item id :: 285851603358 exists in Database 2025-08-12 15:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-12 15:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-12 15:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-12 15:40:14 [INFO]: in processold action queue is array for {"44773139":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773139","ebayitemid":"404968791303","shopifyproductid":"8477162045662","variants":[{"price":"88.99","quantity":0,"weight":"2","shopifyproductid":"8477162045662","shopifyvariantid":"45346582003934","shopifyinventoryid":"47444531773662","shopifylocationid":"","product_id":"44773139","variant_id":"77681681","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44773153":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44773153","ebayitemid":"285851603358","shopifyproductid":"8477219913950","variants":[{"price":"77.99","quantity":0,"weight":"2","shopifyproductid":"8477219913950","shopifyvariantid":"45346778120414","shopifyinventoryid":"47444729463006","shopifylocationid":"","product_id":"44773153","variant_id":"77681695","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-12 15:40:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-12 15:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:40:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-12 15:40:14 [INFO]: Shopify Inventory id 47444531773662 2025-08-12 15:40:14 [INFO]: Shopify Location id 58450641063 2025-08-12 15:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15:40:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 15:40:14 [INFO]: Change: available | Delta: -1 2025-08-12 15:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773139 and user_id = 14409 2025-08-12 15:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681681 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:40:14 [INFO]: Shopify Inventory id 47444729463006 2025-08-12 15:40:14 [INFO]: Shopify Location id 58450641063 2025-08-12 15:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-12 15:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T15:40:14Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-12 15:40:14 [INFO]: Change: available | Delta: -1 2025-08-12 15:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-12 15:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-12 15:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44773153 and user_id = 14409 2025-08-12 15:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681695 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-12 15:40:14 [INFO]: updateIdsQuantity -> ["77681681","77681695"] 2025-08-12 15:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-12 15:40:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77681681 THEN 0 WHEN id = 77681695 THEN 0 END, quantityflag = CASE WHEN id = 77681681 THEN 0 WHEN id = 77681695 THEN 0 END WHERE user_id = 14409 AND id IN (77681681,77681695) 2025-08-12 15:40:14 [INFO]: QUANTITY Updated IDs: 77681681, 77681695 2025-08-12 15:40:14 [INFO]: Successfully processed data for user 14409 2025-08-12 15:40:14 [INFO]: Execution Started 2025-08-12 15:40:14 [INFO]: Execution Finished 2025-08-12 15:50:01 [INFO]: Execution Started 2025-08-12 15:50:01 [INFO]: old server sucessfully connected 2025-08-12 15:50:01 [INFO]: sqs client sucess created 2025-08-12 15:50:03 [INFO]: Number of messages in the queue: 0 2025-08-12 15:50:24 [INFO]: Execution Started 2025-08-12 15:50:24 [INFO]: Execution Finished