HSR, 2026-01-21, morning, TM06202004,1, 0,,Full_Auto_Refill_Sales_GQE
Array
(
[0] => Array
(
[vm_id] => 7421137583197604045
[vm_imei_id] => TM06202004
[location] => Mediatek 4_C 9th Floor
[cluster] => HSR
)
)
***** start of vm id : TM06202004 second pass
17 has negative weight -20.0
Array
(
[4500519] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500552] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500554] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500567] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500607] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[166327] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[132266] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500617] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500564] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500573] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185971] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500609] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500611] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185950] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500566] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500571] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500605] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[159378] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185970] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500620] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185953] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
)
select * from planogram_fixing_details where imei='TM06202004' and slot='morning' and from_date<='2026-01-21' order by from_date desc limit 1
Array
(
[0] => Array
(
[id] => TM06202004-2021-11-26-morning
[imei] => TM06202004
[machine_name] => TM Texas Main Cafetaria PPE
[machine_type] => TM-Corporate
[from_date] => 2021-11-26
[to_date] => 2021-12-26
[slot] => morning
[plan_status] => 1
[plan_json] => [{"tray_id":"11","door_id":"1","sku":"180","name":"Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient","qty":"12","refill_threshold":"2","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"12","door_id":"1","sku":"145724","name":"Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold","qty":"16","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"13","door_id":"1","sku":"155387","name":"Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient","qty":"8","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"14","door_id":"1","sku":"135838","name":"Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient","qty":"8","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"15","door_id":"1","sku":"8639","name":"Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"16","door_id":"1","sku":"129197","name":"25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"17","door_id":"1","sku":"8901","name":"Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"18","door_id":"1","sku":"8562","name":"Coca Cola, 250ml ID:8562 Price:20 Weight:274 T:Cold","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"19","door_id":"1","sku":"121399","name":"Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"20","door_id":"1","sku":"105617","name":"Winkies Fruit Cake ,55g ID:105617 Price:15 Weight:58 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"21","door_id":"1","sku":"2332","name":"Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"22","door_id":"1","sku":"6119","name":"Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"23","door_id":"1","sku":"137335","name":"Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold","qty":"15","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"24","door_id":"1","sku":"108567","name":"OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"25","door_id":"1","sku":"175980","name":"Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"26","door_id":"1","sku":"183807","name":"Tropicana Pomegranate Delight - 200ml Rs, 20 ID:183807 Price:20 Weight:197 T:Cold","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"27","door_id":"1","sku":"112220","name":"Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold","qty":"15","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"28","door_id":"1","sku":"123126","name":"Cadbury Dairy Milk Chocolate Mahapack, 57g ID:123126 Price:50 Weight:57 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"29","door_id":"1","sku":"171810","name":"Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"30","door_id":"1","sku":"283","name":"Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"31","door_id":"1","sku":"173768","name":"Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"32","door_id":"1","sku":"156976","name":"Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"}]
[edited_by] => Barun
[created_at] => 2022-12-29 13:14:44
[modified_at] => 2022-12-29 13:14:44
[vendor_id] =>
)
)
result tray after fixed refill
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
)
)
Cold products after fixed refill 0 and Ambient count 0
odoo stcok reduction 180 imei TM06202004 Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1 allocated stock: odoo_stock:-12 picking_qty:12
odoo stcok reduction 145724 imei TM06202004 Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724 allocated stock: odoo_stock:-16 picking_qty:16
odoo stcok reduction 155387 imei TM06202004 Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1 allocated stock: odoo_stock:-20 picking_qty:8
odoo stcok reduction 135838 imei TM06202004 Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1 allocated stock: odoo_stock:-28 picking_qty:8
odoo stcok reduction 8639 imei TM06202004 Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639 allocated stock: odoo_stock:-14 picking_qty:14
odoo stcok reduction 129197 imei TM06202004 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1 allocated stock: odoo_stock:-38 picking_qty:10
odoo stcok reduction 8901 imei TM06202004 Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901 allocated stock: odoo_stock:-14 picking_qty:14
odoo stcok reduction 8562 imei TM06202004 Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562 allocated stock: odoo_stock:-14 picking_qty:14
odoo stcok reduction 121399 imei TM06202004 Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1 allocated stock: odoo_stock:-50 picking_qty:12
odoo stcok reduction 105617 imei TM06202004 Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617 allocated stock: odoo_stock:-12 picking_qty:12
odoo stcok reduction 2332 imei TM06202004 Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332 allocated stock: odoo_stock:-10 picking_qty:10
odoo stcok reduction 6119 imei TM06202004 Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119 allocated stock: odoo_stock:-12 picking_qty:12
odoo stcok reduction 137335 imei TM06202004 Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335 allocated stock: odoo_stock:-15 picking_qty:15
odoo stcok reduction 108567 imei TM06202004 OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1 allocated stock: odoo_stock:-60 picking_qty:10
odoo stcok reduction 175980 imei TM06202004 Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1 allocated stock: odoo_stock:-72 picking_qty:12
odoo stcok reduction 183807 imei TM06202004 Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807 allocated stock: odoo_stock:-14 picking_qty:14
odoo stcok reduction 112220 imei TM06202004 Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220 allocated stock: odoo_stock:-15 picking_qty:15
odoo stcok reduction 123126 imei TM06202004 Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126 allocated stock: odoo_stock:-12 picking_qty:12
odoo stcok reduction 171810 imei TM06202004 Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810 allocated stock: odoo_stock:-12 picking_qty:12
odoo stcok reduction 283 imei TM06202004 Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1 allocated stock: odoo_stock:-84 picking_qty:12
odoo stcok reduction 173768 imei TM06202004 Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1 allocated stock: odoo_stock:-96 picking_qty:12
odoo stcok reduction 156976 imei TM06202004 Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976 allocated stock: odoo_stock:-12 picking_qty:12
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 16
[picking_quantity] => 16
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 8
[picking_quantity] => 8
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 8
[picking_quantity] => 8
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 15
[picking_quantity] => 15
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 15
[picking_quantity] => 15
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
)
)
Array
(
[4500519] => Array
(
[qty] => 6
[tray] => 11
[no_of_trays] => 1
)
[4500552] => Array
(
[qty] => 3
[tray] => 12
[no_of_trays] => 1
)
[4500554] => Array
(
[qty] => 6
[tray] => 13
[no_of_trays] => 1
)
[4500567] => Array
(
[qty] => 4
[tray] => 14
[no_of_trays] => 1
)
[4500607] => Array
(
[qty] => 5
[tray] => 15
[no_of_trays] => 1
)
[166327] => Array
(
[qty] => 5
[tray] => 16
[no_of_trays] => 1
)
[132266] => Array
(
[qty] => 0
[tray] => 17
[no_of_trays] => 1
)
[4500617] => Array
(
[qty] => 5
[tray] => 18
[no_of_trays] => 1
)
[4500564] => Array
(
[qty] => 7
[tray] => 19,21
[no_of_trays] => 2
)
[4500573] => Array
(
[qty] => 6
[tray] => 20
[no_of_trays] => 1
)
[185971] => Array
(
[qty] => 2
[tray] => 22
[no_of_trays] => 1
)
[4500609] => Array
(
[qty] => 5
[tray] => 23
[no_of_trays] => 1
)
[4500611] => Array
(
[qty] => 6
[tray] => 24
[no_of_trays] => 1
)
[185950] => Array
(
[qty] => 15
[tray] => 25
[no_of_trays] => 1
)
[4500566] => Array
(
[qty] => 23
[tray] => 26
[no_of_trays] => 1
)
[4500571] => Array
(
[qty] => 6
[tray] => 27
[no_of_trays] => 1
)
[4500605] => Array
(
[qty] => 6
[tray] => 28
[no_of_trays] => 1
)
[159378] => Array
(
[qty] => 8
[tray] => 29
[no_of_trays] => 1
)
[185970] => Array
(
[qty] => 8
[tray] => 30
[no_of_trays] => 1
)
[4500620] => Array
(
[qty] => 7
[tray] => 31
[no_of_trays] => 1
)
[185953] => Array
(
[qty] => 9
[tray] => 32
[no_of_trays] => 1
)
)
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500519
[return_quantity] => 6
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 16
[picking_quantity] => 16
[return_sku] => 4500552
[return_quantity] => 3
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 8
[picking_quantity] => 8
[return_sku] => 4500554
[return_quantity] => 6
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 8
[picking_quantity] => 8
[return_sku] => 4500567
[return_quantity] => 4
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500607
[return_quantity] => 5
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 166327
[return_quantity] => 5
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 132266
[return_quantity] => 0
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500617
[return_quantity] => 5
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500564
[return_quantity] => 7
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500573
[return_quantity] => 6
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 4500564
[return_quantity] => 0
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185971
[return_quantity] => 2
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 15
[picking_quantity] => 15
[return_sku] => 4500609
[return_quantity] => 5
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 4500611
[return_quantity] => 6
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185950
[return_quantity] => 15
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500566
[return_quantity] => 23
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 15
[picking_quantity] => 15
[return_sku] => 4500571
[return_quantity] => 6
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500605
[return_quantity] => 6
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 159378
[return_quantity] => 8
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185970
[return_quantity] => 8
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500620
[return_quantity] => 7
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] =>
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185953
[return_quantity] => 9
)
)
***** end of vm id : TM06202004
arguments TM06202004, 2026-01-21,morning, 1, 0,,Full_Auto_Refill_Sales_GQE,
Array
(
[refill_id] => 9689098
[imei] => TM06202004
[tray_json] => [{"tray_id":"11","door_id":"1","tray_weight":"99999","sku_json":"180-12","org_sku":"180","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"12","door_id":"1","tray_weight":"99999","sku_json":"145724-16","org_sku":"145724","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"13","door_id":"1","tray_weight":"99999","sku_json":"155387-8","org_sku":"155387","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"14","door_id":"1","tray_weight":"99999","sku_json":"135838-8","org_sku":"135838","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"15","door_id":"1","tray_weight":"99999","sku_json":"8639-14","org_sku":"8639","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"16","door_id":"1","tray_weight":"99999","sku_json":"129197-10","org_sku":"129197","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"17","door_id":"1","tray_weight":"99999","sku_json":"8901-14","org_sku":"8901","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"18","door_id":"1","tray_weight":"99999","sku_json":"8562-14","org_sku":"8562","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"19","door_id":"1","tray_weight":"99999","sku_json":"121399-12","org_sku":"121399","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"20","door_id":"1","tray_weight":"99999","sku_json":"105617-12","org_sku":"105617","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"21","door_id":"1","tray_weight":"99999","sku_json":"2332-10","org_sku":"2332","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"22","door_id":"1","tray_weight":"99999","sku_json":"6119-12","org_sku":"6119","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"23","door_id":"1","tray_weight":"99999","sku_json":"137335-15","org_sku":"137335","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"24","door_id":"1","tray_weight":"99999","sku_json":"108567-10","org_sku":"108567","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"25","door_id":"1","tray_weight":"99999","sku_json":"175980-12","org_sku":"175980","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"26","door_id":"1","tray_weight":"99999","sku_json":"183807-14","org_sku":"183807","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"27","door_id":"1","tray_weight":"99999","sku_json":"112220-15","org_sku":"112220","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"28","door_id":"1","tray_weight":"99999","sku_json":"123126-12","org_sku":"123126","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"29","door_id":"1","tray_weight":"99999","sku_json":"171810-12","org_sku":"171810","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"30","door_id":"1","tray_weight":"99999","sku_json":"283-12","org_sku":"283","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"31","door_id":"1","tray_weight":"99999","sku_json":"173768-12","org_sku":"173768","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"},{"tray_id":"32","door_id":"1","tray_weight":"99999","sku_json":"156976-12","org_sku":"156976","active":"1","created_at":"2026-01-21 20:13:26","modified_at":"2026-01-21 20:13:26"}]
[created_at] => 2026-01-21 20:13:26
[last_modified_at] => 2026-01-21 20:13:26
[status] => active
[slot] => morning
[date_of_refill] => 2026-01-21
[refilled_at] =>
[time_of_refill] => 09:00:00
[edited_by] => single machine refill from UI
[total_quantity] => 268
[allocation_odoo_transaction] =>
[retrun_odoo_allocation] =>
[reallocation_odoo_transaction] =>
[transport_odoo_transaction] =>
[refill_odoo_transaction] =>
[return_odoo_transaction] =>
[expected_return_qty] => 142
[detailed_trays_json] => {"11":{"tray_id":"11","door_id":"1","org_sku":"4500519","live_sku":"4500519","live_qty":"6","live_weight":"2034.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"180","refill_sku_name":"Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"180","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"4500519","return_quantity":"6"},"12":{"tray_id":"12","door_id":"1","org_sku":"4500552","live_sku":"4500552","live_qty":"3","live_weight":"1028.0","live_qty_weight":0,"live_qty_act":"3","live_misplaced":"No","refill_sku_id":"145724","refill_sku_name":"Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724","refill_quantity":"16","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"145724","qe_refill_qty":"16","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"16","picking_quantity":"16","return_sku":"4500552","return_quantity":"3"},"13":{"tray_id":"13","door_id":"1","org_sku":"4500554","live_sku":"4500554","live_qty":"6","live_weight":"2048.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"155387","refill_sku_name":"Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1","refill_quantity":"8","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"155387","qe_refill_qty":"8","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"8","picking_quantity":"8","return_sku":"4500554","return_quantity":"6"},"14":{"tray_id":"14","door_id":"1","org_sku":"4500567","live_sku":"4500567","live_qty":"4","live_weight":"865.0","live_qty_weight":0,"live_qty_act":"4","live_misplaced":"No","refill_sku_id":"135838","refill_sku_name":"Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1","refill_quantity":"8","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"135838","qe_refill_qty":"8","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"8","picking_quantity":"8","return_sku":"4500567","return_quantity":"4"},"15":{"tray_id":"15","door_id":"1","org_sku":"4500607","live_sku":"4500607","live_qty":"5","live_weight":"1671.0","live_qty_weight":0,"live_qty_act":"5","live_misplaced":"No","refill_sku_id":"8639","refill_sku_name":"Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639","refill_quantity":"14","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"8639","qe_refill_qty":"14","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"14","picking_quantity":"14","return_sku":"4500607","return_quantity":"5"},"16":{"tray_id":"16","door_id":"1","org_sku":"166327","live_sku":"166327","live_qty":5,"live_weight":"1010.0","live_qty_weight":4.8095238095238,"live_qty_act":"5","live_misplaced":"No","refill_sku_id":"129197","refill_sku_name":"25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1","refill_quantity":"10","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"129197","qe_refill_qty":"10","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"10","picking_quantity":"10","return_sku":"166327","return_quantity":5},"17":{"tray_id":"17","door_id":"1","org_sku":"132266","live_sku":"132266","live_qty":"0","live_weight":"-20.0","live_qty_weight":0,"live_qty_act":"0","live_misplaced":"No","refill_sku_id":"8901","refill_sku_name":"Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901","refill_quantity":"14","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"8901","qe_refill_qty":"14","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"14","picking_quantity":"14","return_sku":"132266","return_quantity":"0"},"18":{"tray_id":"18","door_id":"1","org_sku":"4500617","live_sku":"4500617","live_qty":"5","live_weight":"1698.0","live_qty_weight":0,"live_qty_act":"5","live_misplaced":"No","refill_sku_id":"8562","refill_sku_name":"Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562","refill_quantity":"14","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"8562","qe_refill_qty":"14","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"14","picking_quantity":"14","return_sku":"4500617","return_quantity":"5"},"19":{"tray_id":"19","door_id":"1","org_sku":"4500564","live_sku":"4500564","live_qty":"7","live_weight":"363.0","live_qty_weight":0,"live_qty_act":"7","live_misplaced":"No","refill_sku_id":"121399","refill_sku_name":"Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"121399","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"4500564","return_quantity":"7"},"20":{"tray_id":"20","door_id":"1","org_sku":"4500573","live_sku":"4500573","live_qty":"6","live_weight":"310.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"105617","refill_sku_name":"Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"105617","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"4500573","return_quantity":"6"},"21":{"tray_id":"21","door_id":"1","org_sku":"4500564","live_sku":"4500564","live_qty":"0","live_weight":"38.0","live_qty_weight":0,"live_qty_act":"0","live_misplaced":"No","refill_sku_id":"2332","refill_sku_name":"Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332","refill_quantity":"10","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"2332","qe_refill_qty":"10","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"10","picking_quantity":"10","return_sku":"4500564","return_quantity":"0"},"22":{"tray_id":"22","door_id":"1","org_sku":"185971","live_sku":"185971","live_qty":2,"live_weight":"38.0","live_qty_weight":1.0857142857143,"live_qty_act":"2","live_misplaced":"No","refill_sku_id":"6119","refill_sku_name":"Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"6119","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"185971","return_quantity":2},"23":{"tray_id":"23","door_id":"1","org_sku":"4500609","live_sku":"4500609","live_qty":"5","live_weight":"301.0","live_qty_weight":0,"live_qty_act":"5","live_misplaced":"No","refill_sku_id":"137335","refill_sku_name":"Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335","refill_quantity":"15","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"137335","qe_refill_qty":"15","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"15","picking_quantity":"15","return_sku":"4500609","return_quantity":"5"},"24":{"tray_id":"24","door_id":"1","org_sku":"4500611","live_sku":"4500611","live_qty":"6","live_weight":"330.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"108567","refill_sku_name":"OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1","refill_quantity":"10","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"108567","qe_refill_qty":"10","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"10","picking_quantity":"10","return_sku":"4500611","return_quantity":"6"},"25":{"tray_id":"25","door_id":"1","org_sku":"185950","live_sku":"185950","live_qty":"15","live_weight":"454.0","live_qty_weight":0,"live_qty_act":"15","live_misplaced":"No","refill_sku_id":"175980","refill_sku_name":"Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"175980","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"185950","return_quantity":"15"},"26":{"tray_id":"26","door_id":"1","org_sku":"4500566","live_sku":"4500566","live_qty":"23","live_weight":"518.0","live_qty_weight":0,"live_qty_act":"23","live_misplaced":"No","refill_sku_id":"183807","refill_sku_name":"Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807","refill_quantity":"14","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"183807","qe_refill_qty":"14","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"14","picking_quantity":"14","return_sku":"4500566","return_quantity":"23"},"27":{"tray_id":"27","door_id":"1","org_sku":"4500571","live_sku":"4500571","live_qty":"6","live_weight":"262.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"112220","refill_sku_name":"Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220","refill_quantity":"15","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"112220","qe_refill_qty":"15","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"15","picking_quantity":"15","return_sku":"4500571","return_quantity":"6"},"28":{"tray_id":"28","door_id":"1","org_sku":"4500605","live_sku":"4500605","live_qty":"6","live_weight":"252.0","live_qty_weight":0,"live_qty_act":"6","live_misplaced":"No","refill_sku_id":"123126","refill_sku_name":"Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"123126","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"4500605","return_quantity":"6"},"29":{"tray_id":"29","door_id":"1","org_sku":"159378","live_sku":"159378","live_qty":"8","live_weight":"353.0","live_qty_weight":0,"live_qty_act":"8","live_misplaced":"No","refill_sku_id":"171810","refill_sku_name":"Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T7","qe_refill_sku":"171810","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"159378","return_quantity":"8"},"30":{"tray_id":"30","door_id":"1","org_sku":"185970","live_sku":"185970","live_qty":"8","live_weight":"299.0","live_qty_weight":0,"live_qty_act":"8","live_misplaced":"No","refill_sku_id":"283","refill_sku_name":"Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"283","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"185970","return_quantity":"8"},"31":{"tray_id":"31","door_id":"1","org_sku":"4500620","live_sku":"4500620","live_qty":"7","live_weight":"2198.0","live_qty_weight":0,"live_qty_act":"7","live_misplaced":"No","refill_sku_id":"173768","refill_sku_name":"Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T6","qe_refill_sku":"173768","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"4500620","return_quantity":"7"},"32":{"tray_id":"32","door_id":"1","org_sku":"185953","live_sku":"185953","live_qty":9,"live_weight":"495.0","live_qty_weight":8.5344827586207,"live_qty_act":"9","live_misplaced":"No","refill_sku_id":"156976","refill_sku_name":"Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976","refill_quantity":"12","Segment":"A","Temperature":"cold","Tray_type":"T7","qe_refill_sku":"156976","qe_refill_qty":"12","refill_reason":" fixed refill product replacement","odoo_stcok":null,"refill_qty":"12","picking_quantity":"12","return_sku":"185953","return_quantity":9}}
[expected_return_json] => [{"sku_id":"4500519","qty":"6"},{"sku_id":"4500552","qty":"3"},{"sku_id":"4500554","qty":"6"},{"sku_id":"4500567","qty":"4"},{"sku_id":"4500607","qty":"5"},{"sku_id":"166327","qty":5},{"sku_id":"4500617","qty":"5"},{"sku_id":"4500564","qty":"7"},{"sku_id":"4500573","qty":"6"},{"sku_id":"185971","qty":2},{"sku_id":"4500609","qty":"5"},{"sku_id":"4500611","qty":"6"},{"sku_id":"185950","qty":"15"},{"sku_id":"4500566","qty":"23"},{"sku_id":"4500571","qty":"6"},{"sku_id":"4500605","qty":"6"},{"sku_id":"159378","qty":"8"},{"sku_id":"185970","qty":"8"},{"sku_id":"4500620","qty":"7"},{"sku_id":"185953","qty":9}]
[actual_return_json] =>
[atcual_return_qty] =>
[vendor_id] => 1
[pickup_status] =>
[odoo_posting_status] =>
[acceptance] =>
[delivery_cluster] =>
[cleaning_needed] =>
[reason_for_refill] =>
[refill_group] =>
[reject_reason] =>
[accept_reject_timestamp] =>
[refill_tool_version] =>
)
***** start of vm id : TM06202004 second pass
17 has negative weight -20.0
Array
(
[4500519] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500552] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500554] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500567] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500607] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[166327] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[132266] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500617] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500564] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500573] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185971] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500609] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500611] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185950] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500566] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500571] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500605] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[159378] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185970] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[4500620] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
[185953] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] =>
[refill_sku_name] =>
[refill_quantity] =>
)
)
select * from planogram_fixing_details where imei='TM06202004' and slot='morning' and from_date<='2026-01-21' order by from_date desc limit 1
Array
(
[0] => Array
(
[id] => TM06202004-2021-11-26-morning
[imei] => TM06202004
[machine_name] => TM Texas Main Cafetaria PPE
[machine_type] => TM-Corporate
[from_date] => 2021-11-26
[to_date] => 2021-12-26
[slot] => morning
[plan_status] => 1
[plan_json] => [{"tray_id":"11","door_id":"1","sku":"180","name":"Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient","qty":"12","refill_threshold":"2","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"12","door_id":"1","sku":"145724","name":"Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold","qty":"16","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"13","door_id":"1","sku":"155387","name":"Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient","qty":"8","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"14","door_id":"1","sku":"135838","name":"Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient","qty":"8","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"15","door_id":"1","sku":"8639","name":"Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"16","door_id":"1","sku":"129197","name":"25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"17","door_id":"1","sku":"8901","name":"Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"18","door_id":"1","sku":"8562","name":"Coca Cola, 250ml ID:8562 Price:20 Weight:274 T:Cold","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"19","door_id":"1","sku":"121399","name":"Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"20","door_id":"1","sku":"105617","name":"Winkies Fruit Cake ,55g ID:105617 Price:15 Weight:58 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"21","door_id":"1","sku":"2332","name":"Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"22","door_id":"1","sku":"6119","name":"Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"23","door_id":"1","sku":"137335","name":"Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold","qty":"15","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"24","door_id":"1","sku":"108567","name":"OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient","qty":"10","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"25","door_id":"1","sku":"175980","name":"Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"26","door_id":"1","sku":"183807","name":"Tropicana Pomegranate Delight - 200ml Rs, 20 ID:183807 Price:20 Weight:197 T:Cold","qty":"14","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"27","door_id":"1","sku":"112220","name":"Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold","qty":"15","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"28","door_id":"1","sku":"123126","name":"Cadbury Dairy Milk Chocolate Mahapack, 57g ID:123126 Price:50 Weight:57 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"29","door_id":"1","sku":"171810","name":"Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"30","door_id":"1","sku":"283","name":"Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"31","door_id":"1","sku":"173768","name":"Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"},{"tray_id":"32","door_id":"1","sku":"156976","name":"Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold","qty":"12","expiry_check":"No","is_fresh":"No","full_replace":"No"}]
[edited_by] => Barun
[created_at] => 2022-12-29 13:14:44
[modified_at] => 2022-12-29 13:14:44
[vendor_id] =>
)
)
result tray after fixed refill
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -16
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -10
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
)
)
Cold products after fixed refill 0 and Ambient count 0
odoo stcok reduction 180 imei TM06202004 Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1 allocated stock: odoo_stock:-108 picking_qty:12
odoo stcok reduction 145724 imei TM06202004 Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724 allocated stock: odoo_stock:-32 picking_qty:16
odoo stcok reduction 155387 imei TM06202004 Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1 allocated stock: odoo_stock:-116 picking_qty:8
odoo stcok reduction 135838 imei TM06202004 Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1 allocated stock: odoo_stock:-124 picking_qty:8
odoo stcok reduction 8639 imei TM06202004 Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639 allocated stock: odoo_stock:-28 picking_qty:14
odoo stcok reduction 129197 imei TM06202004 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1 allocated stock: odoo_stock:-134 picking_qty:10
odoo stcok reduction 8901 imei TM06202004 Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901 allocated stock: odoo_stock:-28 picking_qty:14
odoo stcok reduction 8562 imei TM06202004 Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562 allocated stock: odoo_stock:-28 picking_qty:14
odoo stcok reduction 121399 imei TM06202004 Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1 allocated stock: odoo_stock:-146 picking_qty:12
odoo stcok reduction 105617 imei TM06202004 Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617 allocated stock: odoo_stock:-24 picking_qty:12
odoo stcok reduction 2332 imei TM06202004 Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332 allocated stock: odoo_stock:-20 picking_qty:10
odoo stcok reduction 6119 imei TM06202004 Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119 allocated stock: odoo_stock:-24 picking_qty:12
odoo stcok reduction 137335 imei TM06202004 Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335 allocated stock: odoo_stock:-30 picking_qty:15
odoo stcok reduction 108567 imei TM06202004 OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1 allocated stock: odoo_stock:-156 picking_qty:10
odoo stcok reduction 175980 imei TM06202004 Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1 allocated stock: odoo_stock:-168 picking_qty:12
odoo stcok reduction 183807 imei TM06202004 Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807 allocated stock: odoo_stock:-28 picking_qty:14
odoo stcok reduction 112220 imei TM06202004 Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220 allocated stock: odoo_stock:-30 picking_qty:15
odoo stcok reduction 123126 imei TM06202004 Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126 allocated stock: odoo_stock:-24 picking_qty:12
odoo stcok reduction 171810 imei TM06202004 Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810 allocated stock: odoo_stock:-24 picking_qty:12
odoo stcok reduction 283 imei TM06202004 Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1 allocated stock: odoo_stock:-180 picking_qty:12
odoo stcok reduction 173768 imei TM06202004 Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1 allocated stock: odoo_stock:-192 picking_qty:12
odoo stcok reduction 156976 imei TM06202004 Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976 allocated stock: odoo_stock:-24 picking_qty:12
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -16
[refill_qty] => 16
[picking_quantity] => 16
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 8
[picking_quantity] => 8
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 8
[picking_quantity] => 8
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 10
[picking_quantity] => 10
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -10
[refill_qty] => 10
[picking_quantity] => 10
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
[refill_qty] => 15
[picking_quantity] => 15
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 10
[picking_quantity] => 10
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
[refill_qty] => 15
[picking_quantity] => 15
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
)
)
Array
(
[4500519] => Array
(
[qty] => 6
[tray] => 11
[no_of_trays] => 1
)
[4500552] => Array
(
[qty] => 3
[tray] => 12
[no_of_trays] => 1
)
[4500554] => Array
(
[qty] => 6
[tray] => 13
[no_of_trays] => 1
)
[4500567] => Array
(
[qty] => 4
[tray] => 14
[no_of_trays] => 1
)
[4500607] => Array
(
[qty] => 5
[tray] => 15
[no_of_trays] => 1
)
[166327] => Array
(
[qty] => 5
[tray] => 16
[no_of_trays] => 1
)
[132266] => Array
(
[qty] => 0
[tray] => 17
[no_of_trays] => 1
)
[4500617] => Array
(
[qty] => 5
[tray] => 18
[no_of_trays] => 1
)
[4500564] => Array
(
[qty] => 7
[tray] => 19,21
[no_of_trays] => 2
)
[4500573] => Array
(
[qty] => 6
[tray] => 20
[no_of_trays] => 1
)
[185971] => Array
(
[qty] => 2
[tray] => 22
[no_of_trays] => 1
)
[4500609] => Array
(
[qty] => 5
[tray] => 23
[no_of_trays] => 1
)
[4500611] => Array
(
[qty] => 6
[tray] => 24
[no_of_trays] => 1
)
[185950] => Array
(
[qty] => 15
[tray] => 25
[no_of_trays] => 1
)
[4500566] => Array
(
[qty] => 23
[tray] => 26
[no_of_trays] => 1
)
[4500571] => Array
(
[qty] => 6
[tray] => 27
[no_of_trays] => 1
)
[4500605] => Array
(
[qty] => 6
[tray] => 28
[no_of_trays] => 1
)
[159378] => Array
(
[qty] => 8
[tray] => 29
[no_of_trays] => 1
)
[185970] => Array
(
[qty] => 8
[tray] => 30
[no_of_trays] => 1
)
[4500620] => Array
(
[qty] => 7
[tray] => 31
[no_of_trays] => 1
)
[185953] => Array
(
[qty] => 9
[tray] => 32
[no_of_trays] => 1
)
)
Array
(
[11] => Array
(
[tray_id] => 11
[door_id] => 1
[org_sku] => 4500519
[live_sku] => 4500519
[live_qty] => 6
[live_weight] => 2034.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 180
[refill_sku_name] => Britannia Bourbon Cream Biscuit - Chocolate Flavor, 60 g ID:180 Price:10 Weight:51 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 180
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500519
[return_quantity] => 6
)
[12] => Array
(
[tray_id] => 12
[door_id] => 1
[org_sku] => 4500552
[live_sku] => 4500552
[live_qty] => 3
[live_weight] => 1028.0
[live_qty_weight] => 0
[live_qty_act] => 3
[live_misplaced] => No
[refill_sku_id] => 145724
[refill_sku_name] => Cavins Masala Chaasa ,180ml ID:145724 Price:20 Weight:198 T:Cold odoo_id:145724
[refill_quantity] => 16
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 145724
[qe_refill_qty] => 16
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -16
[refill_qty] => 16
[picking_quantity] => 16
[return_sku] => 4500552
[return_quantity] => 3
)
[13] => Array
(
[tray_id] => 13
[door_id] => 1
[org_sku] => 4500554
[live_sku] => 4500554
[live_qty] => 6
[live_weight] => 2048.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 155387
[refill_sku_name] => Town Bus Butter Muruku ID:155387 Price:20 Weight:52 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 155387
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 8
[picking_quantity] => 8
[return_sku] => 4500554
[return_quantity] => 6
)
[14] => Array
(
[tray_id] => 14
[door_id] => 1
[org_sku] => 4500567
[live_sku] => 4500567
[live_qty] => 4
[live_weight] => 865.0
[live_qty_weight] => 0
[live_qty_act] => 4
[live_misplaced] => No
[refill_sku_id] => 135838
[refill_sku_name] => Town Bus Ribbon Pakoda, 45g ID:135838 Price:20 Weight:49 T:Ambient odoo_id:1
[refill_quantity] => 8
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 135838
[qe_refill_qty] => 8
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 8
[picking_quantity] => 8
[return_sku] => 4500567
[return_quantity] => 4
)
[15] => Array
(
[tray_id] => 15
[door_id] => 1
[org_sku] => 4500607
[live_sku] => 4500607
[live_qty] => 5
[live_weight] => 1671.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8639
[refill_sku_name] => Sprite, 250ml ID:8639 Price:20 Weight:265 T:Ambient odoo_id:8639
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8639
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500607
[return_quantity] => 5
)
[16] => Array
(
[tray_id] => 16
[door_id] => 1
[org_sku] => 166327
[live_sku] => 166327
[live_qty] => 5
[live_weight] => 1010.0
[live_qty_weight] => 4.8095238095238
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 129197
[refill_sku_name] => 25 Rs, Britania Bourbon Cream Biscuit-Chocolate Flavour 100GMS ID:129197 Price:25 Weight:104 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 129197
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 166327
[return_quantity] => 5
)
[17] => Array
(
[tray_id] => 17
[door_id] => 1
[org_sku] => 132266
[live_sku] => 132266
[live_qty] => 0
[live_weight] => -20.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 8901
[refill_sku_name] => Thums Up, 250ml ID:8901 Price:20 Weight:269 T:Ambient odoo_id:8901
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8901
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 132266
[return_quantity] => 0
)
[18] => Array
(
[tray_id] => 18
[door_id] => 1
[org_sku] => 4500617
[live_sku] => 4500617
[live_qty] => 5
[live_weight] => 1698.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 8562
[refill_sku_name] => Coca Cola, 250ml ID:8562 Price:20 Weight:272 T:Cold odoo_id:8562
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 8562
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500617
[return_quantity] => 5
)
[19] => Array
(
[tray_id] => 19
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 7
[live_weight] => 363.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 121399
[refill_sku_name] => Unibic Pista Badam Cookies , 86 Gms ID:121399 Price:30 Weight:86 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 121399
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500564
[return_quantity] => 7
)
[20] => Array
(
[tray_id] => 20
[door_id] => 1
[org_sku] => 4500573
[live_sku] => 4500573
[live_qty] => 6
[live_weight] => 310.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 105617
[refill_sku_name] => Winkies Fruit Cake ,55g ID:105617 Price:20 Weight:63 T:Ambient odoo_id:105617
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 105617
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500573
[return_quantity] => 6
)
[21] => Array
(
[tray_id] => 21
[door_id] => 1
[org_sku] => 4500564
[live_sku] => 4500564
[live_qty] => 0
[live_weight] => 38.0
[live_qty_weight] => 0
[live_qty_act] => 0
[live_misplaced] => No
[refill_sku_id] => 2332
[refill_sku_name] => Town Bus Masala Peanuts ID:2332 Price:10 Weight:33 T:Ambient odoo_id:2332
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 2332
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -10
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 4500564
[return_quantity] => 0
)
[22] => Array
(
[tray_id] => 22
[door_id] => 1
[org_sku] => 185971
[live_sku] => 185971
[live_qty] => 2
[live_weight] => 38.0
[live_qty_weight] => 1.0857142857143
[live_qty_act] => 2
[live_misplaced] => No
[refill_sku_id] => 6119
[refill_sku_name] => Haldiram Tasty Nuts 10rs ID:6119 Price:10 Weight:43 T:Ambient odoo_id:6119
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 6119
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185971
[return_quantity] => 2
)
[23] => Array
(
[tray_id] => 23
[door_id] => 1
[org_sku] => 4500609
[live_sku] => 4500609
[live_qty] => 5
[live_weight] => 301.0
[live_qty_weight] => 0
[live_qty_act] => 5
[live_misplaced] => No
[refill_sku_id] => 137335
[refill_sku_name] => Nestle Milky bar, 25g RS- 20 ID:137335 Price:20 Weight:29 T:Cold odoo_id:137335
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 137335
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
[refill_qty] => 15
[picking_quantity] => 15
[return_sku] => 4500609
[return_quantity] => 5
)
[24] => Array
(
[tray_id] => 24
[door_id] => 1
[org_sku] => 4500611
[live_sku] => 4500611
[live_qty] => 6
[live_weight] => 330.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 108567
[refill_sku_name] => OREO Vanilla 120GM ID:108567 Price:30 Weight:124 T:Ambient odoo_id:1
[refill_quantity] => 10
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 108567
[qe_refill_qty] => 10
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 10
[picking_quantity] => 10
[return_sku] => 4500611
[return_quantity] => 6
)
[25] => Array
(
[tray_id] => 25
[door_id] => 1
[org_sku] => 185950
[live_sku] => 185950
[live_qty] => 15
[live_weight] => 454.0
[live_qty_weight] => 0
[live_qty_act] => 15
[live_misplaced] => No
[refill_sku_id] => 175980
[refill_sku_name] => Winkies Pineapple Cake, 55g ID:175980 Price:15 Weight:60 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 175980
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185950
[return_quantity] => 15
)
[26] => Array
(
[tray_id] => 26
[door_id] => 1
[org_sku] => 4500566
[live_sku] => 4500566
[live_qty] => 23
[live_weight] => 518.0
[live_qty_weight] => 0
[live_qty_act] => 23
[live_misplaced] => No
[refill_sku_id] => 183807
[refill_sku_name] => Tropicana Pomegranate Delight - 180ml Rs, 20 ID:183807 Price:20 Weight:195 T:Cold odoo_id:183807
[refill_quantity] => 14
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 183807
[qe_refill_qty] => 14
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -14
[refill_qty] => 14
[picking_quantity] => 14
[return_sku] => 4500566
[return_quantity] => 23
)
[27] => Array
(
[tray_id] => 27
[door_id] => 1
[org_sku] => 4500571
[live_sku] => 4500571
[live_qty] => 6
[live_weight] => 262.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 112220
[refill_sku_name] => Snickers Chocolate Bar, 22g Rs - 20 ID:112220 Price:20 Weight:23 T:Cold odoo_id:112220
[refill_quantity] => 15
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 112220
[qe_refill_qty] => 15
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -15
[refill_qty] => 15
[picking_quantity] => 15
[return_sku] => 4500571
[return_quantity] => 6
)
[28] => Array
(
[tray_id] => 28
[door_id] => 1
[org_sku] => 4500605
[live_sku] => 4500605
[live_qty] => 6
[live_weight] => 252.0
[live_qty_weight] => 0
[live_qty_act] => 6
[live_misplaced] => No
[refill_sku_id] => 123126
[refill_sku_name] => Cadbury Dairy Milk Chocolate Mahapack 52g ID:123126 Price:55 Weight:52 T:Cold odoo_id:123126
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 123126
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500605
[return_quantity] => 6
)
[29] => Array
(
[tray_id] => 29
[door_id] => 1
[org_sku] => 159378
[live_sku] => 159378
[live_qty] => 8
[live_weight] => 353.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 171810
[refill_sku_name] => Cavins Kaju Butterscotch 200 ml ID:171810 Price:40 Weight:225 T:Cold odoo_id:171810
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 171810
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 159378
[return_quantity] => 8
)
[30] => Array
(
[tray_id] => 30
[door_id] => 1
[org_sku] => 185970
[live_sku] => 185970
[live_qty] => 8
[live_weight] => 299.0
[live_qty_weight] => 0
[live_qty_act] => 8
[live_misplaced] => No
[refill_sku_id] => 283
[refill_sku_name] => Haldirams Salted Peanuts, 45g ID:283 Price:10 Weight:43 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 283
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185970
[return_quantity] => 8
)
[31] => Array
(
[tray_id] => 31
[door_id] => 1
[org_sku] => 4500620
[live_sku] => 4500620
[live_qty] => 7
[live_weight] => 2198.0
[live_qty_weight] => 0
[live_qty_act] => 7
[live_misplaced] => No
[refill_sku_id] => 173768
[refill_sku_name] => Paper Boat Chikki ID:173768 Price:10 Weight:30 T:Ambient odoo_id:1
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T6
[qe_refill_sku] => 173768
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -96
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 4500620
[return_quantity] => 7
)
[32] => Array
(
[tray_id] => 32
[door_id] => 1
[org_sku] => 185953
[live_sku] => 185953
[live_qty] => 9
[live_weight] => 495.0
[live_qty_weight] => 8.5344827586207
[live_qty_act] => 9
[live_misplaced] => No
[refill_sku_id] => 156976
[refill_sku_name] => Epigamia Strawberry Milkshake 180ML ID:156976 Price:40 Weight:202 T:Cold odoo_id:156976
[refill_quantity] => 12
[Segment] => A
[Temperature] => cold
[Tray_type] => T7
[qe_refill_sku] => 156976
[qe_refill_qty] => 12
[refill_reason] => fixed refill product replacement
[odoo_stcok] => -12
[refill_qty] => 12
[picking_quantity] => 12
[return_sku] => 185953
[return_quantity] => 9
)
)
***** end of vm id : TM06202004
email contnt etc..
TM06202004 fixed product 180 has some other product so replace
TM06202004 fixed product 145724 has some other product so replace
TM06202004 fixed product 155387 has some other product so replace
TM06202004 fixed product 135838 has some other product so replace
TM06202004 fixed product 8639 has some other product so replace
TM06202004 fixed product 129197 has some other product so replace
TM06202004 fixed product 8901 has some other product so replace
TM06202004 fixed product 8562 has some other product so replace
TM06202004 fixed product 121399 has some other product so replace
TM06202004 fixed product 105617 has some other product so replace
TM06202004 fixed product 2332 has some other product so replace
TM06202004 fixed product 6119 has some other product so replace
TM06202004 fixed product 137335 has some other product so replace
TM06202004 fixed product 108567 has some other product so replace
TM06202004 fixed product 175980 has some other product so replace
TM06202004 fixed product 183807 has some other product so replace
TM06202004 fixed product 112220 has some other product so replace
TM06202004 fixed product 123126 has some other product so replace
TM06202004 fixed product 171810 has some other product so replace
TM06202004 fixed product 283 has some other product so replace
TM06202004 fixed product 173768 has some other product so replace
TM06202004 fixed product 156976 has some other product so replace
IEMI:TM06202004 is creating refill as refill_qty in first pass is 268 no of near empty tray is 2
TM06202004 fixed product 180 has some other product so replace
TM06202004 fixed product 145724 has some other product so replace
TM06202004 fixed product 155387 has some other product so replace
TM06202004 fixed product 135838 has some other product so replace
TM06202004 fixed product 8639 has some other product so replace
TM06202004 fixed product 129197 has some other product so replace
TM06202004 fixed product 8901 has some other product so replace
TM06202004 fixed product 8562 has some other product so replace
TM06202004 fixed product 121399 has some other product so replace
TM06202004 fixed product 105617 has some other product so replace
TM06202004 fixed product 2332 has some other product so replace
TM06202004 fixed product 6119 has some other product so replace
TM06202004 fixed product 137335 has some other product so replace
TM06202004 fixed product 108567 has some other product so replace
TM06202004 fixed product 175980 has some other product so replace
TM06202004 fixed product 183807 has some other product so replace
TM06202004 fixed product 112220 has some other product so replace
TM06202004 fixed product 123126 has some other product so replace
TM06202004 fixed product 171810 has some other product so replace
TM06202004 fixed product 283 has some other product so replace
TM06202004 fixed product 173768 has some other product so replace
TM06202004 fixed product 156976 has some other product so replace
IEMI:TM06202004 is creating refill as refill_qty in second pass is 268 no of near empty tray is 2