fx_franchise_order_product

4,737 rows · 33 columns · page 4 / 95

Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
151 360 15 67 12528 32 Neem Soap 100gm NULL 34011110 184 10.0 60.0 0.0 0.0 48.0 45.71 2.29 11040.0 1840.0 8832.0 2.5 210.28 2.5 210.28 0.0 0.0 45.71 420.57 8832.0 INR 0 0.0 0.0 2025-11-07 20:12:29
152 361 16 67 12528 72 Pain Relief Patch NULL 30051090 2 200.0 800.0 0.0 0.0 640.0 609.52 30.48 1600.0 400.0 1280.0 2.5 30.48 2.5 30.48 0.0 0.0 609.52 60.95 1280.0 INR 0 0.0 0.0 2025-11-07 20:12:29
153 362 17 67 12528 8 Piles Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 20:12:29
154 363 18 67 12528 41 Premium Coco Body Lotion NULL 3304300 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-07 20:12:29
155 364 19 67 12528 47 Premium Hair Care Shampoo NULL 3305109 4 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2796.0 600.0 2236.8 2.5 53.26 2.5 53.26 0.0 0.0 532.57 106.51 2236.8 INR 0 0.0 0.0 2025-11-07 20:12:29
156 365 20 67 12528 45 Premium radiance face serum NULL 3304991 5 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 6000.0 1500.0 4800.0 9.0 366.1 9.0 366.1 0.0 0.0 813.56 732.2 4800.0 INR 0 0.0 0.0 2025-11-07 20:12:29
157 366 21 67 12528 35 Sanitary Pad (15 pcs) NULL 9619001 1 40.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 40.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 0 0.0 0.0 2025-11-07 20:12:29
158 367 22 67 12528 26 Spirulina Cap NULL 2009899 1 190.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 190.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:12:29
159 368 23 67 12528 5 Thyro Care NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:12:29
160 369 24 67 12528 36 Toilet Cleaner 500ml NULL 3924101 1 30.0 150.0 0.0 0.0 120.0 101.69 18.31 150.0 30.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.31 120.0 INR 0 0.0 0.0 2025-11-07 20:12:29
161 370 25 67 12528 10 Vitamin D3 Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 20:12:29
162 371 1 68 12522 48 glow face wash NULL 3304999 10 250.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 2500.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-07 20:12:32
163 372 2 68 12522 31 Vegan Plant Protein Powder NULL 21061000 1 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 2999.0 1000.0 2399.2 2.5 57.12 2.5 57.12 0.0 0.0 2284.95 114.25 2399.2 INR 0 0.0 0.0 2025-11-07 20:12:32
164 373 3 68 12522 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-07 20:12:32
165 374 4 68 12522 49 Anti Dandruff Serum NULL 3304999 2 250.0 999.0 0.0 0.0 799.2 677.29 121.91 1998.0 500.0 1598.4 9.0 121.91 9.0 121.91 0.0 0.0 677.29 243.82 1598.4 INR 0 0.0 0.0 2025-11-07 20:12:32
166 375 5 68 12522 6 Asthma Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 20:12:32
167 376 6 68 12522 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 2.5 121.91 2.5 121.91 0.0 0.0 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 20:12:32
168 377 7 68 12522 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-07 20:12:32
169 378 8 68 12522 4 Diabetic Care Capsules NULL 2936900 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 20:12:32
170 379 9 68 12522 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-07 20:12:32
171 380 10 68 12522 39 Fabric Wash 1000ml NULL 3924101 5 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2005.0 750.0 1604.0 9.0 122.34 9.0 122.34 0.0 0.0 271.86 244.68 1604.0 INR 0 0.0 0.0 2025-11-07 20:12:32
172 381 11 68 12522 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 20:12:32
173 382 12 68 12522 33 Herbal Soap 100gm NULL 30049011 150 28.0 100.0 0.0 0.0 80.0 76.19 3.81 15000.0 4200.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 76.19 571.43 12000.0 INR 0 0.0 0.0 2025-11-07 20:12:32
174 383 13 68 12522 34 Herbo2o Toothpaste NULL 33061090 30 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1350.0 4776.0 9.0 364.27 9.0 364.27 0.0 0.0 134.92 728.54 4776.0 INR 0 0.0 0.0 2025-11-07 20:12:32
175 384 14 68 12522 30 Iron Capsules NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:12:32
176 385 15 68 12522 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:12:32
177 386 16 68 12522 12 Melatonin Drop NULL 2106909 2 190.0 749.0 0.0 0.0 599.2 570.67 28.54 1498.0 380.0 1198.4 2.5 28.54 2.5 28.54 0.0 0.0 570.67 57.07 1198.4 INR 0 0.0 0.0 2025-11-07 20:12:32
178 387 17 68 12522 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:12:32
179 388 18 68 12522 7 Morning Fresh Churan NULL 30049011 14 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2786.0 560.0 2228.8 2.5 53.06 2.5 53.06 0.0 0.0 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-07 20:12:32
180 389 19 68 12522 32 Neem Soap 100gm NULL 34011110 250 10.0 60.0 0.0 0.0 48.0 45.71 2.29 15000.0 2500.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 45.71 571.43 12000.0 INR 0 0.0 0.0 2025-11-07 20:12:32
181 390 20 68 12522 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-07 20:12:32
182 391 21 68 12522 28 Ortho Joint Shield NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 20:12:32
183 392 22 68 12522 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-07 20:12:32
184 393 23 68 12522 8 Piles Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:12:32
185 394 24 68 12522 41 Premium Coco Body Lotion NULL 3304300 5 250.0 699.0 0.0 0.0 559.2 473.9 85.3 3495.0 1250.0 2796.0 9.0 213.25 9.0 213.25 0.0 0.0 473.9 426.51 2796.0 INR 0 0.0 0.0 2025-11-07 20:12:32
186 395 25 68 12522 14 Premium Aloe Vera VEG caps NULL 2936900 1 100.0 359.0 0.0 0.0 287.2 273.52 13.68 359.0 100.0 287.2 2.5 6.84 2.5 6.84 0.0 0.0 273.52 13.68 287.2 INR 0 0.0 0.0 2025-11-07 20:12:32
187 396 26 68 12522 47 Premium Hair Care Shampoo NULL 3305109 2 150.0 699.0 0.0 0.0 559.2 532.57 26.63 1398.0 300.0 1118.4 2.5 26.63 2.5 26.63 0.0 0.0 532.57 53.26 1118.4 INR 0 0.0 0.0 2025-11-07 20:12:32
188 397 27 68 12522 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-07 20:12:32
189 398 28 68 12522 35 Sanitary Pad (15 pcs) NULL 9619001 30 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11400.0 1200.0 9120.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 9120.0 INR 0 0.0 0.0 2025-11-07 20:12:32
190 399 29 68 12522 29 Shilajith NULL 30049011 1 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 1800.0 250.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-07 20:12:32
191 400 30 68 12522 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 20:12:32
192 401 31 68 12522 53 Terra care 2 kg NULL 3103100 4 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 6000.0 1800.0 4800.0 2.5 114.28 2.5 114.28 0.0 0.0 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 20:12:32
193 402 32 68 12522 44 Vital Glow Face Scrub NULL 3304300 4 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 284.0 1040.0 9.0 79.32 9.0 79.32 0.0 0.0 220.34 158.64 1040.0 INR 0 0.0 0.0 2025-11-07 20:12:32
194 403 33 68 12522 10 Vitamin D3 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 20:12:32
195 404 1 69 12529 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-07 20:17:38
196 405 1 70 12517 33 Herbal Soap 100gm NULL 30049011 3 28.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 84.0 240.0 0.0 0.0 0.0 0.0 5.0 11.43 76.19 11.43 240.0 INR 0 0.0 0.0 2025-11-07 20:21:33
197 406 2 70 12517 32 Neem Soap 100gm NULL 34011110 3 10.0 60.0 0.0 0.0 48.0 45.71 2.29 180.0 30.0 144.0 0.0 0.0 0.0 0.0 5.0 6.86 45.71 6.86 144.0 INR 0 0.0 0.0 2025-11-07 20:21:33
198 407 1 71 12517 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 0.0 0.0 0.0 0.0 5.0 26.63 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-07 20:24:05
199 408 1 72 12517 48 glow face wash NULL 3304999 3 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 750.0 912.0 0.0 0.0 0.0 0.0 18.0 139.12 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-07 20:37:03
200 409 2 72 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 0.0 0.0 0.0 0.0 5.0 243.81 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 20:37:03