2025-08-12 02:00:01 [INFO]: Execution Started
2025-08-12 02:00:01 [INFO]: old server sucessfully connected
2025-08-12 02:00:01 [INFO]: sqs client sucess created
2025-08-12 02:00:02 [INFO]: Number of messages in the queue: 1
2025-08-12 02:00:02 [INFO]: item found in queue is if condition  14409
2025-08-12 02:00:02 [INFO]: item found in queue is  14409
2025-08-12 02:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBYZbtpCquQmYDwjOy6T+kWkfjWeWOW+/oG4SsdpBeHTqj315KVCLe/dZt0fUen9ZUrnq8dIBKm+U7xhyxJF/lOW74UcOrBc/d3vKc8QOAjvVJa6mlElbjRLbE4LvULq25coOtwnxtklhg3tmHDW4/b05LoRkT09P00/XNvhXo1fGvGFlOIeeODm0Lo8QKDzdbH92IzMURZeyr18a9GAkCIHyHJ+iyPg69JDF1Ln7uVlohC8Uv7WSEUZP5MlimaefmDMtgbguSHymfzfx9qAmlrO3k8wjlp0LMRgIvCtwE/GHJ6hllj4jd0rGAtg3UdNMQCq1pH+De+MN27zu4qTUcr2Vsa/I799Ehrd5In3v6H+oYnmRGjwIP8wfjDuKZTRjnuNYbfr1V0CxCYHDbMLJ35UFpMa4cP8J1a3wb7ii237bfrUYv9ARmOwioA9dExUsR
2025-08-12 02:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 02:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 02:00:03 [INFO]: inside itemsold and closed 14409
2025-08-12 02:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 02:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-12 02:00:05 [INFO]: Ebay item id :: 335953951694 exists in Database
2025-08-12 02:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 02:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 02:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 02:00:05 [INFO]: in processold action queue is array    for {"44631786":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44631786","ebayitemid":"335953951694","shopifyproductid":"8016320397534","variants":[{"price":"19.99","quantity":0,"weight":"2","shopifyproductid":"8016320397534","shopifyvariantid":"44144685809886","shopifyinventoryid":"46241589821662","shopifylocationid":"","product_id":"44631786","variant_id":"77536896","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-12 02:00:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 02:00:05 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 02:00:05 [INFO]: Shopify Inventory id 46241589821662
2025-08-12 02:00:05 [INFO]: Shopify Location id 58450641063
2025-08-12 02:00:05 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 02:00:05 [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-12 02:00:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 02:00:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44631786 and user_id = 14409 
2025-08-12 02:00:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77536896 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 02:00:05 [INFO]: updateIdsQuantity -> ["77536896"]
2025-08-12 02:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 02:00:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77536896 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77536896 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77536896)
2025-08-12 02:00:05 [INFO]: QUANTITY Updated IDs: 77536896
2025-08-12 02:00:05 [INFO]: Successfully processed data for user 14409
2025-08-12 02:00:05 [INFO]: Execution Started
2025-08-12 02:00:05 [INFO]: Execution Finished
2025-08-12 02:10:02 [INFO]: Execution Started
2025-08-12 02:10:02 [INFO]: old server sucessfully connected
2025-08-12 02:10:02 [INFO]: sqs client sucess created
2025-08-12 02:10:03 [INFO]: Number of messages in the queue: 2
2025-08-12 02:10:03 [INFO]: item found in queue is if condition  14409
2025-08-12 02:10:03 [INFO]: item found in queue is  14409
2025-08-12 02:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBg6ibe5HsssNI5Lxl35aOBLbQjPB4oFd6/u5wVk6RyJIqBJATEk4aAET/X3V/wuPLxpUKZ1P4k77hpwhWeh8SPzCpGdJVFNTc/xJqJGc+s75lxpEVfWZZPEE9u6w0kJoUlZY1g9ScAuGLuGWJvlISh+bpHRYOua5t1XERycEnbyt24OL2z8RxOoEEFNc4NA7boSndqndn1kLmyhX0GvOdiVuxKWeSeSOzJuVuUdjw1ChArcSIuEmJllbF34Zo4snI+hM3Tadp1eZSoHhBcVDD1L30Z2CRQVUA3dAa30ygMCobN2i7C/RF7jByYboOFreg66S08YvJuc/ZWkRmZ61BW+laUZZxu1sIngjwD9+rdQndMF906pNjxWiGDI8MQ0HroB2uQOXZfcGN3wlboqzRx3bZFmS3eELioR+6g1+XV/4jvhbf59cXitFAKzwRKA0u
2025-08-12 02:10:04 [INFO]: item found in queue is if condition  14409
2025-08-12 02:10:04 [INFO]: item found in queue is  14409
2025-08-12 02:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBS14UrnZxFbgab7w9iQjFmITYb/UYFlyP9pW3CO0j2ALYlm0fdDAFrJxeU3L+sRE2IjEF9loQcXnT2N2/NrUI3D1S+GPO1Ef9izr3KoUhuICarBCe5G721sMZtBgjM0+5saRgC6HNkkWtiB8JfLmmtmxinw00YOFvlQCEzyOWPWoamJkwLIvaWTkSXQcxzgV6mTbyoDKnghiY8vcF/Ytcr/8fRv0KgNNMfXHBcwvUvflfmNzaYXzInzHsCzuNW5aXcT7zLWlbSQCYVjvz7P2uGT4P6zh/PgJWHyh63LNhU+9skfHIqHnWy3Sc4ZUFIsPsxr6hzY9TcrLb2HbK3e84M+/51zL1+JfNquipS4U+dvF5yukjEnwWN2GYsbVyUvKHFyna2WHHL/YkRCCda7PfwvXIOOccYWnK/QIVS6HB8beuaEmfurezOvKDl0K4g3dD
2025-08-12 02:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-12 02:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 02:10:04 [INFO]: inside itemsold and closed 14409
2025-08-12 02:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 02:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-12 02:10:06 [INFO]: Ebay item id :: 404361907214 exists in Database
2025-08-12 02:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 02:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-12 02:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-12 02:10:06 [INFO]: inside itemsold and closed 14409
2025-08-12 02:10:07 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 02:10:07 [INFO]: autolink for user_id 14409 is 1
2025-08-12 02:10:07 [INFO]: Ebay item id :: 226886062550 exists in Database
2025-08-12 02:10:07 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 02:10:07 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-12 02:10:07 [INFO]: in processold action queue is array    for {"44763982":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44763982","ebayitemid":"404361907214","shopifyproductid":"8077859750110","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"8077859750110","shopifyvariantid":"44255317623006","shopifyinventoryid":"46352475357406","shopifylocationid":"","product_id":"44763982","variant_id":"77672524","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45295562":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45295562","ebayitemid":"226886062550","deleted":1}}}
2025-08-12 02:10:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 02:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-12 02:10:08 [INFO]: productIds WHich are having null productid -> [45295562]
2025-08-12 02:10:08 [INFO]: ebayItemIds WHich are not imported-> ["226886062550"]
2025-08-12 02:10:08 [INFO]: Entered in bulkUpdateProducts function
2025-08-12 02:10:08 [INFO]: Transaction started for bulkUpdateProducts
2025-08-12 02:10:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45295562)
2025-08-12 02:10:08 [INFO]: Query executed successfully. Affected rows: 0
2025-08-12 02:10:08 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-12 02:10:08 [INFO]: Transaction committed successfully.
2025-08-12 02:10:08 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-12 02:10:08 [INFO]: Shopify Inventory id 46352475357406
2025-08-12 02:10:08 [INFO]: Shopify Location id 58450641063
2025-08-12 02:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-12 02:10:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-12T02:10:08Z","reason":"correction","changes":[{"name":"available","delta":-1},{"name":"on_hand","delta":-1}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-12 02:10:08 [INFO]: Change: available | Delta: -1
2025-08-12 02:10:08 [INFO]: Change: on_hand | Delta: -1
2025-08-12 02:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-12 02:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44763982 and user_id = 14409 
2025-08-12 02:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77672524 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-12 02:10:08 [INFO]: updateIdsQuantity -> ["77672524"]
2025-08-12 02:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-12 02:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77672524 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77672524 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77672524)
2025-08-12 02:10:08 [INFO]: QUANTITY Updated IDs: 77672524
2025-08-12 02:10:08 [INFO]: Successfully processed data for user 14409
2025-08-12 02:10:08 [INFO]: Execution Started
2025-08-12 02:10:08 [INFO]: Execution Finished
2025-08-12 02:20:01 [INFO]: Execution Started
2025-08-12 02:20:01 [INFO]: old server sucessfully connected
2025-08-12 02:20:01 [INFO]: sqs client sucess created
2025-08-12 02:20:02 [INFO]: Number of messages in the queue: 1
2025-08-12 02:20:02 [INFO]: item found in queue is if condition  14409
2025-08-12 02:20:02 [INFO]: item found in queue is  14409
2025-08-12 02:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJs/nqO6NA3FOJnar/JXDM80bdkbIisB90072LffugRBn0LVlrNuuVZn0Ro+KvZxzwOS2LaRfAAw3TALSWBZAaytSvdAPxBVoPN8GROHiNTdgMnPrFwuQ1IMIyAq67fMdcGRPD2tRJQsrV/miVR/nnopcdeRwYr1Ao2qqFsYn064fApauxK37R/t32jWLrLOkoFxmwKrqOAIiPtpsj0ozGRQF7Q0c36Yza1lddtm5nyTZw+r2QWfzgqOAEH9F7QreE5hRMWegzym38CCb+iEs+e+3Hfett6yx3aa6VwVQ8/qZvalHP2gvnCEK2RBZ5QScnqNh3/JlV8/M4URKOuObprFJJFfD8xaVe/0PLLORhgRNPKr1wJ3XGAYjqYB0a5JSLyHOkL3xvGwYwTe9jD2VuKqjBwLtKn78/KIhZwDDOj6PnOxRxaP8ksTg5CguaKUy
2025-08-12 02:20:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-12 02:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-12 02:20:03 [INFO]: inside itemsold and closed 14409
2025-08-12 02:20:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-12 02:20:04 [INFO]: autolink for user_id 14409 is 1
2025-08-12 02:20:04 [INFO]: Ebay item id :: 306337630330 exists in Database
2025-08-12 02:20:04 [INFO]: Item is reliested  ::  exists in Database
2025-08-12 02:20:04 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-12 02:20:04 [INFO]: in processold action queue is array    for {"45113403":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113403","ebayitemid":"306337630330","deleted":1}}}
2025-08-12 02:20:04 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-12 02:20:04 [INFO]: productIds WHich are having null productid -> [45113403]
2025-08-12 02:20:04 [INFO]: ebayItemIds WHich are not imported-> ["306337630330"]
2025-08-12 02:20:04 [INFO]: Entered in bulkUpdateProducts function
2025-08-12 02:20:04 [INFO]: Transaction started for bulkUpdateProducts
2025-08-12 02:20:04 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113403)
2025-08-12 02:20:04 [INFO]: Query executed successfully. Affected rows: 0
2025-08-12 02:20:04 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-12 02:20:04 [INFO]: Transaction committed successfully.
2025-08-12 02:20:04 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-12 02:20:04 [INFO]: Successfully processed data for user 14409
2025-08-12 02:20:04 [INFO]: Execution Started
2025-08-12 02:20:04 [INFO]: Execution Finished
2025-08-12 02:30:01 [INFO]: Execution Started
2025-08-12 02:30:01 [INFO]: old server sucessfully connected
2025-08-12 02:30:01 [INFO]: sqs client sucess created
2025-08-12 02:30:02 [INFO]: Number of messages in the queue: 0
2025-08-12 02:30:22 [INFO]: Execution Started
2025-08-12 02:30:22 [INFO]: Execution Finished
2025-08-12 02:40:01 [INFO]: Execution Started
2025-08-12 02:40:01 [INFO]: old server sucessfully connected
2025-08-12 02:40:02 [INFO]: sqs client sucess created
2025-08-12 02:40:03 [INFO]: Number of messages in the queue: 0
2025-08-12 02:40:23 [INFO]: Execution Started
2025-08-12 02:40:23 [INFO]: Execution Finished
2025-08-12 02:50:02 [INFO]: Execution Started
2025-08-12 02:50:02 [INFO]: old server sucessfully connected
2025-08-12 02:50:02 [INFO]: sqs client sucess created
2025-08-12 02:50:03 [INFO]: Number of messages in the queue: 0
2025-08-12 02:50:23 [INFO]: Execution Started
2025-08-12 02:50:23 [INFO]: Execution Finished