2025-08-13 01:00:01 [INFO]: Execution Started
2025-08-13 01:00:01 [INFO]: old server sucessfully connected
2025-08-13 01:00:01 [INFO]: sqs client sucess created
2025-08-13 01:00:03 [INFO]: Number of messages in the queue: 0
2025-08-13 01:00:23 [INFO]: Execution Started
2025-08-13 01:00:23 [INFO]: Execution Finished
2025-08-13 01:10:02 [INFO]: Execution Started
2025-08-13 01:10:02 [INFO]: old server sucessfully connected
2025-08-13 01:10:02 [INFO]: sqs client sucess created
2025-08-13 01:10:03 [INFO]: Number of messages in the queue: 1
2025-08-13 01:10:03 [INFO]: item found in queue is if condition  14409
2025-08-13 01:10:03 [INFO]: item found in queue is  14409
2025-08-13 01:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBGu9mKkZ/oq9kcA+ghyEtrpfwZ18grppAYjbhFMh0zWhJDwK1DZXPxmHokrMW+h4/VqBuZ/8kG1SsUE117U6z6YKLn0Nm3ZpTlFprE2CfOHTif76/8dEXwGCx+z444IWmh9+Dme0ZwJEi7q1gMg0/9bvGUelPcdJDmX+qnEbwabELVVcHK849i8OmQemRkITsnERS9W2dblx+0m2erjjwclDhvIfcd0M1iG1HPfLoxNLMOhWbb2+4Em/Bk9AQ3j3ayvdTBTNAvWLmM28ICWzYz5wFAsVHqn3n7q1hH1jdxbkwEV8C8U25VYyNFViP1GSb9CiI8YohTpcQivCqoRH2dpGvAzPiDj6T2cYhFeutfMEmrnqBl5ErJnTj6XhH10iXr65ltW/s+GXHNHk3AwaSNEYmFaOng0zt/bvr8dQaOU2ioYj2ubosflE1JViELOsP
2025-08-13 01:10:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-13 01:10:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 01:10:03 [INFO]: inside itemsold and closed 14409
2025-08-13 01:10:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 01:10:05 [INFO]: autolink for user_id 14409 is 1
2025-08-13 01:10:05 [INFO]: Ebay item id :: 305693819099 exists in Database
2025-08-13 01:10:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 01:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 01:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 01:10:05 [INFO]: in processold action queue is array    for {"44591574":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44591574","ebayitemid":"305693819099","shopifyproductid":"8700462891230","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8700462891230","shopifyvariantid":"45946991542494","shopifyinventoryid":"48045548765406","shopifylocationid":"","product_id":"44591574","variant_id":"77484283","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 01:10:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 01:10:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 01:10:05 [INFO]: Shopify Inventory id 48045548765406
2025-08-13 01:10:05 [INFO]: Shopify Location id 58450641063
2025-08-13 01:10:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 01:10:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T01:10: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-13 01:10:05 [INFO]: Change: available | Delta: -1
2025-08-13 01:10:05 [INFO]: Change: on_hand | Delta: -1
2025-08-13 01:10:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 01:10:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44591574 and user_id = 14409 
2025-08-13 01:10:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77484283 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 01:10:05 [INFO]: updateIdsQuantity -> ["77484283"]
2025-08-13 01:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-13 01:10:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77484283 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77484283 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77484283)
2025-08-13 01:10:05 [INFO]: QUANTITY Updated IDs: 77484283
2025-08-13 01:10:06 [INFO]: Successfully processed data for user 14409
2025-08-13 01:10:06 [INFO]: Execution Started
2025-08-13 01:10:06 [INFO]: Execution Finished
2025-08-13 01:20:02 [INFO]: Execution Started
2025-08-13 01:20:02 [INFO]: old server sucessfully connected
2025-08-13 01:20:02 [INFO]: sqs client sucess created
2025-08-13 01:20:03 [INFO]: Number of messages in the queue: 1
2025-08-13 01:20:03 [INFO]: item found in queue is if condition  14409
2025-08-13 01:20:03 [INFO]: item found in queue is  14409
2025-08-13 01:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBroC2IBx7+arY9NLwlXkS0AA2+xiczEZ6z444oOKtomTCsxduNEPtlXJ10k1/f6fsa6scMuWIoM6BrNH1v36f+dVNJ3U8en4Wuyt0Eev0ClN4pLFDGquiP9CSUsQVgDIcQ/I3bEVEwKKo+uPimUFPjc016Jnl++gX6+XQqu3KRMFucGcTxKpfvcWWAhFdyoJlRNT5NNqpnuEkUDiCq1ahG4VJfTelcFd90pQx2TLBMIftBQRl5mTIcMJi/g6udT3WFTONkS7B9dFV6VFL4xjNuZThwp54EjgF+p2EASS91UPLDty4R768cK92EuWM3G1VDJAbfiQhJeiJpK+OXh+Qf4vI1Q6YTd9XV3KN+4QlwXkkwtL4LhlVE4fbabguqBhkXJDhg6f94+f/9Qh4Sp+xzZJDcD6OKPKWli5jbdXgCoiCYr3DoFar9pht0DSpLg/f
2025-08-13 01:20:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-13 01:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 01:20:04 [INFO]: inside itemsold and closed 14409
2025-08-13 01:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 01:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-13 01:20:06 [INFO]: Ebay item id :: 285736513897 exists in Database
2025-08-13 01:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 01:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 01:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 01:20:06 [INFO]: in processold action queue is array    for {"44714222":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44714222","ebayitemid":"285736513897","shopifyproductid":"8303355789534","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8303355789534","shopifyvariantid":"44851960250590","shopifyinventoryid":"46950004588766","shopifylocationid":"","product_id":"44714222","variant_id":"77621835","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 01:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 01:20:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 01:20:06 [INFO]: Shopify Inventory id 46950004588766
2025-08-13 01:20:06 [INFO]: Shopify Location id 58450641063
2025-08-13 01:20:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 01:20:06 [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-13 01:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 01:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44714222 and user_id = 14409 
2025-08-13 01:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77621835 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 01:20:06 [INFO]: updateIdsQuantity -> ["77621835"]
2025-08-13 01:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-13 01:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77621835 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77621835 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77621835)
2025-08-13 01:20:06 [INFO]: QUANTITY Updated IDs: 77621835
2025-08-13 01:20:06 [INFO]: Successfully processed data for user 14409
2025-08-13 01:20:06 [INFO]: Execution Started
2025-08-13 01:20:06 [INFO]: Execution Finished
2025-08-13 01:30:01 [INFO]: Execution Started
2025-08-13 01:30:01 [INFO]: old server sucessfully connected
2025-08-13 01:30:01 [INFO]: sqs client sucess created
2025-08-13 01:30:02 [INFO]: Number of messages in the queue: 0
2025-08-13 01:30:23 [INFO]: Execution Started
2025-08-13 01:30:23 [INFO]: Execution Finished
2025-08-13 01:40:01 [INFO]: Execution Started
2025-08-13 01:40:01 [INFO]: old server sucessfully connected
2025-08-13 01:40:01 [INFO]: sqs client sucess created
2025-08-13 01:40:03 [INFO]: Number of messages in the queue: 0
2025-08-13 01:40:23 [INFO]: Execution Started
2025-08-13 01:40:23 [INFO]: Execution Finished
2025-08-13 01:50:01 [INFO]: Execution Started
2025-08-13 01:50:01 [INFO]: old server sucessfully connected
2025-08-13 01:50:01 [INFO]: sqs client sucess created
2025-08-13 01:50:02 [INFO]: Number of messages in the queue: 1
2025-08-13 01:50:02 [INFO]: item found in queue is if condition  14409
2025-08-13 01:50:02 [INFO]: item found in queue is  14409
2025-08-13 01:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoWmblWdbgGP8wIeW+OkAUz+EVOJGsKZD+3sTEBq+QMdSn6BlpX7DW1YE518SKVYz93QGfsT3gUB/m5G8KtNaCo3USjL+otZzglyKzugpzCYKayXJUnOPqLX21Ibi8dk0MWcLwgQAieFs/hsNbXMyc0P6R7C146Mew2zArtMyfnXRSj+RCYTlXS5NdhESpMZLF7rYTsGE6/XTlvuxrb5GoEgoids3xxHmI8c6EIGw1dvZ5k0GNQRMEJr6p+Frbp3mufphaLTGh491zQbW82hoEeYwYKXD7TAU4Ehx7Wk3QwRMm9Wm4kMATp2sUCv1sUruU7LBIWx5j0n4NShm0xHEMhQrFEUYwVFF8oETnxIvwgEK0D8IqX90GEkYSpPLTlJNoe2khi7manXhbvTvkbT8rsDYmxwfNcsBAhtO5Y+nX9reMwuX21+BOxqmextc2pOF
2025-08-13 01:50:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-13 01:50:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-13 01:50:03 [INFO]: inside itemsold and closed 14409
2025-08-13 01:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-13 01:50:05 [INFO]: autolink for user_id 14409 is 1
2025-08-13 01:50:05 [INFO]: Ebay item id :: 286574068634 exists in Database
2025-08-13 01:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-13 01:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-13 01:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-13 01:50:05 [INFO]: in processold action queue is array    for {"44984126":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44984126","ebayitemid":"286574068634","shopifyproductid":"8937288958174","variants":[{"price":"14.99","quantity":0,"weight":"1","shopifyproductid":"8937288958174","shopifyvariantid":"46989713408222","shopifyinventoryid":"49101116539102","shopifylocationid":"58450641063","product_id":"44984126","variant_id":"77903858","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-13 01:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-13 01:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-13 01:50:05 [INFO]: Shopify Inventory id 49101116539102
2025-08-13 01:50:05 [INFO]: Shopify Location id 58450641063
2025-08-13 01:50:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-13 01:50:05 [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-13 01:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-13 01:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44984126 and user_id = 14409 
2025-08-13 01:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77903858 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-13 01:50:05 [INFO]: updateIdsQuantity -> ["77903858"]
2025-08-13 01:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-13 01:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77903858 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77903858 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77903858)
2025-08-13 01:50:05 [INFO]: QUANTITY Updated IDs: 77903858
2025-08-13 01:50:05 [INFO]: Successfully processed data for user 14409
2025-08-13 01:50:05 [INFO]: Execution Started
2025-08-13 01:50:05 [INFO]: Execution Finished