2025-08-01 21:00:01 [INFO]: Execution Started 2025-08-01 21:00:01 [INFO]: old server sucessfully connected 2025-08-01 21:00:02 [INFO]: sqs client sucess created 2025-08-01 21:00:03 [INFO]: Number of messages in the queue: 1 2025-08-01 21:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 21:00:03 [INFO]: item found in queue is 14409 2025-08-01 21:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlf95RauHGmRWwFZQSyMs6MiNGAM8cgOyaczlqpfx3YFqX37FVES+A13vlraKk3GjECzWa/nrHS99PH5ZGOemSxJ5YQ7ZOsLNLNdXjgqcqfpnrEBLIWctkiYnwgWT63iVtyoZVUQUVXAH2AnQXoxIxvNFQk7ptKJsnWYr2EXgA19ZMCZfyn8XOz+V31VdfzMnEKeTLsWZ9aRD8WbO9YpWIXxFEY+bZZyKJemEgKEcOj0gtsrHEYQ9KeVxo0Za1vVZjgkVTOhEErnBEhUguRiU/Y81kUdf7H6geZj55o/ZaB1dgoZrxP8cGHYtF2p3RCmX9n3P9O1WSB8YXMR3KLVuXdI9fFGKkkrOixXYAhwuwggVEuu8H7rVvYEUH5MdnscehHViDik8Fo08tCUlW4ugF88mn5Nn1g2qxju2l2/8/MeP6Je7PjaB0sPgGvGhkd2W 2025-08-01 21:00:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 21:00:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 21:00:03 [INFO]: inside itemsold and closed 14409 2025-08-01 21:00:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:00:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:00:05 [INFO]: Ebay item id :: 226791566444 exists in Database 2025-08-01 21:00:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:00:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 21:00:05 [INFO]: in processold action queue is array for {"45066205":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45066205","ebayitemid":"226791566444","deleted":1}}} 2025-08-01 21:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 21:00:05 [INFO]: productIds WHich are having null productid -> [45066205] 2025-08-01 21:00:05 [INFO]: ebayItemIds WHich are not imported-> ["226791566444"] 2025-08-01 21:00:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 21:00:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 21:00:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45066205) 2025-08-01 21:00:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 21:00:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 21:00:05 [INFO]: Transaction committed successfully. 2025-08-01 21:00:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 21:00:05 [INFO]: Successfully processed data for user 14409 2025-08-01 21:00:05 [INFO]: Execution Started 2025-08-01 21:00:05 [INFO]: Execution Finished 2025-08-01 21:10:01 [INFO]: Execution Started 2025-08-01 21:10:01 [INFO]: old server sucessfully connected 2025-08-01 21:10:01 [INFO]: sqs client sucess created 2025-08-01 21:10:02 [INFO]: Number of messages in the queue: 0 2025-08-01 21:10:22 [INFO]: Execution Started 2025-08-01 21:10:22 [INFO]: Execution Finished 2025-08-01 21:20:01 [INFO]: Execution Started 2025-08-01 21:20:01 [INFO]: old server sucessfully connected 2025-08-01 21:20:01 [INFO]: sqs client sucess created 2025-08-01 21:20:02 [INFO]: Number of messages in the queue: 0 2025-08-01 21:20:22 [INFO]: Execution Started 2025-08-01 21:20:22 [INFO]: Execution Finished 2025-08-01 21:30:02 [INFO]: Execution Started 2025-08-01 21:30:02 [INFO]: old server sucessfully connected 2025-08-01 21:30:02 [INFO]: sqs client sucess created 2025-08-01 21:30:03 [INFO]: Number of messages in the queue: 2 2025-08-01 21:30:03 [INFO]: item found in queue is if condition 14409 2025-08-01 21:30:03 [INFO]: item found in queue is 14409 2025-08-01 21:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBOb+SnKmEMA87jBTunkvWlZk/HsqtAbqr/Bsct3eNwNiUgXEnS3M+PEdw825Rg3AkPmPlrrbWPw0/RnWytgsOp3Pe1cVN1l5rA9tKCfocSE4HB/lKzHK484QLtpL/pnmrZB3Dnr2BxJyoB00v42esJab5bBkezE/HvDyxk21PMgHIYYelsQNA21ECeKmk6x3xszYG4VgtHEC/dBLoh7Ob38Kb7+rswMJD03bLHdjeCtX33JY2Hyn+A04+uXMBJ2qHUSPKIUjQbbj9ILdHZ5JvAn4Y3tEOoUxo/3+lPhnlxpvO6vlcVrqe3Sbv1vuLOHpcqbE3/r3VKoxH6/aecQo6bSMNAdpErZC2vQl4To+WsxKcfx9GNyWS3qeaBsfHdGTLV36/Irfcg7ildTLIjGlQ4xwNaVgRJSbzu2Bj/bnPS9YTCdUhaQ7FYRskNZBXnvDk 2025-08-01 21:30:04 [INFO]: item found in queue is if condition 14409 2025-08-01 21:30:04 [INFO]: item found in queue is 14409 2025-08-01 21:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBnDd9levNzo0HN17ro6fLbO0xPFky9VkRJwTlZZ2YIsfNMG/X8UqlZTvoyVlcFBW26Us6rvG+HTKKm5cvaoeHRHA1nihLANRGMH+q2JL4VxvuBL+0TXaOv01g9Pv1lTnVZ99Ej1WCLoz06gwe3WffxhCY38+HE3KXOnU5ecX+4ycFWVE6ePeMBE9x6E5MFvw1QYmsaY4nTm1rgSX4tvikfI1ICGgPWFsJsHxIW4DDtMrDz1/bhicJxc0egXZlWptX/cHbzOwM+YE7mwDVAuuuEJMgqDbTVK7xz651N6qTUFCuQD3ABARuulvwJQ2Rucwp5eQ3g0rX/xEVGtQ270vAC2iqX91Nke+spDAWvAx9J6oHpKK9u8pPAQkHzkBDm8H6/SDlp0X7xzz54D9J3kt8K7s5tZHfRtF0pDf7HARm4twGZRJ/QC0y+xCOkv4btwPm 2025-08-01 21:30:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 21:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 21:30:04 [INFO]: inside itemsold and closed 14409 2025-08-01 21:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:30:07 [INFO]: Ebay item id :: 326133954857 exists in Database 2025-08-01 21:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 21:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 21:30:07 [INFO]: inside itemsold and closed 14409 2025-08-01 21:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:30:09 [INFO]: Ebay item id :: 326484557570 exists in Database 2025-08-01 21:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 21:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 21:30:09 [INFO]: in processold action queue is array for {"44663284":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44663284","ebayitemid":"326133954857","shopifyproductid":"8493900792030","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8493900792030","shopifyvariantid":"45398103261406","shopifyinventoryid":"47496081539294","shopifylocationid":"","product_id":"44663284","variant_id":"77568504","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44643187":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44643187","ebayitemid":"326484557570","shopifyproductid":"8840913060062","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8840913060062","shopifyvariantid":"46360757272798","shopifyinventoryid":"48462566162654","shopifylocationid":"","product_id":"44643187","variant_id":"77548376","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 21:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 21:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 21:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 21:30:09 [INFO]: Shopify Inventory id 47496081539294 2025-08-01 21:30:09 [INFO]: Shopify Location id 58450641063 2025-08-01 21:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 21:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T21:30:09Z","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-01 21:30:09 [INFO]: Change: available | Delta: -3 2025-08-01 21:30:09 [INFO]: Change: on_hand | Delta: -3 2025-08-01 21:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 21:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44663284 and user_id = 14409 2025-08-01 21:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77568504 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 21:30:09 [INFO]: Shopify Inventory id 48462566162654 2025-08-01 21:30:09 [INFO]: Shopify Location id 58450641063 2025-08-01 21:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 21:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T21:30:10Z","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-01 21:30:10 [INFO]: Change: available | Delta: -1 2025-08-01 21:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-01 21:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 21:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44643187 and user_id = 14409 2025-08-01 21:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77548376 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 21:30:10 [INFO]: updateIdsQuantity -> ["77568504","77548376"] 2025-08-01 21:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-01 21:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77568504 THEN 0 WHEN id = 77548376 THEN 0 END, quantityflag = CASE WHEN id = 77568504 THEN 0 WHEN id = 77548376 THEN 0 END WHERE user_id = 14409 AND id IN (77568504,77548376) 2025-08-01 21:30:10 [INFO]: QUANTITY Updated IDs: 77568504, 77548376 2025-08-01 21:30:10 [INFO]: Successfully processed data for user 14409 2025-08-01 21:30:10 [INFO]: Execution Started 2025-08-01 21:30:10 [INFO]: Execution Finished 2025-08-01 21:40:01 [INFO]: Execution Started 2025-08-01 21:40:01 [INFO]: old server sucessfully connected 2025-08-01 21:40:02 [INFO]: sqs client sucess created 2025-08-01 21:40:03 [INFO]: Number of messages in the queue: 1 2025-08-01 21:40:03 [INFO]: item found in queue is if condition 14409 2025-08-01 21:40:03 [INFO]: item found in queue is 14409 2025-08-01 21:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBgUsBrk5NmqiVTDM8Fq7iccm0H6mKXxK5EGYASvq/fDzCnA4bUTtJnVMkmHWen21z0x+yeGdJNMbweC+Ske8w4pWceB93Uj+gt9dU/FtTWprArqROafjD8a+486k61Hq061BO9F4yBW78TNjTW7ormzmkreiCr3dYGK5TEzpHxnjm3wmB6urerLpW3euf9aO1rnj70Y71oOVHjIfGUrfDaeAWfNhzF1GhlGf4xKaipyxfOL2mcweHwhVumx2jiX0RHuU08/YRROjKfw76hgXD2ai/H1YxkyHu74MO9rG1MRrDQMVaxT6SG3b10MbgfJbynGS6AfGApicwOMVSYR0/TW2GQQazt75RIRcLPXTubZdqkjr3l2j0Rjl/MoqV1jLZySHdTJ/NDOm6zwnZeReO1pcpLwHk7woTdAYJOSNYnRem54icUQ4JPTRO4TyAvEXl 2025-08-01 21:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 21:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 21:40:03 [INFO]: inside itemsold and closed 14409 2025-08-01 21:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:40:05 [INFO]: Ebay item id :: 326443693534 exists in Database 2025-08-01 21:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:40:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 21:40:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 21:40:05 [INFO]: in processold action queue is array for {"44646265":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44646265","ebayitemid":"326443693534","shopifyproductid":"8817217765598","variants":[{"price":"10.99","quantity":0,"weight":"0.5","shopifyproductid":"8817217765598","shopifyvariantid":"46289369989342","shopifyinventoryid":"48390294110430","shopifylocationid":"","product_id":"44646265","variant_id":"77551454","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 21:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 21:40:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 21:40:05 [INFO]: Shopify Inventory id 48390294110430 2025-08-01 21:40:05 [INFO]: Shopify Location id 58450641063 2025-08-01 21:40:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 21:40:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T21:40:06Z","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-01 21:40:06 [INFO]: Change: available | Delta: -1 2025-08-01 21:40:06 [INFO]: Change: on_hand | Delta: -1 2025-08-01 21:40:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 21:40:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44646265 and user_id = 14409 2025-08-01 21:40:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77551454 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 21:40:06 [INFO]: updateIdsQuantity -> ["77551454"] 2025-08-01 21:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 21:40:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77551454 THEN 0 END, quantityflag = CASE WHEN id = 77551454 THEN 0 END WHERE user_id = 14409 AND id IN (77551454) 2025-08-01 21:40:06 [INFO]: QUANTITY Updated IDs: 77551454 2025-08-01 21:40:06 [INFO]: Successfully processed data for user 14409 2025-08-01 21:40:06 [INFO]: Execution Started 2025-08-01 21:40:06 [INFO]: Execution Finished 2025-08-01 21:50:01 [INFO]: Execution Started 2025-08-01 21:50:01 [INFO]: old server sucessfully connected 2025-08-01 21:50:02 [INFO]: sqs client sucess created 2025-08-01 21:50:03 [INFO]: Number of messages in the queue: 2 2025-08-01 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 21:50:03 [INFO]: item found in queue is 14409 2025-08-01 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB2VOuvfEtU2x5s1mgoxYmDgFyvl2J2eylFJX2CFmUZKtGbsaOsJ229aEGqV1jeEiGE5KyvmW8E0DYvqHF0p+0KsEDq8EhlZVtWuXd7/3vE8ftUwDnVnXBHnXxPKANJKgEurKN7XFgr9MwfPD0B7R/RbNBgn+Jyy6OOWyQRzjusVRtOt+hOm7OWGMlBOrygWugZtKAYTyo9aLiVMY7AOQiP6M/NLD9jAOTht/ZdjVqeO7YIRSUIDtHHdivZcHyJOnvcEebRCAMx+lPpMLmhJgTogwNEZhqcrD6gwZaGNm1RRfuDSIZ/s8FUIzgNf0rVtVYm7EPugIOB7MxbJ5ZipzOZ09L+r9YVNg0URhvXalzq36MiE0WQML7Rur/Cy5HgyPfHOBVl26Vk+BWsWk9QcoZqNA8RrmPneN4S01WFlFxv+FLp736fLm9iECRMIexBa1A 2025-08-01 21:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 21:50:03 [INFO]: item found in queue is 14409 2025-08-01 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBzHwKfga6H/iYSeJ6zsE8Afy5isWfBv9W6q41Zx9W0wPv9kyFO5cCDaMBqfQ4RhXMSdXjb2aMDyP3qY87exDsVLElUmzZBwGroiSJkbcSmdXel3fbW0R4QfgmwoG/vSmNO2mEtKzCAKJYYkPIjOmD4XvF9+18G9YifvpOFhdaEdhWAUfOh5aBkl4a36bvEIW/hJ4KnDmENSOZy11yxrs348Odrl+QsPq0eP69mFMOfLsa7BphvLdZw4+RiK3h+y5dnAc3FOteHG26no9aRbtA9bThsYgQ5w9bElVpYd+Kixwmd/6Vx8X6kQT2pC6HXXhUaRUgnhiMqdcO5NzzRD1Po+SanjKa/8yKmTEr68uEAkPagXnRe3DTg92h3xaWBNadacPsfnkkRiF/xwje+UY8GdDWAdE3NZFbeq3fQKcGQxPaQdYVOooP6+RJwyeqUKIB 2025-08-01 21:50:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 21:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 21:50:04 [INFO]: inside itemsold and closed 14409 2025-08-01 21:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:50:05 [INFO]: Ebay item id :: 336102689266 exists in Database 2025-08-01 21:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:50:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 21:50:05 [INFO]: inside itemsold and closed 14409 2025-08-01 21:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 21:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 21:50:07 [INFO]: Ebay item id :: 226770455520 exists in Database 2025-08-01 21:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 21:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 21:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 21:50:07 [INFO]: in processold action queue is array for {"45313059":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45313059","ebayitemid":"336102689266","deleted":1}},"44858421":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44858421","ebayitemid":"226770455520","shopifyproductid":"8927182356702","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8927182356702","shopifyvariantid":"46846584226014","shopifyinventoryid":"48958028873950","shopifylocationid":"58450641063","product_id":"44858421","variant_id":"77769522","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 21:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 21:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 21:50:07 [INFO]: productIds WHich are having null productid -> [45313059] 2025-08-01 21:50:07 [INFO]: ebayItemIds WHich are not imported-> ["336102689266"] 2025-08-01 21:50:07 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 21:50:07 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 21:50:07 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45313059) 2025-08-01 21:50:07 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 21:50:07 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 21:50:07 [INFO]: Transaction committed successfully. 2025-08-01 21:50:07 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 21:50:07 [INFO]: Shopify Inventory id 48958028873950 2025-08-01 21:50:07 [INFO]: Shopify Location id 58450641063 2025-08-01 21:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 21:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T21:50: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-01 21:50:07 [INFO]: Change: available | Delta: -1 2025-08-01 21:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-01 21:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 21:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44858421 and user_id = 14409 2025-08-01 21:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77769522 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 21:50:07 [INFO]: updateIdsQuantity -> ["77769522"] 2025-08-01 21:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 21:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77769522 THEN 0 END, quantityflag = CASE WHEN id = 77769522 THEN 0 END WHERE user_id = 14409 AND id IN (77769522) 2025-08-01 21:50:07 [INFO]: QUANTITY Updated IDs: 77769522 2025-08-01 21:50:07 [INFO]: Successfully processed data for user 14409 2025-08-01 21:50:07 [INFO]: Execution Started 2025-08-01 21:50:07 [INFO]: Execution Finished