2025-08-01 17:00:02 [INFO]: Execution Started 2025-08-01 17:00:02 [INFO]: old server sucessfully connected 2025-08-01 17:00:02 [INFO]: sqs client sucess created 2025-08-01 17:00:03 [INFO]: Number of messages in the queue: 3 2025-08-01 17:00:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:00:03 [INFO]: item found in queue is 14409 2025-08-01 17:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSlcP30/KFp1kTSPzvQhL0UWL1eZKNuMYJCgOd15TC3okgucxoHwkYbnA87sJBuCTb8f1EbDX2lEQTrmEgVfSQ2COr80TJNdkka8rAYPYD4Bd/tOlQA5WfuFghk0dKxQoTOK9Z+izX4MX6b6i9m7Trp0Tm3gLnvDrK9fxiaqiwtIjqEK1rSkqhmXebss3fxstY4cUfFKKsPGHZ7zhtxouVYzrelb7IGwKsCqGo8VlNkNcAFmkEn9P1ajjlRXDtur+9ZdYIHKhLd9oT+Bj55MKBrA72nB7RlnckaqiqJ8kumWUlpGvAanif/tgAfleB/80Emeqh1OkZQ+LERckFBfVkHRhdnOxCJs2V0dyXAhD0R/yOYEAA4rlt+IYC6vROIf7hRg51Q0OSlUGkj8ILEhcMGcRwqFTR872OE2K5F4LohaRrUN3Mg/ZDjZsK0rae7I2 2025-08-01 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-01 17:00:04 [INFO]: item found in queue is 14409 2025-08-01 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBXINRVJE2fur5jTGEEnA+5bJtghlIojjQ48MgGVhts9LQCIStKLQla/1ybiJZjabGwwWVvHBPcZuXGNUQHQ8ENimHu8ZVczKVXZy268kLVcLOJvlga1hNxkCuVQbnJckHRVcxAOxtpc4tGPjzjTZF7/8LMqMGE7wkJg1QWdLuxSemB/A/5jdkGjwK8GnpsFajzz8XPaKhDQHL8sQ/2caGwUGTrKeYg7j9DRpmUv6jxfnCIOIBVYo265HtxU/J+GfrZBv45nf/tb1L1oNuF7eJ9r1hDSziLG3nlcKO8xgqZYa0UsCWILKhnxnJZcaM4JheDAh8tm2zgGdxEF4IUvJt7wV5pnPTzi3Rzsfk8TpglOCelaKUo7jT7SL87FrM4Tllui1sOMnlwiLptN8q7GNeCnHt57T6kQLngmb+YZtMtq4ADD/Y477dEImAuNVVByS4 2025-08-01 17:00:04 [INFO]: item found in queue is if condition 14409 2025-08-01 17:00:04 [INFO]: item found in queue is 14409 2025-08-01 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBY2TnFfXhvSlSo+GiXi9eohE1HyAW5ciUQaL+1CA5Gny1p/I+vOZjGWpIj/DOEsvIBwYS6ocuywI3PRP/xCAe3OXS/cxSYCV/2x7uAVdTo8XGit9zuGxf3N1WLQH5QuNo3XHNlkW+9vPt3+SGtkh6rj4h1xr5L6lNhy6JHiMk25ly5YhpomtpYdFNVQvb3Ai65K2FCVLXrYtcSOFCc8iMpaPekfIGGSx7HIb+s5/67WlcJ1Q/qvL6yVqBwD+Z2DFvvli+t846OjIgP7Jd1jR2fcFYUKzmnZk4PfiNtvGEmV0GbrygoaHp6gwt5Dne5TvyT5QS9wV4XybQ26MGZLsNGu2Swy0HLMRr6DU3y/avOeHsz2sH1Txax+I1wZgKhMVq/49lPzLzY8TQfYbzedOO316mMcDIXJG3Bj6haSbqP3dB29lD5GnIFbVn1zd22pqR 2025-08-01 17:00:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-01 17:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 17:00:04 [INFO]: inside itemsold and closed 14409 2025-08-01 17:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:00:07 [INFO]: Ebay item id :: 257020957685 exists in Database 2025-08-01 17:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:00:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 17:00:07 [INFO]: inside itemsold and closed 14409 2025-08-01 17:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:00:09 [INFO]: Ebay item id :: 226847186891 exists in Database 2025-08-01 17:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:00:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 17:00:09 [INFO]: inside itemsold and closed 14409 2025-08-01 17:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:00:11 [INFO]: Ebay item id :: 286714274052 exists in Database 2025-08-01 17:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:00:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 17:00:11 [INFO]: in processold action queue is array for {"45241398":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45241398","ebayitemid":"257020957685","deleted":1}},"45190745":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45190745","ebayitemid":"226847186891","deleted":1}},"45256451":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45256451","ebayitemid":"286714274052","deleted":1}}} 2025-08-01 17:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 17:00:11 [INFO]: productIds WHich are having null productid -> [45241398,45190745,45256451] 2025-08-01 17:00:11 [INFO]: ebayItemIds WHich are not imported-> ["257020957685","226847186891","286714274052"] 2025-08-01 17:00:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 17:00:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 17:00:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45241398,45190745,45256451) 2025-08-01 17:00:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 17:00:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 17:00:11 [INFO]: Transaction committed successfully. 2025-08-01 17:00:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 17:00:11 [INFO]: Successfully processed data for user 14409 2025-08-01 17:00:11 [INFO]: Execution Started 2025-08-01 17:00:11 [INFO]: Execution Finished 2025-08-01 17:10:01 [INFO]: Execution Started 2025-08-01 17:10:01 [INFO]: old server sucessfully connected 2025-08-01 17:10:01 [INFO]: sqs client sucess created 2025-08-01 17:10:02 [INFO]: Number of messages in the queue: 2 2025-08-01 17:10:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:10:03 [INFO]: item found in queue is 14409 2025-08-01 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrRSyxsAzskWdMZLnEg6dGie3nx9cqQfIEG17x8Y9efWBT0Sf3ao+Ini4BX6kxTcA9mRsNhwXOaDh6vBBKpYMlEnPKKKtbCcg/rH0uOZaXEzbYXCdRDSmmjNr2XUK+E9ciZc8Z6vWcijcnGvrnI5uKUYiYdo79nJ4C0qtXmNpG4BUOOQeYtTzMDEoxMOlBjiy/egviY/RgOz0ubEkrT85MbVynrWturmOUMSH6GtkIfMHxJtmWFKEyL/sH9am+1fiSHQ07zxmTtggvL6mXgIiyz4f9ZVcrfVRbJl4XARi2JYb3j1f900C9mM6nICWi8NdC616U7f50h6ubuFRlyMPky6pbioHSEaEaaDV3gdOlo4jHA9TsD+YHsF3jPFrLNSCfNhvLrMla+HqL3dSr6aKWuZWX4DIpSG3xPw6UmuYHQmlby84YN0IARBdh6XKdGu/ 2025-08-01 17:10:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:10:03 [INFO]: item found in queue is 14409 2025-08-01 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBffNYreq8cpO83azxY8DVtj+AtgONnSefAwW7zx6WJQxfho/MTkeRk2/KB089FdcnyzSeCuEbNVBtbzyuX222ATA271Q0lISz93buXGbs67O0SXgnKK15GS8yXU30/2LDtPoOwcCOBEQbnpCzYBB1wgsz2sIWQqUGPvvpHPAjwqznNabt7Rw37JWLtOep4wYruGABUYvUfcnHwYHAsHNODOi58hYep3CPjov8ihWStA0IDh5GRCGCvfQ4a2Xq/+5Wa/fagTzwD0SYGpB2CKunKcRWV1PnrGS+kgbztPc1eDQNaGLKeokTpJfHjLBR3L5K1QHv0sJS/gMtk+QmvDYEDYi14aEHCivPQ3SaVOFxx3SUPvVCHuDMqIXWjNcmiol8xbHKRP3EzTZSB+H1UydvqgcYxzZmd29Dxm3JnrNE1lEWCSmcud2p/0w0t2q91aAv 2025-08-01 17:10:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-01 17:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 17:10:04 [INFO]: inside itemsold and closed 14409 2025-08-01 17:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:10:05 [INFO]: Ebay item id :: 256906659065 exists in Database 2025-08-01 17:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:10:05 [INFO]: inside itemsold and closed 14409 2025-08-01 17:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:10:07 [INFO]: Ebay item id :: 226223243101 exists in Database 2025-08-01 17:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:10:07 [INFO]: in processold action queue is array for {"44679983":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44679983","ebayitemid":"256906659065","shopifyproductid":"8215255384286","variants":[{"price":"62.99","quantity":0,"weight":"2","shopifyproductid":"8215255384286","shopifyvariantid":"44550150095070","shopifyinventoryid":"46648103141598","shopifylocationid":"","product_id":"44679983","variant_id":"77585203","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44711648":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44711648","ebayitemid":"226223243101","shopifyproductid":"8705152549086","variants":[{"price":"9.99","quantity":0,"weight":"1","shopifyproductid":"8705152549086","shopifyvariantid":"45959085818078","shopifyinventoryid":"48057718407390","shopifylocationid":"","product_id":"44711648","variant_id":"77619261","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 17:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 17:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:10:07 [INFO]: Shopify Inventory id 46648103141598 2025-08-01 17:10:07 [INFO]: Shopify Location id 58450641063 2025-08-01 17:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T17:10: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 17:10:08 [INFO]: Change: available | Delta: -1 2025-08-01 17:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-01 17:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44679983 and user_id = 14409 2025-08-01 17:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77585203 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:10:08 [INFO]: Shopify Inventory id 48057718407390 2025-08-01 17:10:08 [INFO]: Shopify Location id 58450641063 2025-08-01 17:10:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T17:10:08Z","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 17:10:08 [INFO]: Change: available | Delta: -1 2025-08-01 17:10:08 [INFO]: Change: on_hand | Delta: -1 2025-08-01 17:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44711648 and user_id = 14409 2025-08-01 17:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77619261 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:10:08 [INFO]: updateIdsQuantity -> ["77585203","77619261"] 2025-08-01 17:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-01 17:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77585203 THEN 0 WHEN id = 77619261 THEN 0 END, quantityflag = CASE WHEN id = 77585203 THEN 0 WHEN id = 77619261 THEN 0 END WHERE user_id = 14409 AND id IN (77585203,77619261) 2025-08-01 17:10:08 [INFO]: QUANTITY Updated IDs: 77585203, 77619261 2025-08-01 17:10:08 [INFO]: Successfully processed data for user 14409 2025-08-01 17:10:08 [INFO]: Execution Started 2025-08-01 17:10:08 [INFO]: Execution Finished 2025-08-01 17:20:01 [INFO]: Execution Started 2025-08-01 17:20:01 [INFO]: old server sucessfully connected 2025-08-01 17:20:01 [INFO]: sqs client sucess created 2025-08-01 17:20:03 [INFO]: Number of messages in the queue: 1 2025-08-01 17:20:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:20:03 [INFO]: item found in queue is 14409 2025-08-01 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBbmQzYOKTcMSYeMVQ4qy/V65Rqmz5xYiQCfpfBCzOTeUfeccaKPJ2IWPYyDTyHUoDCDw4T2O3b5uLVkSZWCzVmcDf+T4MStPEGojRLSYXr1uzxC7vdG6EWSmL58XZDrs5SYX/w9jQRK9/7SGO/W/NbwNxtixTpriTIk8aKrydl6voP8xqNMo/JkR62xvjz6yXPWo+PlKy71L97bNVVZ/S8ylfODH49fWbiJDUVNSA5OjOwMS4hgO74XbLNfHimB31sprw2WIw+D8gUqfDS5ASSWrpsMTL5ArYhj8CmRNHHWaKhyGS8J1zUc21+1M7WcBYYTV7eyt7Jb1C6HJSxUqZ//ud8U4toqA6IowUToKHzV6TjSFLQn+B4JvKUP5bCoTMenkpRzxwmr4VVmxtymUQuMBDUjGWXcoMzK7Q//o7M+GD0MgqgdyHlH/Rg+oZG6GY 2025-08-01 17:20:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 17:20:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 17:20:03 [INFO]: inside itemsold and closed 14409 2025-08-01 17:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:20:05 [INFO]: Ebay item id :: 226444370602 exists in Database 2025-08-01 17:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:20:05 [INFO]: in processold action queue is array for {"44736118":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44736118","ebayitemid":"226444370602","shopifyproductid":"7711427166430","variants":[{"price":"12.99","quantity":0,"weight":"0.75","shopifyproductid":"7711427166430","shopifyvariantid":"43045905563870","shopifyinventoryid":"45141154463966","shopifylocationid":"","product_id":"44736118","variant_id":"77644055","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 17:20:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 17:20:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:20:05 [INFO]: Shopify Inventory id 45141154463966 2025-08-01 17:20:05 [INFO]: Shopify Location id 58450641063 2025-08-01 17:20:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:20:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T17:20: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-01 17:20:05 [INFO]: Change: available | Delta: -1 2025-08-01 17:20:05 [INFO]: Change: on_hand | Delta: -1 2025-08-01 17:20:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:20:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44736118 and user_id = 14409 2025-08-01 17:20:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77644055 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:20:05 [INFO]: updateIdsQuantity -> ["77644055"] 2025-08-01 17:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-01 17:20:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77644055 THEN 0 END, quantityflag = CASE WHEN id = 77644055 THEN 0 END WHERE user_id = 14409 AND id IN (77644055) 2025-08-01 17:20:05 [INFO]: QUANTITY Updated IDs: 77644055 2025-08-01 17:20:05 [INFO]: Successfully processed data for user 14409 2025-08-01 17:20:05 [INFO]: Execution Started 2025-08-01 17:20:05 [INFO]: Execution Finished 2025-08-01 17:30:01 [INFO]: Execution Started 2025-08-01 17:30:01 [INFO]: old server sucessfully connected 2025-08-01 17:30:01 [INFO]: sqs client sucess created 2025-08-01 17:30:03 [INFO]: Number of messages in the queue: 1 2025-08-01 17:30:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:30:03 [INFO]: item found in queue is 14409 2025-08-01 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKlekDCXIjcc0JU2orUd10v0mZUFpf800k+R8xvgry26S+IrAhqA5QnPMF9EBYTV7xvK+DAP6+wqkvo/yhESZZcvibrk6tLWhK0Yl2e9Nw57qiQY48vZEhmr4Xm6QzYNJvhCQy2BOZautJlbEcTJsI0Akv4bt5yU8R/8ejTWUSVpVNQ/5m+1AykZMNlFl9ER6e+4qnEM8g2CzoZ8LqcQ62LNPLgSiqaR83xOkQBWAg29lrbACpWiMEXnXgY8CB0bm626xR+kv2OX9TozE5LhMnwCavRqLNGRKPkbBkht+ouGfZBhchM0N4cBmC7PPNVpgRTv0ZJvh3NW2YkyocPq2BB8qKiSobZ/QfoigFCdGXnyYMm4g07UCe7Bay3Y5kz9mneA0+SnxblcjN2XpqlLPPMu8PxgAvfSqkNN8qbpJaqvsqCyuw2zuz/hOgaZU1Xtv 2025-08-01 17:30:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-01 17:30:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 17:30:03 [INFO]: inside itemsold and closed 14409 2025-08-01 17:30:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:30:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:30:05 [INFO]: Ebay item id :: 286638149817 exists in Database 2025-08-01 17:30:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:30:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-01 17:30:05 [INFO]: in processold action queue is array for {"45109911":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45109911","ebayitemid":"286638149817","deleted":1}}} 2025-08-01 17:30:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 17:30:05 [INFO]: productIds WHich are having null productid -> [45109911] 2025-08-01 17:30:05 [INFO]: ebayItemIds WHich are not imported-> ["286638149817"] 2025-08-01 17:30:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-01 17:30:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-01 17:30:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45109911) 2025-08-01 17:30:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-01 17:30:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-01 17:30:05 [INFO]: Transaction committed successfully. 2025-08-01 17:30:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-01 17:30:05 [INFO]: Successfully processed data for user 14409 2025-08-01 17:30:05 [INFO]: Execution Started 2025-08-01 17:30:05 [INFO]: Execution Finished 2025-08-01 17:40:01 [INFO]: Execution Started 2025-08-01 17:40:01 [INFO]: old server sucessfully connected 2025-08-01 17:40:01 [INFO]: sqs client sucess created 2025-08-01 17:40:02 [INFO]: Number of messages in the queue: 0 2025-08-01 17:40:22 [INFO]: Execution Started 2025-08-01 17:40:22 [INFO]: Execution Finished 2025-08-01 17:50:01 [INFO]: Execution Started 2025-08-01 17:50:01 [INFO]: old server sucessfully connected 2025-08-01 17:50:01 [INFO]: sqs client sucess created 2025-08-01 17:50:02 [INFO]: Number of messages in the queue: 3 2025-08-01 17:50:02 [INFO]: item found in queue is if condition 14409 2025-08-01 17:50:02 [INFO]: item found in queue is 14409 2025-08-01 17:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEBArHGa9F1b2Q7yXDB/eMR6k0noI9HfRmoBlsH480xpzrt28D0gEL8o/JygRC/N9O0IrVRSRHqO5eIsiFcdQq7ATMZ+Luq4/vbgmCnqznIrxaLfPF4pQ0veHlH2Jzy+U1dMVBKLiUZ64ax/FAEc9H6lAQVCVj7Cvhjmd12/6sa1SPxtWbluavnw7nyVEZsSvUHEMYHrSlFRcc+VVjfnZyJkTM8Nc/I8bxuDz5FB4f+FeUNyviMLBhLh7Qjl6uVwxuUoIXczIMg0F91SOni9AS+PME29k9uPTYLf2HPfOn9QTXDCJizWT6GcncLx4mVHpeJxnDHHmAWm0+JfCAxR6SV19LrqChhs6VLIN53H18ZHixR8odwCTch4HNbdKSkU0ukIJk1tBB7Nsng5GWpsgBTBt8B+4X/ZqxQFg3Mnf+2mG81ZkPNn8f7lgUXUaRFo3BE 2025-08-01 17:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:50:03 [INFO]: item found in queue is 14409 2025-08-01 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBIS1yQIKYbG/wBxmjbPbquSRLanD9E1QoH0H6Ayq3NDqnKOwleGnJdrAN3aFrLgdv5Nzbb9REqZOsaIFe5W0gMJn/1wiXSRQAfAC08lleTkddINHmABZD2x3ZvEdQVVcGSUstXmLxuZJAgcoo7QfiEPXGzykDP078J4v7YI/g315YlXKaKwSuPsGMysLJ9mPQPoqFp2DBGugNCF3+vV59olQhSx9al1bu6GnCHx28q6aJpeHbtZWq3ErvIre84mlXjzsdkMIyF4a3Hjp9kw3fPfPkgXAAnUEa2tTnDCyy8zUTgbKDUhc5Dahx879bdoPMyQrxPqVdljRZ3iWlEK2+ZAYZQ/ewWWNM00OucpaMmXJOZKmSk4B6WI4DncXUjwMqU3r8IeR/zbwkiNPlcbEXqmRZDm0oFFdL4b4Z/ze9AKsrHtCGwV84oX5kbBGvXUYT 2025-08-01 17:50:03 [INFO]: item found in queue is if condition 14409 2025-08-01 17:50:03 [INFO]: item found in queue is 14409 2025-08-01 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB3xmCNOA5zWuyPc+uTndMt+8QSUPDAjFes7Q/JSaVUka1YaGPutTzpfjVlyU/WjkiRwhiuRUbajrNLiZGfNgZADwQ7Yim9uwYiVVQG9tph5L4EYhvivmYYhX6hGV4uhaOZfyGUrAPKrB4FluhhLLniMCphn1iUhRBVN/S2i1kxYvy3rpTeUGMrrkRZUMaKyz56vSnsQ5VbyIMMAaDbWu4m/apolpD1WQS+HN3eFgEiT6fOOQ7xPAfRJxyVpEekmPSwxFOUuRhv40ztH17wu+1YqxRTYas7BbxDuZd6fTJvAvuNtZ/XsClhoBJL/hOcJKCWCxoY3rJGslUUMgAWL7CI0jhHF9x3/aMW8X7dmnHviBIy5kQJa4U4fTSKPLAitdGaFNjk+Yzr18zD44EKoM3RYD6DaDXSEGZFzYlNrGc0uYZ6gxMSsFI+BouNmNl5UKA 2025-08-01 17:50:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-01 17:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-01 17:50:03 [INFO]: inside itemsold and closed 14409 2025-08-01 17:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:50:05 [INFO]: Ebay item id :: 226403830577 exists in Database 2025-08-01 17:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:50:05 [INFO]: inside itemsold and closed 14409 2025-08-01 17:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:50:07 [INFO]: Ebay item id :: 306115184494 exists in Database 2025-08-01 17:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:50:07 [INFO]: inside itemsold and closed 14409 2025-08-01 17:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-01 17:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-01 17:50:08 [INFO]: Ebay item id :: 326306149814 exists in Database 2025-08-01 17:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-01 17:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-01 17:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-01 17:50:08 [INFO]: in processold action queue is array for {"44652318":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44652318","ebayitemid":"226403830577","shopifyproductid":"8048775954654","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"8048775954654","shopifyvariantid":"44203200151774","shopifyinventoryid":"46300276850910","shopifylocationid":"","product_id":"44652318","variant_id":"77557507","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573042":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573042","ebayitemid":"306115184494","shopifyproductid":"8817212293342","variants":[{"price":"305.10","quantity":0,"weight":"2","shopifyproductid":"8817212293342","shopifyvariantid":"46289350820062","shopifyinventoryid":"48390274482398","shopifylocationid":"","product_id":"44573042","variant_id":"77465726","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44652314":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44652314","ebayitemid":"326306149814","shopifyproductid":"7068977201319","variants":[{"price":"34.99","quantity":0,"weight":"3","shopifyproductid":"7068977201319","shopifyvariantid":"41436364177575","shopifyinventoryid":"43532781125799","shopifylocationid":"","product_id":"44652314","variant_id":"77557503","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-01 17:50:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-01 17:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:50:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-01 17:50:08 [INFO]: Shopify Inventory id 46300276850910 2025-08-01 17:50:08 [INFO]: Shopify Location id 58450641063 2025-08-01 17:50:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T17:50:08Z","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 17:50:09 [INFO]: Change: available | Delta: -1 2025-08-01 17:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-01 17:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44652318 and user_id = 14409 2025-08-01 17:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77557507 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:50:09 [INFO]: Shopify Inventory id 48390274482398 2025-08-01 17:50:09 [INFO]: Shopify Location id 58450641063 2025-08-01 17:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:50:09 [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-01 17:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573042 and user_id = 14409 2025-08-01 17:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77465726 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:50:09 [INFO]: Shopify Inventory id 43532781125799 2025-08-01 17:50:09 [INFO]: Shopify Location id 58450641063 2025-08-01 17:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-01 17:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-01T17:50:09Z","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 17:50:09 [INFO]: Change: available | Delta: -1 2025-08-01 17:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-01 17:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-01 17:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44652314 and user_id = 14409 2025-08-01 17:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77557503 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-01 17:50:09 [INFO]: updateIdsQuantity -> ["77557507","77465726","77557503"] 2025-08-01 17:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-01 17:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77557507 THEN 0 WHEN id = 77465726 THEN 0 WHEN id = 77557503 THEN 0 END, quantityflag = CASE WHEN id = 77557507 THEN 0 WHEN id = 77465726 THEN 0 WHEN id = 77557503 THEN 0 END WHERE user_id = 14409 AND id IN (77557507,77465726,77557503) 2025-08-01 17:50:09 [INFO]: QUANTITY Updated IDs: 77557507, 77465726, 77557503 2025-08-01 17:50:09 [INFO]: Successfully processed data for user 14409 2025-08-01 17:50:09 [INFO]: Execution Started 2025-08-01 17:50:09 [INFO]: Execution Finished