2025-08-04 10:00:02 [INFO]: Execution Started 2025-08-04 10:00:02 [INFO]: old server sucessfully connected 2025-08-04 10:00:02 [INFO]: sqs client sucess created 2025-08-04 10:00:03 [INFO]: Number of messages in the queue: 4 2025-08-04 10:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:00:03 [INFO]: item found in queue is 14409 2025-08-04 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBRa2YXVrAoNELy8yCDIm02ENmpwrGwBCxiRKfp4NtwwQZPmoPmZurgiqkKoKyO/LgtffSzJbgAtGJd9EoANdDqwdOrkrpuF+XRYcR44l1GkUKzXGcDeLqK3RdH5IuyhSxXp0vkR0x6G0PaE2B5IHpsDzeaiJmTwPZUyQ9iBkCHuo7fsNormngLc/I1NyvTeFkXEDot7o7Q4w//oOQRJ42//L5qGtmTm0ZiHMev4DMTgmQ+Gy8iAkaDN54fVfJ9RYpSXeh+8vA/Y3vz+HzgtpvsyyEuCahNHHMAvtG/iJVpgpoWsh+/vH1mRjL9I8OezNVHI8kNnECz/ykPGPE245uZuzzlvoqfeGWZf9TgwNXk18x2uuZ4yARHjo0CCnzqWvcHDAjxPdTyzgN33kNYzLSSdAPsj18ZsQ9yp+nAikvosD6X4u/0HFDVqkSEpkQJPay 2025-08-04 10:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:00:04 [INFO]: item found in queue is 14409 2025-08-04 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBl45qIwBo/oJNvYOjgTDgg97MPpJxI1+wUJwiZ+9MS163OucZ+Z6YoRLy0DshlPqoWZ+J6vpTogBHNaNEV0H+Cdxej+2BCFBYR9GtbLeBxJbMvdrn+tUFLqjOELH8qt6TxFBGkJsP/X0C6VIHE1TUO3XERPxcLdsEGD4t6tQDvl8XYYsC4+2wLpnApniAMKRxfs0duluEZNxsM7QOtc2KuCOIWQBSZmytiTldx3tcdCo34umykR/XyQu7nJLWAjFEm7aSZvfq5YDntY3xcZBYx1O4OI5dvXThTjhKrbk6jJhEvcnROl2IPFCeZS66b+Md4tyj/JNvYPWbYU7TOrMYF2Rhel6YHVRn73gU/YE4W05UWGivdqsTRMDzICzoSalTIEI1oJ6mYB7LeM+3WMc9yB0xGwythWT0ORXMgQh0AF6V2Oj8OwP+zQNUEpkVm0+D 2025-08-04 10:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:00:04 [INFO]: item found in queue is 14409 2025-08-04 10:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4gTqIID0A/qL4utk1IolYStxNuncChO8MMesDYurzYO+0OOObdWzj7MQ4ZNlL+/zY9cylDixyDc7y9RH4tY4PGruuJ/zRNqez7/J1RoPgDAGj6mulX0xGDVrEOjdXFgxyGmm4R+y7kWGLqDJJo8xc+g34c5wpLdTpqufLUwCdeGp91RRD81iNQbe1MbS7aunOEESqKr65VgEtSzqF6W0URwYWmA1X3Kk58LkUInfAN8q31Z093O/ZTkXHkJUYfu6meE0/BjANepF98QequhJD0xoxklKHw/0LOsYuQhGHwmSMQ95bR6cjjbdRiKf8H0brSWGt1YPsVitwvUkiVnMt3DO5gD8kIyvd+qhdHx5vCM5kcug3ytQ4DvqhUnfHD8BTE8IzcITdjmicPE930o32W0R3i34r5CQrh0kMIIgad+/kCAEOPg4Va26uKR0+sBG 2025-08-04 10:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:00:04 [INFO]: item found in queue is 14409 2025-08-04 10:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBI85slYzBky9d2IVWt1tg4/W8mlX2PHnnIJJOTZxzeB2+J5Xf0qXKX8SV89pKpEsvwWB1UebsLncsNa8gaQJva4lCGZE+zyzstmks3IbRbTOR1a0TtowlCODn8F24x0p+KxQlGv/hPi3hhumlYVkjvG/cynW7j1iYBmA0GJOT+8+AXX792HrXWR7gQ/lsHwUlN7c4JV1Dr8JuNhb9A2mvhRx3Z0X/4/fzMFRWz6yrx+SZPk6GbZcxgX9m7PiadM9kNteiaypFVjjDTSKDxmz3r5WlDOTFBxeUeViqh6HXeoyh+WrrmVNeuv2+I1Te+p1Mpyr8H9u5Rewa9ai28dbmujbmx48ihvFo1oT4o0gjdINPQWtSH9eVYGC8Y+8UgquyhD5oEGjiVN/bC9QYGbnCc9JUmuM/jl807H0qB9Shzti4W5+RjwI/tvC9idaUiVoy 2025-08-04 10:00:05 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 10:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:00:05 [INFO]: inside itemsold and closed 14409 2025-08-04 10:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:00:07 [INFO]: Ebay item id :: 326152725748 exists in Database 2025-08-04 10:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:00:07 [INFO]: inside itemsold and closed 14409 2025-08-04 10:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:00:09 [INFO]: Ebay item id :: 224164605663 exists in Database 2025-08-04 10:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:00:09 [INFO]: inside itemsold and closed 14409 2025-08-04 10:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:00:11 [INFO]: Ebay item id :: 326030428673 exists in Database 2025-08-04 10:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:00:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:00:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:00:11 [INFO]: inside itemsold and closed 14409 2025-08-04 10:00:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:00:13 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:00:13 [INFO]: Ebay item id :: 226021645119 exists in Database 2025-08-04 10:00:13 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:00:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:00:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:00:13 [INFO]: in processold action queue is array for {"44734997":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734997","ebayitemid":"326152725748","shopifyproductid":"8697451053278","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8697451053278","shopifyvariantid":"45939218022622","shopifyinventoryid":"48037674483934","shopifylocationid":"","product_id":"44734997","variant_id":"77642890","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44664467":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664467","ebayitemid":"224164605663","shopifyproductid":"6635576492199","variants":[{"price":"9.67","quantity":0,"weight":"0.75","shopifyproductid":"6635576492199","shopifyvariantid":"39657741549735","shopifyinventoryid":"41752421040295","shopifylocationid":"","product_id":"44664467","variant_id":"77569687","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681361":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681361","ebayitemid":"326030428673","shopifyproductid":"8303376662750","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8303376662750","shopifyvariantid":"44851995902174","shopifyinventoryid":"46950040240350","shopifylocationid":"","product_id":"44681361","variant_id":"77586586","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681516":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681516","ebayitemid":"226021645119","shopifyproductid":"8303403925726","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8303403925726","shopifyvariantid":"44852056817886","shopifyinventoryid":"46950101156062","shopifylocationid":"","product_id":"44681516","variant_id":"77586741","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 10:00:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:00:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:00:13 [INFO]: Shopify Inventory id 48037674483934 2025-08-04 10:00:13 [INFO]: Shopify Location id 58450641063 2025-08-04 10:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:00: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-04 10:00:13 [INFO]: Change: available | Delta: -1 2025-08-04 10:00:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734997 and user_id = 14409 2025-08-04 10:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642890 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:00:13 [INFO]: Shopify Inventory id 41752421040295 2025-08-04 10:00:13 [INFO]: Shopify Location id 58450641063 2025-08-04 10:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:00: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-04 10:00:13 [INFO]: Change: available | Delta: -1 2025-08-04 10:00:13 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664467 and user_id = 14409 2025-08-04 10:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77569687 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:00:13 [INFO]: Shopify Inventory id 46950040240350 2025-08-04 10:00:13 [INFO]: Shopify Location id 58450641063 2025-08-04 10:00:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:00:13Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 10:00:14 [INFO]: Change: available | Delta: -2 2025-08-04 10:00:14 [INFO]: Change: on_hand | Delta: -2 2025-08-04 10:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681361 and user_id = 14409 2025-08-04 10:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586586 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:00:14 [INFO]: Shopify Inventory id 46950101156062 2025-08-04 10:00:14 [INFO]: Shopify Location id 58450641063 2025-08-04 10:00:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:00:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:00:14Z","reason":"correction","changes":[{"name":"available","delta":-3},{"name":"on_hand","delta":-3}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1986,"restoreRate":100}}}} 2025-08-04 10:00:14 [INFO]: Change: available | Delta: -3 2025-08-04 10:00:14 [INFO]: Change: on_hand | Delta: -3 2025-08-04 10:00:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:00:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681516 and user_id = 14409 2025-08-04 10:00:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586741 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:00:14 [INFO]: updateIdsQuantity -> ["77642890","77569687","77586586","77586741"] 2025-08-04 10:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-04 10:00:14 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77642890 THEN 0 WHEN id = 77569687 THEN 0 WHEN id = 77586586 THEN 0 WHEN id = 77586741 THEN 0 END, quantityflag = CASE WHEN id = 77642890 THEN 0 WHEN id = 77569687 THEN 0 WHEN id = 77586586 THEN 0 WHEN id = 77586741 THEN 0 END WHERE user_id = 14409 AND id IN (77642890,77569687,77586586,77586741) 2025-08-04 10:00:14 [INFO]: QUANTITY Updated IDs: 77642890, 77569687, 77586586, 77586741 2025-08-04 10:00:14 [INFO]: Successfully processed data for user 14409 2025-08-04 10:00:14 [INFO]: Execution Started 2025-08-04 10:00:14 [INFO]: Execution Finished 2025-08-04 10:10:02 [INFO]: Execution Started 2025-08-04 10:10:02 [INFO]: old server sucessfully connected 2025-08-04 10:10:02 [INFO]: sqs client sucess created 2025-08-04 10:10:03 [INFO]: Number of messages in the queue: 3 2025-08-04 10:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:10:03 [INFO]: item found in queue is 14409 2025-08-04 10:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEB/0t+DSEqi6ShNajPWqWCOWCE/kNgl9DCLNSdrd5pwyXzKkAa/E3REHSNih0bA80BZUPUDA7elIDAXDPdhK6npLpj27UxmEHzitVquJJQV/rgULyZ16cbFF0b4Io4ppu2k768F6JcvwL1qQJSkgUUBZgiEdp6CnoJ08gGY7QZYGZkTroB71kFuZZz0NywKDbRSVHU4vqdS4AHOGs06xMa27TTpLd/f0jMyLMdVXLK0tPTy85ftRaSYnzTSpt6Xb95SyBArDsfOgUcGIjSfMRfv5NQV7g1ry4is6A4ryNw7kSI6t6OsgW75tJEbEev8xcQayUaimhWJvqYPLq1JC8pJwonePsBIjFbx/IkzRJ8+Y4AFUQ9MXQN/ZgH868qKJ+IIBdFPSIiHMUcn17Eub1R9JJDuZrQ9QTn+55Iby0GA8SBsEXq8GCvQrpfHeb0AnfX 2025-08-04 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:10:04 [INFO]: item found in queue is 14409 2025-08-04 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/2Nw8JscduXwpQbI7p8BN0MAWg8ms0KYv0Bzw+ATfU2KjDQbFpC6SpZxiMpnjtj8/PiJjS6FzCLclx0y2uBTPQJKzuw9dPjQYWx1ATxzHbDzzq8LBo/s8p9bJc+wi7Ao2Zv2xuU4fj7n0IkseN1wgG1TYIl4XJT4pzq+NvxzFK1oXClWwbr4QIQaHEHSG/QYINzXyn2QqHswY+1muUcpTm8nfiB0wYZ/HRwbx6SfzYFYqlRF5g7CPnBkJBJKYRiMoIRVAwj2N7BkV/aFJoKHNYq9UJ4coKP8JdGAayzsTeHekgWBtXoKrF0d+Kb+cBevTJlUUvuFcTA41AakeT61F/m9vXltSxgaWJlRK/8eEFsM9UQX/rJZtGX3SZXZ4+STvkcOqoaC2U41p5GJuwnygLciT0FkD48kVR9eaUSuie5oFak7T8nB62rsZraQYL6a 2025-08-04 10:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:10:04 [INFO]: item found in queue is 14409 2025-08-04 10:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEByLDWJWmXRM1WzS1Eq+i4podDkE7i4Q1lrx32B+o0Go548qf9HEpuCihrZ471aucrvsHFB1gR5RJrs/N6/H0E8D0dCM/1j+Xob/vu7etfBUNN+5gs2nBkP2s9Oxz2t5XdTaqyLYSPK7L0uSpKn69FDQ9CeHSxSj4w6xN+e2mpK5lObmFFaipP29ze6EXmPJXIJ4dw/ArcdJBEoo8dio+0VIWWI5eKftcmLFqB+Tg7C3WJHZXtSKa14XMMA6UwGC2hJZlYKhhOoVWZ0M3qMWUlgsSVMuV62XMQO4lnp2JNoLYzdKVieoO3Fo9FHKzovTI/ID0OzqJDsSbCCapS9dqRk8Ey4uHCbMVZEcd74Js+fTmF13hq/E3nIPLAnhiuXEpNoRM6DESUx2Up/FKt3LYJ+pu7TCWM3XOIvXmgVn7w0w8CvbiD2lnc9YpbD7Ua2AMQ 2025-08-04 10:10:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 10:10:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:10:04 [INFO]: inside itemsold and closed 14409 2025-08-04 10:10:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:10:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:10:06 [INFO]: Ebay item id :: 286653812517 exists in Database 2025-08-04 10:10:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:10:06 [INFO]: inside itemsold and closed 14409 2025-08-04 10:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:10:08 [INFO]: Ebay item id :: 326134689056 exists in Database 2025-08-04 10:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:10:08 [INFO]: inside itemsold and closed 14409 2025-08-04 10:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:10:09 [INFO]: Ebay item id :: 226021645335 exists in Database 2025-08-04 10:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:10:09 [INFO]: in processold action queue is array for {"44664919":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664919","ebayitemid":"326134689056","shopifyproductid":"8495823519966","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8495823519966","shopifyvariantid":"45401172771038","shopifyinventoryid":"47499151507678","shopifylocationid":"","product_id":"44664919","variant_id":"77570139","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681521":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681521","ebayitemid":"226021645335","shopifyproductid":"8303353856222","variants":[{"price":"9.99","quantity":0,"weight":"0.9375","shopifyproductid":"8303353856222","shopifyvariantid":"44851957924062","shopifyinventoryid":"46950002262238","shopifylocationid":"","product_id":"44681521","variant_id":"77586746","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 10:10:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:10:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:10:09 [INFO]: Shopify Inventory id 47499151507678 2025-08-04 10:10:09 [INFO]: Shopify Location id 58450641063 2025-08-04 10:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:10: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-04 10:10:10 [INFO]: Change: available | Delta: -1 2025-08-04 10:10:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664919 and user_id = 14409 2025-08-04 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77570139 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:10:10 [INFO]: Shopify Inventory id 46950002262238 2025-08-04 10:10:10 [INFO]: Shopify Location id 58450641063 2025-08-04 10:10:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:10:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:10:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 10:10:10 [INFO]: Change: available | Delta: -2 2025-08-04 10:10:10 [INFO]: Change: on_hand | Delta: -2 2025-08-04 10:10:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:10:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681521 and user_id = 14409 2025-08-04 10:10:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586746 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:10:10 [INFO]: updateIdsQuantity -> ["77570139","77586746"] 2025-08-04 10:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 10:10:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77570139 THEN 0 WHEN id = 77586746 THEN 0 END, quantityflag = CASE WHEN id = 77570139 THEN 0 WHEN id = 77586746 THEN 0 END WHERE user_id = 14409 AND id IN (77570139,77586746) 2025-08-04 10:10:10 [INFO]: QUANTITY Updated IDs: 77570139, 77586746 2025-08-04 10:10:10 [INFO]: Successfully processed data for user 14409 2025-08-04 10:10:10 [INFO]: Execution Started 2025-08-04 10:10:10 [INFO]: Execution Finished 2025-08-04 10:20:01 [INFO]: Execution Started 2025-08-04 10:20:01 [INFO]: old server sucessfully connected 2025-08-04 10:20:01 [INFO]: sqs client sucess created 2025-08-04 10:20:02 [INFO]: Number of messages in the queue: 4 2025-08-04 10:20:02 [INFO]: item found in queue is if condition 14409 2025-08-04 10:20:02 [INFO]: item found in queue is 14409 2025-08-04 10:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBq3ColzF/q4kwvBAJoSwvGQdNyX0Tj3v1DZWGcfpCDFM8LHtJ3vICI+PBNB2zO6YvW8NOrj5ONmbKZlutrLlj0qJ3+4lfPSgZ21slpQft7D/xZdmYXX9X04XfRnOvT7z5ATx37XSAPxGhZI3oLZiUvz9vbf685+FjAJomg/xejjMcNuUZibeHzfCZ3Yry+gQUF7oKuyw3G7Wn3KcCsL4108HUKRIyZrNuomE/6NWL35IJwCMdqzRlOnMPj1XwGuWHeGsYV0V3AYdp/ZSfcTfGNqG1KTt1/pzSw6QZZ99Cbz1kkPaF36Av0ShcIda4PA3g+CI9eIJnusAZg6CI+kf0GIiLaNmOx3K41g+PZkuUV7YXR5MWP3epfaSfVUcmBOL3fqLzghVcDtHRFKDMpPYqa2ljNpHdMOq0upkWQaNPmsk/GbjEoDS6Xalz+PGbA0ej 2025-08-04 10:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:20:03 [INFO]: item found in queue is 14409 2025-08-04 10:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBrLkb4ceCh6EssGAtzIOutjTL2/kOTx5fFguDQA0WTfqu4vM4FNJCf7X5znjYvlZkUJjIbzfPYFl2pb8CJrC+nLaagF5HIXOuT4XjUaip4vBglHgUP8zLnWR32hN34srSgx8kykdlG8g86shC8/JrTpGVeb7+t0eKUfj2GSwyy1xRGeTRjmJehsAqofD6SJbuMsBQ5EbrAElb0o+c69XQzAXR/O7mrldttrdZMUnBEFAqbHtC16dbtkYIRV+IRB0DTOVIhSoniF7l65fDQ8/tAmZexmZesUjtMCKUo6lraVVlsabAMSzdAP8O1n93Vo+0tu5z9pLV12Jk5S54oD1zJbf15NX3zjYzbnHCVHyYIplXWvN+Xnde/D/mOr4NT9iV0sEAGUpJZo+t7uMW891naG8+FgZYeJEME+24j4y9ATkrPYCGfIyzXBcFEFlVfS/a 2025-08-04 10:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:20:03 [INFO]: item found in queue is 14409 2025-08-04 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBjpiU94uybHT5rYFOlLOW0Y7CmNE0i+GUn6xFbJRJoSCXdyV1WJOs0Auh7Rg5szNice1YDDwm0898UynN643YKoNqFE65jgKRbFIgq1ENS3WfdImolH9u1XwDGFXP26f4qBUQ+dyudXE14BVmYryLitF3NtIhKlWlcH68rZSMUN3NtANGVefXhTgJZT1EqyzcffRAuGKA8bf1CtQ8b4Dm9qaeHbdZf83M+mgUNbcJVhJEbIQ2Iuc9Z8vdSC8/LD7Xnj+aAeM5LcaZwkcbrI+MZFAsdkXw6aXiSPSWY+yUWas2Jw1x5DXbk1nbAGu+/Wffkh2qI6dctKnkLBA8Xi4Dx9sGIcQgfliYbhF8ZaIhepl+RCPG8+vPGYYYWVMG/vANAcmPgiI/ZM3NO03DH3eYzpvioxvntYdIKThWzOcxteBIOOrtVU0tc/UDP1UtzA5U 2025-08-04 10:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:20:04 [INFO]: item found in queue is 14409 2025-08-04 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBEABzaBjKQn4HvYKkn6nOZGOIQ1XuRUWSKhQH9zJWmmEeU46UHmbJKMgxBEyfjS/+v+o1Lwd68ML0ojLg8b5/rAkVu5QQ04GUz2r3q9Vqe6v1Rywyn/DOVe2FlO4i+JeiwuANQFN/5LTrzBiSc1LYD+DJRJLjRlq2nv5c9VAMXCBbqV/2SdS203NGqwe5j5Btu4i2SSg2KU7mdQAC6Azd6Y/fAi4dDZ4Vfd7ub71a7YGUKD4FQsre+5ESCDysDKH/ANPTfCuwlzxWzVI/tPdtaGAc6uJU02Fdgq2B4lY/bAxeALoyfEhBB0d+THbuBgkbN6WfsIH4PNVdqzj4hnAJFVRY08d22L7hho+mfnQwhrPWglpwPpoXAzA6QdYoB8U63VoKLoypdzoVLqEcKJj6/HusvI2xNRS+VldGBkJgHK15Hzt61a36b4lDOLAldz5K 2025-08-04 10:20:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 10:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:20:04 [INFO]: inside itemsold and closed 14409 2025-08-04 10:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:20:06 [INFO]: Ebay item id :: 324302587201 exists in Database 2025-08-04 10:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:20:06 [INFO]: inside itemsold and closed 14409 2025-08-04 10:20:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:20:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:20:08 [INFO]: Ebay item id :: 226021646458 exists in Database 2025-08-04 10:20:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:20:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:20:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:20:08 [INFO]: inside itemsold and closed 14409 2025-08-04 10:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:20:09 [INFO]: Ebay item id :: 226030447947 exists in Database 2025-08-04 10:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:20:09 [INFO]: inside itemsold and closed 14409 2025-08-04 10:20:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:20:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:20:11 [INFO]: Ebay item id :: 326119677932 exists in Database 2025-08-04 10:20:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:20:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:20:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:20:11 [INFO]: in processold action queue is array for {"44664489":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664489","ebayitemid":"324302587201","shopifyproductid":"6634317578407","variants":[{"price":"9.67","quantity":0,"weight":"0.5","shopifyproductid":"6634317578407","shopifyvariantid":"39653699453095","shopifyinventoryid":"41748342767783","shopifylocationid":"","product_id":"44664489","variant_id":"77569709","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681529":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681529","ebayitemid":"226021646458","shopifyproductid":"8303350415582","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8303350415582","shopifyvariantid":"44851951141086","shopifyinventoryid":"46949995479262","shopifylocationid":"","product_id":"44681529","variant_id":"77586754","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734373":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734373","ebayitemid":"226030447947","shopifyproductid":"8303545778398","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8303545778398","shopifyvariantid":"44852946960606","shopifyinventoryid":"46950991298782","shopifylocationid":"","product_id":"44734373","variant_id":"77642266","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734845":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734845","ebayitemid":"326119677932","shopifyproductid":"8475253735646","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8475253735646","shopifyvariantid":"45339985903838","shopifyinventoryid":"47437932560606","shopifylocationid":"","product_id":"44734845","variant_id":"77642738","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 10:20:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:20:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:20:11 [INFO]: Shopify Inventory id 41748342767783 2025-08-04 10:20:11 [INFO]: Shopify Location id 58450641063 2025-08-04 10:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:20:11Z","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-04 10:20:11 [INFO]: Change: available | Delta: -1 2025-08-04 10:20:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664489 and user_id = 14409 2025-08-04 10:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77569709 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:20:11 [INFO]: Shopify Inventory id 46949995479262 2025-08-04 10:20:11 [INFO]: Shopify Location id 58450641063 2025-08-04 10:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:20:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:20:11Z","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-04 10:20:11 [INFO]: Change: available | Delta: -3 2025-08-04 10:20:11 [INFO]: Change: on_hand | Delta: -3 2025-08-04 10:20:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:20:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681529 and user_id = 14409 2025-08-04 10:20:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586754 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:20:11 [INFO]: Shopify Inventory id 46950991298782 2025-08-04 10:20:11 [INFO]: Shopify Location id 58450641063 2025-08-04 10:20:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:20:12Z","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-04 10:20:12 [INFO]: Change: available | Delta: -4 2025-08-04 10:20:12 [INFO]: Change: on_hand | Delta: -4 2025-08-04 10:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734373 and user_id = 14409 2025-08-04 10:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642266 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:20:12 [INFO]: Shopify Inventory id 47437932560606 2025-08-04 10:20:12 [INFO]: Shopify Location id 58450641063 2025-08-04 10:20:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:20:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:20:12Z","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-04 10:20:12 [INFO]: Change: available | Delta: -4 2025-08-04 10:20:12 [INFO]: Change: on_hand | Delta: -4 2025-08-04 10:20:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:20:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734845 and user_id = 14409 2025-08-04 10:20:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642738 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:20:12 [INFO]: updateIdsQuantity -> ["77569709","77586754","77642266","77642738"] 2025-08-04 10:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4 2025-08-04 10:20:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77569709 THEN 0 WHEN id = 77586754 THEN 0 WHEN id = 77642266 THEN 0 WHEN id = 77642738 THEN 0 END, quantityflag = CASE WHEN id = 77569709 THEN 0 WHEN id = 77586754 THEN 0 WHEN id = 77642266 THEN 0 WHEN id = 77642738 THEN 0 END WHERE user_id = 14409 AND id IN (77569709,77586754,77642266,77642738) 2025-08-04 10:20:12 [INFO]: QUANTITY Updated IDs: 77569709, 77586754, 77642266, 77642738 2025-08-04 10:20:12 [INFO]: Successfully processed data for user 14409 2025-08-04 10:20:12 [INFO]: Execution Started 2025-08-04 10:20:12 [INFO]: Execution Finished 2025-08-04 10:30:01 [INFO]: Execution Started 2025-08-04 10:30:01 [INFO]: old server sucessfully connected 2025-08-04 10:30:02 [INFO]: sqs client sucess created 2025-08-04 10:30:03 [INFO]: Number of messages in the queue: 3 2025-08-04 10:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:30:03 [INFO]: item found in queue is 14409 2025-08-04 10:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB1ahlV7wmS1K5BthPo7yReaUFbyuO3jnoPpP/jIa/E/VeJ9JuodQPB6vVNsTUor4d+56Iw/W3J7qvrHYl7SvlPprmHU07TfntMpb2xrQxacqM/foxnVFUA1OBm2nmFHw4A7cTFDhHuTrV/l+yTNgaIWuLbZtMXh073P6IPB/FX/p5TLQajNhQKTJ9+USmnBNxgJzjVnvkEDzhNpiC+xkrV6QWevlXsmnOFPqngpRdCq2DSiLWzoQgbL+GozkmCZXhnHAc7CGwUYLFXiAzYvWGT54ZiJfr7+8ZmtLThXo86OLgPtswexpE2xG9dz1qA6+1IswANqPMIQnSRyZpKDFxo+UobFD6z5YjMEYYokiLhZnV2N5W/vvcNd+zUEwnpXg3uS4DSoR3iX1FBz/MIN0lyP8glBxrX8sxdr/CPkTqUCEOA25Bp7Zdik67PAoYIo0w 2025-08-04 10:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:30:03 [INFO]: item found in queue is 14409 2025-08-04 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBNkO6m0tNX4JCzWuF6kvWTwlDBenvxcHbddBWv5FBk+SX6RYPzNBcn5MnQg8ogJ4ylAMcV3aaa6YjZz18+/yaphVOHTAOESh7mX1SMQ983ui6D+/liEvTn1c57ax+7TAJsgajboOAnWqt6IlVPwqNjEUc45OHDW2fu7sSyUOU/pRbaY6O983ad3V1lS3kbhtqqjwaUa2OKpqc4DmLcf3TYw9RWxSLonwYjdeUmxyMd435Yx7AjyiUeKThNNp5/Y00b/d+QpJ+22+neqCFtRPVqyp4tioz8B2bCprQTS5jdx/lY9wAQO+mBLUwJbHqX5PYWf0gBTAvcVO8icjjbGAbDGK6qYI4LJx1Q3tKH03Ko1ZgK5ZCWSfT/M/Yf8lpM5EXcPqKGa8N7D8f9NLZ6m3Lt0SwCKmJwi43tiZI6dCtSQ0xGCN6AmxJgNFC+r1NjCA5 2025-08-04 10:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 10:30:04 [INFO]: item found in queue is 14409 2025-08-04 10:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBJEG8ZyXPaI6sJ71QoNkIjqwEXScBZ7xjY0BophL8cpg3LHxf7S+qUKicJhpneyCnlYzNPLzor5ts8S2Nuz44lCtfzAR42RIL2uZOG45jfaoeKp+2dynjxhQEEWiPDzYMmQ+s016R1Ybd7HCOfWN9US4L2C7wM9TGMmr3SRpTwOxAh8bcN0v4WBgYS8JEYtdtdT74r9GL+5WPa0HIxJ9cfEPKXKEA3V29KlpmBGZpdqk/f50PL6EuhRPtYMUEGHHFRkG5v1WYzWoEBLJU9A80ywqF6gh+1cfevSdpybf+nMaUk9x7i1/J5hjGQTDOMjjjP7u1IaXQKzdlnyd4L14+r45SJLe4DQT6eDDtTMUu8UObZJsCnPE0gRuQ74k68faQQys9PuYk7PY4GaCjvc+VbHaxEgcRka+nNBRsZK66JYQs/si8kOXPymOjDtzhaq8D 2025-08-04 10:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 10:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:30:04 [INFO]: inside itemsold and closed 14409 2025-08-04 10:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:30:06 [INFO]: Ebay item id :: 226470988384 exists in Database 2025-08-04 10:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:30:06 [INFO]: inside itemsold and closed 14409 2025-08-04 10:30:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:30:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:30:08 [INFO]: Ebay item id :: 226179019318 exists in Database 2025-08-04 10:30:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:30:08 [INFO]: inside itemsold and closed 14409 2025-08-04 10:30:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:30:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:30:10 [INFO]: Ebay item id :: 226021649031 exists in Database 2025-08-04 10:30:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:30:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:30:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:30:10 [INFO]: in processold action queue is array for {"44683928":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44683928","ebayitemid":"226470988384","shopifyproductid":"8795272052958","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8795272052958","shopifyvariantid":"46233857491166","shopifyinventoryid":"48334169309406","shopifylocationid":"","product_id":"44683928","variant_id":"77589153","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734996":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734996","ebayitemid":"226179019318","shopifyproductid":"8706569830622","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8706569830622","shopifyvariantid":"45962737746142","shopifyinventoryid":"48061426237662","shopifylocationid":"","product_id":"44734996","variant_id":"77642889","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44681543":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44681543","ebayitemid":"226021649031","shopifyproductid":"8303351529694","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"8303351529694","shopifyvariantid":"44851953107166","shopifyinventoryid":"46949997445342","shopifylocationid":"","product_id":"44681543","variant_id":"77586768","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 10:30:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:30:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:30:10 [INFO]: Shopify Inventory id 48334169309406 2025-08-04 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-04 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:30:10Z","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-04 10:30:10 [INFO]: Change: available | Delta: -4 2025-08-04 10:30:10 [INFO]: Change: on_hand | Delta: -4 2025-08-04 10:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44683928 and user_id = 14409 2025-08-04 10:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589153 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:30:10 [INFO]: Shopify Inventory id 48061426237662 2025-08-04 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-04 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10: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-04 10:30:10 [INFO]: Change: available | Delta: -1 2025-08-04 10:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734996 and user_id = 14409 2025-08-04 10:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642889 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:30:10 [INFO]: Shopify Inventory id 46949997445342 2025-08-04 10:30:10 [INFO]: Shopify Location id 58450641063 2025-08-04 10:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:30:11Z","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-04 10:30:11 [INFO]: Change: available | Delta: -1 2025-08-04 10:30:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44681543 and user_id = 14409 2025-08-04 10:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77586768 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:30:11 [INFO]: updateIdsQuantity -> ["77589153","77642889","77586768"] 2025-08-04 10:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 10:30:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77589153 THEN 0 WHEN id = 77642889 THEN 0 WHEN id = 77586768 THEN 0 END, quantityflag = CASE WHEN id = 77589153 THEN 0 WHEN id = 77642889 THEN 0 WHEN id = 77586768 THEN 0 END WHERE user_id = 14409 AND id IN (77589153,77642889,77586768) 2025-08-04 10:30:11 [INFO]: QUANTITY Updated IDs: 77589153, 77642889, 77586768 2025-08-04 10:30:11 [INFO]: Successfully processed data for user 14409 2025-08-04 10:30:11 [INFO]: Execution Started 2025-08-04 10:30:11 [INFO]: Execution Finished 2025-08-04 10:40:01 [INFO]: Execution Started 2025-08-04 10:40:01 [INFO]: old server sucessfully connected 2025-08-04 10:40:01 [INFO]: sqs client sucess created 2025-08-04 10:40:02 [INFO]: Number of messages in the queue: 1 2025-08-04 10:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:40:03 [INFO]: item found in queue is 14409 2025-08-04 10:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBEKwey1jUSFK2CgNQlTCcnMFSIGSCV9MTv+qDDt+FMzR/CeUbA8HJaXuuZe+w8HuBq2FQL7ZGyGdyMXGdgldpgjyP7Btd4WI2ZEh4PZXZJB6sCv85dVIXhRJBC88pC9hs9g9gnthWCO1wWNVwdBMC7ZU+79dscAuNgyOkBPsCBHRXEAe+5EN0pUgYJU3Ky7Z8Br3GcANonue51m7IB4k/xWu3nZCQCgBa0k8SzZa3XF7HYW1XmiKENba1DIie/hhGv5KN41J8sWTI1loQp2Ddq+6HjkkrtL9PqHN5mqWbi+LerFKnNLW1yGp7ERc0ASuZW0m4kHunbnhomXnBQRnAUpGBq5VJg+/BR77KG7E46aOCdbDDDh9OPKz+i3mM/k0cpfTy4L4vvt24lIbHt09mQe1Py1GcExYFSBMXKZZdfIQRriPmT7MG4XpA9LSO6Wsu 2025-08-04 10:40:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 10:40:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:40:03 [INFO]: inside itemsold and closed 14409 2025-08-04 10:40:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:40:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:40:05 [INFO]: Ebay item id :: 225090509889 exists in Database 2025-08-04 10:40:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:40:05 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 10:40:05 [INFO]: in processold action queue is array for {"44677710":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"44677710","ebayitemid":"225090509889","deleted":1}}} 2025-08-04 10:40:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:40:05 [INFO]: productIds WHich are having null productid -> [44677710] 2025-08-04 10:40:05 [INFO]: ebayItemIds WHich are not imported-> ["225090509889"] 2025-08-04 10:40:05 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 10:40:05 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 10:40:05 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (44677710) 2025-08-04 10:40:05 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 10:40:05 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 10:40:05 [INFO]: Transaction committed successfully. 2025-08-04 10:40:05 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 10:40:05 [INFO]: Successfully processed data for user 14409 2025-08-04 10:40:05 [INFO]: Execution Started 2025-08-04 10:40:05 [INFO]: Execution Finished 2025-08-04 10:50:01 [INFO]: Execution Started 2025-08-04 10:50:01 [INFO]: old server sucessfully connected 2025-08-04 10:50:01 [INFO]: sqs client sucess created 2025-08-04 10:50:02 [INFO]: Number of messages in the queue: 3 2025-08-04 10:50:02 [INFO]: item found in queue is if condition 14409 2025-08-04 10:50:02 [INFO]: item found in queue is 14409 2025-08-04 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBNmoYZY64emr97FMI91UENcTOn9tXjlJ0bfxQwhDEfLdzTH8DwWnGIiaHk6BPRTOMSyRi7DvQ+1xf+jm32E5/6evmwWzfyvckHFpCdt4r5K9RwUltkZZG+HhBKOKAEpqWcHwnPvc76R1fTFdckzE64rgccAIuJR0yiynXspEOwJ6kRZWs6GQ+i2RRDLTDhEqsahMyBbAjIR+4IrE+AjPuq1PaySfqhEfLwUm6vOBaSeIB/9VPk+E/5I6jRrUJ5v6He8UkDJQYSB4UrsnNJTDZKUf77UH1nRWzhMU6FpiSOyfBOkp3liD4R8YXYvUWmwKAga8bu9cOH0cN85ikKFkIOR5RP2s0rON7v61WIUb8DbArJGLHUt8/nOJdVHnofIVrYCTEr9Rbs/5ImddGPqxDh+KfFqjJDt+pE3JU0QUOPlbbe/Z18H7pqNnoKfttugF5 2025-08-04 10:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:50:03 [INFO]: item found in queue is 14409 2025-08-04 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBQAqLUPCXsmGUVCT6eCdrd9rL2bRwMxE8l8/r67ngdYXyLSHz+5CXIVHV6ltnZXbS8LGR+4rBQPBvphmWVAEe510DJdL9Ubdyh6nT80K/zxTSfW3ikz9H6638No4JjAlrm4V5kt6kovwkadeRWPvkOTVEMgexjBCPIigoHg1ALHTeHJPQ0z5pM6172FiYGAJ+fR/Tx1j9LcXXlomqKvXPSAnfMfyNzZOkUUam/Qe5gWhRI+by4tat6A2RsxYZlU7Iz+Tq47R/+ovEIcb5WpsGO8uURs5+IPmFwqLVub1pnUwS9TzDL/UcnNcFFEnmhJ2u4vXZ1UtUW503BrvF9VTSnKgywIOYcLAts93J77rSaZOjOSzoY9FHuhnTWUmU1issBGpUP/DcMhQVuCCzb60UrIzsHqgJ0h//kQlBEVEdw1GGxC+e0iJVriE2Az4DG4S4 2025-08-04 10:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 10:50:03 [INFO]: item found in queue is 14409 2025-08-04 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBykjt/IoqAOZqHqI3eBG5BQKeqnRxctbEsc5nGrLIhUcWkW0LA6Yf2hTohw65MkRCNhtjoD5+alPS4gRDosmtV2LMCerFKJH86G8XUUkZ2drzd7BEPLacJoJeOdlTXdpQ/oVkPoUCaqhNxisnOnlGlrV7nea4kP2PeBCI0o/rtUODCwjeCzWNt7AX4BZ1u+n8aTIPCV1thKJ3IHANBFlKsC1sxQPJ+EtgUzHP22ABLBRkT+NNNo67QbG5NIvZOqvmcF8oOfhSmu6YYX0Rs1EZIMKhuNtegHA58XU3wykCWvHaAfbEGFlgcTfm9KSWS7Ce/AIUKFJxSHZ3ctiUR2SSDBdI9jUh/juvDe5AhhhQzXAAnNLmuQOMtqNzF00i56dDZcgPRoA16jrNCmNAqdldEYXd0DWfdGO+blf/SIJMB8YO6TTDMUvPK39vGzoPXXlx 2025-08-04 10:50:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 10:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 10:50:03 [INFO]: inside itemsold and closed 14409 2025-08-04 10:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:50:05 [INFO]: Ebay item id :: 325217098720 exists in Database 2025-08-04 10:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:50:05 [INFO]: inside itemsold and closed 14409 2025-08-04 10:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:50:07 [INFO]: Ebay item id :: 224786810616 exists in Database 2025-08-04 10:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:50:07 [INFO]: inside itemsold and closed 14409 2025-08-04 10:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 10:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 10:50:09 [INFO]: Ebay item id :: 224806067247 exists in Database 2025-08-04 10:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 10:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 10:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 10:50:09 [INFO]: in processold action queue is array for {"44731678":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731678","ebayitemid":"325217098720","shopifyproductid":"7677883154654","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"7677883154654","shopifyvariantid":"42911647793374","shopifyinventoryid":"45006579335390","shopifylocationid":"","product_id":"44731678","variant_id":"77639563","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44731130":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44731130","ebayitemid":"224786810616","shopifyproductid":"7515261534430","variants":[{"price":"12.79","quantity":0,"weight":"0","shopifyproductid":"7515261534430","shopifyvariantid":"42331311341790","shopifyinventoryid":"44425293725918","shopifylocationid":"","product_id":"44731130","variant_id":"77639015","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674114":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674114","ebayitemid":"224806067247","shopifyproductid":"7530255876318","variants":[{"price":"13.59","quantity":0,"weight":"0","shopifyproductid":"7530255876318","shopifyvariantid":"42383873573086","shopifyinventoryid":"44477927555294","shopifylocationid":"","product_id":"44674114","variant_id":"77579334","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 10:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 10:50:09 [INFO]: Shopify Inventory id 45006579335390 2025-08-04 10:50:09 [INFO]: Shopify Location id 58450641063 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:50:09Z","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-04 10:50:09 [INFO]: Change: available | Delta: -4 2025-08-04 10:50:09 [INFO]: Change: on_hand | Delta: -4 2025-08-04 10:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731678 and user_id = 14409 2025-08-04 10:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639563 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:50:09 [INFO]: Shopify Inventory id 44425293725918 2025-08-04 10:50:09 [INFO]: Shopify Location id 58450641063 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10: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-04 10:50:09 [INFO]: Change: available | Delta: -1 2025-08-04 10:50:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 10:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44731130 and user_id = 14409 2025-08-04 10:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77639015 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:50:09 [INFO]: Shopify Inventory id 44477927555294 2025-08-04 10:50:09 [INFO]: Shopify Location id 58450641063 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 10:50:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T10:50:09Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 10:50:09 [INFO]: Change: available | Delta: -2 2025-08-04 10:50:09 [INFO]: Change: on_hand | Delta: -2 2025-08-04 10:50:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 10:50:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674114 and user_id = 14409 2025-08-04 10:50:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579334 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 10:50:09 [INFO]: updateIdsQuantity -> ["77639563","77639015","77579334"] 2025-08-04 10:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 10:50:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77639563 THEN 0 WHEN id = 77639015 THEN 0 WHEN id = 77579334 THEN 0 END, quantityflag = CASE WHEN id = 77639563 THEN 0 WHEN id = 77639015 THEN 0 WHEN id = 77579334 THEN 0 END WHERE user_id = 14409 AND id IN (77639563,77639015,77579334) 2025-08-04 10:50:09 [INFO]: QUANTITY Updated IDs: 77639563, 77639015, 77579334 2025-08-04 10:50:09 [INFO]: Successfully processed data for user 14409 2025-08-04 10:50:09 [INFO]: Execution Started 2025-08-04 10:50:09 [INFO]: Execution Finished