2025-08-12 16:00:01 [INFO]: Execution Started
2025-08-12 16:00:01 [INFO]: old server sucessfully connected
2025-08-12 16:00:01 [INFO]: sqs client sucess created
2025-08-12 16:00:04 [INFO]: Number of messages in the queue: 0
2025-08-12 16:00:24 [INFO]: Execution Started
2025-08-12 16:00:24 [INFO]: Execution Finished
2025-08-12 16:10:01 [INFO]: Execution Started
2025-08-12 16:10:01 [INFO]: old server sucessfully connected
2025-08-12 16:10:01 [INFO]: sqs client sucess created
2025-08-12 16:10:11 [INFO]: Number of messages in the queue: 0
2025-08-12 16:10:31 [INFO]: Execution Started
2025-08-12 16:10:31 [INFO]: Execution Finished
2025-08-12 16:20:01 [INFO]: Execution Started
2025-08-12 16:20:01 [INFO]: old server sucessfully connected
2025-08-12 16:20:01 [INFO]: sqs client sucess created
2025-08-12 16:20:04 [INFO]: Number of messages in the queue: 1
2025-08-12 16:20:04 [INFO]: item found in queue is if condition  14409
2025-08-12 16:20:04 [INFO]: item found in queue is  14409
2025-08-12 16:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBx97H9pv22Ym+3kLnYSDs+UtkKjliIEpk0tg+M9scV16ijL0FgkAfPvx19ZSPNPw4IlqdDblHv3W5DNRrmpXssVMwi6u7i0LOGOnI6xJcxov+lI8XDtclL1MioGRiRlN9iQsR6JDJfnhN4Y5JG4+NQfcjuNIo57dbrXMkQxzYYPPGnkcDfhiOkIFqkAiYo2z4dlUi1hev0kMR7PakgO+favh2BKB2VXtcEFA3pjp1zgOmwObWPbwY7nAYrYzegCz1v9bXsBqBcvZRQFBV2wmcxN+7/nEKB8tkUqKDnRSML2tHoJNkqXAuQvKsTbUlUe2b1ofDLa1SMPhzL8/G855Bstgz5W5hqgGmv4dvmqHo5rZOe2ux4DdXXcA7hEAcHrw1g6X/y+LUUhGbhwOUQ8XjKgtlOOAWMZw8i8kiGSgQyx9lgG9Wm7+MKFhtoKcSnEY8
2025-08-12 16:20:05 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 16:20:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 16:20:05 [INFO]: inside itemsold and closed 14409
2025-08-12 16:20:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 16:20:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 16:20:07 [INFO]: Ebay item id :: 306348442981 exists in Database
2025-08-12 16:20:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 16:20:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-12 16:20:07 [INFO]: in processold action queue is array    for {"45113762":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113762","ebayitemid":"306348442981","deleted":1}}}
2025-08-12 16:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 16:20:07 [INFO]: productIds WHich are having null productid -> [45113762]
2025-08-12 16:20:07 [INFO]: ebayItemIds WHich are not imported-> ["306348442981"]
2025-08-12 16:20:07 [INFO]: Entered in bulkUpdateProducts function
2025-08-12 16:20:07 [INFO]: Transaction started for bulkUpdateProducts
2025-08-12 16:20:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113762)
2025-08-12 16:20:07 [INFO]: Query executed successfully. Affected rows: 0
2025-08-12 16:20:07 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-12 16:20:07 [INFO]: Transaction committed successfully.
2025-08-12 16:20:07 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-12 16:20:07 [INFO]: Successfully processed data for user 14409
2025-08-12 16:20:07 [INFO]: Execution Started
2025-08-12 16:20:07 [INFO]: Execution Finished
2025-08-12 16:30:02 [INFO]: Execution Started
2025-08-12 16:30:02 [INFO]: old server sucessfully connected
2025-08-12 16:30:02 [INFO]: sqs client sucess created
2025-08-12 16:30:05 [INFO]: Number of messages in the queue: 0
2025-08-12 16:30:26 [INFO]: Execution Started
2025-08-12 16:30:26 [INFO]: Execution Finished
2025-08-12 16:40:01 [INFO]: Execution Started
2025-08-12 16:40:01 [INFO]: old server sucessfully connected
2025-08-12 16:40:01 [INFO]: sqs client sucess created
2025-08-12 16:40:04 [INFO]: Number of messages in the queue: 1
2025-08-12 16:40:05 [INFO]: item found in queue is if condition  14409
2025-08-12 16:40:05 [INFO]: item found in queue is  14409
2025-08-12 16:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBwyrvNr0ZIvJgoCfesJqCrdwQp/uiosaUB49fRTJfP1UKx14gp+MFAdTuLM4JTZLmz9B/sqwqfNP+GVSL6AYLazYoZBxXqWf+jqnOBQZnDvMieWcNABCnD6cCjoQ28+zXP1MNigOVj4YMJIUv+w+1ChhuytqZVUkCSK7mYdkhDgfcbGsK2b3qorAzID+106yy4OyqeBNLpyhgg7G6yf81YH+ZiB+nMylnjrQTjHDWrTNJ2Nx8oVdBuE117DAXF4hCT2f4Wo/al27d4o1J5GlxmWTADFEQ7UoBfJlkmUx2/xGIu9eYfnynmwtggp4/8WAyGchTVkejpc10o4mRbcqu4p26kVBZGmnJok17HazdHwmHNCzZyHug1D1Q3pS7uJS05W/mtsEyyjQcFQwV0ubnMQyysr/FYaFwAVvxHPKFtbQ03WVuJRhwx9ZKtfz0Y1AP
2025-08-12 16:40:06 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 16:40:06 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 16:40:06 [INFO]: inside itemsold and closed 14409
2025-08-12 16:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 16:40:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 16:40:07 [INFO]: Ebay item id :: 286753410280 exists in Database
2025-08-12 16:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 16:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 16:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 16:40:07 [INFO]: in processold action queue is array    for {"45313775":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313775","ebayitemid":"286753410280","shopifyproductid":"8983199580382","variants":[{"price":"188.88","quantity":0,"weight":"18","shopifyproductid":"8983199580382","shopifyvariantid":"47431393378526","shopifyinventoryid":"49543211024606","shopifylocationid":"58450641063","product_id":"45313775","variant_id":"78266288","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 16:40:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 16:40:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 16:40:08 [INFO]: Shopify Inventory id 49543211024606
2025-08-12 16:40:08 [INFO]: Shopify Location id 58450641063
2025-08-12 16:40:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 16:40:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T16:40:08Z","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 16:40:08 [INFO]: Change: available | Delta: -1
2025-08-12 16:40:08 [INFO]: Change: on_hand | Delta: -1
2025-08-12 16:40:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 16:40:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313775 and user_id = 14409 
2025-08-12 16:40:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266288 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 16:40:08 [INFO]: updateIdsQuantity -> ["78266288"]
2025-08-12 16:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 16:40:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78266288 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78266288 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78266288)
2025-08-12 16:40:08 [INFO]: QUANTITY Updated IDs: 78266288
2025-08-12 16:40:08 [INFO]: Successfully processed data for user 14409
2025-08-12 16:40:08 [INFO]: Execution Started
2025-08-12 16:40:08 [INFO]: Execution Finished
2025-08-12 16:50:01 [INFO]: Execution Started
2025-08-12 16:50:01 [INFO]: old server sucessfully connected
2025-08-12 16:50:01 [INFO]: sqs client sucess created
2025-08-12 16:50:03 [INFO]: Number of messages in the queue: 2
2025-08-12 16:50:03 [INFO]: item found in queue is if condition  14409
2025-08-12 16:50:03 [INFO]: item found in queue is  14409
2025-08-12 16:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBd+1Ro/tOmyhLbgWA8UePsewKMdJBNINYTaxcNaOjvKnk/o3PhNK7xfTF+mUglW7thLk0j5yGj04SoqN4wzFA7eBfSVCDyOnJVHlpJIxFepmij0lFpV5P6VoGKQE4RI/3SAARY6fcKgHa24c4suxekjLOg39vTpLLITWbBa1l3LKiqeutIpOmczGfcGJt9gYPIvd1aOSLBbz87IIN0Na+idR/lr3nRPagDuxu4sjQmtG1bUdbnPixy7Mv6YWeeLbqYw1jpTh/Fewm9lvegksiaKQ+30emCIlASo1CgUcu7vNOCyfveavb3u+N750Ty2Ha0iYdSBeALcckeHxoDIsictfO50IRxK7mXQJb+1/x4R0OUXszxQPFSLK4kriCPnY87nysQ219RzmKFlRN6LtP2eeuREbPb64kcVZ8+gZsYlOV4U2XPf4mTTkU0Biq+JRp
2025-08-12 16:50:03 [INFO]: item found in queue is if condition  14409
2025-08-12 16:50:03 [INFO]: item found in queue is  14409
2025-08-12 16:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBi54lnls5x1ialiGXJQgvlsV74y7a9E7uM63GTkgPTtUCVVT1bfMkV/BFpovACKacSAYGPUwc+l4UUqp3ckyMLhZBa9aPih0t8FLuyFi1pGyblLcwdIy7099QxeaTERhVYHI80IdY9cQ1Xz47HcSoxAdHNHpJIUzCe1duhqgkfvpZP4b9bU0IbackRhmhRyiiJS1p3SdETk9QnetJhGp2f4zyis1khopgpMreTybCPN0nIJ622zdo4AXIo9C3SaA3eCX89gWTfGeGKA2x46kfgh/wxqWOxLNP4UduCnZdYvG8N5DobJx7uLPLZfSocMsaXlAdcsknuOM7qwayKX/I32njN/yZ7RMbCf57H1PBayDcFL23cS2KMWDg/+d3zQtlzxVvFWRMD9T2zgc6XLK3oWELcUpmuBr1OQs3mfyPx2jsmolwGQRKY8hl20OWppk5
2025-08-12 16:50:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-12 16:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 16:50:04 [INFO]: inside itemsold and closed 14409
2025-08-12 16:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 16:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 16:50:06 [INFO]: Ebay item id :: 305461396175 exists in Database
2025-08-12 16:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 16:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 16:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 16:50:06 [INFO]: inside itemsold and closed 14409
2025-08-12 16:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 16:50:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 16:50:07 [INFO]: Ebay item id :: 335487256765 exists in Database
2025-08-12 16:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 16:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 16:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 16:50:07 [INFO]: in processold action queue is array    for {"44579278":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579278","ebayitemid":"305461396175","shopifyproductid":"8329111208158","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8329111208158","shopifyvariantid":"44933418975454","shopifyinventoryid":"47031198384350","shopifylocationid":"","product_id":"44579278","variant_id":"77471985","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573197":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573197","ebayitemid":"335487256765","shopifyproductid":"8700399190238","variants":[{"price":"12.99","quantity":0,"weight":"0.5","shopifyproductid":"8700399190238","shopifyvariantid":"45946896613598","shopifyinventoryid":"48045453836510","shopifylocationid":"","product_id":"44573197","variant_id":"77465904","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 16:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 16:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 16:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 16:50:07 [INFO]: Shopify Inventory id 47031198384350
2025-08-12 16:50:07 [INFO]: Shopify Location id 58450641063
2025-08-12 16:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 16:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T16:50:08Z","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 16:50:08 [INFO]: Change: available | Delta: -1
2025-08-12 16:50:08 [INFO]: Change: on_hand | Delta: -1
2025-08-12 16:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 16:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579278 and user_id = 14409 
2025-08-12 16:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471985 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 16:50:08 [INFO]: Shopify Inventory id 48045453836510
2025-08-12 16:50:08 [INFO]: Shopify Location id 58450641063
2025-08-12 16:50:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 16:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T16:50:08Z","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 16:50:08 [INFO]: Change: available | Delta: -1
2025-08-12 16:50:08 [INFO]: Change: on_hand | Delta: -1
2025-08-12 16:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 16:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573197 and user_id = 14409 
2025-08-12 16:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465904 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 16:50:08 [INFO]: updateIdsQuantity -> ["77471985","77465904"]
2025-08-12 16:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-08-12 16:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77471985 THEN 0 WHEN id = 77465904 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77471985 THEN 0 WHEN id = 77465904 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77471985,77465904)
2025-08-12 16:50:08 [INFO]: QUANTITY Updated IDs: 77471985, 77465904
2025-08-12 16:50:09 [INFO]: Successfully processed data for user 14409
2025-08-12 16:50:09 [INFO]: Execution Started
2025-08-12 16:50:09 [INFO]: Execution Finished