2025-08-10 18:00:01 [INFO]: Execution Started
2025-08-10 18:00:01 [INFO]: old server sucessfully connected
2025-08-10 18:00:01 [INFO]: sqs client sucess created
2025-08-10 18:00:02 [INFO]: Number of messages in the queue: 1
2025-08-10 18:00:03 [INFO]: item found in queue is if condition  14409
2025-08-10 18:00:03 [INFO]: item found in queue is  14409
2025-08-10 18:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBiu42SgqNjcpu90OiSBg9WgoDhhbxoPEahQ4ezQzllofkAHg53fSsskPALO8QVSwmJhqQnulzL9tRvknPBjfc1aN0WTU3tnbu5sh9tO9Vb05+cYSP9nofaAaPT3QgrD4+HzYMr750FpKJtVlui2kmC12bXyzy2iN7hlEf2uyYnci0bpsOqLNP7LM4F3jgY1Ba1MrGWpCRwsOiiIhaLyd6k5ffuCBtuz7oKN8TH0vEPkSC8tfaalksMa51zPIucHViSqtiXnztUC8jZczFQlrhPIx643t8jNV2lHGXs8iAQdQ7tq0Z4VFv/ZO4JldvxE87H4FpBWBNsNeBrACNgP/MIt5hhdM4/a1PEygIP5AjxQhBcPSXMnrNHRM14li+r150hXGBQ3+LDG83cEr/1XDpLdHx/0mtDRsopCapXFccAKVFB5DLx2bitYEgkLV+fG29
2025-08-10 18:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-10 18:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-10 18:00:03 [INFO]: inside itemsold and closed 14409
2025-08-10 18:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-10 18:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-10 18:00:05 [INFO]: Ebay item id :: 336114724962 exists in Database
2025-08-10 18:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-10 18:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-10 18:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-10 18:00:05 [INFO]: in processold action queue is array    for {"45313904":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313904","ebayitemid":"336114724962","shopifyproductid":"8983662330078","variants":[{"price":"279.99","quantity":0,"weight":"18","shopifyproductid":"8983662330078","shopifyvariantid":"47433568714974","shopifyinventoryid":"49545401041118","shopifylocationid":"58450641063","product_id":"45313904","variant_id":"78266417","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-10 18:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-10 18:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-10 18:00:05 [INFO]: Shopify Inventory id 49545401041118
2025-08-10 18:00:05 [INFO]: Shopify Location id 58450641063
2025-08-10 18:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-10 18:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T18:00:05Z","reason":"correction","changes":[{"name":"available","delta":-28},{"name":"on_hand","delta":-28}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-10 18:00:05 [INFO]: Change: available | Delta: -28
2025-08-10 18:00:05 [INFO]: Change: on_hand | Delta: -28
2025-08-10 18:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-10 18:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313904 and user_id = 14409 
2025-08-10 18:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78266417 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-10 18:00:05 [INFO]: updateIdsQuantity -> ["78266417"]
2025-08-10 18:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-10 18:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 78266417 THEN 0  END, 
					  quantityflag = CASE WHEN id = 78266417 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (78266417)
2025-08-10 18:00:05 [INFO]: QUANTITY Updated IDs: 78266417
2025-08-10 18:00:05 [INFO]: Successfully processed data for user 14409
2025-08-10 18:00:05 [INFO]: Execution Started
2025-08-10 18:00:05 [INFO]: Execution Finished
2025-08-10 18:10:01 [INFO]: Execution Started
2025-08-10 18:10:01 [INFO]: old server sucessfully connected
2025-08-10 18:10:01 [INFO]: sqs client sucess created
2025-08-10 18:10:02 [INFO]: Number of messages in the queue: 0
2025-08-10 18:10:23 [INFO]: Execution Started
2025-08-10 18:10:23 [INFO]: Execution Finished
2025-08-10 18:20:01 [INFO]: Execution Started
2025-08-10 18:20:01 [INFO]: old server sucessfully connected
2025-08-10 18:20:01 [INFO]: sqs client sucess created
2025-08-10 18:20:02 [INFO]: Number of messages in the queue: 0
2025-08-10 18:20:23 [INFO]: Execution Started
2025-08-10 18:20:23 [INFO]: Execution Finished
2025-08-10 18:30:01 [INFO]: Execution Started
2025-08-10 18:30:01 [INFO]: old server sucessfully connected
2025-08-10 18:30:01 [INFO]: sqs client sucess created
2025-08-10 18:30:03 [INFO]: Number of messages in the queue: 0
2025-08-10 18:30:23 [INFO]: Execution Started
2025-08-10 18:30:23 [INFO]: Execution Finished
2025-08-10 18:40:01 [INFO]: Execution Started
2025-08-10 18:40:01 [INFO]: old server sucessfully connected
2025-08-10 18:40:01 [INFO]: sqs client sucess created
2025-08-10 18:40:02 [INFO]: Number of messages in the queue: 0
2025-08-10 18:40:22 [INFO]: Execution Started
2025-08-10 18:40:22 [INFO]: Execution Finished
2025-08-10 18:50:01 [INFO]: Execution Started
2025-08-10 18:50:01 [INFO]: old server sucessfully connected
2025-08-10 18:50:01 [INFO]: sqs client sucess created
2025-08-10 18:50:02 [INFO]: Number of messages in the queue: 4
2025-08-10 18:50:02 [INFO]: item found in queue is if condition  14409
2025-08-10 18:50:02 [INFO]: item found in queue is  14409
2025-08-10 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBK5BBut1/UBmVJ5vx03+MG3RCkgcGiqfrhuYvmMsgeLv/mLuxfOoMTPP3Gv+eModM1u0xBcjvTfuVHnhpXT/sBNCUmqYe5TSOT+7biT+QbOeF9TyTZbSnl6V/Vv42hQomz3oveI2Ntd490ulXIQ1jrLz1WdE1ilvUY5KcI6SYCkIyUNSGUguhXIQpq3T0H0aDQNd7ecTb4gTBMFhsqADYg3Us5EGoj2HDByrvViQyCT2YeaYZJiA5ubBHmbLgQdr4QlQVh2c/MEw6olTYyQBrVHDXRBfP/wD8wq/jYvox1Tc/Fs/lS1/53uyzoL6v2DqNtnVQBe13wy4Bubk1XKdB59gvoHONQlgfIcf2l5B97kej5snUZk8ox9z//RjPDVc0wrcTp9j+TfvhiatVJ50SmDTGJ8jQolYUNJMSz3mu6D1BHyvLSjk2HGbkKe1IigiD
2025-08-10 18:50:03 [INFO]: item found in queue is if condition  14409
2025-08-10 18:50:03 [INFO]: item found in queue is  14409
2025-08-10 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoLDl03qjmRnbKEunbRgGEcTD1zBJ/mXb+gKm2eAG3N0XZvYJEO9W4G+dQHlI2EQXu6ZqsLR7jpDXujRfQjOl/DSTU/4en1puIFOkERNm/THxkeWm7ukcZyAyjFhax/DAsGbVHPeFsy1XFEEh5FJpEUX+X7peiV3dAAGvE3GC1w6FN8bV6bZMM3CwNm8SCYw+dYimbJcsOUmp3LTlMrC8lkhXHW/sKCxnEI/kq9czQ67/6fxDN5dBSXm9MRll2EyMOASLLeDzGtpLXSb4Omp27iA3sYd0rm5tn0KCJFn+L5kGweS+A4lt6nCkEAird2lud0rzlbJnqg9nutpSEqCfbmtdBa5PzDvq/bV6zLvHeZYTv5ydChi0Jt0aAgow+K85Z6ysrIQH53h3dzoYcNEn5eGAmu/iVdEB0Uxz8lPsvGy9vsz80nAiQbxp/81GKw9O
2025-08-10 18:50:03 [INFO]: item found in queue is if condition  14409
2025-08-10 18:50:03 [INFO]: item found in queue is  14409
2025-08-10 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBR03iUU37vuSbFlL9ZTAod5MQTgaIbpt2K+KC0iwPkBGZx5K8XgH4SyJOHgodvsikYsHtH4mmQKXt5M6lvINkov6I0ZvJ3oNgtDXFSOnOrqYV/CqYUFmDJdpslwuTRo9UnQk39JSN4A8ifbNLzTzj9qdrkVD9RdnC3CPDuZX9oQ1Rnxm73EwF6csaivU2CPxQNBEdhxLTWlI9ysCKNvXhLm1AqUA9RD94MHT2mlThe8qeZxp74v2sBKJ6mnRAklHPvLZJ3tYKXp85nys03wr+0gxpx57NQGNF1t5r+nQkdatcE/0utfPu8yGEbsBYEoLJBDhbBe+qxxfj7axw+bHekqJSm/SPO7EAPEZa7FSDDRzbJaw8KLTsPVMdkLJIJdzdqDmfe8NQqHFRLc6O2hauoNXZWcYCHJoopJKLz3+jJwcAJo5DwRh5ujimXqNWRhcd
2025-08-10 18:50:04 [INFO]: item found in queue is if condition  14409
2025-08-10 18:50:04 [INFO]: item found in queue is  14409
2025-08-10 18:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEByDrB45Ad5MVYZTwAH0eDzcWvstu7nocXmMVXZJ7KpFfM+Ww5/RkBBohx5nB0yOy/1rVneW3mgQjxg6bWxd9oWZrvzZmqXjFnGZyNKrObCO1n2sNv8h2Fe4llvfjEMKolv4S4+SC2K6XpD/Tu7/2OgK2hCnaf93OTJGpqCdVCdgBg0H5kojycrQzhwXzj2ZDCTCWbo+3Z6KiOwUY1BwJbBoiGRvRNPCh54JX2IOZFRdKPBAuMCCFuSktUHuJDFpLXgacpJ1pvoq7JEfJlgkJ4s+2O7SOdEUm0AhkN2nwaooKKn17sRiA91O2p+0bk+4tRS4tI4NupapdEFxgnloEQrppeuEnZqUSLvGnII+46f//6J1sNr2Vw+9XflNzU5Tp8Bt8ZK89Dh1WG7hyjEDsG/kh0nYZ1eYgD5P/xjjGaCckE4fK90dbh9N085tO2sc+N
2025-08-10 18:50:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-08-10 18:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-10 18:50:04 [INFO]: inside itemsold and closed 14409
2025-08-10 18:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-10 18:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-10 18:50:06 [INFO]: Ebay item id :: 286019337391 exists in Database
2025-08-10 18:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-10 18:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-10 18:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-10 18:50:06 [INFO]: inside itemsold and closed 14409
2025-08-10 18:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-10 18:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-10 18:50:08 [INFO]: Ebay item id :: 405711156857 exists in Database
2025-08-10 18:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-10 18:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-10 18:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-10 18:50:08 [INFO]: inside itemsold and closed 14409
2025-08-10 18:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-10 18:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-10 18:50:10 [INFO]: Ebay item id :: 326313419851 exists in Database
2025-08-10 18:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-10 18:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-10 18:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-10 18:50:10 [INFO]: inside itemsold and closed 14409
2025-08-10 18:50:11 [INFO]: autodelete for user_id 14409 is 0
2025-08-10 18:50:11 [INFO]: autolink for user_id 14409 is 1
2025-08-10 18:50:11 [INFO]: Ebay item id :: 286706259775 exists in Database
2025-08-10 18:50:11 [INFO]: Item is reliested  ::  exists in Database
2025-08-10 18:50:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-10 18:50:11 [INFO]: in processold action queue is array    for {"44580130":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44580130","ebayitemid":"286019337391","shopifyproductid":"8697543393502","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"8697543393502","shopifyvariantid":"45939379306718","shopifyinventoryid":"48037839012062","shopifylocationid":"","product_id":"44580130","variant_id":"77472837","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44749877":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44749877","ebayitemid":"405711156857","shopifyproductid":"8860366864606","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"8860366864606","shopifyvariantid":"46512643571934","shopifyinventoryid":"48614945751262","shopifylocationid":"","product_id":"44749877","variant_id":"77658353","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44671131":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44671131","ebayitemid":"326313419851","shopifyproductid":"8520027701470","variants":[{"price":"19.99","quantity":0,"weight":"0.5","shopifyproductid":"8520027701470","shopifyvariantid":"45453465878750","shopifyinventoryid":"47551446024414","shopifylocationid":"","product_id":"44671131","variant_id":"77576351","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45221187":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45221187","ebayitemid":"286706259775","deleted":1}}}
2025-08-10 18:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-10 18:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-10 18:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-10 18:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-10 18:50:11 [INFO]: productIds WHich are having null productid -> [45221187]
2025-08-10 18:50:11 [INFO]: ebayItemIds WHich are not imported-> ["286706259775"]
2025-08-10 18:50:11 [INFO]: Entered in bulkUpdateProducts function
2025-08-10 18:50:11 [INFO]: Transaction started for bulkUpdateProducts
2025-08-10 18:50:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45221187)
2025-08-10 18:50:11 [INFO]: Query executed successfully. Affected rows: 0
2025-08-10 18:50:11 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-10 18:50:11 [INFO]: Transaction committed successfully.
2025-08-10 18:50:11 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-10 18:50:11 [INFO]: Shopify Inventory id 48037839012062
2025-08-10 18:50:11 [INFO]: Shopify Location id 58450641063
2025-08-10 18:50:11 [INFO]: QUANTITY FOR UPDATE 0
2025-08-10 18:50:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-10T18:50:12Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-10 18:50:12 [INFO]: Change: available | Delta: -3
2025-08-10 18:50:12 [INFO]: Change: on_hand | Delta: -3
2025-08-10 18:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-10 18:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44580130 and user_id = 14409 
2025-08-10 18:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77472837 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-10 18:50:12 [INFO]: Shopify Inventory id 48614945751262
2025-08-10 18:50:12 [INFO]: Shopify Location id 58450641063
2025-08-10 18:50:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-10 18:50:12 [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-10 18:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-10 18:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44749877 and user_id = 14409 
2025-08-10 18:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77658353 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-10 18:50:12 [INFO]: Shopify Inventory id 47551446024414
2025-08-10 18:50:12 [INFO]: Shopify Location id 58450641063
2025-08-10 18:50:12 [INFO]: QUANTITY FOR UPDATE 0
2025-08-10 18:50:12 [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-10 18:50:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-10 18:50:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44671131 and user_id = 14409 
2025-08-10 18:50:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77576351 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-10 18:50:12 [INFO]: updateIdsQuantity -> ["77472837","77658353","77576351"]
2025-08-10 18:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-10 18:50:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77472837 THEN 0 WHEN id = 77658353 THEN 0 WHEN id = 77576351 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77472837 THEN 0 WHEN id = 77658353 THEN 0 WHEN id = 77576351 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77472837,77658353,77576351)
2025-08-10 18:50:12 [INFO]: QUANTITY Updated IDs: 77472837, 77658353, 77576351
2025-08-10 18:50:12 [INFO]: Successfully processed data for user 14409
2025-08-10 18:50:12 [INFO]: Execution Started
2025-08-10 18:50:12 [INFO]: Execution Finished