2025-08-04 19:00:02 [INFO]: Execution Started 2025-08-04 19:00:02 [INFO]: old server sucessfully connected 2025-08-04 19:00:02 [INFO]: sqs client sucess created 2025-08-04 19:00:03 [INFO]: Number of messages in the queue: 3 2025-08-04 19:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:00:03 [INFO]: item found in queue is 14409 2025-08-04 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB4Ypec5ek8AP44diOZE8gFj3T66ERrWcDd3iita04kEm8onBggyq+Oe7GjjHV1PHx9VAagEDAnaJvZSfBAXg/NAe3tgMIs/cOO/MR4swGsk9MlBOtnCBJxernME4RhoaST/D4EcaRKwNpgcMQgVkRGQtfWIDs0lWZsCTYvMpkxau+PmIoDqwV43AW+q+f5q5HHGOtzeKubGrUAGkQPt90QlChgQisxzln9i+SnT5WqVKVVPNXKRu4xEyYPONMz+BO7pdYzKTEdFz2JMWnPhy0OrTVSP9+kHtaRUy4TRXHdKe1zD4NDnX/N7+UJbsTsoPaBOsFnVOi+bVpP9A9sgGZiGHb35vPg3QK5fRrFmLPqUiawaBd8Gar0vmN0Cdjpt2aUqWTysQ3iK3PgfqiMzoMLsTB7MaRvnQiNuYnKiakGTYZIUiuiq4ljc4ulXvjXZ1B 2025-08-04 19:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:00:04 [INFO]: item found in queue is 14409 2025-08-04 19:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBFzf0Zt4r07+G00gDy34DuluM3+uptpJlOLbmWmpTbA3VEJ61homf7aq3KjyLYSIoHVKaANr2PpNBxMW7Fk0SnmM5V9551Hf1jBRXzGZd/93cmTSY3t6+Cm38pUqNimuagn8/cFLc7bKLoU7iMAZOHSoS4Lmbdk5BffV78AI11nUG0Wt7oxGtf5fzkZZKGTgY/aMubHNpzl/fOOw5nL8lQgnsycDGXbS2b6VC4O48hoyPKUr2CictPl7DpNMgaov0TwOSv4QHjsSiBH3aKj35hDTMG7ZUQawkFSA3Qo1hYubPiBde5E2bK/muVds2ctvaBBXOkDup0OA6NR/1i9pYfcpBLz+FHQSfabOD+5Ny3hQRcbDalZ+ZjHJ7VKkDwx7WsONiiB68JmQJ3+7g3zj+8bI5CagcI9GBxqdrugc+Xu4W6qB95gI2/LMDNM0ij5vz 2025-08-04 19:00:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:00:05 [INFO]: item found in queue is 14409 2025-08-04 19:00:05 [INFO]: Message deleted from the queue for receipt handle: AQEBwVEYW5AaD4n04dHLJZoOMTVtu8PoHHf25cS7rTjTtn//bY1S/3X0Ph5DA+xOUYRS6Aa6oeI3hJg/cNXTh6NdDIYzq0PCKXzwJmxo5qCveisRWRIpEVY9JTiKVYlkTzYQ6TzkUXJGVoLZ8tLbdNvm+HkgMioJEbj5cJlBQjzfX5R6/ICzzlWSuk+z5ey1DmjJcJrdnfIdF5X4UVXz8ntsJtxNlqa++lemXxOSWADeblHoDSENQxhPnFdeURkWlvOuFEVvwOeE8CGfnpz/D+g6cVSVPxznzcnJ2OhDvWRtea8cysGPH2jAT8n4hwBLJ1KKm5TDka4SwyRG7ev0LTwM6PfJOgueyKKxhC1Nk7IZtsq6F+CekHTxX8dIriUdpUdjYtcg/ghkht7f00qZBOlohNu6e83kBYSB+gb6MbEd1TuGl8wD6tPEyhmxy6Iy1ckT 2025-08-04 19:00:05 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 19:00:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:00:05 [INFO]: inside itemsold and closed 14409 2025-08-04 19:00:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:00:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:00:07 [INFO]: Ebay item id :: 225668958896 exists in Database 2025-08-04 19:00:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:00:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:00:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:00:07 [INFO]: inside itemsold and closed 14409 2025-08-04 19:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:00:09 [INFO]: Ebay item id :: 334570069190 exists in Database 2025-08-04 19:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:00:09 [INFO]: inside itemsold and closed 14409 2025-08-04 19:00:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:00:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:00:10 [INFO]: Ebay item id :: 334445776048 exists in Database 2025-08-04 19:00:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:00:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:00:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:00:10 [INFO]: in processold action queue is array for {"44642037":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44642037","ebayitemid":"225668958896","shopifyproductid":"8085508915422","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8085508915422","shopifyvariantid":"44267113545950","shopifyinventoryid":"46364210266334","shopifylocationid":"","product_id":"44642037","variant_id":"77547226","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44588124":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44588124","ebayitemid":"334570069190","shopifyproductid":"7811472621790","variants":[{"price":"25.99","quantity":0,"weight":"0.5","shopifyproductid":"7811472621790","shopifyvariantid":"43444835254494","shopifyinventoryid":"45540251959518","shopifylocationid":"","product_id":"44588124","variant_id":"77480833","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44579331":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579331","ebayitemid":"334445776048","shopifyproductid":"6828816760999","variants":[{"price":"12.38","quantity":0,"weight":"0.5","shopifyproductid":"6828816760999","shopifyvariantid":"40327931592871","shopifyinventoryid":"42423276732583","shopifylocationid":"","product_id":"44579331","variant_id":"77472038","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:00:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:00:10 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:00:10 [INFO]: Shopify Inventory id 46364210266334 2025-08-04 19:00:10 [INFO]: Shopify Location id 58450641063 2025-08-04 19:00:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44642037 and user_id = 14409 2025-08-04 19:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77547226 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:00:11 [INFO]: Shopify Inventory id 45540251959518 2025-08-04 19:00:11 [INFO]: Shopify Location id 58450641063 2025-08-04 19:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 19:00:11 [INFO]: Change: available | Delta: -1 2025-08-04 19:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44588124 and user_id = 14409 2025-08-04 19:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480833 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:00:11 [INFO]: Shopify Inventory id 42423276732583 2025-08-04 19:00:11 [INFO]: Shopify Location id 58450641063 2025-08-04 19:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:00:11 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:00:11Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 19:00:11 [INFO]: Change: available | Delta: -1 2025-08-04 19:00:11 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:00:11 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:00:11 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579331 and user_id = 14409 2025-08-04 19:00:11 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77472038 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:00:11 [INFO]: updateIdsQuantity -> ["77547226","77480833","77472038"] 2025-08-04 19:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 19:00:11 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77547226 THEN 0 WHEN id = 77480833 THEN 0 WHEN id = 77472038 THEN 0 END, quantityflag = CASE WHEN id = 77547226 THEN 0 WHEN id = 77480833 THEN 0 WHEN id = 77472038 THEN 0 END WHERE user_id = 14409 AND id IN (77547226,77480833,77472038) 2025-08-04 19:00:11 [INFO]: QUANTITY Updated IDs: 77547226, 77480833, 77472038 2025-08-04 19:00:11 [INFO]: Successfully processed data for user 14409 2025-08-04 19:00:11 [INFO]: Execution Started 2025-08-04 19:00:11 [INFO]: Execution Finished 2025-08-04 19:10:01 [INFO]: Execution Started 2025-08-04 19:10:01 [INFO]: old server sucessfully connected 2025-08-04 19:10:01 [INFO]: sqs client sucess created 2025-08-04 19:10:02 [INFO]: Number of messages in the queue: 6 2025-08-04 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:03 [INFO]: item found in queue is 14409 2025-08-04 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBoNNy8IKj3ixAtGGFw9wtJRO2fgnStFNejWEz9uBdO5P5+WMMQN7pnmNfm/SGp9iPIATEeHgfwLkWLXiyxe96MFCvueRR+dV2kyXeg+SbNFrE87oPrSr2aAMVST4wicsmc1+PuN4abksbR+Ltt2iv2+fTvsk6L1+vnOBlQdSnb9PpAKCpRSxH6QzXScl+HKCTx+KUZ6Ren5MnA+f92tOVxJbMkU2nrl3fGpJxsPQg3RkfBkBGsOzmifyq/9yUif4Lvl9YGInnDqtl3CZ2VRxvY5f72NS4q1o5+pq0Je7fspu0UZCqIUuH7tvtBWNPcrrMr3OgNetZbMYWkW+oyP/KxM6wWECbSul4C5r/t7fQSetYJwy8v04eCPbfiYXIwLq4HF9XsAP6R1opqeAlpUxgGnrpscG8qNJsrbaIpEote9XyjMrDyYKcFObFoiZF6K0M 2025-08-04 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:03 [INFO]: item found in queue is 14409 2025-08-04 19:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBvnit0WGPdPyG7UochIE+pRpxRXFttI+hnOM2zMqMXcPiqMZc7C6SZjzsuAx7BFofgIqVjDY8EPnOTdF1m5weQjZoimaOUKV196kdSmkIwqH6G3g+XqB0ddiI+5wegHb9E7JL5dH8Uf5QFEQBUqUsMkFbtJPhSoHg0N45MQvVxTdPFvCH0+mOfbN7iAU7Tj/YhcLYKGmK73D+auZaQxROH6n+SPpMur6YP/yiWAkZIA8txGcV+9gSqbaQADmeLaB3BeJkAtLs6u4KaDGuaWIsXKkqzSKDSVTaMsFfOAKgpXEX1u1YcBl0z01y4B2MRVh2Q2/CDLSvSoBGy/e++SRALdjeRIg5j2hF0FFZkU6fAg59nW0PdPYjoAXhMEmuHwmHRj8tumec0uefEiuHKLExtXphWLuaFSBqkO1K9SISgFNGrI8ZdTqCkzX2IxNKy2a3 2025-08-04 19:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:03 [INFO]: item found in queue is 14409 2025-08-04 19:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEB/LPuFzdBXjguG6e50eATsrMBW4q1l/rtzRGMmSl7S/az7tN/fq9yaE8SfZBrWpRnxAD6w9cOw/oqtR8XIwHJugMcUgdvhpXhmuCCadJusO8dY/p1XBpOfnPbsFaFAqAvJk2TjXZIzEcSOb4H0srEV1INZgNy/PCAJ3LC+6/GA7y227HqTw8ngGFUSESA/HN1FOLMYMOCBesVVYLQFHnlsdD93szoQKTz5d3rmexxHvl3Ye7xo3NtCFj/3jwrwmEf5dsnqKGzuniaJBs5S+wLzGLgk6lfs87Kfbzu5lI2KipLEz3WpZ5kVcZ/sxAJmffmUNEaZzb66aDnPQphXV0ick54eRDFdwjn+HaXLLilTBBEoJFGtKCxODN0dwtsgNEpJLDNoVcqmvK7d2D0ONgt3qU/klIaYGDQn6+zNMXoY7CMBHMu8mm1HV3ISyQh9V4E 2025-08-04 19:10:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:04 [INFO]: item found in queue is 14409 2025-08-04 19:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBbrenajbVzQd1VJfxxBxZW8wKEx5f4uMW8HOFQREtQxYpzz8t4D7xtd6nPXHF9JhbGRcd+WKq/RNf9eP7RRms/KdGt5MlxfMcYc7WYc/FpGZN9QCdJmbcGxPiIYebg2EimZezmjZ3nDs//9hVJ0+98ys3jToFE+ZWFiscf9ETKhIyW9y81a2suqxmMwvDmfTuTYzBS2VpYDMwa3p9P13VM0tq09SlfM7QqNVtWebrGLMsCmHmhY2N2Aexx7dLWlDx/RCkTDcfjPUXUbcWgm7yvof+Xmru3gA2wZi9jJ1VWANiKjQSJtqfARg+H6bwRNYhCVf03jnKH3cG+zRMyvTLg4yNGHsfgQatgumy9Q4COy2ttdl7UJqjYlYSrAEnrvZ29H8lkcXItgPrRbyYWSZzHyTD8SxpQWCHtI7s9eIBsnmf9EcVswoAyEtmI7GXB9Km 2025-08-04 19:10:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:05 [INFO]: item found in queue is 14409 2025-08-04 19:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBelKef4wSEEXdAS6iUJD8Mxnjnc1ECfdstHzFjwGcpw4HH/nofXFn+WmajPsCNTdr20F1gGRxVL8NegqF3Y8A+BytyzttHJMTr3PsLZ0ATSXW3bv7z2g4JXYvtsmhKHdf6DIHpFD1JC+wMhNx+kM8eE+SKpwfR9QX7tLkI3YwrFAYFSXpoaPCGHz0GQ6ujXSvxhjQvfjNYNL8iTATiGTYgh3sBudrY/T0lKDcf8X7wKnVhJ5xmMKsubp1v4ngViAN90GiBCfb1fvhmQlGOP+VLWd5Qk8E3Iq3ZN2yqKiDPfb/PGYUwzuu/O8ltjppEwhQvL7XEm3VqhbDmrxKzUCdz+BrZROW7QiNIlHFfGdWnc/WuoWKsc/m1cQdl/+BlpIQcQYFDV8geF9pbkxJqzpdJT0gPo/ePZ9RG2zDrbOa35o/gz4yiqC9ikBJ6gx3eWfi 2025-08-04 19:10:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:10:05 [INFO]: item found in queue is 14409 2025-08-04 19:10:05 [INFO]: Message deleted from the queue for receipt handle: AQEBJfgn9pcSGpMp8cTm4QxLxeYI5n/JtD7DOQi5Wv/j+83ijCI8UyFJaX4pQrL3wxWKoHWCRaD6SbXk7e86o86TT8PqpJXVbepZUn3iubhOs/nTIWi/EpP+5bJGUlv8QYIZ3S8Fe9Gf7lK1fgWygwKS62wAIbsK7M1lAme+L/1gJ83qoKxBfe3oyIGSP+OLbJ7D8qNDWDBJDEwHhExivas0JnogC2yqLQO7HNgyKOqIepCnHycTTwYU9APewd/6eD5NFIU7AJrIN6+x23rvFgHe3ncg5wBEBxACCOxEYxYD+eKnUQ/E8CVKycLOED3jsWxwxlB8XmfMPA+NrkR5uG/WC6kw9v4ivsM8pwpWqdCO6ap47E2FAsiGv0m7/VlHGcSogdro4ou3GPRJVrG8gthmbHSOCCFSrQ1C3MGmBlbfGAcIQ44dJwHJhRILQtsA2cxP 2025-08-04 19:10:05 [INFO]: Processed 6 messages, reached the limit of 6. 2025-08-04 19:10:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:10:05 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:07 [INFO]: Ebay item id :: 405411677201 exists in Database 2025-08-04 19:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:10:07 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:09 [INFO]: Ebay item id :: 404799788971 exists in Database 2025-08-04 19:10:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:10:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:10:09 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:11 [INFO]: Ebay item id :: 303406621714 exists in Database 2025-08-04 19:10:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:11 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:10:11 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:10:11 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:12 [INFO]: Ebay item id :: 303727673772 exists in Database 2025-08-04 19:10:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:10:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:10:12 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:14 [INFO]: Ebay item id :: 256996913000 exists in Database 2025-08-04 19:10:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:14 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:10:14 [INFO]: inside itemsold and closed 14409 2025-08-04 19:10:16 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:10:16 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:10:16 [INFO]: Ebay item id :: 334157091987 exists in Database 2025-08-04 19:10:16 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:10:16 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:10:16 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:10:16 [INFO]: in processold action queue is array for {"44777336":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777336","ebayitemid":"405411677201","shopifyproductid":"8759950704862","variants":[{"price":"15.99","quantity":0,"weight":"0.5","shopifyproductid":"8759950704862","shopifyvariantid":"46139303330014","shopifyinventoryid":"48238524727518","shopifylocationid":"","product_id":"44777336","variant_id":"77685878","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44644605":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44644605","ebayitemid":"404799788971","shopifyproductid":"8697489096926","variants":[{"price":"35.99","quantity":0,"weight":"2","shopifyproductid":"8697489096926","shopifyvariantid":"45939282051294","shopifyinventoryid":"48037738512606","shopifylocationid":"","product_id":"44644605","variant_id":"77549794","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44577256":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577256","ebayitemid":"303406621714","shopifyproductid":"6806888972455","variants":[{"price":"10.38","quantity":0,"weight":"0.5","shopifyproductid":"6806888972455","shopifyvariantid":"40228080517287","shopifyinventoryid":"42323341344935","shopifylocationid":"","product_id":"44577256","variant_id":"77469963","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44573557":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44573557","ebayitemid":"303727673772","shopifyproductid":"6835658784935","variants":[{"price":"10.35","quantity":0,"weight":"0.5","shopifyproductid":"6835658784935","shopifyvariantid":"40352911065255","shopifyinventoryid":"42448258400423","shopifylocationid":"","product_id":"44573557","variant_id":"77466264","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45179712":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45179712","ebayitemid":"256996913000","deleted":1}},"44586452":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44586452","ebayitemid":"334157091987","shopifyproductid":"7057756586151","variants":[{"price":"11.51","quantity":0,"weight":"0.5","shopifyproductid":"7057756586151","shopifyvariantid":"41382228656295","shopifyinventoryid":"43478251667623","shopifylocationid":"","product_id":"44586452","variant_id":"77479161","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:10:16 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:10:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:10:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:10:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:10:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:10:16 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:10:16 [INFO]: productIds WHich are having null productid -> [45179712] 2025-08-04 19:10:16 [INFO]: ebayItemIds WHich are not imported-> ["256996913000"] 2025-08-04 19:10:16 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 19:10:16 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 19:10:16 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45179712) 2025-08-04 19:10:16 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 19:10:16 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 19:10:16 [INFO]: Transaction committed successfully. 2025-08-04 19:10:16 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 19:10:16 [INFO]: Shopify Inventory id 48238524727518 2025-08-04 19:10:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:10:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:10:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:10: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 19:10:16 [INFO]: Change: available | Delta: -1 2025-08-04 19:10:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:10:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:10:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777336 and user_id = 14409 2025-08-04 19:10:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685878 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:10:16 [INFO]: Shopify Inventory id 48037738512606 2025-08-04 19:10:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:10:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:10: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 19:10:17 [INFO]: Change: available | Delta: -1 2025-08-04 19:10:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44644605 and user_id = 14409 2025-08-04 19:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77549794 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:10:17 [INFO]: Shopify Inventory id 42323341344935 2025-08-04 19:10:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:10: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 19:10:17 [INFO]: Change: available | Delta: -1 2025-08-04 19:10:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577256 and user_id = 14409 2025-08-04 19:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469963 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:10:17 [INFO]: Shopify Inventory id 42448258400423 2025-08-04 19:10:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:10: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 19:10:17 [INFO]: Change: available | Delta: -1 2025-08-04 19:10:17 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:10:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:10:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44573557 and user_id = 14409 2025-08-04 19:10:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77466264 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:10:17 [INFO]: Shopify Inventory id 43478251667623 2025-08-04 19:10:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:10:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:10:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:10: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 19:10:18 [INFO]: Change: available | Delta: -1 2025-08-04 19:10:18 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:10:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:10:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44586452 and user_id = 14409 2025-08-04 19:10:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77479161 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:10:18 [INFO]: updateIdsQuantity -> ["77685878","77549794","77469963","77466264","77479161"] 2025-08-04 19:10:18 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-04 19:10:18 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77685878 THEN 0 WHEN id = 77549794 THEN 0 WHEN id = 77469963 THEN 0 WHEN id = 77466264 THEN 0 WHEN id = 77479161 THEN 0 END, quantityflag = CASE WHEN id = 77685878 THEN 0 WHEN id = 77549794 THEN 0 WHEN id = 77469963 THEN 0 WHEN id = 77466264 THEN 0 WHEN id = 77479161 THEN 0 END WHERE user_id = 14409 AND id IN (77685878,77549794,77469963,77466264,77479161) 2025-08-04 19:10:18 [INFO]: QUANTITY Updated IDs: 77685878, 77549794, 77469963, 77466264, 77479161 2025-08-04 19:10:18 [INFO]: Successfully processed data for user 14409 2025-08-04 19:10:18 [INFO]: Execution Started 2025-08-04 19:10:18 [INFO]: Execution Finished 2025-08-04 19:20:02 [INFO]: Execution Started 2025-08-04 19:20:02 [INFO]: old server sucessfully connected 2025-08-04 19:20:02 [INFO]: sqs client sucess created 2025-08-04 19:20:03 [INFO]: Number of messages in the queue: 5 2025-08-04 19:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:20:03 [INFO]: item found in queue is 14409 2025-08-04 19:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBiAuHatQqlUe/wEYfS6etSJgMqyp92j9+9FLUuVok7dum4gPPl3aIRGmS5Vfm+nLqgbKH4r7z8s39+QXVNnp5MREL5k30GFympRbwDBj27FpuOnjBFwP/lI02P3wrOAZtdbj/+ElZNnf8mzGNvuN77NsHrOIutXpgog/sKuSU8XPzecHku4hlvnwkdxmKhBRMAU2rgUtJcAoTSu5DszGrMOcIx88gucEKNsE356nwrkfejnmYSTmGosZIO2+Dfnl90MYC7pve+uHGFxjPeN0S8E9crRnfLrI8hQqoYZ7Kbr+h02+bVFyuE1uwY8+8Dz3M19VRZwImtO5qdfurjM1Y3l/uPDaI8Y/SC83QvRQIJtR7WyXmMj2laP7wKixA3ip4ZUu6k0fc1N8UqJe8ZK8cRT4eLcd6Rlm/8DwzJFsNPny0O/1a/dKqsqhzoSdq1Ddr 2025-08-04 19:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:20:04 [INFO]: item found in queue is 14409 2025-08-04 19:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBzVJnEji9XA9KTTuRd30hOTL469WCMCbwH4WyC2oYjKHQ134sixmwwAILUpnQzu7sVHQwnfSdSS5aArVmNFHyy+EwbeMb3I2uYG+cB7k6HAvBu6GnDhisXTgxGAtGJ7+npY+zY0n5oin2QXjMUql+41RNHqK44D7P0HXRsKM7VvA6zIAqLyQS30OvZSHSDzSFgOtbdIUB//cqXQ+byYTybq6pYej08/3ArQ9IOyZjTQgku9iV73qLlGe5S0kJswCi1RgYZMBpd2NavV1BheVihuUC2AMTfp6oVTDRWrMBWBwTqFaTRAgYqRPlkgvstHYSRbmIPu8pqIHPThxgfPUBKXMBcQLJRhe8MXw9DwADeEcqkQ3xHKN/nil8WuSH+uKuvB+JenH1a8rpuQv2AI/XfEBZ03oohUXI6qWPSPOJW8NfivxcDNA5An0TtCwonNMu 2025-08-04 19:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:20:04 [INFO]: item found in queue is 14409 2025-08-04 19:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBsLDObrOtHUxUDcSrqQXJ2O2lN8X8MxnetDo4yU678dX13w7KXGQeuZt9E2RHg+UOH638iBo/J8lzwvLiHGI+ZMwcdiGsk30Fi4bhaCmCAeLjpM0v+CDvax6l5x3Vo3lTlcSJvCcNlKQnhC+4P15G3utbg/+8pMxCeVLo62ANMUR/uav7dpPDUcuy7feB52pEN5pKuDlvQgJ75GVrK/5To9x6vatxO60Eg5/AWDxaI9jGGCi+GkfiKVu5t1+V1ijy/PpfRX8Qt9RTq/gTw3m+f7FH9wf0CeeeueVpnwc1PJHr3D9Rihyge2g/3K1yKsAYIQOQulvkvxMutu6jGUAVzZQL2qUSFF8niRWERQqdILsKLzEZdOgMpAZPM1PIjnR1XCd5b5DOqsBF95GxSdRE2eiDKfMYNUuybb57VoniTr/jnW18K0p65HCd2E2LU9sF 2025-08-04 19:20:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:20:05 [INFO]: item found in queue is 14409 2025-08-04 19:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBx8DIuqQi9vUesvNfw82QcF25BpZE5Zr6cvQ/sASle9XAjiILRUYJsQC2bGA+nQ4mWboPwd7GymMQjWN2/fovrMGovLK+5qWp9cwy7fXWqhs+sZQiczwgiEG+K0vQSOZMspIvfg9SX9rcNtY7F60zKCZEQ7aHCNtSv/m8F/olLpBE08Hxb7rcSrNUD8LO7idthHDazylgqtT7yVps9GZaTTNRcc2gaGyu/gUVwffstEiIMaVqw25T1SiyIzum4bCvy4bha7AlKQKJKQjBpLecIY6tmIyVzmPHNPhBKwgrEuTudQgcxrKSnYEKu3K2bEuHBI5CoysHipdt/B8bdFLSasBIGBP/4GCYgo2g7keBioP4fPwSNhIS0MJRJbWsQnjBkeTYFJYjmRQ5Qs79zPD4k2W6GUWU5Jy0dOp/lSJhO9QOVxG+QeteiiUCKYxLOpkI 2025-08-04 19:20:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:20:05 [INFO]: item found in queue is 14409 2025-08-04 19:20:05 [INFO]: Message deleted from the queue for receipt handle: AQEBnC4rUXNqR1IEH0WL4DxZVl9lke3abow1xyxOHv8ZNowD98EDM96bYwwNzW+WrkRGJAHhAOTvFCK4Zs6CdoXuoFkjuXhdyO/0S69jO8GbCyHRj7MbabgLEClfkMuHHzuLeKyK8DaFQFKc9OlSrC6JZVCCrZvPuL42Ed0niagytwaB+ij6k+2L9kOne7GA6gEM+u18RoMkwF8DWuhA+aXsyKuvbK1a7DjYN+d2onnu1iC8Kthze/3pjpsFRTJwE/8Mw/SkaD449nVI4hAXpUxM8Qca2yh79k3ygdVSj5hnv48GI9C+fZ5TBdG01jXzh/Bu1YLxlRzgezPeEn7hWnp4k+wFRnXt6r8Ion7rPgsj1wIcBkVUugB/gQk4p0+1XC8Z7G8CwrvG8irzajUDbNrifLDi0zvlYeEd+5OUJxaM3/Up3Wbv2wu8DQ25Mulh+XrC 2025-08-04 19:20:05 [INFO]: Processed 5 messages, reached the limit of 5. 2025-08-04 19:20:05 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:20:05 [INFO]: inside itemsold and closed 14409 2025-08-04 19:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:20:07 [INFO]: Ebay item id :: 404827375095 exists in Database 2025-08-04 19:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:20:07 [INFO]: inside itemsold and closed 14409 2025-08-04 19:20:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:20:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:20:09 [INFO]: Ebay item id :: 285725184581 exists in Database 2025-08-04 19:20:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:20:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:20:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:20:09 [INFO]: inside itemsold and closed 14409 2025-08-04 19:20:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:20:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:20:10 [INFO]: Ebay item id :: 333441809611 exists in Database 2025-08-04 19:20:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:20:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:20:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:20:10 [INFO]: inside itemsold and closed 14409 2025-08-04 19:20:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:20:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:20:12 [INFO]: Ebay item id :: 256842524069 exists in Database 2025-08-04 19:20:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:20:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:20:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:20:12 [INFO]: inside itemsold and closed 14409 2025-08-04 19:20:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:20:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:20:14 [INFO]: Ebay item id :: 303592555981 exists in Database 2025-08-04 19:20:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:20:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:20:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:20:14 [INFO]: in processold action queue is array for {"44715361":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44715361","ebayitemid":"404827375095","shopifyproductid":"8303390818526","variants":[{"price":"89.99","quantity":0,"weight":"3","shopifyproductid":"8303390818526","shopifyvariantid":"44852032733406","shopifyinventoryid":"46950077071582","shopifylocationid":"","product_id":"44715361","variant_id":"77622974","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44672706":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44672706","ebayitemid":"285725184581","shopifyproductid":"8303373287646","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8303373287646","shopifyvariantid":"44851989086430","shopifyinventoryid":"46950033391838","shopifylocationid":"","product_id":"44672706","variant_id":"77577926","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44577291":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44577291","ebayitemid":"333441809611","shopifyproductid":"6814524375207","variants":[{"price":"10.00","quantity":0,"weight":"0.5","shopifyproductid":"6814524375207","shopifyvariantid":"40258219147431","shopifyinventoryid":"42353491083431","shopifylocationid":"","product_id":"44577291","variant_id":"77469998","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44797865":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44797865","ebayitemid":"256842524069","shopifyproductid":"8838262980830","variants":[{"price":"39.99","quantity":0,"weight":"2","shopifyproductid":"8838262980830","shopifyvariantid":"46352541679838","shopifyinventoryid":"48454264848606","shopifylocationid":"","product_id":"44797865","variant_id":"77708282","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44566377":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566377","ebayitemid":"303592555981","shopifyproductid":"6835658096807","variants":[{"price":"10.00","quantity":0,"weight":"0.5","shopifyproductid":"6835658096807","shopifyvariantid":"40352908804263","shopifyinventoryid":"42448256139431","shopifylocationid":"","product_id":"44566377","variant_id":"77459057","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:20:14 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:20:14 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:20:14 [INFO]: Shopify Inventory id 46950077071582 2025-08-04 19:20:14 [INFO]: Shopify Location id 58450641063 2025-08-04 19:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:20:14 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:20: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 19:20:14 [INFO]: Change: available | Delta: -1 2025-08-04 19:20:14 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:20:14 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:20:14 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44715361 and user_id = 14409 2025-08-04 19:20:14 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77622974 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:20:14 [INFO]: Shopify Inventory id 46950033391838 2025-08-04 19:20:14 [INFO]: Shopify Location id 58450641063 2025-08-04 19:20:14 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:20: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 19:20:15 [INFO]: Change: available | Delta: -1 2025-08-04 19:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44672706 and user_id = 14409 2025-08-04 19:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77577926 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:20:15 [INFO]: Shopify Inventory id 42353491083431 2025-08-04 19:20:15 [INFO]: Shopify Location id 58450641063 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:20: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 19:20:15 [INFO]: Change: available | Delta: -1 2025-08-04 19:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44577291 and user_id = 14409 2025-08-04 19:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77469998 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:20:15 [INFO]: Shopify Inventory id 48454264848606 2025-08-04 19:20:15 [INFO]: Shopify Location id 58450641063 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:20: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 19:20:15 [INFO]: Change: available | Delta: -1 2025-08-04 19:20:15 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:20:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:20:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44797865 and user_id = 14409 2025-08-04 19:20:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77708282 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:20:15 [INFO]: Shopify Inventory id 42448256139431 2025-08-04 19:20:15 [INFO]: Shopify Location id 58450641063 2025-08-04 19:20:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:20:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19: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 19:20:16 [INFO]: Change: available | Delta: -1 2025-08-04 19:20:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:20:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:20:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566377 and user_id = 14409 2025-08-04 19:20:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459057 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:20:16 [INFO]: updateIdsQuantity -> ["77622974","77577926","77469998","77708282","77459057"] 2025-08-04 19:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 5. Affected rows: 5 2025-08-04 19:20:16 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77622974 THEN 0 WHEN id = 77577926 THEN 0 WHEN id = 77469998 THEN 0 WHEN id = 77708282 THEN 0 WHEN id = 77459057 THEN 0 END, quantityflag = CASE WHEN id = 77622974 THEN 0 WHEN id = 77577926 THEN 0 WHEN id = 77469998 THEN 0 WHEN id = 77708282 THEN 0 WHEN id = 77459057 THEN 0 END WHERE user_id = 14409 AND id IN (77622974,77577926,77469998,77708282,77459057) 2025-08-04 19:20:16 [INFO]: QUANTITY Updated IDs: 77622974, 77577926, 77469998, 77708282, 77459057 2025-08-04 19:20:16 [INFO]: Successfully processed data for user 14409 2025-08-04 19:20:16 [INFO]: Execution Started 2025-08-04 19:20:16 [INFO]: Execution Finished 2025-08-04 19:30:02 [INFO]: Execution Started 2025-08-04 19:30:02 [INFO]: old server sucessfully connected 2025-08-04 19:30:02 [INFO]: sqs client sucess created 2025-08-04 19:30:03 [INFO]: Number of messages in the queue: 30 2025-08-04 19:30:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:03 [INFO]: item found in queue is 14409 2025-08-04 19:30:03 [INFO]: Message deleted from the queue for receipt handle: AQEBxhZmknvvLJxOTS+S6OAUEHcuBpppj7K7inojvOGF6VmevAAv8mJbnZe1ZeAqjmlSoRlCn2s5P4w57i6E7lpWBMHD8BCrAXHU9eoG/Uiwb6DQzR0lSGNHed0VFx4MhKleYgvaTL7UllbgqVNzHuCR46DOj4kDwtaH++UDJi9JKnZbSB2vwIfph9fe+zH1vCQ7u+beJBkftN+Qi5waB0rKpnD8qMFnbmYQXcXurdKxMZAaDPdMbtqgj34pKUNVdP9ipGjaUiVU0luH66jLy5TpRWvHJ+0qJ45hiITYLDC9OE8z3DNrA8WAj39L4EwAEBtrLcJZ9au7efOuioeQgKR6Pk8FK/UaR8p95L9GKyfO0XO+lJt5JFXvprnXiUxavYs//V+ycnPfc931MjMfNWC5eeMhI4VeoAc6rD0prE6CvNltx4W9bpobpsez/Ka1mJjc 2025-08-04 19:30:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:04 [INFO]: item found in queue is 14409 2025-08-04 19:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBuV/U1IFDKqQ6+EwzoPyQN/2pcxLwelSgl7aaacyGh1S9XntRhgLiEEEX2KZFNwsVEgpkdSFaUL6OGZ9BiP9OP9eW3NxUQ+IKYUxLl4bJuJTxo3n56G1l4TWLxZwJ0l3weW+x7LY1c7baOA4rnZZsovGTG/1ffcjnpRVvj5d3jIYtQdhME9xaB0sCTteNmfrntS7ZkLwNmRct/1r1YAUUCyM8Vj1Kx/oMVBs7Se8pQINRpgtNj5rtPMJhbcR7B9LVunqdnxgexDOmlqp4tp6jpzutzc9sFTiMDjw0FBgERJEJYOvWMAfd6+raDlyTRUkesFv+5k0deTIn/btrturEEfXprmBIJnFBP9l/xBkiin464C45J+WEPY8YtdI6tfpqNSPE/X8tGF6ZWsPAeLGe5kezofdTp7in0wTdHJdT9XFNZ09Veywe4bP19njBQOFP 2025-08-04 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:05 [INFO]: item found in queue is 14409 2025-08-04 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBytunMtx8G6hTeljqOvgrKTNPS5zUb08C8znxHhYW90gTmcu1OUcgWPBH3XQywC5BJUZpkr9dUGiHBCx36kaEOOYuwIt63jAoBSVzlB5xYji4YpJ9rFZfhdPMDNVgCJH3NJNRewCzo7VQtyzGxrpiMGato+IJmvLS7zbMfkEIeI138uyLGCHX7FvstSvib2vsyAVnwF0bcBlTyDKw8bwWJOHub02ER8mlGVqPaVxM4p7wYU4PYW5opg1Cv5MbXT6WDJIyp7v4Sd12ownKWLyzlQHP5RgmvzjkJ490C75OKKm/OAp/LX1+cgIRwXF77+Z6WVGzbBzLz6eZVVCqbHtlH454qqw7JmrU+GiJzcIAoiHu3/ZNjC9SSCIt2md/6RL056ppqpFU6CROBPTCvobrc3mCPhVX+OOn3j7x8vjtyDlnQQpYTDdrkEIMfzM82ek3 2025-08-04 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:05 [INFO]: item found in queue is 14409 2025-08-04 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEB04s5qykQgzbKVyODjYC8jHYmx8OjKgnX7/kxspF5QXDh2JIR6Qph31pt/ELgO/K/mubz73Kh31E+cKQEm6OXmZndIFxnc2NfAoal6AFRxiMCqzIbutDiXYHp9+Z/jnwhWum46aXxBY+ifEmJ72O3tCpaArXNKq1Z6lgRN6FNq0S2P9ApZ89QWSV3X0IgdAy0jtDv6yqmIDGY7cJ6+adu0JapIyrvOvMQSwNBqgnOjCbRsa0Y0VaaBwbFJqcCS1qEnb/UYdDWJzQFeNRVBSEMuDdz6yprVlXzCddn+nGxo698B/nrEeRqm35t1taegX7GttbC+mUmMLnLnAfzdPMhAtlGdnZGL7TtxnS0FNLqX+a1bHBpbqtmyTKDjKoWkew4rFDhDd4bcL/jNS3hlPkigbgIe4Bnk/K9+OeL+9gvRRyG7wpFZJdQ1BDtJv7U1Trh 2025-08-04 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:05 [INFO]: item found in queue is 14409 2025-08-04 19:30:05 [INFO]: Message deleted from the queue for receipt handle: AQEBrwIRtaox7WcaQP1OlTs+N0CYvXIP4daZIiZEExRbR1Vf+xCm9024aooPjK6eNc+BB+7jm9Ua7fYx9uE3Rl7YEaIj2swhiQnySLR+gbqk071gAFJHSR1M/HqhjagjDNS3UXQlDwM34ozjYkcacSrzdWMhK1wA68akfVHPSQsGveuyYQMsYkqSGQHOhfOY0dN7T4sO1gRBTsAJsPnYoJf9wp9w+rH1XO5E29QiAWL3bVAnjOVRuIr6KR2Nh3jFTGdwRZ94t5TBfbsim5hI0d4O4U30dbeno/LhhUJEt+LF2YH3mUg60iO5+KXgH141Gm+0RoJZ8p2YiprRA7RNSx8IXmdfFiUv6vrAdRmS+otOu8dywltQ1J/2qcl60BH40uUvAc7m1TNuZmRtToaNgoJdXb7yiDuVwYlSba96BavKDsKpSB4lhEmkBycXfIigPM/7 2025-08-04 19:30:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:05 [INFO]: item found in queue is 14409 2025-08-04 19:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBPGgierx5HzmrnS6JYAPnZ4v/I76XAAVS+FlI3fsJiUmhRROeE5FOLJujTTjfouSlCKcDR2iRwngYOtjF4jbTE0DewWSTcxVCWMCteDgdjqKUW6DWpnj5GVvLHgRYlrVVaSRAKb/fxQLQpu0a0XiUmjlv3pU9N2jj2jwSnlW3x6lyeL9zmdRRCgiRZWQzZ4Vu0qBRb9VLuxamQE4aNRjvPg/BnHfps9FtZHagvJ4g/kQ19vQv0x+/cT0yc4xjy1x4wV0pHfAJpPwCNYaXyP0+BBtSh78c+jYI3MenScCwU5lt9ahnTuKvgfGEV9JolrzzWJzMob/mLq40HA+DbEWMXPgPpqVuhV8LE3wwfoxCDBbVeEmTC/QdrlziRwHWrkoQmgp1DfRmfi8q+Wjt4746zDGdTMvDecsUcjvmHPcUjao/rFr0PC0GUIXx2Y2kS1jq 2025-08-04 19:30:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:06 [INFO]: item found in queue is 14409 2025-08-04 19:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEBMRu046GxFppqREBx7LC2PKJjwFw5ghXHpccrPa57IGPHtN3TyXR1qdHbwC5WPTodiXwU+plEEXG02EHcEnubdjF1JMqwLOfzxA3BhHH6QnCLEV6pe7LP+ivgPMmYavq7LTlimU18UTIICU1Dln24/2Ct9KHFInouSC1eXrifN3nlPGaQPlYlaSrU9xvVoaBU+68BEFP2XvwfmuZuyAPEmScYGCiDwTZ7Kz7DKbrugiixdI9Pw+Yx6cnaTn+1Bu51KXyfakW2LqIyKL2pUIxoqnPMy4/iYUnEbNqjVNffLuZowxXcYO/CrGgtRsq205fYQMtim1fDTmZa8T5I/vooUiE5ahe7dHcXq3rz8vr/NrXXchh6UWhJNWyqj0/Ijxh3gZUpa3Ou+NPnuuQhjh2X4mJdFAGniREd/HiCMCk2/gdz86Z+2LjD4N6hEJqQlBr7 2025-08-04 19:30:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:06 [INFO]: item found in queue is 14409 2025-08-04 19:30:06 [INFO]: Message deleted from the queue for receipt handle: AQEB9ZuxQuWvpt9YQJ0ZO+iWR/aqsWv0RRJ8+WSWitugh73zl2N7UxPkPG7TGlWPeB6moXormkKduZ9hfrsrPOuTMQkKL+KpQUUGzNUMWqzQv6sJfeEkCEA+B52qHJBhwNLGGmoqfE3NlM3g50C6ZMZjHReTkThGA94FlJYXHLp8D3PhTa24B3hLwnZNj3CyDSYgy84awTlNT13+htFpDjPZfsxBb/z1myPlKPQexD+q8LfkHu/ycPuxEBwKjWShiLBXB7S3wKdK5toeJA0Ot274XEZW8L0oRwolgor/pdm8CZotDu8xRsxY34nMJ0jk0gah7VbNMkbAVI5BOSXpcUCFuX+osYXagEVBVmv7QGqiVCmZp5VhlRi9Q+25ECI1ioRiVgjziUqeippBJ6r6umA0HsvadQYdel+j6oL95iO55VAI+3FzPF/6KIsr3O4oGoeY 2025-08-04 19:30:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:06 [INFO]: item found in queue is 14409 2025-08-04 19:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBLWI4FTA0yJWmZSf4zt8SMa957Cr1PFw7X9DDJ6DM6Rin7Dc7Bnbi5z8uThfZ3MZesqVk9Pjr4Yi1LB/+Qk0Qfwg/e7+vND9kKU4MQBxGZJ6WAEiIHd45scdfIslv+V742u4PClytzzIE7GkKiK0cnomS/jF5/OovjQfSwAIcXJXblmonfEHVR4EHuPL406odZQAkTEjSOkVb1jQY/PeIu3eTV/W8KZLsafNXvyBIgErChJ0LlFClCyR8SbMvqpg4YYbpsg1MSsTpIYxgw5WwOSitiOQdVbKs66PPFlJ9F+Ryb1L8xFDU4XgI9oFZbZvbnokJJckoGE9bOwqJHFhnVZbfLvTkugg7NuW2ktWmzq5XWt/UHGjjJTgtoHiGrf6OySapwuK0KdEVzylt4OaFyIIzFBk4loY7ilMUjZ6C79/bwEVXx/shMqkS3O+KChCC 2025-08-04 19:30:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:07 [INFO]: item found in queue is 14409 2025-08-04 19:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBMPIKWNjIQhquyfa4CtEFRw5R3v31rNsbdnV7mVVxBUwvRrJC6oTIguElnAOMLhBhWYYzPYDXu8PDoHhi646vuc/TXdHf86tiMPZs17w5NhdlK40wr6ZtBgkTLqqTRNo9EHEKrCx1UvbJK6ML2kuCTrb9NRRU4/n0mESjDTo4l4zzwNevRUK48eowc+2Q9y9H7l+8Y74mIGm/govn/GiJg1ICyk2RbtKW003aJoPHk+JTodRNDrtm91XQP7Id3vCyZbk/T5vLO6tyU1wgSFv6UvgCeiP5dhunYXiifW6WkLgwIoxhlh+GrwKp+ypguCHMmgNfq4nV6hoil5Op8BZMFxmyBurdc0atzHJVapRc4OJfAyBbRgn33COd5nDVKZyyVIs/mqBj3YFh4iGfp97LoeTg8qtAmZ+/tHn+0OPxWUxMNpJmutGFEkOMz3wFoUo7 2025-08-04 19:30:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:07 [INFO]: item found in queue is 14409 2025-08-04 19:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBlI7ey/1Ihg9iMjx+e2j9nlpafhmzOu+8yfCruto6He2it3vgWFutiPSvqnFnoZX5/yJM4iuQ+DwIusaQ+CxPgDAY6Y5PVXCNA6wj9up9n8GlXKSvN4D1Q5n9GztD6FPd1PqN95/eQwI0WwXz6SUYb2PhaBMgHWjRAeTuKzhQMI9JHPx3VewfVIJtQe4sRVt3VbjHcvHyJIYyV/w3jBW+Wvr6Yq0weQLTXMivlR+uH1hPzfokMVEHbqUv38sTf4x1gBd++vJ0EJVy3zRRgNeHLhBhOhErYtNDLcR2iQXZpwAqfND4Gj4j8tSJ6lZMhurdLVeNciHG5zeNtJ6g+bO0u3I5zkhJ5zoMIcvjYgnW706MIEToKbTPVtfQWFhkzzBoaqy1PtOoXxo3O/WcrVKjy1gWlar0i5uZ3S+73r14DQ3tOoMgy59JVooE6XzSeygh 2025-08-04 19:30:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:07 [INFO]: item found in queue is 14409 2025-08-04 19:30:07 [INFO]: Message deleted from the queue for receipt handle: AQEBUGqpm+okxu0whqciJLbFYKd/KUDsEQfe/SSpafbUJMmi9erdhQXSf5s6vKrCBdsnep7FwONIokwTkDuMZkHVjTsWT4ChUd5umFa7kqMO6amVut2Q15K199faRLet2XlO3yF+sJzhFcIMtyQQYfKNf09X7XQOwDXlzrbv/+rPUXBNR8UgtZlFInR4YFIaaVcntI8+6fl8JDF5QBbciO2Dj+OY1DKb4V/QzQ0w6ffmSPva4x4ob9+S09a/Z3GLLuNeOfb0asnjSgX2imqpR7PGjXozn3NILxC2V0AoaPIkqtT8GLzs+quLcLqJckKvKxfonUyQAJkzzYcSToOS0gFpqmfupoJRSoLSM4iNjbzPQNNq8TbvueARkgwfaGR0iBnhgnf30kvGD9BzRtbirO5kuO2R9CPDSabIW/JPhAhraC5HOLGtsIudTo9KeOi+X7zA 2025-08-04 19:30:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:08 [INFO]: item found in queue is 14409 2025-08-04 19:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEBjYhxYlM9FLC/GkhVwA5zYeC6NLpRiBSjiiQz+8TuYnPkRKvpB3sPqkQcP8tk+vci7xbCMwHLoITOye2lXHYDB256wIoWrbzyzpOGoKi5p34YehKB6GppfmuOJvJ0NNN+SHSvzSHsPBMsGcR58qREck2QiJTydZoz9lIxS06edh26YuRjSobCLh4TwO5hacCSnxXBpjL3k8ub3EOBAiCDl5mJPqYhqbM7xbBH1aXjGkmVIPupxawLZj3xj9JLJbHbbW6dNFdO1dQhSyEWaTQJDLEDWyw21NCxjdYa1GqqK+KS60IdYe5lrZZLkuXGUWTubhT0wvHWh02fAi6sG8OcBWxP1xjp04Amj7g1OMN5Rqq2MD+xhI8u9s54ChQvFFgajc4skQxC23r27H0IJ9i2omTdsYHtFvhe+NzhgEF+tDY4fMXOy8QGqM2RGUCx/MlN 2025-08-04 19:30:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:08 [INFO]: item found in queue is 14409 2025-08-04 19:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEB+BvnhVykiEwcwgNFOexplPVcjGZg/TCE/WqEZfC0e5HlWLirwOTY7iXc7iR54Bf++mTRbK0q8NawUIPeXLCnwM8f6B+1ZNqN43UDsnHjpv0PyZJSOTVHmkAEsqZm8GXl/zUW53ZTsDGY98eGUT3u0gpY0Sl9bvS0IdUUpYLFNfunrwvzAFpGr7Ed7xMWF4SrLd3oTA63G8F5+PubYLirNj6nWKiZBZ5uj5xFlAQljnsv9xScBeeTdAl6DYEEgRVA08uOtTS9TYBL5r9a0Lj79r9p8JdzILEbUt202Z/1SBdH84EzNZGlLHcn5Dxngi1SHkhPdLHsO74JGuRFpGyZao/eC3SRt54BkYsk38hMGAXgzRtno7xQGX3vybYgoo6SYqWodRer/4UdCgafR7D1O0KIZl2D4qWqQldFG8/TfQ9muUBvxbAC9R0FrYZBKIn0 2025-08-04 19:30:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:08 [INFO]: item found in queue is 14409 2025-08-04 19:30:08 [INFO]: Message deleted from the queue for receipt handle: AQEBQWzU3x9u3PgEytD9EyTg2DX1rofWQuFh1wSCYIJF/mMQ4lofgskC35AJhkYmTILRtwl5D3IoctY/Nf6GpV+E9gF6ZopyR8siSHqMJMLz7HEIR+XRGONSAIxlsTwuv+k5xOZw/iPyJkYv+Nzd7Q4zPCoib3J36SoG2VHsiUU3EQBLAOQ5+b25JRy5JFysJhVg1yUsqEw9dpkiL3bDISVC5de5Q+pgttNouKtlLcWOIAIJlvUNUb8R82DZieE2TvwgNar/P2Qhk94KLow09R2E1iDrdCpNELxXQ7pj5gWq1gQtP/aKfsoScTRATv94s7lVHbNFq5qCwKBcqxQenQNwziQ4y/sAVatIYrv3GZegJRLEEMQCRsaaYQ8ChxYFM7cwN1rdt9sfJhJWJ5HvkqpKpruwWoos1JXt/xphl3t7bDek14Ak1GmKakJhX8MxxWp2 2025-08-04 19:30:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:08 [INFO]: item found in queue is 14409 2025-08-04 19:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEB9zt86udCfA7vprqwV6SK6KZ7ggptSwla3SPu84cH2Xf+dlb9oeD0cMmm6CMrd6ObHETC3UwTGGY9UDFaHBd+fRjT7QfZCCdiyeHtDsS2pr2qzOYYL7/xdurW+aW0xf4Ts9Hmgr0PPnrDIbVRbI1BCUf6RXSCoy1qI4JgnixLL2BVttrSu9pXoMeYs1UBF7dWrxGAhzqbclTQ2XUru5Al6Hn+6rleQ+cD9/xDJx+j/IUDsfJoqCEitoNvjoNpOAcoBmq9x0F96sxamjFoYvTfAENXvUSDUQdtbdaVW/LvZdtj/Zv0zCLlravpL4HC20QHTwctyyuQ9/EQQC10yUCUGQ7JQGkbjVWlB7pUqzW8OazMZg12goBefOt4pbg8CBSs12zISNeDsU4lpr1xJ7b/mvl8gKETn6agD+VYEXAQ9NtrZd0IL1/JZNWEiMP3mqzf 2025-08-04 19:30:09 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:09 [INFO]: item found in queue is 14409 2025-08-04 19:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEB2nTOh1A1m/fqmpKTFXraklORk/wUo/bB11gbQaobfEmF5ExHQd5pdjuHb0cqIMHFxRRlxaBe7Fps+icNFnq3geXeTDNFIt3N2jX5j7Bw8SbXBZ7A7PyyGX8AGLysBE3qyaGYNMpm5wrSOX0SBXnqFwJYPfKDvpwiKA2Mnjy6vOgG2rAtCqK6XxSABrhVCbD//e5fBX6TJqPwhw50J8b03vz6zDPEqy/uxuw90nMcmhZauah6iRqDxXj7LRIYkowUDAnIS2CeZpRs3se/FMFFjsye/G+ZSqIc9fGmNbNIuYbNiRDz0/jFeQBPljXE70XD9sOAjtpDwl0j9MLXF8qROEcYG1OBPld5BPGJ+/8TsKmgYW40X6yDG/P48D6JfQnxYLeQTRgaVJ9sK25IMhY0ZcVNHBWWs2Yxi+Jr4nFijdCRLK6aQlBUwr4ZNrgr0Xk1 2025-08-04 19:30:09 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:09 [INFO]: item found in queue is 14409 2025-08-04 19:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEBfb8UitsdDFM5Uhy/acHqXDDWYSWTdtNRmCTh+uLzcwKeQl75ASCDVS6B/tB+B38/qDX5Zw43lcSqiWr+4HrmqxyhG3Ld2Kbek8lQK25yPUYQSQm7bFAo5C8/rTYw29+wHQ3U07sPNpquyMqfW+flkQPjkO4jCe7uqT9x1p/9leycnxVfJD5eeLpmHuKaVJdYdnpml7JyTWdt6IroWR6FWJ+bkwhJwnGLqtBeWEfpZe755WYpH1I0xW2MKli2yOjF5GpH24FezO/ajYc5f6MRiPIGK3evTz+9EVKwMmOjVMQZvVMSeS83Y6CCODm8A3+J+qtKqY3hvbLSjnpUsWTABUyyGUxTRkAnpQG4VMqQb7tE5cvXbCZxKT91kV/59YWLYHEvmBIDqJuMmPLWSiJXsSxK4PmFU9gZKVGn2RvEvvNQfcd8P2GnPMLspowYgh+Y 2025-08-04 19:30:09 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:09 [INFO]: item found in queue is 14409 2025-08-04 19:30:09 [INFO]: Message deleted from the queue for receipt handle: AQEBK6asjWZo0k4jFSes7yb4NE+A7Hvz1ZXXyS55z4L0o72gVCe3WOuT8vRDkS85UD0N7Amo3SBDrfV6QELJjFfvrn+Dem/v5zZFWuyN7LAyg8hihG8kztdrKq9mYqYMa3RXU+9EUU7N5etouBFg9nX9wa59WHI9WKP3ucrSCt8/q1BtfrND041eq8AkbCfNAMO9RWKPpxLQXF/409RpwE7a4fUOxgIsSuGZZnaySsYdEa8lpWmB89m5V3oFzPzdkQeX4Wpc87lE+BtNgZQfJ45WdFLXYiNmtypIvADeZEFZV6o+0Z6dcKIisjy3qYqG/7XnBGFAS8p4RqcysSjw9lCRlZglolTAJ7QLbFTs1hSf3DhSQGSxB6ugP+JG8KBJcKtqdsnOovAnw+ml/KTuBmFZwtwOljkbI/i5bAIDtkjXYHVX5TvqRkLsHyfKWUQ6yejB 2025-08-04 19:30:09 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:09 [INFO]: item found in queue is 14409 2025-08-04 19:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBeQDUmK8AMZ5lFwx8IUvyEIIiuREo8YGpPDu1GnzlrryCrl5jD/fe/+fkxPkSKdaepIyTATIxPljOAUZCZIO5gaQ7RQiLfCFPtbIZ8DkVC/ji96jpgCqZO4DmY2aCtqQhfryIbhZO0sn51mm/n1H4uvKBuuNxIrjDfoQP7ZWIIThU5aXoOvjA1hZmN+12hOlXmOE/sBrd8jEn6SgyYmuTiwUWlCmU6qUQWFibeykaW/0pgEnOsEYxlx1VCHv2HGtwaK3OpKF4E7fvnMDoTTouxdaHrvkF2mdHN9M88BsMZZd3LSnyE1/tSYR4Ec+lCXbuPtP5h9elT3ymGQMaKljYb+7IA0SW54czzZZjYAcMudpGh531su4VTv3VKc67VP4jWV6lzPyxJXNyVht+DzLjXWzHXPcxoCfIa/UfZCjmHe2gPZIwM53+nK7sI71oI3n6 2025-08-04 19:30:10 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:10 [INFO]: item found in queue is 14409 2025-08-04 19:30:10 [INFO]: Message deleted from the queue for receipt handle: AQEBQqZs0dpFZE5RKwWgwn2DI/ebEeRJILtJl45nk3e2c08kEgFUVNoZ3YjCUNg0RMWMp4ohwt3VxArOkNAoXcFAyNA+4wznRS+TfCBKsnTv0CuhCkGB9u3u2hyKMAk/hQRNhYdysXfj48TF5QvJnWP/XkAEvD/sxjBEHMs7lbCqhaSJx6CbgQa2pBnHP/JWK6lhF2ulDyardsyFTNMqAdT0g6R2gxs1uTKIkMlyJyJNkLKXFHqioYQ5lHGylPasb2TZeyX4l7y4IaOPNlrAiHjMkjcAIr0G+0d98O4ndNhMQNkcQKaP0uuhZYcKufLGmgTq5ICjaDZvmQJ0Lg1m3c1WDuBfRhi9ED0attPSj7V7dYe4t6Wscp17/Cp3AXjgRTcxfpg7ipOX2sv5iZRs5aK+l9n07wD8/nLN/UmJYoKtr2ZQFKR5FLDD7jHNPmrjxCoi 2025-08-04 19:30:11 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:11 [INFO]: item found in queue is 14409 2025-08-04 19:30:11 [INFO]: Message deleted from the queue for receipt handle: AQEB3aObIopNXFHBJWHMTldRbX0HV6YzR9TJLTQG2LLkieg2QmH5eJczJ8rvlI6xwul+aH6qRRj9FjV/GgiVlz46QvOOcbf+KD0ujqWCihi5pwfBiyQSwzfB2ukwuX9vMiZC7+2ukbI5PIPxLCJsKN10Z3tuEqQwee+duIAFKRAOnc4zdKDZGAzPewKWD6A9Uvrze+gTPtUGAxqUMeUg5FankbRlHgIxQVJBwUnLZTcTnwGH3rHCypvQy9kPlOiO8SxuS/QFKham8BjF3mU2wv/1kOBmOm5kJVxFFRDRIP6pqr3nx/S2kK/eUadj69ga/HXWeQ9PyNYHPYPRG+ZM5t1ZrMBxBaocbAyMW1qf6QF4CKa+N6dJ5z3M+vDeIWrrfAoXJvt7fdpSdCMz34IXRNdVchm3BcJKjuiVvHbeLzTEqw8x7XucoPZFgZ8QWrYYehi7 2025-08-04 19:30:11 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:11 [INFO]: item found in queue is 14409 2025-08-04 19:30:11 [INFO]: Message deleted from the queue for receipt handle: AQEB6635fcQNoMw6WGDg27ADJN+3p0Bbw67q0eX3+NksbeqMUEjdOiCHo4lgJpsU+HRNSsNdcyyEb/lKB0WdOVQxhAqdag+kROEKUaKZPpLI9//9SLMqOyYgAUgHmEhp/SD6sdhr4PP6cOoQ0o8mn5WFLHOjA9QiJLegOvFlzQTo2z2nT7hbTRJafu96qELVZveLvB5k1jJAH8OcF+H1KAQn+r8cU1vgS3o3/AEQpJx0BXmJrXJIs24v2z78cDb+GSrqyJwPLkASVgZIAUO17+w5XR2b5yIudIjLwZwsO5xwoDsDdTAlwYwB8rZB4pfZEfdNHRu8vG8Tkg+v387a0+D6ZbJeqspiEym7yw8D2Fn7H8FW2x75iJKcr10od0FeXnxWAkK+49QNIHNlw0IZxbUcigb2NF6AevSpOnBjfBGZfzgFNw35Y0QYcqLEEHkubr6E 2025-08-04 19:30:11 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:11 [INFO]: item found in queue is 14409 2025-08-04 19:30:11 [INFO]: Message deleted from the queue for receipt handle: AQEBvPt/3TYALhle8+0mQF2ZprhP0PWQFXUUu1MBV+3sNI0PtQhwDhx00EkYpoR6F/SrPJFjzfUOjOe6c+bDtR7JS3lCwhsh/Kjo5mmgJhCtaTyGk6n6oLOoKz+yw4W1gyi3Hu49lOMEBdfX5r6S6d7kKKX5dHf2eeoBKUwBnlRn3eaXwQ/AwuiiGwLNTD0fAdyaWGVdJZEoxXpNXnycXUkveOupS1cHfegxMoH+Tr9aIJyraiAAIXba3Kx5yVV58UfYs8eyLJ/4Jfu/JwR+VfiLcaQgw4y3cpoBQmaR8yYkzlj7rxWb7MOr5PByunfYtVCl7O5SFiXEMaWlb6cCcHzT9RrKODw7lOrROVmkxjoO4OWuarFKQxocWWP1pM0wKA3J1tKsQe9WgILN5StTO36OXZbnMhuKjxy6DuoWSuLodiOZIP2Ui3ZALwMzZEqABCrX 2025-08-04 19:30:11 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:11 [INFO]: item found in queue is 14409 2025-08-04 19:30:12 [INFO]: Message deleted from the queue for receipt handle: AQEBn46wn/XasmbPEmNs1igEK1rLwp5xlZNJe+MYlQH/oaXmTV7UwdQqvtqVnsFUwvs0WcARIeu/NTr4uwdhtHhyOwgrRGUGrXSZa/pSUZwds16OZH3D61zX3qi3/RgUFqi5x9HAbNgy4SZ1swyVgOpYS1Jp0/5WLeYrTFVdnPB1pEbtlCf4Mww1ITRsJVoyJRwIjFaMS62Gk+cuvF1l+T5vaHLOI+Ksw4CD2wnGDAWCzzAUgJ2rho+fTjUslWFYj2ECwFP0vvTIc0k6FHC10jC8dYvFUNEwgsA9KZ9xwMZpsXLuGSzmrKugEstNCOUkC+rQ7Jpm1U16rniz6Brbu4o3vsYvh7VqWuFGEmiP+fY+YxkbC6P8JyiTTh8KOHjyegwFisHuFGDgyvKtBKC59bhBxGcAtl1lmzB1rAuFfUgnb8v0RuTe8ftj42RD7zlyhvvo 2025-08-04 19:30:12 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:12 [INFO]: item found in queue is 14409 2025-08-04 19:30:12 [INFO]: Message deleted from the queue for receipt handle: AQEBCcTIY8UB2pwvCS6IsOmK11ZQJ545PFe/cm43JIPcC46rZlTx8Q5EXs1tQ3IvBTjygqkC6JebIE+TyvBoP2Z+oPGFDLgIqZPZWGpDkIQf+u+yAvUs3SvefK8ie83vIKDL/yI+epMAxjhLcMMWCWk3E9iXxAfE4cD62io1keCeRJrDCFJR3abazsccv1ahYKxcHSVzCL2C/NtDsd31H1+HiY8OhZbZNvOmItY0sS/TFzAfqyc4t3O+w5EiyczfLOAiG6JxD2zsMJFTX2McszAL541mV8WoZbVDGVU5Yddg+NSyt76bYDLOE70XIYFBcfZdBma/sRCuGuWAFR6KHWJJ8I4ubBWcohWRQdxoYM4uKr18QhVoh4+YbUjzlHCIk+NLTzo10XCCOXXJuXE/KX2uTyB8X3s3ctOSqaV/hZjj2mFl64GPbs57VnvUxjifJZ1B 2025-08-04 19:30:12 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:12 [INFO]: item found in queue is 14409 2025-08-04 19:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBUZo5JFoZT6IywXIOmnPwE4WXbe1OTAhTncU5atLAbck02C1+dlPCEHrv3NezvOm8i4W4GIhqJhY/N9UIt5Dxlgzn1H4bOQzI58QgtIZPGt6ZjcQXlpn63KV4lWS0W6CI2DMWiy4p/TYzhbExpT4D1aVZpusQ/QMdlG6NjkCvS6WryNj3TC6VQAFAkPwCtOI2TVcu1zTiCAcr36Htcdopaz7F1GIOVtv6yXtzEFGtYTD2zzUjqXLdywFnKjLZo5zlPV7iM+4kp2HIFOS79v00XZJntCfyhn4OxB3YGSBYDS3LLtqnHatFfXV1GNMO8T1APGbUSZOtKAetd8BxSgCf+NvNvXOSBa9Hqo5MEc+3V25EpWJCdoi7s0pNbnLFZ9vwTj1nHM3lwHfIe5c5P1e+EZ1lnuetMOlVVgIfLhqNCsKdl5hdtJrv9abvqtJNqn0c 2025-08-04 19:30:13 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:13 [INFO]: item found in queue is 14409 2025-08-04 19:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBxyedjV7r13U28f1vLp1n2V+VWCth+VsnTCBF2C3ICuBvuP9phYWob4q5TdWFdOTRa4eWxwRFAIkFoKorF+4ajoym7LuyXRcTrJo0a4OXyJFbafTbG8hvzRX8sKrMA/jsV6wVJjsORX63bgnP/382AskVyrfSN2K/p51R1/GUANSgG67j3lBZKnJQ3Ng6f4IwiOyX4iCw/l9ZT+lWorDM7OPnCckhmuQf0nIyieBZHZBr4ghrRxLCUg5Vo/+TGoDhPEh3HlZoqn12McILw2+V6ctY9b+UGs5ID5hA+gemuFkOF7HWCnhzrIIWWTGPQWXTF4BMKaRgxO5YiPg+96cJZBWpbODvp0NKGGqNZkt+LoIbaJsqPAv4znmJzMwJxGOMonZG3pmchNpFZEWIpG/PYQI2caO5ovEKBNWYEqw1gDlFKAOaOLNiRV3/lKpENs4w 2025-08-04 19:30:13 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:13 [INFO]: item found in queue is 14409 2025-08-04 19:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBDD7kYCLf4r3VSRpxMPU6rTqHRSY209b+7p/gvdIWPsciYarJB1EBExPjMR/c6K5NQCe9f+Yz3JB0N1LscA3+5CTFejPVXNFWXnKVWtaVpavBIsnKgMR/1pYUc1XFr8CbNkehPPHqpB8N8vivcrXRpQrRVDhF+QXRNZ/5S6KP9tqhZee6INps86JSwlaVxjWujwLsI1dAp0EbtisZZVZ30o2SSY7R57nATny5o/cPrwxp2LV6fd5iC+G+g+SJTkzXfD1Zeg2/bvJm/P+89Wjs+PqlzGNkJHQBJjKsrefAYvSvj+vJ7EP/mQZgtv/SWgsTGeC0MtXcJQg2hsFshId2ifV/teSW6jBfqZTx9PGqCbPf9oQnPUr7T1ziQ2frK9YVp52bJzXAGigKuJzdM+ezdYpPCped1aFYCKQTlQcrV/0d3yY91OMtc0LIdu2FdiFY 2025-08-04 19:30:13 [INFO]: item found in queue is if condition 14409 2025-08-04 19:30:13 [INFO]: item found in queue is 14409 2025-08-04 19:30:13 [INFO]: Message deleted from the queue for receipt handle: AQEBepsbrvi0Nu1elcr8jIrflOuHCNFThevWB7LFNUCxm3ZLhsAROM9z3tWynd5oVlKFMIr1yK4cuOU+fYgGCz0ZaYkBa2NHrPbQOJQGyskzNd+6KN+UoOScAsQkZOcoXYvhXr04gz0LcMNLC/xIsHRY/mCBy6ac7VQSszwDP563kkvU1SvhG1fZ2OdeYw1rGMB97f7Q/RwAcqktuYm++RvDeTvalatm1+SZTrB6cmR2mhK1aZzmlAiOSSvQEtM5e4Vau1+UmXy5mIykbpe9W+AR/XzK1EleBQxHFw0tS8AqJ128NFZmhWBiD6dD0jrAgNsEwCzqQi7lNPxC4TIf+4li90IyynNVj1aFL0lUa/zscPYO349w1JFvzhNzbcld3HnDfYPTp+s8z7chojapVlhJP3/b2XSDGfJR9/FX6w2+whGT5gVbWAvayiuwyXwvdpk4 2025-08-04 19:30:13 [INFO]: Processed 30 messages, reached the limit of 30. 2025-08-04 19:30:13 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:30:13 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:15 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:15 [INFO]: Ebay item id :: 286453840103 exists in Database 2025-08-04 19:30:15 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:15 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:17 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:17 [INFO]: Ebay item id :: 285543074666 exists in Database 2025-08-04 19:30:17 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:17 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:18 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:18 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:18 [INFO]: Ebay item id :: 284044181068 exists in Database 2025-08-04 19:30:18 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:18 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:18 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:18 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:20 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:20 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:20 [INFO]: Ebay item id :: 286379577420 exists in Database 2025-08-04 19:30:20 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:20 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:20 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:20 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:22 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:22 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:22 [INFO]: Ebay item id :: 334633195358 exists in Database 2025-08-04 19:30:22 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:22 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:22 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:22 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:23 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:23 [INFO]: Ebay item id :: 286715408174 exists in Database 2025-08-04 19:30:23 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:23 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:30:23 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:25 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:25 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:25 [INFO]: Ebay item id :: 335894581253 exists in Database 2025-08-04 19:30:25 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:25 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:25 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:25 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:27 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:27 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:27 [INFO]: Ebay item id :: 306155116442 exists in Database 2025-08-04 19:30:27 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:27 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:27 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:27 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:29 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:29 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:29 [INFO]: Ebay item id :: 286129463186 exists in Database 2025-08-04 19:30:29 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:29 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:30:29 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:31 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:31 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:31 [INFO]: Ebay item id :: 335894590702 exists in Database 2025-08-04 19:30:31 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:31 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:31 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:31 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:33 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:33 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:33 [INFO]: Ebay item id :: 305455564989 exists in Database 2025-08-04 19:30:33 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:33 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:33 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:33 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:35 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:35 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:35 [INFO]: Ebay item id :: 306356056044 exists in Database 2025-08-04 19:30:35 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:35 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:30:35 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:37 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:37 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:37 [INFO]: Ebay item id :: 286177191398 exists in Database 2025-08-04 19:30:37 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:37 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:37 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:37 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:39 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:39 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:39 [INFO]: Ebay item id :: 335842702744 exists in Database 2025-08-04 19:30:39 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:39 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:39 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:39 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:41 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:41 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:41 [INFO]: Ebay item id :: 306294788574 exists in Database 2025-08-04 19:30:41 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:41 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:30:41 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:43 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:43 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:43 [INFO]: Ebay item id :: 305591686757 exists in Database 2025-08-04 19:30:43 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:43 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:43 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:43 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:45 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:45 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:45 [INFO]: Ebay item id :: 305461177414 exists in Database 2025-08-04 19:30:45 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:45 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:45 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:45 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:48 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:48 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:48 [INFO]: Ebay item id :: 306401314069 exists in Database 2025-08-04 19:30:48 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:48 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:48 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:48 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:50 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:50 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:50 [INFO]: Ebay item id :: 286459513622 exists in Database 2025-08-04 19:30:50 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:50 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:50 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:50 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:52 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:52 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:52 [INFO]: Ebay item id :: 304644468926 exists in Database 2025-08-04 19:30:52 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:52 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:52 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:52 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:55 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:55 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:55 [INFO]: Ebay item id :: 282960708677 exists in Database 2025-08-04 19:30:55 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:55 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:55 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:55 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:57 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:57 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:57 [INFO]: Ebay item id :: 286715399707 exists in Database 2025-08-04 19:30:57 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:57 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:30:57 [INFO]: inside itemsold and closed 14409 2025-08-04 19:30:59 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:30:59 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:30:59 [INFO]: Ebay item id :: 286379629824 exists in Database 2025-08-04 19:30:59 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:30:59 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:30:59 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:30:59 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:01 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:01 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:01 [INFO]: Ebay item id :: 286459569083 exists in Database 2025-08-04 19:31:01 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:01 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:01 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:01 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:04 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:04 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:04 [INFO]: Ebay item id :: 285807568665 exists in Database 2025-08-04 19:31:04 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:04 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:04 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:04 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:06 [INFO]: Ebay item id :: 306186488256 exists in Database 2025-08-04 19:31:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:06 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:08 [INFO]: Ebay item id :: 306401323786 exists in Database 2025-08-04 19:31:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:08 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:10 [INFO]: Ebay item id :: 306155111588 exists in Database 2025-08-04 19:31:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:10 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:13 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:13 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:13 [INFO]: Ebay item id :: 305246716296 exists in Database 2025-08-04 19:31:13 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:13 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:13 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:13 [INFO]: inside itemsold and closed 14409 2025-08-04 19:31:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:31:15 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:31:15 [INFO]: Ebay item id :: 332825878587 exists in Database 2025-08-04 19:31:15 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:31:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:31:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:31:15 [INFO]: in processold action queue is array for {"44599549":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44599549","ebayitemid":"286453840103","shopifyproductid":"7991110861022","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7991110861022","shopifyvariantid":"44091220590814","shopifyinventoryid":"46188006244574","shopifylocationid":"","product_id":"44599549","variant_id":"77492258","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44555226":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555226","ebayitemid":"285543074666","shopifyproductid":"8185941885150","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8185941885150","shopifyvariantid":"44478873108702","shopifyinventoryid":"46576802857182","shopifylocationid":"","product_id":"44555226","variant_id":"77447906","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44570805":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44570805","ebayitemid":"284044181068","shopifyproductid":"6800975626407","variants":[{"price":"10.00","quantity":0,"weight":"0.5","shopifyproductid":"6800975626407","shopifyvariantid":"40205550682279","shopifyinventoryid":"42300808167591","shopifylocationid":"","product_id":"44570805","variant_id":"77463489","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556068":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556068","ebayitemid":"286379577420","shopifyproductid":"8220314435806","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8220314435806","shopifyvariantid":"44562703974622","shopifyinventoryid":"46660658364638","shopifylocationid":"","product_id":"44556068","variant_id":"77448748","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44579059":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44579059","ebayitemid":"334633195358","shopifyproductid":"7876479910110","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7876479910110","shopifyvariantid":"43675889434846","shopifyinventoryid":"45771679203550","shopifylocationid":"","product_id":"44579059","variant_id":"77471766","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45256568":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45256568","ebayitemid":"286715408174","deleted":1}},"44556231":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556231","ebayitemid":"335894581253","shopifyproductid":"8193914241246","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8193914241246","shopifyvariantid":"44491960582366","shopifyinventoryid":"46589893574878","shopifylocationid":"","product_id":"44556231","variant_id":"77448911","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556090":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556090","ebayitemid":"306155116442","shopifyproductid":"8249499320542","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8249499320542","shopifyvariantid":"44653878739166","shopifyinventoryid":"46751868289246","shopifylocationid":"","product_id":"44556090","variant_id":"77448770","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45140738":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45140738","ebayitemid":"286129463186","deleted":1}},"44581251":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44581251","ebayitemid":"335894590702","shopifyproductid":"8193912570078","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8193912570078","shopifyvariantid":"44491957731550","shopifyinventoryid":"46589890724062","shopifylocationid":"","product_id":"44581251","variant_id":"77473960","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574722":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574722","ebayitemid":"305455564989","shopifyproductid":"8322011267294","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8322011267294","shopifyvariantid":"44915193839838","shopifyinventoryid":"47012972789982","shopifylocationid":"","product_id":"44574722","variant_id":"77467429","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45115726":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115726","ebayitemid":"306356056044","deleted":1}},"44638790":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44638790","ebayitemid":"286177191398","shopifyproductid":"8744305754334","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8744305754334","shopifyvariantid":"46099000262878","shopifyinventoryid":"48197820874974","shopifylocationid":"","product_id":"44638790","variant_id":"77543980","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556133":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556133","ebayitemid":"335842702744","shopifyproductid":"8369794482398","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8369794482398","shopifyvariantid":"45069693812958","shopifyinventoryid":"47167553274078","shopifylocationid":"","product_id":"44556133","variant_id":"77448813","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45144217":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45144217","ebayitemid":"306294788574","deleted":1}},"44595916":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44595916","ebayitemid":"305591686757","shopifyproductid":"8519985234142","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8519985234142","shopifyvariantid":"45453313867998","shopifyinventoryid":"47551294013662","shopifylocationid":"","product_id":"44595916","variant_id":"77488625","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44578883":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44578883","ebayitemid":"305461177414","shopifyproductid":"8328851194078","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8328851194078","shopifyvariantid":"44932890231006","shopifyinventoryid":"47030669639902","shopifylocationid":"","product_id":"44578883","variant_id":"77471590","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44734603":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44734603","ebayitemid":"306401314069","shopifyproductid":"8378545471710","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8378545471710","shopifyvariantid":"45093976113374","shopifyinventoryid":"47191839244510","shopifylocationid":"","product_id":"44734603","variant_id":"77642496","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556269":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556269","ebayitemid":"286459513622","shopifyproductid":"8202692985054","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8202692985054","shopifyvariantid":"44515524444382","shopifyinventoryid":"46613463335134","shopifylocationid":"","product_id":"44556269","variant_id":"77448949","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44596481":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44596481","ebayitemid":"304644468926","shopifyproductid":"7819233296606","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7819233296606","shopifyvariantid":"43468777586910","shopifyinventoryid":"45564231483614","shopifylocationid":"","product_id":"44596481","variant_id":"77489190","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44567006":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44567006","ebayitemid":"282960708677","shopifyproductid":"6821603016871","variants":[{"price":"9.84","quantity":0,"weight":"0.25","shopifyproductid":"6821603016871","shopifyvariantid":"40294775292071","shopifyinventoryid":"42390107259047","shopifylocationid":"","product_id":"44567006","variant_id":"77459686","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45256532":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45256532","ebayitemid":"286715399707","deleted":1}},"44556126":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556126","ebayitemid":"286379629824","shopifyproductid":"8303356936414","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8303356936414","shopifyvariantid":"44851962282206","shopifyinventoryid":"46950006620382","shopifylocationid":"","product_id":"44556126","variant_id":"77448806","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556308":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556308","ebayitemid":"286459569083","shopifyproductid":"8228254843102","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8228254843102","shopifyvariantid":"44585821896926","shopifyinventoryid":"46683787362526","shopifylocationid":"","product_id":"44556308","variant_id":"77448988","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44566288":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566288","ebayitemid":"285807568665","shopifyproductid":"8384831848670","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8384831848670","shopifyvariantid":"45116288794846","shopifyinventoryid":"47214152614110","shopifylocationid":"","product_id":"44566288","variant_id":"77458968","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44637127":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44637127","ebayitemid":"306186488256","shopifyproductid":"8846525399262","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8846525399262","shopifyvariantid":"46447000191198","shopifyinventoryid":"48548892541150","shopifylocationid":"","product_id":"44637127","variant_id":"77542316","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556082":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556082","ebayitemid":"306155111588","shopifyproductid":"8246745694430","variants":[{"price":"14.99","quantity":0,"weight":"2","shopifyproductid":"8246745694430","shopifyvariantid":"44642225029342","shopifyinventoryid":"46740208812254","shopifylocationid":"","product_id":"44556082","variant_id":"77448762","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44555306":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44555306","ebayitemid":"305246716296","shopifyproductid":"8185960136926","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8185960136926","shopifyvariantid":"44478919508190","shopifyinventoryid":"46576849322206","shopifylocationid":"","product_id":"44555306","variant_id":"77447986","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44599442":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44599442","ebayitemid":"332825878587","shopifyproductid":"6801623908519","variants":[{"price":"9.83","quantity":0,"weight":"0","shopifyproductid":"6801623908519","shopifyvariantid":"40207897165991","shopifyinventoryid":"42303154716839","shopifylocationid":"","product_id":"44599442","variant_id":"77492151","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:31:15 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:31:15 [INFO]: productIds WHich are having null productid -> [45256568,45140738,45115726,45144217,45256532] 2025-08-04 19:31:15 [INFO]: ebayItemIds WHich are not imported-> ["286715408174","286129463186","306356056044","306294788574","286715399707"] 2025-08-04 19:31:15 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 19:31:15 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 19:31:15 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45256568,45140738,45115726,45144217,45256532) 2025-08-04 19:31:15 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 19:31:15 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 19:31:15 [INFO]: Transaction committed successfully. 2025-08-04 19:31:15 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 19:31:15 [INFO]: Shopify Inventory id 46188006244574 2025-08-04 19:31:15 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:15 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:15 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:15 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44599549 and user_id = 14409 2025-08-04 19:31:15 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492258 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:15 [INFO]: Shopify Inventory id 46576802857182 2025-08-04 19:31:15 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:15 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555226 and user_id = 14409 2025-08-04 19:31:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447906 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:16 [INFO]: Shopify Inventory id 42300808167591 2025-08-04 19:31:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:31: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 19:31:16 [INFO]: Change: available | Delta: -1 2025-08-04 19:31:16 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:31:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44570805 and user_id = 14409 2025-08-04 19:31:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77463489 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:16 [INFO]: Shopify Inventory id 46660658364638 2025-08-04 19:31:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556068 and user_id = 14409 2025-08-04 19:31:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448748 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:16 [INFO]: Shopify Inventory id 45771679203550 2025-08-04 19:31:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:16 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:16 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44579059 and user_id = 14409 2025-08-04 19:31:16 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471766 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:16 [INFO]: Shopify Inventory id 46589893574878 2025-08-04 19:31:16 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:16 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556231 and user_id = 14409 2025-08-04 19:31:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448911 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:17 [INFO]: Shopify Inventory id 46751868289246 2025-08-04 19:31:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556090 and user_id = 14409 2025-08-04 19:31:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448770 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:17 [INFO]: Shopify Inventory id 46589890724062 2025-08-04 19:31:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44581251 and user_id = 14409 2025-08-04 19:31:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77473960 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:17 [INFO]: Shopify Inventory id 47012972789982 2025-08-04 19:31:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:17 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:17 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574722 and user_id = 14409 2025-08-04 19:31:17 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467429 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:17 [INFO]: Shopify Inventory id 48197820874974 2025-08-04 19:31:17 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:17 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44638790 and user_id = 14409 2025-08-04 19:31:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77543980 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:18 [INFO]: Shopify Inventory id 47167553274078 2025-08-04 19:31:18 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556133 and user_id = 14409 2025-08-04 19:31:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448813 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:18 [INFO]: Shopify Inventory id 47551294013662 2025-08-04 19:31:18 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44595916 and user_id = 14409 2025-08-04 19:31:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77488625 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:18 [INFO]: Shopify Inventory id 47030669639902 2025-08-04 19:31:18 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:18 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:18 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44578883 and user_id = 14409 2025-08-04 19:31:18 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471590 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:18 [INFO]: Shopify Inventory id 47191839244510 2025-08-04 19:31:18 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:18 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31: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-08-04 19:31:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44734603 and user_id = 14409 2025-08-04 19:31:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77642496 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:19 [INFO]: Shopify Inventory id 46613463335134 2025-08-04 19:31:19 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31: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-08-04 19:31:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556269 and user_id = 14409 2025-08-04 19:31:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448949 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:19 [INFO]: Shopify Inventory id 45564231483614 2025-08-04 19:31:19 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31: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-08-04 19:31:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44596481 and user_id = 14409 2025-08-04 19:31:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77489190 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:19 [INFO]: Shopify Inventory id 42390107259047 2025-08-04 19:31:19 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:19 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:31: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-08-04 19:31:19 [INFO]: Change: available | Delta: -1 2025-08-04 19:31:19 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:31:19 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:19 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44567006 and user_id = 14409 2025-08-04 19:31:19 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459686 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:19 [INFO]: Shopify Inventory id 46950006620382 2025-08-04 19:31:19 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:19 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556126 and user_id = 14409 2025-08-04 19:31:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448806 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:20 [INFO]: Shopify Inventory id 46683787362526 2025-08-04 19:31:20 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556308 and user_id = 14409 2025-08-04 19:31:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448988 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:20 [INFO]: Shopify Inventory id 47214152614110 2025-08-04 19:31:20 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566288 and user_id = 14409 2025-08-04 19:31:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77458968 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:20 [INFO]: Shopify Inventory id 48548892541150 2025-08-04 19:31:20 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:20 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:20 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44637127 and user_id = 14409 2025-08-04 19:31:20 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77542316 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:20 [INFO]: Shopify Inventory id 46740208812254 2025-08-04 19:31:20 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:20 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556082 and user_id = 14409 2025-08-04 19:31:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448762 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:21 [INFO]: Shopify Inventory id 46576849322206 2025-08-04 19:31:21 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:31:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44555306 and user_id = 14409 2025-08-04 19:31:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77447986 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:21 [INFO]: Shopify Inventory id 42303154716839 2025-08-04 19:31:21 [INFO]: Shopify Location id 58450641063 2025-08-04 19:31:21 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:31:21 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:31:21Z","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 19:31:21 [INFO]: Change: available | Delta: -1 2025-08-04 19:31:21 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:31:21 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:31:21 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44599442 and user_id = 14409 2025-08-04 19:31:21 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492151 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:31:21 [INFO]: updateIdsQuantity -> ["77492258","77447906","77463489","77448748","77471766","77448911","77448770","77473960","77467429","77543980","77448813","77488625","77471590","77642496","77448949","77489190","77459686","77448806","77448988","77458968","77542316","77448762","77447986","77492151"] 2025-08-04 19:31:21 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 24. Affected rows: 24 2025-08-04 19:31:21 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77492258 THEN 0 WHEN id = 77447906 THEN 0 WHEN id = 77463489 THEN 0 WHEN id = 77448748 THEN 0 WHEN id = 77471766 THEN 0 WHEN id = 77448911 THEN 0 WHEN id = 77448770 THEN 0 WHEN id = 77473960 THEN 0 WHEN id = 77467429 THEN 0 WHEN id = 77543980 THEN 0 WHEN id = 77448813 THEN 0 WHEN id = 77488625 THEN 0 WHEN id = 77471590 THEN 0 WHEN id = 77642496 THEN 0 WHEN id = 77448949 THEN 0 WHEN id = 77489190 THEN 0 WHEN id = 77459686 THEN 0 WHEN id = 77448806 THEN 0 WHEN id = 77448988 THEN 0 WHEN id = 77458968 THEN 0 WHEN id = 77542316 THEN 0 WHEN id = 77448762 THEN 0 WHEN id = 77447986 THEN 0 WHEN id = 77492151 THEN 0 END, quantityflag = CASE WHEN id = 77492258 THEN 0 WHEN id = 77447906 THEN 0 WHEN id = 77463489 THEN 0 WHEN id = 77448748 THEN 0 WHEN id = 77471766 THEN 0 WHEN id = 77448911 THEN 0 WHEN id = 77448770 THEN 0 WHEN id = 77473960 THEN 0 WHEN id = 77467429 THEN 0 WHEN id = 77543980 THEN 0 WHEN id = 77448813 THEN 0 WHEN id = 77488625 THEN 0 WHEN id = 77471590 THEN 0 WHEN id = 77642496 THEN 0 WHEN id = 77448949 THEN 0 WHEN id = 77489190 THEN 0 WHEN id = 77459686 THEN 0 WHEN id = 77448806 THEN 0 WHEN id = 77448988 THEN 0 WHEN id = 77458968 THEN 0 WHEN id = 77542316 THEN 0 WHEN id = 77448762 THEN 0 WHEN id = 77447986 THEN 0 WHEN id = 77492151 THEN 0 END WHERE user_id = 14409 AND id IN (77492258,77447906,77463489,77448748,77471766,77448911,77448770,77473960,77467429,77543980,77448813,77488625,77471590,77642496,77448949,77489190,77459686,77448806,77448988,77458968,77542316,77448762,77447986,77492151) 2025-08-04 19:31:21 [INFO]: QUANTITY Updated IDs: 77492258, 77447906, 77463489, 77448748, 77471766, 77448911, 77448770, 77473960, 77467429, 77543980, 77448813, 77488625, 77471590, 77642496, 77448949, 77489190, 77459686, 77448806, 77448988, 77458968, 77542316, 77448762, 77447986, 77492151 2025-08-04 19:31:21 [INFO]: Successfully processed data for user 14409 2025-08-04 19:31:21 [INFO]: Execution Started 2025-08-04 19:31:21 [INFO]: Execution Finished 2025-08-04 19:40:02 [INFO]: Execution Started 2025-08-04 19:40:02 [INFO]: old server sucessfully connected 2025-08-04 19:40:02 [INFO]: sqs client sucess created 2025-08-04 19:40:03 [INFO]: Number of messages in the queue: 15 2025-08-04 19:40:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:03 [INFO]: item found in queue is 14409 2025-08-04 19:40:03 [INFO]: Message deleted from the queue for receipt handle: AQEBPKdLoqi6K10DKLB1Kv98XhoUmiDTo+mFzbUZChBbP4CFvBptdXPdxTTvlR5N/o83a+PlOklX9pqGzBRqgvui/dT+UzIlhFLJWNksZKWETnW59lG3Rl3TlCathfIoXmCL6ZQwjuS7C/QWPVhSXHVHKXRGwguPt7JPGAg+bdRJNZjN3PhCE2DRCCTfwDuCaz9Eiv38yWaNlS0eJEerqHEZ8lA1cMq2K0cQM+A6wf5SCd07i8n/87R1Mkx5Xe0wviDmm/m4hgMD+4xnNSSTLlzsslGFpbtuRR36+m2MXt7oOu26HGXkbBA+oClbf2qNSjpFoTo1fp/rPdwURylmx7PkzPCYncz48aRfX7VhN8Z4aB9H9o+J0lKpRxUP7lYU7kYVQH8rKUUx+gcIsAtAfMEQ3bH6VKc8i/5tAPQk5uzWDCpklh1QYMC3AWhXjMs/rXhy 2025-08-04 19:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:04 [INFO]: item found in queue is 14409 2025-08-04 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEByZnAB+jlfLmaooHQvGzlaZ2l6+ur4AfkZqDXY7+QHbhxAc+CwYKv+Oq1XkEY1dyNMjFhFYsSCNKZba7zylmIY2A8yBPx+tVCnNi/tIuJF+4t0qplc64ZN8574pF8+IYAA/COCVgjXBplvZsGPxuf5eEvKCuJobt5EH28Wq0oQ2zqLM3+wf1Lp7oez3QDwtSIzUn+5tDhVnRJy514vhZ3qYsyWcT42au11XNklnzGg+pflHk+bswXBy9oAndm/UJ4qVg1DirU2YPQQU+ZMC13/1KodJ8P2QumHL2c98rq7UOS8pcFPTBIE8bKFTH5Bt0TPsjQetBo6zO+1WX5q8PPLZ5a2dWoyOK0Rdnu3Rq0JM8umjyFsBWOr2hQpJeJbBawCrOsfRJ+Knnb3SIRlmGT57pnX37aIQIHwK5jgEKlqCSz+0B+8uuNHi5WMi8aLatX 2025-08-04 19:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:04 [INFO]: item found in queue is 14409 2025-08-04 19:40:04 [INFO]: Message deleted from the queue for receipt handle: AQEBZIM8+pGtSEmVg+rcxz6Y6NJKUaBED28LIWf/buEkNaJJGwFm+UfdYgJjbr5PAU3bCl/7MfXB1t8hq3o0+nWDgdbOigwAl3JbDmNMwAUXwezkevzTOJUUTvNLQba8/IbjxoOW7dxihCl2QGl87zTtLX2oVt3f2wagJFDQ8v7UMg7ySwUyhi2O9EPrjVextXLMX9eeOALp6QxcueijkjWUmxqxkRNTdyfIcmx6h6V0TwEJW+yZ1nIJR/zPtl4Hohw4vPcuLRjnPwsGnXWhivRqLiVvFE0MjgKsxLsQXWtpwQHbAmtYIRNVDBp0Fc8rEskBwEpVWOmEZvX2zzQEu7+ZYn59UZhKinSPeRWFJOBslv7LdkzqRBeHTMO9529+q2AXWsw323MiWU2gc9LHbhmAopO0eb1OeNL0WtwYR9X8zKJAiT7s9mCJymfxwpfcH+dF 2025-08-04 19:40:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:04 [INFO]: item found in queue is 14409 2025-08-04 19:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBftVoWbaCl4jHakYoS4YbHGrD8l+lprp1t+Yj9hBnd8pMlrr29SGgSUsvWkAJPFiqZKaLJBo0utkEI0DssM9sFRmGSoWIxcpA23fOyAgmIC63DEJ511QBuw5vgquO713/WT1AQpuckFe428Ztp80RXHxToZ8og4Ukiz4jNkR/woVZXThT2/tee9L58ueN0hswhYNEwIjtmYZxu/nlyN5uoeCIo5DZmuEaqr4aJfF4Vo23ltTw24wVkYoJ76K8buV7u/FKd7kVtOfsn+Z1tzNWhnHySz08l+tqLPlR0uAbbgl976tUZHHKYPATH7EZpzpdvWpNwCdCNwziDauwbwB87H3Z/ZUmCBzpsE2P8f3gjyys2pei7ZJDO2TcSy9TqAjJg04Gx8VLFLCLJAkvpj7QUjtGmFYk4Kvl6GxfNspBnLfnQzLxqXwR66tiApKiHS4Y 2025-08-04 19:40:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:05 [INFO]: item found in queue is 14409 2025-08-04 19:40:05 [INFO]: Message deleted from the queue for receipt handle: AQEBbr4S91AXAL/73NdWsnrIKMhQi5ja+qX6FIQC2mNVF84LbMnMmvZBgIlVUkiBjEl83AuM6Z3bg/wGQTcsS32NZx0C+g7lie5QU+bvX2Mu9uqhJpS3CPZQhtFnjbAkBrqhZMzBZQdV93WW/cgvZyY67KIZnm69mvftyc+AO0tgmV6uRSH2QB8ahubAKUf+/1XK8QaR+uqKJ2vQWVvKhpfbfKyjNJCQkMoXuaDn7Vw/uyVQpOizhWOGczuWeWQ8G4b0GWAIF0aop13mnqylR9alvHn8PqiF0aD9lLvwAjNJ7ulkKHVUMIMjJmadMMoZRElZ7u5YAZBo0YHEJRNpw27A/Srmn0BJiaQN45pbqlpMhO3h2OoAGnCRz5fHXpEIaIiBK4FQxjBAlf9bjGH94cS5g5UcxUBVMxFHWSh5ADntb69JjgxfviLmSGqOOyqyimQD 2025-08-04 19:40:05 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:05 [INFO]: item found in queue is 14409 2025-08-04 19:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBvIIOPtIjI0Py1YIx1j1qXLi1JG2IBx95WpavHoVdNCPI5z33BT3hNQE+ep1GEkTic4r/427+GmiuPZIvsdomGEhiMhNzeM6TWH+w0ophgvKrPILMEnvQME25ZGqmGAhrcqkdWTvLtECAKcLHbAEQ5NMalwNjGZ4No/Jqdtm+KpU720l6PYWsdCPU2pEr/Ka0D7aDGvYqnFnQgwLizdY2Vje7MhCsektzmDF9V9l1CyTat9E2IxpwuarkWQlVZG8L2p/7C5sk/aymdwUpBkaaIv38rSkFDi18t1Quy3rSFM2toPJm1jDl94Fdd4my1fe6ncszx7J+dCjAbple4mlPHz0tt64ZSu/4J1a5tTJdTe8Ob6GTwp2dzHI6vXAhFYKL0UeI+UhnrnswNOy1Kg1xdDtRryW6CZ5v0HD8hczEUeKTK+h4L+ok5M5rY3kULCAD 2025-08-04 19:40:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:06 [INFO]: item found in queue is 14409 2025-08-04 19:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEB8qfEFoYHmaFvvNuVo2/5iqMNqsDjObv5+FPIoZ7ALuFcyFHRbHGXj7b7c7k5ga0ii7tMTLCdQgXttmERaMtIs5KpHBNf+ZQNqSDNFnFotmFDHo1sScDPjb+uiYCmcgcC4TU1RNqzuP7VH56iAnJBlbxbK95pCX0mA0KcU4J10eAa3V4J/o1fUzybOYkg+sMwdIwn32hfaYPfv+jUu5OV2swKNPXyLCHJzBcctxj9GeEddWLhOYeE0Ud6AAFm+2bJhilruhV8O0T7hoimMaPCVze2kv25EFG/5lh7gadyC8tBWFhSyaXjRS7Z0QLjy3QILgPoUKykY+H2LXrz7+FsDXuRvLS4I5In3mQbkiAoznCgffkl2vXGbfZu1l60BRpsQ9Vm7/ztAPV+NozjyZG99fOHO3CBdm4muVIv0V2gqwsYFqnqTLhYzJl7YRDrsVfN 2025-08-04 19:40:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:06 [INFO]: item found in queue is 14409 2025-08-04 19:40:06 [INFO]: Message deleted from the queue for receipt handle: AQEBeLK8yv09utNytfEH2PgZlDoPFU2AbV6vMnwd2QsubQOnoVkp/7jEC+dtDez7eYPnPjptL3XLVHTk8yCy3xNxPpHqUw7RWhTHA6uk+iB8Ov6au51NF1i6gZEyAAqG1J0t3AoRUqGnOPEK4aTv9P4yiFma3r6WtEBnVvBGINTiHILMP+DKWGGRYpf6I3fmbsxAXbSqt2dFqJH1PJC2r82MV6HeHlCQIPj3ghq5zZKu8rPJhoiMFE0infqBUn1gr4o4lNJVE8CScRm63XGcde+MHgo8UE/tgWzqMpoUhaCXog6kgiPqGf3zVX2YQNmoprtxxI1Xiw4z4tuemzyzppBHSL89fWQBmqBlcZPRmudLuiLAHYBuuB1vSfuMB+xUz/n71orDD8TiVLojoORBsiITMb1qROaxFI2xUZnp/n391GjExwex3qkT+wEWLFHoZlQd 2025-08-04 19:40:06 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:06 [INFO]: item found in queue is 14409 2025-08-04 19:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEB2Aejqd21yMnu4Iv6V/ooJhWwUeNY5H53A8soY9sEq/KB6cQQBZtyyL5ldEUMCYKompzfGMYPOkre91sXfXVNl2Oy6vK2iIkh8PnrqJANiypCSHrVELt4qDTPXvFMk/WUQguiRwuS8SCWCedyDfGANFOmNB1NqdDnbh1o+SU6DIcsHP9b4yIcYX+RF1SEKGKUkqoGE2z8xAwlLvnedty8AdnxrJ3juily0RWwFF2iTs8q8u7gEkVMfx137rfOscw5JwBAOEJrrOjYBBL5pHfOtwljwMUaeN6EkNFjjkmgSxF+2QlpmSd0vSqG9Gv4B6UHUtXiRzIPz2Lg2G+LP7hq0OlQTh4tiB7xBok8JwyppyYXQ40sKp2TlveAGRA3Yx+iD+Yyr3bA3b/aLnefw790sgUZSlWa5+qwdZbPFheHrkvDx7vu/sOb3qEe/dnniIcz 2025-08-04 19:40:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:07 [INFO]: item found in queue is 14409 2025-08-04 19:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBd506psQ/YC8AkD/1rT3+A7EZn/aSZ8BtmwK21W04+3pgzEZfBQrpUWsRJxMxd/a123LfALdls7XIOEuwZ2Wj4LqI/Eo9zJIcLXSvqL3ue6WMWm1hrhjXuyCP1iCo9r1GE3a8snZ/uPzDmXD1nnW73t6ijJe+QQr+qjpR57n3UznYwFcIWBWlruP+txsi6XlE+N3fgazvV0FLAGnBYBpI2ks0pQZvnx0mpf7O+Yfzlp6oUCRWzwycWDUhtmQRLBYOVR2lrC5nP7q3hYWoz0eepuUy6JzCz5cXTy/Uhsyfxbxwpij/mHzKk+o4BW91EGkQJQKZeBy4JmV+q+z9PXUS2cnQr9A0qwOWoUpzF9E2HVJE4G1b7Csikeo9XrVV5IHuShtZbERMmMVlS0YX3qt6mv0mecpnzb7KFXC/VkmMBqLvqz6CQ6zRL+ApU5HCn8TB 2025-08-04 19:40:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:07 [INFO]: item found in queue is 14409 2025-08-04 19:40:07 [INFO]: Message deleted from the queue for receipt handle: AQEBUreS/O9S1spkJPO3i6fXFmLe7kb5gW4mDuHnT/AvX1IorBAMRYMOjQxojKLo/L0hY27cNmEpAxwBsMw2p0HOfk1dePNaBmfRSAM/YkHlINMIMCl2Wwib25xNSyBsHqfXdPB4I7X20K+UKcdR0HjhCtOxTOp24t3/Gep3JO9OcVaPJzZeqztt4NR3GobsGAqPbjJZ6TquT/CLRCjbjpjQmjysKghnPA7cyZvQr/+a4e2PhNMztV6cbRgmz4Ke+LDDLifPMQpO9lnFiDL7V7nx9IcVyCWXxDVFDDwiD/CRZMIOR6acvDeWKjJl3pcoje1nO/CHIALkeXR7eOphFv8Tj154hH+yRvMQcsoNoftsmfTlk9nVUbUv+dz6r5AhsarCm5KN8XYJsBWs5le+B9mCQVewCMzZo7A7zlyyqJGlH7GulOTN73VaF0TyPVYhJp0a 2025-08-04 19:40:07 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:07 [INFO]: item found in queue is 14409 2025-08-04 19:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBhwKYHs1qQg9ubX7ivpFBcfY3IZF1rMyt/Ga5w6t1NC/ACxFEsipK1K7QyDnpqvTe6PScFhgYDFIIXYXuXtlVu9dvP8asxyiBNjO1hM/nxK8iD3zxVXH6yebK48mX4ZwgfS8ovxog7ndWVWanHPEw/eWxpLAhV/wXsELmg5b+rmcfHBVhtlMBjXGW4zbXQivlmWZgDajCU07tf/4y8hsOoo0PUUWQkyX/IcQf0LjKuxvwOWLeEb04mf6Lt8dhV5wL0nkLnS1m7FEmX14f6inXTcMVJKoSa/PNU/n068LMFCSEH9vKTXak3SV3IJkbgW9jLarI1ZNfwjujs83i1PBKsUzzT6ffm2XfgoWnp1DhjM6nGsV5B3jvucVj6csBX3U1siRcSAJ9qyoYJROGqW4T7vbcPaxAGRpnZODJX/RF0jqEOK0DtjZK4xN2KjE1OhNg 2025-08-04 19:40:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:08 [INFO]: item found in queue is 14409 2025-08-04 19:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEB0GMoUdf5nf3f3uOzNlp3hfYGxSccU3SEYbo2/4uhr5fD7cB4VB5fmeSpysrc+ii1q1/e9hNGu/nMPCmCVscj4mne3Ka89DPFg0eCzlgZrZ9RqTUF2zLYYFoBqplQHCxad1UFFnE4joY7yoxcs7SaWm2sHzU+XmErimqlvf+1jPeDSt/6tmbP/Xi9MRkFWRjJosGs6pkMSNxrluXF+woeEPfczBwHhKr/oPmtU5EKiTjXOJ5DIi+Mtg20sZuRgaD4Ch6jVZL5y0F6B4TQFzK8Wj4v5gCEN3VYZUmiteiQeNS4jyakqpcIFZcUy2uKy1+fZVqcdVVlIhSjcq/WlzSKH9OmTHY8WTZHSvNwPRdlcCcqzLFgtOAQzXj6MLkhnz4FvXIgry8mN6H6yfWebTOOM5UaHDDEgUpqrquzdXtRbbtq69Y8KWx5NR5WMW41ridw 2025-08-04 19:40:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:08 [INFO]: item found in queue is 14409 2025-08-04 19:40:08 [INFO]: Message deleted from the queue for receipt handle: AQEBlif7RArFWnVbkbGZoxwn55xOt8ZMlFWasywdv9ObZ8XBLa2B1dHVkXI46t4+9lT8x76ZERbOrfsez3UBv7QZEBzYvrQtxaGff2x2Kxqo54ATatXU8A8T6FrWNkecKEsDY1uzLUUBlX1XDNwmP86r6TdYSj7aFDgat0ejhRMGtckOQn/1+tKUucJoZHRATgVMDGzGJ6ruCvQv55IP0lsaeGiT/nOA2hZhJHG38ToYk+x//H/z3HD8IxBXS2k5bSjmNdsxe56c+9047xyVu7rZmXF4P+NtSkkl1DNL/mot9gwm3m63MO7iupC2Ikj929SRj/ZgTym7PtxOHJJpKOkR9DTThD7l86H+vhZQyqJAuHv3UEBNkqPZJyhGcEMDrG4HTIlVWk4VfAWmFGnc2Uqq7GIsMp5+fdqTyfyk998FmVYi+Hm7UelGvZEUk6Ca+6/D 2025-08-04 19:40:08 [INFO]: item found in queue is if condition 14409 2025-08-04 19:40:08 [INFO]: item found in queue is 14409 2025-08-04 19:40:09 [INFO]: Message deleted from the queue for receipt handle: AQEB23BOnetL+RUNUGC5YXDHRr78NY+WmVRBShLGpmklc6+cZeP0NY8e8+IflgaNRDJQeIpWqTrKkxSiN5TbfYETIot10EqbEQR7W78qKY3W6eG68WTlt6pI59Ua3Cl73luLy6jrwtsBbFSfc5lqoLJTn8x5JU6//13Tu5z1yVUGNVR3PZ7YDHH/MPdFWyCe3eopGWn87q3IzXglYaQc5GN8TnhCs4KrffhEyaNBSKCv/qdF0D4U3WFDZQRZrT0YEBet+C9+ZADjATiecbgZaeq1HEU3sX1BwIBNaW5rLz8R65vMijDrP1JPjWO00HuvTwaPz9IaHZB98DMafQUhi2cl8RGtyw+MyobBad+NHJFckPup8NDKr3hLGmioEYn1fm6jKq6uiBdxiAoNq/jaZLGg0UVEpMTr2RslI2SZwv7+UFhfAHkTa9S2sk7F+M5bFXCV 2025-08-04 19:40:09 [INFO]: Processed 15 messages, reached the limit of 15. 2025-08-04 19:40:09 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:40:09 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:10 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:10 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:10 [INFO]: Ebay item id :: 286648209147 exists in Database 2025-08-04 19:40:10 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:10 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:40:10 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:12 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:12 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:12 [INFO]: Ebay item id :: 306219395179 exists in Database 2025-08-04 19:40:12 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:12 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:12 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:12 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:14 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:14 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:14 [INFO]: Ebay item id :: 286747477376 exists in Database 2025-08-04 19:40:14 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:14 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:14 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:14 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:15 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:15 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:15 [INFO]: Ebay item id :: 335919197198 exists in Database 2025-08-04 19:40:15 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:15 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:15 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:15 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:17 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:17 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:17 [INFO]: Ebay item id :: 335350552556 exists in Database 2025-08-04 19:40:17 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:17 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:17 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:17 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:19 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:19 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:19 [INFO]: Ebay item id :: 305856108577 exists in Database 2025-08-04 19:40:19 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:19 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:19 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:19 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:21 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:21 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:21 [INFO]: Ebay item id :: 285815303860 exists in Database 2025-08-04 19:40:21 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:21 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:21 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:21 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:23 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:23 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:23 [INFO]: Ebay item id :: 335350590681 exists in Database 2025-08-04 19:40:23 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:23 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:23 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:23 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:25 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:25 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:25 [INFO]: Ebay item id :: 226421991658 exists in Database 2025-08-04 19:40:25 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:25 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:25 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:25 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:27 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:27 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:27 [INFO]: Ebay item id :: 286066391996 exists in Database 2025-08-04 19:40:27 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:27 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:27 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:27 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:29 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:29 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:29 [INFO]: Ebay item id :: 336010339550 exists in Database 2025-08-04 19:40:29 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:29 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:29 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:29 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:31 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:31 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:31 [INFO]: Ebay item id :: 283598736324 exists in Database 2025-08-04 19:40:31 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:31 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:31 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:31 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:33 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:33 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:33 [INFO]: Ebay item id :: 326644554900 exists in Database 2025-08-04 19:40:33 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:33 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 19:40:33 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:35 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:35 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:35 [INFO]: Ebay item id :: 305852930787 exists in Database 2025-08-04 19:40:35 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:35 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:35 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:35 [INFO]: inside itemsold and closed 14409 2025-08-04 19:40:37 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:40:37 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:40:37 [INFO]: Ebay item id :: 286122961508 exists in Database 2025-08-04 19:40:37 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:40:37 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:40:37 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:40:37 [INFO]: in processold action queue is array for {"45115887":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115887","ebayitemid":"286648209147","deleted":1}},"44556181":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556181","ebayitemid":"306219395179","shopifyproductid":"7513871450334","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7513871450334","shopifyvariantid":"42325073494238","shopifyinventoryid":"44419057090782","shopifylocationid":"","product_id":"44556181","variant_id":"77448861","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45313136":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"45313136","ebayitemid":"286747477376","shopifyproductid":"8979658997982","variants":[{"price":"39.99","quantity":0,"weight":"0.75","shopifyproductid":"8979658997982","shopifyvariantid":"47292289876190","shopifyinventoryid":"49404109455582","shopifylocationid":"58450641063","product_id":"45313136","variant_id":"78265649","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44578464":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44578464","ebayitemid":"335919197198","shopifyproductid":"8879440363742","variants":[{"price":"49.99","quantity":0,"weight":"0.75","shopifyproductid":"8879440363742","shopifyvariantid":"46624705413342","shopifyinventoryid":"48727641325790","shopifylocationid":"","product_id":"44578464","variant_id":"77471171","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574668":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574668","ebayitemid":"335350552556","shopifyproductid":"7636014530782","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7636014530782","shopifyvariantid":"42741751513310","shopifyinventoryid":"44836233642206","shopifylocationid":"","product_id":"44574668","variant_id":"77467375","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44587291":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587291","ebayitemid":"305856108577","shopifyproductid":"8712909357278","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8712909357278","shopifyvariantid":"45976550506718","shopifyinventoryid":"48075356831966","shopifylocationid":"","product_id":"44587291","variant_id":"77480000","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574677":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574677","ebayitemid":"285815303860","shopifyproductid":"7653599576286","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7653599576286","shopifyvariantid":"42804055212254","shopifyinventoryid":"44898623979742","shopifylocationid":"","product_id":"44574677","variant_id":"77467384","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44574705":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44574705","ebayitemid":"335350590681","shopifyproductid":"7679388418270","variants":[{"price":"11.99","quantity":0,"weight":"2","shopifyproductid":"7679388418270","shopifyvariantid":"42918489620702","shopifyinventoryid":"45013457404126","shopifylocationid":"","product_id":"44574705","variant_id":"77467412","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44684852":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684852","ebayitemid":"226421991658","shopifyproductid":"7949392249054","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"7949392249054","shopifyvariantid":"43976258715870","shopifyinventoryid":"46072728649950","shopifylocationid":"","product_id":"44684852","variant_id":"77590077","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44578435":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44578435","ebayitemid":"286066391996","shopifyproductid":"8700425994462","variants":[{"price":"10.99","quantity":0,"weight":"2","shopifyproductid":"8700425994462","shopifyvariantid":"45946939867358","shopifyinventoryid":"48045497090270","shopifylocationid":"","product_id":"44578435","variant_id":"77471142","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44780748":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44780748","ebayitemid":"336010339550","shopifyproductid":"8784631169246","variants":[{"price":"9.99","quantity":0,"weight":"2","shopifyproductid":"8784631169246","shopifyvariantid":"46206100898014","shopifyinventoryid":"48305922212062","shopifylocationid":"","product_id":"44780748","variant_id":"77689322","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44597372":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44597372","ebayitemid":"283598736324","shopifyproductid":"6799670935719","variants":[{"price":"9.83","quantity":0,"weight":"0.5","shopifyproductid":"6799670935719","shopifyvariantid":"40198687654055","shopifyinventoryid":"42293942616231","shopifylocationid":"","product_id":"44597372","variant_id":"77490081","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45110965":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45110965","ebayitemid":"326644554900","deleted":1}},"44585526":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44585526","ebayitemid":"305852930787","shopifyproductid":"8711644578014","variants":[{"price":"16.99","quantity":0,"weight":"2","shopifyproductid":"8711644578014","shopifyvariantid":"45973465759966","shopifyinventoryid":"48072264745182","shopifylocationid":"","product_id":"44585526","variant_id":"77478235","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44587302":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44587302","ebayitemid":"286122961508","shopifyproductid":"8712932655326","variants":[{"price":"15.99","quantity":0,"weight":"2","shopifyproductid":"8712932655326","shopifyvariantid":"45976650383582","shopifyinventoryid":"48075457626334","shopifylocationid":"","product_id":"44587302","variant_id":"77480011","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:40:37 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:40:37 [INFO]: productIds WHich are having null productid -> [45115887,45110965] 2025-08-04 19:40:37 [INFO]: ebayItemIds WHich are not imported-> ["286648209147","326644554900"] 2025-08-04 19:40:37 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 19:40:37 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 19:40:37 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115887,45110965) 2025-08-04 19:40:37 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 19:40:37 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 19:40:37 [INFO]: Transaction committed successfully. 2025-08-04 19:40:37 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 19:40:37 [INFO]: Shopify Inventory id 44419057090782 2025-08-04 19:40:37 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:37 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:37 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:37Z","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 19:40:37 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:37 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:37 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:37 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556181 and user_id = 14409 2025-08-04 19:40:37 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77448861 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:37 [INFO]: Shopify Inventory id 49404109455582 2025-08-04 19:40:37 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:37 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:37 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:37Z","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 19:40:37 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:37 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:37 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:37 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 45313136 and user_id = 14409 2025-08-04 19:40:37 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 78265649 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:37 [INFO]: Shopify Inventory id 48727641325790 2025-08-04 19:40:37 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:37 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:38Z","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 19:40:38 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:38 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:38 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:38 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44578464 and user_id = 14409 2025-08-04 19:40:38 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471171 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:38 [INFO]: Shopify Inventory id 44836233642206 2025-08-04 19:40:38 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:38Z","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 19:40:38 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:38 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:38 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:38 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574668 and user_id = 14409 2025-08-04 19:40:38 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467375 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:38 [INFO]: Shopify Inventory id 48075356831966 2025-08-04 19:40:38 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:38Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1983,"restoreRate":100}}}} 2025-08-04 19:40:38 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:38 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:38 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:38 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587291 and user_id = 14409 2025-08-04 19:40:38 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480000 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:38 [INFO]: Shopify Inventory id 44898623979742 2025-08-04 19:40:38 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:38 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:39Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1982,"restoreRate":100}}}} 2025-08-04 19:40:39 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:39 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:39 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:39 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574677 and user_id = 14409 2025-08-04 19:40:39 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467384 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:39 [INFO]: Shopify Inventory id 45013457404126 2025-08-04 19:40:39 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}} 2025-08-04 19:40:39 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:39 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44574705 and user_id = 14409 2025-08-04 19:40:39 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77467412 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:39 [INFO]: Shopify Inventory id 46072728649950 2025-08-04 19:40:39 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:39Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1980,"restoreRate":100}}}} 2025-08-04 19:40:39 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:39 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:39 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:39 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684852 and user_id = 14409 2025-08-04 19:40:39 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590077 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:39 [INFO]: Shopify Inventory id 48045497090270 2025-08-04 19:40:39 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1987,"restoreRate":100}}}} 2025-08-04 19:40:39 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:39 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44578435 and user_id = 14409 2025-08-04 19:40:39 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77471142 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:39 [INFO]: Shopify Inventory id 48305922212062 2025-08-04 19:40:39 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:39 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:40Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1984,"restoreRate":100}}}} 2025-08-04 19:40:40 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:40 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:40 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:40 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44780748 and user_id = 14409 2025-08-04 19:40:40 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77689322 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:40 [INFO]: Shopify Inventory id 42293942616231 2025-08-04 19:40:40 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:40:40Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1982,"restoreRate":100}}}} 2025-08-04 19:40:40 [INFO]: Change: available | Delta: -1 2025-08-04 19:40:40 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:40:40 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:40 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44597372 and user_id = 14409 2025-08-04 19:40:40 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77490081 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:40 [INFO]: Shopify Inventory id 48072264745182 2025-08-04 19:40:40 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:40:40 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:40 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44585526 and user_id = 14409 2025-08-04 19:40:40 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77478235 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:40 [INFO]: Shopify Inventory id 48075457626334 2025-08-04 19:40:40 [INFO]: Shopify Location id 58450641063 2025-08-04 19:40:40 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:40:41 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:40:41 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:40:41 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44587302 and user_id = 14409 2025-08-04 19:40:41 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77480011 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:40:41 [INFO]: updateIdsQuantity -> ["77448861","78265649","77471171","77467375","77480000","77467384","77467412","77590077","77471142","77689322","77490081","77478235","77480011"] 2025-08-04 19:40:41 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 13. Affected rows: 13 2025-08-04 19:40:41 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77448861 THEN 0 WHEN id = 78265649 THEN 0 WHEN id = 77471171 THEN 0 WHEN id = 77467375 THEN 0 WHEN id = 77480000 THEN 0 WHEN id = 77467384 THEN 0 WHEN id = 77467412 THEN 0 WHEN id = 77590077 THEN 0 WHEN id = 77471142 THEN 0 WHEN id = 77689322 THEN 0 WHEN id = 77490081 THEN 0 WHEN id = 77478235 THEN 0 WHEN id = 77480011 THEN 0 END, quantityflag = CASE WHEN id = 77448861 THEN 0 WHEN id = 78265649 THEN 0 WHEN id = 77471171 THEN 0 WHEN id = 77467375 THEN 0 WHEN id = 77480000 THEN 0 WHEN id = 77467384 THEN 0 WHEN id = 77467412 THEN 0 WHEN id = 77590077 THEN 0 WHEN id = 77471142 THEN 0 WHEN id = 77689322 THEN 0 WHEN id = 77490081 THEN 0 WHEN id = 77478235 THEN 0 WHEN id = 77480011 THEN 0 END WHERE user_id = 14409 AND id IN (77448861,78265649,77471171,77467375,77480000,77467384,77467412,77590077,77471142,77689322,77490081,77478235,77480011) 2025-08-04 19:40:41 [INFO]: QUANTITY Updated IDs: 77448861, 78265649, 77471171, 77467375, 77480000, 77467384, 77467412, 77590077, 77471142, 77689322, 77490081, 77478235, 77480011 2025-08-04 19:40:41 [INFO]: Successfully processed data for user 14409 2025-08-04 19:40:41 [INFO]: Execution Started 2025-08-04 19:40:41 [INFO]: Execution Finished 2025-08-04 19:50:01 [INFO]: Execution Started 2025-08-04 19:50:01 [INFO]: old server sucessfully connected 2025-08-04 19:50:01 [INFO]: sqs client sucess created 2025-08-04 19:50:03 [INFO]: Number of messages in the queue: 3 2025-08-04 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:50:03 [INFO]: item found in queue is 14409 2025-08-04 19:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBx0ehIF3i7ZWZS7Snc7iAlHRKvid5cWr4uHDQDRItU+ejoM4lZpYSM8YtkcldCja7TYgC3jBrZJOkJfUTZQlNNtZw+GQ7Ecg6GeTBdQWyIK6bTbtL1x5y9A5UKsdE3ZxwAk++a+PyD2uXY6j8thVQwCrBMs27s+EvZ4hkGoqdhYIkjmsfESpKc5CUUj3QBcTuxm/37j1IFg/5lex3AxPa4nTHvw8xxbs7KHXA9/jumwU5Nhlwako4vzH2Bf8co1yDT6tn02O1Q4WJ2x+LxJLfyRRKNSCm2Ytz/2JD4R3xIV11OKReQhb+xB6jQx5ZtDYxYwXYt7xyNOgRS+eurGhioax5325+wQ8Yp1zHlv/9jBrm59Hu9sZ6hIkaDXs8rOC3mP3fdK3sjVoqkBVC/P23sVYMX9P9PrhLY7v4DJfaxpqSqDHpg9s6TCF3oBRyiD31 2025-08-04 19:50:03 [INFO]: item found in queue is if condition 14409 2025-08-04 19:50:03 [INFO]: item found in queue is 14409 2025-08-04 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBHiXLm04d/7GPvSSyneZh8tUYwyhZF9aJWgg2kFlG0GblaeE/oP/34qkzWEolVMA2A1Ki7zq8RHW/C3gxAT+OQnKg7lw/suOdAlNnKyqlUFUZcghXmsz5+zAe1sZzNSvaRTLb74VvsfcoA7BfXxFpWT+hCFXfGTphAwgHckKcJw2kKdw/xJKkATxLONMIl/6q+QwIn8fVVgPK/dxuT2M8hNPBcAK0fwN0aLuISajnFuNCfnkaG1KATMzjv9p+8SfTcTjpwu7mvxQaHEfqUYNVWipTrQcj1vkxkXvGoJ/rmgS9KATe7tqIMjjIiopNA5Z+QjL4Iui6OLhlskVWUIK2g6r5fD9Al4JIn12sPsx7ApDaHtiCuBQbl/9HolK+SY3aLlULYR+glhiX9ZrfChTR/maiKUyvUr2mBAnuNRM5RAYclb5rWr3AhvOjQOuggY4S 2025-08-04 19:50:04 [INFO]: item found in queue is if condition 14409 2025-08-04 19:50:04 [INFO]: item found in queue is 14409 2025-08-04 19:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBHhreGQq5OiKAKIUBxEauio2eE8iy7idar6j/WE47+R0rL6rB+lBMbvGP7eZx3JUMy9gyvyA77/EjpHOhvs1KqXg6rKauCYPoi+JGv/xxwa3RNew1xbwBCE+dViGkFZAi7oebJubIzCI5doBbgwDW8XYjyiYEmvBPz9a6a+d7Ij6ZC+7Q96IhCKfw/csbDuYInO9D5VKrTp/5c+0mc+ouXLo7oOMkNlotBiH+U6xqGjrKlp8ySUyeepl6sKxL1wMV29+zj5cwpVmUqtkPi7BuAyL3AsD4IvuWzzb/70nT0n/InLj7x16Ir9FntyC4+Pzcj7XXg8f0QAF4OfKf9OjPFHVO//8bs+SaIvXpCdoVurWT8Am1VZvwLpj0ScMyCIc/pCwG1dOT/KmvSD4kefBJEAzzE16hhmXSJiQ7B69uyZWIJOu/UzzE74NfL6sSdVFZ 2025-08-04 19:50:04 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 19:50:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 19:50:04 [INFO]: inside itemsold and closed 14409 2025-08-04 19:50:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:50:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:50:06 [INFO]: Ebay item id :: 335890848347 exists in Database 2025-08-04 19:50:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:50:06 [INFO]: inside itemsold and closed 14409 2025-08-04 19:50:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:50:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:50:08 [INFO]: Ebay item id :: 286208827791 exists in Database 2025-08-04 19:50:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:50:08 [INFO]: inside itemsold and closed 14409 2025-08-04 19:50:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 19:50:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 19:50:09 [INFO]: Ebay item id :: 305966872878 exists in Database 2025-08-04 19:50:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 19:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 19:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 19:50:09 [INFO]: in processold action queue is array for {"44744025":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44744025","ebayitemid":"335890848347","shopifyproductid":"8861044703454","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8861044703454","shopifyvariantid":"46514871140574","shopifyinventoryid":"48617202548958","shopifylocationid":"","product_id":"44744025","variant_id":"77652424","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44566981":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566981","ebayitemid":"286208827791","shopifyproductid":"7848286814430","variants":[{"price":"20.99","quantity":0,"weight":"1","shopifyproductid":"7848286814430","shopifyvariantid":"43559379763422","shopifyinventoryid":"45655019552990","shopifylocationid":"","product_id":"44566981","variant_id":"77459661","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44566490":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566490","ebayitemid":"305966872878","shopifyproductid":"8760153800926","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8760153800926","shopifyvariantid":"46139875852510","shopifyinventoryid":"48239110160606","shopifylocationid":"","product_id":"44566490","variant_id":"77459170","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 19:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 19:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 19:50:09 [INFO]: Shopify Inventory id 48617202548958 2025-08-04 19:50:09 [INFO]: Shopify Location id 58450641063 2025-08-04 19:50:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44744025 and user_id = 14409 2025-08-04 19:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77652424 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:50:10 [INFO]: Shopify Inventory id 45655019552990 2025-08-04 19:50:10 [INFO]: Shopify Location id 58450641063 2025-08-04 19:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T19:50: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 19:50:10 [INFO]: Change: available | Delta: -1 2025-08-04 19:50:10 [INFO]: Change: on_hand | Delta: -1 2025-08-04 19:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566981 and user_id = 14409 2025-08-04 19:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459661 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:50:10 [INFO]: Shopify Inventory id 48239110160606 2025-08-04 19:50:10 [INFO]: Shopify Location id 58450641063 2025-08-04 19:50:10 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 19:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":null,"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":10,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1990,"restoreRate":100}}}} 2025-08-04 19:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 19:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566490 and user_id = 14409 2025-08-04 19:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459170 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 19:50:10 [INFO]: updateIdsQuantity -> ["77652424","77459661","77459170"] 2025-08-04 19:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 19:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77652424 THEN 0 WHEN id = 77459661 THEN 0 WHEN id = 77459170 THEN 0 END, quantityflag = CASE WHEN id = 77652424 THEN 0 WHEN id = 77459661 THEN 0 WHEN id = 77459170 THEN 0 END WHERE user_id = 14409 AND id IN (77652424,77459661,77459170) 2025-08-04 19:50:10 [INFO]: QUANTITY Updated IDs: 77652424, 77459661, 77459170 2025-08-04 19:50:10 [INFO]: Successfully processed data for user 14409 2025-08-04 19:50:10 [INFO]: Execution Started 2025-08-04 19:50:10 [INFO]: Execution Finished