Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [items_per_page] => 12
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2815
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2815
    [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 (2815) 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, 12

before end of oxn

Array
(
    [3564] => Array
        (
            [product_id] => 3564
            [product] => Midnight Blue Calming Cream - 60ml
            [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] => 8809572890291
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2100.00
            [amount] => 2
            [weight] => 60.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1628586838
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1260.000000
            [short_description] => <p>Provides soothing relief and hydration.</p>
            [full_description] => <p>This gentle cream instantly calms and soothes sensitive skin, protecting it from stress and irritation. Enriched with guaiazulene from chamomile oil, it effectively reduces inflammation and regenerates skin cells. Ideal for sunburns, eczema, and ulcerative conditions, it hydrates, relieves redness, and prevents scarring. The blue cream also works as a spot treatment for acne and is excellent after pore care, laser treatments, prolonged sun exposure, and shaving. Its lightweight texture is perfect for oily and acne-prone skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => midnight-blue-calming-cream-60ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 4.74
            [reviews_count] => 31
            [main_category] => 2815
            [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] => Klairs
            [ratting_count] => 31
        )

    [28570] => Array
        (
            [product_id] => 28570
            [product] => The Retinol 0.1 Cream - 20ml
            [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] => CR077
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2050.00
            [amount] => 35
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681555720
            [updated_timestamp] => 1750427211
            [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] => 
            [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] => 1230.000000
            [short_description] => Prevent And Correct Early Signs Of Aging
            [full_description] => <p>The Cosrx Retinol 0.1 Cream is a low-irritation solution created with the ideal ratio of key ingredients for first-time retinol users, just starting to notice the appearance of fine lines caused by dry skin. Using pure retinol it is the perfect choice to prevent and correct premature signs of ageing before they set in completely. <br /> Retinol, which is a form of vitamin A, helps increase the rate at which your skin produces new cells, that otherwise slows down with age. The Retinol 0.1 Cream resurfaces your skin to reduce skin texture and improve uneven skin tone and wrinkles. Its non-comedogenic formula means it can also be use to help acne prone skin to keep skin blemish free!<br /><br /> The cream also uses Panthenol to soothe and moisturise skin, Adenosine to help boost skin elasticity and Super Vitamin E (Tocotreniol) for added antioxidant benefits.\</p>
            [category_ids] => Array
                (
                    [0] => 2368
                    [1] => 2815
                )

            [position] => 0
            [seo_name] => the-retinol-0.1-cream-20ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => COSRX
            [ratting_count] => 1
        )

    [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] => 0
            [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&amp;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&amp;product_id=22355" data-value="22355">Body Exfoliating &amp; 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&amp;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&amp;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
        )

    [7788] => Array
        (
            [product_id] => 7788
            [product] => 2% Retinoid Anti Aging Night Cream - 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] => 8906128100023
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646310667
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 629.100000
            [short_description] => <p>Gives you a glowing and youthful skin.</p>
            [full_description] => <p>Turn back the clock on aging and give your skin a youthful vibrancy with this gentle, safe & effective 2% Retinoid serum.2% Granactive Retinoid is dermatologically tested to offer less irritation & multi-fold better effect than other retinol and retinoid derivatives<br />Boosts cell turnover & stimulates collagen production to erase fine lines and wrinkles, revealing radiant glowy skin<br />Contains top quality Granactive Retinoid sourced from Grant Industries, USA, A leading global supplier in skincare</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><strong>How to use </strong>: - 1. Take a pea-sized amount of serum on your fingertips with a dropper. Dab the product onto your face and neck; For optimal results, allow 2-3 minutes for absorption before applying your moisturiser.<br />2. To see noticeable effects from Retinoid, use it consistently for at least 2-3 months, starting 2-3 times per week & gradually increasing frequency to daily.<br />Due to the high concentration of retinoid in the product, use this serum only in the PM to limit photosensitivity and irritation. Always apply a broad-spectrum sunscreen during the day when using this product.</p>
<p>Orders will be dispatched in 5-6 days.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => 2-retinoid-anti-aging-night-cream-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Minimalist
            [ratting_count] => 2
        )

    [8013] => Array
        (
            [product_id] => 8013
            [product] => Moon Struck Night Cream - 60 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 103
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => pureByPriyankaProduct00036
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 25
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646471044
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1140.000000
            [short_description] => Get yourself the perfectly hydrated & glowing skin.
            [full_description] => <p>Our Moon Struck Night Cream has been specially designed to heal and rejuvenate your skin while you sleep. With a host of amazing ingredients, such as saffron, niacinamide & shea butter, it will nourish, replenish & heal your skin while you catch your forty winks! Get plump, soft & supple skin after waking up! Product Benefits Brightens your skin & gives you a beautiful glow Strengthens your skin barrier Reduces the appearance of enlarged pores.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => moon-struck-night-cream-60-gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Pure by Priyanka
        )

    [12264] => Array
        (
            [product_id] => 12264
            [product] => Multi-Corrective Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 34
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => ORC 50
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1170.00
            [amount] => 50
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655205168
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1111.500000
            [short_description] => Target Wrinkles, Age Spots, & Pigmentation
            [full_description] => <p>A rich & powerful formula visibly improves 5 top signs of stress & environment affected ageing skin - the appearance of lines and wrinkles, lack of firmness, loss of radiance, discolouration & age spots and tired looking skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => multi-corrective-night-cream-50gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Detoxie
        )

    [12385] => Array
        (
            [product_id] => 12385
            [product] => Glow I Pigmentation Gel - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 292
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => glow_30g
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 47
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655717336
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 664.050000
            [short_description] => Helps to reduce skin pigmentation
            [full_description] => <p>A topical gel with Frankincense, Tea tree, and Juniper amongst others clear blemishes and evens out skin texture. The cucumber gel base works to repair and improve the overall appearance of skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => glow-i-pigmentation-gel-30gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Secret Alchemist 
        )

    [12620] => Array
        (
            [product_id] => 12620
            [product] => Restorative Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 280
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => DTFW_CRM_NGT_50G
            [hsn_code] => 3304
            [status] => A
            [list_price] => 599.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655897555
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 509.150000
            [short_description] => Restorative night cream
            [full_description] => <p>Infused with the goodness of oiless'city and lecigel actives, this night cream helps to improve the control of oil on the skin caused by the environment and hydrates your skin. The actives in the cream act as a detoxifier and pulls out excess oil and environmental impurities for clear, calm, and soothing skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                    [1] => 2144
                )

            [position] => 0
            [seo_name] => restorative-night-cream-50gm
            [seo_path] => 2594/2144
            [main_category] => 2144
            [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] => Dermatouch
        )

    [13899] => Array
        (
            [product_id] => 13899
            [product] => Collagen 100 - 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] => #8809663751593
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1699.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1189.300000
            [short_description] => Improves skin elasticity and deliver deep hydration
            [full_description] => <p>90% highly concentrated collagen ampoule makes your skin tight, supple and moist again. It has magical skin-plumping capabilities because of collagen and makes the skin lively and healthy. Improves skin elasticity and deliver deep hydration. This serum lifts facial contours, plumps skin and smoothes the appearance of fine lines and improves your skin texture and elasticity.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => collagen-100-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [13902] => Array
        (
            [product_id] => 13902
            [product] => Peptide 500 - 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] => #8809663752149
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2350.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1645.000000
            [short_description] => Helps with early signs of aging
            [full_description] => <p>Powered by a rejuvenating 50% highly concentrated solution, a drop of peptide 500 tones up your skin for a more healthy complexion. Absorbs into the skin well and gets rid of tired-looking skin. Adenosine as an ingredient aids in wrinkle-care, gets smooth-looking skin and turns skin texture supple. A youthful solution of peptides, hyaluronic acid and beta-glucan works instantly to plump and hydrate the skin</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => peptide-500-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [14250] => Array
        (
            [product_id] => 14250
            [product] => Foobetik Cream - 100gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 302
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => FDFOOBETIKCREAM100ML36257
            [hsn_code] => 3304
            [status] => A
            [list_price] => 600.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658226727
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 510.000000
            [short_description] => Keeps feet moisturised and smooth
            [full_description] => <p>Foobetik cream is a promising foot care formulation for diabetics which keeps the feet soft and smoother for a longer time. The advanced moisturizers, like lactic acid, urea and shea butter smooth the dry and scaly skin of the feet and heels. Provides long duration moisturization and prevents fungal infections, it soothes the burning & discomforted feeling and improves circulation in feet.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => foobetik-cream-100g
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Fixderma	
            [ratting_count] => 2
        )

    [15974] => Array
        (
            [product_id] => 15974
            [product] => Papaya & Peptide Night Cream For Younger Looking & Smooth Skin - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 334
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => PAPAYAPNC
            [hsn_code] => 3304
            [status] => A
            [list_price] => 650.00
            [amount] => 83
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1660647951
            [updated_timestamp] => 1750266976
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 650.000000
            [short_description] => <p>Regenerates your skin cells overnight</p>
            [full_description] => <p>Do you know that skin manifold its healing process overnight? Using the right night cream is the key! TNW introduces you to the Papaya & Peptide Night Cream that helps to improve the skins overall texture by boosting collagen production. With active ingredients like papaya, peptide, hyaluronic acid, and panthenol, this non-sticky night cream helps to reduce the visibility of fine lines, wrinkles, pigmentation, and darkness while deeply moisturizing the skin. Besides, it calms irritation and makes skin super soft & hydrated. Suitable for all skin types, this night cream work wonders on your skin. To witness the effective results, you must use this night cream regularly.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => papaya-and-peptide-night-cream-for-younger-looking-and-smooth-skin-50g
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => TNW - The Natural Wash
        )

)

