[2026-10-14 08:17:00,926.926 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:01,716.716 INFO    ] Opening Door 1
[2026-10-14 08:17:01,719.719 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:01,945.945 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:02,812.812 INFO    ] Opening Door 1
[2026-10-14 08:17:02,814.814 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:05,927.927 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:06,950.950 INFO    ] Opening Door 1
[2026-10-14 08:17:06,952.952 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:10,062.062 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:10,851.851 INFO    ] Opening Door 1
[2026-10-14 08:17:10,852.852 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:13,964.964 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:14,770.770 INFO    ] Opening Door 1
[2026-10-14 08:17:14,773.773 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:17,983.983 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:18,700.700 INFO    ] Opening Door 1
[2026-10-14 08:17:18,702.702 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:17:21,856.856 INFO    ] Open Door Command ^^98|lockOpen|1|49

[2026-10-14 08:17:22,584.584 INFO    ] Opening Door 1
[2026-10-14 08:17:22,587.587 INFO    ] OPEN_DOOR_BY_MACHINE^^98|True|1|lockOpen|89

[2026-10-14 08:22:07,926.926 INFO    ] Closing Door 1
[2026-10-14 08:22:07,951.951 INFO    ] CLOSE_DOOR_BY_MACHINE 1
[2026-10-14 08:22:56,779.779 INFO    ] refill_id is --> 9690584
[2026-10-14 08:22:57,297.297 INFO    ] refill_content successfully fetched.
[2026-10-14 08:22:57,299.299 INFO    ] skus fetched is --> ['{"name":"Raw Coconut Water, 200ml","sku_id":"177747","vendor_id":"1","mrp":"65","selling_price":"65","weight":"223","image":"https://images.tinymart.in/product/177747-2139.png","qty":"100","description":"","check_round_off":"0","sku_variance":"22","created_at":"2022-11-09 15:46:12.0"}', '{"name":"Raw Alphonso Mango 200ml","sku_id":"186094","vendor_id":"1","mrp":"56","selling_price":"56","weight":"242","image":"https://images.tinymart.in/product/186094-3209.jpeg","qty":"100","description":"null","check_round_off":"null","sku_variance":"24","created_at":"2025-01-29 09:56:32.0"}', '{"name":"Poptail Watermelon Boba Drink 250ml","sku_id":"4500752","vendor_id":"1","mrp":"120","selling_price":"120","weight":"275","image":"https://images.tinymart.in/product/4500752-6181.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"28","created_at":"2026-09-25 15:30:01.0"}', '{"name":"Heritage A1 Spiced Butter Milk180ml","sku_id":"4500499","vendor_id":"1","mrp":"25","selling_price":"25","weight":"192","image":"https://images.tinymart.in/product/4500499-5719.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"19","created_at":"2025-07-11 11:53:35.0"}', '{"name":"Nestle Nescafe Chilled Latte Coffee Milk ","sku_id":"186001","vendor_id":"1","mrp":"45","selling_price":"45","weight":"202","image":"https://images.tinymart.in/product/186001-2099.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"20","created_at":"2024-05-13 15:40:23.0"}', '{"name":"Wholy Fudgy Cakes Hazelnut Chocolate 32g","sku_id":"4500563","vendor_id":"1","mrp":"35","selling_price":"35","weight":"34","image":"https://images.tinymart.in/product/4500563-5270.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2025-10-24 12:00:22.0"}', '{"name":"Snickers Chocolate Bar 22g","sku_id":"112220","vendor_id":"1","mrp":"20","selling_price":"20","weight":"24","image":"https://images.tinymart.in/product/112220-2513.jpg","qty":"100","description":"","check_round_off":"0","sku_variance":"2","created_at":"2022-07-09 10:51:59.0"}', '{"name":"WinGreen Harvest Crunchy Granola Bar 25gm","sku_id":"4500737","vendor_id":"1","mrp":"40","selling_price":"40","weight":"28","image":"https://images.tinymart.in/product/4500737-3298.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-08-28 21:40:33.0"}', '{"name":"Modern kitchens Banana Chips 21gm","sku_id":"4500648","vendor_id":"1","mrp":"10","selling_price":"10","weight":"25","image":"https://images.tinymart.in/product/4500648-25.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2026-02-27 10:46:30.0"}', '{"name":"Farmely Classic date Bites 20gm","sku_id":"4500667","vendor_id":"1","mrp":"40","selling_price":"40","weight":"23","image":"https://images.tinymart.in/product/4500667-4339.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"2","created_at":"2026-03-25 20:30:16.0"}', '{"name":"Rite Bite Sports Bar 40gm","sku_id":"4500669","vendor_id":"1","mrp":"45","selling_price":"45","weight":"44","image":"https://images.tinymart.in/product/4500669-3919.webp","qty":"100","description":"null","check_round_off":"null","sku_variance":"4","created_at":"2026-03-25 20:34:29.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":"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":"KITKAT Nestle 4 Finger Chocolate 38g","sku_id":"186084","vendor_id":"1","mrp":"30","selling_price":"30","weight":"41","image":"https://images.tinymart.in/product/186084-5395.png","qty":"100","description":"null","check_round_off":"null","sku_variance":"4","created_at":"2025-01-06 17:47:45.0"}', '{"name":"Wholy Fudgy Cakes Red Velvet 32g","sku_id":"4500564","vendor_id":"1","mrp":"35","selling_price":"35","weight":"34","image":"https://images.tinymart.in/product/4500564-6115.jpg","qty":"100","description":"null","check_round_off":"null","sku_variance":"3","created_at":"2025-10-24 12:02:42.0"}', '{"name":"Maxvita  cheese ball Tomato masti 70gm","sku_id":"4500749","vendor_id":"1","mrp":"30","selling_price":"30","weight":"77","image":"https://images.tinymart.in/product/4500749-9445.png","qty":"100","description":"null","check_round_off":"null","sku_variance":"8","created_at":"2026-09-22 11:19:48.0"}']
[2026-10-14 08:22:57,302.302 INFO    ] tray data fetched is --> [{'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '177747-4', 'tray_id': '11', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '177747', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '186094-0', 'tray_id': '12', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '186094', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500752-4', 'tray_id': '13', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500752', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500499-6', 'tray_id': '14', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500499', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '186001-2', 'tray_id': '15', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '186001', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500563-0', 'tray_id': '16', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500563', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '112220-20', 'tray_id': '17', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '112220', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500737-0', 'tray_id': '18', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500737', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500648-12', 'tray_id': '19', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500648', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500667-7', 'tray_id': '20', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500667', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500669-0', 'tray_id': '21', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500669', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500708-2', 'tray_id': '22', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500708', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500653-0', 'tray_id': '23', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500653', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '186084-15', 'tray_id': '24', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '186084', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500564-12', 'tray_id': '25', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500564', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': '1', 'sku_json': '4500749-8', 'tray_id': '26', 'tray_weight': '99999', 'door_id': '1', 'org_sku': '4500749', 'modified_at': '2026-10-14 08:22:53'}]
[2026-10-14 08:22:58,844.844 INFO    ] refill_response is --> {'sku_updated': True, 'trays_updated': True}
[2026-10-14 08:22:58,848.848 INFO    ] Trays successfully updated.
[2026-10-14 08:22:58,858.858 INFO    ] active doors --> ['1']
[2026-10-14 08:22:59,715.715 INFO    ] door --> 1
[2026-10-14 08:22:59,717.717 INFO    ] actual_tray_weights is --> [{'flow': '0', 'datetime': '2026-10-14 08:22:58.887000', 'tray_id': '11', 'expected_tray_weight': 892, 'address': '11', 'tray_weight': '1603', 'weight': '1603', 'TS': 1791946378.887}, {'flow': '0', 'datetime': '2026-10-14 08:22:58.873000', 'tray_id': '12', 'expected_tray_weight': 0, 'address': '12', 'tray_weight': '1211', 'weight': '1211', 'TS': 1791946378.8730001}, {'flow': '0', 'datetime': '2026-10-14 08:22:58.988000', 'tray_id': '13', 'expected_tray_weight': 1100, 'address': '13', 'tray_weight': '1095', 'weight': '1095', 'TS': 1791946378.988}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.050000', 'tray_id': '14', 'expected_tray_weight': 1152, 'address': '14', 'tray_weight': '1342', 'weight': '1342', 'TS': 1791946379.05}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.068000', 'tray_id': '15', 'expected_tray_weight': 404, 'address': '15', 'tray_weight': '1010', 'weight': '1010', 'TS': 1791946379.068}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.078000', 'tray_id': '16', 'expected_tray_weight': 0, 'address': '16', 'tray_weight': '290', 'weight': '290', 'TS': 1791946379.078}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.147000', 'tray_id': '17', 'expected_tray_weight': 480, 'address': '17', 'tray_weight': '458', 'weight': '458', 'TS': 1791946379.147}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.207000', 'tray_id': '18', 'expected_tray_weight': 0, 'address': '18', 'tray_weight': '253', 'weight': '253', 'TS': 1791946379.2069998}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.296000', 'tray_id': '19', 'expected_tray_weight': 300, 'address': '19', 'tray_weight': '300', 'weight': '300', 'TS': 1791946379.296}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.299000', 'tray_id': '20', 'expected_tray_weight': 161, 'address': '20', 'tray_weight': '331', 'weight': '331', 'TS': 1791946379.299}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.390000', 'tray_id': '21', 'expected_tray_weight': 0, 'address': '21', 'tray_weight': '370', 'weight': '370', 'TS': 1791946379.39}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.394000', 'tray_id': '22', 'expected_tray_weight': 62, 'address': '22', 'tray_weight': '305', 'weight': '305', 'TS': 1791946379.3939998}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.457000', 'tray_id': '23', 'expected_tray_weight': 0, 'address': '23', 'tray_weight': '224', 'weight': '224', 'TS': 1791946379.457}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.531000', 'tray_id': '24', 'expected_tray_weight': 615, 'address': '24', 'tray_weight': '589', 'weight': '589', 'TS': 1791946379.531}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.554000', 'tray_id': '25', 'expected_tray_weight': 408, 'address': '25', 'tray_weight': '407', 'weight': '407', 'TS': 1791946379.554}, {'flow': '0', 'datetime': '2026-10-14 08:22:59.607000', 'tray_id': '26', 'expected_tray_weight': 616, 'address': '26', 'tray_weight': '512', 'weight': '512', 'TS': 1791946379.607}]
[2026-10-14 08:22:59,720.720 INFO    ] tray mismatch found in tray ID --> 11
[2026-10-14 08:22:59,724.724 INFO    ] tray_sku_json is --> 177747-4
[2026-10-14 08:22:59,726.726 INFO    ] sku_id is --> 177747
[2026-10-14 08:22:59,728.728 INFO    ] qty is --> 4
[2026-10-14 08:22:59,746.746 INFO    ] sku_name is --> Raw Coconut Water, 200ml
[2026-10-14 08:22:59,748.748 INFO    ] tray_mismatch is --> {'sku_id': '177747', 'sku_name': 'Raw Coconut Water, 200ml', 'tray_id': '11', 'quantity_on_tray': '7', 'quantity_in_db': '4'}
[2026-10-14 08:22:59,749.749 INFO    ] tray mismatch found in tray ID --> 12
[2026-10-14 08:22:59,754.754 INFO    ] tray_sku_json is --> 186094-0
[2026-10-14 08:22:59,756.756 INFO    ] sku_id is --> 186094
[2026-10-14 08:22:59,758.758 INFO    ] qty is --> 0
[2026-10-14 08:22:59,773.773 INFO    ] sku_name is --> Raw Alphonso Mango 200ml
[2026-10-14 08:22:59,774.774 INFO    ] tray_mismatch is --> {'sku_id': '186094', 'sku_name': 'Raw Alphonso Mango 200ml', 'tray_id': '12', 'quantity_on_tray': '5', 'quantity_in_db': '0'}
[2026-10-14 08:22:59,776.776 INFO    ] tray mismatch found in tray ID --> 13
[2026-10-14 08:22:59,781.781 INFO    ] tray_sku_json is --> 4500752-4
[2026-10-14 08:22:59,783.783 INFO    ] sku_id is --> 4500752
[2026-10-14 08:22:59,785.785 INFO    ] qty is --> 4
[2026-10-14 08:22:59,800.800 INFO    ] sku_name is --> Poptail Watermelon Boba Drink 250ml
[2026-10-14 08:22:59,801.801 INFO    ] tray_mismatch is --> {'sku_id': '4500752', 'sku_name': 'Poptail Watermelon Boba Drink 250ml', 'tray_id': '13', 'quantity_on_tray': '4', 'quantity_in_db': '4'}
[2026-10-14 08:22:59,803.803 INFO    ] tray mismatch found in tray ID --> 14
[2026-10-14 08:22:59,808.808 INFO    ] tray_sku_json is --> 4500499-6
[2026-10-14 08:22:59,810.810 INFO    ] sku_id is --> 4500499
[2026-10-14 08:22:59,812.812 INFO    ] qty is --> 6
[2026-10-14 08:22:59,951.951 INFO    ] sku_name is --> Heritage A1 Spiced Butter Milk180ml
[2026-10-14 08:22:59,953.953 INFO    ] tray_mismatch is --> {'sku_id': '4500499', 'sku_name': 'Heritage A1 Spiced Butter Milk180ml', 'tray_id': '14', 'quantity_on_tray': '6', 'quantity_in_db': '6'}
[2026-10-14 08:22:59,955.955 INFO    ] tray mismatch found in tray ID --> 15
[2026-10-14 08:22:59,961.961 INFO    ] tray_sku_json is --> 186001-2
[2026-10-14 08:22:59,963.963 INFO    ] sku_id is --> 186001
[2026-10-14 08:22:59,965.965 INFO    ] qty is --> 2
[2026-10-14 08:22:59,980.980 INFO    ] sku_name is --> Nestle Nescafe Chilled Latte Coffee Milk 
[2026-10-14 08:22:59,982.982 INFO    ] tray_mismatch is --> {'sku_id': '186001', 'sku_name': 'Nestle Nescafe Chilled Latte Coffee Milk ', 'tray_id': '15', 'quantity_on_tray': '5', 'quantity_in_db': '2'}
[2026-10-14 08:22:59,983.983 INFO    ] tray mismatch found in tray ID --> 16
[2026-10-14 08:22:59,988.988 INFO    ] tray_sku_json is --> 4500563-0
[2026-10-14 08:22:59,990.990 INFO    ] sku_id is --> 4500563
[2026-10-14 08:22:59,992.992 INFO    ] qty is --> 0
[2026-10-14 08:23:00,114.114 INFO    ] sku_name is --> Wholy Fudgy Cakes Hazelnut Chocolate 32g
[2026-10-14 08:23:00,116.116 INFO    ] tray_mismatch is --> {'sku_id': '4500563', 'sku_name': 'Wholy Fudgy Cakes Hazelnut Chocolate 32g', 'tray_id': '16', 'quantity_on_tray': '8', 'quantity_in_db': '0'}
[2026-10-14 08:23:00,118.118 INFO    ] tray mismatch found in tray ID --> 17
[2026-10-14 08:23:00,123.123 INFO    ] tray_sku_json is --> 112220-20
[2026-10-14 08:23:00,125.125 INFO    ] sku_id is --> 112220
[2026-10-14 08:23:00,126.126 INFO    ] qty is --> 20
[2026-10-14 08:23:00,244.244 INFO    ] sku_name is --> Snickers Chocolate Bar 22g
[2026-10-14 08:23:00,246.246 INFO    ] tray_mismatch is --> {'sku_id': '112220', 'sku_name': 'Snickers Chocolate Bar 22g', 'tray_id': '17', 'quantity_on_tray': '19', 'quantity_in_db': '20'}
[2026-10-14 08:23:00,248.248 INFO    ] tray mismatch found in tray ID --> 18
[2026-10-14 08:23:00,253.253 INFO    ] tray_sku_json is --> 4500737-0
[2026-10-14 08:23:00,255.255 INFO    ] sku_id is --> 4500737
[2026-10-14 08:23:00,256.256 INFO    ] qty is --> 0
[2026-10-14 08:23:00,382.382 INFO    ] sku_name is --> WinGreen Harvest Crunchy Granola Bar 25gm
[2026-10-14 08:23:00,384.384 INFO    ] tray_mismatch is --> {'sku_id': '4500737', 'sku_name': 'WinGreen Harvest Crunchy Granola Bar 25gm', 'tray_id': '18', 'quantity_on_tray': '9', 'quantity_in_db': '0'}
[2026-10-14 08:23:00,385.385 INFO    ] tray mismatch found in tray ID --> 19
[2026-10-14 08:23:00,390.390 INFO    ] tray_sku_json is --> 4500648-12
[2026-10-14 08:23:00,392.392 INFO    ] sku_id is --> 4500648
[2026-10-14 08:23:00,394.394 INFO    ] qty is --> 12
[2026-10-14 08:23:00,523.523 INFO    ] sku_name is --> Modern kitchens Banana Chips 21gm
[2026-10-14 08:23:00,525.525 INFO    ] tray_mismatch is --> {'sku_id': '4500648', 'sku_name': 'Modern kitchens Banana Chips 21gm', 'tray_id': '19', 'quantity_on_tray': '12', 'quantity_in_db': '12'}
[2026-10-14 08:23:00,527.527 INFO    ] tray mismatch found in tray ID --> 20
[2026-10-14 08:23:00,532.532 INFO    ] tray_sku_json is --> 4500667-7
[2026-10-14 08:23:00,534.534 INFO    ] sku_id is --> 4500667
[2026-10-14 08:23:00,535.535 INFO    ] qty is --> 7
[2026-10-14 08:23:00,654.654 INFO    ] sku_name is --> Farmely Classic date Bites 20gm
[2026-10-14 08:23:00,656.656 INFO    ] tray_mismatch is --> {'sku_id': '4500667', 'sku_name': 'Farmely Classic date Bites 20gm', 'tray_id': '20', 'quantity_on_tray': '14', 'quantity_in_db': '7'}
[2026-10-14 08:23:00,658.658 INFO    ] tray mismatch found in tray ID --> 21
[2026-10-14 08:23:00,662.662 INFO    ] tray_sku_json is --> 4500669-0
[2026-10-14 08:23:00,664.664 INFO    ] sku_id is --> 4500669
[2026-10-14 08:23:00,666.666 INFO    ] qty is --> 0
[2026-10-14 08:23:00,681.681 INFO    ] sku_name is --> Rite Bite Sports Bar 40gm
[2026-10-14 08:23:00,683.683 INFO    ] tray_mismatch is --> {'sku_id': '4500669', 'sku_name': 'Rite Bite Sports Bar 40gm', 'tray_id': '21', 'quantity_on_tray': '8', 'quantity_in_db': '0'}
[2026-10-14 08:23:00,685.685 INFO    ] tray mismatch found in tray ID --> 22
[2026-10-14 08:23:00,690.690 INFO    ] tray_sku_json is --> 4500708-2
[2026-10-14 08:23:00,691.691 INFO    ] sku_id is --> 4500708
[2026-10-14 08:23:00,693.693 INFO    ] qty is --> 2
[2026-10-14 08:23:00,820.820 INFO    ] sku_name is --> Modern Kitchen Masala Peanut 28gm
[2026-10-14 08:23:00,824.824 INFO    ] tray_mismatch is --> {'sku_id': '4500708', 'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'tray_id': '22', 'quantity_on_tray': '9', 'quantity_in_db': '2'}
[2026-10-14 08:23:00,826.826 INFO    ] tray mismatch found in tray ID --> 23
[2026-10-14 08:23:00,833.833 INFO    ] tray_sku_json is --> 4500653-0
[2026-10-14 08:23:00,834.834 INFO    ] sku_id is --> 4500653
[2026-10-14 08:23:00,836.836 INFO    ] qty is --> 0
[2026-10-14 08:23:00,966.966 INFO    ] sku_name is --> Modern kitchens Kabuli Channa 26gm
[2026-10-14 08:23:00,968.968 INFO    ] tray_mismatch is --> {'sku_id': '4500653', 'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'tray_id': '23', 'quantity_on_tray': '7', 'quantity_in_db': '0'}
[2026-10-14 08:23:00,970.970 INFO    ] tray mismatch found in tray ID --> 24
[2026-10-14 08:23:00,975.975 INFO    ] tray_sku_json is --> 186084-15
[2026-10-14 08:23:00,977.977 INFO    ] sku_id is --> 186084
[2026-10-14 08:23:00,979.979 INFO    ] qty is --> 15
[2026-10-14 08:23:01,097.097 INFO    ] sku_name is --> KITKAT Nestle 4 Finger Chocolate 38g
[2026-10-14 08:23:01,099.099 INFO    ] tray_mismatch is --> {'sku_id': '186084', 'sku_name': 'KITKAT Nestle 4 Finger Chocolate 38g', 'tray_id': '24', 'quantity_on_tray': '14', 'quantity_in_db': '15'}
[2026-10-14 08:23:01,101.101 INFO    ] tray mismatch found in tray ID --> 25
[2026-10-14 08:23:01,106.106 INFO    ] tray_sku_json is --> 4500564-12
[2026-10-14 08:23:01,108.108 INFO    ] sku_id is --> 4500564
[2026-10-14 08:23:01,110.110 INFO    ] qty is --> 12
[2026-10-14 08:23:01,230.230 INFO    ] sku_name is --> Wholy Fudgy Cakes Red Velvet 32g
[2026-10-14 08:23:01,232.232 INFO    ] tray_mismatch is --> {'sku_id': '4500564', 'sku_name': 'Wholy Fudgy Cakes Red Velvet 32g', 'tray_id': '25', 'quantity_on_tray': '11', 'quantity_in_db': '12'}
[2026-10-14 08:23:01,234.234 INFO    ] tray mismatch found in tray ID --> 26
[2026-10-14 08:23:01,239.239 INFO    ] tray_sku_json is --> 4500749-8
[2026-10-14 08:23:01,241.241 INFO    ] sku_id is --> 4500749
[2026-10-14 08:23:01,243.243 INFO    ] qty is --> 8
[2026-10-14 08:23:01,258.258 INFO    ] sku_name is --> Maxvita  cheese ball Tomato masti 70gm
[2026-10-14 08:23:01,260.260 INFO    ] tray_mismatch is --> {'sku_id': '4500749', 'sku_name': 'Maxvita  cheese ball Tomato masti 70gm', 'tray_id': '26', 'quantity_on_tray': '7', 'quantity_in_db': '8'}
[2026-10-14 08:23:01,262.262 INFO    ] response from startRefill is --> {'message': 'Tray mismatches found.', 'tray_mismatches': [{'sku_id': '177747', 'sku_name': 'Raw Coconut Water, 200ml', 'tray_id': '11', 'quantity_on_tray': '7', 'quantity_in_db': '4'}, {'sku_id': '186094', 'sku_name': 'Raw Alphonso Mango 200ml', 'tray_id': '12', 'quantity_on_tray': '5', 'quantity_in_db': '0'}, {'sku_id': '4500752', 'sku_name': 'Poptail Watermelon Boba Drink 250ml', 'tray_id': '13', 'quantity_on_tray': '4', 'quantity_in_db': '4'}, {'sku_id': '4500499', 'sku_name': 'Heritage A1 Spiced Butter Milk180ml', 'tray_id': '14', 'quantity_on_tray': '6', 'quantity_in_db': '6'}, {'sku_id': '186001', 'sku_name': 'Nestle Nescafe Chilled Latte Coffee Milk ', 'tray_id': '15', 'quantity_on_tray': '5', 'quantity_in_db': '2'}, {'sku_id': '4500563', 'sku_name': 'Wholy Fudgy Cakes Hazelnut Chocolate 32g', 'tray_id': '16', 'quantity_on_tray': '8', 'quantity_in_db': '0'}, {'sku_id': '112220', 'sku_name': 'Snickers Chocolate Bar 22g', 'tray_id': '17', 'quantity_on_tray': '19', 'quantity_in_db': '20'}, {'sku_id': '4500737', 'sku_name': 'WinGreen Harvest Crunchy Granola Bar 25gm', 'tray_id': '18', 'quantity_on_tray': '9', 'quantity_in_db': '0'}, {'sku_id': '4500648', 'sku_name': 'Modern kitchens Banana Chips 21gm', 'tray_id': '19', 'quantity_on_tray': '12', 'quantity_in_db': '12'}, {'sku_id': '4500667', 'sku_name': 'Farmely Classic date Bites 20gm', 'tray_id': '20', 'quantity_on_tray': '14', 'quantity_in_db': '7'}, {'sku_id': '4500669', 'sku_name': 'Rite Bite Sports Bar 40gm', 'tray_id': '21', 'quantity_on_tray': '8', 'quantity_in_db': '0'}, {'sku_id': '4500708', 'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'tray_id': '22', 'quantity_on_tray': '9', 'quantity_in_db': '2'}, {'sku_id': '4500653', 'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'tray_id': '23', 'quantity_on_tray': '7', 'quantity_in_db': '0'}, {'sku_id': '186084', 'sku_name': 'KITKAT Nestle 4 Finger Chocolate 38g', 'tray_id': '24', 'quantity_on_tray': '14', 'quantity_in_db': '15'}, {'sku_id': '4500564', 'sku_name': 'Wholy Fudgy Cakes Red Velvet 32g', 'tray_id': '25', 'quantity_on_tray': '11', 'quantity_in_db': '12'}, {'sku_id': '4500749', 'sku_name': 'Maxvita  cheese ball Tomato masti 70gm', 'tray_id': '26', 'quantity_on_tray': '7', 'quantity_in_db': '8'}], 'success': True}
[2026-10-14 08:23:27,463.463 INFO    ] completeRefill refill_content is --> {'txnType': 'refill', 'content': [{'sku_id': '177747', 'tray_id': '11', 'sku_name': 'Raw Coconut Water, 200ml', 'quantity_in_db': '4', 'quantity_on_tray': '7', 'check_enabled': True}, {'sku_id': '186094', 'tray_id': '12', 'sku_name': 'Raw Alphonso Mango 200ml', 'quantity_in_db': '0', 'quantity_on_tray': '5', 'check_enabled': True}, {'sku_id': '4500752', 'tray_id': '13', 'sku_name': 'Poptail Watermelon Boba Drink 250ml', 'quantity_in_db': '4', 'quantity_on_tray': '4', 'check_enabled': True}, {'sku_id': '4500499', 'tray_id': '14', 'sku_name': 'Heritage A1 Spiced Butter Milk180ml', 'quantity_in_db': '6', 'quantity_on_tray': '6', 'check_enabled': True}, {'sku_id': '186001', 'tray_id': '15', 'sku_name': 'Nestle Nescafe Chilled Latte Coffee Milk ', 'quantity_in_db': '2', 'quantity_on_tray': '5', 'check_enabled': True}, {'sku_id': '4500563', 'tray_id': '16', 'sku_name': 'Wholy Fudgy Cakes Hazelnut Chocolate 32g', 'quantity_in_db': '0', 'quantity_on_tray': '8', 'check_enabled': True}, {'sku_id': '112220', 'tray_id': '17', 'sku_name': 'Snickers Chocolate Bar 22g', 'quantity_in_db': '20', 'quantity_on_tray': '19', 'check_enabled': True}, {'sku_id': '4500737', 'tray_id': '18', 'sku_name': 'WinGreen Harvest Crunchy Granola Bar 25gm', 'quantity_in_db': '0', 'quantity_on_tray': '9', 'check_enabled': True}, {'sku_id': '4500648', 'tray_id': '19', 'sku_name': 'Modern kitchens Banana Chips 21gm', 'quantity_in_db': '12', 'quantity_on_tray': '12', 'check_enabled': True}, {'sku_id': '4500667', 'tray_id': '20', 'sku_name': 'Farmely Classic date Bites 20gm', 'quantity_in_db': '7', 'quantity_on_tray': '14', 'check_enabled': True}, {'sku_id': '4500669', 'tray_id': '21', 'sku_name': 'Rite Bite Sports Bar 40gm', 'quantity_in_db': '0', 'quantity_on_tray': '8', 'check_enabled': True}, {'sku_id': '4500708', 'tray_id': '22', 'sku_name': 'Modern Kitchen Masala Peanut 28gm', 'quantity_in_db': '2', 'quantity_on_tray': '9', 'check_enabled': True}, {'sku_id': '4500653', 'tray_id': '23', 'sku_name': 'Modern kitchens Kabuli Channa 26gm', 'quantity_in_db': '0', 'quantity_on_tray': '7', 'check_enabled': True}, {'sku_id': '186084', 'tray_id': '24', 'sku_name': 'KITKAT Nestle 4 Finger Chocolate 38g', 'quantity_in_db': '15', 'quantity_on_tray': '14', 'check_enabled': True}, {'sku_id': '4500564', 'tray_id': '25', 'sku_name': 'Wholy Fudgy Cakes Red Velvet 32g', 'quantity_in_db': '12', 'quantity_on_tray': '11', 'check_enabled': True}, {'sku_id': '4500749', 'tray_id': '26', 'sku_name': 'Maxvita  cheese ball Tomato masti 70gm', 'quantity_in_db': '8', 'quantity_on_tray': '7', 'check_enabled': True}], 'order_id': 'TM06202506_refill_261014081657', 'door_open_init': True, 'refill_id': '9690584', 'door_id': [1]}
[2026-10-14 08:23:27,466.466 INFO    ] Quantity updated for tray --> 11
[2026-10-14 08:23:27,498.498 INFO    ] Quantity updated for tray --> 12
[2026-10-14 08:23:27,533.533 INFO    ] Quantity updated for tray --> 15
[2026-10-14 08:23:27,560.560 INFO    ] Quantity updated for tray --> 16
[2026-10-14 08:23:27,584.584 INFO    ] Quantity updated for tray --> 17
[2026-10-14 08:23:27,611.611 INFO    ] Quantity updated for tray --> 18
[2026-10-14 08:23:27,637.637 INFO    ] Quantity updated for tray --> 20
[2026-10-14 08:23:27,667.667 INFO    ] Quantity updated for tray --> 21
[2026-10-14 08:23:27,701.701 INFO    ] Quantity updated for tray --> 22
[2026-10-14 08:23:29,100.100 INFO    ] Quantity updated for tray --> 23
[2026-10-14 08:23:29,131.131 INFO    ] Quantity updated for tray --> 24
[2026-10-14 08:23:29,193.193 INFO    ] Quantity updated for tray --> 25
[2026-10-14 08:23:29,225.225 INFO    ] Quantity updated for tray --> 26
[2026-10-14 08:23:29,260.260 INFO    ] calling checktrays in complete refill
[2026-10-14 08:23:29,887.887 INFO    ] Successfully updated refill time.
[2026-10-14 08:23:29,889.889 INFO    ] Trays with quantities updated --> [{"sku_id": "177747", "tray_id": "11", "sku_name": "Raw Coconut Water, 200ml", "quantity_in_db": "4", "quantity_on_tray": "7", "check_enabled": true}, {"sku_id": "186094", "tray_id": "12", "sku_name": "Raw Alphonso Mango 200ml", "quantity_in_db": "0", "quantity_on_tray": "5", "check_enabled": true}, {"sku_id": "186001", "tray_id": "15", "sku_name": "Nestle Nescafe Chilled Latte Coffee Milk ", "quantity_in_db": "2", "quantity_on_tray": "5", "check_enabled": true}, {"sku_id": "4500563", "tray_id": "16", "sku_name": "Wholy Fudgy Cakes Hazelnut Chocolate 32g", "quantity_in_db": "0", "quantity_on_tray": "8", "check_enabled": true}, {"sku_id": "112220", "tray_id": "17", "sku_name": "Snickers Chocolate Bar 22g", "quantity_in_db": "20", "quantity_on_tray": "19", "check_enabled": true}, {"sku_id": "4500737", "tray_id": "18", "sku_name": "WinGreen Harvest Crunchy Granola Bar 25gm", "quantity_in_db": "0", "quantity_on_tray": "9", "check_enabled": true}, {"sku_id": "4500667", "tray_id": "20", "sku_name": "Farmely Classic date Bites 20gm", "quantity_in_db": "7", "quantity_on_tray": "14", "check_enabled": true}, {"sku_id": "4500669", "tray_id": "21", "sku_name": "Rite Bite Sports Bar 40gm", "quantity_in_db": "0", "quantity_on_tray": "8", "check_enabled": true}, {"sku_id": "4500708", "tray_id": "22", "sku_name": "Modern Kitchen Masala Peanut 28gm", "quantity_in_db": "2", "quantity_on_tray": "9", "check_enabled": true}, {"sku_id": "4500653", "tray_id": "23", "sku_name": "Modern kitchens Kabuli Channa 26gm", "quantity_in_db": "0", "quantity_on_tray": "7", "check_enabled": true}, {"sku_id": "186084", "tray_id": "24", "sku_name": "KITKAT Nestle 4 Finger Chocolate 38g", "quantity_in_db": "15", "quantity_on_tray": "14", "check_enabled": true}, {"sku_id": "4500564", "tray_id": "25", "sku_name": "Wholy Fudgy Cakes Red Velvet 32g", "quantity_in_db": "12", "quantity_on_tray": "11", "check_enabled": true}, {"sku_id": "4500749", "tray_id": "26", "sku_name": "Maxvita  cheese ball Tomato masti 70gm", "quantity_in_db": "8", "quantity_on_tray": "7", "check_enabled": true}]
[2026-10-14 08:23:30,448.448 INFO    ] completeRefill response is --> {'success': True}
[2026-10-14 08:23:45,479.479 INFO    ] trays_before_refill --> [{"sku_json": "177747-1", "active": 1, "tray_id": 11, "created_at": "2026-10-03 09:25:47", "tray_weight": "227", "door_id": "1", "org_sku": "177747", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "186094-5", "active": 1, "tray_id": 12, "created_at": "2026-10-03 09:25:47", "tray_weight": "1214", "door_id": "1", "org_sku": "186094", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "8639-1", "active": 1, "tray_id": 13, "created_at": "2026-10-03 09:25:47", "tray_weight": "6", "door_id": "1", "org_sku": "8639", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500499-0", "active": 1, "tray_id": 14, "created_at": "2026-10-03 09:25:47", "tray_weight": "190", "door_id": "1", "org_sku": "4500499", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "186001-3", "active": 1, "tray_id": 15, "created_at": "2026-10-03 09:25:47", "tray_weight": "605", "door_id": "1", "org_sku": "186001", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500563-8", "active": 1, "tray_id": 16, "created_at": "2026-10-03 09:25:47", "tray_weight": "290", "door_id": "1", "org_sku": "4500563", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500571-1", "active": 1, "tray_id": 17, "created_at": "2026-10-03 09:25:47", "tray_weight": "34", "door_id": "1", "org_sku": "4500571", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500737-9", "active": 1, "tray_id": 18, "created_at": "2026-10-03 09:25:47", "tray_weight": "253", "door_id": "1", "org_sku": "4500737", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500723-2", "active": 1, "tray_id": 19, "created_at": "2026-10-03 09:25:47", "tray_weight": "78", "door_id": "1", "org_sku": "4500723", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500667-5", "active": 1, "tray_id": 20, "created_at": "2026-10-03 09:25:47", "tray_weight": "74", "door_id": "1", "org_sku": "4500667", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500669-8", "active": 1, "tray_id": 21, "created_at": "2026-10-03 09:25:47", "tray_weight": "371", "door_id": "1", "org_sku": "4500669", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500708-8", "active": 1, "tray_id": 22, "created_at": "2026-10-03 09:25:47", "tray_weight": "244", "door_id": "1", "org_sku": "4500708", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500653-8", "active": 1, "tray_id": 23, "created_at": "2026-10-03 09:25:47", "tray_weight": "226", "door_id": "1", "org_sku": "4500653", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "186084-0", "active": 1, "tray_id": 24, "created_at": "2026-10-03 09:25:47", "tray_weight": "-4", "door_id": "1", "org_sku": "186084", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500732-0", "active": 1, "tray_id": 25, "created_at": "2026-10-03 09:25:47", "tray_weight": "11", "door_id": "1", "org_sku": "4500732", "modified_at": "2026-10-03 09:25:47"}, {"sku_json": "4500448-0", "active": 1, "tray_id": 26, "created_at": "2026-10-03 09:25:47", "tray_weight": "96", "door_id": "1", "org_sku": "4500448", "modified_at": "2026-10-03 09:25:47"}]
[2026-10-14 08:23:45,485.485 INFO    ] trays_after_refill --> [{"sku_json": "177747-7", "active": 1, "tray_id": 11, "created_at": "2026-10-14 08:22:53", "tray_weight": "1603", "door_id": "1", "org_sku": "177747", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "186094-5", "active": 1, "tray_id": 12, "created_at": "2026-10-14 08:22:53", "tray_weight": "1211", "door_id": "1", "org_sku": "186094", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500752-4", "active": 1, "tray_id": 13, "created_at": "2026-10-14 08:22:53", "tray_weight": "1095", "door_id": "1", "org_sku": "4500752", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500499-6", "active": 1, "tray_id": 14, "created_at": "2026-10-14 08:22:53", "tray_weight": "1342", "door_id": "1", "org_sku": "4500499", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "186001-5", "active": 1, "tray_id": 15, "created_at": "2026-10-14 08:22:53", "tray_weight": "1010", "door_id": "1", "org_sku": "186001", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500563-8", "active": 1, "tray_id": 16, "created_at": "2026-10-14 08:22:53", "tray_weight": "290", "door_id": "1", "org_sku": "4500563", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "112220-19", "active": 1, "tray_id": 17, "created_at": "2026-10-14 08:22:53", "tray_weight": "458", "door_id": "1", "org_sku": "112220", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500737-9", "active": 1, "tray_id": 18, "created_at": "2026-10-14 08:22:53", "tray_weight": "253", "door_id": "1", "org_sku": "4500737", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500648-12", "active": 1, "tray_id": 19, "created_at": "2026-10-14 08:22:53", "tray_weight": "300", "door_id": "1", "org_sku": "4500648", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500667-14", "active": 1, "tray_id": 20, "created_at": "2026-10-14 08:22:53", "tray_weight": "331", "door_id": "1", "org_sku": "4500667", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500669-8", "active": 1, "tray_id": 21, "created_at": "2026-10-14 08:22:53", "tray_weight": "370", "door_id": "1", "org_sku": "4500669", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500708-9", "active": 1, "tray_id": 22, "created_at": "2026-10-14 08:22:53", "tray_weight": "305", "door_id": "1", "org_sku": "4500708", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500653-7", "active": 1, "tray_id": 23, "created_at": "2026-10-14 08:22:53", "tray_weight": "224", "door_id": "1", "org_sku": "4500653", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "186084-14", "active": 1, "tray_id": 24, "created_at": "2026-10-14 08:22:53", "tray_weight": "589", "door_id": "1", "org_sku": "186084", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500564-11", "active": 1, "tray_id": 25, "created_at": "2026-10-14 08:22:53", "tray_weight": "407", "door_id": "1", "org_sku": "4500564", "modified_at": "2026-10-14 08:22:53"}, {"sku_json": "4500749-7", "active": 1, "tray_id": 26, "created_at": "2026-10-14 08:22:53", "tray_weight": "512", "door_id": "1", "org_sku": "4500749", "modified_at": "2026-10-14 08:22:53"}]
[2026-10-14 08:23:45,489.489 INFO    ] compute_stock_transfer trays_before_refill is --> [{'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '227', 'tray_id': 11, 'sku_json': '177747-1', 'door_id': '1', 'org_sku': '177747', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '1214', 'tray_id': 12, 'sku_json': '186094-5', 'door_id': '1', 'org_sku': '186094', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '6', 'tray_id': 13, 'sku_json': '8639-1', 'door_id': '1', 'org_sku': '8639', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '190', 'tray_id': 14, 'sku_json': '4500499-0', 'door_id': '1', 'org_sku': '4500499', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '605', 'tray_id': 15, 'sku_json': '186001-3', 'door_id': '1', 'org_sku': '186001', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '290', 'tray_id': 16, 'sku_json': '4500563-8', 'door_id': '1', 'org_sku': '4500563', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '34', 'tray_id': 17, 'sku_json': '4500571-1', 'door_id': '1', 'org_sku': '4500571', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '253', 'tray_id': 18, 'sku_json': '4500737-9', 'door_id': '1', 'org_sku': '4500737', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '78', 'tray_id': 19, 'sku_json': '4500723-2', 'door_id': '1', 'org_sku': '4500723', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '74', 'tray_id': 20, 'sku_json': '4500667-5', 'door_id': '1', 'org_sku': '4500667', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '371', 'tray_id': 21, 'sku_json': '4500669-8', 'door_id': '1', 'org_sku': '4500669', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '244', 'tray_id': 22, 'sku_json': '4500708-8', 'door_id': '1', 'org_sku': '4500708', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '226', 'tray_id': 23, 'sku_json': '4500653-8', 'door_id': '1', 'org_sku': '4500653', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '-4', 'tray_id': 24, 'sku_json': '186084-0', 'door_id': '1', 'org_sku': '186084', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '11', 'tray_id': 25, 'sku_json': '4500732-0', 'door_id': '1', 'org_sku': '4500732', 'modified_at': '2026-10-03 09:25:47'}, {'created_at': '2026-10-03 09:25:47', 'active': 1, 'tray_weight': '96', 'tray_id': 26, 'sku_json': '4500448-0', 'door_id': '1', 'org_sku': '4500448', 'modified_at': '2026-10-03 09:25:47'}]
[2026-10-14 08:23:45,491.491 INFO    ] compute_stock_transfer trays_after_refill is --> [{'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '1603', 'tray_id': 11, 'sku_json': '177747-7', 'door_id': '1', 'org_sku': '177747', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '1211', 'tray_id': 12, 'sku_json': '186094-5', 'door_id': '1', 'org_sku': '186094', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '1095', 'tray_id': 13, 'sku_json': '4500752-4', 'door_id': '1', 'org_sku': '4500752', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '1342', 'tray_id': 14, 'sku_json': '4500499-6', 'door_id': '1', 'org_sku': '4500499', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '1010', 'tray_id': 15, 'sku_json': '186001-5', 'door_id': '1', 'org_sku': '186001', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '290', 'tray_id': 16, 'sku_json': '4500563-8', 'door_id': '1', 'org_sku': '4500563', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '458', 'tray_id': 17, 'sku_json': '112220-19', 'door_id': '1', 'org_sku': '112220', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '253', 'tray_id': 18, 'sku_json': '4500737-9', 'door_id': '1', 'org_sku': '4500737', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '300', 'tray_id': 19, 'sku_json': '4500648-12', 'door_id': '1', 'org_sku': '4500648', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '331', 'tray_id': 20, 'sku_json': '4500667-14', 'door_id': '1', 'org_sku': '4500667', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '370', 'tray_id': 21, 'sku_json': '4500669-8', 'door_id': '1', 'org_sku': '4500669', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '305', 'tray_id': 22, 'sku_json': '4500708-9', 'door_id': '1', 'org_sku': '4500708', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '224', 'tray_id': 23, 'sku_json': '4500653-7', 'door_id': '1', 'org_sku': '4500653', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '589', 'tray_id': 24, 'sku_json': '186084-14', 'door_id': '1', 'org_sku': '186084', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '407', 'tray_id': 25, 'sku_json': '4500564-11', 'door_id': '1', 'org_sku': '4500564', 'modified_at': '2026-10-14 08:22:53'}, {'created_at': '2026-10-14 08:22:53', 'active': 1, 'tray_weight': '512', 'tray_id': 26, 'sku_json': '4500749-7', 'door_id': '1', 'org_sku': '4500749', 'modified_at': '2026-10-14 08:22:53'}]
[2026-10-14 08:23:45,493.493 INFO    ] trays_comparison_list is --> <zip object at 0x724db3a0>
[2026-10-14 08:23:45,502.502 INFO    ] tray_id[11] type:add sku_id:before[177747] after[177747] weight:initial[227] final[1603] weightdiff[1376] qtyDB:before[1] after:[7] qtyWeight[6]
[2026-10-14 08:23:45,504.504 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 6, 'tray_id': '11', 'sku_removed': '177747', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,513.513 INFO    ] tray_id[12] type:no_change sku_id:before[186094] after[186094] weight:initial[1214] final[1211] weightdiff[3] qtyDB:before[5] after:[5] qtyWeight[0]
[2026-10-14 08:23:45,514.514 INFO    ] No change on tray --> 12
[2026-10-14 08:23:45,523.523 INFO    ] stock_json is --> {'type': 'replace', 'sku_added': '4500752', 'quantity_added_to_tray': 4, 'tray_id': '13', 'sku_removed': '8639', 'quantity_removed_from_tray': 1}
[2026-10-14 08:23:45,525.525 INFO    ] tray_id[13] type:replace sku_id:before[8639] after[4500752] weight:initial[0] final[1095] weightdiff[1095] qtyDB:before[0] after[4] qtyWeight[4]
[2026-10-14 08:23:45,584.584 INFO    ] tray_id[14] type:add sku_id:before[4500499] after[4500499] weight:initial[190] final[1342] weightdiff[1152] qtyDB:before[0] after:[6] qtyWeight[6]
[2026-10-14 08:23:45,588.588 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 6, 'tray_id': '14', 'sku_removed': '4500499', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,598.598 INFO    ] tray_id[15] type:add sku_id:before[186001] after[186001] weight:initial[605] final[1010] weightdiff[405] qtyDB:before[3] after:[5] qtyWeight[2]
[2026-10-14 08:23:45,599.599 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 2, 'tray_id': '15', 'sku_removed': '186001', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,608.608 INFO    ] tray_id[16] type:no_change sku_id:before[4500563] after[4500563] weight:initial[290] final[290] weightdiff[0] qtyDB:before[8] after:[8] qtyWeight[0]
[2026-10-14 08:23:45,610.610 INFO    ] No change on tray --> 16
[2026-10-14 08:23:45,657.657 INFO    ] stock_json is --> {'type': 'replace', 'sku_added': '112220', 'quantity_added_to_tray': 19, 'tray_id': '17', 'sku_removed': '4500571', 'quantity_removed_from_tray': 1}
[2026-10-14 08:23:45,659.659 INFO    ] tray_id[17] type:replace sku_id:before[4500571] after[112220] weight:initial[0] final[458] weightdiff[458] qtyDB:before[0] after[19] qtyWeight[11]
[2026-10-14 08:23:45,668.668 INFO    ] tray_id[18] type:no_change sku_id:before[4500737] after[4500737] weight:initial[253] final[253] weightdiff[0] qtyDB:before[9] after:[9] qtyWeight[0]
[2026-10-14 08:23:45,669.669 INFO    ] No change on tray --> 18
[2026-10-14 08:23:45,720.720 INFO    ] stock_json is --> {'type': 'replace', 'sku_added': '4500648', 'quantity_added_to_tray': 12, 'tray_id': '19', 'sku_removed': '4500723', 'quantity_removed_from_tray': 2}
[2026-10-14 08:23:45,721.721 INFO    ] tray_id[19] type:replace sku_id:before[4500723] after[4500648] weight:initial[0] final[300] weightdiff[300] qtyDB:before[0] after[12] qtyWeight[11]
[2026-10-14 08:23:45,773.773 INFO    ] tray_id[20] type:add sku_id:before[4500667] after[4500667] weight:initial[74] final[331] weightdiff[257] qtyDB:before[5] after:[14] qtyWeight[11]
[2026-10-14 08:23:45,774.774 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 9, 'tray_id': '20', 'sku_removed': '4500667', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,783.783 INFO    ] tray_id[21] type:no_change sku_id:before[4500669] after[4500669] weight:initial[371] final[370] weightdiff[1] qtyDB:before[8] after:[8] qtyWeight[0]
[2026-10-14 08:23:45,785.785 INFO    ] No change on tray --> 21
[2026-10-14 08:23:45,793.793 INFO    ] tray_id[22] type:add sku_id:before[4500708] after[4500708] weight:initial[244] final[305] weightdiff[61] qtyDB:before[8] after:[9] qtyWeight[2]
[2026-10-14 08:23:45,795.795 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 1, 'tray_id': '22', 'sku_removed': '4500708', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,804.804 INFO    ] tray_id[23] type:remove sku_id:before[4500653] after[4500653] weight:initial[226] final[224] weightdiff[2] qtyDB:before[8] after:[7] qtyWeight[0]
[2026-10-14 08:23:45,806.806 INFO    ] stock_json is --> {'type': 'remove', 'sku_added': '4500653', 'tray_id': '23', 'quantity_removed_from_tray': 1, 'sku_removed': '', 'quantity_added_to_tray': 0}
[2026-10-14 08:23:45,873.873 INFO    ] tray_id[24] type:add sku_id:before[186084] after[186084] weight:initial[-4] final[589] weightdiff[593] qtyDB:before[0] after:[14] qtyWeight[14]
[2026-10-14 08:23:45,876.876 INFO    ] stock_json is --> {'type': 'add', 'sku_added': '', 'quantity_added_to_tray': 14, 'tray_id': '24', 'sku_removed': '186084', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,952.952 INFO    ] stock_json is --> {'type': 'replace', 'sku_added': '4500564', 'quantity_added_to_tray': 11, 'tray_id': '25', 'sku_removed': '4500732', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:45,955.955 INFO    ] tray_id[25] type:replace sku_id:before[4500732] after[4500564] weight:initial[0] final[407] weightdiff[407] qtyDB:before[0] after[11] qtyWeight[9]
[2026-10-14 08:23:46,059.059 INFO    ] stock_json is --> {'type': 'replace', 'sku_added': '4500749', 'quantity_added_to_tray': 7, 'tray_id': '26', 'sku_removed': '4500448', 'quantity_removed_from_tray': 0}
[2026-10-14 08:23:46,063.063 INFO    ] tray_id[26] type:replace sku_id:before[4500448] after[4500749] weight:initial[0] final[512] weightdiff[512] qtyDB:before[0] after[7] qtyWeight[8]
[2026-10-14 08:23:46,072.072 INFO    ] stock_transfer is --> [{"type": "add", "sku_added": "", "quantity_added_to_tray": 6, "tray_id": "11", "sku_removed": "177747", "quantity_removed_from_tray": 0}, {"type": "replace", "sku_added": "4500752", "quantity_added_to_tray": 4, "tray_id": "13", "sku_removed": "8639", "quantity_removed_from_tray": 1}, {"type": "add", "sku_added": "", "quantity_added_to_tray": 6, "tray_id": "14", "sku_removed": "4500499", "quantity_removed_from_tray": 0}, {"type": "add", "sku_added": "", "quantity_added_to_tray": 2, "tray_id": "15", "sku_removed": "186001", "quantity_removed_from_tray": 0}, {"type": "replace", "sku_added": "112220", "quantity_added_to_tray": 19, "tray_id": "17", "sku_removed": "4500571", "quantity_removed_from_tray": 1}, {"type": "replace", "sku_added": "4500648", "quantity_added_to_tray": 12, "tray_id": "19", "sku_removed": "4500723", "quantity_removed_from_tray": 2}, {"type": "add", "sku_added": "", "quantity_added_to_tray": 9, "tray_id": "20", "sku_removed": "4500667", "quantity_removed_from_tray": 0}, {"type": "add", "sku_added": "", "quantity_added_to_tray": 1, "tray_id": "22", "sku_removed": "4500708", "quantity_removed_from_tray": 0}, {"type": "remove", "sku_added": "4500653", "tray_id": "23", "quantity_removed_from_tray": 1, "sku_removed": "", "quantity_added_to_tray": 0}, {"type": "add", "sku_added": "", "quantity_added_to_tray": 14, "tray_id": "24", "sku_removed": "186084", "quantity_removed_from_tray": 0}, {"type": "replace", "sku_added": "4500564", "quantity_added_to_tray": 11, "tray_id": "25", "sku_removed": "4500732", "quantity_removed_from_tray": 0}, {"type": "replace", "sku_added": "4500749", "quantity_added_to_tray": 7, "tray_id": "26", "sku_removed": "4500448", "quantity_removed_from_tray": 0}]
[2026-10-14 08:23:46,172.172 INFO    ] tray_mismatches are --> [{"expected_tray_weigth": 1152, "db_sku_qty": "6", "actual_tray_weight": 1342, "tray_id": 14, "expected_sku_qty": 6}]
[2026-10-14 08:23:46,222.222 INFO    ] calculate_refill_data response --> {"message": "Refill data successfully updated.", "success": true}
[2026-10-14 08:23:46,734.734 INFO    ] Refill data successfully synced.
[2026-10-14 18:24:06,736.736 INFO    ] 
###################################
####### PI SERVER STARTED #########
###################################