2025-08-05 14:00:01 [INFO]: Execution Started 2025-08-05 14:00:01 [INFO]: old server sucessfully connected 2025-08-05 14:00:01 [INFO]: sqs client sucess created 2025-08-05 14:00:06 [INFO]: Number of messages in the queue: 5 2025-08-05 14:00:06 [INFO]: item found in queue is if condition 14409 2025-08-05 14:00:06 [INFO]: item found in queue is 14409 2025-08-05 14:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBoqAgAtLG26gTeS6bxZHdNj1Ls8Ntiyv3sLn0K/SJnQKaJbZm22VV7y1+msI/SrBGfaL2XUGc1gtnyZF2YTPB0gRlynrAi4rPF/P49sG6LrX1w7fU5U8Rb0a7e8zd5cuWmuToR8Q3AFsPL20MmmEqUSvq1QeuaWX18yX0gyhWJHHuX4n+ko/acqAut1sSmDX3oq//EqtaxiT38ir7rtV0Zrr6ei9WsCb23ODUiDs/tbNPqKH6SAWBn2tjklVIZ+3nYj06FqlAdaLrfUvhMj8h8Asv8sOpLtamZmtMeQrfncMLtYwJY+YkKPQultI7MkqLcXJ9AqSGPu8ziincGp4DhVBqBbNeESFDRLthV9wMs8dn1EzjtaL7m5Icbjmui6GuDBum0rpVJ9QDhIAIw8C8wDZhj1u+OS8coI1q3X8SR/hz9+rQYl8hFjISJ0Ef6rqy 2025-08-05 14:00:08 [INFO]: item found in queue is if condition 14409 2025-08-05 14:00:08 [INFO]: item found in queue is 14409 2025-08-05 14:00:08 [INFO]: Message deleted from the queue for receipt handle: AQEBoqSrnioazBDxgV/pd9QUDYoqAXABbzYFFllvfbhnZhsZA/K6CF7ihKc8mNPGKRfUKiWmA+VFBCjnon1xSNqdJrLH2L/6hCaaUrWEO1+Yhi3VuJzWfXnI9O4/giWgMRCRw4iSjYuG9UycpblI3bwhws31LO1ohNcqt65LvRq1AA2h9JLdOGEa1p54FOqmxwnVla8xCDz34+rXG1e0AYoUZoZ6gIYjbsYs2h6zmmuAd3nTJce6Gc33n3QWNIrIywciT5OS7S7/4c5+FP+XLmqGkBYdA3rvIKv6LUsH2I8F7hFDF2j89ddt0+sUhmr7ZOGyj2vu3WHSgEW/eWuH6R5CIi5iD16EvLUU1G9ErUb9KI+nems7g5Rw3I+FDSNG9RQUR93I7v5EYM9z+/6auMuCBpuQXhGCO61LrNW41ZFEsb/3Sf0zYFU80DozlEROab7/ 2025-08-05 14:00:10 [INFO]: item found in queue is if condition 14409 2025-08-05 14:00:10 [INFO]: item found in queue is 14409 2025-08-05 14:00:10 [INFO]: Message deleted from the queue for receipt handle: AQEBv62fQjJpQZmkvuwYdimLsyPKcXvTRXKGbYK75OMpfrKvZ7/OetV3XJEIOxMowERSCrxo+f8iqf+KPoIb/kNeveNuCgmbB5j+8oBlrk/rUaM5L6GfebwMMGX03phP+NSQ7VNj7EXjYLQhV2wFCTR+l/LJbsyB2BnFQ6RWPZcyxGKUozfiEKO1XeuK5HSUbSCv3JOrnVFSrxVflNUKG0wmcfHwjTjtg6FQgKcvXjAvUcDs4h/jALlyEkSvOLxayj1VkJmbkvaNZ6w+q0X1CndIeTdvN3VQLUMtg4Kdqusv8xO3T8oDat3qZ+Y6CFh3b0ZoJfbCvktzWVhjSha78+t6ioQCjKJOupJ+LdrQnlP4x9/wkKCbB5QBbOuTMq/yurvrPeJA/C80V7ErDjuwGstswZVwxHfMsMc2GM6mYY80+5v9/DN/6WO8RZlY00Je0q5h 2025-08-05 14:00:11 [INFO]: item found in queue is if condition 14409 2025-08-05 14:00:11 [INFO]: item found in queue is 14409 2025-08-05 14:00:12 [INFO]: Message deleted from the queue for receipt handle: AQEBblZ6lavGHXTPF8WNk9z1tZTpJirC+5Z0D0AFddwnduISiWiXT+bgyaAUJCf1GjYhVGuFmCgpfetfVT5O77wtWiAso0XXcsBxKfAh/EpCXxtrTM9HiqFg7yWCTTIaCFnUhrH3bBY1wZb06M6O6WKrWKW2uF6YYixZGHYGAVOIRKwihrCuXiLPHHNGx6Ls2deVW6pZs1yV8Gde7bx4fAYZsLlm2OOTh5V+GYNesPrVOIB79gPhwhIV2v6CZYCfjiRO+Txe51+tOP01JEBSND5e7JrCLqMhFAgZUXZAuJoTt/pNrZjR9yziljY23GUyZbjvOAJRyT3h8MO2lsvQGOu3a4uCbrsgpenMwTNmVGn0keB78gHU2fRKkF0etAFayILDTm4eS+M9y7TA++RcxY9GqdgiiNqRcZ8bRz0NFheS/DzdD4E9yCwiiz7WSKdn5+JP 2025-08-05 14:00:12 [INFO]: item found in queue is if condition 14409 2025-08-05 14:00:12 [INFO]: item found in queue is 14409 2025-08-05 14:00:13 [INFO]: Message deleted from the queue for receipt handle: AQEBt5spxx4t6kxl2NB6Ro6st2ibALL069S4jE8bSPc2S7FHg4rD5DmobaUhZlPMeaG2o934VfPN9wYZ+wmADgFKOwcUG7c1tOqIctiWtttI76c9TX1pYCyXCY2q4s4FzA+3bkoZqf2OH9t5E4MVtneiG5EGWbrg9bie0SAL+0+GeZu5NxeYqzq+splNzlijXjPhSby5zLPhohBKSjK52kE+271Lp7Ze1oOuht/Gew31je4fU7nfXs0GFwXtGDi/YYHqmopXDR5Sr34KmBS+vUslYD0WLAa6pebne7oR0p/VqZqrlWbk8CM0T5wqu8ECVxka0rrBzqUKqS9cuQFp9s5CSvkpQeXe3pgrX1DLjn64RrU5Vxqggy4kmY87cY3Zx1K186aoXJknZxaNU90K1PlhtvEYznBmLD32G/nI2pLwzZf1k5hTo389XrylISUpj6np 2025-08-05 14:00:13 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-05 14:00:13 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 14:00:13 [INFO]: inside itemsold and closed 14409 2025-08-05 14:00:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:00:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:00:15 [INFO]: Ebay item id :: 305195084169 exists in Database 2025-08-05 14:00:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:00:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:00:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:00:15 [INFO]: inside itemsold and closed 14409 2025-08-05 14:00:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:00:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:00:17 [INFO]: Ebay item id :: 305195084169 exists in Database 2025-08-05 14:00:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:00:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:00:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:00:17 [INFO]: inside itemsold and closed 14409 2025-08-05 14:00:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:00:18 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:00:18 [INFO]: Ebay item id :: 406096528456 exists in Database 2025-08-05 14:00:18 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:00:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:00:18 [INFO]: inside itemsold and closed 14409 2025-08-05 14:00:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:00:20 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:00:20 [INFO]: Ebay item id :: 335118851201 exists in Database 2025-08-05 14:00:20 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:00:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:00:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:00:20 [INFO]: inside itemsold and closed 14409 2025-08-05 14:00:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:00:22 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:00:22 [INFO]: Ebay item id :: 335118851201 exists in Database 2025-08-05 14:00:22 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:00:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:00:22 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:00:22 [INFO]: in processold action queue is array for {"44566636":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566636","ebayitemid":"305195084169","shopifyproductid":"7668381876446","variants":[{"price":"274.99","quantity":0,"weight":"2","shopifyproductid":"7668381876446","shopifyvariantid":"42870980083934","shopifyinventoryid":"44965670420702","shopifylocationid":"","product_id":"44566636","variant_id":"77459316","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44572012":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44572012","ebayitemid":"335118851201","shopifyproductid":"7089361158311","variants":[{"price":"88.99","quantity":0,"weight":"2","shopifyproductid":"7089361158311","shopifyvariantid":"41498895810727","shopifyinventoryid":"43595372724391","shopifylocationid":"","product_id":"44572012","variant_id":"77464696","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 14:00:22 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 14:00:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:00:22 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:00:22 [INFO]: Shopify Inventory id 44965670420702 2025-08-05 14:00:22 [INFO]: Shopify Location id 58450641063 2025-08-05 14:00:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T14:00:22Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 14:00:22 [INFO]: Change: available | Delta: -2 2025-08-05 14:00:22 [INFO]: Change: on_hand | Delta: -2 2025-08-05 14:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566636 and user_id = 14409 2025-08-05 14:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459316 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:00:22 [INFO]: Shopify Inventory id 43595372724391 2025-08-05 14:00:22 [INFO]: Shopify Location id 58450641063 2025-08-05 14:00:22 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14:00:22 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T14:00:22Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 14:00:22 [INFO]: Change: available | Delta: -2 2025-08-05 14:00:22 [INFO]: Change: on_hand | Delta: -2 2025-08-05 14:00:22 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:00:22 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44572012 and user_id = 14409 2025-08-05 14:00:22 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77464696 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:00:22 [INFO]: updateIdsQuantity -> ["77459316","77464696"] 2025-08-05 14:00:22 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 14:00:22 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459316 THEN 0 WHEN id = 77464696 THEN 0 END, quantityflag = CASE WHEN id = 77459316 THEN 0 WHEN id = 77464696 THEN 0 END WHERE user_id = 14409 AND id IN (77459316,77464696) 2025-08-05 14:00:22 [INFO]: QUANTITY Updated IDs: 77459316, 77464696 2025-08-05 14:00:22 [INFO]: Successfully processed data for user 14409 2025-08-05 14:00:22 [INFO]: Execution Started 2025-08-05 14:00:22 [INFO]: Execution Finished 2025-08-05 14:10:01 [INFO]: Execution Started 2025-08-05 14:10:01 [INFO]: old server sucessfully connected 2025-08-05 14:10:01 [INFO]: sqs client sucess created 2025-08-05 14:10:05 [INFO]: Number of messages in the queue: 3 2025-08-05 14:10:06 [INFO]: item found in queue is if condition 14409 2025-08-05 14:10:06 [INFO]: item found in queue is 14409 2025-08-05 14:10:10 [INFO]: Message deleted from the queue for receipt handle: AQEBDaiv7WP6w6HeC8wNpGEnSFyBgSkrP7K/JEvXE/79CjGaDZmbI70MufCh7wf5fzRNT3OmfUQ8SbI3kMVmhjhIWrbEjN4KRh2XUJpRHqG1UtT1seEL6H16jRjBsVu9JMnTFbUAMBAQWMkbLXfcAgBi2AtbmqPYkjoi+4Wc3xjnUgm+uKHQ3cEcyskxidAaZ+ccnVW5ZeYl8/WHxGi2gjqloUcpaufLmLzAou8HXu4JadoWJPWCOuwc5jUCOZXBhypl/Kh2J2IgAdLko3ldZFOQMzl7zeuFYUY16QYwCodjUwJKmIM9pkNOI0juXp224GodSst8HHiGfQiLJ59SNc45KHd1NF7OJHxKkXbrExfw2yW8LKvw4fEXGQowBX3EUSU+qVcXHP6o3zYhzUGzonD39NVWZcHHvSN2HAW6mFrJPem60arXppdPpO+bRanipWlD 2025-08-05 14:10:10 [INFO]: item found in queue is if condition 14409 2025-08-05 14:10:10 [INFO]: item found in queue is 14409 2025-08-05 14:10:11 [INFO]: Message deleted from the queue for receipt handle: AQEB3z8vbF/+xVFqRr9hPk+FbjbEz7nMYZ2bcCuHCxTTCQUieRED/SW7wyZZ6wbGVadSn1mNN6Czji5qs9c4uUYw6dzmo092rLBXbn6o5WhSEIUQFQiqgldi/qQgRoTdD+X22Hfm9Y3MQHRhXzk8swX6Ky9DUP8yqSz/I0r18NLFBlomctTi+roNWo/yaoDqIE0nE/0QM/d3l5m/PmyRY1ecL/7lKtyZ+TqaOATlEzV0YCjDGIlxGbt6DBKzuNuvMicF1CkQSqc4w4oDS3al4wp7Mx5B5qIOKp16ndcpidOPhLkIqOW6byUxw9klBN9jc/u50euJ+afM30zrtS/4qCtUP5KwJ8uxwaC1/Pm6td8TIi+aqDCZy5yzuIgnz9IFgmzmMyqVZZx2/THebLd7V4NYA7S2aQlMrbbEyciqoVW4nEjut3WVqwJmtzIf2hV7OtKZ 2025-08-05 14:10:12 [INFO]: item found in queue is if condition 14409 2025-08-05 14:10:12 [INFO]: item found in queue is 14409 2025-08-05 14:10:12 [INFO]: Message deleted from the queue for receipt handle: AQEBEzvHqwj3kvAyo1Gx62+kj972U8ApnhbPjMXoXK+cf5pL3vn6UjRedLSRpBp7Y/mnYcZYBaAWU25GzbQ7Nc4s455dD1st1gv4Ee7p9hah1clvL5ZXMxvpQAwjv1iAvECy5DfxVJ1yt9lgdhcA2RGbO9aEI/G38YDORqx4cvx7YJ6ZTh+Bx70dXARaBIGPsyg3WkBM+VHqFdaaqjbN+upPJtFzpqfFFJCUMPvHNfsWYBDOw7xOJt0jx8HqFapF3JQsDDuY+4NjOWkYR1QdrQpvJQzQr43XRHMpY1FWHrJH17UdlW6DAytttSR1D8Pmw9d09VuixAvZLq6DYQaSQl6q2WaphkqXarfX8zydd+6O0+LF+k/87ZqiW2fgQpU0aYCQrWubRAcpde1QZjgvmKsRe1WRfoeuIjWCMW6hI/QKWHA/NM8KlJS8f3EB8U+acMY+ 2025-08-05 14:10:12 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-05 14:10:12 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 14:10:12 [INFO]: inside itemsold and closed 14409 2025-08-05 14:10:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:10:14 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:10:14 [INFO]: Ebay item id :: 286721318773 exists in Database 2025-08-05 14:10:14 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:10:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-05 14:10:14 [INFO]: inside itemsold and closed 14409 2025-08-05 14:10:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:10:15 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:10:15 [INFO]: Ebay item id :: 335871701732 exists in Database 2025-08-05 14:10:15 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:10:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:10:15 [INFO]: inside itemsold and closed 14409 2025-08-05 14:10:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:10:17 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:10:17 [INFO]: Ebay item id :: 305352225469 exists in Database 2025-08-05 14:10:17 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:10:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:10:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:10:17 [INFO]: in processold action queue is array for {"45272707":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45272707","ebayitemid":"286721318773","deleted":1}},"44569689":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44569689","ebayitemid":"305352225469","shopifyproductid":"8252428255454","variants":[{"price":"26.99","quantity":0,"weight":"2","shopifyproductid":"8252428255454","shopifyvariantid":"44665579405534","shopifyinventoryid":"46763575476446","shopifylocationid":"","product_id":"44569689","variant_id":"77462373","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 14:10:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 14:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:10:17 [INFO]: productIds WHich are having null productid -> [45272707] 2025-08-05 14:10:17 [INFO]: ebayItemIds WHich are not imported-> ["286721318773"] 2025-08-05 14:10:17 [INFO]: Entered in bulkUpdateProducts function 2025-08-05 14:10:17 [INFO]: Transaction started for bulkUpdateProducts 2025-08-05 14:10:17 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45272707) 2025-08-05 14:10:17 [INFO]: Query executed successfully. Affected rows: 0 2025-08-05 14:10:17 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-05 14:10:17 [INFO]: Transaction committed successfully. 2025-08-05 14:10:17 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-05 14:10:17 [INFO]: Shopify Inventory id 46763575476446 2025-08-05 14:10:17 [INFO]: Shopify Location id 58450641063 2025-08-05 14:10:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T14:10:17Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 14:10:17 [INFO]: Change: available | Delta: -2 2025-08-05 14:10:17 [INFO]: Change: on_hand | Delta: -2 2025-08-05 14:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44569689 and user_id = 14409 2025-08-05 14:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77462373 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:10:17 [INFO]: updateIdsQuantity -> ["77462373"] 2025-08-05 14:10:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 14:10:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77462373 THEN 0 END, quantityflag = CASE WHEN id = 77462373 THEN 0 END WHERE user_id = 14409 AND id IN (77462373) 2025-08-05 14:10:17 [INFO]: QUANTITY Updated IDs: 77462373 2025-08-05 14:10:17 [INFO]: Successfully processed data for user 14409 2025-08-05 14:10:17 [INFO]: Execution Started 2025-08-05 14:10:17 [INFO]: Execution Finished 2025-08-05 14:20:01 [INFO]: Execution Started 2025-08-05 14:20:01 [INFO]: old server sucessfully connected 2025-08-05 14:20:01 [INFO]: sqs client sucess created 2025-08-05 14:20:02 [INFO]: Number of messages in the queue: 1 2025-08-05 14:20:03 [INFO]: item found in queue is if condition 14409 2025-08-05 14:20:03 [INFO]: item found in queue is 14409 2025-08-05 14:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1n3WnpcbJGMM+PRL/cF84xc4LUrXvbQ5Hjd1gMM/vW0ti14OKK2rE52heOyGEGUAXVB8lC0CIhCd5knNJX1bDlo9cOIGPDF6Hg3kBuklB0qinZEsEkMBgxkYtGUmo14FfUsSYaGaQVQOuj/BBywrGE8aC1UFwzvr8UTEPtwtzwt6wAiH5bcK6QjH2v10aQKfAb9kbnu3fCXHdmVYFJGObdVpPq0fd4z4vFhKpA+QrdN5WdttyvO+eDvP3VxCwfsvuTviDPGiZ6XvHiCQftqwqVhkGcGhqiJJGlVuGFUZM8AzqosrRXcnw/dNuYjGBi+y0ix8TEYDN5uU65DUOAbg20nh+OiS54F4wAgBEqpHEOuK/FD/9d0xKNzUfeuicWwSxhKJ5524MyiKHJZTpx88n9F0uovud99N+JWRLn5MsKhpsRvVZ+RYsgTZWHR2rBvT 2025-08-05 14:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 14:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 14:20:03 [INFO]: inside itemsold and closed 14409 2025-08-05 14:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:20:05 [INFO]: Ebay item id :: 285672134217 exists in Database 2025-08-05 14:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:20:05 [INFO]: in processold action queue is array for {"44592381":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592381","ebayitemid":"285672134217","shopifyproductid":"6678811738279","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"6678811738279","shopifyvariantid":"39856544809127","shopifyinventoryid":"41951455150247","shopifylocationid":"","product_id":"44592381","variant_id":"77485090","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 14:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 14:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:20:05 [INFO]: Shopify Inventory id 41951455150247 2025-08-05 14:20:05 [INFO]: Shopify Location id 58450641063 2025-08-05 14:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T14:20:05Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-05 14:20:05 [INFO]: Change: available | Delta: -1 2025-08-05 14:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-05 14:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592381 and user_id = 14409 2025-08-05 14:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485090 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:20:05 [INFO]: updateIdsQuantity -> ["77485090"] 2025-08-05 14:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-05 14:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77485090 THEN 0 END, quantityflag = CASE WHEN id = 77485090 THEN 0 END WHERE user_id = 14409 AND id IN (77485090) 2025-08-05 14:20:05 [INFO]: QUANTITY Updated IDs: 77485090 2025-08-05 14:20:05 [INFO]: Successfully processed data for user 14409 2025-08-05 14:20:05 [INFO]: Execution Started 2025-08-05 14:20:05 [INFO]: Execution Finished 2025-08-05 14:30:02 [INFO]: Execution Started 2025-08-05 14:30:02 [INFO]: old server sucessfully connected 2025-08-05 14:30:02 [INFO]: sqs client sucess created 2025-08-05 14:30:05 [INFO]: Number of messages in the queue: 1 2025-08-05 14:30:06 [INFO]: item found in queue is if condition 14409 2025-08-05 14:30:06 [INFO]: item found in queue is 14409 2025-08-05 14:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEB7uXEA0hMZlRrRpp5V2sIqpr8Hg+1yiLqatR+ka0MqLP3DYzuAOG3Ju5pyVwhZIEfcEo0OXuRDtsQ8c79FIPRct5bwWjigH2AwEzty3/2Saihqh4KqpZp1thrDQjLa5hooPIKkS4WVSLzpwsMbLkZ0Qdt6pD5uRvqMBaWIhpJ8H0wdhOwegob1h5EiI1h5OUcJC1J6GqN5yA8K4lt9rho49IQiW0wtan8sy1XE4BD9QhR5IDyowvcLlYk8IHfzfcBBZt2QGHLsCuzZ0zv3sqUPHg7XqM6T5sjKaKgw14Nq1AeX+CsV+UuYPp42b/epIAHGWx4XFGVGadqnt53AaSYoZZ1GbXAi4HNreXEfaqBL+BsCbLgRwEYlLS+41a8Ow0FcJOJSeEgjJ1Z4gaDI9gQf7hh9AWYWzLXQ/t90eASm4vHSx5wpeyubxe0Mc6XXegs 2025-08-05 14:30:07 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-05 14:30:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 14:30:07 [INFO]: inside itemsold and closed 14409 2025-08-05 14:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:30:08 [INFO]: not in db for user_id 14409 and the ebayitemid406091135949 2025-08-05 14:30:08 [INFO]: in processold action queue is array for [] 2025-08-05 14:30:08 [INFO]: Successfully processed data for user 14409 2025-08-05 14:30:08 [INFO]: Execution Started 2025-08-05 14:30:08 [INFO]: Execution Finished 2025-08-05 14:40:02 [INFO]: Execution Started 2025-08-05 14:40:02 [INFO]: old server sucessfully connected 2025-08-05 14:40:02 [INFO]: sqs client sucess created 2025-08-05 14:40:04 [INFO]: Number of messages in the queue: 2 2025-08-05 14:40:05 [INFO]: item found in queue is if condition 14409 2025-08-05 14:40:05 [INFO]: item found in queue is 14409 2025-08-05 14:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBI3wBcaSLcpo19GslCMiGyhj2Sbt34t2iomYxEMGP/E7s9PR4M5nADz5/Sv+hNWNEKnKRIuQYWnKoB5zOb4xi682kNr+CPGAOxMNscCjhP24fql4PfkjfVBs7OxwLAwzJjggrSCcchZU4dU/0uxLTwBcEXd0ATABodoXKoEdi2QPNEvtWe9zdHtnb7LR63cEXRUOxMUjHuNER7XiEyY3LoddOJfBOE8RV7NTOB4P4XBNkDbtJ7B9M+unjnrHr3+jBP1Ea4qeWBPLM672HHXOsGov9NA66X/cD1QekLm6FvxcxbbWvcgOwkv695YIFBVcxFExdRST2FVe4kkAUDySQgSo/6se1UtD74E8TyWPJdKqsqukF25uu307OwM7fp58PPOuAF0/AOAJ8kGupexifTGOf8nPJzBMF4phR6WAPwY9gxdVGDGIbEuPfBE5LDdhT 2025-08-05 14:40:08 [INFO]: item found in queue is if condition 14409 2025-08-05 14:40:08 [INFO]: item found in queue is 14409 2025-08-05 14:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBYkOCwa7/yornDQSM50F3QBPgSVdJ4PHptLcdqMjLWWIYYLNiAkt5RFdTURCIS6ki7emzZXNE2wIlnzYQOzO3nUZ9njqCR9p1xDs5M6fT2zemZ8VBvG4FJKGu5ZNc2Xf1RxDR+Dei/FXtyQXsQM2MvA5qyW+ci1RCANGifjjfoio/pnYThZaxs/h9mrVOgbaNxJIqRCRBLOG2MCJEzvmyYkWYzdqd6o8ooX6574mRrMktt/ixwNX3lQPAqBdQ4mdpOZx5xsYeBihr+fJbsrAiD2t2YZSCTwYPerK4x40jkuF8q5m+a9CAmQk8fTUjiEp0STrJDnrYHtrZJ/3HZA6T87ZneeSk/9fHdscECgs2k0UdMG/MRrqLTmXLi/uBt0/eQ0fw9T43T0gWH3YfOpXnm5cnrDXqgKu26luPAn8GnEih8ahtxqu9byus0r1BCPWO 2025-08-05 14:40:09 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-05 14:40:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-05 14:40:09 [INFO]: inside itemsold and closed 14409 2025-08-05 14:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:40:10 [INFO]: Ebay item id :: 405608961751 exists in Database 2025-08-05 14:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:40:10 [INFO]: inside itemsold and closed 14409 2025-08-05 14:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-05 14:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-05 14:40:12 [INFO]: Ebay item id :: 406105666627 exists in Database 2025-08-05 14:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-05 14:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-05 14:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-05 14:40:12 [INFO]: in processold action queue is array for {"44820014":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44820014","ebayitemid":"405608961751","shopifyproductid":"8926419124446","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8926419124446","shopifyvariantid":"46838156460254","shopifyinventoryid":"48936644575454","shopifylocationid":"58450641063","product_id":"44820014","variant_id":"77730577","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313318":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313318","ebayitemid":"406105666627","shopifyproductid":"8980527874270","variants":[{"price":"71.99","quantity":0,"weight":"3","shopifyproductid":"8980527874270","shopifyvariantid":"47307506188510","shopifyinventoryid":"49419308957918","shopifylocationid":"58450641063","product_id":"45313318","variant_id":"78265831","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-05 14:40:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-05 14:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-05 14:40:12 [INFO]: Shopify Inventory id 48936644575454 2025-08-05 14:40:12 [INFO]: Shopify Location id 58450641063 2025-08-05 14:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14: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-05 14:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44820014 and user_id = 14409 2025-08-05 14:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77730577 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:40:13 [INFO]: Shopify Inventory id 49419308957918 2025-08-05 14:40:13 [INFO]: Shopify Location id 58450641063 2025-08-05 14:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-05 14:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-05T14: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-05 14:40:13 [INFO]: Change: available | Delta: -1 2025-08-05 14:40:13 [INFO]: Change: on_hand | Delta: -1 2025-08-05 14:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-05 14:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313318 and user_id = 14409 2025-08-05 14:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265831 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-05 14:40:13 [INFO]: updateIdsQuantity -> ["77730577","78265831"] 2025-08-05 14:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-05 14:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77730577 THEN 0 WHEN id = 78265831 THEN 0 END, quantityflag = CASE WHEN id = 77730577 THEN 0 WHEN id = 78265831 THEN 0 END WHERE user_id = 14409 AND id IN (77730577,78265831) 2025-08-05 14:40:13 [INFO]: QUANTITY Updated IDs: 77730577, 78265831 2025-08-05 14:40:13 [INFO]: Successfully processed data for user 14409 2025-08-05 14:40:13 [INFO]: Execution Started 2025-08-05 14:40:13 [INFO]: Execution Finished 2025-08-05 14:50:02 [INFO]: Execution Started 2025-08-05 14:50:02 [INFO]: old server sucessfully connected 2025-08-05 14:50:02 [INFO]: sqs client sucess created 2025-08-05 14:50:03 [INFO]: Number of messages in the queue: 0 2025-08-05 14:50:24 [INFO]: Execution Started 2025-08-05 14:50:24 [INFO]: Execution Finished