All orders 
Cart is empty
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+
Array ( [show_master_products_only] => [area] => A [extend] => Array ( [0] => product_name ) [pid] => Array ( [0] => 65121 ) [group_child_variations] => [skip_rating] => 1 [sort_by] => null [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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 (65121)) 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
before end of oxn
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )end of fxn
Array ( [show_master_products_only] => [area] => A [extend] => Array ( [0] => product_name ) [pid] => Array ( [0] => 65121 ) [group_child_variations] => [skip_rating] => 1 [sort_by] => null [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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 (65121)) 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
before end of oxn
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )end of fxn
Array ( [show_master_products_only] => [area] => A [extend] => Array ( [0] => product_name ) [pid] => Array ( [0] => 65121 ) [group_child_variations] => [skip_rating] => 1 [sort_by] => null [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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 (65121)) 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
before end of oxn
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )end of fxn
Array ( [show_master_products_only] => [area] => A [extend] => Array ( [0] => product_name ) [pid] => Array ( [0] => 65121 ) [group_child_variations] => [skip_rating] => 1 [sort_by] => null [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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 (65121)) 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
before end of oxn
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )end of fxn
Array ( [show_master_products_only] => [area] => A [extend] => Array ( [0] => product_name ) [pid] => Array ( [0] => 65121 ) [group_child_variations] => [skip_rating] => 1 [sort_by] => null [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
before 2nd hook
after 2nd hook
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 (65121)) 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
before end of oxn
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )
Array ( [65121] => Array ( [product_id] => 65121 [product] => Red Noir Eau De Parfum 50Ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 724 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => 8906121644623 [hsn_code] => 3304 [status] => A [list_price] => 599.00 [amount] => 2528 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1738934520 [updated_timestamp] => 1750427156 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [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] => 0 [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] => 437.270000 [category_ids] => Array ( [0] => 2780 ) [seo_name] => red-noir-eau-de-parfum-50ml [seo_path] => 2768/2769/2780 [main_category] => 2780 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 0 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Renee Cosmetics ) )end of fxn
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
A bold, luxurious fragrance with a blend of fruity, floral, and spicy notes, designed for confidence and charm. Its long-lasting formula makes it a perfect gift for all occasions.
Read More
Features
Brand:
Renee Cosmetics
Key Ingredients:
- DEP
- Ethyl Alcohol
- Perfume
- Propylene Glycol
Additional Information
Net Content:
Single Unit(s)
Array ( [show_master_products_only] => [area] => C [for_required_product] => 65121 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 13 )
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] => )
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
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 = 65121 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
How to use
Related to watch
Reviews
No reviews found
kindcode
