1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 17105
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 17105 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 17105
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => products
                                [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282
                            )
    
                    )
    
            )
    
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 1
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (17105)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 17105
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [condition_element] => 62
                                [operator] => nin
                                [condition] => feature
                                [value] => 49321,40971,38308
                                [value_name] => 
                            )
    
                    )
    
            )
    
        [include_child_variations] => 1
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 1
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (17105)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  1. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 17105
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 1
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (17105)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 17105
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [vr_company_id] => 0
        [is_virtual] => Y
        [virtual_conditions] => Array
            (
                [set] => all
                [set_value] => 1
                [conditions] => Array
                    (
                        [1] => Array
                            (
                                [operator] => in
                                [condition] => categories
                                [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684
                            )
    
                    )
    
            )
    
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 1
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A')  AND  ((1  AND  products.product_id IN (17105)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC  LIMIT 0, 1
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
Niana: Oudh Candle - 500gm

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

KLOVE | Extra 5% off on all Kbeauty orders above ₹999

SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+

SUNKISS5 | Extra 5% off on orders ₹999+

Niana: Oudh Candle - 500gm
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 17105
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (17105)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => NIA_OU
                [hsn_code] => 3304
                [status] => A
                [list_price] => 925.00
                [amount] => 10
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1662201518
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 878.750000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => oudh-candle-500gm
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  1. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => NIA_OU
                [hsn_code] => 3304
                [status] => A
                [list_price] => 925.00
                [amount] => 10
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1662201518
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 878.750000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => oudh-candle-500gm
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 17105
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  WHERE 1  AND companies.status IN ('A') AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0)  AND  ((1  AND  products.product_id IN (17105)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => NIA_OU
                [hsn_code] => 3304
                [status] => A
                [list_price] => 925.00
                [amount] => 10
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1662201518
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 878.750000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => oudh-candle-500gm
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  1. Array
    (
        [17105] => Array
            (
                [product_id] => 17105
                [product] => Oudh Candle - 500gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 358
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => NIA_OU
                [hsn_code] => 3304
                [status] => A
                [list_price] => 925.00
                [amount] => 10
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1662201518
                [updated_timestamp] => 1750246019
                [usergroup_ids] => 0
                [is_edp] => N
                [edp_shipping] => N
                [unlimited_download] => N
                [tracking] => B
                [free_shipping] => N
                [zero_price_action] => R
                [is_pbp] => Y
                [is_op] => N
                [is_oper] => N
                [is_returnable] => Y
                [return_period] => 10
                [avail_since] => 0
                [out_of_stock_actions] => N
                [localization] => 
                [min_qty] => 0
                [max_qty] => 5
                [qty_step] => 0
                [list_qty_count] => 0
                [tax_ids] => 13
                [age_verification] => N
                [age_limit] => 0
                [options_type] => P
                [exceptions_type] => F
                [details_layout] => default
                [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
                [facebook_obj_type] => 
                [buy_now_url] => 
                [is_stock_split_by_warehouses] => N
                [master_product_status] => A
                [youtube_link] => 
                [show_youtube_video] => Y
                [replace_main_image] => 
                [position_youtube] => 
                [restrict_cod] => N
                [price] => 878.750000
                [category_ids] => Array
                    (
                        [0] => 451
                    )
    
                [seo_name] => oudh-candle-500gm
                [seo_path] => 211/212/221/451
                [main_category] => 451
                [options_type_raw] => P
                [exceptions_type_raw] => F
                [tracking_raw] => B
                [zero_price_action_raw] => R
                [min_qty_raw] => 0
                [max_qty_raw] => 5
                [qty_step_raw] => 0
                [list_qty_count_raw] => 0
                [details_layout_raw] => default
                [video_as_images] => Array
                    (
                    )
    
                [videos] => Array
                    (
                    )
    
                [brand_name] => Niana
            )
    
    )
    
    
  2. end of fxn
    

Oudh Candle - 500gm

Scented Soy Candle

Compare

Share

879
925
Save: ₹46 (5%)
i

Price details

  • Maximum retail price incl. of all taxes
    925
  • Total Discount 46
Special Price
879
26
kinders earned

Delivery

Your box of happiness will be shipped in 2-4 business days.
Cash on delivery available on orders above ₹499
100% recyclable packaging
10 Days Return Policy
Available offers
  • Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.
  • Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
Details
Features
How to use
Related to watch
Reviews
kindcode

Details

Addictive with heavenly tones and warm aromas. Known for its mystical and healing properties, velvety Oudh derived from agarwood is exotic and sensual. Fresh floral, powdery and musky notes are layered and blended with earthy patchouli & sandalwood. This soothing aroma is reminiscent of a heady Arabian night and will invite harmony and peace around any space.




Read More

Features

Brand:
Niana
Key Ingredients:
  • 100% Cotton Wick
  • Fragrance
  • Soy wax
Ingredients:
  • Soy Wax, Fragrance, 100% Cotton Wick
kindcode
:
  • Cruelty Free
  • Toxin Free

Additional Information

Net Weight:
500gm
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 17105
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  1. Array
    (
        [area] => C
        [use_caching] => 1
        [extend] => Array
            (
                [0] => product_name
                [1] => prices
                [2] => categories
            )
    
        [custom_extend] => Array
            (
            )
    
        [pname] => 
        [pshort] => 
        [pfull] => 
        [pkeywords] => 
        [feature] => Array
            (
            )
    
        [type] => simple
        [page] => 1
        [action] => 
        [filter_variants] => Array
            (
            )
    
        [features_hash] => 
        [limit] => 0
        [bid] => 0
        [match] => 
        [tracking] => Array
            (
            )
    
        [get_frontend_urls] => 
        [items_per_page] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products  LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en'  LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id  INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id  AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids))  LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P'  LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id  LEFT JOIN ?:product_required_products ON products.product_id = ?:product_required_products.required_id WHERE 1  AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) AND products.master_product_status IN ('A') AND ?:product_required_products.product_id = 17105 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    

How to use

Allow all the wax on the surface to melt and become a liquid pool. Let the liquid pool reach the edges of the container before extinguishing.

Related to watch

Reviews

No reviews found

kindcode

  • Cruelty Free

    “Cruelty-Free” is a PETA provided certification to brands which do not conduct product tests on animals prior to sales. Considering the vulnerability of animals and their lack of ability to give consent doesn’t make it ethical to test products meant for human use on them. Hence products that are natural or plant based could be cruelty free only if they have not been tested on animals.

  • Toxin Free

    Toxin free products indicate that the ingredients used in it do not exist in amounts that are known or proven to be harmful and affect the consumer negatively. It does not always mean that there are no chemicals in it.

Niana

Luxury soy candles and home fragrances hand-finished for subtle evocative ambiance

Shop the Brand

kiki.AI

Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.

Compare with similar items

Similar Products

Recently viewed

Server

Request

Config

SQL

Cache queries

Logging

Templates

Blocks