Array ( [show_master_products_only] => [area] => C [currency] => INR [sort_order] => desc [sl] => en [dispatch] => categories.view [category_id] => 2577 [save_view_results] => product_id [items_per_page] => 24 [sort_by] => bestsellers [cid] => 2577 [extend] => Array ( [0] => categories [1] => description [2] => description [3] => full_description ) [subcats] => Y [runtime_company_id] => 0 )
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] => 24 [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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND ?:categories.category_id IN (2577, 459, 460, 711, 712) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array ( [682] => Array ( [product_id] => 682 [product] => Onion Shampoo - 400ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => #8906087772187 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 400.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1612167970 [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] => activity [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] => 474.050000 [short_description] => Strengthening hair cleanser [full_description] => <p>Stress, pollution & unhealthy lifestyle choices can lead to many hair troubles, hair fall is the most common one. Mamaearth's Onion Hair Shampoo helps you combat that. Onion Oil, rich in Sulphur, Potassium & antioxidants, reduces hair fall & accelerates hair regrowth. Plant Keratin replenishes and strengthens hair, repairing its natural structure. It makes hair smooth & frizz-free. Safe for coloured & chemically treated hair, this Shampoo is free of harmful chemicals & toxins such as Sulfates, Silicones, Parabens, Mineral Oil & Dyes.</p> [category_ids] => Array ( [0] => 424 [1] => 460 [2] => 2765 ) [position] => [seo_name] => onion-shampoo [seo_path] => 2743/2759/2765 [average_rating] => 5.00 [reviews_count] => 8 [main_category] => 2765 [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] => Mamaearth [ratting_count] => 8 ) [1420] => Array ( [product_id] => 1420 [product] => Plum Green Tea Pore Cleansing Face Wash Acne Face Wash - 100ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0100FWA8121 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 6 [weight] => 125.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => [full_description] => <p>This product for deeply cleanses away all the dirt, grime and dead skin from your face. It is rich in antioxidant green tea that helps in controlling sebum production and makes your skin acne-free. Glycolic acid helps in brightening the skin. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2779 ) [position] => [seo_name] => green-tea-face-wash-120ml [seo_path] => 2768/2774/2779 [average_rating] => 4.82 [reviews_count] => 11 [main_category] => 2779 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [1296] => Array ( [video_id] => 1296 [video_type] => A [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1718044200 [status] => A [user_id] => 149280 [extra_params] => [community_video_id] => 0 [community_url] => https://www.kindlife.in/best-cleansers-for-oily-combination-skin [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117_preview.jpg [community_video_url] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117.mov [community_last_sync_timestamp] => 0 [lang_code] => en [youtube_id] => [video] => From Oily to Acne-Prone [description] => <p><strong>Refresh your skin with Plum Green Tea Pore Cleansing Face Wash! Perfect for daily use, it controls acne and leaves your skin feeling clean and clear. For targeted acne care, try our Acne Control Cleanser, designed to fight breakouts and soothe irritation. Need a full-body cleanse? The Sebium Face and Body Wash Moussant Purifying Cleansing Gel keeps both your face and body purified and balanced.</strong></p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [417] => Array ( [video_id] => 417 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 22532 [extra_params] => [community_video_id] => 395 [community_url] => https://admin.kindlife.in/the-ultimate-monsoon-skincare-routine [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/395/f18dcaf4055eecac91bd9268171207ff.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/395/fac0c86ff6c6ba244bc1231558d57437.mp4 [community_last_sync_timestamp] => 1713161296 [lang_code] => en [youtube_id] => [video] => The Ultimate Monsoon Skincare Routine! [description] => <p>Beat the monsoon blues with a simplified skincare routine! Discover the perfect combination of face wash, toner, and moisturizer to protect your skin from humidity and keep it fresh and glowing. Let's tackle monsoon skin woes together!</p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [585] => Array ( [video_id] => 585 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 2807 [extra_params] => [community_video_id] => 139 [community_url] => https://admin.kindlife.in/3-steps-to-skincare-you-shouldnt-be-missing [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/139/6d08946bd5b62d256ff7eeb9332d9424.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/139/4ae1156575e47477198dd2e092e42c22.mp4 [community_last_sync_timestamp] => 1713158780 [lang_code] => en [youtube_id] => [video] => 3 Skincare Must-Dos [description] => <p>Keep your skin looking flawless with these 3 essential skincare steps! Start with Plum Green Tea Pore Cleansing Face Wash to remove dirt and impurities. Follow up with Plum Green Tea Mattifying Moisturizer to keep your skin hydrated and shine-free. Don’t forget to protect your skin with Plum Green Tea Day-Light Sunscreen SPF35 PA+++. These products will keep your skin fresh, clear, and protected all day long! </p> [short_description] => [privacy] => 1 [like_count] => 4 [dislike_count] => 0 [comment_count] => 3 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 11 ) [35763] => Array ( [product_id] => 35763 [product] => 25ml Plum Green Tea Mattifying Moisturizer [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0025DMT0279 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 40 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705402185 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => Expiry Date: 01-03-2025 [full_description] => <p>This product with green tea extracts helps in fighting acne and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan. After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2821 ) [position] => [seo_name] => plum-green-tea-mattifying-moisturizer-25ml [seo_path] => 2685/2686/2821 [main_category] => 2821 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [995] => Array ( [video_id] => 995 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1707849000 [status] => A [user_id] => 76014 [extra_params] => [community_video_id] => 1126 [community_url] => https://www.kindlife.in/plum-haul [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4 [community_last_sync_timestamp] => 1707913411 [lang_code] => en [youtube_id] => [video] => Unboxing My Latest Plum Haul [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p> <p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p> <p><br></p> </b><p></p> [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum ) [1450] => Array ( [product_id] => 1450 [product] => Age Specialist Bright Years Serum - 30ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLBY0030FSE1147 [hsn_code] => 3304 [status] => A [list_price] => 1575.00 [amount] => 3 [weight] => 30.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 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] => activity [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] => 1496.250000 [short_description] => Expiry Date: 01-07-2025 [full_description] => <p>This quick absorbing, anti-ageing, ultra-hydrating serum makes your skin feel as good as new. The specially isolated sesame protein in this product is proven to help make skin look taut and visibly fuller. Argan oil, plant betaine and vitamin e concentrates provide deep hydration to the skin and keep the dark circles at bay by smoothing out your wrinkles. Hyaluronic acid in this product maintains your skin's hydration levels so it doesn't feel dull, dry and dehydrated. Suitable for dry, very dry skin type on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free, paraben free, sulphate-free and mineral oil free.</p> <p><br /></p> <p><br /></p> [category_ids] => Array ( [0] => 459 [1] => 493 [2] => 2706 ) [position] => [seo_name] => age-specialist-bright-years-serum-30-ml [seo_path] => 2685/2705/2706 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2706 [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] => Plum [ratting_count] => 5 ) [1421] => Array ( [product_id] => 1421 [product] => Plum Green Tea Renewed Clarity Night Gel [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0050NMT0522 [hsn_code] => 3304 [status] => A [list_price] => 575.00 [amount] => 4 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [updated_timestamp] => 1750266880 [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] => 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] => activity [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] => 546.000000 [short_description] => [full_description] => <p>This non-greasy product, rich in antioxidant green tea extracts helps in clearing out acne and acne marks and leaves behind brighter, glowing skin. Argan oil extracts in this product provide balanced hydration and helps your skin retain its moisture overnight. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free and paraben free.</p> <p><br /></p> [category_ids] => Array ( [0] => 2815 [1] => 459 ) [position] => [seo_name] => green-tea-night-gel-50-ml [seo_path] => 2577/459 [average_rating] => 4.90 [reviews_count] => 10 [main_category] => 459 [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 ( [708] => Array ( [video_id] => 708 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1682879400 [status] => A [user_id] => 146299 [extra_params] => [community_video_id] => 733 [community_url] => https://www.kindlife.in/summer-beauty-essentials [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/733/2dd6fc782e4559b78775d8f42d1a6ab7.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/733/7b02f84e9d78f877fbaa06b68cebedf8.mp4 [community_last_sync_timestamp] => 1713162242 [lang_code] => en [youtube_id] => [video] => Summer Beauty Essentials? [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@night"><a id="product_1421" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=1421" data-value="1421">Plum Green Tea Renewed Clarity NightGel</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@body"><a id="product_22355" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=22355" data-value="22355">Body Exfoliating & Pigmentation Removal cream - 100gm</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@ginseng"><a id="product_13927" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13927" data-value="13927">Ginseng Essence Water - 150ml</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@silky"><a id="product_13802" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13802" data-value="13802">Sun Project Silky Calming Sun Stick SPF50+ PA++++(14gm)</a></span> and vanilla vibes edp✨ [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 10 ) )
Array ( [682] => Array ( [product_id] => 682 [product] => Onion Shampoo - 400ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => #8906087772187 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 400.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1612167970 [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] => activity [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] => 474.050000 [short_description] => Strengthening hair cleanser [full_description] => <p>Stress, pollution & unhealthy lifestyle choices can lead to many hair troubles, hair fall is the most common one. Mamaearth's Onion Hair Shampoo helps you combat that. Onion Oil, rich in Sulphur, Potassium & antioxidants, reduces hair fall & accelerates hair regrowth. Plant Keratin replenishes and strengthens hair, repairing its natural structure. It makes hair smooth & frizz-free. Safe for coloured & chemically treated hair, this Shampoo is free of harmful chemicals & toxins such as Sulfates, Silicones, Parabens, Mineral Oil & Dyes.</p> [category_ids] => Array ( [0] => 424 [1] => 460 [2] => 2765 ) [position] => [seo_name] => onion-shampoo [seo_path] => 2743/2759/2765 [average_rating] => 5.00 [reviews_count] => 8 [main_category] => 2765 [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] => Mamaearth [ratting_count] => 8 ) [1420] => Array ( [product_id] => 1420 [product] => Plum Green Tea Pore Cleansing Face Wash Acne Face Wash - 100ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0100FWA8121 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 6 [weight] => 125.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => [full_description] => <p>This product for deeply cleanses away all the dirt, grime and dead skin from your face. It is rich in antioxidant green tea that helps in controlling sebum production and makes your skin acne-free. Glycolic acid helps in brightening the skin. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2779 ) [position] => [seo_name] => green-tea-face-wash-120ml [seo_path] => 2768/2774/2779 [average_rating] => 4.82 [reviews_count] => 11 [main_category] => 2779 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [1296] => Array ( [video_id] => 1296 [video_type] => A [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1718044200 [status] => A [user_id] => 149280 [extra_params] => [community_video_id] => 0 [community_url] => https://www.kindlife.in/best-cleansers-for-oily-combination-skin [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117_preview.jpg [community_video_url] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117.mov [community_last_sync_timestamp] => 0 [lang_code] => en [youtube_id] => [video] => From Oily to Acne-Prone [description] => <p><strong>Refresh your skin with Plum Green Tea Pore Cleansing Face Wash! Perfect for daily use, it controls acne and leaves your skin feeling clean and clear. For targeted acne care, try our Acne Control Cleanser, designed to fight breakouts and soothe irritation. Need a full-body cleanse? The Sebium Face and Body Wash Moussant Purifying Cleansing Gel keeps both your face and body purified and balanced.</strong></p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [417] => Array ( [video_id] => 417 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 22532 [extra_params] => [community_video_id] => 395 [community_url] => https://admin.kindlife.in/the-ultimate-monsoon-skincare-routine [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/395/f18dcaf4055eecac91bd9268171207ff.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/395/fac0c86ff6c6ba244bc1231558d57437.mp4 [community_last_sync_timestamp] => 1713161296 [lang_code] => en [youtube_id] => [video] => The Ultimate Monsoon Skincare Routine! [description] => <p>Beat the monsoon blues with a simplified skincare routine! Discover the perfect combination of face wash, toner, and moisturizer to protect your skin from humidity and keep it fresh and glowing. Let's tackle monsoon skin woes together!</p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [585] => Array ( [video_id] => 585 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 2807 [extra_params] => [community_video_id] => 139 [community_url] => https://admin.kindlife.in/3-steps-to-skincare-you-shouldnt-be-missing [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/139/6d08946bd5b62d256ff7eeb9332d9424.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/139/4ae1156575e47477198dd2e092e42c22.mp4 [community_last_sync_timestamp] => 1713158780 [lang_code] => en [youtube_id] => [video] => 3 Skincare Must-Dos [description] => <p>Keep your skin looking flawless with these 3 essential skincare steps! Start with Plum Green Tea Pore Cleansing Face Wash to remove dirt and impurities. Follow up with Plum Green Tea Mattifying Moisturizer to keep your skin hydrated and shine-free. Don’t forget to protect your skin with Plum Green Tea Day-Light Sunscreen SPF35 PA+++. These products will keep your skin fresh, clear, and protected all day long! </p> [short_description] => [privacy] => 1 [like_count] => 4 [dislike_count] => 0 [comment_count] => 3 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 11 ) [35763] => Array ( [product_id] => 35763 [product] => 25ml Plum Green Tea Mattifying Moisturizer [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0025DMT0279 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 40 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705402185 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => Expiry Date: 01-03-2025 [full_description] => <p>This product with green tea extracts helps in fighting acne and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan. After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2821 ) [position] => [seo_name] => plum-green-tea-mattifying-moisturizer-25ml [seo_path] => 2685/2686/2821 [main_category] => 2821 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [995] => Array ( [video_id] => 995 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1707849000 [status] => A [user_id] => 76014 [extra_params] => [community_video_id] => 1126 [community_url] => https://www.kindlife.in/plum-haul [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4 [community_last_sync_timestamp] => 1707913411 [lang_code] => en [youtube_id] => [video] => Unboxing My Latest Plum Haul [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p> <p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p> <p><br></p> </b><p></p> [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum ) [1450] => Array ( [product_id] => 1450 [product] => Age Specialist Bright Years Serum - 30ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLBY0030FSE1147 [hsn_code] => 3304 [status] => A [list_price] => 1575.00 [amount] => 3 [weight] => 30.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 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] => activity [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] => 1496.250000 [short_description] => Expiry Date: 01-07-2025 [full_description] => <p>This quick absorbing, anti-ageing, ultra-hydrating serum makes your skin feel as good as new. The specially isolated sesame protein in this product is proven to help make skin look taut and visibly fuller. Argan oil, plant betaine and vitamin e concentrates provide deep hydration to the skin and keep the dark circles at bay by smoothing out your wrinkles. Hyaluronic acid in this product maintains your skin's hydration levels so it doesn't feel dull, dry and dehydrated. Suitable for dry, very dry skin type on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free, paraben free, sulphate-free and mineral oil free.</p> <p><br /></p> <p><br /></p> [category_ids] => Array ( [0] => 459 [1] => 493 [2] => 2706 ) [position] => [seo_name] => age-specialist-bright-years-serum-30-ml [seo_path] => 2685/2705/2706 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2706 [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] => Plum [ratting_count] => 5 ) [1421] => Array ( [product_id] => 1421 [product] => Plum Green Tea Renewed Clarity Night Gel [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0050NMT0522 [hsn_code] => 3304 [status] => A [list_price] => 575.00 [amount] => 4 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [updated_timestamp] => 1750266880 [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] => 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] => activity [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] => 546.000000 [short_description] => [full_description] => <p>This non-greasy product, rich in antioxidant green tea extracts helps in clearing out acne and acne marks and leaves behind brighter, glowing skin. Argan oil extracts in this product provide balanced hydration and helps your skin retain its moisture overnight. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free and paraben free.</p> <p><br /></p> [category_ids] => Array ( [0] => 2815 [1] => 459 ) [position] => [seo_name] => green-tea-night-gel-50-ml [seo_path] => 2577/459 [average_rating] => 4.90 [reviews_count] => 10 [main_category] => 459 [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 ( [708] => Array ( [video_id] => 708 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1682879400 [status] => A [user_id] => 146299 [extra_params] => [community_video_id] => 733 [community_url] => https://www.kindlife.in/summer-beauty-essentials [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/733/2dd6fc782e4559b78775d8f42d1a6ab7.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/733/7b02f84e9d78f877fbaa06b68cebedf8.mp4 [community_last_sync_timestamp] => 1713162242 [lang_code] => en [youtube_id] => [video] => Summer Beauty Essentials? [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@night"><a id="product_1421" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=1421" data-value="1421">Plum Green Tea Renewed Clarity NightGel</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@body"><a id="product_22355" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=22355" data-value="22355">Body Exfoliating & Pigmentation Removal cream - 100gm</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@ginseng"><a id="product_13927" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13927" data-value="13927">Ginseng Essence Water - 150ml</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@silky"><a id="product_13802" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13802" data-value="13802">Sun Project Silky Calming Sun Stick SPF50+ PA++++(14gm)</a></span> and vanilla vibes edp✨ [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 10 ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [currency] => INR [sort_order] => desc [sl] => en [dispatch] => categories.view [category_id] => 2577 [save_view_results] => product_id [items_per_page] => 24 [sort_by] => bestsellers [cid] => 2577 [extend] => Array ( [0] => categories [1] => description [2] => description [3] => full_description ) [subcats] => Y [runtime_company_id] => 0 )
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] => 24 [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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND ?:categories.category_id IN (2577, 459, 460, 711, 712) 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.parent_product_id = 0 AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 24
before end of oxn
Array ( [682] => Array ( [product_id] => 682 [product] => Onion Shampoo - 400ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => #8906087772187 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 400.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1612167970 [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] => activity [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] => 474.050000 [short_description] => Strengthening hair cleanser [full_description] => <p>Stress, pollution & unhealthy lifestyle choices can lead to many hair troubles, hair fall is the most common one. Mamaearth's Onion Hair Shampoo helps you combat that. Onion Oil, rich in Sulphur, Potassium & antioxidants, reduces hair fall & accelerates hair regrowth. Plant Keratin replenishes and strengthens hair, repairing its natural structure. It makes hair smooth & frizz-free. Safe for coloured & chemically treated hair, this Shampoo is free of harmful chemicals & toxins such as Sulfates, Silicones, Parabens, Mineral Oil & Dyes.</p> [category_ids] => Array ( [0] => 424 [1] => 460 [2] => 2765 ) [position] => [seo_name] => onion-shampoo [seo_path] => 2743/2759/2765 [average_rating] => 5.00 [reviews_count] => 8 [main_category] => 2765 [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] => Mamaearth [ratting_count] => 8 ) [1420] => Array ( [product_id] => 1420 [product] => Plum Green Tea Pore Cleansing Face Wash Acne Face Wash - 100ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0100FWA8121 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 6 [weight] => 125.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => [full_description] => <p>This product for deeply cleanses away all the dirt, grime and dead skin from your face. It is rich in antioxidant green tea that helps in controlling sebum production and makes your skin acne-free. Glycolic acid helps in brightening the skin. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2779 ) [position] => [seo_name] => green-tea-face-wash-120ml [seo_path] => 2768/2774/2779 [average_rating] => 4.82 [reviews_count] => 11 [main_category] => 2779 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [1296] => Array ( [video_id] => 1296 [video_type] => A [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1718044200 [status] => A [user_id] => 149280 [extra_params] => [community_video_id] => 0 [community_url] => https://www.kindlife.in/best-cleansers-for-oily-combination-skin [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117_preview.jpg [community_video_url] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117.mov [community_last_sync_timestamp] => 0 [lang_code] => en [youtube_id] => [video] => From Oily to Acne-Prone [description] => <p><strong>Refresh your skin with Plum Green Tea Pore Cleansing Face Wash! Perfect for daily use, it controls acne and leaves your skin feeling clean and clear. For targeted acne care, try our Acne Control Cleanser, designed to fight breakouts and soothe irritation. Need a full-body cleanse? The Sebium Face and Body Wash Moussant Purifying Cleansing Gel keeps both your face and body purified and balanced.</strong></p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [417] => Array ( [video_id] => 417 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 22532 [extra_params] => [community_video_id] => 395 [community_url] => https://admin.kindlife.in/the-ultimate-monsoon-skincare-routine [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/395/f18dcaf4055eecac91bd9268171207ff.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/395/fac0c86ff6c6ba244bc1231558d57437.mp4 [community_last_sync_timestamp] => 1713161296 [lang_code] => en [youtube_id] => [video] => The Ultimate Monsoon Skincare Routine! [description] => <p>Beat the monsoon blues with a simplified skincare routine! Discover the perfect combination of face wash, toner, and moisturizer to protect your skin from humidity and keep it fresh and glowing. Let's tackle monsoon skin woes together!</p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [585] => Array ( [video_id] => 585 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 2807 [extra_params] => [community_video_id] => 139 [community_url] => https://admin.kindlife.in/3-steps-to-skincare-you-shouldnt-be-missing [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/139/6d08946bd5b62d256ff7eeb9332d9424.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/139/4ae1156575e47477198dd2e092e42c22.mp4 [community_last_sync_timestamp] => 1713158780 [lang_code] => en [youtube_id] => [video] => 3 Skincare Must-Dos [description] => <p>Keep your skin looking flawless with these 3 essential skincare steps! Start with Plum Green Tea Pore Cleansing Face Wash to remove dirt and impurities. Follow up with Plum Green Tea Mattifying Moisturizer to keep your skin hydrated and shine-free. Don’t forget to protect your skin with Plum Green Tea Day-Light Sunscreen SPF35 PA+++. These products will keep your skin fresh, clear, and protected all day long! </p> [short_description] => [privacy] => 1 [like_count] => 4 [dislike_count] => 0 [comment_count] => 3 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 11 ) [35763] => Array ( [product_id] => 35763 [product] => 25ml Plum Green Tea Mattifying Moisturizer [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0025DMT0279 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 40 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705402185 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => Expiry Date: 01-03-2025 [full_description] => <p>This product with green tea extracts helps in fighting acne and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan. After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2821 ) [position] => [seo_name] => plum-green-tea-mattifying-moisturizer-25ml [seo_path] => 2685/2686/2821 [main_category] => 2821 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [995] => Array ( [video_id] => 995 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1707849000 [status] => A [user_id] => 76014 [extra_params] => [community_video_id] => 1126 [community_url] => https://www.kindlife.in/plum-haul [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4 [community_last_sync_timestamp] => 1707913411 [lang_code] => en [youtube_id] => [video] => Unboxing My Latest Plum Haul [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p> <p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p> <p><br></p> </b><p></p> [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum ) [1450] => Array ( [product_id] => 1450 [product] => Age Specialist Bright Years Serum - 30ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLBY0030FSE1147 [hsn_code] => 3304 [status] => A [list_price] => 1575.00 [amount] => 3 [weight] => 30.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 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] => activity [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] => 1496.250000 [short_description] => Expiry Date: 01-07-2025 [full_description] => <p>This quick absorbing, anti-ageing, ultra-hydrating serum makes your skin feel as good as new. The specially isolated sesame protein in this product is proven to help make skin look taut and visibly fuller. Argan oil, plant betaine and vitamin e concentrates provide deep hydration to the skin and keep the dark circles at bay by smoothing out your wrinkles. Hyaluronic acid in this product maintains your skin's hydration levels so it doesn't feel dull, dry and dehydrated. Suitable for dry, very dry skin type on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free, paraben free, sulphate-free and mineral oil free.</p> <p><br /></p> <p><br /></p> [category_ids] => Array ( [0] => 459 [1] => 493 [2] => 2706 ) [position] => [seo_name] => age-specialist-bright-years-serum-30-ml [seo_path] => 2685/2705/2706 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2706 [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] => Plum [ratting_count] => 5 ) [1421] => Array ( [product_id] => 1421 [product] => Plum Green Tea Renewed Clarity Night Gel [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0050NMT0522 [hsn_code] => 3304 [status] => A [list_price] => 575.00 [amount] => 4 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [updated_timestamp] => 1750266880 [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] => 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] => activity [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] => 546.000000 [short_description] => [full_description] => <p>This non-greasy product, rich in antioxidant green tea extracts helps in clearing out acne and acne marks and leaves behind brighter, glowing skin. Argan oil extracts in this product provide balanced hydration and helps your skin retain its moisture overnight. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free and paraben free.</p> <p><br /></p> [category_ids] => Array ( [0] => 2815 [1] => 459 ) [position] => [seo_name] => green-tea-night-gel-50-ml [seo_path] => 2577/459 [average_rating] => 4.90 [reviews_count] => 10 [main_category] => 459 [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 ( [708] => Array ( [video_id] => 708 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1682879400 [status] => A [user_id] => 146299 [extra_params] => [community_video_id] => 733 [community_url] => https://www.kindlife.in/summer-beauty-essentials [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/733/2dd6fc782e4559b78775d8f42d1a6ab7.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/733/7b02f84e9d78f877fbaa06b68cebedf8.mp4 [community_last_sync_timestamp] => 1713162242 [lang_code] => en [youtube_id] => [video] => Summer Beauty Essentials? [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@night"><a id="product_1421" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=1421" data-value="1421">Plum Green Tea Renewed Clarity NightGel</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@body"><a id="product_22355" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=22355" data-value="22355">Body Exfoliating & Pigmentation Removal cream - 100gm</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@ginseng"><a id="product_13927" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13927" data-value="13927">Ginseng Essence Water - 150ml</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@silky"><a id="product_13802" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13802" data-value="13802">Sun Project Silky Calming Sun Stick SPF50+ PA++++(14gm)</a></span> and vanilla vibes edp✨ [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 10 ) )
Array ( [682] => Array ( [product_id] => 682 [product] => Onion Shampoo - 400ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => #8906087772187 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 400.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1612167970 [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] => activity [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] => 474.050000 [short_description] => Strengthening hair cleanser [full_description] => <p>Stress, pollution & unhealthy lifestyle choices can lead to many hair troubles, hair fall is the most common one. Mamaearth's Onion Hair Shampoo helps you combat that. Onion Oil, rich in Sulphur, Potassium & antioxidants, reduces hair fall & accelerates hair regrowth. Plant Keratin replenishes and strengthens hair, repairing its natural structure. It makes hair smooth & frizz-free. Safe for coloured & chemically treated hair, this Shampoo is free of harmful chemicals & toxins such as Sulfates, Silicones, Parabens, Mineral Oil & Dyes.</p> [category_ids] => Array ( [0] => 424 [1] => 460 [2] => 2765 ) [position] => [seo_name] => onion-shampoo [seo_path] => 2743/2759/2765 [average_rating] => 5.00 [reviews_count] => 8 [main_category] => 2765 [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] => Mamaearth [ratting_count] => 8 ) [1420] => Array ( [product_id] => 1420 [product] => Plum Green Tea Pore Cleansing Face Wash Acne Face Wash - 100ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0100FWA8121 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 6 [weight] => 125.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => [full_description] => <p>This product for deeply cleanses away all the dirt, grime and dead skin from your face. It is rich in antioxidant green tea that helps in controlling sebum production and makes your skin acne-free. Glycolic acid helps in brightening the skin. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2779 ) [position] => [seo_name] => green-tea-face-wash-120ml [seo_path] => 2768/2774/2779 [average_rating] => 4.82 [reviews_count] => 11 [main_category] => 2779 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [1296] => Array ( [video_id] => 1296 [video_type] => A [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1718044200 [status] => A [user_id] => 149280 [extra_params] => [community_video_id] => 0 [community_url] => https://www.kindlife.in/best-cleansers-for-oily-combination-skin [community_thumbnail] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117_preview.jpg [community_video_url] => https://cdn02.kindlife.in/images/video_library/1296_1718016127648117.mov [community_last_sync_timestamp] => 0 [lang_code] => en [youtube_id] => [video] => From Oily to Acne-Prone [description] => <p><strong>Refresh your skin with Plum Green Tea Pore Cleansing Face Wash! Perfect for daily use, it controls acne and leaves your skin feeling clean and clear. For targeted acne care, try our Acne Control Cleanser, designed to fight breakouts and soothe irritation. Need a full-body cleanse? The Sebium Face and Body Wash Moussant Purifying Cleansing Gel keeps both your face and body purified and balanced.</strong></p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [417] => Array ( [video_id] => 417 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 22532 [extra_params] => [community_video_id] => 395 [community_url] => https://admin.kindlife.in/the-ultimate-monsoon-skincare-routine [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/395/f18dcaf4055eecac91bd9268171207ff.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/395/fac0c86ff6c6ba244bc1231558d57437.mp4 [community_last_sync_timestamp] => 1713161296 [lang_code] => en [youtube_id] => [video] => The Ultimate Monsoon Skincare Routine! [description] => <p>Beat the monsoon blues with a simplified skincare routine! Discover the perfect combination of face wash, toner, and moisturizer to protect your skin from humidity and keep it fresh and glowing. Let's tackle monsoon skin woes together!</p> [short_description] => [privacy] => 1 [like_count] => 1 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) [585] => Array ( [video_id] => 585 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1681669800 [status] => A [user_id] => 2807 [extra_params] => [community_video_id] => 139 [community_url] => https://admin.kindlife.in/3-steps-to-skincare-you-shouldnt-be-missing [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/139/6d08946bd5b62d256ff7eeb9332d9424.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/139/4ae1156575e47477198dd2e092e42c22.mp4 [community_last_sync_timestamp] => 1713158780 [lang_code] => en [youtube_id] => [video] => 3 Skincare Must-Dos [description] => <p>Keep your skin looking flawless with these 3 essential skincare steps! Start with Plum Green Tea Pore Cleansing Face Wash to remove dirt and impurities. Follow up with Plum Green Tea Mattifying Moisturizer to keep your skin hydrated and shine-free. Don’t forget to protect your skin with Plum Green Tea Day-Light Sunscreen SPF35 PA+++. These products will keep your skin fresh, clear, and protected all day long! </p> [short_description] => [privacy] => 1 [like_count] => 4 [dislike_count] => 0 [comment_count] => 3 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 11 ) [35763] => Array ( [product_id] => 35763 [product] => 25ml Plum Green Tea Mattifying Moisturizer [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0025DMT0279 [hsn_code] => 3304 [status] => A [list_price] => 275.00 [amount] => 40 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705402185 [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] => 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] => 2 [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] => activity [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] => 261.250000 [short_description] => Expiry Date: 01-03-2025 [full_description] => <p>This product with green tea extracts helps in fighting acne and provides controlled hydration to the skin. Glycolic acid helps exfoliate pores gently and keeps the skin clear and oil-free all day long. It is 100% vegan. After cleansing and toning, apply tiny dots of the moisturizer all over your face and neck. While it's still drying, tap lightly with your fingertips to allow the moisturizer to soak in better. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, mineral oil free, SLS free, cruelty-free and paraben free.</p> [category_ids] => Array ( [0] => 459 [1] => 2821 ) [position] => [seo_name] => plum-green-tea-mattifying-moisturizer-25ml [seo_path] => 2685/2686/2821 [main_category] => 2821 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 2 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( [995] => Array ( [video_id] => 995 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1707849000 [status] => A [user_id] => 76014 [extra_params] => [community_video_id] => 1126 [community_url] => https://www.kindlife.in/plum-haul [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/1126/5485bf9e4601f3dd331bf2a675ca1f08.mp4 [community_last_sync_timestamp] => 1707913411 [lang_code] => en [youtube_id] => [video] => Unboxing My Latest Plum Haul [description] => <p>Treat yourself to a Plum Haul and discover a range of delightful products for your skin and senses! Start with the invigorating Coffee Wake-a-ccino Foot Cream to nourish tired feet. Indulge in the rich Vanilla Vibes BodyButter for deep hydration and a luxurious scent. Finish off with the refreshing Vanilla Vibes Body Mist, perfect for an all-day sweet aroma. Experience the joy of self-care with these Plum favorites, designed to leave you feeling pampered and radiant!</p> <p><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"><br></span></b></span></p><p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span data-state="closed"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><span class="flex h-[30px] w-[30px] items-center justify-center"></span></b></span></b></b></p> <p><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"><b class="rounded-lg text-token-text-secondary hover:bg-token-main-surface-secondary"> <span data-state="closed"><b class="cursor-pointer rounded-md px-1 text-token-text-secondary h-[30px] hover:bg-token-main-surface-secondary"></b></span></b></b></b></p> <p><br></p> </b><p></p> [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum ) [1450] => Array ( [product_id] => 1450 [product] => Age Specialist Bright Years Serum - 30ml [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLBY0030FSE1147 [hsn_code] => 3304 [status] => A [list_price] => 1575.00 [amount] => 3 [weight] => 30.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [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] => 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] => 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] => activity [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] => 1496.250000 [short_description] => Expiry Date: 01-07-2025 [full_description] => <p>This quick absorbing, anti-ageing, ultra-hydrating serum makes your skin feel as good as new. The specially isolated sesame protein in this product is proven to help make skin look taut and visibly fuller. Argan oil, plant betaine and vitamin e concentrates provide deep hydration to the skin and keep the dark circles at bay by smoothing out your wrinkles. Hyaluronic acid in this product maintains your skin's hydration levels so it doesn't feel dull, dry and dehydrated. Suitable for dry, very dry skin type on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free, paraben free, sulphate-free and mineral oil free.</p> <p><br /></p> <p><br /></p> [category_ids] => Array ( [0] => 459 [1] => 493 [2] => 2706 ) [position] => [seo_name] => age-specialist-bright-years-serum-30-ml [seo_path] => 2685/2705/2706 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2706 [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] => Plum [ratting_count] => 5 ) [1421] => Array ( [product_id] => 1421 [product] => Plum Green Tea Renewed Clarity Night Gel [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 704 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => PLGT0050NMT0522 [hsn_code] => 3304 [status] => A [list_price] => 575.00 [amount] => 4 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1614670072 [updated_timestamp] => 1750266880 [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] => 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] => activity [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] => 546.000000 [short_description] => [full_description] => <p>This non-greasy product, rich in antioxidant green tea extracts helps in clearing out acne and acne marks and leaves behind brighter, glowing skin. Argan oil extracts in this product provide balanced hydration and helps your skin retain its moisture overnight. It is 100% vegan and recyclable. Suitable for oily, acne-prone skin on both, men and women in all season, this product is FDA approved, SLS free, cruelty-free and paraben free.</p> <p><br /></p> [category_ids] => Array ( [0] => 2815 [1] => 459 ) [position] => [seo_name] => green-tea-night-gel-50-ml [seo_path] => 2577/459 [average_rating] => 4.90 [reviews_count] => 10 [main_category] => 459 [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 ( [708] => Array ( [video_id] => 708 [video_type] => C [company_id] => 13 [usergroup_ids] => 0 [position] => 0 [timestamp] => 1682879400 [status] => A [user_id] => 146299 [extra_params] => [community_video_id] => 733 [community_url] => https://www.kindlife.in/summer-beauty-essentials [community_thumbnail] => https://cdn02.kindlife.in/images/videos/thumb/733/2dd6fc782e4559b78775d8f42d1a6ab7.jpg [community_video_url] => https://cdn02.kindlife.in/images/videos/thumb/733/7b02f84e9d78f877fbaa06b68cebedf8.mp4 [community_last_sync_timestamp] => 1713162242 [lang_code] => en [youtube_id] => [video] => Summer Beauty Essentials? [description] => <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@night"><a id="product_1421" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=1421" data-value="1421">Plum Green Tea Renewed Clarity NightGel</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@body"><a id="product_22355" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=22355" data-value="22355">Body Exfoliating & Pigmentation Removal cream - 100gm</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@ginseng"><a id="product_13927" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13927" data-value="13927">Ginseng Essence Water - 150ml</a></span> <span class="atwho-inserted" contenteditable="false" data-atwho-at-query="@silky"><a id="product_13802" class="pTagD" href="https://www.kindlife.in/index.php?dispatch=products.view&product_id=13802" data-value="13802">Sun Project Silky Calming Sun Stick SPF50+ PA++++(14gm)</a></span> and vanilla vibes edp✨ [short_description] => [privacy] => 1 [like_count] => 0 [dislike_count] => 0 [comment_count] => 0 [meta_keywords] => [meta_description] => [page_title] => [tagged_brands] => [category_id] => 7 [link_type] => M [preview] => Array ( [default_icon] => 1 ) ) ) [cp_has_video] => 1 [brand_name] => Plum [ratting_count] => 10 ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 682 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 0 )
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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 682 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 1420 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 0 )
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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 1420 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 35763 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 0 )
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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 35763 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 1450 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 0 )
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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 1450 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 1421 [include_child_variations] => 1 [group_child_variations] => [runtime_company_id] => 0 )
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 ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 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 products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) AND ?:product_required_products.product_id = 1421 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Cannot create references to/from string offsets
app/Tygh/Registry.php, line: 221
File: | app/Tygh/Registry.php |
Line: | 89 |
Function: | _varByKey |
File: | app/addons/seo/Tygh/SeoCache.php |
Line: | 111 |
Function: | set |
File: | app/addons/seo/Tygh/SeoCache.php |
Line: | 49 |
Function: | setStatic |
File: | app/addons/seo/func.php |
Line: | 1329 |
Function: | set |
File: | app/addons/seo/func.php |
Line: | 1563 |
Function: | fn_seo_get_name |
File: | app/functions/fn.control.php |
Line: | 123 |
Function: | fn_seo_url_post |
File: | app/functions/fn.common.php |
Line: | 3921 |
Function: | fn_set_hook |
File: | app/Tygh/BlockManager/Container.php |
Line: | 496 |
Function: | fn_url |
File: | app/Tygh/BlockManager/Container.php |
Line: | 517 |
Function: | getConfigurationUrl |
File: | app/Tygh/BlockManager/Container.php |
Line: | 120 |
Function: | addBlockManagerProperties |
File: | app/Tygh/BlockManager/RenderManager.php |
Line: | 127 |
Function: | getListByArea |
File: | app/functions/smarty_plugins/function.render_location.php |
Line: | 50 |
Function: | __construct |
File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
Line: | 191 |
Function: | smarty_function_render_location |
File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
Line: | 188 |
Function: | content_689464c1dbc0b1_26812820 |
File: | app/Tygh/SmartyEngine/Core.php |
Line: | 81 |
Function: | fetch |
File: | app/functions/fn.control.php |
Line: | 636 |
Function: | fetch |
File: | index.php |
Line: | 39 |
Function: | fn_dispatch |