fx_franchise_order_product

4,737 rows · 33 columns · page 39 / 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
1901 2110 1 351 12555 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-12-11 12:03:19
1902 2111 1 352 12554 35 Sanitary Pad (15 pcs) NULL 9619001 50 40.0 380.0 0.0 0.0 304.0 304.0 0.0 19000.0 2000.0 15200.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 15200.0 INR 0 0.0 0.0 2025-12-11 12:03:53
1903 2112 1 353 12516 35 Sanitary Pad (15 pcs) NULL 9619001 60 40.0 380.0 0.0 0.0 304.0 304.0 0.0 22800.0 2400.0 18240.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 18240.0 INR 0 0.0 0.0 2025-12-11 12:04:31
1904 2113 1 354 12555 31 Vegan Plant Protein Powder NULL 21061000 10 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 29990.0 10000.0 23992.0 2.5 571.24 2.5 571.24 0.0 0.0 2284.95 1142.48 23992.0 INR 0 0.0 0.0 2025-12-13 15:30:09
1905 2114 1 355 12555 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-12-13 16:28:16
1906 2115 1 356 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:30:31
1907 2116 1 357 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:48:00
1908 2117 1 358 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:55:28
1909 2118 1 359 12555 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:49:37
1910 2119 1 360 12554 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:51:12
1911 2120 1 361 12516 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:52:13
1912 2121 1 362 12518 5 Thyro Care NULL 2936900 101 0.0 899.0 0.0 0.0 719.2 684.95 34.25 90799.0 0.0 72639.2 2.5 1729.51 2.5 1729.51 0.0 0.0 684.95 3459.01 72639.2 INR 0 0.0 0.0 2025-12-16 15:39:27
1913 2122 1 363 12555 5 Thyro Care NULL 2936900 10 0.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 0.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-12-16 16:37:33
1914 2123 1 364 12516 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:02:36
1915 2124 2 364 12516 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:02:36
1916 2125 1 365 12516 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:08:01
1917 2126 2 365 12516 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:08:01
1918 2127 1 366 12554 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:10:20
1919 2128 2 366 12554 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:10:20
1920 2129 1 367 12555 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:12:24
1921 2130 2 367 12555 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:12:24
1922 2131 1 368 12555 62 3*3 BED WITH BRACELET NULL 9404 5 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 64995.0 0.0 38997.0 1.5 567.92 1.5 567.92 0.0 0.0 7572.23 1135.84 38997.0 INR 0 0.0 0.0 2025-12-17 12:13:42
1923 2132 2 368 12555 63 6*6 bio magnetic bed WITH bracelet NULL 9404 3 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 65997.0 0.0 39598.2 1.5 576.67 1.5 576.67 0.0 0.0 12814.95 1153.34 39598.2 INR 0 0.0 0.0 2025-12-17 12:13:42
1924 2133 1 369 12555 61 Radiation chip NULL 902221 10 0.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 0.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-12-17 13:54:51
1925 2134 1 370 12555 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:12
1926 2135 1 371 12554 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:38
1927 2136 1 372 12516 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:58
1928 2137 1 373 12555 4 Diabetic Care Capsules NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1929 2138 2 373 12555 19 Fat loss Juice 500 ml NULL 30049011 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1930 2139 3 373 12555 2 Heart Care Capsules NULL 2936900 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1931 2140 4 373 12555 24 Immunomax 24/7 Caps NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1932 2141 5 373 12555 18 Lady Care Juice 500ml NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1933 2142 6 373 12555 8 Piles Care NULL 30049011 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-17 21:29:33
1934 2143 1 374 12516 27 Multicharge Cap NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1935 2144 2 374 12516 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1936 2145 3 374 12516 3 BP Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1937 2146 4 374 12516 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1938 2147 5 374 12516 19 Fat loss Juice 500 ml NULL 30049011 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1939 2148 6 374 12516 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1940 2149 7 374 12516 8 Piles Care NULL 30049011 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1941 2150 8 374 12516 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
1942 2151 1 375 12554 27 Multicharge Cap NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1943 2152 2 375 12554 61 Radiation chip NULL 902221 50 0.0 999.0 0.0 0.0 500.0 423.73 76.27 49950.0 0.0 25000.0 9.0 1906.78 9.0 1906.78 0.0 0.0 423.73 3813.56 25000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1944 2153 3 375 12554 3 BP Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1945 2154 4 375 12554 4 Diabetic Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1946 2155 5 375 12554 19 Fat loss Juice 500 ml NULL 30049011 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1947 2156 6 375 12554 2 Heart Care Capsules NULL 2936900 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1948 2157 7 375 12554 24 Immunomax 24/7 Caps NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1949 2158 8 375 12554 8 Piles Care NULL 30049011 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
1950 2159 9 375 12554 5 Thyro Care NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-17 21:44:19