Array
(
    [3564] => Array
        (
            [product_id] => 3564
            [product] => Midnight Blue Calming Cream - 60ml
            [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] => 8809572890291
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2100.00
            [amount] => 2
            [weight] => 60.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1628586838
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1260.000000
            [short_description] => <p>Provides soothing relief and hydration.</p>
            [full_description] => <p>This gentle cream instantly calms and soothes sensitive skin, protecting it from stress and irritation. Enriched with guaiazulene from chamomile oil, it effectively reduces inflammation and regenerates skin cells. Ideal for sunburns, eczema, and ulcerative conditions, it hydrates, relieves redness, and prevents scarring. The blue cream also works as a spot treatment for acne and is excellent after pore care, laser treatments, prolonged sun exposure, and shaving. Its lightweight texture is perfect for oily and acne-prone skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => midnight-blue-calming-cream-60ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 4.74
            [reviews_count] => 31
            [main_category] => 2815
            [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] => Klairs
            [ratting_count] => 31
        )

    [28570] => Array
        (
            [product_id] => 28570
            [product] => The Retinol 0.1 Cream - 20ml
            [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] => CR077
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2050.00
            [amount] => 35
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681555720
            [updated_timestamp] => 1750427211
            [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] => 
            [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] => 1230.000000
            [short_description] => Prevent And Correct Early Signs Of Aging
            [full_description] => <p>The Cosrx Retinol 0.1 Cream is a low-irritation solution created with the ideal ratio of key ingredients for first-time retinol users, just starting to notice the appearance of fine lines caused by dry skin. Using pure retinol it is the perfect choice to prevent and correct premature signs of ageing before they set in completely. <br /> Retinol, which is a form of vitamin A, helps increase the rate at which your skin produces new cells, that otherwise slows down with age. The Retinol 0.1 Cream resurfaces your skin to reduce skin texture and improve uneven skin tone and wrinkles. Its non-comedogenic formula means it can also be use to help acne prone skin to keep skin blemish free!<br /><br /> The cream also uses Panthenol to soothe and moisturise skin, Adenosine to help boost skin elasticity and Super Vitamin E (Tocotreniol) for added antioxidant benefits.\</p>
            [category_ids] => Array
                (
                    [0] => 2368
                    [1] => 2815
                )

            [position] => 0
            [seo_name] => the-retinol-0.1-cream-20ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => COSRX
            [ratting_count] => 1
        )

    [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] => 0
            [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&amp;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&amp;product_id=22355" data-value="22355">Body Exfoliating &amp; 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&amp;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&amp;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
        )

    [7788] => Array
        (
            [product_id] => 7788
            [product] => 2% Retinoid Anti Aging Night Cream - 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] => 8906128100023
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646310667
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 629.100000
            [short_description] => <p>Gives you a glowing and youthful skin.</p>
            [full_description] => <p>Turn back the clock on aging and give your skin a youthful vibrancy with this gentle, safe & effective 2% Retinoid serum.2% Granactive Retinoid is dermatologically tested to offer less irritation & multi-fold better effect than other retinol and retinoid derivatives<br />Boosts cell turnover & stimulates collagen production to erase fine lines and wrinkles, revealing radiant glowy skin<br />Contains top quality Granactive Retinoid sourced from Grant Industries, USA, A leading global supplier in skincare</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><strong>How to use </strong>: - 1. Take a pea-sized amount of serum on your fingertips with a dropper. Dab the product onto your face and neck; For optimal results, allow 2-3 minutes for absorption before applying your moisturiser.<br />2. To see noticeable effects from Retinoid, use it consistently for at least 2-3 months, starting 2-3 times per week & gradually increasing frequency to daily.<br />Due to the high concentration of retinoid in the product, use this serum only in the PM to limit photosensitivity and irritation. Always apply a broad-spectrum sunscreen during the day when using this product.</p>
<p>Orders will be dispatched in 5-6 days.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => 2-retinoid-anti-aging-night-cream-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Minimalist
            [ratting_count] => 2
        )

    [8013] => Array
        (
            [product_id] => 8013
            [product] => Moon Struck Night Cream - 60 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 103
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => pureByPriyankaProduct00036
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 25
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646471044
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1140.000000
            [short_description] => Get yourself the perfectly hydrated & glowing skin.
            [full_description] => <p>Our Moon Struck Night Cream has been specially designed to heal and rejuvenate your skin while you sleep. With a host of amazing ingredients, such as saffron, niacinamide & shea butter, it will nourish, replenish & heal your skin while you catch your forty winks! Get plump, soft & supple skin after waking up! Product Benefits Brightens your skin & gives you a beautiful glow Strengthens your skin barrier Reduces the appearance of enlarged pores.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => moon-struck-night-cream-60-gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Pure by Priyanka
        )

    [12264] => Array
        (
            [product_id] => 12264
            [product] => Multi-Corrective Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 34
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => ORC 50
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1170.00
            [amount] => 50
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655205168
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1111.500000
            [short_description] => Target Wrinkles, Age Spots, & Pigmentation
            [full_description] => <p>A rich & powerful formula visibly improves 5 top signs of stress & environment affected ageing skin - the appearance of lines and wrinkles, lack of firmness, loss of radiance, discolouration & age spots and tired looking skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => multi-corrective-night-cream-50gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Detoxie
        )

    [12385] => Array
        (
            [product_id] => 12385
            [product] => Glow I Pigmentation Gel - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 292
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => glow_30g
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 47
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655717336
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 664.050000
            [short_description] => Helps to reduce skin pigmentation
            [full_description] => <p>A topical gel with Frankincense, Tea tree, and Juniper amongst others clear blemishes and evens out skin texture. The cucumber gel base works to repair and improve the overall appearance of skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => glow-i-pigmentation-gel-30gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Secret Alchemist 
        )

    [12620] => Array
        (
            [product_id] => 12620
            [product] => Restorative Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 280
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => DTFW_CRM_NGT_50G
            [hsn_code] => 3304
            [status] => A
            [list_price] => 599.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655897555
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 509.150000
            [short_description] => Restorative night cream
            [full_description] => <p>Infused with the goodness of oiless'city and lecigel actives, this night cream helps to improve the control of oil on the skin caused by the environment and hydrates your skin. The actives in the cream act as a detoxifier and pulls out excess oil and environmental impurities for clear, calm, and soothing skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                    [1] => 2144
                )

            [position] => 0
            [seo_name] => restorative-night-cream-50gm
            [seo_path] => 2594/2144
            [main_category] => 2144
            [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] => Dermatouch
        )

    [13899] => Array
        (
            [product_id] => 13899
            [product] => Collagen 100 - 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] => #8809663751593
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1699.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1189.300000
            [short_description] => Improves skin elasticity and deliver deep hydration
            [full_description] => <p>90% highly concentrated collagen ampoule makes your skin tight, supple and moist again. It has magical skin-plumping capabilities because of collagen and makes the skin lively and healthy. Improves skin elasticity and deliver deep hydration. This serum lifts facial contours, plumps skin and smoothes the appearance of fine lines and improves your skin texture and elasticity.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => collagen-100-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [13902] => Array
        (
            [product_id] => 13902
            [product] => Peptide 500 - 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] => #8809663752149
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2350.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1645.000000
            [short_description] => Helps with early signs of aging
            [full_description] => <p>Powered by a rejuvenating 50% highly concentrated solution, a drop of peptide 500 tones up your skin for a more healthy complexion. Absorbs into the skin well and gets rid of tired-looking skin. Adenosine as an ingredient aids in wrinkle-care, gets smooth-looking skin and turns skin texture supple. A youthful solution of peptides, hyaluronic acid and beta-glucan works instantly to plump and hydrate the skin</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => peptide-500-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [14250] => Array
        (
            [product_id] => 14250
            [product] => Foobetik Cream - 100gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 302
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => FDFOOBETIKCREAM100ML36257
            [hsn_code] => 3304
            [status] => A
            [list_price] => 600.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658226727
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 510.000000
            [short_description] => Keeps feet moisturised and smooth
            [full_description] => <p>Foobetik cream is a promising foot care formulation for diabetics which keeps the feet soft and smoother for a longer time. The advanced moisturizers, like lactic acid, urea and shea butter smooth the dry and scaly skin of the feet and heels. Provides long duration moisturization and prevents fungal infections, it soothes the burning & discomforted feeling and improves circulation in feet.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => foobetik-cream-100g
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Fixderma	
            [ratting_count] => 2
        )

    [15974] => Array
        (
            [product_id] => 15974
            [product] => Papaya & Peptide Night Cream For Younger Looking & Smooth Skin - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 334
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => PAPAYAPNC
            [hsn_code] => 3304
            [status] => A
            [list_price] => 650.00
            [amount] => 83
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1660647951
            [updated_timestamp] => 1750266976
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 650.000000
            [short_description] => <p>Regenerates your skin cells overnight</p>
            [full_description] => <p>Do you know that skin manifold its healing process overnight? Using the right night cream is the key! TNW introduces you to the Papaya & Peptide Night Cream that helps to improve the skins overall texture by boosting collagen production. With active ingredients like papaya, peptide, hyaluronic acid, and panthenol, this non-sticky night cream helps to reduce the visibility of fine lines, wrinkles, pigmentation, and darkness while deeply moisturizing the skin. Besides, it calms irritation and makes skin super soft & hydrated. Suitable for all skin types, this night cream work wonders on your skin. To witness the effective results, you must use this night cream regularly.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => papaya-and-peptide-night-cream-for-younger-looking-and-smooth-skin-50g
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => TNW - The Natural Wash
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [currency] => USD
    [items_per_page] => 12
    [sl] => en
    [dispatch] => categories.view
    [category_id] => 2815
    [save_view_results] => product_id
    [sort_by] => bestsellers
    [sort_order] => desc
    [cid] => 2815
    [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 (2815) 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, 12

before end of oxn

Array
(
    [3564] => Array
        (
            [product_id] => 3564
            [product] => Midnight Blue Calming Cream - 60ml
            [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] => 8809572890291
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2100.00
            [amount] => 2
            [weight] => 60.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1628586838
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1260.000000
            [short_description] => <p>Provides soothing relief and hydration.</p>
            [full_description] => <p>This gentle cream instantly calms and soothes sensitive skin, protecting it from stress and irritation. Enriched with guaiazulene from chamomile oil, it effectively reduces inflammation and regenerates skin cells. Ideal for sunburns, eczema, and ulcerative conditions, it hydrates, relieves redness, and prevents scarring. The blue cream also works as a spot treatment for acne and is excellent after pore care, laser treatments, prolonged sun exposure, and shaving. Its lightweight texture is perfect for oily and acne-prone skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => midnight-blue-calming-cream-60ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 4.74
            [reviews_count] => 31
            [main_category] => 2815
            [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] => Klairs
            [ratting_count] => 31
        )

    [28570] => Array
        (
            [product_id] => 28570
            [product] => The Retinol 0.1 Cream - 20ml
            [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] => CR077
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2050.00
            [amount] => 35
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681555720
            [updated_timestamp] => 1750427211
            [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] => 
            [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] => 1230.000000
            [short_description] => Prevent And Correct Early Signs Of Aging
            [full_description] => <p>The Cosrx Retinol 0.1 Cream is a low-irritation solution created with the ideal ratio of key ingredients for first-time retinol users, just starting to notice the appearance of fine lines caused by dry skin. Using pure retinol it is the perfect choice to prevent and correct premature signs of ageing before they set in completely. <br /> Retinol, which is a form of vitamin A, helps increase the rate at which your skin produces new cells, that otherwise slows down with age. The Retinol 0.1 Cream resurfaces your skin to reduce skin texture and improve uneven skin tone and wrinkles. Its non-comedogenic formula means it can also be use to help acne prone skin to keep skin blemish free!<br /><br /> The cream also uses Panthenol to soothe and moisturise skin, Adenosine to help boost skin elasticity and Super Vitamin E (Tocotreniol) for added antioxidant benefits.\</p>
            [category_ids] => Array
                (
                    [0] => 2368
                    [1] => 2815
                )

            [position] => 0
            [seo_name] => the-retinol-0.1-cream-20ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => COSRX
            [ratting_count] => 1
        )

    [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] => 0
            [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&amp;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&amp;product_id=22355" data-value="22355">Body Exfoliating &amp; 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&amp;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&amp;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
        )

    [7788] => Array
        (
            [product_id] => 7788
            [product] => 2% Retinoid Anti Aging Night Cream - 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] => 8906128100023
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646310667
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 629.100000
            [short_description] => <p>Gives you a glowing and youthful skin.</p>
            [full_description] => <p>Turn back the clock on aging and give your skin a youthful vibrancy with this gentle, safe & effective 2% Retinoid serum.2% Granactive Retinoid is dermatologically tested to offer less irritation & multi-fold better effect than other retinol and retinoid derivatives<br />Boosts cell turnover & stimulates collagen production to erase fine lines and wrinkles, revealing radiant glowy skin<br />Contains top quality Granactive Retinoid sourced from Grant Industries, USA, A leading global supplier in skincare</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><strong>How to use </strong>: - 1. Take a pea-sized amount of serum on your fingertips with a dropper. Dab the product onto your face and neck; For optimal results, allow 2-3 minutes for absorption before applying your moisturiser.<br />2. To see noticeable effects from Retinoid, use it consistently for at least 2-3 months, starting 2-3 times per week & gradually increasing frequency to daily.<br />Due to the high concentration of retinoid in the product, use this serum only in the PM to limit photosensitivity and irritation. Always apply a broad-spectrum sunscreen during the day when using this product.</p>
<p>Orders will be dispatched in 5-6 days.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => 2-retinoid-anti-aging-night-cream-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Minimalist
            [ratting_count] => 2
        )

    [8013] => Array
        (
            [product_id] => 8013
            [product] => Moon Struck Night Cream - 60 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 103
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => pureByPriyankaProduct00036
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 25
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646471044
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1140.000000
            [short_description] => Get yourself the perfectly hydrated & glowing skin.
            [full_description] => <p>Our Moon Struck Night Cream has been specially designed to heal and rejuvenate your skin while you sleep. With a host of amazing ingredients, such as saffron, niacinamide & shea butter, it will nourish, replenish & heal your skin while you catch your forty winks! Get plump, soft & supple skin after waking up! Product Benefits Brightens your skin & gives you a beautiful glow Strengthens your skin barrier Reduces the appearance of enlarged pores.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => moon-struck-night-cream-60-gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Pure by Priyanka
        )

    [12264] => Array
        (
            [product_id] => 12264
            [product] => Multi-Corrective Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 34
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => ORC 50
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1170.00
            [amount] => 50
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655205168
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1111.500000
            [short_description] => Target Wrinkles, Age Spots, & Pigmentation
            [full_description] => <p>A rich & powerful formula visibly improves 5 top signs of stress & environment affected ageing skin - the appearance of lines and wrinkles, lack of firmness, loss of radiance, discolouration & age spots and tired looking skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => multi-corrective-night-cream-50gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Detoxie
        )

    [12385] => Array
        (
            [product_id] => 12385
            [product] => Glow I Pigmentation Gel - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 292
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => glow_30g
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 47
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655717336
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 664.050000
            [short_description] => Helps to reduce skin pigmentation
            [full_description] => <p>A topical gel with Frankincense, Tea tree, and Juniper amongst others clear blemishes and evens out skin texture. The cucumber gel base works to repair and improve the overall appearance of skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => glow-i-pigmentation-gel-30gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Secret Alchemist 
        )

    [12620] => Array
        (
            [product_id] => 12620
            [product] => Restorative Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 280
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => DTFW_CRM_NGT_50G
            [hsn_code] => 3304
            [status] => A
            [list_price] => 599.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655897555
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 509.150000
            [short_description] => Restorative night cream
            [full_description] => <p>Infused with the goodness of oiless'city and lecigel actives, this night cream helps to improve the control of oil on the skin caused by the environment and hydrates your skin. The actives in the cream act as a detoxifier and pulls out excess oil and environmental impurities for clear, calm, and soothing skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                    [1] => 2144
                )

            [position] => 0
            [seo_name] => restorative-night-cream-50gm
            [seo_path] => 2594/2144
            [main_category] => 2144
            [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] => Dermatouch
        )

    [13899] => Array
        (
            [product_id] => 13899
            [product] => Collagen 100 - 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] => #8809663751593
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1699.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1189.300000
            [short_description] => Improves skin elasticity and deliver deep hydration
            [full_description] => <p>90% highly concentrated collagen ampoule makes your skin tight, supple and moist again. It has magical skin-plumping capabilities because of collagen and makes the skin lively and healthy. Improves skin elasticity and deliver deep hydration. This serum lifts facial contours, plumps skin and smoothes the appearance of fine lines and improves your skin texture and elasticity.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => collagen-100-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [13902] => Array
        (
            [product_id] => 13902
            [product] => Peptide 500 - 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] => #8809663752149
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2350.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1645.000000
            [short_description] => Helps with early signs of aging
            [full_description] => <p>Powered by a rejuvenating 50% highly concentrated solution, a drop of peptide 500 tones up your skin for a more healthy complexion. Absorbs into the skin well and gets rid of tired-looking skin. Adenosine as an ingredient aids in wrinkle-care, gets smooth-looking skin and turns skin texture supple. A youthful solution of peptides, hyaluronic acid and beta-glucan works instantly to plump and hydrate the skin</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => peptide-500-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [14250] => Array
        (
            [product_id] => 14250
            [product] => Foobetik Cream - 100gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 302
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => FDFOOBETIKCREAM100ML36257
            [hsn_code] => 3304
            [status] => A
            [list_price] => 600.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658226727
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 510.000000
            [short_description] => Keeps feet moisturised and smooth
            [full_description] => <p>Foobetik cream is a promising foot care formulation for diabetics which keeps the feet soft and smoother for a longer time. The advanced moisturizers, like lactic acid, urea and shea butter smooth the dry and scaly skin of the feet and heels. Provides long duration moisturization and prevents fungal infections, it soothes the burning & discomforted feeling and improves circulation in feet.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => foobetik-cream-100g
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Fixderma	
            [ratting_count] => 2
        )

    [15974] => Array
        (
            [product_id] => 15974
            [product] => Papaya & Peptide Night Cream For Younger Looking & Smooth Skin - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 334
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => PAPAYAPNC
            [hsn_code] => 3304
            [status] => A
            [list_price] => 650.00
            [amount] => 83
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1660647951
            [updated_timestamp] => 1750266976
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 650.000000
            [short_description] => <p>Regenerates your skin cells overnight</p>
            [full_description] => <p>Do you know that skin manifold its healing process overnight? Using the right night cream is the key! TNW introduces you to the Papaya & Peptide Night Cream that helps to improve the skins overall texture by boosting collagen production. With active ingredients like papaya, peptide, hyaluronic acid, and panthenol, this non-sticky night cream helps to reduce the visibility of fine lines, wrinkles, pigmentation, and darkness while deeply moisturizing the skin. Besides, it calms irritation and makes skin super soft & hydrated. Suitable for all skin types, this night cream work wonders on your skin. To witness the effective results, you must use this night cream regularly.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => papaya-and-peptide-night-cream-for-younger-looking-and-smooth-skin-50g
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => TNW - The Natural Wash
        )

)

