2025-08-04 20:00:01 [INFO]: Execution Started 2025-08-04 20:00:01 [INFO]: old server sucessfully connected 2025-08-04 20:00:01 [INFO]: sqs client sucess created 2025-08-04 20:00:02 [INFO]: Number of messages in the queue: 4 2025-08-04 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 20:00:03 [INFO]: item found in queue is 14409 2025-08-04 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEBJFo+FyE6KhNRSGaXDbL0dzrKf7xbrWhYixPsJKYNXfdQ6Zktk8r7e6X7t/Qp2U8hbYnp8QNUXv/Y3pQzNRSRHAa1qkZVUuNeFcseBtixxAe2YDnTtFTHM6MxwdEkUy5gssZoH2K5OAATfX8hToO7K14WhAwIAA11H6O70JSOEJm9yUqqBT+djc5dCqY9rAj/PXlqEXfeQYiFZJ5NSu6FwBbEfpRblF6odhVEvLRGJybMOfu71qXDjFn8+fzSgq7OxSjl9VT826QM4S5AipoIlv4kvkw4hUHfEMEhVfK3WPJRmw1fedUpDYukEDEoU+ZVE0k6crKp0EMgf+bKFHvHDRGd57arf2yx1o55gk+2Pgcxm+8Nge3kwBI5iemkLJl81GepMlsPfxLS63XV5MPIeKF22Wr+ZmwFzad5AEqXQCOzIMVOz4z6ZsZr1LZCzF1Q 2025-08-04 20:00:03 [INFO]: item found in queue is if condition 14409 2025-08-04 20:00:03 [INFO]: item found in queue is 14409 2025-08-04 20:00:03 [INFO]: Message deleted from the queue for receipt handle: AQEB5OQGpVa0iqoWdSOqnIecQSjtPbHEtGVsDbGaJE6GlyJONjQeXkLcxJtmdkoEUHlVcbO6yDKGhI1t+H64uzHAdG6OjFFDquSarigg9l8dnOJ5yseoj4iKCBshZcZ6CKfLh2ke3DX6EV1Q0GZoqU11jMlD3aqne4Vj+7Wy0hCxL1JjM4uS0vJ96Gas+j48zHRk7Q7A6MqVe46dxgELLsqni7Sb6pqKgf6sYIO1TIw/idCGivqs5ktMmi78IxbSU7BuZpZQYDY3A7zJ0PVZwIF2uGGbezgPV1r8aXc1TOeFAv96pn9i+kKzvU+wga1LUXQbFiod6EiilmNlniuVAE5Mr0J1Em4wzCKfbKKcHjQaAOntFB1cPW/JYnzp7Q28kq3dsOun2vC/uGgidtKLQlgIpO/EeP3ZFOAPDgSFW3EJKxE5Yc90XAzqw8hMFZ5GvmHU 2025-08-04 20:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 20:00:04 [INFO]: item found in queue is 14409 2025-08-04 20:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEBLPGZ5NIiPhSl+fylgjCwPRVRkT024NM7H95R/gTHsvR4A0Be6UgJIO/5CZr0Kk/qZ7BmZp2M69WiwByG5vjlxotx9SIMhPW8c4JKRlNp3ir9k6njYJHPV1ZpQZc9JwMfDIqNEHN/73pzUjHdYf0l8HD9xtN/EJocSM4HW3vLwmzZwqNjpd9gFgstN6ctK9FgqKhcqblosYHhjT6Pgl2RdFLHwhS1CSx8qI8w+GpwSTLPtrzjPN6XjEXLRtf57J3eo1mLhjzPEW2/58PTCsrUe165OwqflLEU5NRK+No3fG2CtY3IA9Ow8WiCYURJhvmHmfuDzRjl6XMXaqKsIGHTMBNSmFy7urAouaIPs3JW9O9Bf3Yn9ZYI1VVS0XsWFP9w8e1Gub3cjxv7hhPuqLofTEeCH6AVpLbiRnIwogkI86qxTIqQMwZtAaVH7E1uzmAe 2025-08-04 20:00:04 [INFO]: item found in queue is if condition 14409 2025-08-04 20:00:04 [INFO]: item found in queue is 14409 2025-08-04 20:00:04 [INFO]: Message deleted from the queue for receipt handle: AQEB8GI6jZhZt63qji5F2z+iLM6B7TW19uyoRxpKSxuiy4c4Gt3j5YHYiwYWr91XtCyIVCICridS5B+jWlCkNH3kWEeDWXbyfQXYjIdzRkestZnjDJ+zaSg3+udO4HUlIdtXKcpNXXsuikriopNlUYBOOnKbMMj+vqPRjL3/b2fGxoHjYbwhscaO/Gx0oXPWMRaMaLS52qHUMsYOoA+NmVlhVUwOw8e+Hcs5/7cY52y131NApvtI9mBdRXbLwOCAR8Nd9Gg/zO5dhSMDbPZAm56J097776hUcu5IguCFObhdaBfWgzDX+C/AjFmEfFBm7Z7XBPQ4rexf2cCEm5x5iEnOLi6rvZdpy2wnbqn3Wt402ceWjlNH3B1A2JjIhIHh0DuOn+iqpGx3Bzxz3LWMjE+0h5NldneKRQ7Hi0l2pT6Z2/7QXul6E1C0na+ca0A3nEEI 2025-08-04 20:00:04 [INFO]: Processed 4 messages, reached the limit of 4. 2025-08-04 20:00:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 20:00:04 [INFO]: inside itemsold and closed 14409 2025-08-04 20:00:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:00:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:00:06 [INFO]: Ebay item id :: 305951414759 exists in Database 2025-08-04 20:00:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:00:06 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:00:06 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:00:06 [INFO]: inside itemsold and closed 14409 2025-08-04 20:00:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:00:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:00:08 [INFO]: Ebay item id :: 286197720944 exists in Database 2025-08-04 20:00:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:00:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:00:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:00:08 [INFO]: inside itemsold and closed 14409 2025-08-04 20:00:09 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:00:09 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:00:09 [INFO]: Ebay item id :: 305406822566 exists in Database 2025-08-04 20:00:09 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:00:09 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:00:09 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:00:09 [INFO]: inside itemsold and closed 14409 2025-08-04 20:00:11 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:00:11 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:00:11 [INFO]: Ebay item id :: 335946352837 exists in Database 2025-08-04 20:00:11 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:00:11 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 20:00:11 [INFO]: in processold action queue is array for {"44556371":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556371","ebayitemid":"305951414759","shopifyproductid":"8123669709022","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"8123669709022","shopifyvariantid":"44337319411934","shopifyinventoryid":"46435004088542","shopifylocationid":"","product_id":"44556371","variant_id":"77449051","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44556369":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44556369","ebayitemid":"286197720944","shopifyproductid":"8019806257374","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"8019806257374","shopifyvariantid":"44149746991326","shopifyinventoryid":"46246710083806","shopifylocationid":"","product_id":"44556369","variant_id":"77449049","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44584497":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44584497","ebayitemid":"305406822566","shopifyproductid":"7611302412510","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"7611302412510","shopifyvariantid":"42648299995358","shopifyinventoryid":"44742398443742","shopifylocationid":"","product_id":"44584497","variant_id":"77477206","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"45141211":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45141211","ebayitemid":"335946352837","deleted":1}}} 2025-08-04 20:00:11 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 20:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:00:11 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:00:11 [INFO]: productIds WHich are having null productid -> [45141211] 2025-08-04 20:00:11 [INFO]: ebayItemIds WHich are not imported-> ["335946352837"] 2025-08-04 20:00:11 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 20:00:11 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 20:00:11 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45141211) 2025-08-04 20:00:11 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 20:00:11 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 20:00:11 [INFO]: Transaction committed successfully. 2025-08-04 20:00:11 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 20:00:11 [INFO]: Shopify Inventory id 46435004088542 2025-08-04 20:00:11 [INFO]: Shopify Location id 58450641063 2025-08-04 20:00:11 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20: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 20:00:12 [INFO]: Change: available | Delta: -1 2025-08-04 20:00:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556371 and user_id = 14409 2025-08-04 20:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449051 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:00:12 [INFO]: Shopify Inventory id 46246710083806 2025-08-04 20:00:12 [INFO]: Shopify Location id 58450641063 2025-08-04 20:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:00:12Z","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 20:00:12 [INFO]: Change: available | Delta: -1 2025-08-04 20:00:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44556369 and user_id = 14409 2025-08-04 20:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77449049 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:00:12 [INFO]: Shopify Inventory id 44742398443742 2025-08-04 20:00:12 [INFO]: Shopify Location id 58450641063 2025-08-04 20:00:12 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:00:12 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:00:12Z","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 20:00:12 [INFO]: Change: available | Delta: -1 2025-08-04 20:00:12 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:00:12 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:00:12 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44584497 and user_id = 14409 2025-08-04 20:00:12 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77477206 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:00:12 [INFO]: updateIdsQuantity -> ["77449051","77449049","77477206"] 2025-08-04 20:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 20:00:12 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77449051 THEN 0 WHEN id = 77449049 THEN 0 WHEN id = 77477206 THEN 0 END, quantityflag = CASE WHEN id = 77449051 THEN 0 WHEN id = 77449049 THEN 0 WHEN id = 77477206 THEN 0 END WHERE user_id = 14409 AND id IN (77449051,77449049,77477206) 2025-08-04 20:00:12 [INFO]: QUANTITY Updated IDs: 77449051, 77449049, 77477206 2025-08-04 20:00:12 [INFO]: Successfully processed data for user 14409 2025-08-04 20:00:12 [INFO]: Execution Started 2025-08-04 20:00:12 [INFO]: Execution Finished 2025-08-04 20:10:01 [INFO]: Execution Started 2025-08-04 20:10:01 [INFO]: old server sucessfully connected 2025-08-04 20:10:01 [INFO]: sqs client sucess created 2025-08-04 20:10:02 [INFO]: Number of messages in the queue: 3 2025-08-04 20:10:02 [INFO]: item found in queue is if condition 14409 2025-08-04 20:10:02 [INFO]: item found in queue is 14409 2025-08-04 20:10:02 [INFO]: Message deleted from the queue for receipt handle: AQEBun6Y0ZrTEcMErVQrVjDc6raGYDqJXvKp4UDLOd5nejYqokqeE3Tw1FzC9SmRftigBh2YWDzcMWS0dOMfwXTPqRGWRTx93dFTPXWNjq1PfOB613uEauUT1H00IXvCRrLYCYyrWZ/h2BP6YtRg+S0dOq15vyQBnNH0DcEaCu4u/htP0t3wwRa/oo1H64HunHG5RuHwcPQUAl/Vn+QPO3sByz6k4+Alp0x47ssTTpZRMp9i5fbUrvb7TmBVQG0fm4H9cxFiReTAvVT0GTXaTQ5Mh0waIztg9d+oH9iocmTUGNDBLHT6Yzo13rJ/Ga8nYYDzKZCP2DhrLoRNmZ/sQG8f2woMrJhLdKq3DpHQZMqCDnyy+s5IYy+b40bK6pkdQpJZBysWAIrTQK7ZVUWW+HQ7MnYfyoPO7rTro/++J0t3hNlyF9liDgOXutbpeQ1aUKsH 2025-08-04 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 20:10:03 [INFO]: item found in queue is 14409 2025-08-04 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBd899QuDOwEVnnJvkW9Z1r8dRC5Sl09UWPyg7omgu9XMfLWtcA3HNyoHcU74VK3NWnsSvsWLhZNI3Vi2KMll/gbF0mRElZhAXjI73zDAP+HclcBvfJy7KvANMY1XRTinwKvedbhbyKuLlYF4k04gYBNNB7zK1m2PugLPQ/iNeYz2iFwLng5+ywMp0hB+pKLnzKIuWY6KelizMs8a9WIL1YH1NeuhO4mckxYHJsBXlhLMlGpFn+8Bcp3aB0zg+0jVpwD3v1xarINLL9RbVdEEqzar54zXUIRu9YfVhxk464kCgWWJEAfTfOAihjCm1GsrQF3YJAAxjlCUMk9stHpyOFdHpvKkFNCqII9uH0p6G3VBR9lIFeuyJYSwD6TqoZOcm8JZ6yBgbGMHjN2t6zQ4wRWItoF8oySigSngyjtKHzDOquCcFWgFu8DYk771iqoRW 2025-08-04 20:10:03 [INFO]: item found in queue is if condition 14409 2025-08-04 20:10:03 [INFO]: item found in queue is 14409 2025-08-04 20:10:03 [INFO]: Message deleted from the queue for receipt handle: AQEBd0v9NvC3QFdgMnRLMocHnSN/bOunK9DdLMFdf24FOxf0o8hwyKQKdxR+j1M3wS+pFkNplEwnkYWHTOoX60EGMXCCeHsr3OMxI+QSn7/EIt6yBIQyQ34C2UCBWzPFPeNcG8XRmuqQz4uoDpbmJvZ/djKSmvMZbvSUFbakH+b4GgWQ8gYXFB40EOvvKurUALYVzABZIsrTRIQ6UzFRMZo10FUCkrPZqfBwKsa8HTswrvAy68OqVYrxNJtiNjUA3gM+ToqhdID9j8LKNtxPrVz13mtF0Itc348YyL0K8ybg5DpRI2cA55Re0k+X24L5tIS0riSYY8gm/Ac9ECyccmsdcQsQTgoiLIVjcSXVZGmLC19Esnsglghp9Ts4wZr1J7cqCUu4pqx9ZEw7cOZ4H20B43MsLP010d587VDU5V0Ecb2grSFQ8/a3EWwZoFjD7bix 2025-08-04 20:10:03 [INFO]: Processed 3 messages, reached the limit of 3. 2025-08-04 20:10:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 20:10:03 [INFO]: inside itemsold and closed 14409 2025-08-04 20:10:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:10:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:10:05 [INFO]: Ebay item id :: 405824117522 exists in Database 2025-08-04 20:10:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:10:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:10:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:10:05 [INFO]: inside itemsold and closed 14409 2025-08-04 20:10:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:10:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:10:07 [INFO]: Ebay item id :: 284677706058 exists in Database 2025-08-04 20:10:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:10:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:10:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:10:07 [INFO]: inside itemsold and closed 14409 2025-08-04 20:10:08 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:10:08 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:10:08 [INFO]: Ebay item id :: 286184173170 exists in Database 2025-08-04 20:10:08 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:10:08 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:10:08 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:10:08 [INFO]: in processold action queue is array for {"44748634":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44748634","ebayitemid":"405824117522","shopifyproductid":"8021047345374","variants":[{"price":"13.99","quantity":0,"weight":"0.75","shopifyproductid":"8021047345374","shopifyvariantid":"44151969382622","shopifyinventoryid":"46248936571102","shopifylocationid":"","product_id":"44748634","variant_id":"77657110","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44756046":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44756046","ebayitemid":"284677706058","shopifyproductid":"7575692869854","variants":[{"price":"9.99","quantity":0,"weight":"0.5","shopifyproductid":"7575692869854","shopifyvariantid":"42527948701918","shopifyinventoryid":"44621941506270","shopifylocationid":"","product_id":"44756046","variant_id":"77664572","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}},"44592604":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44592604","ebayitemid":"286184173170","shopifyproductid":"7570789335262","variants":[{"price":"19.99","quantity":0,"weight":"1","shopifyproductid":"7570789335262","shopifyvariantid":"42511540027614","shopifyinventoryid":"44605537681630","shopifylocationid":"","product_id":"44592604","variant_id":"77485313","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 20:10:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 20:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:10:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:10:08 [INFO]: Shopify Inventory id 46248936571102 2025-08-04 20:10:08 [INFO]: Shopify Location id 58450641063 2025-08-04 20:10:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:10:09Z","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 20:10:09 [INFO]: Change: available | Delta: -1 2025-08-04 20:10:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44748634 and user_id = 14409 2025-08-04 20:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77657110 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:10:09 [INFO]: Shopify Inventory id 44621941506270 2025-08-04 20:10:09 [INFO]: Shopify Location id 58450641063 2025-08-04 20:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:10:09Z","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 20:10:09 [INFO]: Change: available | Delta: -1 2025-08-04 20:10:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44756046 and user_id = 14409 2025-08-04 20:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77664572 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:10:09 [INFO]: Shopify Inventory id 44605537681630 2025-08-04 20:10:09 [INFO]: Shopify Location id 58450641063 2025-08-04 20:10:09 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:10:09 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:10:09Z","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 20:10:09 [INFO]: Change: available | Delta: -1 2025-08-04 20:10:09 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:10:09 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:10:09 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44592604 and user_id = 14409 2025-08-04 20:10:09 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77485313 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:10:09 [INFO]: updateIdsQuantity -> ["77657110","77664572","77485313"] 2025-08-04 20:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 3. Affected rows: 3 2025-08-04 20:10:09 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77657110 THEN 0 WHEN id = 77664572 THEN 0 WHEN id = 77485313 THEN 0 END, quantityflag = CASE WHEN id = 77657110 THEN 0 WHEN id = 77664572 THEN 0 WHEN id = 77485313 THEN 0 END WHERE user_id = 14409 AND id IN (77657110,77664572,77485313) 2025-08-04 20:10:09 [INFO]: QUANTITY Updated IDs: 77657110, 77664572, 77485313 2025-08-04 20:10:09 [INFO]: Successfully processed data for user 14409 2025-08-04 20:10:09 [INFO]: Execution Started 2025-08-04 20:10:09 [INFO]: Execution Finished 2025-08-04 20:20:02 [INFO]: Execution Started 2025-08-04 20:20:02 [INFO]: old server sucessfully connected 2025-08-04 20:20:02 [INFO]: sqs client sucess created 2025-08-04 20:20:03 [INFO]: Number of messages in the queue: 2 2025-08-04 20:20:03 [INFO]: item found in queue is if condition 14409 2025-08-04 20:20:03 [INFO]: item found in queue is 14409 2025-08-04 20:20:03 [INFO]: Message deleted from the queue for receipt handle: AQEBAOf/KTxYTX5wQTYYsEma5YOOr/x/bX0uLvB4FwSfQSHBRGt+bLPnZcBIppUbWbL0Yss9TTQ9EGZvCQYa7BZyHKpxGDHv60c5iAiF+JeA0QBKyXBJBlqUcByx0qOiPLxAUuKDBrCoOWUAXSVN5LbnxUMJWfnxAlX09uN1VvTn8/dvalzH6Cr3VzCkVplvDiVbdOCwOfU584iIp0Wwd7d2NbUtdb5wq2RuR/g8Zd8POdchAAHcP1kfj4nC6HQBEZNkUb2dTv7zDQTuBIywtrGCDYx9tOWQC73g1COvd8YqUwJL/UPk+GN0FG+XjhI7U/R+k6mtOexsKe5QqiUmbxF9/NGBAQaL2u1V9Q3EBAzR2Z3Z0St+KKujNQRbjk+JcHVZJ60ktuV5eL/xZ50+Et3QAzJv6nkr+lx9ooa/JmrxJDsy8Be24whQcur3Jzfd4TCD 2025-08-04 20:20:04 [INFO]: item found in queue is if condition 14409 2025-08-04 20:20:04 [INFO]: item found in queue is 14409 2025-08-04 20:20:04 [INFO]: Message deleted from the queue for receipt handle: AQEBZoJLaEf9dZhZ05x4aLXEBd44nRceGGNfmi9NyHASUgFnB5wABuQ0pfXHvmGc3WJJS+zC/kNy1bzIY0w3fMOcWmCzVEgowfUaRQza7cO4ZHtC0AVU3g6E9JPbD/S9WrWoN22/PikiZGvl6dh3YQUkxwcLU6NoGj6Y0mWFn45i2y5yHiyACtbz0bd7Gzmpz14miKowJTNHYdpGx4gK2zs7m2402xNHNSlTNn61TG9cuMLapA+R15d3Q7fTv4jbJqs3ikeYDc9rcO3vv8MnLkXrSv0740jEGHQ1lE8xbAuQgnoQupcyuQkV7cySoFQ3K2S6nH5RTnWwgygdtPFP+IHVUmiiEKdcYqkBcGHnXIzvS/3bY9M3L63BWsKTI0Y4M9brHX+L5lcSSgVtW6vv1/s/B/CvROHgxJ9psrlluKwUzSbaOEoxTCLAclaUGiKEFWKC 2025-08-04 20:20:04 [INFO]: Processed 2 messages, reached the limit of 2. 2025-08-04 20:20:04 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 20:20:04 [INFO]: inside itemsold and closed 14409 2025-08-04 20:20:06 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:20:06 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:20:06 [INFO]: Ebay item id :: 286747641292 exists in Database 2025-08-04 20:20:06 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:20:06 [INFO]: IF SHOPIFYPRODUCTID IS NULL 2025-08-04 20:20:06 [INFO]: inside itemsold and closed 14409 2025-08-04 20:20:07 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:20:07 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:20:07 [INFO]: Ebay item id :: 305967172364 exists in Database 2025-08-04 20:20:07 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:20:07 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:20:07 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:20:07 [INFO]: in processold action queue is array for {"45313178":{"DELETEFROMDB":1,"DATAFORDELETE":{"product_id":"45313178","ebayitemid":"286747641292","deleted":1}},"44566874":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44566874","ebayitemid":"305967172364","shopifyproductid":"7868468920542","variants":[{"price":"18.99","quantity":0,"weight":"1","shopifyproductid":"7868468920542","shopifyvariantid":"43636537655518","shopifyinventoryid":"45732292788446","shopifylocationid":"","product_id":"44566874","variant_id":"77459554","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 20:20:08 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 20:20:08 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:20:08 [INFO]: productIds WHich are having null productid -> [45313178] 2025-08-04 20:20:08 [INFO]: ebayItemIds WHich are not imported-> ["286747641292"] 2025-08-04 20:20:08 [INFO]: Entered in bulkUpdateProducts function 2025-08-04 20:20:08 [INFO]: Transaction started for bulkUpdateProducts 2025-08-04 20:20:08 [INFO]: Executing query: UPDATE products SET deleted = 1 WHERE user_id = 14409 AND Status = 'ready to import' AND product_id IN (45313178) 2025-08-04 20:20:08 [INFO]: Query executed successfully. Affected rows: 0 2025-08-04 20:20:08 [WARNING]: No rows affected by the query. Check conditions or input data. 2025-08-04 20:20:08 [INFO]: Transaction committed successfully. 2025-08-04 20:20:08 [INFO]: Transaction ended for bulkUpdateProducts 2025-08-04 20:20:08 [INFO]: Shopify Inventory id 45732292788446 2025-08-04 20:20:08 [INFO]: Shopify Location id 58450641063 2025-08-04 20:20:08 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:20:08 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:20: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-04 20:20:08 [INFO]: Change: available | Delta: -1 2025-08-04 20:20:08 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:20:08 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:20:08 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44566874 and user_id = 14409 2025-08-04 20:20:08 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77459554 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:20:08 [INFO]: updateIdsQuantity -> ["77459554"] 2025-08-04 20:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 20:20:08 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77459554 THEN 0 END, quantityflag = CASE WHEN id = 77459554 THEN 0 END WHERE user_id = 14409 AND id IN (77459554) 2025-08-04 20:20:08 [INFO]: QUANTITY Updated IDs: 77459554 2025-08-04 20:20:08 [INFO]: Successfully processed data for user 14409 2025-08-04 20:20:08 [INFO]: Execution Started 2025-08-04 20:20:08 [INFO]: Execution Finished 2025-08-04 20:30:01 [INFO]: Execution Started 2025-08-04 20:30:01 [INFO]: old server sucessfully connected 2025-08-04 20:30:01 [INFO]: sqs client sucess created 2025-08-04 20:30:02 [INFO]: Number of messages in the queue: 0 2025-08-04 20:30:23 [INFO]: Execution Started 2025-08-04 20:30:23 [INFO]: Execution Finished 2025-08-04 20:40:01 [INFO]: Execution Started 2025-08-04 20:40:01 [INFO]: old server sucessfully connected 2025-08-04 20:40:01 [INFO]: sqs client sucess created 2025-08-04 20:40:02 [INFO]: Number of messages in the queue: 0 2025-08-04 20:40:23 [INFO]: Execution Started 2025-08-04 20:40:23 [INFO]: Execution Finished 2025-08-04 20:50:01 [INFO]: Execution Started 2025-08-04 20:50:01 [INFO]: old server sucessfully connected 2025-08-04 20:50:01 [INFO]: sqs client sucess created 2025-08-04 20:50:02 [INFO]: Number of messages in the queue: 1 2025-08-04 20:50:02 [INFO]: item found in queue is if condition 14409 2025-08-04 20:50:02 [INFO]: item found in queue is 14409 2025-08-04 20:50:03 [INFO]: Message deleted from the queue for receipt handle: AQEB5gHgHzcag3pvBufFPV5miR9qqvX6TBz4xrtcjDGl0Tjx++TUp/QK/2HhIDydZxqbIWA5vukHBx53SBYL0k3h47Guw7RigXc5QfKmwWspnstp7ycFjOo/GlmgCkqruoCR9PqlguSXFMZ8EylVEK6LeSWO6WFWeHv/HoAUPBOztMP9KaiNK2blPb+D/eVPv5lI8KF8i3Ym/f6YfgfgJkoC6wxj6sJllIFHv/1CIKo4Hb+C2QDWrvmrcs2HBh9TygCGH6Fkd9JH+3AqZWpeJMqPHhz7y8uKFeMtdC5B54EtjUqS+QWm8cuDkMYULcdiJrkIpkbQ28PPh9ici77ZElZzA/VWj+KA3H7oCUQ63jhqjwysTEUM3l01Nn886G+57qj9d4TWB07DgViWljKMUhQqaR2C3PEooNFndl2LJUx+tuVWdLR09Q/aNJGoSZHOs4z1 2025-08-04 20:50:03 [INFO]: Processed 1 messages, reached the limit of 1. 2025-08-04 20:50:03 [WARNING]: actionquee araye for user_id is 14409 and [] 2025-08-04 20:50:03 [INFO]: inside itemsold and closed 14409 2025-08-04 20:50:05 [INFO]: autodelete for user_id 14409 is 0 2025-08-04 20:50:05 [INFO]: autolink for user_id 14409 is 1 2025-08-04 20:50:05 [INFO]: Ebay item id :: 226670342843 exists in Database 2025-08-04 20:50:05 [INFO]: Item is reliested :: exists in Database 2025-08-04 20:50:05 [INFO]: THE CURRENT DATA FOR TO PROCESS 2025-08-04 20:50:05 [CONDITION]: IF quantity in database is not 0 then this will update the quantity 2025-08-04 20:50:05 [INFO]: in processold action queue is array for {"44684656":{"UPDATE":1,"DATAFORUPDATE":{"product_id":"44684656","ebayitemid":"226670342843","shopifyproductid":"8857444614366","variants":[{"price":"49.99","quantity":0,"weight":"3","shopifyproductid":"8857444614366","shopifyvariantid":"46495000133854","shopifyinventoryid":"48597211381982","shopifylocationid":"","product_id":"44684656","variant_id":"77589881","quantityflag":1,"priceflag":0}],"shopifydelete":0,"dbdelete":0}}} 2025-08-04 20:50:05 [INFO]: ENETER IN PROCESS UPDATE BACKUP 2025-08-04 20:50:05 [INFO]: PRODUCT HAS QUANTITY FLAG 2025-08-04 20:50:05 [INFO]: Shopify Inventory id 48597211381982 2025-08-04 20:50:05 [INFO]: Shopify Location id 58450641063 2025-08-04 20:50:05 [INFO]: QUANTITY FOR UPDATE 0 2025-08-04 20:50:05 [INFO]: QUANTITY FOR UPDATE on shopify response {"data":{"inventorySetQuantities":{"inventoryAdjustmentGroup":{"createdAt":"2025-08-04T20:50:05Z","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 20:50:05 [INFO]: Change: available | Delta: -1 2025-08-04 20:50:05 [INFO]: Change: on_hand | Delta: -1 2025-08-04 20:50:05 [INFO]: HERE IS RESPONSE FROM SHOPIFY true 2025-08-04 20:50:05 [QUERY]: Deleting 1 for the productid query is :: update products set deleted = 1 where product_id = 44684656 and user_id = 14409 2025-08-04 20:50:05 [INFO]: PRODUCT IS UPDATING QUANTITY IN DATABASE FOR VARIANT ID 77589881 AND QUANTITY IS 0 SUCCESSFUL ON SHOPIFY 2025-08-04 20:50:05 [INFO]: updateIdsQuantity -> ["77589881"] 2025-08-04 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Total IDs to update: 1. Affected rows: 1 2025-08-04 20:50:05 [INFO]: QUANTITY Bulk update query executed successfully. Query: UPDATE product_variants SET quantity = CASE WHEN id = 77589881 THEN 0 END, quantityflag = CASE WHEN id = 77589881 THEN 0 END WHERE user_id = 14409 AND id IN (77589881) 2025-08-04 20:50:05 [INFO]: QUANTITY Updated IDs: 77589881 2025-08-04 20:50:05 [INFO]: Successfully processed data for user 14409 2025-08-04 20:50:05 [INFO]: Execution Started 2025-08-04 20:50:05 [INFO]: Execution Finished