2025-08-14 14:00:01 [INFO]: Execution Started
2025-08-14 14:00:01 [INFO]: old server sucessfully connected
2025-08-14 14:00:01 [INFO]: sqs client sucess created
2025-08-14 14:00:04 [INFO]: Number of messages in the queue: 0
2025-08-14 14:00:18 [INFO]: item found in queue is if condition  14409
2025-08-14 14:00:18 [INFO]: item found in queue is  14409
2025-08-14 14:00:19 [INFO]: Message deleted from the queue for receipt handle: AQEBwPUC9AYP2qKWuP3ZqHgcKepfBIFFU/PaP8ajRyp4+/l/1CryB/W9DtdxUWMCFxN/FtYX5qVUVOmbqPm1Cfns/JApdz7D1vpaEtVzYYTliZ4WrgnSlagj32K8wgvJZdVAZWTUDMN+zrHMWLXsJqWxa4ZCdDAEZmM7Bpg0CSFWGFU5k+ne0xuE7vg6DyiJoskGLTAAwLmobz1DJvv16dI/l/oYu3nZcnuu2cACIBZypcp5Fs3Um+//mVC7oIOB/+H1Advooon8ETSN0E3Pc9Tz7tM7DudvoT2Dpu3jF2yZ+MszjiQfBPE9wwQGxXCIAXIjdIc9a5MjUnm8C3nMCxPCBpZc74mpq4rmUFsZpxb3Lzz+8TkAo174hcWcXeU8JZruUCHbz7Sc5rzhKRkBBoCz7d3RIo46N5v8QvP9/Y99hxNfxEQkpyQkfIBRTyedHfoY
2025-08-14 14:00:19 [INFO]: Processed 1 messages, reached the limit of 0.
2025-08-14 14:00:19 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 14:00:19 [INFO]: inside itemsold and closed 14409
2025-08-14 14:00:21 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 14:00:21 [INFO]: autolink for user_id 14409 is 1
2025-08-14 14:00:21 [INFO]: Ebay item id :: 286099615579 exists in Database
2025-08-14 14:00:21 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 14:00:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 14:00:21 [INFO]: in processold action queue is array    for []
2025-08-14 14:00:21 [INFO]: Successfully processed data for user 14409
2025-08-14 14:00:21 [INFO]: Execution Started
2025-08-14 14:00:21 [INFO]: Execution Finished
2025-08-14 14:10:01 [INFO]: Execution Started
2025-08-14 14:10:01 [INFO]: old server sucessfully connected
2025-08-14 14:10:01 [INFO]: sqs client sucess created
2025-08-14 14:10:09 [INFO]: Number of messages in the queue: 2
2025-08-14 14:10:13 [INFO]: item found in queue is if condition  14409
2025-08-14 14:10:13 [INFO]: item found in queue is  14409
2025-08-14 14:10:14 [INFO]: Message deleted from the queue for receipt handle: AQEBQX7nAAuNcgpTEvRFJn+RfTX1rkt4otKSrx9f2vmFl1ANBJIzBu9rbmEuGTBNW5y3hoc87BGOnLwJgZiDXxxspvyyXEgv8zHt4NxFxAkB4J5MnmJQ16tm1y8FKVNnvgqs7hV2ansn2ogSj1eYcNowIWzh19/75j9isUVlE8WdFEgO5YFNdeJPl/UKehy9a3LV+I2jEtqJ6dSClse+6JEickm0avqfEkxM0fy45Togh8IP0JVYy44YSsjT5YX1VZipSoZiEMTgbu1gSuQYDMkptaTzaX5MkriZI+TpFkNflFFSRR26x2mixLmcnNIVjbtDdMeqAOdehMSZuoRbTI8jijwXlIYlSA+WNUqQjGBbDw4Z93aHGU5n7PKodimv7pqlhFiWMCwEdHXxdcdWu3VfKAusWMX4ey0WN7jO6flURHP4pnuOeU1CGi3VSA43HEGA
2025-08-14 14:10:15 [INFO]: item found in queue is if condition  14409
2025-08-14 14:10:15 [INFO]: item found in queue is  14409
2025-08-14 14:10:15 [INFO]: Message deleted from the queue for receipt handle: AQEBC0aGvMsH0mATk56VphRYC1//wKCOCicUE71ukd4ule0Zoayqr4PbdlBM+1CRhOxeqATe/uC/Jo+b/RQTl8JFnL0e7zd2SuN/pXdxXBBYJBU5GhTCkgqVLLvxMCPZTRVr7N2tZEJ6nxAn2OqVB8qqNssglNcK9VMfP+EhGlGc6wkKCKhUExNlBriqAPdIp/Bg4kvTWPfdPy4B2Gfe5+qWj/rT5mslLB6ACJJkwK90dukPoeHqUjC8E6odW/m5Xp9XoTbABxBR9pNbiepLCqAkbcW+gvFEM78tMZwH1TwuB0eOx9+guKwwFqukjl+zLciV3dW0Gp5yZyfxktP1azS/0HoUx4iJGK4+ryWqIlMGfxiMh9Bi3izDlaB9VyQ/J5Vvc5JPjkWs6yubxXqC7yUjopoRQDC7tjzquWKyz0XFlQXRWJMjecR4cwTqVATFFDi5
2025-08-14 14:10:15 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-14 14:10:15 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 14:10:15 [INFO]: inside itemsold and closed 14409
2025-08-14 14:10:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 14:10:17 [INFO]: autolink for user_id 14409 is 1
2025-08-14 14:10:17 [INFO]: not in db for user_id 14409 and the ebayitemid286738773277
2025-08-14 14:10:17 [INFO]: inside itemsold and closed 14409
2025-08-14 14:10:19 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 14:10:19 [INFO]: autolink for user_id 14409 is 1
2025-08-14 14:10:19 [INFO]: Ebay item id :: 286498679632 exists in Database
2025-08-14 14:10:19 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 14:10:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 14:10:19 [INFO]: in processold action queue is array    for []
2025-08-14 14:10:19 [INFO]: Successfully processed data for user 14409
2025-08-14 14:10:19 [INFO]: Execution Started
2025-08-14 14:10:19 [INFO]: Execution Finished
2025-08-14 14:20:01 [INFO]: Execution Started
2025-08-14 14:20:01 [INFO]: old server sucessfully connected
2025-08-14 14:20:01 [INFO]: sqs client sucess created
2025-08-14 14:20:09 [INFO]: Number of messages in the queue: 1
2025-08-14 14:20:10 [INFO]: item found in queue is if condition  14409
2025-08-14 14:20:10 [INFO]: item found in queue is  14409
2025-08-14 14:20:15 [INFO]: Message deleted from the queue for receipt handle: AQEBNk6pRK7Sq5K0MNpZFOfvOY/DT7ryrerfMk+R+VBIedbMOiPRASDFkU6NFJ1tsj2kCOaTn5+Jpc3cXtu8K71ifuBYUtAEVxWLkXwjRScZ2DYrQYElF4Yzz8UIVKrwAv1Vl03di+JqiR7wlk3ZCVgVwYLvpkATK0yA0YxSUydF7lAiexecSz75PEX0zRXgKI8hulY/P+tyblwf8puiff9ObQvKuvWM6cEkK/ur26G0ENVMUc9PRo+k5d9jt7eoA1rsP+SiySBhZVjYE5Fun7DniRs1mTHedwtelI5oiamUysyujeG2KlCOTdKEiL6PP1M6i5+IDYDsFFHcxPgtT5sQ4ReHn+9h/4Cd9dFLc62Avo7SVbI2rwPEi/m3Py/JplSoGenwAvcCe8/ugnK7ZABhKD/KScCX1uWDmtyafE4shSiTD5PNyscS24rupivVQc7j
2025-08-14 14:20:15 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-14 14:20:15 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 14:20:15 [INFO]: inside itemsold and closed 14409
2025-08-14 14:20:17 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 14:20:17 [INFO]: autolink for user_id 14409 is 1
2025-08-14 14:20:17 [INFO]: Ebay item id :: 257017841205 exists in Database
2025-08-14 14:20:17 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 14:20:17 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-14 14:20:17 [INFO]: in processold action queue is array    for {"45226759":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45226759","ebayitemid":"257017841205","deleted":1}}}
2025-08-14 14:20:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 14:20:17 [INFO]: productIds WHich are having null productid -> [45226759]
2025-08-14 14:20:17 [INFO]: ebayItemIds WHich are not imported-> ["257017841205"]
2025-08-14 14:20:17 [INFO]: Entered in bulkUpdateProducts function
2025-08-14 14:20:17 [INFO]: Transaction started for bulkUpdateProducts
2025-08-14 14:20:17 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45226759)
2025-08-14 14:20:17 [INFO]: Query executed successfully. Affected rows: 0
2025-08-14 14:20:17 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-14 14:20:17 [INFO]: Transaction committed successfully.
2025-08-14 14:20:17 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-14 14:20:17 [INFO]: Successfully processed data for user 14409
2025-08-14 14:20:17 [INFO]: Execution Started
2025-08-14 14:20:17 [INFO]: Execution Finished
2025-08-14 14:30:01 [INFO]: Execution Started
2025-08-14 14:30:01 [INFO]: old server sucessfully connected
2025-08-14 14:30:01 [INFO]: sqs client sucess created
2025-08-14 14:30:09 [INFO]: Number of messages in the queue: 0
2025-08-14 14:30:30 [INFO]: Execution Started
2025-08-14 14:30:30 [INFO]: Execution Finished
2025-08-14 14:40:01 [INFO]: Execution Started
2025-08-14 14:40:01 [INFO]: old server sucessfully connected
2025-08-14 14:40:01 [INFO]: sqs client sucess created
2025-08-14 14:40:04 [INFO]: Number of messages in the queue: 0
2025-08-14 14:40:25 [INFO]: Execution Started
2025-08-14 14:40:25 [INFO]: Execution Finished
2025-08-14 14:50:01 [INFO]: Execution Started
2025-08-14 14:50:01 [INFO]: old server sucessfully connected
2025-08-14 14:50:01 [INFO]: sqs client sucess created
2025-08-14 14:50:03 [INFO]: Number of messages in the queue: 0
2025-08-14 14:50:04 [INFO]: item found in queue is if condition  14409
2025-08-14 14:50:04 [INFO]: item found in queue is  14409
2025-08-14 14:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBLUf/oDSXuTAHbK4v1frZJiQLm6AhCf8aggBMTqvkj3DMYNeAS7zTBQMW8n4mEmtC2VFf7xHQArFfHyHk7DIMN+qNT+jZNLv1vi8VRJkZoldgrwU65GeX+FzA7iuETkMEnNdPh4scstPedKCfeeFVOYnFA65dACrGv2Nv+vXp+63Io4UTkEsNRYrUZmdWJMR1KgAJXH4uHNHc4+fmq14dVK2twG9GLawZqwoRl+vMSzBgcqbUlIEkkIwvIew/iOLq5g5PsNz8f0a2ctm8062K0wAw7GnQi871CboAIbuFVVax+yOfBDDzyWbPtW3Pd1nW5fiLwt7mcdD+gu5tDEkChnnO20YdnT0wIpH1t+5h/zk5n8/ggJOLLxQXRHVu+QSkLL8Zxwfa4wq2b13elOqOeD7xleK3v/gPwRO1qbShzGdRbKl9z+rSWsAhic3BCgGc
2025-08-14 14:50:04 [INFO]: Processed 1 messages, reached the limit of 0.
2025-08-14 14:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-14 14:50:04 [INFO]: inside itemsold and closed 14409
2025-08-14 14:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-14 14:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-14 14:50:06 [INFO]: Ebay item id :: 406095656598 exists in Database
2025-08-14 14:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-14 14:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-14 14:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-14 14:50:06 [INFO]: in processold action queue is array    for {"45312983":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312983","ebayitemid":"406095656598","shopifyproductid":"8976334749918","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8976334749918","shopifyvariantid":"47191866245342","shopifyinventoryid":"49303705223390","shopifylocationid":"58450641063","product_id":"45312983","variant_id":"78265496","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-14 14:50:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-14 14:50:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-14 14:50:06 [INFO]: Shopify Inventory id 49303705223390
2025-08-14 14:50:06 [INFO]: Shopify Location id 58450641063
2025-08-14 14:50:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-14 14:50:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-14T14:50:06Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1988,"restoreRate":100}}}}
2025-08-14 14:50:06 [INFO]: Change: available | Delta: -1
2025-08-14 14:50:06 [INFO]: Change: on_hand | Delta: -1
2025-08-14 14:50:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-14 14:50:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312983 and user_id = 14409 
2025-08-14 14:50:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265496 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-14 14:50:06 [INFO]: updateIdsQuantity -> ["78265496"]
2025-08-14 14:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-14 14:50:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78265496 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78265496 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78265496)
2025-08-14 14:50:06 [INFO]: QUANTITY Updated IDs: 78265496
2025-08-14 14:50:06 [INFO]: Successfully processed data for user 14409
2025-08-14 14:50:06 [INFO]: Execution Started
2025-08-14 14:50:06 [INFO]: Execution Finished