fx_order_product

11,631 rows · 35 columns · page 207 / 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
10301 10301 3 6146 15850 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 0.0 0.25 0.0 INR 2026-05-12 20:49:23 0 NULL NULL NULL NULL
10302 10302 1 6147 16250 65 SINGLE WELLNESS 94041000 1 12999.0 1 2299.0 10190.48 5350.0 2.0 0.0 12999.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10700.0 0.0 2.0 0.0 INR 2026-05-12 21:38:20 0 NULL NULL NULL NULL
10303 10303 1 6148 5762 48 Glow it multi fruit face wash 3304999 1 450.0 1 130.0 271.19 160.0 0.05 0.0 450.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 320.0 160.0 0.0 0.0 INR 2026-05-12 22:53:09 0 NULL NULL NULL NULL
10304 10304 2 6148 5762 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 70.0 0.0 0.0 INR 2026-05-12 22:53:09 0 NULL NULL NULL NULL
10305 10305 3 6148 5762 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 79.0 0.0 0.0 INR 2026-05-12 22:53:09 0 NULL NULL NULL NULL
10306 10306 4 6148 5762 35 Sanitary Pad (15 pcs) 9619001 1 380.0 1 76.0 304.0 150.0 0.05 0.0 380.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 150.0 0.0 0.0 INR 2026-05-12 22:53:09 0 NULL NULL NULL NULL
10307 10307 5 6148 5762 34 Toothpaste 33061090 1 199.0 1 40.0 134.75 55.0 0.025 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-05-12 22:53:09 0 NULL NULL NULL NULL
10308 10308 1 6149 7560 4 Diabetic Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-05-12 22:54:12 0 NULL NULL NULL NULL
10309 10309 2 6149 7560 35 Sanitary Pad (15 pcs) 9619001 1 380.0 1 76.0 304.0 150.0 0.05 0.0 380.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 150.0 0.0 0.0 INR 2026-05-12 22:54:12 0 NULL NULL NULL NULL
10310 10310 1 6150 5573 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-05-12 23:05:40 0 NULL NULL NULL NULL
10311 10311 2 6150 5573 39 Fabric Wash 1000ml 34029099 1 401.0 1 80.0 272.03 112.0 0.022 0.0 401.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 321.0 112.0 0.0 0.0 INR 2026-05-12 23:05:40 0 NULL NULL NULL NULL
10312 10312 3 6150 5573 48 Glow it multi fruit face wash 3304999 2 450.0 1 130.0 271.19 160.0 0.05 0.0 900.0 640.0 9.0 48.81 9.0 48.81 0.0 0.0 640.0 320.0 0.0 0.0 INR 2026-05-12 23:05:40 0 NULL NULL NULL NULL
10313 10313 4 6150 5573 33 HALDI CHANDAN SOAP 100gm 30049011 1 100.0 1 20.0 76.19 35.0 0.009 0.0 100.0 80.0 2.5 1.9 2.5 1.9 0.0 0.0 80.0 35.0 0.0 0.0 INR 2026-05-12 23:05:40 0 NULL NULL NULL NULL
10314 10314 1 6151 5574 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 70.0 0.0 0.0 INR 2026-05-12 23:07:43 0 NULL NULL NULL NULL
10315 10315 2 6151 5574 9 Omega 369 2936900 2 999.0 1 279.0 685.71 360.0 0.15 0.0 1998.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 720.0 0.0 0.0 INR 2026-05-12 23:07:43 0 NULL NULL NULL NULL
10316 10316 3 6151 5574 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 102.0 0.0 0.0 INR 2026-05-12 23:07:43 0 NULL NULL NULL NULL
10317 10317 4 6151 5574 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 110.0 0.0 0.0 INR 2026-05-12 23:07:43 0 NULL NULL NULL NULL
10318 10318 1 6152 8123 52 Bhoo sanjeevni 5 kg 3103100 1 1600.0 1 350.0 1190.48 625.0 0.25 0.0 1600.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1250.0 625.0 0.0 0.0 INR 2026-05-12 23:22:01 0 NULL NULL NULL NULL
10319 10319 2 6152 8123 3 BP Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-05-12 23:22:01 0 NULL NULL NULL NULL
10320 10320 3 6152 8123 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 20.0 0.0 0.0 INR 2026-05-12 23:22:01 0 NULL NULL NULL NULL
10321 10321 1 6153 7532 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-05-12 23:24:54 0 NULL NULL NULL NULL
10322 10322 1 6154 5564 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-05-12 23:30:55 0 NULL NULL NULL NULL
10323 10323 2 6154 5564 48 Glow it multi fruit face wash 3304999 1 450.0 1 130.0 271.19 160.0 0.05 0.0 450.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 320.0 160.0 0.0 0.0 INR 2026-05-12 23:30:55 0 NULL NULL NULL NULL
10324 10324 3 6154 5564 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-05-12 23:30:55 0 NULL NULL NULL NULL
10325 10325 4 6154 5564 34 Toothpaste 33061090 1 199.0 1 40.0 134.75 55.0 0.025 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-05-12 23:30:55 0 NULL NULL NULL NULL
10326 10326 1 6155 8732 52 Bhoo sanjeevni 5 kg 3103100 1 1600.0 1 350.0 1190.48 625.0 0.25 0.0 1600.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1250.0 0.0 0.25 0.0 INR 2026-05-13 10:17:18 0 NULL NULL NULL NULL
10327 10327 2 6155 8732 33 HALDI CHANDAN SOAP 100gm 30049011 20 100.0 1 20.0 76.19 35.0 0.009 0.0 2000.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1600.0 0.0 0.18 0.0 INR 2026-05-13 10:17:18 0 NULL NULL NULL NULL
10328 10328 3 6155 8732 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 0.0 0.25 0.0 INR 2026-05-13 10:17:18 0 NULL NULL NULL NULL
10329 10329 1 6156 16033 4 Diabetic Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 0.0 0.15 0.0 INR 2026-05-13 12:34:13 0 NULL NULL NULL NULL
10330 10330 1 6157 16242 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 0.0 0.05 0.0 INR 2026-05-13 12:34:53 0 NULL NULL NULL NULL
10331 10331 1 6158 15207 33 HALDI CHANDAN SOAP 100gm 30049011 4 100.0 1 20.0 76.19 35.0 0.009 0.0 400.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 320.0 140.0 0.0 0.0 INR 2026-05-13 18:15:23 0 NULL NULL NULL NULL
10332 10332 1 6159 16252 68 DOUBLE WELLNESS BED 6 BY 6 SET 94041000 1 23999.0 1 5499.0 17619.05 9250.0 3.75 0.0 23999.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 18500.0 0.0 3.75 0.0 INR 2026-05-13 19:51:08 0 NULL NULL NULL NULL
10333 10333 1 6160 7948 4 Diabetic Care Capsules 2936900 2 999.0 1 279.0 685.71 360.0 0.15 0.0 1998.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 720.0 0.0 0.0 INR 2026-05-14 12:14:21 0 NULL NULL NULL NULL
10334 10334 1 6161 8291 3 BP Care Capsules 2936900 2 999.0 1 279.0 685.71 360.0 0.15 0.0 1998.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1440.0 720.0 0.0 0.0 INR 2026-05-14 12:17:37 0 NULL NULL NULL NULL
10335 10335 2 6161 8291 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-05-14 12:17:37 0 NULL NULL NULL NULL
10336 10336 1 6162 14462 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 70.0 0.0 0.0 INR 2026-05-14 15:36:12 0 NULL NULL NULL NULL
10337 10337 2 6162 14462 94 PAVANA DROPS 30041211 1 699.0 1 200.0 475.24 249.0 0.1 0.0 699.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 499.0 249.0 0.0 0.0 INR 2026-05-14 15:36:12 0 NULL NULL NULL NULL
10338 10338 3 6162 14462 36 Toilet Cleaner 500ml 3924101 2 150.0 1 30.0 101.69 42.0 0.011 0.0 300.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 240.0 84.0 0.0 0.0 INR 2026-05-14 15:36:12 0 NULL NULL NULL NULL
10339 10339 4 6162 14462 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 110.0 0.0 0.0 INR 2026-05-14 15:36:12 0 NULL NULL NULL NULL
10340 10340 1 6163 16109 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-05-14 15:41:35 0 NULL NULL NULL NULL
10341 10341 2 6163 16109 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-05-14 15:41:35 0 NULL NULL NULL NULL
10342 10342 1 6164 9840 70 Premium Hand belt 9404 2 2500.0 1 1060.0 1371.43 720.0 0.2 0.0 5000.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2880.0 1440.0 0.0 0.0 INR 2026-05-14 16:34:12 0 NULL NULL NULL NULL
10343 10343 2 6164 9840 3 BP Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-05-14 16:34:12 0 NULL NULL NULL NULL
10344 10344 3 6164 9840 4 Diabetic Care Capsules 2936900 1 999.0 1 279.0 685.71 360.0 0.15 0.0 999.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 720.0 360.0 0.0 0.0 INR 2026-05-14 16:34:12 0 NULL NULL NULL NULL
10345 10345 4 6164 9840 33 HALDI CHANDAN SOAP 100gm 30049011 5 100.0 1 20.0 76.19 35.0 0.009 0.0 500.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 400.0 175.0 0.0 0.0 INR 2026-05-14 16:34:12 0 NULL NULL NULL NULL
10346 10346 5 6164 9840 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-05-14 16:34:12 0 NULL NULL NULL NULL
10347 10347 6 6164 9840 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-05-14 16:34:12 0 NULL NULL NULL NULL
10348 10348 7 6164 9840 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 102.0 0.0 0.0 INR 2026-05-14 16:34:12 0 NULL NULL NULL NULL
10349 10349 8 6164 9840 34 Toothpaste 33061090 1 199.0 1 40.0 134.75 55.0 0.025 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-05-14 16:34:12 0 NULL NULL NULL NULL
10350 10350 1 6165 15428 33 HALDI CHANDAN SOAP 100gm 30049011 10 100.0 1 20.0 76.19 35.0 0.009 0.0 1000.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 800.0 350.0 0.0 0.0 INR 2026-05-14 16:59:28 0 NULL NULL NULL NULL