fx_order_product

11,631 rows · 35 columns · page 224 / 233

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_MRP prod_dis_type prod_dis prod_dis_amt product_bv product_pv product_sv total_mrp total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount final_amount total_bv total_pv total_sv _currency created_on free_prod_delevery_status delivered_on delivery_by deliver_name del_contact_no
11151 11151 3 6490 16344 17 Memory Booster Juice 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 0.0 0.05 0.0 INR 2026-06-11 19:06:47 0 NULL NULL NULL NULL
11152 11152 4 6490 16344 41 Premium Coco Body Lotion 3304300 1 699.0 1 140.0 473.73 279.0 0.1 0.0 699.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 559.0 0.0 0.1 0.0 INR 2026-06-11 19:06:47 0 NULL NULL NULL NULL
11153 11153 5 6490 16344 47 Premium Hair Care Shampoo 3305109 2 699.0 1 140.0 532.38 279.0 0.11 0.0 1398.0 1118.0 2.5 26.62 2.5 26.62 0.0 0.0 1118.0 0.0 0.22 0.0 INR 2026-06-11 19:06:47 0 NULL NULL NULL NULL
11154 11154 1 6491 15223 32 Neem Soap 100gm 34011110 50 60.0 1 8.0 49.52 20.0 0.006 0.0 3000.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2600.0 1000.0 0.0 0.0 INR 2026-06-11 19:08:33 0 NULL NULL NULL NULL
11155 11155 1 6492 16302 38 Dish Wash 500ml 34029099 12 230.0 1 46.0 155.93 65.0 0.011 0.0 2760.0 2208.0 9.0 168.41 9.0 168.41 0.0 0.0 2208.0 0.0 0.132 0.0 INR 2026-06-11 19:13:12 0 NULL NULL NULL NULL
11156 11156 2 6492 16302 37 Floor Cleaner 500ml 3924101 16 199.0 1 40.0 134.75 55.0 0.011 0.0 3184.0 2544.0 9.0 194.03 9.0 194.03 0.0 0.0 2544.0 0.0 0.176 0.0 INR 2026-06-11 19:13:12 0 NULL NULL NULL NULL
11157 11157 3 6492 16302 43 Quench Kiss Lip Balm 3304300 1 199.0 1 40.0 134.75 79.0 0.012 0.0 199.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 159.0 0.0 0.012 0.0 INR 2026-06-11 19:13:12 0 NULL NULL NULL NULL
11158 11158 4 6492 16302 46 Root Vitality Hair Oil 3305901 2 255.0 1 51.0 194.29 102.0 0.04 0.0 510.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 408.0 0.0 0.08 0.0 INR 2026-06-11 19:13:12 0 NULL NULL NULL NULL
11159 11159 5 6492 16302 50 Sun Screen 330499 1 699.0 1 140.0 473.73 279.0 0.11 0.0 699.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 559.0 0.0 0.11 0.0 INR 2026-06-11 19:13:12 0 NULL NULL NULL NULL
11160 11160 1 6493 9038 33 HALDI CHANDAN SOAP 100gm 30049011 59 100.0 1 20.0 76.19 35.0 0.009 0.0 5900.0 4720.0 2.5 112.38 2.5 112.38 0.0 0.0 4720.0 0.0 0.531 0.0 INR 2026-06-11 19:19:17 0 NULL NULL NULL NULL
11161 11161 2 6493 9038 7 Morning Fresh Churan 30049011 1 199.0 1 20.0 170.48 79.0 0.015 0.0 199.0 179.0 2.5 4.26 2.5 4.26 0.0 0.0 179.0 0.0 0.015 0.0 INR 2026-06-11 19:19:17 0 NULL NULL NULL NULL
11162 11162 3 6493 9038 32 Neem Soap 100gm 34011110 91 60.0 1 8.0 49.52 20.0 0.006 0.0 5460.0 4732.0 2.5 112.67 2.5 112.67 0.0 0.0 4732.0 0.0 0.546 0.0 INR 2026-06-11 19:19:17 0 NULL NULL NULL NULL
11163 11163 4 6493 9038 36 Toilet Cleaner 500ml 3924101 8 150.0 1 30.0 101.69 42.0 0.011 0.0 1200.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 960.0 0.0 0.088 0.0 INR 2026-06-11 19:19:17 0 NULL NULL NULL NULL
11164 11164 5 6493 9038 34 Toothpaste 33061090 11 199.0 1 40.0 134.75 55.0 0.025 0.0 2189.0 1749.0 9.0 133.4 9.0 133.4 0.0 0.0 1749.0 0.0 0.275 0.0 INR 2026-06-11 19:19:17 0 NULL NULL NULL NULL
11165 11165 1 6494 16365 25 Manicalcium Tablets 2009899 2 399.0 1 80.0 303.81 159.0 0.05 0.0 798.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 638.0 0.0 0.1 0.0 INR 2026-06-11 20:49:41 0 NULL NULL NULL NULL
11166 11166 2 6494 16365 26 Spirulina Cap 2009899 1 899.0 1 180.0 684.76 359.0 0.15 0.0 899.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 719.0 0.0 0.15 0.0 INR 2026-06-11 20:49:41 0 NULL NULL NULL NULL
11167 11167 1 6495 5574 53 Terra care 2 kg 3103100 1 1500.0 1 350.0 1095.24 575.0 0.25 0.0 1500.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1150.0 575.0 0.0 0.0 INR 2026-06-12 10:30:14 0 NULL NULL NULL NULL
11168 11168 1 6496 16392 32 Neem Soap 100gm 34011110 1 60.0 1 8.0 49.52 20.0 0.006 0.0 60.0 52.0 2.5 1.24 2.5 1.24 0.0 0.0 52.0 0.0 0.006 0.0 INR 2026-06-12 11:35:02 0 NULL NULL NULL NULL
11169 11169 1 6497 16393 32 Neem Soap 100gm 34011110 1 60.0 1 8.0 49.52 20.0 0.006 0.0 60.0 52.0 2.5 1.24 2.5 1.24 0.0 0.0 52.0 0.0 0.006 0.0 INR 2026-06-12 11:35:37 0 NULL NULL NULL NULL
11170 11170 1 6498 16386 25 Manicalcium Tablets 2009899 2 399.0 1 80.0 303.81 159.0 0.05 0.0 798.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 638.0 0.0 0.1 0.0 INR 2026-06-12 14:45:57 0 NULL NULL NULL NULL
11171 11171 2 6498 16386 28 Ortho Joint Shield 2009899 2 1499.0 1 299.0 1142.86 600.0 0.25 0.0 2998.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2400.0 0.0 0.5 0.0 INR 2026-06-12 14:45:57 0 NULL NULL NULL NULL
11172 11172 1 6499 2 25 Manicalcium Tablets 2009899 2 399.0 1 80.0 303.81 159.0 0.05 0.0 798.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 638.0 318.0 0.0 0.0 INR 2026-06-12 14:47:53 0 NULL NULL NULL NULL
11173 11173 2 6499 2 28 Ortho Joint Shield 2009899 2 1499.0 1 299.0 1142.86 600.0 0.25 0.0 2998.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2400.0 1200.0 0.0 0.0 INR 2026-06-12 14:47:53 0 NULL NULL NULL NULL
11174 11174 1 6500 5289 38 Dish Wash 500ml 34029099 4 230.0 0 0.0 155.93 65.0 0.011 0.0 920.0 736.0 9.0 56.14 9.0 56.14 0.0 0.0 736.0 260.0 0.044 0.0 INR 2026-06-12 14:51:18 0 NULL NULL NULL NULL
11175 11175 1 6501 5557 15 KIDNEY CARE JUICE 2009899 2 349.0 1 49.0 285.71 150.0 0.05 0.0 698.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 600.0 300.0 0.0 0.0 INR 2026-06-12 18:27:56 0 NULL NULL NULL NULL
11176 11176 1 6502 16386 25 Manicalcium Tablets 2009899 2 399.0 1 80.0 303.81 159.0 0.05 0.0 798.0 638.0 2.5 15.19 2.5 15.19 0.0 0.0 638.0 0.0 0.1 0.0 INR 2026-06-12 20:17:23 0 NULL NULL NULL NULL
11177 11177 2 6502 16386 28 Ortho Joint Shield 2009899 2 1499.0 1 299.0 1142.86 600.0 0.25 0.0 2998.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2400.0 0.0 0.5 0.0 INR 2026-06-12 20:17:23 0 NULL NULL NULL NULL
11178 11178 1 6503 16422 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 0.95 0.0 0.0 0.0 3499.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11179 11179 2 6503 16422 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 1523.81 800.0 0.25 0.0 3499.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1600.0 0.0 0.25 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11180 11180 3 6503 16422 33 HALDI CHANDAN SOAP 100gm 30049011 6 100.0 1 20.0 76.19 35.0 0.009 0.0 600.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 480.0 0.0 0.054 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11181 11181 4 6503 16422 47 Premium Hair Care Shampoo 3305109 1 699.0 1 140.0 532.38 279.0 0.11 0.0 699.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 559.0 0.0 0.11 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11182 11182 5 6503 16422 46 Root Vitality Hair Oil 3305901 1 255.0 1 51.0 194.29 102.0 0.04 0.0 255.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 204.0 0.0 0.04 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11183 11183 6 6503 16422 34 Toothpaste 33061090 2 199.0 1 40.0 134.75 55.0 0.025 0.0 398.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 318.0 0.0 0.05 0.0 INR 2026-06-12 20:21:49 0 NULL NULL NULL NULL
11184 11184 1 6504 16424 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 0.95 0.0 0.0 0.0 3499.0 1.0 2.5 0.02 2.5 0.02 0.0 0.0 1.0 0.0 0.0 0.0 INR 2026-06-13 13:31:54 0 NULL NULL NULL NULL
11185 11185 2 6504 16424 20 Premium Berry Juice 1000ml 2936900 1 3499.0 1 1899.0 1523.81 800.0 0.25 0.0 3499.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1600.0 0.0 0.25 0.0 INR 2026-06-13 13:31:54 0 NULL NULL NULL NULL
11186 11186 3 6504 16424 82 ALKALINE CAPSULE 3402000 1 2500.0 1 850.0 1571.43 800.0 0.25 0.0 2500.0 1650.0 2.5 39.29 2.5 39.29 0.0 0.0 1650.0 0.0 0.25 0.0 INR 2026-06-13 13:31:54 0 NULL NULL NULL NULL
11187 11187 1 6505 4003 34 HERBO 33 TOOTHPASTE 33061090 25 199.0 1 40.0 134.75 55.0 0.025 0.0 4975.0 3975.0 9.0 303.18 9.0 303.18 0.0 0.0 3975.0 0.0 0.625 0.0 INR 2026-06-13 14:58:17 0 NULL NULL NULL NULL
11188 11188 1 6506 15131 38 Dish Wash 500ml 34029099 1 230.0 1 46.0 155.93 65.0 0.011 0.0 230.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 184.0 65.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11189 11189 2 6506 15131 33 HALDI CHANDAN SOAP 100gm 30049011 3 100.0 1 20.0 76.19 35.0 0.009 0.0 300.0 240.0 2.5 5.71 2.5 5.71 0.0 0.0 240.0 105.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11190 11190 3 6506 15131 16 Liver Care Juice 2009899 1 349.0 1 49.0 285.71 150.0 0.05 0.0 349.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 300.0 150.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11191 11191 4 6506 15131 72 Pain Relief Patch 30051090 1 800.0 1 400.0 380.95 200.0 0.025 0.0 800.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 200.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11192 11192 5 6506 15131 47 Premium Hair Care Shampoo 3305109 1 699.0 1 140.0 532.38 279.0 0.11 0.0 699.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 559.0 279.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11193 11193 6 6506 15131 46 Root Vitality Hair Oil 3305901 2 255.0 1 51.0 194.29 102.0 0.04 0.0 510.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 408.0 204.0 0.0 0.0 INR 2026-06-13 15:40:06 0 NULL NULL NULL NULL
11194 11194 1 6507 15202 28 Ortho Joint Shield 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 600.0 0.0 0.0 INR 2026-06-13 15:43:39 0 NULL NULL NULL NULL
11195 11195 1 6508 15203 37 Floor Cleaner 500ml 3924101 1 199.0 1 40.0 134.75 55.0 0.011 0.0 199.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 159.0 55.0 0.0 0.0 INR 2026-06-13 15:44:50 0 NULL NULL NULL NULL
11196 11196 2 6508 15203 30 Iron Capsules 30049011 1 899.0 1 180.0 684.76 359.0 0.15 0.0 899.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 719.0 359.0 0.0 0.0 INR 2026-06-13 15:44:50 0 NULL NULL NULL NULL
11197 11197 3 6508 15203 28 Ortho Joint Shield 2009899 1 1499.0 1 299.0 1142.86 600.0 0.25 0.0 1499.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1200.0 600.0 0.0 0.0 INR 2026-06-13 15:44:50 0 NULL NULL NULL NULL
11198 11198 1 6509 16423 33 HALDI CHANDAN SOAP 100gm 30049011 2 100.0 1 20.0 76.19 35.0 0.009 0.0 200.0 160.0 2.5 3.81 2.5 3.81 0.0 0.0 160.0 0.0 0.018 0.0 INR 2026-06-13 15:47:02 0 NULL NULL NULL NULL
11199 11199 2 6509 16423 34 HERBO 33 TOOTHPASTE 33061090 2 199.0 1 40.0 134.75 55.0 0.025 0.0 398.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 318.0 0.0 0.05 0.0 INR 2026-06-13 15:47:02 0 NULL NULL NULL NULL
11200 11200 3 6509 16423 30 Iron Capsules 30049011 1 899.0 1 180.0 684.76 359.0 0.15 0.0 899.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 719.0 0.0 0.15 0.0 INR 2026-06-13 15:47:02 0 NULL NULL NULL NULL