Array
(
    [3564] => Array
        (
            [product_id] => 3564
            [product] => Midnight Blue Calming Cream - 60ml
            [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] => 8809572890291
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2100.00
            [amount] => 2
            [weight] => 60.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1628586838
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1260.000000
            [short_description] => <p>Provides soothing relief and hydration.</p>
            [full_description] => <p>This gentle cream instantly calms and soothes sensitive skin, protecting it from stress and irritation. Enriched with guaiazulene from chamomile oil, it effectively reduces inflammation and regenerates skin cells. Ideal for sunburns, eczema, and ulcerative conditions, it hydrates, relieves redness, and prevents scarring. The blue cream also works as a spot treatment for acne and is excellent after pore care, laser treatments, prolonged sun exposure, and shaving. Its lightweight texture is perfect for oily and acne-prone skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => midnight-blue-calming-cream-60ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 4.74
            [reviews_count] => 31
            [main_category] => 2815
            [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] => Klairs
            [ratting_count] => 31
        )

    [28570] => Array
        (
            [product_id] => 28570
            [product] => The Retinol 0.1 Cream - 20ml
            [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] => CR077
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2050.00
            [amount] => 35
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1681555720
            [updated_timestamp] => 1750427211
            [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] => 
            [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] => 1230.000000
            [short_description] => Prevent And Correct Early Signs Of Aging
            [full_description] => <p>The Cosrx Retinol 0.1 Cream is a low-irritation solution created with the ideal ratio of key ingredients for first-time retinol users, just starting to notice the appearance of fine lines caused by dry skin. Using pure retinol it is the perfect choice to prevent and correct premature signs of ageing before they set in completely. <br /> Retinol, which is a form of vitamin A, helps increase the rate at which your skin produces new cells, that otherwise slows down with age. The Retinol 0.1 Cream resurfaces your skin to reduce skin texture and improve uneven skin tone and wrinkles. Its non-comedogenic formula means it can also be use to help acne prone skin to keep skin blemish free!<br /><br /> The cream also uses Panthenol to soothe and moisturise skin, Adenosine to help boost skin elasticity and Super Vitamin E (Tocotreniol) for added antioxidant benefits.\</p>
            [category_ids] => Array
                (
                    [0] => 2368
                    [1] => 2815
                )

            [position] => 0
            [seo_name] => the-retinol-0.1-cream-20ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => COSRX
            [ratting_count] => 1
        )

    [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] => 0
            [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&amp;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&amp;product_id=22355" data-value="22355">Body Exfoliating &amp; 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&amp;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&amp;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
        )

    [7788] => Array
        (
            [product_id] => 7788
            [product] => 2% Retinoid Anti Aging Night Cream - 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] => 8906128100023
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 4
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646310667
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 629.100000
            [short_description] => <p>Gives you a glowing and youthful skin.</p>
            [full_description] => <p>Turn back the clock on aging and give your skin a youthful vibrancy with this gentle, safe & effective 2% Retinoid serum.2% Granactive Retinoid is dermatologically tested to offer less irritation & multi-fold better effect than other retinol and retinoid derivatives<br />Boosts cell turnover & stimulates collagen production to erase fine lines and wrinkles, revealing radiant glowy skin<br />Contains top quality Granactive Retinoid sourced from Grant Industries, USA, A leading global supplier in skincare</p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><br /></p>
<p><strong>How to use </strong>: - 1. Take a pea-sized amount of serum on your fingertips with a dropper. Dab the product onto your face and neck; For optimal results, allow 2-3 minutes for absorption before applying your moisturiser.<br />2. To see noticeable effects from Retinoid, use it consistently for at least 2-3 months, starting 2-3 times per week & gradually increasing frequency to daily.<br />Due to the high concentration of retinoid in the product, use this serum only in the PM to limit photosensitivity and irritation. Always apply a broad-spectrum sunscreen during the day when using this product.</p>
<p>Orders will be dispatched in 5-6 days.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => 2-retinoid-anti-aging-night-cream-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Minimalist
            [ratting_count] => 2
        )

    [8013] => Array
        (
            [product_id] => 8013
            [product] => Moon Struck Night Cream - 60 gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 103
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => pureByPriyankaProduct00036
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1200.00
            [amount] => 25
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1646471044
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1140.000000
            [short_description] => Get yourself the perfectly hydrated & glowing skin.
            [full_description] => <p>Our Moon Struck Night Cream has been specially designed to heal and rejuvenate your skin while you sleep. With a host of amazing ingredients, such as saffron, niacinamide & shea butter, it will nourish, replenish & heal your skin while you catch your forty winks! Get plump, soft & supple skin after waking up! Product Benefits Brightens your skin & gives you a beautiful glow Strengthens your skin barrier Reduces the appearance of enlarged pores.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => moon-struck-night-cream-60-gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Pure by Priyanka
        )

    [12264] => Array
        (
            [product_id] => 12264
            [product] => Multi-Corrective Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 34
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => ORC 50
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1170.00
            [amount] => 50
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655205168
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1111.500000
            [short_description] => Target Wrinkles, Age Spots, & Pigmentation
            [full_description] => <p>A rich & powerful formula visibly improves 5 top signs of stress & environment affected ageing skin - the appearance of lines and wrinkles, lack of firmness, loss of radiance, discolouration & age spots and tired looking skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => multi-corrective-night-cream-50gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Detoxie
        )

    [12385] => Array
        (
            [product_id] => 12385
            [product] => Glow I Pigmentation Gel - 30gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 292
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => glow_30g
            [hsn_code] => 3304
            [status] => A
            [list_price] => 699.00
            [amount] => 47
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655717336
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 664.050000
            [short_description] => Helps to reduce skin pigmentation
            [full_description] => <p>A topical gel with Frankincense, Tea tree, and Juniper amongst others clear blemishes and evens out skin texture. The cucumber gel base works to repair and improve the overall appearance of skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => glow-i-pigmentation-gel-30gm
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => Secret Alchemist 
        )

    [12620] => Array
        (
            [product_id] => 12620
            [product] => Restorative Night Cream - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 280
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => DTFW_CRM_NGT_50G
            [hsn_code] => 3304
            [status] => A
            [list_price] => 599.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1655897555
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => N
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 509.150000
            [short_description] => Restorative night cream
            [full_description] => <p>Infused with the goodness of oiless'city and lecigel actives, this night cream helps to improve the control of oil on the skin caused by the environment and hydrates your skin. The actives in the cream act as a detoxifier and pulls out excess oil and environmental impurities for clear, calm, and soothing skin.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                    [1] => 2144
                )

            [position] => 0
            [seo_name] => restorative-night-cream-50gm
            [seo_path] => 2594/2144
            [main_category] => 2144
            [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] => Dermatouch
        )

    [13899] => Array
        (
            [product_id] => 13899
            [product] => Collagen 100 - 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] => #8809663751593
            [hsn_code] => 3304
            [status] => A
            [list_price] => 1699.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1189.300000
            [short_description] => Improves skin elasticity and deliver deep hydration
            [full_description] => <p>90% highly concentrated collagen ampoule makes your skin tight, supple and moist again. It has magical skin-plumping capabilities because of collagen and makes the skin lively and healthy. Improves skin elasticity and deliver deep hydration. This serum lifts facial contours, plumps skin and smoothes the appearance of fine lines and improves your skin texture and elasticity.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => collagen-100-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [13902] => Array
        (
            [product_id] => 13902
            [product] => Peptide 500 - 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] => #8809663752149
            [hsn_code] => 3304
            [status] => A
            [list_price] => 2350.00
            [amount] => 3
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1657797479
            [updated_timestamp] => 1750246019
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 1645.000000
            [short_description] => Helps with early signs of aging
            [full_description] => <p>Powered by a rejuvenating 50% highly concentrated solution, a drop of peptide 500 tones up your skin for a more healthy complexion. Absorbs into the skin well and gets rid of tired-looking skin. Adenosine as an ingredient aids in wrinkle-care, gets smooth-looking skin and turns skin texture supple. A youthful solution of peptides, hyaluronic acid and beta-glucan works instantly to plump and hydrate the skin</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => peptide-500-30ml
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 1
            [main_category] => 2815
            [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] => Mizon
            [ratting_count] => 1
        )

    [14250] => Array
        (
            [product_id] => 14250
            [product] => Foobetik Cream - 100gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 302
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => FDFOOBETIKCREAM100ML36257
            [hsn_code] => 3304
            [status] => A
            [list_price] => 600.00
            [amount] => 0
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1658226727
            [updated_timestamp] => 1750427156
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 510.000000
            [short_description] => Keeps feet moisturised and smooth
            [full_description] => <p>Foobetik cream is a promising foot care formulation for diabetics which keeps the feet soft and smoother for a longer time. The advanced moisturizers, like lactic acid, urea and shea butter smooth the dry and scaly skin of the feet and heels. Provides long duration moisturization and prevents fungal infections, it soothes the burning & discomforted feeling and improves circulation in feet.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => foobetik-cream-100g
            [seo_path] => 2685/2705/2815
            [average_rating] => 5.00
            [reviews_count] => 2
            [main_category] => 2815
            [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] => Fixderma	
            [ratting_count] => 2
        )

    [15974] => Array
        (
            [product_id] => 15974
            [product] => Papaya & Peptide Night Cream For Younger Looking & Smooth Skin - 50gm
            [company_name] => Roadskye Tradecom Pvt. Ltd.
            [supplier_id] => 334
            [product_type] => P
            [parent_product_id] => 0
            [master_product_offers_count] => 0
            [master_product_id] => 0
            [company_id] => 13
            [product_code] => PAPAYAPNC
            [hsn_code] => 3304
            [status] => A
            [list_price] => 650.00
            [amount] => 83
            [weight] => 0.000
            [length] => 0
            [width] => 0
            [height] => 0
            [shipping_freight] => 0.00
            [low_avail_limit] => 0
            [timestamp] => 1660647951
            [updated_timestamp] => 1750266976
            [usergroup_ids] => 0
            [is_edp] => N
            [edp_shipping] => N
            [unlimited_download] => N
            [tracking] => B
            [free_shipping] => N
            [zero_price_action] => R
            [is_pbp] => Y
            [is_op] => N
            [is_oper] => N
            [is_returnable] => Y
            [return_period] => 10
            [avail_since] => 0
            [out_of_stock_actions] => N
            [localization] => 
            [min_qty] => 0
            [max_qty] => 5
            [qty_step] => 0
            [list_qty_count] => 0
            [tax_ids] => 13
            [age_verification] => N
            [age_limit] => 0
            [options_type] => P
            [exceptions_type] => F
            [details_layout] => default
            [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;}
            [facebook_obj_type] => 
            [buy_now_url] => 
            [is_stock_split_by_warehouses] => N
            [master_product_status] => A
            [youtube_link] => 
            [show_youtube_video] => Y
            [replace_main_image] => 
            [position_youtube] => 
            [restrict_cod] => N
            [price] => 650.000000
            [short_description] => <p>Regenerates your skin cells overnight</p>
            [full_description] => <p>Do you know that skin manifold its healing process overnight? Using the right night cream is the key! TNW introduces you to the Papaya & Peptide Night Cream that helps to improve the skins overall texture by boosting collagen production. With active ingredients like papaya, peptide, hyaluronic acid, and panthenol, this non-sticky night cream helps to reduce the visibility of fine lines, wrinkles, pigmentation, and darkness while deeply moisturizing the skin. Besides, it calms irritation and makes skin super soft & hydrated. Suitable for all skin types, this night cream work wonders on your skin. To witness the effective results, you must use this night cream regularly.</p>
            [category_ids] => Array
                (
                    [0] => 2815
                )

            [position] => 0
            [seo_name] => papaya-and-peptide-night-cream-for-younger-looking-and-smooth-skin-50g
            [seo_path] => 2685/2705/2815
            [main_category] => 2815
            [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] => TNW - The Natural Wash
        )

)

end of fxn

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 3564
    [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 = 3564 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] => 28570
    [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 = 28570 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

Array
(
    [show_master_products_only] => 
    [area] => C
    [for_required_product] => 7788
    [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 = 7788 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] => 8013
    [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 = 8013 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] => 12264
    [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 = 12264 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] => 12385
    [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 = 12385 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] => 12620
    [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 = 12620 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] => 13899
    [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 = 13899 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] => 13902
    [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 = 13902 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] => 14250
    [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 = 14250 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] => 15974
    [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 = 15974 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 

before end of oxn

Array
(
)

Array
(
)

end of fxn