2025-08-04 21:00:01 [INFO]: Execution Started
2025-08-04 21:00:01 [INFO]: old server sucessfully connected
2025-08-04 21:00:01 [INFO]: sqs client sucess created
2025-08-04 21:00:02 [INFO]: Number of messages in the queue: 0
2025-08-04 21:00:23 [INFO]: Execution Started
2025-08-04 21:00:23 [INFO]: Execution Finished
2025-08-04 21:10:02 [INFO]: Execution Started
2025-08-04 21:10:02 [INFO]: old server sucessfully connected
2025-08-04 21:10:02 [INFO]: sqs client sucess created
2025-08-04 21:10:03 [INFO]: Number of messages in the queue: 2
2025-08-04 21:10:03 [INFO]: item found in queue is if condition  14409
2025-08-04 21:10:03 [INFO]: item found in queue is  14409
2025-08-04 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBPBOF2vwU2xKzI9/FqItOBdJnXaLTjBQoPg6Frt2BEUSHE0ccceo6WNmlZ+KHm4xAzSN/JE+Y3OPh5BsBsHCCY3UxBF6Q8CdRFXWd476E6V6Pt2Nwb4wqSLZkwXvgQbuMMpLYH2ezgHOQQnXPH8M8ssq6EgcMxkpOkARo5WJOvuFCakz0mwxLQKWr0JcTk7ptR8U2kMcbI8GFnLdkAr5FklT7TXQXLh8GPbGxkNHE4mrq343cit6FuPQGjyz8njSLZEzgGmu1amgldaNIePOlVpOXBWmfLSOe/1nreWs/AwHK87eMrFjG8r96/QhgNwgrjyYRFjViqTpBcSXz5w4grojlQ1LV1CmQ6Mqf+e4Wlcan23avKQir959oZWSKVPVBB4cQbO/dUQtNg+pu8WTDUPhd+f2bJgceq8J/H1OeQsvCL9TWqOglma7jJTQcfcNV
2025-08-04 21:10:04 [INFO]: item found in queue is if condition  14409
2025-08-04 21:10:04 [INFO]: item found in queue is  14409
2025-08-04 21:10:04 [INFO]: Message deleted from the queue for receipt handle: AQEBl6JUUqaZzQLh29TlGIzp0n3sLZCfTtav+GRWWi5SGkbWL8ixkoLE0DbEWP8jKbWQLHDJw3kcjdwxhzTSxlGcmNQy1g8WsGmaYHOLhVpBQNAkPFN/7ZlXAcVsHICF3wWoJUSItzfBc4xbcjYk5lk4ZmNo9hCxUpwP35UP6iI+lCzxslqRkJY1Q0mD545MA81RbBcfWbua0OTVkR2ODd8K4S7oKQ+ewzsjtBnygJujdUkCiZEQs7hJD6B3X1EH9xzJ/OB5lj/ryyEkdUx79XQ/4LUZ+jg+Od6zHMryb8OwkTMaMI5/QETz3yaIjz6Mp92YWf6rirtKaIV/aNfDb6FMW9yG4y9Ex1YqwO7iFwXWKojNWCtH++Q7pkshIurpGJ6gJoCLGRSVMDcadlTcyfwWHEmV4gPr8btrqyt2+SXyhRuicNUl3fzfI5ELMkb2gcfi
2025-08-04 21:10:04 [INFO]: Processed 2 messages, reached the limit of 2.
2025-08-04 21:10:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 21:10:04 [INFO]: inside itemsold and closed 14409
2025-08-04 21:10:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:10:06 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:10:06 [INFO]: Ebay item id :: 306150861313 exists in Database
2025-08-04 21:10:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 21:10:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 21:10:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 21:10:06 [INFO]: inside itemsold and closed 14409
2025-08-04 21:10:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:10:08 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:10:08 [INFO]: Ebay item id :: 406088532980 exists in Database
2025-08-04 21:10:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 21:10:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-04 21:10:08 [INFO]: in processold action queue is array    for {"44600127":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44600127","ebayitemid":"306150861313","shopifyproductid":"8832194904286","variants":[{"price":"160.19","quantity":0,"weight":"15","shopifyproductid":"8832194904286","shopifyvariantid":"46333807395038","shopifyinventoryid":"48435126141150","shopifylocationid":"","product_id":"44600127","variant_id":"77492836","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45184132":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45184132","ebayitemid":"406088532980","deleted":1}}}
2025-08-04 21:10:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 21:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 21:10:08 [INFO]: productIds WHich are having null productid -> [45184132]
2025-08-04 21:10:08 [INFO]: ebayItemIds WHich are not imported-> ["406088532980"]
2025-08-04 21:10:08 [INFO]: Entered in bulkUpdateProducts function
2025-08-04 21:10:08 [INFO]: Transaction started for bulkUpdateProducts
2025-08-04 21:10:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45184132)
2025-08-04 21:10:08 [INFO]: Query executed successfully. Affected rows: 0
2025-08-04 21:10:08 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-04 21:10:08 [INFO]: Transaction committed successfully.
2025-08-04 21:10:08 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-04 21:10:08 [INFO]: Shopify Inventory id 48435126141150
2025-08-04 21:10:08 [INFO]: Shopify Location id 58450641063
2025-08-04 21:10:08 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 21:10:08 [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 21:10:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 21:10:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44600127 and user_id = 14409 
2025-08-04 21:10:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77492836 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 21:10:08 [INFO]: updateIdsQuantity -> ["77492836"]
2025-08-04 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 0
2025-08-04 21:10:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77492836 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77492836 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77492836)
2025-08-04 21:10:08 [INFO]: QUANTITY Updated IDs: 
2025-08-04 21:10:08 [INFO]: Successfully processed data for user 14409
2025-08-04 21:10:08 [INFO]: Execution Started
2025-08-04 21:10:08 [INFO]: Execution Finished
2025-08-04 21:20:01 [INFO]: Execution Started
2025-08-04 21:20:01 [INFO]: old server sucessfully connected
2025-08-04 21:20:01 [INFO]: sqs client sucess created
2025-08-04 21:20:02 [INFO]: Number of messages in the queue: 1
2025-08-04 21:20:02 [INFO]: item found in queue is if condition  14409
2025-08-04 21:20:02 [INFO]: item found in queue is  14409
2025-08-04 21:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBb+YgDULVruyKby9UKfVguuKaCGIJ3P1F6Zmxg49o5K1NsrD0o0GDuhukC+pHGPwJo3heIxeyigYezJJVn39LD7/zvfNzO0MRUOynhPlYA9RLjH5WFS2ViD69MBYy+9Q/wDHkmdi07EgTu9cNv7g1aRpYmGGGWRHfp/rjMUWVp2R9JQYxmAxbNhzWAEXfnzypTo6ikqOwtO8mv67YmIrTicAM4KKDISYQfvFYzG9oD4IRSGgryaBHc4HQldHqWhSa0Hx7Biy14yqfxZFwLSYWaBA3ZKHA7y9lmWL01OAi3tJdtEaiKzk47p77Ik7prmEsf9UqPi6Ou8mKrY2gCBCxwMLIY9hCk00TNlMgR3DBbAHDBkbjiFiW/+85NKp+yGKL2cKIWak5J80F3i8iKrPh7qCHMZwJ3UeR1OzoE17ahux9s6W+QEuOBHfe8fEiTaC2
2025-08-04 21:20:03 [INFO]: Processed 1 messages, reached the limit of 1.
2025-08-04 21:20:03 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 21:20:03 [INFO]: inside itemsold and closed 14409
2025-08-04 21:20:04 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:20:04 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:20:04 [INFO]: not in db for user_id 14409 and the ebayitemid336088586771
2025-08-04 21:20:04 [INFO]: in processold action queue is array    for []
2025-08-04 21:20:04 [INFO]: Successfully processed data for user 14409
2025-08-04 21:20:04 [INFO]: Execution Started
2025-08-04 21:20:04 [INFO]: Execution Finished
2025-08-04 21:30:01 [INFO]: Execution Started
2025-08-04 21:30:01 [INFO]: old server sucessfully connected
2025-08-04 21:30:01 [INFO]: sqs client sucess created
2025-08-04 21:30:02 [INFO]: Number of messages in the queue: 0
2025-08-04 21:30:22 [INFO]: Execution Started
2025-08-04 21:30:22 [INFO]: Execution Finished
2025-08-04 21:40:02 [INFO]: Execution Started
2025-08-04 21:40:02 [INFO]: old server sucessfully connected
2025-08-04 21:40:02 [INFO]: sqs client sucess created
2025-08-04 21:40:03 [INFO]: Number of messages in the queue: 0
2025-08-04 21:40:23 [INFO]: Execution Started
2025-08-04 21:40:23 [INFO]: Execution Finished
2025-08-04 21:50:01 [INFO]: Execution Started
2025-08-04 21:50:01 [INFO]: old server sucessfully connected
2025-08-04 21:50:01 [INFO]: sqs client sucess created
2025-08-04 21:50:03 [INFO]: Number of messages in the queue: 3
2025-08-04 21:50:03 [INFO]: item found in queue is if condition  14409
2025-08-04 21:50:03 [INFO]: item found in queue is  14409
2025-08-04 21:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEBWy0iq4jKm3vmuSVjBEKGPNh8OnnJnW7esCnI5OuG0ULyC4UNP60jLuZO7vlLc1czWVR0/suE2V2FftsFVi5aD1ZDSWerYwuYAD9SmSMW+gqExT1lW0yR9iUw5/Tzdys9JPXqGDEyvGSzC6kTjn4+6QhC8ELwrs1XhR8Y0ts1NqetPr5+Zj+W+KgpIwdeEn7Az+uLws2z5VP3yjO1s2u/TGTEmfEnA793HolX4ADKOtANN1RBboxF7Zs/92dcadi4BlYsrfQkERKaJ+DnThrULHY5e1OLMir4z1b2tTHveiIZM4bl7xLvYKyIx8AV4UQUlnZolKzOnoQT671v5DVhNVv7PtzaqAZK0KhJfJ6FAK8tw4pmHezqH+5Oj5+f2aPTdAlgDSyZC+7e8Wpu7jTdYa10BROHXl50AIhXwDHLCPbIY9ChZzXpCCBnUPEwaZn7
2025-08-04 21:50:03 [INFO]: item found in queue is if condition  14409
2025-08-04 21:50:03 [INFO]: item found in queue is  14409
2025-08-04 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEBqRBuCAIiUaqSixa3SQ/OZuFx26ROauJAwWH7a9cYkHjVOZdN2T7VXQTMCu4ga8rpMtVlvMpCDBWtUW7iw3wGKy+yii95efpRP8g4rjgJyZV3hpeechbn1xtUGMrrUhVH3+85VKI0M0OM2thLkiuQ6ORzo+VbldkLCtOkp6f3sGPIeYgA8Q9TN6FTOtZBQX5A5Y7Iyfc7SwI2unYLEBylE2uQWaE+EOJq1pozEJ/Fuc4F1SkGP8BBZHFwTQJmO7Jad9UD9xxm8kNiClpvPGJ4IyDrBzIzJ7cYqCYBUSeiAqNUy1RAQluo3F2vCDz43nEqlKmEtzFDiq5ZnP2ypcr2OZ+ZBv2ps9Fdm4iYRsg+qtk7LU77AmAi7g0HuhcpRP9rkDFph+CcigN1tVJIBHi8myS/WYby/KXmwhEGNzgyyMda1wxcuQy9eZiEBas4ZhiO
2025-08-04 21:50:04 [INFO]: item found in queue is if condition  14409
2025-08-04 21:50:04 [INFO]: item found in queue is  14409
2025-08-04 21:50:04 [INFO]: Message deleted from the queue for receipt handle: AQEB3daoNqhj/yX8oXBfddgtuGprX7A7PUAyQHMGNh7dcSO2JZpNplpjRhpzR1FkjsJCBv+vNB+sj+J+xI2ADbjvCApQs2c1bMpNK7iuLq0V9J/mAwPgQl70XTbwcTupnxxxsgKRGhbiEqdJgF0rJ60PIzuLXcz1LnicvYIua45MOuMR5STsJ1Z2Yzqb00H4TzaPAylvNX4d70OyrQl1j5yS3xiaKRMf0niCUcZXNeqNtdOr6TVHRXb/3k7OUKgTIMVN0QRacQjyBH69IeR74eyGFDvRgUi3ZdKQLEQMyfvUkfWgi8l6hGhH+hGgE8/crCYDDHOgCA2bF26AygvL9o5uwoNwJgxCdEI5LJF3fOBAqhw+mGsSfI9nroJcSAqxZKBhOOjpYFlTfv/zrBArIMaUPtpNP1hKCIjIGsIQsWgT0xjImgNVcULxMfuyLR3MXnGk
2025-08-04 21:50:04 [INFO]: Processed 3 messages, reached the limit of 3.
2025-08-04 21:50:04 [WARNING]:  actionquee araye for user_id is 14409 and  []
2025-08-04 21:50:04 [INFO]: inside itemsold and closed 14409
2025-08-04 21:50:06 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:50:06 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:50:06 [INFO]: Ebay item id :: 336018017175 exists in Database
2025-08-04 21:50:06 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 21:50:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-04 21:50:06 [INFO]: inside itemsold and closed 14409
2025-08-04 21:50:08 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:50:08 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:50:08 [INFO]: Ebay item id :: 286730671488 exists in Database
2025-08-04 21:50:08 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 21:50:08 [INFO]: IF SHOPIFYPRODUCTID IS NULL
2025-08-04 21:50:08 [INFO]: inside itemsold and closed 14409
2025-08-04 21:50:10 [INFO]: autodelete for user_id 14409 is 0
2025-08-04 21:50:10 [INFO]: autolink for user_id 14409 is 1
2025-08-04 21:50:10 [INFO]: Ebay item id :: 286441813045 exists in Database
2025-08-04 21:50:10 [INFO]: Item is reliested  ::  exists in Database
2025-08-04 21:50:10 [INFO]: THE CURRENT DATA FOR TO PROCESS 
2025-08-04 21:50:10 [CONDITION]: IF quantity in database is not 0 then this will update the quantity
2025-08-04 21:50:10 [INFO]: in processold action queue is array    for {"45115683":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45115683","ebayitemid":"336018017175","deleted":1}},"45296834":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45296834","ebayitemid":"286730671488","deleted":1}},"44685519":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44685519","ebayitemid":"286441813045","shopifyproductid":"8857387008222","variants":[{"price":"9.90","quantity":0,"weight":"1","shopifyproductid":"8857387008222","shopifyvariantid":"46494318002398","shopifyinventoryid":"48596528988382","shopifylocationid":"","product_id":"44685519","variant_id":"77590744","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}}
2025-08-04 21:50:10 [INFO]: ENETER IN PROCESS UPDATE BACKUP   
2025-08-04 21:50:10 [INFO]: PRODUCT HAS QUANTITY FLAG
2025-08-04 21:50:10 [INFO]: productIds WHich are having null productid -> [45115683,45296834]
2025-08-04 21:50:10 [INFO]: ebayItemIds WHich are not imported-> ["336018017175","286730671488"]
2025-08-04 21:50:10 [INFO]: Entered in bulkUpdateProducts function
2025-08-04 21:50:10 [INFO]: Transaction started for bulkUpdateProducts
2025-08-04 21:50:10 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45115683,45296834)
2025-08-04 21:50:10 [INFO]: Query executed successfully. Affected rows: 0
2025-08-04 21:50:10 [WARNING]: No rows affected by the query. Check conditions or input data.
2025-08-04 21:50:10 [INFO]: Transaction committed successfully.
2025-08-04 21:50:10 [INFO]: Transaction ended for bulkUpdateProducts
2025-08-04 21:50:10 [INFO]: Shopify Inventory id 48596528988382
2025-08-04 21:50:10 [INFO]: Shopify Location id 58450641063
2025-08-04 21:50:10 [INFO]: QUANTITY FOR UPDATE 0
2025-08-04 21: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 21:50:10 [INFO]: HERE IS RESPONSE FROM SHOPIFY true
2025-08-04 21:50:10 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44685519 and user_id = 14409 
2025-08-04 21:50:10 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77590744 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY
2025-08-04 21:50:10 [INFO]: updateIdsQuantity -> ["77590744"]
2025-08-04 21:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1
2025-08-04 21:50:10 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants 
				  SET 
					  quantity = CASE WHEN id = 77590744 THEN 0  END, 
					  quantityflag = CASE WHEN id = 77590744 THEN 0  END 
				  WHERE user_id = 14409 AND id IN (77590744)
2025-08-04 21:50:10 [INFO]: QUANTITY Updated IDs: 77590744
2025-08-04 21:50:10 [INFO]: Successfully processed data for user 14409
2025-08-04 21:50:10 [INFO]: Execution Started
2025-08-04 21:50:10 [INFO]: Execution Finished