2025-08-13 16:00:01 [INFO]: Execution Started 2025-08-13 16:00:01 [INFO]: old server sucessfully connected 2025-08-13 16:00:01 [INFO]: sqs client sucess created 2025-08-13 16:00:04 [INFO]: Number of messages in the queue: 2 2025-08-13 16:00:05 [INFO]: item found in queue is if condition 14409 2025-08-13 16:00:05 [INFO]: item found in queue is 14409 2025-08-13 16:00:06 [INFO]: Message deleted from the queue for receipt handle: AQEBfJwCrbVhXfJSXKuDkOzbhm7kw3HGWKaFHRMOa49LqrU9UPuL/nJ5psSR/mWM9jMM+DpDZxO6izYr8dep9lqFUY68zUMVQO2+mHNDYyC6IR/JVqUxwUoytLVbZ61EbpbxuCjh6nDDlhZt4KqUAP7Ol+L0JHt8KjAK+GYBw5+cm6clcoKaWnftQ3S+hp2/vP7MVFa5FlAN3spt9JEqoblJWHrdokYZ/wuccj4Ebw1x+/A2+fWLmnoo8IZjv69To2PM5vDZXTc7CIUdzitDiP9NqkrqeUT2uIRlaHnMgMdftyAYFxBVlzyHrCbU7NJF6Db22TuK0E+wmJyGcI/DElJ4FZsGpLAVq68i2GdxvC+ShD4nzIxkiYMiFBHuqtYBEDUBMqvFndaGEFnekS/lr9miybxdAiTwX1n3lUlYMSLMgcn6oIaIMABxTMZAc0AhO1lZ 2025-08-13 16:00:07 [INFO]: item found in queue is if condition 14409 2025-08-13 16:00:07 [INFO]: item found in queue is 14409 2025-08-13 16:00:07 [INFO]: Message deleted from the queue for receipt handle: AQEBEkiLTS145gzIiagcbpCN7cGZ0frsAXbsR55PAuS7V7quwvjyVvDcIg3WGK8Tdg3Ei5MdxKhtftyDSZhOwrzTrr2mXa1GFNT+qPfZ9A98Pdz17szgeixRCEhcONnDx2kwFs0oOwl727ywL1Gb25bx42BXQENPW32lXe+ccXJmnWKl3nAaAZ6U6XF1Lv7Gc+RI/3/O99Vtl/IkPbXzgTkWF8NgJ/3EUD9jjdoD1LVtnYdaJq3S6k8Zea7X9npO1Lm+bacSQUzI32icEciV6WCKlxoVOrZuhADNMXHEZamRb7H3XqGP81mmK+wIOWjIRH06kxCsXAvSUz4WSFkt1JiBtuvghT133u7+kxX2MH+OX5VUShlDCtUMcq6lMg8vp+7UiKrWBRmAw2eIdTTsk98YSKhOEehihjHnUmb3CCMW8adEaawiWB7W48tBKcSf1weo 2025-08-13 16:00:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 16:00:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 16:00:07 [INFO]: inside itemsold and closed 14409 2025-08-13 16:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:00:09 [INFO]: Ebay item id :: 405752130393 exists in Database 2025-08-13 16:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:00:09 [INFO]: inside itemsold and closed 14409 2025-08-13 16:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:00:11 [INFO]: Ebay item id :: 404228706424 exists in Database 2025-08-13 16:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:00:11 [INFO]: in processold action queue is array for {"44892863":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44892863","ebayitemid":"405752130393","shopifyproductid":"8929164263646","variants":[{"price":"29.99","quantity":0,"weight":"0.75","shopifyproductid":"8929164263646","shopifyvariantid":"46853191598302","shopifyinventoryid":"48964629070046","shopifylocationid":"58450641063","product_id":"44892863","variant_id":"77807523","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44761420":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44761420","ebayitemid":"404228706424","shopifyproductid":"8005102076126","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8005102076126","shopifyvariantid":"44125031792862","shopifyinventoryid":"46221896122590","shopifylocationid":"","product_id":"44761420","variant_id":"77669954","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 16:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 16:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:00:11 [INFO]: Shopify Inventory id 48964629070046 2025-08-13 16:00:11 [INFO]: Shopify Location id 58450641063 2025-08-13 16:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:00: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-13 16:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44892863 and user_id = 14409 2025-08-13 16:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77807523 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:00:12 [INFO]: Shopify Inventory id 46221896122590 2025-08-13 16:00:12 [INFO]: Shopify Location id 58450641063 2025-08-13 16:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:00: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-13 16:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44761420 and user_id = 14409 2025-08-13 16:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77669954 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:00:12 [INFO]: updateIdsQuantity -> ["77807523","77669954"] 2025-08-13 16:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 16:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77807523 THEN 0 WHEN id = 77669954 THEN 0 END, quantityflag = CASE WHEN id = 77807523 THEN 0 WHEN id = 77669954 THEN 0 END WHERE user_id = 14409 AND id IN (77807523,77669954) 2025-08-13 16:00:12 [INFO]: QUANTITY Updated IDs: 77807523, 77669954 2025-08-13 16:00:12 [INFO]: Successfully processed data for user 14409 2025-08-13 16:00:12 [INFO]: Execution Started 2025-08-13 16:00:12 [INFO]: Execution Finished 2025-08-13 16:10:01 [INFO]: Execution Started 2025-08-13 16:10:01 [INFO]: old server sucessfully connected 2025-08-13 16:10:01 [INFO]: sqs client sucess created 2025-08-13 16:10:04 [INFO]: Number of messages in the queue: 0 2025-08-13 16:10:25 [INFO]: Execution Started 2025-08-13 16:10:25 [INFO]: Execution Finished 2025-08-13 16:20:01 [INFO]: Execution Started 2025-08-13 16:20:01 [INFO]: old server sucessfully connected 2025-08-13 16:20:01 [INFO]: sqs client sucess created 2025-08-13 16:20:03 [INFO]: Number of messages in the queue: 1 2025-08-13 16:20:04 [INFO]: item found in queue is if condition 14409 2025-08-13 16:20:04 [INFO]: item found in queue is 14409 2025-08-13 16:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBlzncpbfjjwxi3M6041mWdlC5coXMTegFdfiX7Vms+orpXkwWh3w2smfg2FgONT+j7TefkK72hubtvqZ0Hsn0PD1FHNYQ/nc0bG4D3KSkmGdRm1RQGYAaNmEPOzD3BExF7EAaqqIzHEaa45YkWsrJJ3OHXJ39meK2B/yoW+K6Sd+hBV6SGy4bB7MgJoHms85NtDjpYOr6jn2c7iVp/lF50o9gPfdNHSSmqfCUnSlN3EArm6n5w17CMgQ3uKWz8rV8BDq4kWnOQBaFzhvv1s9UPAsh2ilnwSqZ5Z1C9c/uxSPlBhqsKI9dDPisid65wGDgIXrZaZ2I72usOiQAeOmBZtu5exvYkIikUAo1d3obeYyTRMEalG9EECbiCBZmX5ocedjEK0FjzQAKMfoass2LrlTYXXP+BA9KrwRFqW2hCjK8ldiq2tnEpw3c+Z0mOPzF 2025-08-13 16:20:04 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 16:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 16:20:04 [INFO]: inside itemsold and closed 14409 2025-08-13 16:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:20:06 [INFO]: Ebay item id :: 257008698337 exists in Database 2025-08-13 16:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:20:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-13 16:20:06 [INFO]: in processold action queue is array for {"45205843":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45205843","ebayitemid":"257008698337","deleted":1}}} 2025-08-13 16:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 16:20:06 [INFO]: productIds WHich are having null productid -> [45205843] 2025-08-13 16:20:06 [INFO]: ebayItemIds WHich are not imported-> ["257008698337"] 2025-08-13 16:20:06 [INFO]: Entered in bulkUpdateProducts function 2025-08-13 16:20:06 [INFO]: Transaction started for bulkUpdateProducts 2025-08-13 16:20:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45205843) 2025-08-13 16:20:06 [INFO]: Query executed successfully. Affected rows: 0 2025-08-13 16:20:06 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-13 16:20:06 [INFO]: Transaction committed successfully. 2025-08-13 16:20:06 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-13 16:20:06 [INFO]: Successfully processed data for user 14409 2025-08-13 16:20:06 [INFO]: Execution Started 2025-08-13 16:20:06 [INFO]: Execution Finished 2025-08-13 16:30:01 [INFO]: Execution Started 2025-08-13 16:30:01 [INFO]: old server sucessfully connected 2025-08-13 16:30:01 [INFO]: sqs client sucess created 2025-08-13 16:30:03 [INFO]: Number of messages in the queue: 1 2025-08-13 16:30:04 [INFO]: item found in queue is if condition 14409 2025-08-13 16:30:04 [INFO]: item found in queue is 14409 2025-08-13 16:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBRVZ1QiKnWRRcJmA8Ni7OauUd8Jp88FM5jwjBS2byE47+YV9AuGptNc2mf/5tIx6T2saej9fAPB7Md2O7lyje8a7m2JzVZIG+SbHjPtJTWIC9Gr7LLLVTh+eCr/LujZApCbh7udlhaRCFhp8r1Z/TcV2udUHJ4BfCMkbHKVuHznrI+8Y94upy13DjAeMDCW54L+PruzDHtgWpgT0FY8IyfsQBpgvR7vMD997Wua4ygqWL5k39IajvHu+MRx5avIYH6cTw8hANMmQ88/zHqUtQL5Uek0tQmzSSlnPrGxAZCFJr0UgLdHg8quvYQquAp3B26NBRXZpON334nCDx7U01hTVWxvjXyWDdJJ49G9SpHwtYkzu2nxogiTKxd4pa6Oa3IMfnnr8SmwTdBQOvybWUs5pT/YCaxQL5AJrnb6KiXiqmBjMnxbxUU4iChI4MsccG 2025-08-13 16:30:05 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-13 16:30:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 16:30:05 [INFO]: inside itemsold and closed 14409 2025-08-13 16:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:30:07 [INFO]: Ebay item id :: 334518538423 exists in Database 2025-08-13 16:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:30:07 [INFO]: in processold action queue is array for {"44598316":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44598316","ebayitemid":"334518538423","shopifyproductid":"7750276284638","variants":[{"price":"46.99","quantity":0,"weight":"2","shopifyproductid":"7750276284638","shopifyvariantid":"43229679321310","shopifyinventoryid":"45324808749278","shopifylocationid":"","product_id":"44598316","variant_id":"77491025","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 16:30:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 16:30:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:30:07 [INFO]: Shopify Inventory id 45324808749278 2025-08-13 16:30:07 [INFO]: Shopify Location id 58450641063 2025-08-13 16:30:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:30:07 [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 16:30:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:30:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44598316 and user_id = 14409 2025-08-13 16:30:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77491025 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:30:07 [INFO]: updateIdsQuantity -> ["77491025"] 2025-08-13 16:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 16:30:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77491025 THEN 0 END, quantityflag = CASE WHEN id = 77491025 THEN 0 END WHERE user_id = 14409 AND id IN (77491025) 2025-08-13 16:30:07 [INFO]: QUANTITY Updated IDs: 77491025 2025-08-13 16:30:07 [INFO]: Successfully processed data for user 14409 2025-08-13 16:30:07 [INFO]: Execution Started 2025-08-13 16:30:07 [INFO]: Execution Finished 2025-08-13 16:40:01 [INFO]: Execution Started 2025-08-13 16:40:01 [INFO]: old server sucessfully connected 2025-08-13 16:40:01 [INFO]: sqs client sucess created 2025-08-13 16:40:05 [INFO]: Number of messages in the queue: 2 2025-08-13 16:40:06 [INFO]: item found in queue is if condition 14409 2025-08-13 16:40:06 [INFO]: item found in queue is 14409 2025-08-13 16:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBhGR9Fm9qvYQHzkLWPNxm4tNqAIQ0meN3YAIcoXUpqEnsKZmRJreyYB656voDG3XYYWGY+OSmR5qltr19CjTOyjLDMA4/NvlnaLh5wpHGRpCfPrhhZBqVhewef3Z0DuhTbGxLDrLuxeW4n//fAX7YYVo1Bg4MrelrwR8MOlA3wZ3yryIi3U7RHXP67akCz4mpjji7fYAs2v22vyxNblDG2CWVz6efiXaz3ZuoP4swPmOV33T8LXSIhwsuyvxySXDGaE+PMc+hqT19yEExpYdLlSiSVwl1uS6BrN6DjLec9G/i4LxU4QuZHwP03vtgWaZT/UyX26T3a0M6Wklwjcg9BOLs0MubdCDNh0c+w25GY5DVYNGciN8NNmK2rqN/Gh6ptB6duM95V78XmTwZ3MScrP5S9H2Bakqzu+nJHLM0Y4n51bpjZR5Zd/vqoYs+ukGV 2025-08-13 16:40:08 [INFO]: item found in queue is if condition 14409 2025-08-13 16:40:08 [INFO]: item found in queue is 14409 2025-08-13 16:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEBdxTrYeYKoHvcQcyUzzCNdRUGkMK2IEwX4V1EDCkrb1VJTYZLyInPfM1Qu0eIhA10/qs/icCDPnAPRIoksG1d/5YsqtuzHSqcP1+XwyGmBbWl4sRy8GRSLYd1OHwpirxW+Gx1W0LbL51DOrff9UN+WzCXNDqlcbMv4Mgxd8q59TE+rDLS3WNOophY7pisK8ZBcExqz02XrZk4sNCDUVfufZJI1tk1GIEeXn0yEjqyUJb5cXnXvtluuZS0BImk9iJ4VT2yr7eiiqAoPN6UwZKqjx7ucNpixYXFIE7m4FPHeCDxv5j/Jjk2XpqRnIzQPxvfaXKx+0b9vU/YdpVrqj/jhlmKcbm3BowKy48F0onmCVV1kcrdDIZzgi/OzweC2AU21hsYGRfuO9yFfUxzxtYcetr3io/M4pUV3ados/Or8+P2F3zxlkEG3I4EA5J+nRiq 2025-08-13 16:40:09 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 16:40:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 16:40:09 [INFO]: inside itemsold and closed 14409 2025-08-13 16:40:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:40:11 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:40:11 [INFO]: Ebay item id :: 336100630575 exists in Database 2025-08-13 16:40:11 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:40:11 [INFO]: inside itemsold and closed 14409 2025-08-13 16:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:40:12 [INFO]: Ebay item id :: 256330815267 exists in Database 2025-08-13 16:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:40:12 [INFO]: in processold action queue is array for {"45312945":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45312945","ebayitemid":"336100630575","shopifyproductid":"8976176611550","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8976176611550","shopifyvariantid":"47183135113438","shopifyinventoryid":"49294969995486","shopifylocationid":"58450641063","product_id":"45312945","variant_id":"78265458","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44769271":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44769271","ebayitemid":"256330815267","shopifyproductid":"8228283482334","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8228283482334","shopifyvariantid":"44585907683550","shopifyinventoryid":"46683873149150","shopifylocationid":"","product_id":"44769271","variant_id":"77677813","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 16:40:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:40:12 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:40:12 [INFO]: Shopify Inventory id 49294969995486 2025-08-13 16:40:12 [INFO]: Shopify Location id 58450641063 2025-08-13 16:40:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:40:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-13T16:40:13Z","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 16:40:13 [INFO]: Change: available | Delta: -1 2025-08-13 16:40:13 [INFO]: Change: on_hand | Delta: -1 2025-08-13 16:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45312945 and user_id = 14409 2025-08-13 16:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265458 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:40:13 [INFO]: Shopify Inventory id 46683873149150 2025-08-13 16:40:13 [INFO]: Shopify Location id 58450641063 2025-08-13 16:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:40:13 [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 16:40:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:40:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44769271 and user_id = 14409 2025-08-13 16:40:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77677813 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:40:13 [INFO]: updateIdsQuantity -> ["78265458","77677813"] 2025-08-13 16:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-13 16:40:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 78265458 THEN 0 WHEN id = 77677813 THEN 0 END, quantityflag = CASE WHEN id = 78265458 THEN 0 WHEN id = 77677813 THEN 0 END WHERE user_id = 14409 AND id IN (78265458,77677813) 2025-08-13 16:40:13 [INFO]: QUANTITY Updated IDs: 78265458, 77677813 2025-08-13 16:40:13 [INFO]: Successfully processed data for user 14409 2025-08-13 16:40:13 [INFO]: Execution Started 2025-08-13 16:40:13 [INFO]: Execution Finished 2025-08-13 16:50:02 [INFO]: Execution Started 2025-08-13 16:50:02 [INFO]: old server sucessfully connected 2025-08-13 16:50:02 [INFO]: sqs client sucess created 2025-08-13 16:50:04 [INFO]: Number of messages in the queue: 2 2025-08-13 16:50:05 [INFO]: item found in queue is if condition 14409 2025-08-13 16:50:05 [INFO]: item found in queue is 14409 2025-08-13 16:50:05 [INFO]: Message deleted from the queue for receipt handle: AQEBC3KiNa3SUFVzi1/G8aWsHxa/Y5ugXf9RN4kNrOKvTCFLsXcRp4rQo7zZDrTLYPzJpCFvAK4SuT8LI1ooKGhk+P71/wLDySd97rHbV6LaY72uDLO7g6e/S3oAqxupOOOuVx9E2yIT6sOISK5adPtsHkYdNTXJLMSRX0weV75VLYMwAV6XJBRTSxp7RlKoF0h3+L6zvZhh6g9iKyhaHdRZdS7C7vgd5ZI4XwU9kSRAS5CxRLngHL8BlGBs2S9IVm2oAOF7w9hTWoJnhjyL74GqbLlXAJCOjZU/V8N6yFrPvS+Xozu2EmiuZ4oiv7wr2JAUvX7VQX/6XRp8toHy8j7jKFaTbQybEFlyTD0ebzThReRwiFiP48WL4DSbMFPsVXYxBRNY4A6zkSBPZYrX/0GPTmjUWiKc+RobvT5SuNFX4IrCFamajtUeVWrWvuxIp5RS 2025-08-13 16:50:07 [INFO]: item found in queue is if condition 14409 2025-08-13 16:50:07 [INFO]: item found in queue is 14409 2025-08-13 16:50:07 [INFO]: Message deleted from the queue for receipt handle: AQEBzqi3z9op2HKXvwKdrzFcGHtFdahoGXin8Ub1neJmR1p7G4/GAE84uy7WuWJxLuEczBoyxWOPHXUxQ9cxiB13pouvF9Uyqaqzx2h8JlXSp8YPIj1YezgqcZuROLsxTRegKGORp6VaLb+6U69SvUF5hGd4fr4Gjk2JZHzGORVtVHM4+/L3zb+8UTtTwECMPwbIkv7tY67JgO391NnqqCgKH6ztfysIQ21I+o58wZU4KVtRYPDaBwupT7fcIkSmJ8cP9qJ31yXPTOSolL6rxwhA/W6PYS+M/jituZSi0dxUWB3d34dR/oeKmLrv+ufa4cmYOzT4o+W4iLIVNKPvKFdWR0TCFRV9oP0MaUuk1CTn0VGp2HMsMvW0qCbdn5mVsvjFUjW7+jA1Sk1FdX51jZs0pm/2N+tPCPbDkLuhoZ0BH5xiJj81V2azhF3HgR7EZjl4 2025-08-13 16:50:07 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-13 16:50:07 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-13 16:50:07 [INFO]: inside itemsold and closed 14409 2025-08-13 16:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:50:09 [INFO]: Ebay item id :: 404401520453 exists in Database 2025-08-13 16:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-13 16:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-13 16:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-13 16:50:09 [INFO]: inside itemsold and closed 14409 2025-08-13 16:50:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-13 16:50:11 [INFO]: autolink for user_id 14409 is 1 2025-08-13 16:50:11 [INFO]: not in db for user_id 14409 and the ebayitemid286730743876 2025-08-13 16:50:11 [INFO]: in processold action queue is array for {"44679181":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679181","ebayitemid":"404401520453","shopifyproductid":"7868341977310","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"7868341977310","shopifyvariantid":"43636046758110","shopifyinventoryid":"45731799630046","shopifylocationid":"","product_id":"44679181","variant_id":"77584401","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-13 16:50:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-13 16:50:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-13 16:50:11 [INFO]: Shopify Inventory id 45731799630046 2025-08-13 16:50:11 [INFO]: Shopify Location id 58450641063 2025-08-13 16:50:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-13 16:50:11 [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 16:50:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-13 16:50:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679181 and user_id = 14409 2025-08-13 16:50:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77584401 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-13 16:50:11 [INFO]: updateIdsQuantity -> ["77584401"] 2025-08-13 16:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-13 16:50:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77584401 THEN 0 END, quantityflag = CASE WHEN id = 77584401 THEN 0 END WHERE user_id = 14409 AND id IN (77584401) 2025-08-13 16:50:11 [INFO]: QUANTITY Updated IDs: 77584401 2025-08-13 16:50:11 [INFO]: Successfully processed data for user 14409 2025-08-13 16:50:11 [INFO]: Execution Started 2025-08-13 16:50:11 [INFO]: Execution Finished