2025-08-15 05:00:02 [INFO]: Execution Started
2025-08-15 05:00:02 [INFO]: old server sucessfully connected
2025-08-15 05:00:02 [INFO]: sqs client sucess created
2025-08-15 05:00:03 [INFO]: Number of messages in the queue: 1
2025-08-15 05:00:03 [INFO]: item found in queue is if condition  14409
2025-08-15 05:00:03 [INFO]: item found in queue is  14409
2025-08-15 05:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBtm8qOZoLMVMvWeJ/DX3+E2+SOLBxBcrw/q1J94Efw2n2LXednfpj8btmirXIhwxP+JutlOap2clf2Pl676kCJsXAy+rhxJPJyUMNXGu/5r3Sj9+WlZsWeg+enYnZOVNKZUycLKDgb1m1CWGFQRLE8ntyL2CnXFE9zuNcM3KN/IBJ10HY7qtm5QS4y9Cihdij66NcQVOcytQa6+3CoowkaqXZSlEosZte+qUa8FmzzYs/Ik7f+k5sldfGJObmRWwQ/FOsll7XsI/91bzy0MuNvp+VJR689doEH7g9swS2rMRSs1Jhq304edwWAXBXO2ntYZOO43U7nhR8vlh2bEeqVByz7n72CegtTAar1ihwkOiNBIIE2X5ft4AfNFyvNDi2pJ+IA+3aqFWtWMHF4ngj4WqFTq+6mxApiGyolUYbeEC4H4MpWXsJgkH5g3WZ1+BI
2025-08-15 05:00:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-15 05:00:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-15 05:00:03 [INFO]: inside itemsold and closed 14409
2025-08-15 05:00:05 [INFO]: autodelete for user_id 14409 is 0
2025-08-15 05:00:05 [INFO]: autolink for user_id 14409 is 1
2025-08-15 05:00:05 [INFO]: Ebay item id :: 286480150555 exists in Database
2025-08-15 05:00:05 [INFO]: Item is reliested  ::  exists in Database
2025-08-15 05:00:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-15 05:00:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-15 05:00:05 [INFO]: in processold action queue is array    for {"44568676":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44568676","ebayitemid":"286480150555","shopifyproductid":"8073949315294","variants":[{"price":"160.55","quantity":0,"weight":"35","shopifyproductid":"8073949315294","shopifyvariantid":"44249627459806","shopifyinventoryid":"46346781720798","shopifylocationid":"","product_id":"44568676","variant_id":"77461360","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-15 05:00:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-15 05:00:06 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-15 05:00:06 [INFO]: Shopify Inventory id 46346781720798
2025-08-15 05:00:06 [INFO]: Shopify Location id 58450641063
2025-08-15 05:00:06 [INFO]: QUANTITY FOR UPDATE 0
2025-08-15 05:00:06 [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-15 05:00:06 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-15 05:00:06 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44568676 and user_id = 14409 
2025-08-15 05:00:06 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77461360 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-15 05:00:06 [INFO]: updateIdsQuantity -> ["77461360"]
2025-08-15 05:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-15 05:00:06 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77461360 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77461360 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77461360)
2025-08-15 05:00:06 [INFO]: QUANTITY Updated IDs: 77461360
2025-08-15 05:00:06 [INFO]: Successfully processed data for user 14409
2025-08-15 05:00:06 [INFO]: Execution Started
2025-08-15 05:00:06 [INFO]: Execution Finished
2025-08-15 05:10:01 [INFO]: Execution Started
2025-08-15 05:10:01 [INFO]: old server sucessfully connected
2025-08-15 05:10:01 [INFO]: sqs client sucess created
2025-08-15 05:10:02 [INFO]: Number of messages in the queue: 0
2025-08-15 05:10:23 [INFO]: Execution Started
2025-08-15 05:10:23 [INFO]: Execution Finished
2025-08-15 05:20:01 [INFO]: Execution Started
2025-08-15 05:20:01 [INFO]: old server sucessfully connected
2025-08-15 05:20:01 [INFO]: sqs client sucess created
2025-08-15 05:20:03 [INFO]: Number of messages in the queue: 0
2025-08-15 05:20:23 [INFO]: Execution Started
2025-08-15 05:20:23 [INFO]: Execution Finished
2025-08-15 05:30:01 [INFO]: Execution Started
2025-08-15 05:30:01 [INFO]: old server sucessfully connected
2025-08-15 05:30:01 [INFO]: sqs client sucess created
2025-08-15 05:30:03 [INFO]: Number of messages in the queue: 1
2025-08-15 05:30:04 [INFO]: item found in queue is if condition  14409
2025-08-15 05:30:04 [INFO]: item found in queue is  14409
2025-08-15 05:30:04 [INFO]: Message deleted from the queue for receipt handle: AQEBejJErDuikp+CMzaHmenvYLNugp9WYCOpxRV4Q3Z0mCxsh0cWscsmF6saMnh8ApB+IuT4CRZdwNhz5in2lmst7Sd6oKTKEqfDFnZ7YMy0yiNTjrRvDFGdtKq5BTTvawCN6ppsJGJCgwr4aZozQciOQOOvDgfNvAGaXyWe6oXy75DtTG12osFBP3CdtQ2t9fm26yBKxlZiGQdTMpHxCV94RBwkMCGa/hls7CQqBh/dMBL4OZaYiRxoU6wVbWbMHhGgFpx5G8vBkbjyFWliJq29uOuOWWN5sVGPSZJjkv5t4+9v4fjZGlYZKK1upXuYHENPu5pd1ExgR6bh8uDhchd3NG1A6FVD4faIDbqsLMvVOHRcnPzidJC1SpaeOnwitfrmKWQUIgeur3aNQCw9BTzIMoEwQ56QFX7nD9U0LeyrB+oHTVpt7+MrM5VxbQ+JAzQo
2025-08-15 05:30:04 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-15 05:30:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-15 05:30:04 [INFO]: inside itemsold and closed 14409
2025-08-15 05:30:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-15 05:30:06 [INFO]: autolink for user_id 14409 is 1
2025-08-15 05:30:06 [INFO]: Ebay item id :: 336005143896 exists in Database
2025-08-15 05:30:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-15 05:30:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-15 05:30:06 [INFO]: in processold action queue is array    for {"45113616":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45113616","ebayitemid":"336005143896","deleted":1}}}
2025-08-15 05:30:06 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-15 05:30:06 [INFO]: productIds WHich are having null productid -> [45113616]
2025-08-15 05:30:06 [INFO]: ebayItemIds WHich are not imported-> ["336005143896"]
2025-08-15 05:30:06 [INFO]: Entered in bulkUpdateProducts function
2025-08-15 05:30:06 [INFO]: Transaction started for bulkUpdateProducts
2025-08-15 05:30:06 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45113616)
2025-08-15 05:30:06 [INFO]: Query executed successfully. Affected rows: 0
2025-08-15 05:30:06 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-15 05:30:06 [INFO]: Transaction committed successfully.
2025-08-15 05:30:06 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-15 05:30:06 [INFO]: Successfully processed data for user 14409
2025-08-15 05:30:06 [INFO]: Execution Started
2025-08-15 05:30:06 [INFO]: Execution Finished
2025-08-15 05:40:01 [INFO]: Execution Started
2025-08-15 05:40:01 [INFO]: old server sucessfully connected
2025-08-15 05:40:01 [INFO]: sqs client sucess created
2025-08-15 05:40:02 [INFO]: Number of messages in the queue: 0
2025-08-15 05:40:23 [INFO]: Execution Started
2025-08-15 05:40:23 [INFO]: Execution Finished
2025-08-15 05:50:01 [INFO]: Execution Started
2025-08-15 05:50:01 [INFO]: old server sucessfully connected
2025-08-15 05:50:01 [INFO]: sqs client sucess created
2025-08-15 05:50:02 [INFO]: Number of messages in the queue: 0
2025-08-15 05:50:23 [INFO]: Execution Started
2025-08-15 05:50:23 [INFO]: Execution Finished