2025-08-12 22:00:02 [INFO]: Execution Started
2025-08-12 22:00:02 [INFO]: old server sucessfully connected
2025-08-12 22:00:02 [INFO]: sqs client sucess created
2025-08-12 22:00:03 [INFO]: Number of messages in the queue: 0
2025-08-12 22:00:23 [INFO]: Execution Started
2025-08-12 22:00:23 [INFO]: Execution Finished
2025-08-12 22:10:01 [INFO]: Execution Started
2025-08-12 22:10:01 [INFO]: old server sucessfully connected
2025-08-12 22:10:01 [INFO]: sqs client sucess created
2025-08-12 22:10:02 [INFO]: Number of messages in the queue: 1
2025-08-12 22:10:02 [INFO]: item found in queue is if condition  14409
2025-08-12 22:10:02 [INFO]: item found in queue is  14409
2025-08-12 22:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBO+V+r9Pzk87IhCd2twI19rT4Dyqd5+YLLBwyGc+sDfhs23AIxfm5N+4D8EZljFOsjrwUiqJF/30uCWrpAZG+abIR3g+bDPeQ3SF/ZE+0ZbAz/hV2ZesXmJi7E8g+/xDtjv+CJubeWvdC0TAH4wKH609b/U6Fl8QY7cn/wYvYluH54d72RPpC4MYnIzyqmcL2WN+7f+KZx6NOhf273T+G6GSJqFunqIOBhmmBjf38syv/az9UHUn7z2EwZGU+m/rHWN6+fucgJAM++0D+MhBWtRA6bExUhd0O027FMZMSGJpxu4PPAqaqgqVhZssl9S/9qTS18mpOv5K3XcUwpI8zw/0dnx70+7i3Dp2A/jYMpoE8J3rTQBmNKUQYN/5O6d5tBV9xVR3VZp6k9wpX5U9GjVEC55zDy7mwYeC81baFFpe6ZzrHaTsLopoRppalizii
2025-08-12 22:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 22:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 22:10:03 [INFO]: inside itemsold and closed 14409
2025-08-12 22:10:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 22:10:04 [INFO]: autolink for user_id 14409 is 1
2025-08-12 22:10:04 [INFO]: Ebay item id :: 286304529903 exists in Database
2025-08-12 22:10:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 22:10:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 22:10:04 [INFO]: in processold action queue is array    for []
2025-08-12 22:10:04 [INFO]: Successfully processed data for user 14409
2025-08-12 22:10:04 [INFO]: Execution Started
2025-08-12 22:10:04 [INFO]: Execution Finished
2025-08-12 22:20:01 [INFO]: Execution Started
2025-08-12 22:20:01 [INFO]: old server sucessfully connected
2025-08-12 22:20:01 [INFO]: sqs client sucess created
2025-08-12 22:20:02 [INFO]: Number of messages in the queue: 2
2025-08-12 22:20:03 [INFO]: item found in queue is if condition  14409
2025-08-12 22:20:03 [INFO]: item found in queue is  14409
2025-08-12 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLWLgCrUThMEYkyRV+jJMZoi97JPY+wOxNtO5LeHuH0AZrLFGrhYNmcNehncH92FfL4XNCW15ykr3da55020T8qxqO4X6h/gINLpeaud3Cts2reYJhEIcFd85FTx/11Hzy73UK0QzCv+mTjvY2ovYI7OjTJmgfTFqp5iU1XfsHXWFsw9M2aMnjlaVQ1zxcFU5S8In/k4qUTeTVhgQeta7PiGQCYfo9BY7+kHqLnotNv+utyHKjjPQv1Ow7p3UPEbnsY6IMnbdnEjuERY99PaasvnwCF4NJEPIYiTKv86FcF+4JMHteJw8uJEHf953Q3y8daL2an9HdhL15iB7/stS6ulfoID8lk39AKh3EOom1/yYB0azHYVfsj0UOb64FcGtkh0CDQ6Gx8ec1o1N7MgJ7lO1th/Df4Di/ZABQEtCwEsxuZ+40WTERl3oT2iqhNGD
2025-08-12 22:20:03 [INFO]: item found in queue is if condition  14409
2025-08-12 22:20:03 [INFO]: item found in queue is  14409
2025-08-12 22:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBBj7YCA4jkQ6poz0D/artv7Jz3t8bIIguT+QPm9Iox9f6xYwaQMVJljpixvRy0oekmEXqz+IP/Aq3YZoP96s2Gd7OflVRX+phKhAYPu56DlRWM3UHgoUI1+65/+vbB/CMzVYBXXu7K3OO7Pbu9FifWH25Ws9abfKiJeAoIFJTMIUDKU1wYQUzPRRmG9FLu2eo/fcub0SXH+NzmfM3KibjIMbQO2thc5aXX9uBc88AtGmY3pWyTm2/JMLGtvkEMGnyTGN0BeHs1b1i40BJrAz8qRiLf3k6eQm7E/su363DsJgBkxmEy6iiYOdbi00yK2EO2iSb4rXQX/Mb0XarhNyghISzMuHvoUtn/VeoFnakL98amABGD73Txoy+KddOeGBASYZ21HbR+LC0O/cXD2z3yvat8+Gbx8+68bUJ9Pw9UVwbKCc08i/urjqIawynBVJP
2025-08-12 22:20:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-12 22:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 22:20:03 [INFO]: inside itemsold and closed 14409
2025-08-12 22:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 22:20:05 [INFO]: autolink for user_id 14409 is 1
2025-08-12 22:20:05 [INFO]: Ebay item id :: 306396421643 exists in Database
2025-08-12 22:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 22:20:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-12 22:20:05 [INFO]: inside itemsold and closed 14409
2025-08-12 22:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 22:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 22:20:07 [INFO]: Ebay item id :: 306088459661 exists in Database
2025-08-12 22:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 22:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 22:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 22:20:07 [INFO]: in processold action queue is array    for {"45226464":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45226464","ebayitemid":"306396421643","deleted":1}},"44556543":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556543","ebayitemid":"306088459661","shopifyproductid":"8811492311262","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8811492311262","shopifyvariantid":"46274743206110","shopifyinventoryid":"48375524327646","shopifylocationid":"","product_id":"44556543","variant_id":"77449223","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 22:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 22:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 22:20:07 [INFO]: productIds WHich are having null productid -> [45226464]
2025-08-12 22:20:07 [INFO]: ebayItemIds WHich are not imported-> ["306396421643"]
2025-08-12 22:20:07 [INFO]: Entered in bulkUpdateProducts function
2025-08-12 22:20:07 [INFO]: Transaction started for bulkUpdateProducts
2025-08-12 22:20:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45226464)
2025-08-12 22:20:07 [INFO]: Query executed successfully. Affected rows: 0
2025-08-12 22:20:07 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-12 22:20:07 [INFO]: Transaction committed successfully.
2025-08-12 22:20:07 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-12 22:20:07 [INFO]: Shopify Inventory id 48375524327646
2025-08-12 22:20:07 [INFO]: Shopify Location id 58450641063
2025-08-12 22:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 22:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T22: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-12 22:20:07 [INFO]: Change: available | Delta: -1
2025-08-12 22:20:07 [INFO]: Change: on_hand | Delta: -1
2025-08-12 22:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 22:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556543 and user_id = 14409 
2025-08-12 22:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449223 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 22:20:07 [INFO]: updateIdsQuantity -> ["77449223"]
2025-08-12 22:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 22:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77449223 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77449223 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77449223)
2025-08-12 22:20:07 [INFO]: QUANTITY Updated IDs: 77449223
2025-08-12 22:20:07 [INFO]: Successfully processed data for user 14409
2025-08-12 22:20:07 [INFO]: Execution Started
2025-08-12 22:20:07 [INFO]: Execution Finished
2025-08-12 22:30:01 [INFO]: Execution Started
2025-08-12 22:30:01 [INFO]: old server sucessfully connected
2025-08-12 22:30:01 [INFO]: sqs client sucess created
2025-08-12 22:30:02 [INFO]: Number of messages in the queue: 0
2025-08-12 22:30:23 [INFO]: Execution Started
2025-08-12 22:30:23 [INFO]: Execution Finished
2025-08-12 22:40:01 [INFO]: Execution Started
2025-08-12 22:40:01 [INFO]: old server sucessfully connected
2025-08-12 22:40:01 [INFO]: sqs client sucess created
2025-08-12 22:40:02 [INFO]: Number of messages in the queue: 1
2025-08-12 22:40:03 [INFO]: item found in queue is if condition  14409
2025-08-12 22:40:03 [INFO]: item found in queue is  14409
2025-08-12 22:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBTbg5VjuQpujxMif4uH9Vntgvv1NQaP7pAYVz/O8QwUQy+c6lcUKTKQxgkoFp4AcFwi9BVAE0N4bpZaxhT9xsZlFOGlcVfBuHS/yGqn4ZVwrJykMXen4FBb2W5ZHx1fR/vyo/Ttw/Btg67fOoIHe2jjVlPIQl2hyyMUFHQW2r4dE9Trmm6J2K4Za7beymAFxLVwDHUoTl3a8sqWrdoqy27Imh1wk30W5mRSFUxeGfvP0EU/8fvB/RdHyIlQeoJBScLfXp+AmT+Jmk3McexLOWR4wk9Z0JvDcsBQFBA/ixSZcdaILtuMgHVZ9+VlN1YZKwhYSdB1qLem6u7fdC0O7kLqS2Zr8JUqrHnBTRy+9s8Ew6Ksxk6BxdBCgd04a2QhFszTeJv5/LySy+l8C/MO0SzGxHgYeD9VeUJI91JWahyZF5+/HEQ9jyHfiOeWvXkUBy
2025-08-12 22:40:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 22:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 22:40:03 [INFO]: inside itemsold and closed 14409
2025-08-12 22:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 22:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-12 22:40:05 [INFO]: Ebay item id :: 326677820236 exists in Database
2025-08-12 22:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 22:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-12 22:40:05 [INFO]: in processold action queue is array    for {"45205870":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45205870","ebayitemid":"326677820236","deleted":1}}}
2025-08-12 22:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 22:40:05 [INFO]: productIds WHich are having null productid -> [45205870]
2025-08-12 22:40:05 [INFO]: ebayItemIds WHich are not imported-> ["326677820236"]
2025-08-12 22:40:05 [INFO]: Entered in bulkUpdateProducts function
2025-08-12 22:40:05 [INFO]: Transaction started for bulkUpdateProducts
2025-08-12 22:40:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45205870)
2025-08-12 22:40:05 [INFO]: Query executed successfully. Affected rows: 0
2025-08-12 22:40:05 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-12 22:40:05 [INFO]: Transaction committed successfully.
2025-08-12 22:40:05 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-12 22:40:05 [INFO]: Successfully processed data for user 14409
2025-08-12 22:40:05 [INFO]: Execution Started
2025-08-12 22:40:05 [INFO]: Execution Finished
2025-08-12 22:50:01 [INFO]: Execution Started
2025-08-12 22:50:01 [INFO]: old server sucessfully connected
2025-08-12 22:50:01 [INFO]: sqs client sucess created
2025-08-12 22:50:02 [INFO]: Number of messages in the queue: 0
2025-08-12 22:50:22 [INFO]: Execution Started
2025-08-12 22:50:22 [INFO]: Execution Finished