2025-08-06 18:00:01 [INFO]: Execution Started 2025-08-06 18:00:01 [INFO]: old server sucessfully connected 2025-08-06 18:00:01 [INFO]: sqs client sucess created 2025-08-06 18:00:02 [INFO]: Number of messages in the queue: 0 2025-08-06 18:00:22 [INFO]: Execution Started 2025-08-06 18:00:22 [INFO]: Execution Finished 2025-08-06 18:10:01 [INFO]: Execution Started 2025-08-06 18:10:01 [INFO]: old server sucessfully connected 2025-08-06 18:10:01 [INFO]: sqs client sucess created 2025-08-06 18:10:03 [INFO]: Number of messages in the queue: 0 2025-08-06 18:10:23 [INFO]: Execution Started 2025-08-06 18:10:23 [INFO]: Execution Finished 2025-08-06 18:20:01 [INFO]: Execution Started 2025-08-06 18:20:01 [INFO]: old server sucessfully connected 2025-08-06 18:20:02 [INFO]: sqs client sucess created 2025-08-06 18:20:03 [INFO]: Number of messages in the queue: 2 2025-08-06 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:20:03 [INFO]: item found in queue is 14409 2025-08-06 18:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSGgL2jEMOsYTl6VWUwwk+eAO9h2rqKIahhlcRg1HsSu1sVx0FJy8TeyhUcyTnW0RbBRvvYh7RbiWwsZ4dE8zT2zuz7hfYzx+fckBaewo8D/0I6Hf1jHFFhqj4pMb1PmtfNEcdyUNE1p35LmEozewL/7FI+gg+Ht8DhVWsiundSadmtZ8H6XpjNWcmkUVQ/QHLOW9ajZ0GiASLHgIlOZAhiKqdfW2WB7sEWTEEkY9HI2UHt2lrLSonX500W15XyMhi7mOki/WRQ0O9Pl8DVxEZ7mK2s2IXCoHIj6MHGcSYyw1Xb6r/pw8YCFmcf4rsimbJ+BRjmjQyOsiq8y0/FMTK9OAjZjN+3lxEGVtg+edRo3YEM7X6KDZfwVLHz7M0IZwaWRK0+4NgGp5PDb1Nr26H/5q7ZtA2vXnRSqoLTI79Geid2PcSMPih/O72Ho9jnjm 2025-08-06 18:20:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:20:03 [INFO]: item found in queue is 14409 2025-08-06 18:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBxL6jSO+Z3fvMxpgwoHysjrmERrvU29DxB57Wsbn6T+OX27UDC2x59IPTUZyHz/U9C+VCS4tADpP4QUU3dnerr+Lwo9zQtum9doNg1Hng0PebaFjkrMfe5ovVfp5NahavHRZa6yR6z0X/wjVf9zcWklLSAtqe7yCWk1M+A7URqaxT+Un0v0dq1XPrXN3h6Nt1BXeP/K4UtlA0Jw8Yecw6JK1RoSkNDIRpKZ2APoZshQ/8OU9YraIkMuAoeT50+isLzbw7Ru/VJOnV0P6wbUuq6o8Kx65UzvZYE48nU6mqyyboYhtH6cRypewPtAB484orO6/rIa8ai58WMFYMTCwxys39cZJImdPze1kfjzgUW9VDDBu9Hbr2bJ8yapchGdMI1ARkkKNFqZZY3pQQ2LU3tv2O3JF0D/E4o8vF9NjGKdYg63hbTOnbu0dXf3JituBf 2025-08-06 18:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-06 18:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 18:20:04 [INFO]: inside itemsold and closed 14409 2025-08-06 18:20:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:20:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:20:05 [INFO]: Ebay item id :: 335377291166 exists in Database 2025-08-06 18:20:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:20:05 [INFO]: inside itemsold and closed 14409 2025-08-06 18:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:20:07 [INFO]: Ebay item id :: 285909318480 exists in Database 2025-08-06 18:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:20:07 [INFO]: in processold action queue is array for {"44556078":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556078","ebayitemid":"335377291166","shopifyproductid":"8466615763166","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8466615763166","shopifyvariantid":"45315385655518","shopifyinventoryid":"47413316419806","shopifylocationid":"","product_id":"44556078","variant_id":"77448758","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44641412":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44641412","ebayitemid":"285909318480","shopifyproductid":"8699714863326","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8699714863326","shopifyvariantid":"45944577753310","shopifyinventoryid":"48043112235230","shopifylocationid":"","product_id":"44641412","variant_id":"77546601","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 18:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:20:07 [INFO]: Shopify Inventory id 47413316419806 2025-08-06 18:20:07 [INFO]: Shopify Location id 58450641063 2025-08-06 18:20:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18:20: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-06 18:20:07 [INFO]: Change: available | Delta: -1 2025-08-06 18:20:07 [INFO]: Change: on_hand | Delta: -1 2025-08-06 18:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556078 and user_id = 14409 2025-08-06 18:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448758 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:20:08 [INFO]: Shopify Inventory id 48043112235230 2025-08-06 18:20:08 [INFO]: Shopify Location id 58450641063 2025-08-06 18:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18:20: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-06 18:20:08 [INFO]: Change: available | Delta: -1 2025-08-06 18:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-06 18:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44641412 and user_id = 14409 2025-08-06 18:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77546601 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:20:08 [INFO]: updateIdsQuantity -> ["77448758","77546601"] 2025-08-06 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-06 18:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448758 THEN 0 WHEN id = 77546601 THEN 0 END, quantityflag = CASE WHEN id = 77448758 THEN 0 WHEN id = 77546601 THEN 0 END WHERE user_id = 14409 AND id IN (77448758,77546601) 2025-08-06 18:20:08 [INFO]: QUANTITY Updated IDs: 77448758, 77546601 2025-08-06 18:20:08 [INFO]: Successfully processed data for user 14409 2025-08-06 18:20:08 [INFO]: Execution Started 2025-08-06 18:20:08 [INFO]: Execution Finished 2025-08-06 18:30:01 [INFO]: Execution Started 2025-08-06 18:30:01 [INFO]: old server sucessfully connected 2025-08-06 18:30:02 [INFO]: sqs client sucess created 2025-08-06 18:30:03 [INFO]: Number of messages in the queue: 3 2025-08-06 18:30:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:30:03 [INFO]: item found in queue is 14409 2025-08-06 18:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxIBp8RQXo0+jUIRCnCZZhIt/BNIaCP9APYKDjLWDFLqNqTWTBMiS9M6tCOHSlXTvUI91qT8ZsNOU766srL/Z03EPHM4Ik+od9GRaRy9fjEpJ+qsKLb0lO5DqgOFlipoSzoVME2EB5UCD3uJu76sGr+IVPI5dQg9RUWsyR01Qef7Hw+JpeKPH6JgMh8RHKD8g7DTfbxn7nyPoV00Z3mWkjxgW/G5grD8AX670DOyTGe+Vk+xqgW4wxWdD/T9a3aBC+ihfFejUD7Vt0Yu5EM+eCX3px3V6cUz0LVgvzf4MWcLifIIj37Eijbq5zuaNnaQxfap4On4/0Zin5hBcR4g0yLCQIMIs61X+ag2pWsHsCTO/8kpWFPn7f+slES9C8dgbqubCl1Gr6uKpEuDH3SbmXlPLtNyVNobLA025S2Q0waNkxFFbsRl4cjf5pijDYd3q 2025-08-06 18:30:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:30:03 [INFO]: item found in queue is 14409 2025-08-06 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBBV/20+Syb++JzVghxuZUxpUL9LhvbPHrUdcDhSbh9J428aL0HzfXNk84Ilc5jB4haGLBQxF+g2kezdecx0nkF6110GRRgYY180G/EPTliqwH6Q4cFQiRaMOeT91I0MC4PRrYTB5g2DibWU0Fl3pkUY6jjqCW8C5gIRLbDlAL+DvxaIoJPCVG0DpeXpy5RZjlfM2YAjyfRdNdGubMo9GIzlfYtbCP2J1N7xXDJ71sxbWsOQr+dxBQ0ciVNzFvhLqcBK53rteV9JeE4qbUXovSCZvkis722qUEpx4kz20ssd4tzQhdxhvaBP4oyuiDKLBIKGp9eN3rIfnrBj07ldBn5Ia0HnSUPIwZv/PrlW4LoczxdshZiQ/VGlXbZoqNMHKT4cjmleNK5vin7tHYhMHu1yMCgQlEj8Rv1WYmoogVte3CSXFym93TQy5uDoNEuEMW 2025-08-06 18:30:04 [INFO]: item found in queue is if condition 14409 2025-08-06 18:30:04 [INFO]: item found in queue is 14409 2025-08-06 18:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBX/Bx74vm/9t1SoAGzp2SDYplq1ao5ouAvFWrnzpKenJTusxlanucdGIyAfK6+2wIUI7ln1jr8mYUQZfyKMWBIFnLNInJg0Ka4cnA8QZaUtsxfcvdvRw4FXO7Hd1sSHRUn6vCd3GCefDZFjex1xee9+7iv6G4I/OZtxWCKX07BjDHlfTk87N0BaawCHgoWiWA5l+1mEJRByeTjff8MyCAvlNHXwpJr9GRSFVUKmq8XVSgzyX9eXNok+ZJSWgBVQt5dlk7Yfc6TxCdBX04sj/RJx41c5Cgh116sj18VcVc7OyR4TXM/NE2sbnJza2eSyIRKwoNksbtN8udEmKdmskQIT5zbG+ZqloeCpy9HLrpB6Fdxq6ZjcraNOCbkxJiDfbgWjb6LkfAIkVBGOUZZX7bWnyOhZoMoCvO5EjyK3MSm5KokAHJn5eQF0knpDJCHIhd 2025-08-06 18:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-06 18:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 18:30:04 [INFO]: inside itemsold and closed 14409 2025-08-06 18:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:30:06 [INFO]: Ebay item id :: 285810468425 exists in Database 2025-08-06 18:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:30:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 18:30:06 [INFO]: inside itemsold and closed 14409 2025-08-06 18:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:30:08 [INFO]: Ebay item id :: 255187852825 exists in Database 2025-08-06 18:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:30:08 [INFO]: inside itemsold and closed 14409 2025-08-06 18:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:30:09 [INFO]: Ebay item id :: 305488818855 exists in Database 2025-08-06 18:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:30:09 [INFO]: in processold action queue is array for {"45143216":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45143216","ebayitemid":"285810468425","deleted":1}},"44661670":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661670","ebayitemid":"255187852825","shopifyproductid":"7115480924327","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7115480924327","shopifyvariantid":"41591482548391","shopifyinventoryid":"43688105672871","shopifylocationid":"","product_id":"44661670","variant_id":"77566890","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44554444":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44554444","ebayitemid":"305488818855","shopifyproductid":"8362498326750","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8362498326750","shopifyvariantid":"45052159426782","shopifyinventoryid":"47149958398174","shopifylocationid":"","product_id":"44554444","variant_id":"77447124","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 18:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 18:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:30:09 [INFO]: productIds WHich are having null productid -> [45143216] 2025-08-06 18:30:09 [INFO]: ebayItemIds WHich are not imported-> ["285810468425"] 2025-08-06 18:30:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 18:30:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 18:30:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45143216) 2025-08-06 18:30:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 18:30:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 18:30:09 [INFO]: Transaction committed successfully. 2025-08-06 18:30:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 18:30:09 [INFO]: Shopify Inventory id 43688105672871 2025-08-06 18:30:09 [INFO]: Shopify Location id 58450641063 2025-08-06 18:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18: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-06 18:30:10 [INFO]: Change: available | Delta: -1 2025-08-06 18:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-06 18:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661670 and user_id = 14409 2025-08-06 18:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566890 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:30:10 [INFO]: Shopify Inventory id 47149958398174 2025-08-06 18:30:10 [INFO]: Shopify Location id 58450641063 2025-08-06 18:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18: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-06 18:30:10 [INFO]: Change: available | Delta: -1 2025-08-06 18:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-06 18:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44554444 and user_id = 14409 2025-08-06 18:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447124 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:30:10 [INFO]: updateIdsQuantity -> ["77566890","77447124"] 2025-08-06 18:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-06 18:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77566890 THEN 0 WHEN id = 77447124 THEN 0 END, quantityflag = CASE WHEN id = 77566890 THEN 0 WHEN id = 77447124 THEN 0 END WHERE user_id = 14409 AND id IN (77566890,77447124) 2025-08-06 18:30:10 [INFO]: QUANTITY Updated IDs: 77566890, 77447124 2025-08-06 18:30:10 [INFO]: Successfully processed data for user 14409 2025-08-06 18:30:10 [INFO]: Execution Started 2025-08-06 18:30:10 [INFO]: Execution Finished 2025-08-06 18:40:01 [INFO]: Execution Started 2025-08-06 18:40:01 [INFO]: old server sucessfully connected 2025-08-06 18:40:01 [INFO]: sqs client sucess created 2025-08-06 18:40:02 [INFO]: Number of messages in the queue: 3 2025-08-06 18:40:02 [INFO]: item found in queue is if condition 14409 2025-08-06 18:40:02 [INFO]: item found in queue is 14409 2025-08-06 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBMukuMRgN/iKTEyR1N8rSPEFK9ufueOz0ibx6W85niXdmA91QJq8H3EhsFizSD4cII8JNV1sZIU5M5iXuK2bpv6hxC13FKGg8m5LXMDiIKr8i3QhL22OhKZE2mIZ4Cm+6eRnrN5sdPNAXEayhVv/PWJL505PBOZ5JfmvxCxbaa//IZPAjYi6qJFTRFfazuRDhtiO2Kp+R11a11sqOYamp1ZpBbTbrVXik/UGG89HeJxN64CUCcrzCOlbdAhfurJpQwtOnRxplnLZYxDIlJ4CGd5XgMpl7LiutFo0Uzo0hVaZwBSrfxpznkWTL374d5ENSISfLY6pBgFf4UxxKvQCHxJ+t/pDoOzYalceYzuw4cFnEsgbxrGkUBhq7V7PGSlGu8AHbc4+P5xYZGG30iGDom0HLOjWzjPdbRXkmU7nFhkglqVO+CE9dq8qqKsA3Hkrq 2025-08-06 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:40:03 [INFO]: item found in queue is 14409 2025-08-06 18:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBbWyVjE/bjcPVEx+glVImNsfkgRHoue1da/+J42xSxqr70MSCP9gRJg1Ua8wrfCYB1Vm+TcV27n64MrZbv8xsFzpbeTpJ/RfvmBfm+1flq8jvgkVqejlJN1tXW8FRNPImu6HDx+e6Vku6hWTQcdjTOJ6haqN4J8IRkD940+JpDIqUnOtNp53EEewcDv/yiHhvaOU8yZrGku0Sf5LcYBbQ3LJXIFNov85OTQAvI2aS3v2kQ0zwtrpHnAxTrRZI47I1fZkd/u71+qlcsUFqX+IZE9NYrzQ78EJ+bxEI8rZhwsWiXIZUprUpxdg8sbpXbGbzFicNOP1yFbY2Me5ZpxfusKqw0BukqnEyLpAZ77wwyiG7P/hzH6kNfAdzBF6ES7A5Q0GaDqzcex8CdLOX3vsF4AJ8Ep3DzRyvICaousXNnfBSb4VdpuItY1bnLbLdrZFn 2025-08-06 18:40:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:40:03 [INFO]: item found in queue is 14409 2025-08-06 18:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBYFiki7oKfQkQBq47vi3WoWqwxpiXkepr8W25fBecdZLxe10PlE0x619P4BkYn9Ey/3I91tYya4KF2NbTfoPPOUQ0tU+F+XLO/Gtk3mkZEtRAEfLBVH4yibzUDtCwYkhPY0BP5u2cvn0W2wEzzFJnqp81stSlA+9mcRyrQ6sfSQvQfnxHFh8+CgPlzsbhP7IVaq0aumyuCmSrFYPWPzKGESc6JlA7WubD4nNAK1DLlu/zQRyaM+0OgzvtyVRPLy8Xx1eYMvv/BukxAIrEnE5J3I+k46t7bqF9/pA9RRK/Bqs5t0xZ9x4SJcJnduJxCvQz/zt8AaqSu3RBKyIPr5yiyLokfeC65Cjif5cYf2BnN8torz1KvuSZcBnEjGtMsFcc9XaXMjGJE/mVzn3xwFOZrU7LnB6wnm/BFYsxN0EOU3zmeaDM0taJwSm254sbJ7NX 2025-08-06 18:40:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-06 18:40:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 18:40:04 [INFO]: inside itemsold and closed 14409 2025-08-06 18:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:40:05 [INFO]: Ebay item id :: 334991351850 exists in Database 2025-08-06 18:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 18:40:05 [INFO]: inside itemsold and closed 14409 2025-08-06 18:40:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:40:07 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:40:07 [INFO]: Ebay item id :: 326354381227 exists in Database 2025-08-06 18:40:07 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:40:07 [INFO]: inside itemsold and closed 14409 2025-08-06 18:40:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:40:09 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:40:09 [INFO]: Ebay item id :: 334991351850 exists in Database 2025-08-06 18:40:09 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:40:09 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-06 18:40:09 [INFO]: in processold action queue is array for {"45143995":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45143995","ebayitemid":"334991351850","deleted":1}},"44683058":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683058","ebayitemid":"326354381227","shopifyproductid":"8749003636958","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8749003636958","shopifyvariantid":"46112273924318","shopifyinventoryid":"48211249987806","shopifylocationid":"","product_id":"44683058","variant_id":"77588283","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 18:40:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 18:40:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:40:09 [INFO]: productIds WHich are having null productid -> [45143995] 2025-08-06 18:40:09 [INFO]: ebayItemIds WHich are not imported-> ["334991351850"] 2025-08-06 18:40:09 [INFO]: Entered in bulkUpdateProducts function 2025-08-06 18:40:09 [INFO]: Transaction started for bulkUpdateProducts 2025-08-06 18:40:09 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45143995) 2025-08-06 18:40:09 [INFO]: Query executed successfully. Affected rows: 0 2025-08-06 18:40:09 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-06 18:40:09 [INFO]: Transaction committed successfully. 2025-08-06 18:40:09 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-06 18:40:09 [INFO]: Shopify Inventory id 48211249987806 2025-08-06 18:40:09 [INFO]: Shopify Location id 58450641063 2025-08-06 18:40:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:40: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-06 18:40:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:40:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683058 and user_id = 14409 2025-08-06 18:40:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77588283 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:40:09 [INFO]: updateIdsQuantity -> ["77588283"] 2025-08-06 18:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-06 18:40:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77588283 THEN 0 END, quantityflag = CASE WHEN id = 77588283 THEN 0 END WHERE user_id = 14409 AND id IN (77588283) 2025-08-06 18:40:09 [INFO]: QUANTITY Updated IDs: 77588283 2025-08-06 18:40:09 [INFO]: Successfully processed data for user 14409 2025-08-06 18:40:09 [INFO]: Execution Started 2025-08-06 18:40:09 [INFO]: Execution Finished 2025-08-06 18:50:01 [INFO]: Execution Started 2025-08-06 18:50:01 [INFO]: old server sucessfully connected 2025-08-06 18:50:01 [INFO]: sqs client sucess created 2025-08-06 18:50:02 [INFO]: Number of messages in the queue: 2 2025-08-06 18:50:02 [INFO]: item found in queue is if condition 14409 2025-08-06 18:50:02 [INFO]: item found in queue is 14409 2025-08-06 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBuvAMhWSzKCFX7Q9zUktDrunSW/IW9LUG2+VcklR1/O2OYOaMsdNWxUSfJukNd8aKxpcfbOXJwrOwab6nY2bmMZvsrc5D3VVKSrw99d3mVq1r7i1e+mqsrD0kTzukiOL7A+GEEeguyWikzQtYeeD6anS7ve8HCH87w2s93Zw9XAB6z6sD+dfflH3wpT1/VAWDt9n0NcRAomOJPfEJ336MLAvKiyLbUD6/ETI1Wv7Y1p5v/UX7kD5+KaTNAyVhaB+/DLYIY7ILwwohq25SOTS8VVa/ztXhZYXFIhcs1sWsDgwvnmCGe8sC3AXObv4CIwYIFJuVebLy7y/r1zFe7YUhIxbjUJbjDHcXNb39xRinBLD7SfhvM/WS1zcU7/0wu+AdU8N48ngnGM01yTdLv+3+hyfrsgov3ckXNDq7TDRgST+pyEMVL/ZyLZExX8bw7adH 2025-08-06 18:50:03 [INFO]: item found in queue is if condition 14409 2025-08-06 18:50:03 [INFO]: item found in queue is 14409 2025-08-06 18:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBW9iR/7R/GGjsQeBhiyZTPQ11Vuuec3dph/Ne2JhcfJCUYglUYYStkTX1iG5i5HoAwMBrAl3AArtHWgkhNAik1/4heScveSlG4dhVS76QTdkcerFjU9Pw0q6iCQz+RvikwSYHtK5Ck6XlYSeLcKngvzoT27b6ecy056STqNmWEavJ7QLelZbVbhOFBs8PegWMWY4qI4zxV9maPUKB4dSaKaUam/dREDGO6sEWAqTQkofjJkjdBx0kpNVojPNFQGy5wLzDGOgdGhQsU1/0JVxt2mONo9e6fEcHerfX09Fn+xAiAtCj03nTKu/PdNC5KZog/mfDlGv7/Zq7p2EELKQ69zaMnQiKo01kXR/lOnOgmy3t9PvBFnAA2rCPESSH2kvIsru6djg44U6jg88Pjc+RVuB3j3flcBnaqZREKIZvwJPv2+o9rjy9R+eSKPLdwRMH 2025-08-06 18:50:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-06 18:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-06 18:50:03 [INFO]: inside itemsold and closed 14409 2025-08-06 18:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:50:05 [INFO]: Ebay item id :: 285433338417 exists in Database 2025-08-06 18:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:50:05 [INFO]: inside itemsold and closed 14409 2025-08-06 18:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-06 18:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-06 18:50:07 [INFO]: Ebay item id :: 334991239032 exists in Database 2025-08-06 18:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-06 18:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-06 18:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-06 18:50:07 [INFO]: in processold action queue is array for {"44576010":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576010","ebayitemid":"285433338417","shopifyproductid":"8111392948446","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"8111392948446","shopifyvariantid":"44313537872094","shopifyinventoryid":"46411044651230","shopifylocationid":"","product_id":"44576010","variant_id":"77468717","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44575916":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44575916","ebayitemid":"334991239032","shopifyproductid":"7630059143390","variants":[{"price":"34.99","quantity":0,"weight":"0.75","shopifyproductid":"7630059143390","shopifyvariantid":"42719853576414","shopifyinventoryid":"44814323450078","shopifylocationid":"","product_id":"44575916","variant_id":"77468623","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-06 18:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-06 18:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-06 18:50:07 [INFO]: Shopify Inventory id 46411044651230 2025-08-06 18:50:07 [INFO]: Shopify Location id 58450641063 2025-08-06 18:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18: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-06 18:50:07 [INFO]: Change: available | Delta: -1 2025-08-06 18:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-06 18:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576010 and user_id = 14409 2025-08-06 18:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468717 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:50:07 [INFO]: Shopify Inventory id 44814323450078 2025-08-06 18:50:07 [INFO]: Shopify Location id 58450641063 2025-08-06 18:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-06 18:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-06T18:50:07Z","reason":"correction","changes":[{"name":"available","delta":-4},{"name":"on_hand","delta":-4}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-06 18:50:07 [INFO]: Change: available | Delta: -4 2025-08-06 18:50:07 [INFO]: Change: on_hand | Delta: -4 2025-08-06 18:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-06 18:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44575916 and user_id = 14409 2025-08-06 18:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77468623 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-06 18:50:07 [INFO]: updateIdsQuantity -> ["77468717","77468623"] 2025-08-06 18:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-06 18:50:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77468717 THEN 0 WHEN id = 77468623 THEN 0 END, quantityflag = CASE WHEN id = 77468717 THEN 0 WHEN id = 77468623 THEN 0 END WHERE user_id = 14409 AND id IN (77468717,77468623) 2025-08-06 18:50:07 [INFO]: QUANTITY Updated IDs: 77468717, 77468623 2025-08-06 18:50:07 [INFO]: Successfully processed data for user 14409 2025-08-06 18:50:07 [INFO]: Execution Started 2025-08-06 18:50:07 [INFO]: Execution Finished