[2026-10-12 09:32:23,878.878 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:24,694.694 INFO ] Opening Door 1 [2026-10-12 09:32:24,697.697 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:24,854.854 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:25,698.698 INFO ] Opening Door 1 [2026-10-12 09:32:25,701.701 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:28,969.969 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:29,822.822 INFO ] Opening Door 1 [2026-10-12 09:32:29,825.825 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:33,038.038 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:33,876.876 INFO ] Opening Door 1 [2026-10-12 09:32:33,879.879 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:37,144.144 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:37,878.878 INFO ] Opening Door 1 [2026-10-12 09:32:37,881.881 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:41,078.078 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:41,877.877 INFO ] Opening Door 1 [2026-10-12 09:32:41,880.880 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:32:45,115.115 INFO ] Open Door Command ^^98|lockOpen|1|49 [2026-10-12 09:32:45,872.872 INFO ] Opening Door 1 [2026-10-12 09:32:45,875.875 INFO ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89 [2026-10-12 09:38:24,280.280 INFO ] Closing Door 1 [2026-10-12 09:38:24,312.312 INFO ] CLOSE_DOOR_BY_USER 1 [2026-10-12 09:38:24,317.317 INFO ] CLOSE_DOOR_BY_MACHINE 1 [2026-10-12 09:38:28,186.186 INFO ] refill_id is --> 9690563 [2026-10-12 09:38:28,642.642 INFO ] refill_content successfully fetched. [2026-10-12 09:38:28,644.644 INFO ] skus fetched is --> ['{"name":"4700BC corn chips ","sku_id":"4500754","vendor_id":"1","mrp":"50","selling_price":"50","weight":"68","image":"https://images.tinymart.in/product/4500754-4092.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"7","created_at":"2026-10-12 07:50:27.0"}', '{"name":"MaxVita Sev Murmura 90gm","sku_id":"4500733","vendor_id":"1","mrp":"30","selling_price":"30","weight":"96","image":"https://images.tinymart.in/product/4500733-6191.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"10","created_at":"2026-08-21 12:54:38.0"}', '{"name":"Farmely Achari chatka Makhana 14gm","sku_id":"4500689","vendor_id":"1","mrp":"30","selling_price":"30","weight":"22","image":"https://images.tinymart.in/product/4500689-1679.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"2","created_at":"2026-04-20 06:08:11.0"}', '{"name":"Modern kitchens Kabuli Channa 26gm","sku_id":"4500653","vendor_id":"1","mrp":"10","selling_price":"10","weight":"30","image":"https://images.tinymart.in/product/4500653-5107.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-02-27 11:19:03.0"}', '{"name":"Modern Kitchens Potato waffers Spicy 24gm ","sku_id":"4500687","vendor_id":"1","mrp":"10","selling_price":"10","weight":"30","image":"https://images.tinymart.in/product/4500687-5964.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-04-19 19:12:27.0"}', '{"name":"Farmely Cream onion Makhana 14gm","sku_id":"4500664","vendor_id":"1","mrp":"30","selling_price":"30","weight":"22","image":"https://images.tinymart.in/product/4500664-8247.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"2","created_at":"2026-03-25 20:22:26.0"}', '{"name":"Kiru Millet Crunchies Bayiruchi Masala 22gm","sku_id":"4500558","vendor_id":"1","mrp":"10","selling_price":"10","weight":"25","image":"https://images.tinymart.in/product/4500558-8740.jpeg","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2025-10-08 16:24:45.0"}', '{"name":"Modern Kitchen Masala Peanut 28gm","sku_id":"4500708","vendor_id":"1","mrp":"10","selling_price":"10","weight":"31","image":"https://images.tinymart.in/product/4500708-7901.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-06-10 09:44:00.0"}', '{"name":"Max Protein Breakfast Cookie 10g Protein 55gm","sku_id":"4500715","vendor_id":"1","mrp":"50","selling_price":"50","weight":"60","image":"https://images.tinymart.in/product/4500715-4904.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"6","created_at":"2026-07-01 11:16:29.0"}', '{"name":"Wholy Fudgy Cakes Mocha Chocolate 40g","sku_id":"4500574","vendor_id":"1","mrp":"35","selling_price":"35","weight":"35","image":"https://images.tinymart.in/product/4500574-8481.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"4","created_at":"2025-11-07 10:17:26.0"}', '{"name":"Wellbe Banana Chips Guntur Chilli 22gm","sku_id":"4500741","vendor_id":"1","mrp":"20","selling_price":"20","weight":"26","image":"https://images.tinymart.in/product/4500741-208.png","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-09-15 10:39:56.0"}', '{"name":"Farmely Peri Peri Makhana 14gm","sku_id":"4500665","vendor_id":"1","mrp":"30","selling_price":"30","weight":"22","image":"https://images.tinymart.in/product/4500665-172.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"2","created_at":"2026-03-25 20:23:03.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}', '{"name":"test sku","sku_id":"0","vendor_id":"2","mrp":"10","selling_price":"36","weight":"2000","image":"","qty":"0","description":"test sku","check_round_off":"null","sku_variance":"100","created_at":"2018-10-03 18:30:00.0"}'] [2026-10-12 09:38:28,647.647 INFO ] tray data fetched is --> [{'tray_id': '11', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500754', 'sku_json': '4500754-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '12', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500733', 'sku_json': '4500733-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '13', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500689', 'sku_json': '4500689-2', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '14', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500653', 'sku_json': '4500653-8', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '15', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500687', 'sku_json': '4500687-10', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '16', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500664', 'sku_json': '4500664-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '17', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500558', 'sku_json': '4500558-7', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '18', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500708', 'sku_json': '4500708-12', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '19', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500715', 'sku_json': '4500715-12', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '20', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500574', 'sku_json': '4500574-12', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '21', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500741', 'sku_json': '4500741-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '22', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500665', 'sku_json': '4500665-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '23', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '24', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '25', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '26', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '27', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '31', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '32', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '33', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '34', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '35', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '36', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '37', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '38', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '39', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '40', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '41', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '42', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '43', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '44', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '45', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}, {'tray_id': '46', 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': '1'}] [2026-10-12 09:38:30,779.779 INFO ] refill_response is --> {'trays_updated': True, 'sku_updated': True} [2026-10-12 09:38:30,781.781 INFO ] Trays successfully updated. [2026-10-12 09:38:30,788.788 INFO ] active doors --> ['1', '2'] [2026-10-12 09:38:31,952.952 INFO ] door --> 1 [2026-10-12 09:38:33,599.599 INFO ] door --> 2 [2026-10-12 09:38:33,601.601 INFO ] actual_tray_weights is --> [{'expected_tray_weight': 408, 'tray_weight': '464', 'TS': 1791778110.732, 'weight': '464', 'flow': '0', 'datetime': '2026-10-12 09:38:30.732000', 'address': '11', 'tray_id': '11'}, {'expected_tray_weight': 576, 'tray_weight': '588', 'TS': 1791778110.792, 'weight': '588', 'flow': '0', 'datetime': '2026-10-12 09:38:30.792000', 'address': '12', 'tray_id': '12'}, {'expected_tray_weight': 44, 'tray_weight': '180', 'TS': 1791778110.913, 'weight': '180', 'flow': '0', 'datetime': '2026-10-12 09:38:30.913000', 'address': '13', 'tray_id': '13'}, {'expected_tray_weight': 240, 'tray_weight': '407', 'TS': 1791778110.941, 'weight': '407', 'flow': '0', 'datetime': '2026-10-12 09:38:30.941000', 'address': '14', 'tray_id': '14'}, {'expected_tray_weight': 300, 'tray_weight': '306', 'TS': 1791778111.017, 'weight': '306', 'flow': '0', 'datetime': '2026-10-12 09:38:31.017000', 'address': '15', 'tray_id': '15'}, {'expected_tray_weight': 0, 'tray_weight': '135', 'TS': 1791778111.063, 'weight': '135', 'flow': '0', 'datetime': '2026-10-12 09:38:31.063000', 'address': '16', 'tray_id': '16'}, {'expected_tray_weight': 175, 'tray_weight': '210', 'TS': 1791778111.0440001, 'weight': '210', 'flow': '0', 'datetime': '2026-10-12 09:38:31.044000', 'address': '17', 'tray_id': '17'}, {'expected_tray_weight': 372, 'tray_weight': '411', 'TS': 1791778111.171, 'weight': '411', 'flow': '0', 'datetime': '2026-10-12 09:38:31.171000', 'address': '18', 'tray_id': '18'}, {'expected_tray_weight': 720, 'tray_weight': '796', 'TS': 1791778111.193, 'weight': '796', 'flow': '0', 'datetime': '2026-10-12 09:38:31.193000', 'address': '19', 'tray_id': '19'}, {'expected_tray_weight': 420, 'tray_weight': '462', 'TS': 1791778111.233, 'weight': '462', 'flow': '0', 'datetime': '2026-10-12 09:38:31.233000', 'address': '20', 'tray_id': '20'}, {'expected_tray_weight': 156, 'tray_weight': '203', 'TS': 1791778111.318, 'weight': '203', 'flow': '0', 'datetime': '2026-10-12 09:38:31.318000', 'address': '21', 'tray_id': '21'}, {'expected_tray_weight': 0, 'tray_weight': '96', 'TS': 1791778111.362, 'weight': '96', 'flow': '0', 'datetime': '2026-10-12 09:38:31.362000', 'address': '22', 'tray_id': '22'}] [2026-10-12 09:38:33,603.603 INFO ] tray mismatch found in tray ID --> 11 [2026-10-12 09:38:33,607.607 INFO ] tray_sku_json is --> 4500754-6 [2026-10-12 09:38:33,609.609 INFO ] sku_id is --> 4500754 [2026-10-12 09:38:33,611.611 INFO ] qty is --> 6 [2026-10-12 09:38:33,724.724 INFO ] sku_name is --> 4700BC corn chips [2026-10-12 09:38:33,726.726 INFO ] tray_mismatch is --> {'sku_name': '4700BC corn chips ', 'quantity_in_db': '6', 'quantity_on_tray': '6', 'sku_id': '4500754', 'tray_id': '11'} [2026-10-12 09:38:33,727.727 INFO ] tray mismatch found in tray ID --> 12 [2026-10-12 09:38:33,732.732 INFO ] tray_sku_json is --> 4500733-6 [2026-10-12 09:38:33,734.734 INFO ] sku_id is --> 4500733 [2026-10-12 09:38:33,735.735 INFO ] qty is --> 6 [2026-10-12 09:38:33,749.749 INFO ] sku_name is --> MaxVita Sev Murmura 90gm [2026-10-12 09:38:33,750.750 INFO ] tray_mismatch is --> {'sku_name': 'MaxVita Sev Murmura 90gm', 'quantity_in_db': '6', 'quantity_on_tray': '6', 'sku_id': '4500733', 'tray_id': '12'} [2026-10-12 09:38:33,752.752 INFO ] tray mismatch found in tray ID --> 13 [2026-10-12 09:38:33,757.757 INFO ] tray_sku_json is --> 4500689-2 [2026-10-12 09:38:33,758.758 INFO ] sku_id is --> 4500689 [2026-10-12 09:38:33,760.760 INFO ] qty is --> 2 [2026-10-12 09:38:33,862.862 INFO ] sku_name is --> Farmely Achari chatka Makhana 14gm [2026-10-12 09:38:33,863.863 INFO ] tray_mismatch is --> {'sku_name': 'Farmely Achari chatka Makhana 14gm', 'quantity_in_db': '2', 'quantity_on_tray': '8', 'sku_id': '4500689', 'tray_id': '13'} [2026-10-12 09:38:33,865.865 INFO ] tray mismatch found in tray ID --> 14 [2026-10-12 09:38:33,870.870 INFO ] tray_sku_json is --> 4500653-8 [2026-10-12 09:38:33,871.871 INFO ] sku_id is --> 4500653 [2026-10-12 09:38:33,873.873 INFO ] qty is --> 8 [2026-10-12 09:38:33,975.975 INFO ] sku_name is --> Modern kitchens Kabuli Channa 26gm [2026-10-12 09:38:33,977.977 INFO ] tray_mismatch is --> {'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'quantity_in_db': '8', 'quantity_on_tray': '13', 'sku_id': '4500653', 'tray_id': '14'} [2026-10-12 09:38:33,979.979 INFO ] tray mismatch found in tray ID --> 15 [2026-10-12 09:38:33,983.983 INFO ] tray_sku_json is --> 4500687-10 [2026-10-12 09:38:33,985.985 INFO ] sku_id is --> 4500687 [2026-10-12 09:38:33,987.987 INFO ] qty is --> 10 [2026-10-12 09:38:34,089.089 INFO ] sku_name is --> Modern Kitchens Potato waffers Spicy 24gm [2026-10-12 09:38:34,090.090 INFO ] tray_mismatch is --> {'sku_name': 'Modern Kitchens Potato waffers Spicy 24gm ', 'quantity_in_db': '10', 'quantity_on_tray': '10', 'sku_id': '4500687', 'tray_id': '15'} [2026-10-12 09:38:34,092.092 INFO ] tray mismatch found in tray ID --> 16 [2026-10-12 09:38:34,097.097 INFO ] tray_sku_json is --> 4500664-0 [2026-10-12 09:38:34,098.098 INFO ] sku_id is --> 4500664 [2026-10-12 09:38:34,100.100 INFO ] qty is --> 0 [2026-10-12 09:38:34,204.204 INFO ] sku_name is --> Farmely Cream onion Makhana 14gm [2026-10-12 09:38:34,205.205 INFO ] tray_mismatch is --> {'sku_name': 'Farmely Cream onion Makhana 14gm', 'quantity_in_db': '0', 'quantity_on_tray': '6', 'sku_id': '4500664', 'tray_id': '16'} [2026-10-12 09:38:34,207.207 INFO ] tray mismatch found in tray ID --> 17 [2026-10-12 09:38:34,211.211 INFO ] tray_sku_json is --> 4500558-7 [2026-10-12 09:38:34,213.213 INFO ] sku_id is --> 4500558 [2026-10-12 09:38:34,215.215 INFO ] qty is --> 7 [2026-10-12 09:38:34,317.317 INFO ] sku_name is --> Kiru Millet Crunchies Bayiruchi Masala 22gm [2026-10-12 09:38:34,319.319 INFO ] tray_mismatch is --> {'sku_name': 'Kiru Millet Crunchies Bayiruchi Masala 22gm', 'quantity_in_db': '7', 'quantity_on_tray': '8', 'sku_id': '4500558', 'tray_id': '17'} [2026-10-12 09:38:34,321.321 INFO ] tray mismatch found in tray ID --> 18 [2026-10-12 09:38:34,325.325 INFO ] tray_sku_json is --> 4500708-12 [2026-10-12 09:38:34,327.327 INFO ] sku_id is --> 4500708 [2026-10-12 09:38:34,329.329 INFO ] qty is --> 12 [2026-10-12 09:38:34,432.432 INFO ] sku_name is --> Modern Kitchen Masala Peanut 28gm [2026-10-12 09:38:34,433.433 INFO ] tray_mismatch is --> {'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500708', 'tray_id': '18'} [2026-10-12 09:38:34,435.435 INFO ] tray mismatch found in tray ID --> 19 [2026-10-12 09:38:34,440.440 INFO ] tray_sku_json is --> 4500715-12 [2026-10-12 09:38:34,441.441 INFO ] sku_id is --> 4500715 [2026-10-12 09:38:34,443.443 INFO ] qty is --> 12 [2026-10-12 09:38:34,545.545 INFO ] sku_name is --> Max Protein Breakfast Cookie 10g Protein 55gm [2026-10-12 09:38:34,547.547 INFO ] tray_mismatch is --> {'sku_name': 'Max Protein Breakfast Cookie 10g Protein 55gm', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500715', 'tray_id': '19'} [2026-10-12 09:38:34,549.549 INFO ] tray mismatch found in tray ID --> 20 [2026-10-12 09:38:34,553.553 INFO ] tray_sku_json is --> 4500574-12 [2026-10-12 09:38:34,555.555 INFO ] sku_id is --> 4500574 [2026-10-12 09:38:34,556.556 INFO ] qty is --> 12 [2026-10-12 09:38:34,659.659 INFO ] sku_name is --> Wholy Fudgy Cakes Mocha Chocolate 40g [2026-10-12 09:38:34,661.661 INFO ] tray_mismatch is --> {'sku_name': 'Wholy Fudgy Cakes Mocha Chocolate 40g', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500574', 'tray_id': '20'} [2026-10-12 09:38:34,662.662 INFO ] tray mismatch found in tray ID --> 21 [2026-10-12 09:38:34,667.667 INFO ] tray_sku_json is --> 4500741-6 [2026-10-12 09:38:34,669.669 INFO ] sku_id is --> 4500741 [2026-10-12 09:38:34,670.670 INFO ] qty is --> 6 [2026-10-12 09:38:34,772.772 INFO ] sku_name is --> Wellbe Banana Chips Guntur Chilli 22gm [2026-10-12 09:38:34,774.774 INFO ] tray_mismatch is --> {'sku_name': 'Wellbe Banana Chips Guntur Chilli 22gm', 'quantity_in_db': '6', 'quantity_on_tray': '7', 'sku_id': '4500741', 'tray_id': '21'} [2026-10-12 09:38:34,776.776 INFO ] tray mismatch found in tray ID --> 22 [2026-10-12 09:38:34,780.780 INFO ] tray_sku_json is --> 4500665-0 [2026-10-12 09:38:34,782.782 INFO ] sku_id is --> 4500665 [2026-10-12 09:38:34,784.784 INFO ] qty is --> 0 [2026-10-12 09:38:34,797.797 INFO ] sku_name is --> Farmely Peri Peri Makhana 14gm [2026-10-12 09:38:34,799.799 INFO ] tray_mismatch is --> {'sku_name': 'Farmely Peri Peri Makhana 14gm', 'quantity_in_db': '0', 'quantity_on_tray': '4', 'sku_id': '4500665', 'tray_id': '22'} [2026-10-12 09:38:34,801.801 INFO ] response from startRefill is --> {'message': 'Tray mismatches found.', 'success': True, 'tray_mismatches': [{'sku_name': '4700BC corn chips ', 'quantity_in_db': '6', 'quantity_on_tray': '6', 'sku_id': '4500754', 'tray_id': '11'}, {'sku_name': 'MaxVita Sev Murmura 90gm', 'quantity_in_db': '6', 'quantity_on_tray': '6', 'sku_id': '4500733', 'tray_id': '12'}, {'sku_name': 'Farmely Achari chatka Makhana 14gm', 'quantity_in_db': '2', 'quantity_on_tray': '8', 'sku_id': '4500689', 'tray_id': '13'}, {'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'quantity_in_db': '8', 'quantity_on_tray': '13', 'sku_id': '4500653', 'tray_id': '14'}, {'sku_name': 'Modern Kitchens Potato waffers Spicy 24gm ', 'quantity_in_db': '10', 'quantity_on_tray': '10', 'sku_id': '4500687', 'tray_id': '15'}, {'sku_name': 'Farmely Cream onion Makhana 14gm', 'quantity_in_db': '0', 'quantity_on_tray': '6', 'sku_id': '4500664', 'tray_id': '16'}, {'sku_name': 'Kiru Millet Crunchies Bayiruchi Masala 22gm', 'quantity_in_db': '7', 'quantity_on_tray': '8', 'sku_id': '4500558', 'tray_id': '17'}, {'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500708', 'tray_id': '18'}, {'sku_name': 'Max Protein Breakfast Cookie 10g Protein 55gm', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500715', 'tray_id': '19'}, {'sku_name': 'Wholy Fudgy Cakes Mocha Chocolate 40g', 'quantity_in_db': '12', 'quantity_on_tray': '13', 'sku_id': '4500574', 'tray_id': '20'}, {'sku_name': 'Wellbe Banana Chips Guntur Chilli 22gm', 'quantity_in_db': '6', 'quantity_on_tray': '7', 'sku_id': '4500741', 'tray_id': '21'}, {'sku_name': 'Farmely Peri Peri Makhana 14gm', 'quantity_in_db': '0', 'quantity_on_tray': '4', 'sku_id': '4500665', 'tray_id': '22'}]} [2026-10-12 09:39:20,787.787 INFO ] completeRefill refill_content is --> {'txnType': 'refill', 'content': [{'quantity_in_db': '6', 'sku_id': '4500754', 'sku_name': '4700BC corn chips ', 'quantity_on_tray': '6', 'check_enabled': True, 'tray_id': '11'}, {'quantity_in_db': '6', 'sku_id': '4500733', 'sku_name': 'MaxVita Sev Murmura 90gm', 'quantity_on_tray': '6', 'check_enabled': True, 'tray_id': '12'}, {'quantity_in_db': '2', 'sku_id': '4500689', 'sku_name': 'Farmely Achari chatka Makhana 14gm', 'quantity_on_tray': '8', 'check_enabled': True, 'tray_id': '13'}, {'quantity_in_db': '8', 'sku_id': '4500653', 'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'quantity_on_tray': '13', 'check_enabled': True, 'tray_id': '14'}, {'quantity_in_db': '10', 'sku_id': '4500687', 'sku_name': 'Modern Kitchens Potato waffers Spicy 24gm ', 'quantity_on_tray': '10', 'check_enabled': True, 'tray_id': '15'}, {'quantity_in_db': '0', 'sku_id': '4500664', 'sku_name': 'Farmely Cream onion Makhana 14gm', 'quantity_on_tray': '6', 'check_enabled': True, 'tray_id': '16'}, {'quantity_in_db': '7', 'sku_id': '4500558', 'sku_name': 'Kiru Millet Crunchies Bayiruchi Masala 22gm', 'quantity_on_tray': '8', 'check_enabled': True, 'tray_id': '17'}, {'quantity_in_db': '12', 'sku_id': '4500708', 'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'quantity_on_tray': '13', 'check_enabled': True, 'tray_id': '18'}, {'quantity_in_db': '12', 'sku_id': '4500715', 'sku_name': 'Max Protein Breakfast Cookie 10g Protein 55gm', 'quantity_on_tray': '13', 'check_enabled': True, 'tray_id': '19'}, {'quantity_in_db': '12', 'sku_id': '4500574', 'sku_name': 'Wholy Fudgy Cakes Mocha Chocolate 40g', 'quantity_on_tray': '13', 'check_enabled': True, 'tray_id': '20'}, {'quantity_in_db': '6', 'sku_id': '4500741', 'sku_name': 'Wellbe Banana Chips Guntur Chilli 22gm', 'quantity_on_tray': '7', 'check_enabled': True, 'tray_id': '21'}, {'quantity_in_db': '0', 'sku_id': '4500665', 'sku_name': 'Farmely Peri Peri Makhana 14gm', 'quantity_on_tray': '4', 'check_enabled': True, 'tray_id': '22'}], 'order_id': 'TM09202501_refill_261012093217', 'refill_id': '9690563', 'door_id': [1], 'door_open_init': True} [2026-10-12 09:39:20,791.791 INFO ] Quantity updated for tray --> 13 [2026-10-12 09:39:20,825.825 INFO ] Quantity updated for tray --> 14 [2026-10-12 09:39:20,860.860 INFO ] Quantity updated for tray --> 16 [2026-10-12 09:39:20,895.895 INFO ] Quantity updated for tray --> 17 [2026-10-12 09:39:20,928.928 INFO ] Quantity updated for tray --> 18 [2026-10-12 09:39:20,959.959 INFO ] Quantity updated for tray --> 19 [2026-10-12 09:39:20,997.997 INFO ] Quantity updated for tray --> 20 [2026-10-12 09:39:21,034.034 INFO ] Quantity updated for tray --> 21 [2026-10-12 09:39:21,065.065 INFO ] Quantity updated for tray --> 22 [2026-10-12 09:39:21,097.097 INFO ] calling checktrays in complete refill [2026-10-12 09:39:21,546.546 INFO ] Successfully updated refill time. [2026-10-12 09:39:21,548.548 INFO ] Trays with quantities updated --> [{"quantity_in_db": "2", "sku_id": "4500689", "sku_name": "Farmely Achari chatka Makhana 14gm", "quantity_on_tray": "8", "check_enabled": true, "tray_id": "13"}, {"quantity_in_db": "8", "sku_id": "4500653", "sku_name": "Modern kitchens Kabuli Channa 26gm", "quantity_on_tray": "13", "check_enabled": true, "tray_id": "14"}, {"quantity_in_db": "0", "sku_id": "4500664", "sku_name": "Farmely Cream onion Makhana 14gm", "quantity_on_tray": "6", "check_enabled": true, "tray_id": "16"}, {"quantity_in_db": "7", "sku_id": "4500558", "sku_name": "Kiru Millet Crunchies Bayiruchi Masala 22gm", "quantity_on_tray": "8", "check_enabled": true, "tray_id": "17"}, {"quantity_in_db": "12", "sku_id": "4500708", "sku_name": "Modern Kitchen Masala Peanut 28gm", "quantity_on_tray": "13", "check_enabled": true, "tray_id": "18"}, {"quantity_in_db": "12", "sku_id": "4500715", "sku_name": "Max Protein Breakfast Cookie 10g Protein 55gm", "quantity_on_tray": "13", "check_enabled": true, "tray_id": "19"}, {"quantity_in_db": "12", "sku_id": "4500574", "sku_name": "Wholy Fudgy Cakes Mocha Chocolate 40g", "quantity_on_tray": "13", "check_enabled": true, "tray_id": "20"}, {"quantity_in_db": "6", "sku_id": "4500741", "sku_name": "Wellbe Banana Chips Guntur Chilli 22gm", "quantity_on_tray": "7", "check_enabled": true, "tray_id": "21"}, {"quantity_in_db": "0", "sku_id": "4500665", "sku_name": "Farmely Peri Peri Makhana 14gm", "quantity_on_tray": "4", "check_enabled": true, "tray_id": "22"}] [2026-10-12 09:39:21,913.913 INFO ] completeRefill response is --> {'success': True} [2026-10-12 09:39:36,945.945 INFO ] trays_before_refill --> [{"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500474", "sku_json": "4500474-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "1", "tray_id": 11}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500733", "sku_json": "4500733-1", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "111", "tray_id": 12}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500689", "sku_json": "4500689-6", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "137", "tray_id": 13}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500653", "sku_json": "4500653-3", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "123", "tray_id": 14}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500546", "sku_json": "4500546-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "20", "tray_id": 15}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500664", "sku_json": "4500664-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "39", "tray_id": 16}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500558", "sku_json": "4500558-2", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "52", "tray_id": 17}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500708", "sku_json": "4500708-1", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "43", "tray_id": 18}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500715", "sku_json": "4500715-1", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "53", "tray_id": 19}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500631", "sku_json": "4500631-3", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "132", "tray_id": 20}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500473", "sku_json": "4500473-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "8", "tray_id": 21}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "4500665", "sku_json": "4500665-4", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "96", "tray_id": 22}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "99999", "tray_id": 23}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "99999", "tray_id": 24}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "99999", "tray_id": 25}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "99999", "tray_id": 26}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "1", "tray_weight": "99999", "tray_id": 27}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 31}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 32}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 33}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 34}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 35}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 36}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 37}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 38}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 39}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 40}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 41}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 42}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 43}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 44}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 45}, {"active": 1, "modified_at": "2026-10-07 08:32:04", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-07 08:32:04", "door_id": "2", "tray_weight": "99999", "tray_id": 46}] [2026-10-12 09:39:36,960.960 INFO ] trays_after_refill --> [{"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500754", "sku_json": "4500754-6", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "463", "tray_id": 11}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500733", "sku_json": "4500733-6", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "588", "tray_id": 12}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500689", "sku_json": "4500689-8", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "179", "tray_id": 13}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500653", "sku_json": "4500653-13", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "407", "tray_id": 14}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500687", "sku_json": "4500687-10", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "305", "tray_id": 15}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500664", "sku_json": "4500664-6", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "135", "tray_id": 16}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500558", "sku_json": "4500558-8", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "212", "tray_id": 17}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500708", "sku_json": "4500708-13", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "411", "tray_id": 18}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500715", "sku_json": "4500715-13", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "795", "tray_id": 19}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500574", "sku_json": "4500574-13", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "463", "tray_id": 20}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500741", "sku_json": "4500741-7", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "203", "tray_id": 21}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "4500665", "sku_json": "4500665-4", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "96", "tray_id": 22}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "99999", "tray_id": 23}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "99999", "tray_id": 24}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "99999", "tray_id": 25}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "99999", "tray_id": 26}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "1", "tray_weight": "99999", "tray_id": 27}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 31}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 32}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 33}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 34}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 35}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 36}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 37}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 38}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 39}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 40}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 41}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 42}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 43}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 44}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 45}, {"active": 1, "modified_at": "2026-10-12 09:38:26", "org_sku": "0", "sku_json": "0-0", "created_at": "2026-10-12 09:38:26", "door_id": "2", "tray_weight": "99999", "tray_id": 46}] [2026-10-12 09:39:36,972.972 INFO ] compute_stock_transfer trays_before_refill is --> [{'tray_id': 11, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500474', 'sku_json': '4500474-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '1', 'active': 1}, {'tray_id': 12, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500733', 'sku_json': '4500733-1', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '111', 'active': 1}, {'tray_id': 13, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500689', 'sku_json': '4500689-6', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '137', 'active': 1}, {'tray_id': 14, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500653', 'sku_json': '4500653-3', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '123', 'active': 1}, {'tray_id': 15, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500546', 'sku_json': '4500546-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '20', 'active': 1}, {'tray_id': 16, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500664', 'sku_json': '4500664-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '39', 'active': 1}, {'tray_id': 17, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500558', 'sku_json': '4500558-2', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '52', 'active': 1}, {'tray_id': 18, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500708', 'sku_json': '4500708-1', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '43', 'active': 1}, {'tray_id': 19, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500715', 'sku_json': '4500715-1', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '53', 'active': 1}, {'tray_id': 20, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500631', 'sku_json': '4500631-3', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '132', 'active': 1}, {'tray_id': 21, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500473', 'sku_json': '4500473-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '8', 'active': 1}, {'tray_id': 22, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '4500665', 'sku_json': '4500665-4', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '96', 'active': 1}, {'tray_id': 23, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 24, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 25, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 26, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 27, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 31, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 32, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 33, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 34, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 35, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 36, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 37, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 38, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 39, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 40, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 41, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 42, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 43, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 44, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 45, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 46, 'modified_at': '2026-10-07 08:32:04', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-07 08:32:04', 'door_id': '2', 'tray_weight': '99999', 'active': 1}] [2026-10-12 09:39:36,977.977 INFO ] compute_stock_transfer trays_after_refill is --> [{'tray_id': 11, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500754', 'sku_json': '4500754-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '463', 'active': 1}, {'tray_id': 12, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500733', 'sku_json': '4500733-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '588', 'active': 1}, {'tray_id': 13, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500689', 'sku_json': '4500689-8', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '179', 'active': 1}, {'tray_id': 14, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500653', 'sku_json': '4500653-13', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '407', 'active': 1}, {'tray_id': 15, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500687', 'sku_json': '4500687-10', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '305', 'active': 1}, {'tray_id': 16, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500664', 'sku_json': '4500664-6', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '135', 'active': 1}, {'tray_id': 17, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500558', 'sku_json': '4500558-8', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '212', 'active': 1}, {'tray_id': 18, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500708', 'sku_json': '4500708-13', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '411', 'active': 1}, {'tray_id': 19, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500715', 'sku_json': '4500715-13', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '795', 'active': 1}, {'tray_id': 20, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500574', 'sku_json': '4500574-13', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '463', 'active': 1}, {'tray_id': 21, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500741', 'sku_json': '4500741-7', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '203', 'active': 1}, {'tray_id': 22, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '4500665', 'sku_json': '4500665-4', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '96', 'active': 1}, {'tray_id': 23, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 24, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 25, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 26, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 27, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '1', 'tray_weight': '99999', 'active': 1}, {'tray_id': 31, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 32, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 33, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 34, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 35, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 36, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 37, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 38, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 39, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 40, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 41, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 42, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 43, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 44, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 45, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}, {'tray_id': 46, 'modified_at': '2026-10-12 09:38:26', 'org_sku': '0', 'sku_json': '0-0', 'created_at': '2026-10-12 09:38:26', 'door_id': '2', 'tray_weight': '99999', 'active': 1}] [2026-10-12 09:39:36,981.981 INFO ] trays_comparison_list is --> [2026-10-12 09:39:37,085.085 INFO ] stock_json is --> {'type': 'replace', 'quantity_added_to_tray': 6, 'sku_added': '4500754', 'tray_id': '11', 'sku_removed': '4500474', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,087.087 INFO ] tray_id[11] type:replace sku_id:before[4500474] after[4500754] weight:initial[0] final[463] weightdiff[463] qtyDB:before[0] after[6] qtyWeight[7] [2026-10-12 09:39:37,137.137 INFO ] tray_id[12] type:add sku_id:before[4500733] after[4500733] weight:initial[111] final[588] weightdiff[477] qtyDB:before[1] after:[6] qtyWeight[5] [2026-10-12 09:39:37,139.139 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 5, 'sku_added': '', 'tray_id': '12', 'sku_removed': '4500733', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,149.149 INFO ] tray_id[13] type:add sku_id:before[4500689] after[4500689] weight:initial[137] final[179] weightdiff[42] qtyDB:before[6] after:[8] qtyWeight[2] [2026-10-12 09:39:37,151.151 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 2, 'sku_added': '', 'tray_id': '13', 'sku_removed': '4500689', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,204.204 INFO ] tray_id[14] type:add sku_id:before[4500653] after[4500653] weight:initial[123] final[407] weightdiff[284] qtyDB:before[3] after:[13] qtyWeight[9] [2026-10-12 09:39:37,206.206 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 10, 'sku_added': '', 'tray_id': '14', 'sku_removed': '4500653', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,216.216 INFO ] stock_json is --> {'type': 'replace', 'quantity_added_to_tray': 10, 'sku_added': '4500687', 'tray_id': '15', 'sku_removed': '4500546', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,218.218 INFO ] tray_id[15] type:replace sku_id:before[4500546] after[4500687] weight:initial[0] final[305] weightdiff[305] qtyDB:before[0] after[10] qtyWeight[6] [2026-10-12 09:39:37,228.228 INFO ] tray_id[16] type:add sku_id:before[4500664] after[4500664] weight:initial[39] final[135] weightdiff[96] qtyDB:before[0] after:[6] qtyWeight[4] [2026-10-12 09:39:37,230.230 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 6, 'sku_added': '', 'tray_id': '16', 'sku_removed': '4500664', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,287.287 INFO ] tray_id[17] type:add sku_id:before[4500558] after[4500558] weight:initial[52] final[212] weightdiff[160] qtyDB:before[2] after:[8] qtyWeight[6] [2026-10-12 09:39:37,289.289 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 6, 'sku_added': '', 'tray_id': '17', 'sku_removed': '4500558', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,350.350 INFO ] tray_id[18] type:add sku_id:before[4500708] after[4500708] weight:initial[43] final[411] weightdiff[368] qtyDB:before[1] after:[13] qtyWeight[12] [2026-10-12 09:39:37,352.352 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 12, 'sku_added': '', 'tray_id': '18', 'sku_removed': '4500708', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,413.413 INFO ] tray_id[19] type:add sku_id:before[4500715] after[4500715] weight:initial[53] final[795] weightdiff[742] qtyDB:before[1] after:[13] qtyWeight[12] [2026-10-12 09:39:37,415.415 INFO ] stock_json is --> {'type': 'add', 'quantity_added_to_tray': 12, 'sku_added': '', 'tray_id': '19', 'sku_removed': '4500715', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,478.478 INFO ] stock_json is --> {'type': 'replace', 'quantity_added_to_tray': 13, 'sku_added': '4500574', 'tray_id': '20', 'sku_removed': '4500631', 'quantity_removed_from_tray': 3} [2026-10-12 09:39:37,480.480 INFO ] tray_id[20] type:replace sku_id:before[4500631] after[4500574] weight:initial[0] final[463] weightdiff[463] qtyDB:before[0] after[13] qtyWeight[10] [2026-10-12 09:39:37,490.490 INFO ] stock_json is --> {'type': 'replace', 'quantity_added_to_tray': 7, 'sku_added': '4500741', 'tray_id': '21', 'sku_removed': '4500473', 'quantity_removed_from_tray': 0} [2026-10-12 09:39:37,492.492 INFO ] tray_id[21] type:replace sku_id:before[4500473] after[4500741] weight:initial[0] final[203] weightdiff[203] qtyDB:before[0] after[7] qtyWeight[4] [2026-10-12 09:39:37,503.503 INFO ] tray_id[22] type:no_change sku_id:before[4500665] after[4500665] weight:initial[96] final[96] weightdiff[0] qtyDB:before[4] after:[4] qtyWeight[0] [2026-10-12 09:39:37,505.505 INFO ] No change on tray --> 22 [2026-10-12 09:39:37,515.515 INFO ] tray_id[23] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,517.517 INFO ] No change on tray --> 23 [2026-10-12 09:39:37,527.527 INFO ] tray_id[24] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,529.529 INFO ] No change on tray --> 24 [2026-10-12 09:39:37,539.539 INFO ] tray_id[25] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,541.541 INFO ] No change on tray --> 25 [2026-10-12 09:39:37,551.551 INFO ] tray_id[26] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,553.553 INFO ] No change on tray --> 26 [2026-10-12 09:39:37,564.564 INFO ] tray_id[27] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,565.565 INFO ] No change on tray --> 27 [2026-10-12 09:39:37,576.576 INFO ] tray_id[31] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,578.578 INFO ] No change on tray --> 31 [2026-10-12 09:39:37,588.588 INFO ] tray_id[32] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,590.590 INFO ] No change on tray --> 32 [2026-10-12 09:39:37,600.600 INFO ] tray_id[33] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,602.602 INFO ] No change on tray --> 33 [2026-10-12 09:39:37,613.613 INFO ] tray_id[34] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,614.614 INFO ] No change on tray --> 34 [2026-10-12 09:39:37,625.625 INFO ] tray_id[35] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,627.627 INFO ] No change on tray --> 35 [2026-10-12 09:39:37,637.637 INFO ] tray_id[36] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,639.639 INFO ] No change on tray --> 36 [2026-10-12 09:39:37,649.649 INFO ] tray_id[37] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,651.651 INFO ] No change on tray --> 37 [2026-10-12 09:39:37,661.661 INFO ] tray_id[38] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,663.663 INFO ] No change on tray --> 38 [2026-10-12 09:39:37,673.673 INFO ] tray_id[39] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,675.675 INFO ] No change on tray --> 39 [2026-10-12 09:39:37,685.685 INFO ] tray_id[40] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,687.687 INFO ] No change on tray --> 40 [2026-10-12 09:39:37,698.698 INFO ] tray_id[41] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,700.700 INFO ] No change on tray --> 41 [2026-10-12 09:39:37,710.710 INFO ] tray_id[42] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,712.712 INFO ] No change on tray --> 42 [2026-10-12 09:39:37,722.722 INFO ] tray_id[43] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,724.724 INFO ] No change on tray --> 43 [2026-10-12 09:39:37,734.734 INFO ] tray_id[44] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,736.736 INFO ] No change on tray --> 44 [2026-10-12 09:39:37,751.751 INFO ] tray_id[45] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,752.752 INFO ] No change on tray --> 45 [2026-10-12 09:39:37,763.763 INFO ] tray_id[46] type:no_change sku_id:before[0] after[0] weight:initial[99999] final[99999] weightdiff[0] qtyDB:before[0] after:[0] qtyWeight[0] [2026-10-12 09:39:37,765.765 INFO ] No change on tray --> 46 [2026-10-12 09:39:37,768.768 INFO ] stock_transfer is --> [{"type": "replace", "quantity_added_to_tray": 6, "sku_added": "4500754", "tray_id": "11", "sku_removed": "4500474", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 5, "sku_added": "", "tray_id": "12", "sku_removed": "4500733", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 2, "sku_added": "", "tray_id": "13", "sku_removed": "4500689", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 10, "sku_added": "", "tray_id": "14", "sku_removed": "4500653", "quantity_removed_from_tray": 0}, {"type": "replace", "quantity_added_to_tray": 10, "sku_added": "4500687", "tray_id": "15", "sku_removed": "4500546", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 6, "sku_added": "", "tray_id": "16", "sku_removed": "4500664", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 6, "sku_added": "", "tray_id": "17", "sku_removed": "4500558", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 12, "sku_added": "", "tray_id": "18", "sku_removed": "4500708", "quantity_removed_from_tray": 0}, {"type": "add", "quantity_added_to_tray": 12, "sku_added": "", "tray_id": "19", "sku_removed": "4500715", "quantity_removed_from_tray": 0}, {"type": "replace", "quantity_added_to_tray": 13, "sku_added": "4500574", "tray_id": "20", "sku_removed": "4500631", "quantity_removed_from_tray": 3}, {"type": "replace", "quantity_added_to_tray": 7, "sku_added": "4500741", "tray_id": "21", "sku_removed": "4500473", "quantity_removed_from_tray": 0}] [2026-10-12 09:39:37,842.842 INFO ] tray_mismatches are --> [{"actual_tray_weight": 463, "expected_sku_qty": 6, "expected_tray_weigth": 408, "db_sku_qty": "6", "tray_id": 11}] [2026-10-12 09:39:37,947.947 INFO ] calculate_refill_data response --> {"message": "Refill data successfully updated.", "success": true} [2026-10-12 09:39:38,313.313 INFO ] Refill data successfully synced. [2026-10-12 20:56:26,642.642 INFO ] ################################### ####### PI SERVER STARTED ######### ###################################