2025-08-08 10:00:02 [INFO]: Execution Started
2025-08-08 10:00:02 [INFO]: old server sucessfully connected
2025-08-08 10:00:02 [INFO]: sqs client sucess created
2025-08-08 10:00:03 [INFO]: Number of messages in the queue: 0
2025-08-08 10:00:23 [INFO]: Execution Started
2025-08-08 10:00:23 [INFO]: Execution Finished
2025-08-08 10:10:01 [INFO]: Execution Started
2025-08-08 10:10:01 [INFO]: old server sucessfully connected
2025-08-08 10:10:01 [INFO]: sqs client sucess created
2025-08-08 10:10:02 [INFO]: Number of messages in the queue: 0
2025-08-08 10:10:23 [INFO]: Execution Started
2025-08-08 10:10:23 [INFO]: Execution Finished
2025-08-08 10:20:02 [INFO]: Execution Started
2025-08-08 10:20:02 [INFO]: old server sucessfully connected
2025-08-08 10:20:02 [INFO]: sqs client sucess created
2025-08-08 10:20:03 [INFO]: Number of messages in the queue: 1
2025-08-08 10:20:04 [INFO]: item found in queue is if condition  14409
2025-08-08 10:20:04 [INFO]: item found in queue is  14409
2025-08-08 10:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBgEZQFJqMQI6RsWyWa++80nmZdJdqMXmJ9Zs6GaTw96FIUB7z4rpO1uKoMmUAVRIvzDP4wRwlMkWl8By3Z13lpKEh/M2Jaf8VjX+9h6crGL1+PMN5L6ZcH0P0qX9J4BXV16l03LPkW4KOauT6fiW/uK372x/51qbu46CHK0R35szeFw+okjnxXyfpxCcJp6UPf4skE40rmA3yFFWZdM4dHtmHSIA5eCb3icw+927vQxl8hRUPh0Jw2rD1UiEjtLCe8ewUmLOX+o+e6let/TM01xlRINHREKQJbz8vRbvxo/GR5NpOEDp3SCrizLl1k9M2mKgyebyMmE9wqidGw/xJzg4Iq5lj7AuVYr+ClSQJxjn9936yV7plGx+1+8dYTcOupnpNAbpvpcCvvFHfam0GGaCXdXEI+2zSrSwDsyWQ0Ti01Zlp2xGAdSw4mc3q/UsU
2025-08-08 10:20:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-08 10:20:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 10:20:04 [INFO]: inside itemsold and closed 14409
2025-08-08 10:20:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 10:20:06 [INFO]: autolink for user_id 14409 is 1
2025-08-08 10:20:06 [INFO]: Ebay item id :: 256745026231 exists in Database
2025-08-08 10:20:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 10:20:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 10:20:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 10:20:06 [INFO]: in processold action queue is array    for {"44777319":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44777319","ebayitemid":"256745026231","shopifyproductid":"8759057580254","variants":[{"price":"139.99","quantity":0,"weight":"2","shopifyproductid":"8759057580254","shopifyvariantid":"46137028772062","shopifyinventoryid":"48236247646430","shopifylocationid":"","product_id":"44777319","variant_id":"77685861","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 10:20:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 10:20:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 10:20:06 [INFO]: Shopify Inventory id 48236247646430
2025-08-08 10:20:06 [INFO]: Shopify Location id 58450641063
2025-08-08 10:20:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 10:20:06 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T10:20:06Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 10:20:06 [INFO]: Change: available | Delta: -2
2025-08-08 10:20:06 [INFO]: Change: on_hand | Delta: -2
2025-08-08 10:20:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 10:20:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44777319 and user_id = 14409 
2025-08-08 10:20:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77685861 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 10:20:06 [INFO]: updateIdsQuantity -> ["77685861"]
2025-08-08 10:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-08 10:20:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77685861 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77685861 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77685861)
2025-08-08 10:20:06 [INFO]: QUANTITY Updated IDs: 77685861
2025-08-08 10:20:06 [INFO]: Successfully processed data for user 14409
2025-08-08 10:20:06 [INFO]: Execution Started
2025-08-08 10:20:06 [INFO]: Execution Finished
2025-08-08 10:30:01 [INFO]: Execution Started
2025-08-08 10:30:01 [INFO]: old server sucessfully connected
2025-08-08 10:30:01 [INFO]: sqs client sucess created
2025-08-08 10:30:03 [INFO]: Number of messages in the queue: 0
2025-08-08 10:30:23 [INFO]: Execution Started
2025-08-08 10:30:23 [INFO]: Execution Finished
2025-08-08 10:40:01 [INFO]: Execution Started
2025-08-08 10:40:01 [INFO]: old server sucessfully connected
2025-08-08 10:40:01 [INFO]: sqs client sucess created
2025-08-08 10:40:03 [INFO]: Number of messages in the queue: 0
2025-08-08 10:40:23 [INFO]: Execution Started
2025-08-08 10:40:23 [INFO]: Execution Finished
2025-08-08 10:50:01 [INFO]: Execution Started
2025-08-08 10:50:01 [INFO]: old server sucessfully connected
2025-08-08 10:50:01 [INFO]: sqs client sucess created
2025-08-08 10:50:02 [INFO]: Number of messages in the queue: 3
2025-08-08 10:50:03 [INFO]: item found in queue is if condition  14409
2025-08-08 10:50:03 [INFO]: item found in queue is  14409
2025-08-08 10:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBi+M+Sx8xL3PGS2QVgIvjQnX3pDLXaltlE4Pge1kyVQgbbo00ZRiG1Pt5YZsAQT7VMDO25nqH3v01L3MWrZAmR3miBLqlewEg8pv6bHRU5x53YP/z4oPrpKAqIoX8M/bU7AaKcjOKPC6zAiqitpAsZsvu0ZU5SLErKE5jURLoMcvtbkTS6sZPrwiuI82ptkKtYA4+XbiaKXZzp9wVBZcyzwQE73qeHkdqe1RNThwdeAjCKF7YJd62fv9YgtRUUpAqbhXD3wqwoIc36IzNkFHB36yFNpC2baZM/9C4gH6bXmuG0k80Vlqpj9up+siEazwNncGU5ADCzLmVYDLzKMjtocjYIyVu3rSp8+m70uueCXS3KZpvn/MTPpbKiFqU3iWp3cAxw7xZQRDNh7ouLukeUFjU81veTj6vlLdMBCcF62f/C16uL2cSMGu8/GSHSTPI
2025-08-08 10:50:03 [INFO]: item found in queue is if condition  14409
2025-08-08 10:50:03 [INFO]: item found in queue is  14409
2025-08-08 10:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBZecA5f8YZDuFpbkVpk10Bti9QkY6ncGsxpGCgopp6pa6NAYsRyrYjsjHXYnNgaFSI2B0JuPFFRr784TMylN8+mlVz4a2p/rLThd7EEFJdcYJm2Xq4hpuPl6WYmq3y3lgUgPVZPHsXgZUtfNAnNPDZkLMdXTSjLCfu4ij0EbULesNsepUMkikTUCItir1t+6RBzO7c7qLIeRbEqtCJxfEB8tzWmDtuVvsKuZdwVhE8OPtAzbe3i5U2nInebQZeY+iXtHkgwT1YOc/p+0tAzNyatZYaKWqYXYoPydvAT2dR28GOlMJZI3b0tzSC74xVAavEk0eL+pvzQgk3VIgjCWe6QbRDua7SxPZDSMbHtz9dAeuMyO29hYE1K2UI9+X2CtTrBB8a48Z02+qLkAfkiY3hvVJwnwh/LFF7IKF67JlvwdgQpm676gEhfIgjZXrpFMv
2025-08-08 10:50:04 [INFO]: item found in queue is if condition  14409
2025-08-08 10:50:04 [INFO]: item found in queue is  14409
2025-08-08 10:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqVlhb+7TtTMe4wUR3pcErAe0VcMCeW+59arzfNk3xJUJ4ckBszFTpUqdCuc3uXVuhUEhMT3X8jR84+7ehxW8UA7pmqOLquvjCfCM8IkJoiVcEov6dHRuBHnedGxXENgD2Rnpk/wReUTZ3ixGVPTra1GQ/tpgDA40s/KYxgoTJy5tPQLLnmuP6PAxLlgVimW2wwimByz50RS0YQigoGKiLCWiGhVyibwXYkUT1YEJ/nX4g+VOXeS5/aF6PuWb7oG2vQWR1unrsmGkYk92uNCrPwwbiQ+37xRHImoBLZP8rxLakBjIooAWzpszumSGpMQUGCMwEUFHqRIdBErSl3PSnn5Jq5tGQor2k6r9CUU9I+To3IPnup4A9eDoMtUbqHG189K+MiRqjoeTor48koCTJWJoAxheC1WUWTAI1hGLMepQ/V+yOJoNNr1Ev+3BXCQZ
2025-08-08 10:50:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-08 10:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-08 10:50:04 [INFO]: inside itemsold and closed 14409
2025-08-08 10:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 10:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-08 10:50:06 [INFO]: Ebay item id :: 405179426597 exists in Database
2025-08-08 10:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 10:50:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 10:50:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 10:50:06 [INFO]: inside itemsold and closed 14409
2025-08-08 10:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 10:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-08 10:50:08 [INFO]: Ebay item id :: 405238217660 exists in Database
2025-08-08 10:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 10:50:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 10:50:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 10:50:08 [INFO]: inside itemsold and closed 14409
2025-08-08 10:50:09 [INFO]: autodelete for user_id 14409 is 0
2025-08-08 10:50:09 [INFO]: autolink for user_id 14409 is 1
2025-08-08 10:50:09 [INFO]: Ebay item id :: 405171482497 exists in Database
2025-08-08 10:50:09 [INFO]: Item is reliested  ::  exists in Database
2025-08-08 10:50:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-08 10:50:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-08 10:50:09 [INFO]: in processold action queue is array    for {"44661315":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44661315","ebayitemid":"405179426597","shopifyproductid":"8696087052510","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8696087052510","shopifyvariantid":"45936152510686","shopifyinventoryid":"48034601468126","shopifylocationid":"","product_id":"44661315","variant_id":"77566535","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44658327":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44658327","ebayitemid":"405238217660","shopifyproductid":"8696078467294","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8696078467294","shopifyvariantid":"45936133505246","shopifyinventoryid":"48034582462686","shopifylocationid":"","product_id":"44658327","variant_id":"77563547","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44649195":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44649195","ebayitemid":"405171482497","shopifyproductid":"8696087970014","variants":[{"price":"85.99","quantity":0,"weight":"2","shopifyproductid":"8696087970014","shopifyvariantid":"45936154280158","shopifyinventoryid":"48034603237598","shopifylocationid":"","product_id":"44649195","variant_id":"77554384","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-08 10:50:09 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-08 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 10:50:09 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-08 10:50:09 [INFO]: Shopify Inventory id 48034601468126
2025-08-08 10:50:09 [INFO]: Shopify Location id 58450641063
2025-08-08 10:50:09 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 10:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T10: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-08 10:50:10 [INFO]: Change: available | Delta: -1
2025-08-08 10:50:10 [INFO]: Change: on_hand | Delta: -1
2025-08-08 10:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 10:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44661315 and user_id = 14409 
2025-08-08 10:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77566535 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 10:50:10 [INFO]: Shopify Inventory id 48034582462686
2025-08-08 10:50:10 [INFO]: Shopify Location id 58450641063
2025-08-08 10:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 10:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T10:50:10Z","reason":"correction","changes":[{"name":"available","delta":-2},{"name":"on_hand","delta":-2}]},"userErrors":[]}},"extensions":{"cost":{"requestedQueryCost":11,"actualQueryCost":11,"throttleStatus":{"maximumAvailable":2000,"currentlyAvailable":1989,"restoreRate":100}}}}
2025-08-08 10:50:10 [INFO]: Change: available | Delta: -2
2025-08-08 10:50:10 [INFO]: Change: on_hand | Delta: -2
2025-08-08 10:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 10:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44658327 and user_id = 14409 
2025-08-08 10:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77563547 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 10:50:10 [INFO]: Shopify Inventory id 48034603237598
2025-08-08 10:50:10 [INFO]: Shopify Location id 58450641063
2025-08-08 10:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-08 10:50:10 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-08T10: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-08 10:50:10 [INFO]: Change: available | Delta: -1
2025-08-08 10:50:10 [INFO]: Change: on_hand | Delta: -1
2025-08-08 10:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-08 10:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44649195 and user_id = 14409 
2025-08-08 10:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77554384 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-08 10:50:10 [INFO]: updateIdsQuantity -> ["77566535","77563547","77554384"]
2025-08-08 10:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3
2025-08-08 10:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77566535 THEN 0 WHEN id = 77563547 THEN 0 WHEN id = 77554384 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77566535 THEN 0 WHEN id = 77563547 THEN 0 WHEN id = 77554384 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77566535,77563547,77554384)
2025-08-08 10:50:10 [INFO]: QUANTITY Updated IDs: 77566535, 77563547, 77554384
2025-08-08 10:50:10 [INFO]: Successfully processed data for user 14409
2025-08-08 10:50:10 [INFO]: Execution Started
2025-08-08 10:50:10 [INFO]: Execution Finished