2025-08-07 03:00:01 [INFO]: Execution Started
2025-08-07 03:00:01 [INFO]: old server sucessfully connected
2025-08-07 03:00:01 [INFO]: sqs client sucess created
2025-08-07 03:00:02 [INFO]: Number of messages in the queue: 1
2025-08-07 03:00:02 [INFO]: item found in queue is if condition  14409
2025-08-07 03:00:02 [INFO]: item found in queue is  14409
2025-08-07 03:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB+Ly+QvqGFb3LDXNWUTD1odTimei+ziUT++NsZZVkTuH3gcqwB1GpXXnMBZIZ6Pei9+WwcFbEEXjj0h0szr+VEnvhGzYaA7tDYf+9Hva2Ix/+y26mozDZvmU5oWlIbZAuNpl+jiC5N+cWSGuBzEb77mhNxYo5G+yMw0A9/l0G9PvQv39aZTojw1qO+a0nlu8COTdYqqFQgpHAtJRFXkBqozpXpEqSihyeLN2BoZlGJEyzsAy30XiAVt9JEdsI8d6IrBHJFwlt/DPJ9nWbo+c0tLcC3VO/cvnhkn7T9txWa4r1qIbDoUVdfct4iF3AM3fY6R99T85y5hBahY8b0ULNKi342ags5ywKxTXZSh1qq2ELvH4cAAs9mDsLGxDiCdn0BNtWPdVWilp++ZTDmKIw4Lo4fLNoC5QJBf++HJFWyP7ZgLfhsmyYwgqra4u9SF/b
2025-08-07 03:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-07 03:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 03:00:03 [INFO]: inside itemsold and closed 14409
2025-08-07 03:00:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 03:00:04 [INFO]: autolink for user_id 14409 is 1
2025-08-07 03:00:04 [INFO]: Ebay item id :: 226214425349 exists in Database
2025-08-07 03:00:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 03:00:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 03:00:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 03:00:04 [INFO]: in processold action queue is array    for {"44679963":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679963","ebayitemid":"226214425349","shopifyproductid":"8700423438558","variants":[{"price":"12.99","quantity":0,"weight":"1","shopifyproductid":"8700423438558","shopifyvariantid":"45946937213150","shopifyinventoryid":"48045494436062","shopifylocationid":"","product_id":"44679963","variant_id":"77585183","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 03:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 03:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 03:00:05 [INFO]: Shopify Inventory id 48045494436062
2025-08-07 03:00:05 [INFO]: Shopify Location id 58450641063
2025-08-07 03:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 03:00:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T03:00: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-07 03:00:05 [INFO]: Change: available | Delta: -1
2025-08-07 03:00:05 [INFO]: Change: on_hand | Delta: -1
2025-08-07 03:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 03:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679963 and user_id = 14409 
2025-08-07 03:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77585183 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 03:00:05 [INFO]: updateIdsQuantity -> ["77585183"]
2025-08-07 03:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 03:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77585183 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77585183 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77585183)
2025-08-07 03:00:05 [INFO]: QUANTITY Updated IDs: 77585183
2025-08-07 03:00:05 [INFO]: Successfully processed data for user 14409
2025-08-07 03:00:05 [INFO]: Execution Started
2025-08-07 03:00:05 [INFO]: Execution Finished
2025-08-07 03:10:01 [INFO]: Execution Started
2025-08-07 03:10:01 [INFO]: old server sucessfully connected
2025-08-07 03:10:01 [INFO]: sqs client sucess created
2025-08-07 03:10:03 [INFO]: Number of messages in the queue: 0
2025-08-07 03:10:23 [INFO]: Execution Started
2025-08-07 03:10:23 [INFO]: Execution Finished
2025-08-07 03:20:01 [INFO]: Execution Started
2025-08-07 03:20:01 [INFO]: old server sucessfully connected
2025-08-07 03:20:02 [INFO]: sqs client sucess created
2025-08-07 03:20:03 [INFO]: Number of messages in the queue: 0
2025-08-07 03:20:23 [INFO]: Execution Started
2025-08-07 03:20:23 [INFO]: Execution Finished
2025-08-07 03:30:01 [INFO]: Execution Started
2025-08-07 03:30:01 [INFO]: old server sucessfully connected
2025-08-07 03:30:01 [INFO]: sqs client sucess created
2025-08-07 03:30:02 [INFO]: Number of messages in the queue: 2
2025-08-07 03:30:03 [INFO]: item found in queue is if condition  14409
2025-08-07 03:30:03 [INFO]: item found in queue is  14409
2025-08-07 03:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB46DaJF6ia9WDBtS5PBEle7XjsSTWBmrKpcFe0hy3cm6CYpbaAeYTRyMtOHSVNdm3kFuC6IlqzGaFDGiwN6o7XpMScY3N1zt3hppjT4k2Ez+0vDBWeCZoNVlAP36o9YRZ0p6+iGDrEC+ha2A8+NPoY6BIxvGwmKGXi5/625aWRqXw2Pt4Q6CpK1Q2vECTwRka2DjsLlxhyAPzY1cq2RhfaIMYaADVWYF811LqldrKLtO2kBaeJdedKY8CesU6d/jyv5QnsMuM4IKxS1UoI/tVIX48YfMffDSCXQ9cMtP6SYry3PJhnB9qnZfMFMXmJJGsTRF/2tv7XfJ/bueB9R51iUCON1ibNdXtrs1ME9KQueWfQH60L/vxs1xlBAVVTrdXKKbDHbtRpPqFojRfKuXs8M/TlvdRrxyaYNATzkrDBxOkVnKYu/Khau9+s+Br1JhO
2025-08-07 03:30:03 [INFO]: item found in queue is if condition  14409
2025-08-07 03:30:03 [INFO]: item found in queue is  14409
2025-08-07 03:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBwKjSKGbM4mRFYPC3V54g3XNbosgDT6yU7z+PP+oi3K0D75aeWjSH8VmAbSE2PDZJlqtVamdJHKUZJ+jJ6qWY5940HDPuj+6XpIBbETYcnXgggOi3QKGPjAoekpUxKKrtXXAUZyryurrV95f+Rsq6hsloXO2HehLqKjcgaD+InmZ93fGELmRi3LDHn0EH8jtBT6FASb6CDXmpsqFVYNz6lZikrBOw0aiM3IHlC2kExQF/0nSFq5SdPGKLgqD+MaO2L6qi1NvoXUi1JaZlEkfpLb7fyXRORE4nzgzZz8MBWxUNKmrNmgiAjtt6Vp87PIBeZsEe+91Ww9cmUOPvp317kQMmgfLgyMw55RJDi+xb+rnQ5+f2Z4QRJDfHuJfGuogmoGVizkbRsAyHWZZvrxlx+VaLjwvISpxxbwoAKBquZsW6/ODvrcC8gZJvHz3z5Wyl
2025-08-07 03:30:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-07 03:30:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 03:30:03 [INFO]: inside itemsold and closed 14409
2025-08-07 03:30:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 03:30:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 03:30:05 [INFO]: not in db for user_id 14409 and the ebayitemid257042629343
2025-08-07 03:30:05 [INFO]: inside itemsold and closed 14409
2025-08-07 03:30:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 03:30:07 [INFO]: autolink for user_id 14409 is 1
2025-08-07 03:30:07 [INFO]: Ebay item id :: 286551111675 exists in Database
2025-08-07 03:30:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 03:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 03:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 03:30:07 [INFO]: in processold action queue is array    for {"44562394":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44562394","ebayitemid":"286551111675","shopifyproductid":"8285899030750","variants":[{"price":"42.75","quantity":0,"weight":"20","shopifyproductid":"8285899030750","shopifyvariantid":"44805406195934","shopifyinventoryid":"46903433625822","shopifylocationid":"","product_id":"44562394","variant_id":"77455074","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 03:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 03:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 03:30:07 [INFO]: Shopify Inventory id 46903433625822
2025-08-07 03:30:07 [INFO]: Shopify Location id 58450641063
2025-08-07 03:30:07 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 03:30:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T03:30: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-07 03:30:07 [INFO]: Change: available | Delta: -1
2025-08-07 03:30:07 [INFO]: Change: on_hand | Delta: -1
2025-08-07 03:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 03:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44562394 and user_id = 14409 
2025-08-07 03:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77455074 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 03:30:07 [INFO]: updateIdsQuantity -> ["77455074"]
2025-08-07 03:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 03:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77455074 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77455074 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77455074)
2025-08-07 03:30:07 [INFO]: QUANTITY Updated IDs: 77455074
2025-08-07 03:30:07 [INFO]: Successfully processed data for user 14409
2025-08-07 03:30:07 [INFO]: Execution Started
2025-08-07 03:30:07 [INFO]: Execution Finished
2025-08-07 03:40:01 [INFO]: Execution Started
2025-08-07 03:40:01 [INFO]: old server sucessfully connected
2025-08-07 03:40:01 [INFO]: sqs client sucess created
2025-08-07 03:40:02 [INFO]: Number of messages in the queue: 0
2025-08-07 03:40:03 [INFO]: item found in queue is if condition  14409
2025-08-07 03:40:03 [INFO]: item found in queue is  14409
2025-08-07 03:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlh7NfsSh0Z5pF0l+j9LUoROKS8DiQ8YpkgDRatBU3sKa7c6FjQC49JcWdTP9pCX50GA6s+wn4D/OoazOtc4cB8wgwAZlv3GzcaK7R/S2cbqSWgbUf581lpo8AdERz2TpZv9wRNdmRX8khVjHGkwPRIKyFEDeZnh1xSfoQbXkYq2oIJYkil0d+RbWHx9sefoADIxGK1rGJBv5q0sZ1u9kzP2Md+4MK+Hxct6YI66m1DUrxim6cKbftwyCF8aHt/kFdgaLDqOX4qCxEohkRkRFgSrS7IDFgAPR+k0uyN/yajrCWV7jkdgCA5T8K2Ui9qbsnSQw/VB/EcYrmm3HFc3QkJopeWeNRkuqMmf9YphQo9LafMyswe5e+0agw4zROxqdGge4F84AtOqaR6X1cKQNLTBv/KnsrZ2BtGLloTy7joaWtLknIoZ4BLJJL6GZWV9e
2025-08-07 03:40:03 [INFO]: Processed 1 messages, reached the limit of 0.
2025-08-07 03:40:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-07 03:40:03 [INFO]: inside itemsold and closed 14409
2025-08-07 03:40:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-07 03:40:05 [INFO]: autolink for user_id 14409 is 1
2025-08-07 03:40:05 [INFO]: Ebay item id :: 324736264751 exists in Database
2025-08-07 03:40:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-07 03:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-07 03:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-07 03:40:05 [INFO]: in processold action queue is array    for {"44710499":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710499","ebayitemid":"324736264751","shopifyproductid":"6944868237479","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"6944868237479","shopifyvariantid":"40836227596455","shopifyinventoryid":"42932155416743","shopifylocationid":"","product_id":"44710499","variant_id":"77618112","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-07 03:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-07 03:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-07 03:40:05 [INFO]: Shopify Inventory id 42932155416743
2025-08-07 03:40:05 [INFO]: Shopify Location id 58450641063
2025-08-07 03:40:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-07 03:40:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-07T03:40: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-07 03:40:05 [INFO]: Change: available | Delta: -1
2025-08-07 03:40:05 [INFO]: Change: on_hand | Delta: -1
2025-08-07 03:40:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-07 03:40:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710499 and user_id = 14409 
2025-08-07 03:40:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77618112 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-07 03:40:05 [INFO]: updateIdsQuantity -> ["77618112"]
2025-08-07 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-07 03:40:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77618112 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77618112 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77618112)
2025-08-07 03:40:05 [INFO]: QUANTITY Updated IDs: 77618112
2025-08-07 03:40:05 [INFO]: Successfully processed data for user 14409
2025-08-07 03:40:05 [INFO]: Execution Started
2025-08-07 03:40:05 [INFO]: Execution Finished
2025-08-07 03:50:01 [INFO]: Execution Started
2025-08-07 03:50:01 [INFO]: old server sucessfully connected
2025-08-07 03:50:01 [INFO]: sqs client sucess created
2025-08-07 03:50:02 [INFO]: Number of messages in the queue: 0
2025-08-07 03:50:22 [INFO]: Execution Started
2025-08-07 03:50:22 [INFO]: Execution Finished