fx_franchise_order_product

4,737 rows · 33 columns · page 1 / 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
1 210 20 59 12516 37 Floor Cleaner 500ml NULL 3924101 125 80.0 199.0 0.0 0.0 159.2 134.92 24.28 24875.0 10000.0 19900.0 9.0 1517.8 9.0 1517.8 0.0 0.0 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 18:37:14
2 211 21 59 12516 60 Foot patch NULL 30051090 52 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 103948.0 26000.0 83158.4 2.5 1979.96 2.5 1979.96 0.0 0.0 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 18:37:14
3 212 22 59 12516 58 Green shield 250ml NULL 3105 14 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 35000.0 11200.0 28000.0 2.5 666.66 2.5 666.66 0.0 0.0 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 18:37:14
4 213 23 59 12516 55 Grow master 500ml NULL 3105 33 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 66990.0 28050.0 53592.0 2.5 1276.0 2.5 1276.0 0.0 0.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 18:37:14
5 214 24 59 12516 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 18:37:14
6 215 25 59 12516 33 Herbal Soap 100gm NULL 30049011 1593 28.0 100.0 0.0 0.0 80.0 76.19 3.81 159300.0 44604.0 127440.0 2.5 3034.28 2.5 3034.28 0.0 0.0 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 18:37:14
7 216 26 59 12516 34 Herbo2o Toothpaste NULL 33061090 597 45.0 199.0 0.0 0.0 159.2 134.92 24.28 118803.0 26865.0 95042.4 9.0 7248.99 9.0 7248.99 0.0 0.0 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 18:37:14
8 217 27 59 12516 24 Immunomax 24/7 Caps NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 18:37:14
9 218 28 59 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 18:37:14
10 219 29 59 12516 15 Kidney Stone Juice NULL 2009899 11 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3839.0 1320.0 3071.2 2.5 73.12 2.5 73.12 0.0 0.0 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 18:37:14
11 220 30 59 12516 18 Lady Care Juice 500ml NULL 2009899 16 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 23984.0 4000.0 19187.2 2.5 456.84 2.5 456.84 0.0 0.0 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 18:37:14
12 221 31 59 12516 16 Liver Care Juice NULL 2009899 46 120.0 349.0 0.0 0.0 279.2 265.9 13.3 16054.0 5520.0 12843.2 2.5 305.79 2.5 305.79 0.0 0.0 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 18:37:14
13 222 32 59 12516 25 Manicalcium Tablets NULL 2009899 23 95.0 399.0 0.0 0.0 319.2 304.0 15.2 9177.0 2185.0 7341.6 2.5 174.8 2.5 174.8 0.0 0.0 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 18:37:14
14 223 33 59 12516 12 Melatonin Drop NULL 2106909 38 190.0 749.0 0.0 0.0 599.2 570.67 28.53 28462.0 7220.0 22769.6 2.5 542.13 2.5 542.13 0.0 0.0 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 18:37:14
15 224 34 59 12516 17 Memory Booster Juice NULL 2009899 52 120.0 349.0 0.0 0.0 279.2 265.9 13.3 18148.0 6240.0 14518.4 2.5 345.68 2.5 345.68 0.0 0.0 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 18:37:14
16 225 35 59 12516 56 Micro magic 500ml NULL 3105 24 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 48720.0 20400.0 38976.0 9.0 2972.74 9.0 2972.74 0.0 0.0 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 18:37:14
17 226 36 59 12516 7 Morning Fresh Churan NULL 30049011 157 40.0 199.0 0.0 0.0 159.2 151.62 7.58 31243.0 6280.0 24994.4 2.5 595.11 2.5 595.11 0.0 0.0 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 18:37:14
18 227 37 59 12516 32 Neem Soap 100gm NULL 34011110 3122 10.0 60.0 0.0 0.0 48.0 45.71 2.29 187320.0 31220.0 149856.0 2.5 3568.0 2.5 3568.0 0.0 0.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 18:37:14
19 228 38 59 12516 9 Omega 369 NULL 2936900 57 260.0 999.0 0.0 0.0 799.2 761.14 38.06 56943.0 14820.0 45554.4 2.5 1084.63 2.5 1084.63 0.0 0.0 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 18:37:14
20 229 39 59 12516 28 Ortho Joint Shield NULL 2009899 14 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 6300.0 16788.8 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 18:37:14
21 230 40 59 12516 72 Pain Relief Patch NULL 30051090 52 200.0 800.0 0.0 0.0 640.0 609.52 30.48 41600.0 10400.0 33280.0 2.5 792.38 2.5 792.38 0.0 0.0 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 18:37:14
22 231 41 59 12516 8 Piles Care NULL 30049011 49 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44051.0 12250.0 35240.8 2.5 839.07 2.5 839.07 0.0 0.0 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 18:37:14
23 232 42 59 12516 41 Premium Coco Body Lotion NULL 3304300 25 250.0 699.0 0.0 0.0 559.2 473.9 85.3 17475.0 6250.0 13980.0 9.0 1066.27 9.0 1066.27 0.0 0.0 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 18:37:14
24 233 43 59 12516 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 18:37:14
25 234 44 59 12516 47 Premium Hair Care Shampoo NULL 3305109 78 150.0 699.0 0.0 0.0 559.2 532.57 26.63 54522.0 11700.0 43617.6 2.5 1038.52 2.5 1038.52 0.0 0.0 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 18:37:14
26 235 45 59 12516 13 Premium NONI VEG caps NULL 2936900 27 150.0 501.0 0.0 0.0 400.8 381.71 19.09 13527.0 4050.0 10821.6 2.5 257.65 2.5 257.65 0.0 0.0 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 18:37:14
27 236 46 59 12516 45 Premium radiance face serum NULL 3304991 16 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 19200.0 4800.0 15360.0 9.0 1171.53 9.0 1171.53 0.0 0.0 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 18:37:14
28 237 47 59 12516 43 Quench Kiss Lip Balm NULL 3304300 15 35.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 525.0 2388.0 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 18:37:14
29 238 48 59 12516 46 Root Vitality Hair Oil NULL 3305901 59 54.0 255.0 0.0 0.0 204.0 194.29 9.71 15045.0 3186.0 12036.0 2.5 286.57 2.5 286.57 0.0 0.0 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 18:37:14
30 239 49 59 12516 57 Safe guard 250ml NULL 3105 24 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 60000.0 19200.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 18:37:14
31 240 50 59 12516 35 Sanitary Pad (15 pcs) NULL 9619001 370 40.0 380.0 0.0 0.0 304.0 304.0 0.0 140600.0 14800.0 112480.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 112480.0 INR 0 0.0 0.0 2025-11-07 18:37:14
32 241 51 59 12516 29 Shilajith NULL 30049011 21 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 37800.0 5250.0 30240.0 2.5 720.0 2.5 720.0 0.0 0.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 18:37:14
33 242 52 59 12516 26 Spirulina Cap NULL 2009899 30 190.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 5700.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 18:37:14
34 243 53 59 12516 1 Stem Cell Powder NULL 2936900 55 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 137445.0 41195.0 109956.0 2.5 2618.0 2.5 2618.0 0.0 0.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 18:37:14
35 244 54 59 12516 50 Sun Screen NULL 330499 44 250.0 699.0 0.0 0.0 559.2 473.9 85.3 30756.0 11000.0 24604.8 9.0 1876.63 9.0 1876.63 0.0 0.0 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 18:37:14
36 245 55 59 12516 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 18:37:14
37 246 56 59 12516 53 Terra care 2 kg NULL 3103100 71 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 106500.0 31950.0 85200.0 2.5 2028.57 2.5 2028.57 0.0 0.0 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 18:37:14
38 247 57 59 12516 5 Thyro Care NULL 2936900 21 250.0 899.0 0.0 0.0 719.2 684.95 34.25 18879.0 5250.0 15103.2 2.5 359.6 2.5 359.6 0.0 0.0 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 18:37:14
39 248 58 59 12516 36 Toilet Cleaner 500ml NULL 3924101 180 30.0 150.0 0.0 0.0 120.0 101.69 18.31 27000.0 5400.0 21600.0 9.0 1647.46 9.0 1647.46 0.0 0.0 101.69 3294.92 21600.0 INR 0 0.0 0.0 2025-11-07 18:37:14
40 249 59 59 12516 11 Vitamin B12 Drop NULL 2106909 131 190.0 749.0 0.0 0.0 599.2 570.67 28.53 98119.0 24890.0 78495.2 2.5 1868.93 2.5 1868.93 0.0 0.0 570.67 3737.87 78495.2 INR 0 0.0 0.0 2025-11-07 18:37:14
41 250 60 59 12516 23 Women Fuel Juice NULL 2202999 6 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 11994.0 1200.0 9595.2 2.5 228.46 2.5 228.46 0.0 0.0 1523.05 456.91 9595.2 INR 0 0.0 0.0 2025-11-07 18:37:14
42 251 61 59 12516 54 Wonder grow 100ml NULL 3105 55 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 77000.0 27500.0 61600.0 2.5 1466.66 2.5 1466.66 0.0 0.0 1066.67 2933.33 61600.0 INR 0 0.0 0.0 2025-11-07 18:37:14
43 252 1 60 12516 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 18:50:33
44 253 2 60 12516 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 18:50:33
45 254 3 60 12516 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-07 18:50:33
46 255 4 60 12516 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 9.0 73.41 9.0 73.41 0.0 0.0 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-07 18:50:33
47 256 5 60 12516 60 Foot patch NULL 30051090 1 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 1999.0 500.0 1599.2 2.5 38.08 2.5 38.08 0.0 0.0 1523.05 76.15 1599.2 INR 0 0.0 0.0 2025-11-07 18:50:33
48 257 6 60 12516 33 Herbal Soap 100gm NULL 30049011 24 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2400.0 672.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 76.19 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 18:50:33
49 258 7 60 12516 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-07 18:50:33
50 259 8 60 12516 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-07 18:50:33