2025-07-31 17:00:01 [INFO]: Execution Started
2025-07-31 17:00:01 [INFO]: old server sucessfully connected
2025-07-31 17:00:01 [INFO]: sqs client sucess created
2025-07-31 17:00:03 [INFO]: Number of messages in the queue: 4
2025-07-31 17:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:00:03 [INFO]: item found in queue is  14409
2025-07-31 17:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBw5BgCpW3RqRz3AbtYA0IHrl4QrZUpBJBVczoRrfwWH2foAx40xLoDV+a39pZOlxiTdlYxxmdnwBR0M9R6GKVfl1z3Ed9fAzvKFUyGhmJ1gTLhkjLQUDWPTwv0QRh0VLfGYmZNXS+NLxheQTubr4gif2cLQS3qeYGX+mCnEdqB/HwKahPkG9X8cVCkG+So+y6fNf7rnHALTCAsgoaDcWyDog597sOAdgIHUQCd/AAOTwOYUmaMnf+QT7bVcf0TD0FTwz/xsKAoC+vPIeJjyWgwyZOJzk9I+CclT1jrY3U0Xq8TaHxHpImjGdBDm2GDIUK/WftOj94xbRWt4kbNVq53k7E/m2JlpwImZLpP1PnYTtsYeNjRyuTyfjESg+Onk7oo00mRGLb2NJJj9m+7gaqEudaHvE0nwElwQZxJGGQLYGu6L12K3koZlaluwYzyRib
2025-07-31 17:00:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:00:03 [INFO]: item found in queue is  14409
2025-07-31 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBT9ge2iMBDk5cK41guiohDZuwoCEcJnnySZUYhokyqYAUUTl8bjrqwr99e+B97NAzkQ/tZ+aFDtMx11f2NIABgFFgkK8IJ3sY0QTz0zSmyaSKi1ADKdn66+OK3fttqFK8ARxaph7yGEWRoRjDtParjVTbJDsstAHea7RbwkeyK2a3OzvP2u9eIJS1lq7vrEOpRWPucHtGhTIalJGcjY/28xtXCM2gr/yiE2NQkCP2BnBBvhNvtl6bzFx6UR+oLERZcVr1eZziJzZZ21jXIDnSvZNkucVezBH8euQrEzlELUynBm8fXPm2LNxTwyZDbrjBdHSPeDxf5kN7ZDRNANSv10B5cB8huUeko2v0bv0jAis4Gr8JCq63ZkkM9QgTDbTKqDWWXYBwuk72XUAy6Vx/kcsYwqIHAwXorFKaVyOGlAvMfcVFQMj0HQQG4a88amte
2025-07-31 17:00:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:00:04 [INFO]: item found in queue is  14409
2025-07-31 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4xabUDDjfc0QUCJwiR6bzhJfKxM2i0vKHPsdHeNFd0oGYqnbPlseWtkE8a3TlIsHUHlCfSpF62OigvmjDR9lbSfM2u5K17IbhS4nz6xPIfkJhFAQ4sNHH1MhWC9KvG/UWloSS+DntAsff4y5nkyfiD3N5/TO648g9LFPg7iKc09W5EYnUYY3WN8/OJDRW4A0Xcjxu7TXzdH9IB4W81idVtsyx14CwopbGzbFKsk1xGVImWEGw8220gFM8d5YJ3aCsjxhZK84KMyUQSibzz7w7ljbcs80XnyJ6gZx5B7mIZtJ29dUWVzJ5Gu+UpL6pce6+twK4gixRtdJT0mXkmFeZ9AfIrcc2HvPKaQhTEM2Te9G/LmqZ1kichscPZu2/i7e5m3QpszZhH3wIsg7t+uMfN/m/mPZo6ZDAx6Gk7r5HweAyPC/y5YeDNMzdfdgnBe5
2025-07-31 17:00:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:00:04 [INFO]: item found in queue is  14409
2025-07-31 17:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/mcB6P8uaAu4E/+eUCqAGjeo1YGaClSB0OFKfk/mcItyQaqaNPUytkuz1urB0jdgA6auxKNb5VAVnK3nH1hn8WNXFagoC3JijR179j702VjiCKFueYe+4XvdEdj1x94oty5TsASkJxOuGl5Mthh3yAm3dcRaWlaBLEHF3u+NVKtO9t+RiH2cnzQ3x7FnPbYRcdQBNzrYwu3Mc28YIN3fC+XeUtLMFcRJgvhZPivxcLH9RKg7B5lWbzPXXPWUWafX7hzp3cyXdwA+c6aBPbT5fRGO4ly6PhU5C9RqU+D6WlN8SEJp8/lKeP1o0xZALBhmLZ5Vc/HSq5B8aM3//R1JNzLnvdkqjkagCNWTK2DcNzdBX9TnbLY0xFVNbMOEqOgfwVzFkj95xjIkQ/kEY79IxSSuS70qVwuGr28V3TGi7yeFJxeYDfkVmQa10sgvwerX
2025-07-31 17:00:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 17:00:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:00:04 [INFO]: inside itemsold and closed 14409
2025-07-31 17:00:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:00:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:00:06 [INFO]: Ebay item id :: 305996007274 exists in Database
2025-07-31 17:00:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:00:06 [INFO]: inside itemsold and closed 14409
2025-07-31 17:00:08 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:00:08 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:00:08 [INFO]: Ebay item id :: 404832048488 exists in Database
2025-07-31 17:00:08 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:00:08 [INFO]: inside itemsold and closed 14409
2025-07-31 17:00:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:00:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:00:10 [INFO]: Ebay item id :: 256585743026 exists in Database
2025-07-31 17:00:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:00:10 [INFO]: inside itemsold and closed 14409
2025-07-31 17:00:12 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:00:12 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:00:12 [INFO]: Ebay item id :: 286548730463 exists in Database
2025-07-31 17:00:12 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:00:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:00:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:00:12 [INFO]: in processold action queue is array    for {"44589633":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589633","ebayitemid":"305996007274","shopifyproductid":"7954869747934","variants":[{"price":"40.99","quantity":0,"weight":"2","shopifyproductid":"7954869747934","shopifyvariantid":"43994296352990","shopifyinventoryid":"46090814783710","shopifylocationid":"","product_id":"44589633","variant_id":"77482342","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44771814":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44771814","ebayitemid":"404832048488","shopifyproductid":"8303431123166","variants":[{"price":"99.99","quantity":0,"weight":"2","shopifyproductid":"8303431123166","shopifyvariantid":"44852140441822","shopifyinventoryid":"46950184779998","shopifylocationid":"","product_id":"44771814","variant_id":"77680356","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44716272":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44716272","ebayitemid":"256585743026","shopifyproductid":"8695095623902","variants":[{"price":"333.99","quantity":0,"weight":"2","shopifyproductid":"8695095623902","shopifyvariantid":"45933948960990","shopifyinventoryid":"48032400343262","shopifylocationid":"","product_id":"44716272","variant_id":"77623887","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44856248":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44856248","ebayitemid":"286548730463","shopifyproductid":"8927161581790","variants":[{"price":"79.99","quantity":0,"weight":"2","shopifyproductid":"8927161581790","shopifyvariantid":"46846436311262","shopifyinventoryid":"48957657219294","shopifylocationid":"58450641063","product_id":"44856248","variant_id":"77767207","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:00:12 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:00:12 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:00:12 [INFO]: Shopify Inventory id 46090814783710
2025-07-31 17:00:12 [INFO]: Shopify Location id 58450641063
2025-07-31 17:00:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:00:12Z","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-07-31 17:00:12 [INFO]: Change: available | Delta: -1
2025-07-31 17:00:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589633 and user_id = 14409 
2025-07-31 17:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482342 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:00:12 [INFO]: Shopify Inventory id 46950184779998
2025-07-31 17:00:12 [INFO]: Shopify Location id 58450641063
2025-07-31 17:00:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:00:12Z","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-07-31 17:00:13 [INFO]: Change: available | Delta: -1
2025-07-31 17:00:13 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44771814 and user_id = 14409 
2025-07-31 17:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680356 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:00:13 [INFO]: Shopify Inventory id 48032400343262
2025-07-31 17:00:13 [INFO]: Shopify Location id 58450641063
2025-07-31 17:00:13 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17: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-07-31 17:00:13 [INFO]: Change: available | Delta: -1
2025-07-31 17:00:13 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44716272 and user_id = 14409 
2025-07-31 17:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77623887 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:00:13 [INFO]: Shopify Inventory id 48957657219294
2025-07-31 17:00:13 [INFO]: Shopify Location id 58450641063
2025-07-31 17:00:13 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:00:13 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17: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-07-31 17:00:13 [INFO]: Change: available | Delta: -2
2025-07-31 17:00:13 [INFO]: Change: on_hand | Delta: -2
2025-07-31 17:00:13 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:00:13 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44856248 and user_id = 14409 
2025-07-31 17:00:13 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77767207 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:00:13 [INFO]: updateIdsQuantity -> ["77482342","77680356","77623887","77767207"]
2025-07-31 17:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 4. Affected rows: 4
2025-07-31 17:00:13 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77482342 THEN 0 WHEN id = 77680356 THEN 0 WHEN id = 77623887 THEN 0 WHEN id = 77767207 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77482342 THEN 0 WHEN id = 77680356 THEN 0 WHEN id = 77623887 THEN 0 WHEN id = 77767207 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77482342,77680356,77623887,77767207)
2025-07-31 17:00:13 [INFO]: QUANTITY Updated IDs: 77482342, 77680356, 77623887, 77767207
2025-07-31 17:00:13 [INFO]: Successfully processed data for user 14409
2025-07-31 17:00:13 [INFO]: Execution Started
2025-07-31 17:00:13 [INFO]: Execution Finished
2025-07-31 17:10:01 [INFO]: Execution Started
2025-07-31 17:10:01 [INFO]: old server sucessfully connected
2025-07-31 17:10:01 [INFO]: sqs client sucess created
2025-07-31 17:10:02 [INFO]: Number of messages in the queue: 7
2025-07-31 17:10:02 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:02 [INFO]: item found in queue is  14409
2025-07-31 17:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBIwWSpDjN7U+t7I6DoTLigyErvuCTOEilvEbXGz2KtMAXKWQuEgyhxa9OgryIU91T1gfgoUqyxhEtiSG03///EbhcX6z3lWlD0nd/eYT6saSqBd0xTylpHMa8V6/6wLDreT/zX7yvMWRqm6ci0CgPmHpDFxigSF87fclsuWmXdTl7S8lcvwAAMc6nFOP0nvC2K+157wXQphDZlBmn91C3d4Jh48dWzNw924f+UjA/afityYAadbfmX5oYDn6ffjJFBRE2ZSdb4z3VVtR2sHVGNZ5L9+DsJBIRaGdwJ3nNwJ6CZug6mty3dvJ5yZtqVNP6ignyNDv6nlCUBBlIGWR7H6R6InrCzNFjKmY6Ms7OeTW53SgYYd7rBXpKDXbmTHk/pkdkVU8A0jK9FvsYl08bB1gOAj6fSPFmM1PcJV49x1PPkkdHnpHvECcAEihPIa+q
2025-07-31 17:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:03 [INFO]: item found in queue is  14409
2025-07-31 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBmjxJwxbWR+LirjiWXHi8lxzei6hY2J/Gxpnfdnf1svBmaVrVKcc+/tJBI0msEJK+md4qIB4bq5nsIxjeUT0UopIY6XUNItjRgg/YlmOMFSJeC9Sph60fUlnd7Vw2kbkraLZpK0dkS3tBh9RGTQezvcPKt7UTCInv2+jVZXSEuvQsCqLFNNQgkScnVTuYiQ1RixvSyZInKw6PBoVFgv9Jns84Ue5zTWr+nj7d8tGs9iRPpE6bn6efCYxYbDh5bAAKLOqn7J38TxRj0hofs4zGvfwbcaeuM41YNuV0UiYF0JzG29su7e42WYo61e+RlrWuRAR5IrdwP7iohaZQZbUYrDTP0ssNrCukbGR53T7XUAusb4c+sO2yWXSi79KEM3RWxRGcr2oOuuNDdk9I/2CU2djsB9gqo0vHRObDz8ovjyAPZWJOGwMNJ89555thNYJ7
2025-07-31 17:10:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:03 [INFO]: item found in queue is  14409
2025-07-31 17:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBlGdcQTPTnEnB9ULvz5eVXkoAygNp8cvCJQId+HfjZJr78F8BeeAM7JBoV/1Xv5GF6AzIeL0fxkO1EOgCRC5QMOCbsHxVAmul0AE9+ls2Ktv5AhnihNZ0HTHfwfcFRqzcZ6UwxXv7deRVRTdnSMi1OVc+Sbm4TkJdGX6VCkWXj/C1TB1DmAvZlXFeWnZCOhB1d/cAH5ZbLscjlV2aK40g7Tbi0Nu2Hep3l/aFNPkNVKXjaJIW+Q8TgBQR0DCjjpq4iIXy3+3hoh1cP1T368MBzOdH6qCRl26ZsbQOPC/ZYKbyptaOgbzMAldRq9gm4X1Au6s0ALxiVmsCkueYmnRJzW1Ro8sWwHRTP+dknhSHuOwknzEi0Vg/uWyN0mPgaLBvOO7MbXtFWrwh9bET+zVGpJqbA3+tZbfvqQQ+OkvFX15FbqmoY6YF20JmKDurE31C
2025-07-31 17:10:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:04 [INFO]: item found in queue is  14409
2025-07-31 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBi3pjlDqhVYklwBIFc7V3dAX/zW8mXBfJhalBcAveQ1rm/4PjzO20vxqoGsz/x9fvxWv2sh4TJq8fH18q38OFp1zJXWMnMAXh5Xf1UkFO/Tdp0Q9sY+q8AYXDrEiASqM0FVWRQsOsVPlj4tPhaY9XbuxSdRGYBoOKaZSjyYluB7RmW7X1b+uH5vVGD0uK69Z5Dnv5+yRixcwylaKM/7GO1IWTRSi5KxHtBouO0gsA/ilWv4VmQ7BHzcw0hN+5azxZZ1yi0+FD3Bar+CJbMNLZq9Y9j7LRxpCh5ozN5njiMhCCT6e4ed1RtF/QnqkN1tPj+wXImpjW6CW1kcp06Xv+d7tDR+q1z0dm8Ha1NRihGsVL6FeBa/tY+YKNvrqAbbDZkkJjpUgiDGGYC92WaxkMPNbRLDytSTIo0Zt8kdm+DsTx7kvvPETbXBesarHsG536
2025-07-31 17:10:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:04 [INFO]: item found in queue is  14409
2025-07-31 17:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBkubJ55aZ1BAS5CgDZBRq+k/YSEXmCWk2+7b13Q5v1EbAHJjXsoQ7z/J6w+OodDpUxKf2lnyxaXNgl19z2TtxNsXbeZwsxnF3CCzoflInuBJZ0oNdfiox9mW1/PeYGoG1alq9cqfeS3suYKvfFjBwEMiDFrqE0otv5Yt3Rgv7P6+OXMjybaRfd2aqGzXu1so5ub2J7qQGFORGrnHRY0+pOexm3RIH4zkA1GhM+3m1tjip+QncrITsMGk1hh0ZIrAtG4k97t/sY43CRo+MdqD0NJPNvpsRUhe8gz3sJkszF7ozPg7xf7gVYfikeb0p4Z2Jg1W5LNMSAAG3ddkAAxuT5BzxxP/Hy06UILvJsd+BKqevD2L64s3f4uPivEAqz2k6XAkGQEo1tJjBGL1NEomSxk9+JA+7I3i6HYCyWAEUeSZkg4AbYnC/xmOfxg5gwsWh
2025-07-31 17:10:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:04 [INFO]: item found in queue is  14409
2025-07-31 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBSBTisLmasGoTSpRl+o8fxqL7z0c3vvCkSOQXFvObKcKzqAWGu1jdtjUanZq8mb9TNdwzGS94sLVvSy85wJ/JYu8U9gvg8tQf2bHxLMYUBzuYFaXCW5mccmHuWDTataMO2wyb9a89U2u99ziZwpGrHrjoGtlCouPPyjMhVkqXP1nOpjNAHGDRCXJolp9QGKdDPnNMCNLiEriaiUxb0Rrw+G3vOE58d1d3cFaKkUdPDdkHmmUj7h9DWeoceiBB9Nz7eg3mehweTiiGEYoh+ezW9wcQ5TI+1i+/F8Nh9PnMisFtpj0RqM3E5SC/dx5H5ZJCDI3Mej1pZvSGX/uJpTVMZT+w1XMX/czzVpSHWCVx8AAeFWvX07jVkM3hpjYZXVol7Y0QzP+HOMWQ+tp9ZJ6woQC7w0k1v4JesPPRnkaIHhC2zwXV46uldYK1sjoZitjs
2025-07-31 17:10:05 [INFO]: item found in queue is if condition  14409
2025-07-31 17:10:05 [INFO]: item found in queue is  14409
2025-07-31 17:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBbHk0NzOwfF9mnUQBoNGe8GFAeZT9U0S93MxkjK8HPcd5U2z8m2VyFgkp9Nr4JJPgjJtMNDswZedqNxccNw86iFa2PodwivUxX/DH+xgKx9JeoItLz87Et+zB4c0c1qaCEHCtkUEBM+xqaYhnVIkaL8EU9lsQqMFBgNIcatKDiNobeJ686SkJvi+USqPDNgkzqmZ51w8vL7/Yt8P8goTSo6KPZmLM9W8h4kO59thuZum1Xcu0Oi4Zpv/AUmfa+TWbWOmxBTHnngwa15rBe5g+5gABg5hSQ5s23yjqYvhVqdwVwjrLZjYxoEi1pHZ6tFXjwvl2UF+D6h80W2NxBGjpaPco+VPb1MVje3d8KIBVU4t1FMIBhg01Ndmyjs3ePKRzAX9+SS2+o014ff++K9HHdXfKMzL0VeAUBUQTgx21ccr1fFd9lKaYrrFWoJ38Zijf
2025-07-31 17:10:05 [INFO]: Processed 7 messages, reached the limit of 7.
2025-07-31 17:10:05 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:10:05 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:07 [INFO]: Ebay item id :: 404843067921 exists in Database
2025-07-31 17:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:07 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:09 [INFO]: Ebay item id :: 286230746552 exists in Database
2025-07-31 17:10:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:09 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:10 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:10 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:10 [INFO]: Ebay item id :: 335688884362 exists in Database
2025-07-31 17:10:10 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:10 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:12 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:12 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:12 [INFO]: Ebay item id :: 226101136400 exists in Database
2025-07-31 17:10:12 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:12 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:14 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:14 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:14 [INFO]: Ebay item id :: 404843131614 exists in Database
2025-07-31 17:10:14 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:14 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:15 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:15 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:15 [INFO]: Ebay item id :: 405681035854 exists in Database
2025-07-31 17:10:15 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:15 [INFO]: inside itemsold and closed 14409
2025-07-31 17:10:17 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:10:17 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:10:17 [INFO]: Ebay item id :: 335744507915 exists in Database
2025-07-31 17:10:17 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:10:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:10:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:10:17 [INFO]: in processold action queue is array    for {"44772001":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772001","ebayitemid":"404843067921","shopifyproductid":"8305861132510","variants":[{"price":"255.99","quantity":0,"weight":"2","shopifyproductid":"8305861132510","shopifyvariantid":"44860814098654","shopifyinventoryid":"46958863548638","shopifylocationid":"","product_id":"44772001","variant_id":"77680543","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44589615":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589615","ebayitemid":"286230746552","shopifyproductid":"7945977528542","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"7945977528542","shopifyvariantid":"43963545583838","shopifyinventoryid":"46060004049118","shopifylocationid":"","product_id":"44589615","variant_id":"77482324","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44638611":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638611","ebayitemid":"335688884362","shopifyproductid":"8743980204254","variants":[{"price":"24.99","quantity":0,"weight":"2","shopifyproductid":"8743980204254","shopifyvariantid":"46095858008286","shopifyinventoryid":"48194669510878","shopifylocationid":"","product_id":"44638611","variant_id":"77543800","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44659110":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44659110","ebayitemid":"226101136400","shopifyproductid":"8422992740574","variants":[{"price":"14.99","quantity":0,"weight":"0.5","shopifyproductid":"8422992740574","shopifyvariantid":"45227128881374","shopifyinventoryid":"47325040214238","shopifylocationid":"","product_id":"44659110","variant_id":"77564330","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44772005":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44772005","ebayitemid":"404843131614","shopifyproductid":"8306621513950","variants":[{"price":"53.99","quantity":0,"weight":"2","shopifyproductid":"8306621513950","shopifyvariantid":"44861610262750","shopifyinventoryid":"46959660171486","shopifylocationid":"","product_id":"44772005","variant_id":"77680547","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44664440":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44664440","ebayitemid":"405681035854","shopifyproductid":"8850135056606","variants":[{"price":"21.99","quantity":0,"weight":"0.75","shopifyproductid":"8850135056606","shopifyvariantid":"46466185625822","shopifyinventoryid":"48568128110814","shopifylocationid":"","product_id":"44664440","variant_id":"77569660","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44589627":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589627","ebayitemid":"335744507915","shopifyproductid":"8016370008286","variants":[{"price":"32.99","quantity":0,"weight":"2","shopifyproductid":"8016370008286","shopifyvariantid":"44144735879390","shopifyinventoryid":"46241639891166","shopifylocationid":"","product_id":"44589627","variant_id":"77482336","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:10:17 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:10:17 [INFO]: Shopify Inventory id 46958863548638
2025-07-31 17:10:17 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:17 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:18Z","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-07-31 17:10:18 [INFO]: Change: available | Delta: -1
2025-07-31 17:10:18 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772001 and user_id = 14409 
2025-07-31 17:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680543 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:18 [INFO]: Shopify Inventory id 46060004049118
2025-07-31 17:10:18 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:18Z","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-07-31 17:10:18 [INFO]: Change: available | Delta: -1
2025-07-31 17:10:18 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589615 and user_id = 14409 
2025-07-31 17:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482324 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:18 [INFO]: Shopify Inventory id 48194669510878
2025-07-31 17:10:18 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:18Z","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-07-31 17:10:18 [INFO]: Change: available | Delta: -1
2025-07-31 17:10:18 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638611 and user_id = 14409 
2025-07-31 17:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77543800 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:18 [INFO]: Shopify Inventory id 47325040214238
2025-07-31 17:10:18 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:18 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-07-31 17:10:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44659110 and user_id = 14409 
2025-07-31 17:10:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77564330 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:19 [INFO]: Shopify Inventory id 46959660171486
2025-07-31 17:10:19 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:19Z","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-07-31 17:10:19 [INFO]: Change: available | Delta: -1
2025-07-31 17:10:19 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:10:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44772005 and user_id = 14409 
2025-07-31 17:10:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77680547 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:19 [INFO]: Shopify Inventory id 48568128110814
2025-07-31 17:10:19 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:19Z","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-07-31 17:10:19 [INFO]: Change: available | Delta: 1
2025-07-31 17:10:19 [INFO]: Change: on_hand | Delta: 1
2025-07-31 17:10:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44664440 and user_id = 14409 
2025-07-31 17:10:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77569660 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:19 [INFO]: Shopify Inventory id 46241639891166
2025-07-31 17:10:19 [INFO]: Shopify Location id 58450641063
2025-07-31 17:10:19 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:10:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:10:19Z","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-07-31 17:10:20 [INFO]: Change: available | Delta: -1
2025-07-31 17:10:20 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:10:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:10:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589627 and user_id = 14409 
2025-07-31 17:10:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482336 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:10:20 [INFO]: updateIdsQuantity -> ["77680543","77482324","77543800","77564330","77680547","77569660","77482336"]
2025-07-31 17:10:20 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 7. Affected rows: 7
2025-07-31 17:10:20 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77680543 THEN 0 WHEN id = 77482324 THEN 0 WHEN id = 77543800 THEN 0 WHEN id = 77564330 THEN 0 WHEN id = 77680547 THEN 0 WHEN id = 77569660 THEN 0 WHEN id = 77482336 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77680543 THEN 0 WHEN id = 77482324 THEN 0 WHEN id = 77543800 THEN 0 WHEN id = 77564330 THEN 0 WHEN id = 77680547 THEN 0 WHEN id = 77569660 THEN 0 WHEN id = 77482336 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77680543,77482324,77543800,77564330,77680547,77569660,77482336)
2025-07-31 17:10:20 [INFO]: QUANTITY Updated IDs: 77680543, 77482324, 77543800, 77564330, 77680547, 77569660, 77482336
2025-07-31 17:10:20 [INFO]: Successfully processed data for user 14409
2025-07-31 17:10:20 [INFO]: Execution Started
2025-07-31 17:10:20 [INFO]: Execution Finished
2025-07-31 17:20:01 [INFO]: Execution Started
2025-07-31 17:20:01 [INFO]: old server sucessfully connected
2025-07-31 17:20:01 [INFO]: sqs client sucess created
2025-07-31 17:20:02 [INFO]: Number of messages in the queue: 2
2025-07-31 17:20:02 [INFO]: item found in queue is if condition  14409
2025-07-31 17:20:02 [INFO]: item found in queue is  14409
2025-07-31 17:20:02 [INFO]: Message deleted from the queue for receipt handle: AQEBhwywGuYVgvihPKgq1j3JXKLK6Xy68SyI3nlizk4xGJTphZaD/CH2JS3zB3xkKyByuhIW8d01Doxtx0e0JNS6NIHFA6QW7oiguVUJ0Q51z4VuPAUtf3+rncecfsXZHuWVU5HmZFEI30/a504u4ZGppT3wteLDXCqxlKefu72IldSQzfxjWOxinjQ87PjjgB67lO5dpCSF0/cP282sN8FPhIrGspEGfjJMcZuY25QWc7nl9hOu0d/0Gbm92jc79yvUjvncSzW8HrXTwhQpZJmzJcblgNEl0IPtddfEbnZyt+kNejQGRSNAqrtVUlDCEvBvzPaNrLeG8bwxUucVtyN5x9gZKcf2noBPp8YBB756LZ8E9wt8oWfipwKS6+vrh/R52LRLysoQa5XKLTLOq4NhOwqI0HnwYSe8QATs+LE6GiwVrYlbXZ9iuHY12YOOodI+
2025-07-31 17:20:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:20:03 [INFO]: item found in queue is  14409
2025-07-31 17:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEB7SLMUBIClSgwgGqaBMJtdugLqjIjn4i1M7aVGGNUmxQyL8f66bzHod1bSSEIY2A5ianceuZaQ68YHlCl+3Kfjj4oOW06Fki12L4QVcOw0ZmclOn14T/tsvkXG5er+9iJWzeNySwuUd4n443hvs4/W5p+dB28H8LtTCUJNOSS8vxQ+zutvUUzMVlRL0w511E86C/tGq2lL+8wMwRGlo+tg8fl3lMhC58DGfBFOWk6qDJXt/vFFvqcz9TwMuRKSr9lm7JAhxsfvLH/U9FOo42+f8zw+VQAeUio9JzmSkhqSm6VRd7mszxg34Itm5qVy7HbVsXXrEnluVHSbMuRCU6iLjWn3qAIvnAdHb22Epo4FFylxLjwwhqhh8H7o/IWbnA6ywQ8KluWfsj8LrLgOMGYmceWKvU3gKjxH6BlEbsfiN2h7F18suzNg4kZ2mzrlgTP
2025-07-31 17:20:03 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 17:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:20:03 [INFO]: inside itemsold and closed 14409
2025-07-31 17:20:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:20:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:20:05 [INFO]: Ebay item id :: 305980761980 exists in Database
2025-07-31 17:20:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:20:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:20:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:20:05 [INFO]: inside itemsold and closed 14409
2025-07-31 17:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:20:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:20:06 [INFO]: Ebay item id :: 286606905155 exists in Database
2025-07-31 17:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:20:06 [INFO]: in processold action queue is array    for {"44577405":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577405","ebayitemid":"305980761980","shopifyproductid":"8767216058590","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8767216058590","shopifyvariantid":"46160375185630","shopifyinventoryid":"48259718152414","shopifylocationid":"","product_id":"44577405","variant_id":"77470112","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44905737":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44905737","ebayitemid":"286606905155","shopifyproductid":"8940753387742","variants":[{"price":"189.05","quantity":0,"weight":"1","shopifyproductid":"8940753387742","shopifyvariantid":"47001559859422","shopifyinventoryid":"49112759959774","shopifylocationid":"58450641063","product_id":"44905737","variant_id":"77823545","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:20:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:20:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:20:07 [INFO]: Shopify Inventory id 48259718152414
2025-07-31 17:20:07 [INFO]: Shopify Location id 58450641063
2025-07-31 17:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:20:07Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-07-31 17:20:07 [INFO]: Change: available | Delta: -1
2025-07-31 17:20:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577405 and user_id = 14409 
2025-07-31 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77470112 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:20:07 [INFO]: Shopify Inventory id 49112759959774
2025-07-31 17:20:07 [INFO]: Shopify Location id 58450641063
2025-07-31 17:20:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:20:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-07-31 17:20:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:20:07 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44905737 and user_id = 14409 
2025-07-31 17:20:07 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77823545 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:20:07 [INFO]: updateIdsQuantity -> ["77470112","77823545"]
2025-07-31 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 17:20:07 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77470112 THEN 0 WHEN id = 77823545 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77470112 THEN 0 WHEN id = 77823545 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77470112,77823545)
2025-07-31 17:20:07 [INFO]: QUANTITY Updated IDs: 77470112, 77823545
2025-07-31 17:20:07 [INFO]: Successfully processed data for user 14409
2025-07-31 17:20:07 [INFO]: Execution Started
2025-07-31 17:20:07 [INFO]: Execution Finished
2025-07-31 17:30:01 [INFO]: Execution Started
2025-07-31 17:30:01 [INFO]: old server sucessfully connected
2025-07-31 17:30:01 [INFO]: sqs client sucess created
2025-07-31 17:30:02 [INFO]: Number of messages in the queue: 4
2025-07-31 17:30:02 [INFO]: item found in queue is if condition  14409
2025-07-31 17:30:02 [INFO]: item found in queue is  14409
2025-07-31 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBVGm0Irec6Vof+lG5mqn7fK8nmwbl4qkjpzcDVm8RTy9P+EOmJfagSO9WAPtiW4FMa/fSEYypSw17grzHdic24XK4pqe86bVYxJoMhW8ljN2TWo3hzGNoOjV4DfwmPpp8sARv4dDvRtzwylrrCaV33YbBxSyDVxQff0pgNNH8nwGcSonc+JPGp7mLndpozUYVSD4b8ncoeZgtCkAMKylXc0HYBJ/jRH0ychJNn28uWkWgshQ8+YDLHYALtpMJouN4wasyQ1/kccivCdCLnko4SUKNbEtNmRYWx+0Jx+FOZ1UwDN6ahXneFDcsrybiuXbydldsHyueCvSMaV5VoCfzb+5wjd4awL2zk431S7Fzrafv2NXvmd4e4J3S41THKrIC/Qmx/TGQxzr7tottzyX7XL15SeSJyEHen7qNfUghnva1MbuPinTSYphI9ynTBs4C
2025-07-31 17:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:30:03 [INFO]: item found in queue is  14409
2025-07-31 17:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEB0Zx4USO6MD2dTWOAWOQ5fg5y6JKBAM/W1jC0Xel7ULzbtLozapw7sbntfK1Ae7QoQl0Yym4PFnIY0QT4g4zmh5g3JzZG2rGrJVxqVrugsLwooRJplX5OylcgMySecLI+CPSHaCVr+ATObxHpcArgi4aEh7/cPMdll6UvJ87zXjsI9N56fSJbJ88/O7PSOemLFW6NvXkVHJItp/p8+5HG5icNCYnAdiYxNhC7LMKTWKjpDNtSIBLDDBKXCyb95Gw8tJ1/KdxyOfRo9f4pxjQVebSN5wP5eIFvavCnLkXzn1/PTSDCMlvXTboe/MAC9bIaXHhud5/vWZ6rPrye+9UbZRsu1zVdKQ/l5zgOb8D6L/901LOVGwiUjrRoylyuJ9IIqA9pSoztJeOdX1nDk11hEKyGePGG2AhO6YurQfbrI2V7RCSskeITocV1Y8qZji/n
2025-07-31 17:30:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:30:03 [INFO]: item found in queue is  14409
2025-07-31 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBGcecuyunqDplZA6UsgxddBwdUNqfQkST4O4tc06M3+Tju+JWXDef3w5BTXpTRDKhmfYSMz1ajHH3q+2rYBmlFf/GjqULmVfNWkSvuDVnYRtZgqc0AZaxT/CIdfY3seuP81JCL84R4PB+/XnlxdaimXnvIaK0iIblb86c/B5TZ14W/I+sx6DSSOQ/1RbpyN9ZOSDZcs7lNT8bgPRCmp9IJqDQoxkFtUNy7coM4qs8e1jBbiZob+wmx0ONScD7mQUqQyCmdYgP6uMqC0r5Yx8FsGd2/n0zTUjdhDVtbhI3JvaqDqOApcAv5wQkDMr7M0NM4dtA14D5MHPQR3Z7162th0tg3GUPwDvJquH20zQl/kuiIVt88nR1zakUZWZ03rnbjSMm2fsz4GZrQW0Nx5PGyVJugBOmPXF6bshLF813XcjBj3VPU/lcSSz1ChWAIHo5
2025-07-31 17:30:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:30:04 [INFO]: item found in queue is  14409
2025-07-31 17:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBh4lKcw8+U98Ln4bfAbfWIY8PoP5Iysh1bYQHoUuJ5765ANpPeaXhItS9A1jYfRGvq59iBQqjiSNLIS3sYfRt0f7yen3JH6gPaxZXPekiSK1whvyS0VIMw8/lXP3QJsS7kCZu8gEIs42EDoi5TpdX0MGYKSKaIesO0T+vARp0XUuemqL5LehuiqBcvIGCtCJ1xlqhG/ji1/eqo9QPuHoFYjgGeK8csu6uLdaSEtRV7AVGV1mclfb4KXsDD7mmyy2mZG2DEb60A2cXHepRb3voe2etdV2YuNmSVgcY4BdtntR0jAz7dEd/blMNXDxhOOFOCgfGbZqSzeMBP1SJP4HBJ/RgQ3GTBRcJojTG2u25/efCaC/j4QV/7ffXDF5XV3pWg2oNDdNwe8qMl9vJ2X1jT1AsFUHZPOUoNCgW+PKbtdLU/R4h57uQ+b2Bm2s3Wff4
2025-07-31 17:30:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 17:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:30:04 [INFO]: inside itemsold and closed 14409
2025-07-31 17:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:30:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:30:06 [INFO]: Ebay item id :: 305980551563 exists in Database
2025-07-31 17:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:30:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:30:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:30:06 [INFO]: inside itemsold and closed 14409
2025-07-31 17:30:08 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:30:08 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:30:08 [INFO]: Ebay item id :: 285873612291 exists in Database
2025-07-31 17:30:08 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:30:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:30:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:30:08 [INFO]: inside itemsold and closed 14409
2025-07-31 17:30:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:30:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:30:09 [INFO]: not in db for user_id 14409 and the ebayitemid286739965840
2025-07-31 17:30:09 [INFO]: inside itemsold and closed 14409
2025-07-31 17:30:11 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:30:11 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:30:11 [INFO]: Ebay item id :: 326570671032 exists in Database
2025-07-31 17:30:11 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:30:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:30:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:30:11 [INFO]: in processold action queue is array    for {"44577196":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577196","ebayitemid":"305980551563","shopifyproductid":"8766867931358","variants":[{"price":"30.99","quantity":0,"weight":"2","shopifyproductid":"8766867931358","shopifyvariantid":"46159752823006","shopifyinventoryid":"48259093168350","shopifylocationid":"","product_id":"44577196","variant_id":"77469903","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44587925":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587925","ebayitemid":"285873612291","shopifyproductid":"8504194990302","variants":[{"price":"9.99","quantity":0,"weight":"0.75","shopifyproductid":"8504194990302","shopifyvariantid":"45414972260574","shopifyinventoryid":"47512949522654","shopifylocationid":"","product_id":"44587925","variant_id":"77480634","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44737966":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44737966","ebayitemid":"326570671032","shopifyproductid":"8918115352798","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"8918115352798","shopifyvariantid":"46733313999070","shopifyinventoryid":"48831801262302","shopifylocationid":"58450641063","product_id":"44737966","variant_id":"77645903","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:30:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:30:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:30:11 [INFO]: Shopify Inventory id 48259093168350
2025-07-31 17:30:11 [INFO]: Shopify Location id 58450641063
2025-07-31 17:30:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:30:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17: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-07-31 17:30:11 [INFO]: Change: available | Delta: -1
2025-07-31 17:30:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:30:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:30:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577196 and user_id = 14409 
2025-07-31 17:30:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469903 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:30:11 [INFO]: Shopify Inventory id 47512949522654
2025-07-31 17:30:11 [INFO]: Shopify Location id 58450641063
2025-07-31 17:30:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}}
2025-07-31 17:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587925 and user_id = 14409 
2025-07-31 17:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480634 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:30:12 [INFO]: Shopify Inventory id 48831801262302
2025-07-31 17:30:12 [INFO]: Shopify Location id 58450641063
2025-07-31 17:30:12 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:30:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:30:12Z","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-07-31 17:30:12 [INFO]: Change: available | Delta: 1
2025-07-31 17:30:12 [INFO]: Change: on_hand | Delta: 1
2025-07-31 17:30:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:30:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44737966 and user_id = 14409 
2025-07-31 17:30:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77645903 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:30:12 [INFO]: updateIdsQuantity -> ["77469903","77480634","77645903"]
2025-07-31 17:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-07-31 17:30:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77469903 THEN 0 WHEN id = 77480634 THEN 0 WHEN id = 77645903 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77469903 THEN 0 WHEN id = 77480634 THEN 0 WHEN id = 77645903 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77469903,77480634,77645903)
2025-07-31 17:30:12 [INFO]: QUANTITY Updated IDs: 77469903, 77480634, 77645903
2025-07-31 17:30:12 [INFO]: Successfully processed data for user 14409
2025-07-31 17:30:12 [INFO]: Execution Started
2025-07-31 17:30:12 [INFO]: Execution Finished
2025-07-31 17:40:01 [INFO]: Execution Started
2025-07-31 17:40:01 [INFO]: old server sucessfully connected
2025-07-31 17:40:01 [INFO]: sqs client sucess created
2025-07-31 17:40:02 [INFO]: Number of messages in the queue: 4
2025-07-31 17:40:02 [INFO]: item found in queue is if condition  14409
2025-07-31 17:40:02 [INFO]: item found in queue is  14409
2025-07-31 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBLdkVBK0vMURuot6K1JyR35f9/tdVJ4zgnh1mqWVdvnkOdP7Xe3lTXIUXt/4HJNL6mCBtpZI15MSZz+eEjcWZ+uq9G7P0vVV5y28TxJEzXf7u/R1PEx7gPNpi1ZAfiuok/RoCdIGP8t96jNS9mnVyOoFYH94CCjP4Oge4kV7LoUVD2iI3h2JJJgsaRYKTyMxGGhkpzUGDealxZzL0SqjQt/SkiYToQ5cYUidpectLK/50HV+slxnP5pSp7KBUAQAqmYWHALueO0/rDKzUMlK+4j9KAPHuvjhlF8LgRSCTR27KUs5LqIyOx5OJSVENDXYJ1tSQa+TfhXzv7SjM1aMiRRJHDuCHza/tfgch11sjVvWPOTFxxIBnIcFRzObXiNdYDwjG70r03VbelDxN+lmjwqu1R5OONpgxNHlt8+G4SyaPy8lOhuTAraNKMnSIDl5w
2025-07-31 17:40:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:40:03 [INFO]: item found in queue is  14409
2025-07-31 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBd0sNgUSEL80BvhlbFVRvxAAI7b3OzqHEO1pw+hVgb2nLeGPIYHLNJ2zGsTADmKIN4kzLAZtMH4Bnk1fpFDoGyOyGOuwLkql3RaMdkVyXi+Ayv2DtRcl1UMaEBuV+zA529N66zBY70abOKUfiD6mYG3/6fIKlb2AfLTQuuRmQWbuUc0Gyy6qQu/k//od8XqsymBFNMsTEy+uPSMKxGk9xZUftaXbZizZ423ySPhiZC5fG8EsdBeuKhp+zXacCWg8r5Kbi8waN/coYW8GhqPU2hNCVx6MeFtvCbURwpOTg1WnItY2bHyo8yXtG45/bDkysuNDuRx/82mKuA6QvKT7P2ocy7SC8Nuj25EE+G2ia9uaMvlIlKNJjApruerxq4y9FoP71K4WJec2Kq9Uk1JFWKUGYOK9jFqOeEspf401EvTfWitB2hf1u4z9D4j6Q9GJN
2025-07-31 17:40:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:40:03 [INFO]: item found in queue is  14409
2025-07-31 17:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBnn71wI3Zhxliij+1iSbDQ1JsNgR17Y8WZvRhB4P+YzzLUJZiK4IoZCtAGUWDYRFmB90K11Uj60aZmMuoWz3MWppE1TNljxysOqgTkkU+C3LP3cFlHAqpWXr4+yDdTuPddBZJBkzx0xn6RGE3JwJzsODDTYEzm2JPhqt2gqVJUNugR7nuSpPyJGflbqrx3NctouqpfMXiYsMrn2mCi1Lbgbvom3sO6ZxfzMrE3pheBC2ANPPNJyeTbTGbNaCH1vUk4ky/MQcTDrpkyi+stc7dSImqt3FvDBNb4H05x54EQzVZfDT38rUa+t5B/UjyrXmTcxnGltL6XWMjPGJ9aVqyfjB3J1vgEJXJwYVdN5+2DwaABNe8gXJBF1LAlr3ooEe/fOsDC3m17ooZxA9YpsHaq7dmRsyolDcqPX9PzdQBkAQCRJ1JzyuthzKWrvXR/GHs
2025-07-31 17:40:04 [INFO]: item found in queue is if condition  14409
2025-07-31 17:40:04 [INFO]: item found in queue is  14409
2025-07-31 17:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBSp2Noqd3lRo2m2OPL58EG+N5WR1EJYRZfCs7aqoqaOVTISYYHFFGgH83z84g1yvqVDRg1T7rmKkp7hpZr3gQjpRhysS3WTQ2rKPMQwdPZBM8sEsdqcE8RE02Ftyg8VyOjVYT+pWkhL+YQ18EDkknelyoAjoLFpXxuDueDM8N4am46oieIwnoWkKkSz9ZMHibGNZW6c7nbRwRLEivvLHDsUNf7GMQ+dZddrEnTyJhqtFCXdS1RwaW5Yp3LQBdRbcaJfS7fTeOV/9cGxLH+Fb5NpJ+3CmdOkxWCaT1uZKnYRoy1hhNaBbWaSLKTZg+e4TmE3drdKaLh6rjdhV65r0nLcSYrbaLXQeglrkZ67p32iLebI238FocraLZpYMkdqCosx4ZcExtv6h5yGtmID2WU39dUOEy6Uu17tOLJBqJ23fAm9cJcPogIJER7frvGtcP
2025-07-31 17:40:04 [INFO]: Processed 4 messages, reached the limit of 4.
2025-07-31 17:40:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:40:04 [INFO]: inside itemsold and closed 14409
2025-07-31 17:40:06 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:40:06 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:40:06 [INFO]: Ebay item id :: 286661696980 exists in Database
2025-07-31 17:40:06 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:40:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-07-31 17:40:06 [INFO]: inside itemsold and closed 14409
2025-07-31 17:40:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:40:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:40:07 [INFO]: Ebay item id :: 335578896551 exists in Database
2025-07-31 17:40:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:40:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:40:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:40:07 [INFO]: inside itemsold and closed 14409
2025-07-31 17:40:09 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:40:09 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:40:09 [INFO]: Ebay item id :: 335744524489 exists in Database
2025-07-31 17:40:09 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:40:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:40:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:40:09 [INFO]: inside itemsold and closed 14409
2025-07-31 17:40:11 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:40:11 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:40:11 [INFO]: Ebay item id :: 256947625634 exists in Database
2025-07-31 17:40:11 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:40:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:40:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:40:11 [INFO]: in processold action queue is array    for {"45115802":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115802","ebayitemid":"286661696980","deleted":1}},"44577270":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577270","ebayitemid":"335578896551","shopifyproductid":"8697515901150","variants":[{"price":"32.99","quantity":0,"weight":"2","shopifyproductid":"8697515901150","shopifyvariantid":"45939331072222","shopifyinventoryid":"48037790777566","shopifylocationid":"","product_id":"44577270","variant_id":"77469977","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44589658":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44589658","ebayitemid":"335744524489","shopifyproductid":"8013447954654","variants":[{"price":"29.99","quantity":0,"weight":"2","shopifyproductid":"8013447954654","shopifyvariantid":"44139653300446","shopifyinventoryid":"46236554002654","shopifylocationid":"","product_id":"44589658","variant_id":"77482367","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44885867":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44885867","ebayitemid":"256947625634","shopifyproductid":"8927057019102","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8927057019102","shopifyvariantid":"46842634502366","shopifyinventoryid":"48946621317342","shopifylocationid":"58450641063","product_id":"44885867","variant_id":"77797837","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:40:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:40:11 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:40:11 [INFO]: productIds WHich are having null productid -> [45115802]
2025-07-31 17:40:11 [INFO]: ebayItemIds WHich are not imported-> ["286661696980"]
2025-07-31 17:40:11 [INFO]: Entered in bulkUpdateProducts function
2025-07-31 17:40:11 [INFO]: Transaction started for bulkUpdateProducts
2025-07-31 17:40:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115802)
2025-07-31 17:40:11 [INFO]: Query executed successfully. Affected rows: 0
2025-07-31 17:40:11 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-07-31 17:40:11 [INFO]: Transaction committed successfully.
2025-07-31 17:40:11 [INFO]: Transaction ended for bulkUpdateProducts
2025-07-31 17:40:11 [INFO]: Shopify Inventory id 48037790777566
2025-07-31 17:40:11 [INFO]: Shopify Location id 58450641063
2025-07-31 17:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:40: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-07-31 17:40:11 [INFO]: Change: available | Delta: -1
2025-07-31 17:40:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577270 and user_id = 14409 
2025-07-31 17:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469977 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:40:11 [INFO]: Shopify Inventory id 46236554002654
2025-07-31 17:40:11 [INFO]: Shopify Location id 58450641063
2025-07-31 17:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:40:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:40: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-07-31 17:40:11 [INFO]: Change: available | Delta: -1
2025-07-31 17:40:11 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:40:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:40:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44589658 and user_id = 14409 
2025-07-31 17:40:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77482367 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:40:11 [INFO]: Shopify Inventory id 48946621317342
2025-07-31 17:40:11 [INFO]: Shopify Location id 58450641063
2025-07-31 17:40:11 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:40:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17:40:12Z","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-07-31 17:40:12 [INFO]: Change: available | Delta: -1
2025-07-31 17:40:12 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:40:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:40:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44885867 and user_id = 14409 
2025-07-31 17:40:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77797837 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:40:12 [INFO]: updateIdsQuantity -> ["77469977","77482367","77797837"]
2025-07-31 17:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-07-31 17:40:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77469977 THEN 0 WHEN id = 77482367 THEN 0 WHEN id = 77797837 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77469977 THEN 0 WHEN id = 77482367 THEN 0 WHEN id = 77797837 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77469977,77482367,77797837)
2025-07-31 17:40:12 [INFO]: QUANTITY Updated IDs: 77469977, 77482367, 77797837
2025-07-31 17:40:12 [INFO]: Successfully processed data for user 14409
2025-07-31 17:40:12 [INFO]: Execution Started
2025-07-31 17:40:12 [INFO]: Execution Finished
2025-07-31 17:50:01 [INFO]: Execution Started
2025-07-31 17:50:01 [INFO]: old server sucessfully connected
2025-07-31 17:50:01 [INFO]: sqs client sucess created
2025-07-31 17:50:03 [INFO]: Number of messages in the queue: 2
2025-07-31 17:50:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:50:03 [INFO]: item found in queue is  14409
2025-07-31 17:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBb6GGb4lXG4EJJNn7Ol2kV6OfGW4eHlKwXf2n785vCMWpMUbvnppoBEUJVog206Axym03ijQTuAyr2EgUOF+MeptS0PWsYXoqaYY3FDji/teYPRSGgwXXdHh2+CRNU3Sfebjsid/uOuOZ9Azr92d3bIDCXorJVpHxX9+4yQu2N1xk4W5aqKNYyPrc23w+w6HTLEL73fAHLfT38BynCC5/F1E1T0e3QNKz+fui9QEkdiRBg8C0X98DQnBEfdFQucUV+bz8LrxRL4rBj4d24kNIDyCmLkL53Vcmv3FvxoOpXGg4H9UFtCdtOQFo4llle5cMpEpT6uYc/52i4kMbnbcZpY2k4SRwThQyK4sMk8nK1j6t9j9IkD21eBzsCqoJ13AV0LtDYJfzJW9xyXuAXpvtpPET2+SLB7LNLWehlI4rTMm7VQ1NOhKvK40iPxOtUJp9
2025-07-31 17:50:03 [INFO]: item found in queue is if condition  14409
2025-07-31 17:50:03 [INFO]: item found in queue is  14409
2025-07-31 17:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBnpoE3+s0UI2R49nEAB7XMFph/T6wYvUlN7AwhMQkGNb0+JH5wUpTt0Hy9klRj2u5l6QpIGMA/PgqM+sCc092ThdpM+trFG70JLyQ6rrclHBEbFKmNzb23wXPqKSkAOt70zXnhfYkC+fTdcfDcZnX9LCI3uyX1Pzzv/V6t+KyaHI7BCWP0W2wHmUMBo49CxfHhKBN9nLa73dB7PnBzw4KIT/o3I186vbkJIB5zqzNMiTb90WlYb3CRQS2clxFbNsnDuiQIjwKEoctxQd9A4YP/NYShTFyK8Xbef7VSdKfuO6ZA3c8smvxMgfX2YKe3+cyhTkbp97L50VJIDRYgCKfIUhRfTzUZPK0pvfQk1AdfwUXaQ5/2x01RyYzeZiJuSGppsyWB9veOTfjjl0mxBgtg5hWOLQ4yeeniY5otlq+FLUm0Gh4Hz7h/n+yhFiOiasE
2025-07-31 17:50:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-07-31 17:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-07-31 17:50:04 [INFO]: inside itemsold and closed 14409
2025-07-31 17:50:05 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:50:05 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:50:05 [INFO]: Ebay item id :: 305979922454 exists in Database
2025-07-31 17:50:05 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:50:05 [INFO]: inside itemsold and closed 14409
2025-07-31 17:50:07 [INFO]: autodelete for user_id 14409 is 0
2025-07-31 17:50:07 [INFO]: autolink for user_id 14409 is 1
2025-07-31 17:50:07 [INFO]: Ebay item id :: 335727405016 exists in Database
2025-07-31 17:50:07 [INFO]: Item is reliested  ::  exists in Database
2025-07-31 17:50:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-07-31 17:50:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-07-31 17:50:07 [INFO]: in processold action queue is array    for {"44576472":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44576472","ebayitemid":"305979922454","shopifyproductid":"8766570070238","variants":[{"price":"17.99","quantity":0,"weight":"2","shopifyproductid":"8766570070238","shopifyvariantid":"46158967668958","shopifyinventoryid":"48258301362398","shopifylocationid":"","product_id":"44576472","variant_id":"77469179","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570717":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570717","ebayitemid":"335727405016","shopifyproductid":"8764366061790","variants":[{"price":"89.99","quantity":0,"weight":"2","shopifyproductid":"8764366061790","shopifyvariantid":"46152820293854","shopifyinventoryid":"48252133605598","shopifylocationid":"","product_id":"44570717","variant_id":"77463401","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-07-31 17:50:07 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-07-31 17:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:50:07 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-07-31 17:50:07 [INFO]: Shopify Inventory id 48258301362398
2025-07-31 17:50:07 [INFO]: Shopify Location id 58450641063
2025-07-31 17:50:07 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:50:07 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17: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-07-31 17:50:07 [INFO]: Change: available | Delta: -1
2025-07-31 17:50:07 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:50:07 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44576472 and user_id = 14409 
2025-07-31 17:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469179 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:50:08 [INFO]: Shopify Inventory id 48252133605598
2025-07-31 17:50:08 [INFO]: Shopify Location id 58450641063
2025-07-31 17:50:08 [INFO]: QUANTITY FOR UPDATE 0
2025-07-31 17:50:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-07-31T17: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-07-31 17:50:08 [INFO]: Change: available | Delta: -1
2025-07-31 17:50:08 [INFO]: Change: on_hand | Delta: -1
2025-07-31 17:50:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-07-31 17:50:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570717 and user_id = 14409 
2025-07-31 17:50:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77463401 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-07-31 17:50:08 [INFO]: updateIdsQuantity -> ["77469179","77463401"]
2025-07-31 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 2. Affected rows: 2
2025-07-31 17:50:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77469179 THEN 0 WHEN id = 77463401 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77469179 THEN 0 WHEN id = 77463401 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77469179,77463401)
2025-07-31 17:50:08 [INFO]: QUANTITY Updated IDs: 77469179, 77463401
2025-07-31 17:50:08 [INFO]: Successfully processed data for user 14409
2025-07-31 17:50:08 [INFO]: Execution Started
2025-07-31 17:50:08 [INFO]: Execution Finished