2025-08-04 12:00:01 [INFO]: Execution Started 2025-08-04 12:00:01 [INFO]: old server sucessfully connected 2025-08-04 12:00:01 [INFO]: sqs client sucess created 2025-08-04 12:00:03 [INFO]: Number of messages in the queue: 2 2025-08-04 12:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:00:04 [INFO]: item found in queue is 14409 2025-08-04 12:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBQNBxIxN1dLsYUX6RziGg/3iLjm2j9VUQLpP17wzwXXpXHSzwNx7Ia775xeh7YFCFLS1vwn/MvH/5Mz/QULCUONQUxs5mTmpebv5FzEsZJmuVgLL6wH8FY9diCwMoTimUvG5uWYyGwld8Qhy1F1HW6v3G28KPo8hYSGpX949HJ8+N1fT/nOJqAr/u6eFsRDJdVsWskgTuIDjcKFLGIQA+QoIqYM3JnQrJcqAwQfm4qqiblJx709j4oLlIrXvuVflYzJy4ko/x/hAG/Mw082PGFrjFyXJ4LHnxE0lGUebsQ1EEqOhm0vtN2sya25/oi8uuNj8F5hK7dCqbNqzFu3srSJkV1x52+JnR+Qg3TdgUjotDqhUh17/5F9NK+0+l+tNYTq9It7AYeQL8vEeZhmqez+c53QuLTzf2FjWkOPtWMxu4VnIj1sqxDXwUAcv6C5+e 2025-08-04 12:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:00:04 [INFO]: item found in queue is 14409 2025-08-04 12:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBvtR1uhZ0w9WQHilvdFL04G/W2e51P4Y6uuMkn6g1tCW9J8/ZNdABP3E8aI8+Ym7D8PiFy2xYhgVAAdgQByqe5WQpbGBUbI+zDEIdbTNOYqrfp59Iktqlf3Se2UvHPxPFLxLo6/2ZjUo0JEv1cuNo6l8BHbTC6kwEb7/LCRourbnOeCA4ZS6xDlmMgZJWpVVvJuh6mNOtwsVl6CFfAVLIQUtzvPKYJRHN9v8fIuTpHoC57r9k1LkwUHVnH+RqOCmJUrrqLnRP9S7KeX8ejKYKsIYFauEF5elG57LY/ZycM+zNLAVC2CXLEkI/LyfiS6qEYDNAZsmuBwugl6+XljlmjLQWo4LVusFAFXZDU5CmlGNkX5pZRZIUmn3MMEGNLZpEDdKI5lGMAvQ4qLvzVJ+7nWInuEyaaV3lrNLmLhUhn8ykpFNiMC08pEe62TDVFfjq 2025-08-04 12:00:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 12:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:00:04 [INFO]: inside itemsold and closed 14409 2025-08-04 12:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:00:06 [INFO]: Ebay item id :: 404737089395 exists in Database 2025-08-04 12:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:00:06 [INFO]: inside itemsold and closed 14409 2025-08-04 12:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:00:08 [INFO]: Ebay item id :: 285868197704 exists in Database 2025-08-04 12:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:00:08 [INFO]: in processold action queue is array for {"44770605":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44770605","ebayitemid":"404737089395","shopifyproductid":"8122668155102","variants":[{"price":"274.99","quantity":0,"weight":"3","shopifyproductid":"8122668155102","shopifyvariantid":"44335406448862","shopifyinventoryid":"46433085817054","shopifylocationid":"","product_id":"44770605","variant_id":"77679147","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44661551":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661551","ebayitemid":"285868197704","shopifyproductid":"8921767772382","variants":[{"price":"274.99","quantity":0,"weight":"3","shopifyproductid":"8921767772382","shopifyvariantid":"46810055901406","shopifyinventoryid":"48908533792990","shopifylocationid":"58450641063","product_id":"44661551","variant_id":"77566771","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:00:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:00:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:00:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:00:08 [INFO]: Shopify Inventory id 46433085817054 2025-08-04 12:00:08 [INFO]: Shopify Location id 58450641063 2025-08-04 12:00:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:00:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:00: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-04 12:00:08 [INFO]: Change: available | Delta: -1 2025-08-04 12:00:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:00:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:00:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44770605 and user_id = 14409 2025-08-04 12:00:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77679147 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:00:08 [INFO]: Shopify Inventory id 48908533792990 2025-08-04 12:00:08 [INFO]: Shopify Location id 58450641063 2025-08-04 12:00:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:00:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:00: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 12:00:09 [INFO]: Change: available | Delta: -1 2025-08-04 12:00:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:00:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:00:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661551 and user_id = 14409 2025-08-04 12:00:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566771 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:00:09 [INFO]: updateIdsQuantity -> ["77679147","77566771"] 2025-08-04 12:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 12:00:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77679147 THEN 0 WHEN id = 77566771 THEN 0 END, quantityflag = CASE WHEN id = 77679147 THEN 0 WHEN id = 77566771 THEN 0 END WHERE user_id = 14409 AND id IN (77679147,77566771) 2025-08-04 12:00:09 [INFO]: QUANTITY Updated IDs: 77679147, 77566771 2025-08-04 12:00:09 [INFO]: Successfully processed data for user 14409 2025-08-04 12:00:09 [INFO]: Execution Started 2025-08-04 12:00:09 [INFO]: Execution Finished 2025-08-04 12:10:01 [INFO]: Execution Started 2025-08-04 12:10:01 [INFO]: old server sucessfully connected 2025-08-04 12:10:01 [INFO]: sqs client sucess created 2025-08-04 12:10:02 [INFO]: Number of messages in the queue: 2 2025-08-04 12:10:02 [INFO]: item found in queue is if condition 14409 2025-08-04 12:10:02 [INFO]: item found in queue is 14409 2025-08-04 12:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBb682IFxjRSqCxIRSw1AgN9xYj4U18W9uM6awglKbaaIiASDbJtN/sFoyP1DZGzyIPdp30imCREftIvVr3VfrpkKnQr6hB4aTyMovXfSsM5soq+a/4fKW9DkMv36MEwdcROTQaVhQRXu7DiRrhtZRiViB+41A3EpvdDevhOWXwgGnDegV+U+mPM8FV4pzsCG7TamQNMsoFJt5ZrMPtMrtPWNzX1TV+8Dhf/5RBrnlAIu/j7EWs6xDZFyjq2Cr3A04cIskrYOlVIF/m14LZnraYwHzYbA0Io+rHVxWVI/MVK9AIdRtRwHdl2xrwjpkSPXYVnzMJZfY0Sft91l/zWpgCoL5eogUe+msyYzq2PitsJs0ede8nSJ9M9q8JI3I0TMXAgWzzueVVoYtX0SPnQzUrTGcHJpMZC032yLif/1+t0HP4SBuWtUCt+X018lylM1p 2025-08-04 12:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:10:03 [INFO]: item found in queue is 14409 2025-08-04 12:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBq9xuB4ZF3GVPuutxBE52rTOHDwEpYl2wsD5InbS3Mra0740mmv8wJyhq0Dq5lvouYmLzoXtXJGYWdJSskqAHaZmJrOWQPFMW6ZxtO2m969GNH2j/RueMNpUA6rrqKWw/YdFd8bsB525ue5zpQhF31nOggt9uWAJpoxPEoUdnAFSaFDVeSfTqmhkwFCK2Q3nU8o7LHaqszR3XBuweNKIVmi08PPdj3cvmflnmxyTZCtgJrtCOf33y2RaAvgqb6moKIr32rzUP4lO5AqXkkabguItNeL2Stu7YRNJQKa5a85PxfVnee6IZI+gkkjJmwTmcJZyP4y4YCLw4lHI93mfpMup5rg9/d+nfRw5gBB08/icEpxnoqE87ZK0jGLbiQh8OqEXdC4/i9ZsgWCNNFAmn0I+rwisU8YcHsrZGtR8BUqbKtyOG3fpJU16+ksZka/Hk 2025-08-04 12:10:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 12:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:10:03 [INFO]: inside itemsold and closed 14409 2025-08-04 12:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:10:05 [INFO]: Ebay item id :: 325520561096 exists in Database 2025-08-04 12:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:10:05 [INFO]: inside itemsold and closed 14409 2025-08-04 12:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:10:07 [INFO]: Ebay item id :: 225917784078 exists in Database 2025-08-04 12:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:10:07 [INFO]: in processold action queue is array for {"44710856":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44710856","ebayitemid":"325520561096","shopifyproductid":"7945338487006","variants":[{"price":"21.99","quantity":0,"weight":"0.5","shopifyproductid":"7945338487006","shopifyvariantid":"43960401887454","shopifyinventoryid":"46056856649950","shopifylocationid":"","product_id":"44710856","variant_id":"77618469","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44649137":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649137","ebayitemid":"225917784078","shopifyproductid":"7660677300446","variants":[{"price":"21.99","quantity":0,"weight":"0.5","shopifyproductid":"7660677300446","shopifyvariantid":"42834049171678","shopifyinventoryid":"44928660078814","shopifylocationid":"","product_id":"44649137","variant_id":"77554326","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:10:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:10:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:10:07 [INFO]: Shopify Inventory id 46056856649950 2025-08-04 12:10:07 [INFO]: Shopify Location id 58450641063 2025-08-04 12:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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-04 12:10:07 [INFO]: Change: available | Delta: -1 2025-08-04 12:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44710856 and user_id = 14409 2025-08-04 12:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77618469 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:10:07 [INFO]: Shopify Inventory id 44928660078814 2025-08-04 12:10:07 [INFO]: Shopify Location id 58450641063 2025-08-04 12:10:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:10:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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-04 12:10:07 [INFO]: Change: available | Delta: -1 2025-08-04 12:10:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:10:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:10:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649137 and user_id = 14409 2025-08-04 12:10:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554326 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:10:07 [INFO]: updateIdsQuantity -> ["77618469","77554326"] 2025-08-04 12:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 12:10:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77618469 THEN 0 WHEN id = 77554326 THEN 0 END, quantityflag = CASE WHEN id = 77618469 THEN 0 WHEN id = 77554326 THEN 0 END WHERE user_id = 14409 AND id IN (77618469,77554326) 2025-08-04 12:10:07 [INFO]: QUANTITY Updated IDs: 77618469, 77554326 2025-08-04 12:10:07 [INFO]: Successfully processed data for user 14409 2025-08-04 12:10:07 [INFO]: Execution Started 2025-08-04 12:10:07 [INFO]: Execution Finished 2025-08-04 12:20:01 [INFO]: Execution Started 2025-08-04 12:20:01 [INFO]: old server sucessfully connected 2025-08-04 12:20:01 [INFO]: sqs client sucess created 2025-08-04 12:20:02 [INFO]: Number of messages in the queue: 6 2025-08-04 12:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:03 [INFO]: item found in queue is 14409 2025-08-04 12:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLo5efY4LgG3SVBLjiwUFJxY2QcjOgRYywiZpIkJNjj/jiyF2IbabBIU/xC36pwFGvN1xQ7VhhQ3IUhiexR0+156wlNoYEkX0EFnvj59edPefWPRDk4mtM6D3mu3gA6+2kXgaxUvclIpp1SdFO5jGRE7kIrFST/HUSAlBPrDfyz4rk8T5p9Red277XzCYSgHNficTxf8T7scylcFHqwuGDdmJSwwP2O5mdlmTRmGc4yaUCSA+UApt1/HfzQKXMprn7Sey6CVvOcLuz5fjv+sIbOHqz2OT0sFNZ3Z6VgWdfls2OxgPC9ZFgHpsCQCXpO5JQcEZ+rtTe7+6X7XKeo+PRr7aVZYrprSFvRL1Vz1rcTq5urVw7z/c+cXmHnZElS8Lh5xYZmwpzweBalMzYwYyHRqK/S0rogMDdMLRLV8yujv3QDsuZnmlkp3rTOo270tG 2025-08-04 12:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:03 [INFO]: item found in queue is 14409 2025-08-04 12:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBSah0RnXaAcC5dHFxoNOT68jniN+r/iBqFD5+/vV+PmN8YF6FGjd9vo9qegTe5JslUpt7ei8vra5b8++uaQjXXAPTeqBEJQnqH/EYM3ThOVh9IPYNTbSLiPlpq0m+LAMtztpfEuhyRcX9QxnbpIQ6y7Bht8rMzMtG6k4V3RvK3grErhU7S/9wqn3WLRkTCUCIdmX3SzS9rM9b1k43fsf4KNmOQPD0Ut/l9Q5GU2K2AoOG2HbPeopXXrEyTSTiaw6vYtx42kZGqRT+H3QIUzrLzcIhjLW8dy0F7B0v+NoTtgR5st+Rje0Zy3/estY0z7D+iS1akMgutFq4zufKDxsqzOVQ9gYudeduNl+Cxp+IreHgvyEogR1MVStUCRP8NU2qckU2DRs53T0n3CTDWqIo7bKOwjgBfbuQ+y/t7BWAZGO7Oa9tiTsu0ENKUKEekgsk 2025-08-04 12:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:04 [INFO]: item found in queue is 14409 2025-08-04 12:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBVWFgpUa9nTWD3EM4IwhOjWoawdKtQKgx+BRD6YW61/bmWh5nU1iqaO5ekc1/qK1yIJfSHw4iUzM1kshkRNVcnz4DZPcrXCtUCO30sLy8KK1GROgbEuGeUdc4Lb1A7I3z7Xu7DGQ6nNT81h1djPfrMwLFsax0pTtHVoWke/eS4lhZQc+Dh+JWP+e6Dg7OJydHdnumoSaXPBBdi2s16TYR8XUpgwUniPhzVQyXmQSpVBS1sjacNMHA6LYLV/85P0TbhExbpSfCSyAYV7g5pEtuZoT4HM2HePJwYuVrt6DLHladfrzRbqboFitBlpoCkYZ9diJlPSyD3RwRAvSEMDF+qa1vgeechOuER6IsxWXbtu4FhHaLXpEPTO7dZed9AvZhur4m1wh1EOEH6/o/jltPxX4PeJ7IdoDxtaDBZwee6fL9ltvemK07wGlWsZx/3d54 2025-08-04 12:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:04 [INFO]: item found in queue is 14409 2025-08-04 12:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBcRF+uuNqdiHGfG9+4FE/ONBpEEfBZFizzyuq/uV2jj3z27ncbcIPwgaFRl/4leFQmMi0Be5xRKWUSP0tgAj0fztP+3ZDKABfvNlN2jr83fd2L1frBvuTbwgasfv3ZAKs2OOy+QGGfsMlhk59ZlUFwShyjFT8kYiRDN5XzEBu0pRz8phYzHdqXp+dcD4Oa+ugWCUTCiwEgM6ow+IkQIdIh2CSeol9z156GcFANZelmpfnZUe9FOOeoGtdJP9wIvqQr8h2lf7BzJ/MlYnlh+FI9iHDkbKwopglZR5KXQ6Z3jyFh7V8J0h+jKqi1JNtHPPAmbp+kB0y6rpOTcUejZd/7FJvDWmSuRrO6CbXQt1YKCtGftoExhnKLdFs9qxBzA6C2maHdhXJWhCaFYmEh9fR6s5BM0hmoBVL3wPeH2YljCLhf5R4ghdE7Eh2xf5L7lm6 2025-08-04 12:20:05 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:05 [INFO]: item found in queue is 14409 2025-08-04 12:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBn3zL1YfduU6aoROk1ETtNCX/nGwkiRdHRmjRjHzVZnCmbOxJSvEpwkeuAzzvg0mEZvWappLnIJSb1CDWDRVaX3BN5UbuPZSBhrXC/scR04Ywm2f69d9m6Jc7Rx3+pVgcwgFKQcuy2u34rzdV8MhZfORUV8/WpH2lHyG2RIj3EDy7VfJejQuOb32TryA0gzwyXx+vnwb+eXu4zHo377vLVhiRcN2jP79VXySvO8zpFEI1+hV5xEEHCEegC12dFf3/6wp/q4bqYe9iXKnCou5UMBwNADM/yiVrhiwLHqT1BH8o+An+//ss87Ju/m0dLQEsDxviTicsPeY8xVINMkMa5/a4sJnPCK92URqot3GYb7O2qNeis0jySmuG2j72nba8K+K1MvFItH8PrUUMBzvn1DyYsktfg1Y6SNSHppGzCMP7XcHpdwBAXyJcmzbm1j2x 2025-08-04 12:20:05 [INFO]: item found in queue is if condition 14409 2025-08-04 12:20:05 [INFO]: item found in queue is 14409 2025-08-04 12:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBBlJKGu1mFBLnu3MBs5p3Ss30x7KdJWFr+PL+IA0ppgOrDuKqjvHTiIKUZokb3+kuvhDEqDooj23hr0IdSuP3GjmwBE6/FRnbxFk3h9HFozJmq8dg6/aStpHr0iIYHIv3sSk7fPKrCbYNx+aQq1ZxK2DLnnaacSD5AdPHs2g5nWxL1Awed/j/huVz5WzmFSiPHTO/VOczMW3PGGtJ03gkZd+APk+CFqnD4t51BwBUDbsXDQlt1eihUWv08L7bi4h1ftPCwjasvLB+YDsjZje3qF9/1JCurqrQsOUtCzt39bmRDOsQCN4yxlZ4TFgOwWuyaIG4+Mt+aobmRJOeHBoR+o4D8xkpW0lk4GDYTzWRHQpetI8yKjKF7ieCCmI7hH4SCcNB5ztj/eYurN8kvBV3+PXQzLh3PHsQ6+vzO/ih/AiwRQs0sO8P4nApqBtB9P1w 2025-08-04 12:20:05 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-04 12:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:20:05 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:07 [INFO]: Ebay item id :: 404912803864 exists in Database 2025-08-04 12:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:20:07 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:09 [INFO]: Ebay item id :: 256517499814 exists in Database 2025-08-04 12:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:20:09 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:10 [INFO]: Ebay item id :: 326717468881 exists in Database 2025-08-04 12:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 12:20:10 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:12 [INFO]: Ebay item id :: 405383496554 exists in Database 2025-08-04 12:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:20:12 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:14 [INFO]: Ebay item id :: 325548234034 exists in Database 2025-08-04 12:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:20:14 [INFO]: inside itemsold and closed 14409 2025-08-04 12:20:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:20:16 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:20:16 [INFO]: Ebay item id :: 405383491827 exists in Database 2025-08-04 12:20:16 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:20:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:20:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:20:16 [INFO]: in processold action queue is array for {"44772498":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772498","ebayitemid":"404912803864","shopifyproductid":"8380290072798","variants":[{"price":"122.99","quantity":0,"weight":"3","shopifyproductid":"8380290072798","shopifyvariantid":"45103745335518","shopifyinventoryid":"47201608892638","shopifylocationid":"","product_id":"44772498","variant_id":"77681039","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44661118":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661118","ebayitemid":"256517499814","shopifyproductid":"8492218253534","variants":[{"price":"122.99","quantity":0,"weight":"3","shopifyproductid":"8492218253534","shopifyvariantid":"45395695304926","shopifyinventoryid":"47493671878878","shopifylocationid":"","product_id":"44661118","variant_id":"77566338","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313187":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45313187","ebayitemid":"326717468881","deleted":1}},"44684711":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684711","ebayitemid":"405383496554","shopifyproductid":"7473969692894","variants":[{"price":"122.99","quantity":0,"weight":"3","shopifyproductid":"7473969692894","shopifyvariantid":"42161678680286","shopifyinventoryid":"44255730237662","shopifylocationid":"","product_id":"44684711","variant_id":"77589936","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44673518":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44673518","ebayitemid":"325548234034","shopifyproductid":"7961955762398","variants":[{"price":"21.99","quantity":0,"weight":"2","shopifyproductid":"7961955762398","shopifyvariantid":"44016804593886","shopifyinventoryid":"46113387708638","shopifylocationid":"","product_id":"44673518","variant_id":"77578738","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44684703":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684703","ebayitemid":"405383491827","shopifyproductid":"8021563310302","variants":[{"price":"122.99","quantity":0,"weight":"3","shopifyproductid":"8021563310302","shopifyvariantid":"44152678351070","shopifyinventoryid":"46249646129374","shopifylocationid":"","product_id":"44684703","variant_id":"77589928","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:20:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:20:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:20:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:20:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:20:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:20:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:20:16 [INFO]: productIds WHich are having null productid -> [45313187] 2025-08-04 12:20:16 [INFO]: ebayItemIds WHich are not imported-> ["326717468881"] 2025-08-04 12:20:16 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 12:20:16 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 12:20:16 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45313187) 2025-08-04 12:20:16 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 12:20:16 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 12:20:16 [INFO]: Transaction committed successfully. 2025-08-04 12:20:16 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 12:20:16 [INFO]: Shopify Inventory id 47201608892638 2025-08-04 12:20:16 [INFO]: Shopify Location id 58450641063 2025-08-04 12:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:20:16Z","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 12:20:16 [INFO]: Change: available | Delta: -1 2025-08-04 12:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772498 and user_id = 14409 2025-08-04 12:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77681039 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:20:16 [INFO]: Shopify Inventory id 47493671878878 2025-08-04 12:20:16 [INFO]: Shopify Location id 58450641063 2025-08-04 12:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:20:16Z","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 12:20:16 [INFO]: Change: available | Delta: -1 2025-08-04 12:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661118 and user_id = 14409 2025-08-04 12:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566338 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:20:16 [INFO]: Shopify Inventory id 44255730237662 2025-08-04 12:20:16 [INFO]: Shopify Location id 58450641063 2025-08-04 12:20:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:20:16Z","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 12:20:17 [INFO]: Change: available | Delta: -1 2025-08-04 12:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684711 and user_id = 14409 2025-08-04 12:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589936 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:20:17 [INFO]: Shopify Inventory id 46113387708638 2025-08-04 12:20:17 [INFO]: Shopify Location id 58450641063 2025-08-04 12:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:20:17Z","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 12:20:17 [INFO]: Change: available | Delta: -1 2025-08-04 12:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44673518 and user_id = 14409 2025-08-04 12:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77578738 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:20:17 [INFO]: Shopify Inventory id 46249646129374 2025-08-04 12:20:17 [INFO]: Shopify Location id 58450641063 2025-08-04 12:20:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:20:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:20:17Z","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 12:20:17 [INFO]: Change: available | Delta: -1 2025-08-04 12:20:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:20:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:20:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684703 and user_id = 14409 2025-08-04 12:20:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589928 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:20:17 [INFO]: updateIdsQuantity -> ["77681039","77566338","77589936","77578738","77589928"] 2025-08-04 12:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-04 12:20:17 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77681039 THEN 0 WHEN id = 77566338 THEN 0 WHEN id = 77589936 THEN 0 WHEN id = 77578738 THEN 0 WHEN id = 77589928 THEN 0 END, quantityflag = CASE WHEN id = 77681039 THEN 0 WHEN id = 77566338 THEN 0 WHEN id = 77589936 THEN 0 WHEN id = 77578738 THEN 0 WHEN id = 77589928 THEN 0 END WHERE user_id = 14409 AND id IN (77681039,77566338,77589936,77578738,77589928) 2025-08-04 12:20:17 [INFO]: QUANTITY Updated IDs: 77681039, 77566338, 77589936, 77578738, 77589928 2025-08-04 12:20:17 [INFO]: Successfully processed data for user 14409 2025-08-04 12:20:17 [INFO]: Execution Started 2025-08-04 12:20:17 [INFO]: Execution Finished 2025-08-04 12:30:01 [INFO]: Execution Started 2025-08-04 12:30:01 [INFO]: old server sucessfully connected 2025-08-04 12:30:01 [INFO]: sqs client sucess created 2025-08-04 12:30:02 [INFO]: Number of messages in the queue: 3 2025-08-04 12:30:02 [INFO]: item found in queue is if condition 14409 2025-08-04 12:30:02 [INFO]: item found in queue is 14409 2025-08-04 12:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBKsOlymXJc1/3dJcML3Cgu9jGkY9lf2CuQ4+QIeVU41Tyqkd6K3J6awM9+YDM6IFm+6WKNpHV88oJtCDI860KroHLIa6fWkO4uR8n3EkwoH+KTHeAHG18XzfITeE4bt7tIsdEf78x1ctxLZe0gt6xuCmVBAxgQwhIZ8w1TZH5ZI2DjAAFSGbbzeB7nv6OiliszMjsihj6ScEXWlbBVmkg6D6IKgK03Ef8HL9CCIwuznrmsFZBFbLEwOBqetN/K0JsSxNXX9RET9A5Ou1OYn4qtm97AdvNZejXziyRqJQwRLexNMh03dgZgJMwj43BDp46kTVELVqcVRmehOjjO8qjHq3OjBQ3g0amXsN4OiZchMFZobX6pGj/2xZJA8fAHut25nfKX9/VEcLT3nhjQn0ToGM4zu9MVXZLToyMjvhEtLXoaXGlJ2JSW5/Xbkj8t3fc 2025-08-04 12:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:30:03 [INFO]: item found in queue is 14409 2025-08-04 12:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBHcy6Me+bXkvJMSC22w3hYthGsXzfanUA/XR1WbMbXljmIQfgrq6hWNb0gCX9dtQnyctrt8S/80vEPnr+2apv1dStGP8FQ4nW6u9NBLiXV0XiIMDXewuiISAtxwSTuDx8k2sTR/j181IcMR6f47/N12J2ejyo2TT58bfJR6Gmw+1t0hrBVzJmC56Lr6YKMIOWgcw7eGIUhpSqicvVfmEDbAnVnmuYMJkz8Ts0ke3CCmTX6W/E6r93ROM7tzEkDgkr8pEHyQuxxcqqXeVEkWfkgtA1rdOx4v5kKRUZ2t6SrOFM5gjEd86LKUkVvWNLemaJQAQdjrWzspLQXR4TJvS4ivORB3j4xZlySwSvq0rIg9o1Sz92WSZXcX3e/y6ppeSffQ1bekP/ELyUMZKK6Iz2PGM0lX3Yf7u8GwuFZaqEO41YZII3Pi2Qh50Nsbua9ziP 2025-08-04 12:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:30:04 [INFO]: item found in queue is 14409 2025-08-04 12:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBEBhqdsyMaKNwLQmO6JNBZ2S3WHmJRT0ZtD0+3WZvjdtR/uFQl5+uYGH/Eac5PvVIjYJHOYpNmRQr0NcenmVjr8UfEAcg41stcX2YDTj5WEG5dpuBezVUOlrHYdQERvzfgkt1imXOGwtqDnkGftu6zDa07dFF7Bn8rr/Z2nCzVg3iTfjjZHc3Vl68E6muGPzgDww4kElq/WOAcwo146I9rNSwtLVVlX1w/RhIer64mSeweu8HdGdxChvBdB5ULPgPZfYAtdabrhzlVWtgg5Vo+QKYX/2x+4jovrEuwdGnASLLjg+FsVhWGJc0TPS8Ql4tZIt1w536Z7W4gVf9yMUIb9SKB7rx0WbK11E/zd5XHk57x/8qwRh9uZzX+rZ5cdsQ0wsJ0Z3lNwW9XKIDLasox7FTG1LGckTKRaqjrQmA3OO2YRiZvT53REPES2wKS0o/ 2025-08-04 12:30:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 12:30:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:30:04 [INFO]: inside itemsold and closed 14409 2025-08-04 12:30:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:30:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:30:06 [INFO]: Ebay item id :: 225657717403 exists in Database 2025-08-04 12:30:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:30:06 [INFO]: inside itemsold and closed 14409 2025-08-04 12:30:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:30:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:30:07 [INFO]: Ebay item id :: 404757386695 exists in Database 2025-08-04 12:30:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:30:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:30:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:30:07 [INFO]: inside itemsold and closed 14409 2025-08-04 12:30:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:30:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:30:09 [INFO]: Ebay item id :: 225590624821 exists in Database 2025-08-04 12:30:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:30:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:30:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:30:09 [INFO]: in processold action queue is array for {"44733237":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44733237","ebayitemid":"225657717403","shopifyproductid":"7804789784798","variants":[{"price":"97.99","quantity":0,"weight":"2","shopifyproductid":"7804789784798","shopifyvariantid":"43419789459678","shopifyinventoryid":"45515176444126","shopifylocationid":"","product_id":"44733237","variant_id":"77641122","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44670099":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44670099","ebayitemid":"404757386695","shopifyproductid":"8232970027230","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8232970027230","shopifyvariantid":"44597279785182","shopifyinventoryid":"46695251804382","shopifylocationid":"","product_id":"44670099","variant_id":"77575319","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674307":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674307","ebayitemid":"225590624821","shopifyproductid":"8048576168158","variants":[{"price":"329.99","quantity":0,"weight":"2","shopifyproductid":"8048576168158","shopifyvariantid":"44202598138078","shopifyinventoryid":"46299674181854","shopifylocationid":"","product_id":"44674307","variant_id":"77579527","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:30:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:30:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:30:09 [INFO]: Shopify Inventory id 45515176444126 2025-08-04 12:30:09 [INFO]: Shopify Location id 58450641063 2025-08-04 12:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:30:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:30: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 12:30:09 [INFO]: Change: available | Delta: -1 2025-08-04 12:30:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:30:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:30:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44733237 and user_id = 14409 2025-08-04 12:30:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77641122 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:30:09 [INFO]: Shopify Inventory id 46695251804382 2025-08-04 12:30:09 [INFO]: Shopify Location id 58450641063 2025-08-04 12:30:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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 12:30:10 [INFO]: Change: available | Delta: -1 2025-08-04 12:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44670099 and user_id = 14409 2025-08-04 12:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77575319 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:30:10 [INFO]: Shopify Inventory id 46299674181854 2025-08-04 12:30:10 [INFO]: Shopify Location id 58450641063 2025-08-04 12:30:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:30:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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 12:30:10 [INFO]: Change: available | Delta: -1 2025-08-04 12:30:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:30:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:30:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674307 and user_id = 14409 2025-08-04 12:30:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579527 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:30:10 [INFO]: updateIdsQuantity -> ["77641122","77575319","77579527"] 2025-08-04 12:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 12:30:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77641122 THEN 0 WHEN id = 77575319 THEN 0 WHEN id = 77579527 THEN 0 END, quantityflag = CASE WHEN id = 77641122 THEN 0 WHEN id = 77575319 THEN 0 WHEN id = 77579527 THEN 0 END WHERE user_id = 14409 AND id IN (77641122,77575319,77579527) 2025-08-04 12:30:10 [INFO]: QUANTITY Updated IDs: 77641122, 77575319, 77579527 2025-08-04 12:30:10 [INFO]: Successfully processed data for user 14409 2025-08-04 12:30:10 [INFO]: Execution Started 2025-08-04 12:30:10 [INFO]: Execution Finished 2025-08-04 12:40:01 [INFO]: Execution Started 2025-08-04 12:40:01 [INFO]: old server sucessfully connected 2025-08-04 12:40:01 [INFO]: sqs client sucess created 2025-08-04 12:40:02 [INFO]: Number of messages in the queue: 5 2025-08-04 12:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:40:03 [INFO]: item found in queue is 14409 2025-08-04 12:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBnUfvOjJfO5Ze8gGIPJAT1y8r5MM+ucgy7MQ4g6busogORvpv1u25b+5gUUNCzXhhQrrEmYLFIah8I0yG22nb/OITxAR2OLszEcxoKLf5I8Tkul/H2QqfUAlB3Ifc22VYCCX2CPzAq8JZXrE3Hp5cOQRTnB+WN9TOL8Mji1q+cBUxtBibwJcUnydC5XaIbdUoBC/5Vs1TmpWl3ZP9K57vB/oKgJjSC5YSo+EkX4QnfYQXmKzSjkH45QYidW2xpuUtKtjsOsXAypZVtB/+0z/MD0YMd9Sic4xo2Ke0ezJctReoRPFNBp3l0l18QXNeZA2pYve9zf4H6fp3wmlYvVijAn0CABtPMBP5eWkqBF0lZ0RVM3WEC9CJsnh6LB9Fa0ifoQin/kc65cQZo8wRhM55gsEAnYSbKzv3+UsuKbp9oYWeQySx/qah2nUgh3qykd7J 2025-08-04 12:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:40:03 [INFO]: item found in queue is 14409 2025-08-04 12:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBbULPYZpyqpFgBktsbAO7Cj/71m1r7fw1BuKC4oywGn2A3+XmkGMF1j/qD2x+vXWsMoMNzrlOxpVBtsiqyd+0qYJhx1w4YqqVCjjXsgotZoVv7WLi8OmSh9HB2Ee6Q6yUgPLd0C5l8pGnW3Zu9BZVe4WnxlpxfL8EHvAjYmrHsMU72pikpLz5RiVtKptbOtqsoiNge2TKsvcdycVRNRsuAOnuKNQ2UZWXb2djx5E2zYEXDwoLLpqMGJmzjhvVCXRmnJ/QTqa2PQ6ccjLoEANJldc+fCFAjESaZudHGAk8lEaeRuq1tlUQ6EPUZ2M6h74wOn8KFa4/Qhz4ty90+sOmsP/DOtbcOFxQetqJe1GltwIGgXejKGRpeG4ekF8CEyMbcbugOXYF3IpdMBRT+QOoUO9ll9sgMRYD7cqWf5CB+Cw0h9Lanijx0mEeEP609Gqh 2025-08-04 12:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:40:04 [INFO]: item found in queue is 14409 2025-08-04 12:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB1bWDbL9/ky9Az9cAhNfnSR/UdabNc44qinLVWJtrShMDxqK6TDOHjdNlCKBxQRxieDXuw+5F77uKkAhR4niCbzACJIy+s5lPYpF65bWFX8VkYSRyq9xd05dTUT6m9fCo9k5YWZKA25vTq+ar+DKudFLfzdaIPgotKIdmAqf26P1ybeT2IZmlJLycMpJT0reGyxrQdA0JgbODfdkHppH+V4ckXYURYq3AdqzDksoP/DFT3GZMsBbIqX5sQhT0I9YNP9JhoEDg45E2zFEh1RAMFZmLR6/z7m0gXN5AlJHjGPvOBwHT6gLjeR07SNpa+lLfzdLn/Kz0KVGQbk+bq/FZQiLma7x/6PHMrxDiErk+lkAh2UWpzlzw2ar+kko0VJC/rUMWTX0JExugLgkDLhrlDzsWVlNCxqtWfma1BOd8OGU/y/rjxRiSrgQ4CqJmo91i 2025-08-04 12:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:40:04 [INFO]: item found in queue is 14409 2025-08-04 12:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEB06/JTS4WdE/mf1u33IHSRaVscF8OxmkH8+v3FqrzzwNa56lG7M+6hmpQ9f7PIZYfpczT9JAqTiGfe7H5ekRWhCNvNEaRFnJBEQ5CUH59bbluHMMBori4ZqixMOCvxW5PSLJSTBcqm2I6Tjzd7uCo+uiTI4g2WSxAqG8z+heuAu9D+Rmkl0UypSsxsDKPkyqYYMXFrfz6AgCYmP6KbiNGRo5fKuiqvxeDBf7PWwpjEAi+VDSnHOKQE9x+m6yVqyVKPU2XNybhGUBWtkDKpj5aOACuX1poXjwATTU+KS2OUaMCcdTifnZLNkuL31aCKqVLZpGeXjFmXED8uVulMjuB/FylaO+G4c42bGjg3skPepEzB1Aq/HKxzWqj8LKFULIal2lWKPnP0nMMJ8wiWCi1NOOAmFdTe4MQtSCYDFMEgdhx3H+3gQNuxLamEo49fDek 2025-08-04 12:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 12:40:04 [INFO]: item found in queue is 14409 2025-08-04 12:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBu7lLCW+uaqpCxR7DqOeMSOfVzMXkyuutqHj6b/F1geqv0cDzatzORNCR4ag/PYYw0LQrFbrRfROj4y7ZWdfMIQNZ+JCc1FiwOuuhLSnFtbAAwri7GK7bhd1U4U/UO++jpKBiUgg0r7rq8aqMZkqczIP2qmn4Lgmyu+Qj064eAxC2hS2UVdVV27AXwaobEf9m7dICoWTlvXBmcv7uWQ4nZiEDTfN8FK1JVt9D+4RS45Bq87WIygH7OVJEUWsS3am3/WlOexNtAv0V6AiFHehMHRzyr5pVpnexBNZhoeeDb6ygtpIRJdqWFJ/VDCm1nfmwkGSTOUxx6pr5iv1jhJM9jgLqeFdLKxDbeNBilHzvQWcLAFA3c6oagu+0g4+peH45pK7JlvnSkEHoQoxdHOxqtEhj3ElDHXq31EyC7giE6K3jaUk+aJ+5ceZmCmeGk/ZJ 2025-08-04 12:40:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-04 12:40:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:40:05 [INFO]: inside itemsold and closed 14409 2025-08-04 12:40:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:40:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:40:06 [INFO]: Ebay item id :: 325730982102 exists in Database 2025-08-04 12:40:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:40:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:40:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:40:06 [INFO]: inside itemsold and closed 14409 2025-08-04 12:40:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:40:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:40:08 [INFO]: Ebay item id :: 285834985798 exists in Database 2025-08-04 12:40:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:40:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:40:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:40:08 [INFO]: inside itemsold and closed 14409 2025-08-04 12:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:40:10 [INFO]: Ebay item id :: 256707434201 exists in Database 2025-08-04 12:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:40:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:40:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:40:10 [INFO]: inside itemsold and closed 14409 2025-08-04 12:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:40:12 [INFO]: Ebay item id :: 286158756826 exists in Database 2025-08-04 12:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:40:12 [INFO]: inside itemsold and closed 14409 2025-08-04 12:40:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:40:13 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:40:13 [INFO]: Ebay item id :: 326108038634 exists in Database 2025-08-04 12:40:13 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:40:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:40:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:40:13 [INFO]: in processold action queue is array for {"44644805":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644805","ebayitemid":"325730982102","shopifyproductid":"8086386114782","variants":[{"price":"55.99","quantity":0,"weight":"0.5","shopifyproductid":"8086386114782","shopifyvariantid":"44268362662110","shopifyinventoryid":"46365493297374","shopifylocationid":"","product_id":"44644805","variant_id":"77549994","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44715558":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44715558","ebayitemid":"285834985798","shopifyproductid":"8454555926750","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8454555926750","shopifyvariantid":"45291784569054","shopifyinventoryid":"47389706485982","shopifylocationid":"","product_id":"44715558","variant_id":"77623171","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776658":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776658","ebayitemid":"256707434201","shopifyproductid":"8728317690078","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8728317690078","shopifyvariantid":"46020698243294","shopifyinventoryid":"48119281516766","shopifylocationid":"","product_id":"44776658","variant_id":"77685200","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44776772":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44776772","ebayitemid":"286158756826","shopifyproductid":"8006774128862","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8006774128862","shopifyvariantid":"44127777128670","shopifyinventoryid":"46224645128414","shopifylocationid":"","product_id":"44776772","variant_id":"77685314","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44687252":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44687252","ebayitemid":"326108038634","shopifyproductid":"8457864610014","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8457864610014","shopifyvariantid":"45296328016094","shopifyinventoryid":"47394251342046","shopifylocationid":"","product_id":"44687252","variant_id":"77592477","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:40:13 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:40:13 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:40:13 [INFO]: Shopify Inventory id 46365493297374 2025-08-04 12:40:13 [INFO]: Shopify Location id 58450641063 2025-08-04 12:40:13 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:40:14Z","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 12:40:14 [INFO]: Change: available | Delta: -1 2025-08-04 12:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644805 and user_id = 14409 2025-08-04 12:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549994 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:40:14 [INFO]: Shopify Inventory id 47389706485982 2025-08-04 12:40:14 [INFO]: Shopify Location id 58450641063 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:40:14Z","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 12:40:14 [INFO]: Change: available | Delta: -1 2025-08-04 12:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44715558 and user_id = 14409 2025-08-04 12:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77623171 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:40:14 [INFO]: Shopify Inventory id 48119281516766 2025-08-04 12:40:14 [INFO]: Shopify Location id 58450641063 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:40:14Z","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 12:40:14 [INFO]: Change: available | Delta: -1 2025-08-04 12:40:14 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:40:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:40:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776658 and user_id = 14409 2025-08-04 12:40:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685200 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:40:14 [INFO]: Shopify Inventory id 46224645128414 2025-08-04 12:40:14 [INFO]: Shopify Location id 58450641063 2025-08-04 12:40:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:40:14Z","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 12:40:15 [INFO]: Change: available | Delta: -1 2025-08-04 12:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44776772 and user_id = 14409 2025-08-04 12:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685314 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:40:15 [INFO]: Shopify Inventory id 47394251342046 2025-08-04 12:40:15 [INFO]: Shopify Location id 58450641063 2025-08-04 12:40:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:40:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12:40:15Z","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 12:40:15 [INFO]: Change: available | Delta: -1 2025-08-04 12:40:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:40:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:40:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44687252 and user_id = 14409 2025-08-04 12:40:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77592477 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:40:15 [INFO]: updateIdsQuantity -> ["77549994","77623171","77685200","77685314","77592477"] 2025-08-04 12:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-04 12:40:15 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77549994 THEN 0 WHEN id = 77623171 THEN 0 WHEN id = 77685200 THEN 0 WHEN id = 77685314 THEN 0 WHEN id = 77592477 THEN 0 END, quantityflag = CASE WHEN id = 77549994 THEN 0 WHEN id = 77623171 THEN 0 WHEN id = 77685200 THEN 0 WHEN id = 77685314 THEN 0 WHEN id = 77592477 THEN 0 END WHERE user_id = 14409 AND id IN (77549994,77623171,77685200,77685314,77592477) 2025-08-04 12:40:15 [INFO]: QUANTITY Updated IDs: 77549994, 77623171, 77685200, 77685314, 77592477 2025-08-04 12:40:15 [INFO]: Successfully processed data for user 14409 2025-08-04 12:40:15 [INFO]: Execution Started 2025-08-04 12:40:15 [INFO]: Execution Finished 2025-08-04 12:50:01 [INFO]: Execution Started 2025-08-04 12:50:01 [INFO]: old server sucessfully connected 2025-08-04 12:50:01 [INFO]: sqs client sucess created 2025-08-04 12:50:02 [INFO]: Number of messages in the queue: 2 2025-08-04 12:50:02 [INFO]: item found in queue is if condition 14409 2025-08-04 12:50:02 [INFO]: item found in queue is 14409 2025-08-04 12:50:02 [INFO]: Message deleted from the queue for receipt handle: AQEB2jlm8i35l6omCYpp9QAKuYGtkvP7TPVGn0f/pJHdc1h04o1mQY2tfQsRfCGaOaVWcA1r5x+nl4YZNC+o5fkwAKmI9ecqGu42CFL+jexCrEL40ptb4Olx6feoulL0WswXSY2nGidAFXKz45JU3bQ/x7eT0YUty7ooJkVtMv0B9NYUGyry82a3i6mEmm7F1IyFkZtD3Hcem535Fohdtx3dMH44qyd9KuOcg6Et2guut8XmpupSw2k3gOZdeRnesl73YJvAHztuJXhvZ2UPLo1qC0vfDX1DTPMQ9+uIS93GDTlaQ++SPF7Ib/VsgKeGZWEkEXFeUxKFTlGqum5ghOwKwbNgwo0WRCTq8qEv/AvNVHSd9WuzELKyygRaXJRveuZGu9zWiZ8+P72j5zQIC8Qk6Pvrqb4PoH+W4Ypo2Ujx/Ti5eqrx59KUnEE5c+Z0k4T6 2025-08-04 12:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 12:50:03 [INFO]: item found in queue is 14409 2025-08-04 12:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJMLBb6UebHS2rG1Rn39ldbHw+TJpbXdEeEgv9+/gssVEhSHTSNbfMAv92L479sOoKXQz7FnViJ1arj/PRochGWLjUWHHsJu8q099vla0Z3hUXVYQJb5TOM0LFVBE5LxHCfb6jGG+O+R3IU+/iMb5jxk1uHNbAKRvgU80I/qbkufBEgzw+y4uDLFSGAmgscLIz7dPSDnI+oS+7Y2Z3BaMTU25m5X+SlF0FyU0NpKuol+Q3mtRi3xsqrPHbM+4oeMByPEVG92XTqM0hqrJTYem4FlIO1e+fh/ATOJVkciYQkqqZq4BkR6tLN8csbP/ukc8hpYmoKpbhyMuAZQwC+xBmWnc8nKj9OqBsCk0yXOt+oqJcddqmHwP0jvpfrn1rhm7BuMLO+P2/gUKYVOf/zHk/iK0l0FORobk6l4RnnG+Z1VXJ0MAjJ+2fQDuyPeNMHgo 2025-08-04 12:50:03 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 12:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 12:50:03 [INFO]: inside itemsold and closed 14409 2025-08-04 12:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:50:05 [INFO]: Ebay item id :: 226401129325 exists in Database 2025-08-04 12:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:50:05 [INFO]: inside itemsold and closed 14409 2025-08-04 12:50:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 12:50:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 12:50:07 [INFO]: Ebay item id :: 404760025969 exists in Database 2025-08-04 12:50:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 12:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 12:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 12:50:07 [INFO]: in processold action queue is array for {"44647944":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44647944","ebayitemid":"226401129325","shopifyproductid":"8124968239326","variants":[{"price":"64.99","quantity":0,"weight":"3","shopifyproductid":"8124968239326","shopifyvariantid":"44340390691038","shopifyinventoryid":"46438091882718","shopifylocationid":"","product_id":"44647944","variant_id":"77553133","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44674164":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44674164","ebayitemid":"404760025969","shopifyproductid":"8262560022750","variants":[{"price":"54.99","quantity":0,"weight":"3","shopifyproductid":"8262560022750","shopifyvariantid":"44702581719262","shopifyinventoryid":"46800546332894","shopifylocationid":"","product_id":"44674164","variant_id":"77579384","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 12:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 12:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 12:50:07 [INFO]: Shopify Inventory id 46438091882718 2025-08-04 12:50:07 [INFO]: Shopify Location id 58450641063 2025-08-04 12:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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-04 12:50:07 [INFO]: Change: available | Delta: -1 2025-08-04 12:50:07 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:50:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44647944 and user_id = 14409 2025-08-04 12:50:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77553133 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:50:07 [INFO]: Shopify Inventory id 46800546332894 2025-08-04 12:50:07 [INFO]: Shopify Location id 58450641063 2025-08-04 12:50:07 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 12:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T12: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-04 12:50:08 [INFO]: Change: available | Delta: -1 2025-08-04 12:50:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 12:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 12:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44674164 and user_id = 14409 2025-08-04 12:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77579384 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 12:50:08 [INFO]: updateIdsQuantity -> ["77553133","77579384"] 2025-08-04 12:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2 2025-08-04 12:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77553133 THEN 0 WHEN id = 77579384 THEN 0 END, quantityflag = CASE WHEN id = 77553133 THEN 0 WHEN id = 77579384 THEN 0 END WHERE user_id = 14409 AND id IN (77553133,77579384) 2025-08-04 12:50:08 [INFO]: QUANTITY Updated IDs: 77553133, 77579384 2025-08-04 12:50:08 [INFO]: Successfully processed data for user 14409 2025-08-04 12:50:08 [INFO]: Execution Started 2025-08-04 12:50:08 [INFO]: Execution Finished