Array
(
[show_master_products_only] =>
[area] => C
[items_per_page] => 12
[sl] => en
[dispatch] => categories.view
[category_id] => 2772
[page] => 5
[save_view_results] => product_id
[sort_by] => bestsellers
[sort_order] => desc
[cid] => 2772
[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 (2772) 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 48, 12
before end of oxn
Array
(
[8848] => Array
(
[product_id] => 8848
[product] => Monoi Beard Oil - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTO004
[hsn_code] => 3304
[status] => A
[list_price] => 1149.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1091.550000
[short_description] => Treats rough skin and makes it smooth
[full_description] => <p>Teal & Terra's Monoi Beard Oil is a high-grade formulation of Tiaré flowers infused with coconut oil. It is a blend of Monoi oil, Flaxseed oil, Vitamin E, and Grapeseed oil. A nourishing and moisturizing face oil that treats rough skin and makes it smooth. Making beard growth easy and effortless. Teal & Terra's Beard oil aids in strong and healthy beard growth. It treats beard itch, making the skin soft. Made from coconut Monoi Oil, Flaxseed oil, Grapeseed oil, and Vitamin E, It is chemical-free, lightweight, and non-greasy. It prevents beard hair from becoming brittle and rough. Tames flyaways and gives the beard a neat look.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => monoi-beard-oil-30ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8850] => Array
(
[product_id] => 8850
[product] => Onion & Castor Hair Oil For Hairfall Control, Hair Regrowth & Dandruff Control - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT015
[hsn_code] => 3304
[status] => A
[list_price] => 950.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 902.500000
[short_description] => It prevents dandruff, Controls hairfall & promotes regrowth
[full_description] => <p>Teal and Terra Onion and Castor Hair Oil comes in two variants - 100 ml and 200 ml. Enriched with onion, castor, organ and jojoba oil, along with Bhringraj, Amla and Vitamin E, it is a unique blend of nutrients in a bottle. It prevents dandruff, controls hairfall and promotes regrowth. It gives your hair a natural shine and keeps it smooth with the goodness of Omega 6 fatty acids.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => onion-and-castor-hair-oil-for-hairfall-control-hair-regrowth-and-dandruff-control-100ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8851] => Array
(
[product_id] => 8851
[product] => Shampoo With Argan Oil, Olive Oil For Hair Strengthening & Restoration - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT014
[hsn_code] => 3304
[status] => A
[list_price] => 872.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 828.400000
[short_description] => It nourishes the scalp thoroughly, Prevents breakage
[full_description] => <p>Teal and Terra Argan Oil Shampoo deeply cleanses your hair and scalp without harsh chemicals. Argan oil is the perfect tonic to restore shine and volume to your hair. It is also enriched with olive oil, which nourishes the scalp thoroughly, prevents breakage, and protects hair from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => shampoo-with-argan-oil-olive-oil-for-hair-strengthening-and-restoration-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8853] => Array
(
[product_id] => 8853
[product] => Luxury Hydrating Body Oil After Bath With Argan & Rose Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTOY005
[hsn_code] => 3304
[status] => A
[list_price] => 1450.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1378.000000
[short_description] => Nourishes skin and gives skin a soft glow
[full_description] => <p>Teal and Terra Luxury Hydrating Body Oil After Bath makes your skin soft and supple with the goodness of Argan and Rose Oil. Enriched with a host of other natural ingredients, the body oil works best applied after you shower and lightly dab your skin dry. The silky and light formulation of the oil nourishes your skin and gives your skin a soft glow. It has a mild, sophisticated fragrance, giving you a fresh feeling all day.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => luxury-hydrating-body-oil-after-bath-with-argan-and-rose-oil-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[9685] => Array
(
[product_id] => 9685
[product] => Argan Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MS034
[hsn_code] => 3304
[status] => A
[list_price] => 810.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 607.500000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Argan Oil is a multi use cold pressed oil. It can be used for both skin and hair. This oil is a rich source of Vitamin E, antioxidants and is a great source for linoleic and oleic fatty acids which promotes skin, hair, and nail health.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => argan-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9687] => Array
(
[product_id] => 9687
[product] => Sweet Almond Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MSA032
[hsn_code] => 3304
[status] => A
[list_price] => 685.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 513.750000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Sweet Almond Oil is a multi use cold pressed oil. The oil is rich in vitamins A, B, D and E and also contains potassium, magnesium, zinc and calcium. It is also rich in unsaturated fatty acids. It is great for keeping the skin moisturised, protecting it from UV radiation as well as for hair growth. Sweet Almond oil is a great to treat brittle nails too.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => sweet-almond-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9852] => Array
(
[product_id] => 9852
[product] => Cedarwood / Petitgrain Body Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => BO101
[hsn_code] => 3304
[status] => A
[list_price] => 690.00
[amount] => 4
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649929382
[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] => 483.000000
[short_description] => <p>Deeply moisturizes the skin, Treats body pigmentation</p>
[full_description] => <p>SKÖG Cedarwood/ Petitgrain Body Oil is perfect for daily use. This lightweight formulation absorbs easily into the skin giving it an instant long-lasting moisturization as well as maintaining the oil level. This body oil is a combination of various high-quality oils which help to revitalize the skin and treat pigmentation if any. The anti-inflammatory and antimicrobial properties treat any body acne, and skin inflammation, especially in sensitive skin, and prevent any skin infections on a daily basis.<br /> <br /> <br /> This product is unisex.</p>
<p></p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => cedarwood-petitgrain-body-oil-100
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9909] => Array
(
[product_id] => 9909
[product] => Exfoliating Scrub AHA 5% and Licorice Scrub - 100gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI1091
[hsn_code] => 3304
[status] => A
[list_price] => 449.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650280762
[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] => 426.550000
[short_description] => Improves appearance, Prevent acne
[full_description] => <p>AHA - Alpha Hydroxy Acid (Glycolic Acid, from sugar cane) present in this formula, comes with various benefits for your skin. This formula has primarily been made toexfoliate. But it also helps promote collagen and blood flow. Actively corrects discolouration from scars and age spots. Improves appearance of surface lines and wrinkles. Prevent acne breakouts, and scars. Visibly brightens your complexion and as a bonus, increases product absorption.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => exfoliating-scrub-scrub-queen-100gm
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => AULI
[ratting_count] => 1
)
[10165] => Array
(
[product_id] => 10165
[product] => Honey Oats Milk Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => HS013
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For glowing & irritation-free skin
[full_description] => <p>Made with Goat Milk, Mango Butter and Honey, this soap has anti inflammatory and anti microbial properties. Honey acts as a natural humectant locking the moisture in. The oats help exfoliate the skin. <br />Mango butter provides extra nourishment to the skin and keeps skin irritation at bay</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => honey-oats-milk-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10166] => Array
(
[product_id] => 10166
[product] => Vitamin E & Rosehip Seed Oil Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => RS014
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 6
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For hydrated & sun-protected skin
[full_description] => <p>Made with the exotic Rosehip Seed Oil and Carrot Seed Oil, this soap helps retaining moisture and also reduces pigmentation owing to the carrot seed oil. Vitamin E oil helps lighten and protect the skin from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => vitamin-e-and-rosehip-seed-oil-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10175] => Array
(
[product_id] => 10175
[product] => Ulfat Gift Box
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => UGB
[hsn_code] => 3304
[status] => A
[list_price] => 3100.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 2945.000000
[short_description] => A complete kit for perfect mental & skin health
[full_description] => <p>Presented in a Green Tofa Box, Sukoon celebrates its most sold fragrance. <br />This set is a must-have for devotees of good fragrance along side good ingredients. The Ulfat box contains four of Sukoons best selling products - Hand Wash, Hand & Body Lotions, Handmade Soap and Scented Candle. You cannot bear to leave this untouched. </p>
<p>All our products are Paraben free, SLS free, Cruelty free, Plant based, Alcohol free and contains no dye.</p>
[category_ids] => Array
(
[0] => 2772
[1] => 438
)
[position] => 0
[seo_name] => ulfat-gift-box
[seo_path] => 438
[main_category] => 438
[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] => Sukoon
)
[10507] => Array
(
[product_id] => 10507
[product] => Hyaluronic Acid Hydrating Facewash- 0.5% Amino Acids + 0.1% Hyaluronic Acid - 100ml
[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] => SKU050
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 5
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651141223
[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] => 272.090000
[short_description] => Gently washes away impurities leaving skin nourished & hydrated
[full_description] => <p>A hydration-boosting cleanser blend of amino acids and hyaluronic acid that plumps skin with moisture while thoroughly cleansing the face and balancing the pH of the skin. This one-of-a-kind cleanser is suitable for all skin types and will be universally loved because of its gentle cleansing action. Panthenol and Glycerin help to soothe and further nourish the skin.</p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw1.jpg?1673508715639" alt="hydrating%20fw1.jpg?1673508715639" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw2.jpg?1673508724911" alt="hydrating%20fw2.jpg?1673508724911" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw3.jpg?1673508737211" alt="hydrating%20fw3.jpg?1673508737211" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw5.jpg?1673508748653" alt="hydrating%20fw5.jpg?1673508748653" /><br /></p>
<p><br /></p>
<p>Products will be shipped with in a week.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => hyaluronic-acid-hydrating-facewash-0.5-amino-acids-0.1-hyaluronic-acid-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => Deconstruct Skincare
[ratting_count] => 1
)
)
Array
(
[8848] => Array
(
[product_id] => 8848
[product] => Monoi Beard Oil - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTO004
[hsn_code] => 3304
[status] => A
[list_price] => 1149.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1091.550000
[short_description] => Treats rough skin and makes it smooth
[full_description] => <p>Teal & Terra's Monoi Beard Oil is a high-grade formulation of Tiaré flowers infused with coconut oil. It is a blend of Monoi oil, Flaxseed oil, Vitamin E, and Grapeseed oil. A nourishing and moisturizing face oil that treats rough skin and makes it smooth. Making beard growth easy and effortless. Teal & Terra's Beard oil aids in strong and healthy beard growth. It treats beard itch, making the skin soft. Made from coconut Monoi Oil, Flaxseed oil, Grapeseed oil, and Vitamin E, It is chemical-free, lightweight, and non-greasy. It prevents beard hair from becoming brittle and rough. Tames flyaways and gives the beard a neat look.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => monoi-beard-oil-30ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8850] => Array
(
[product_id] => 8850
[product] => Onion & Castor Hair Oil For Hairfall Control, Hair Regrowth & Dandruff Control - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT015
[hsn_code] => 3304
[status] => A
[list_price] => 950.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 902.500000
[short_description] => It prevents dandruff, Controls hairfall & promotes regrowth
[full_description] => <p>Teal and Terra Onion and Castor Hair Oil comes in two variants - 100 ml and 200 ml. Enriched with onion, castor, organ and jojoba oil, along with Bhringraj, Amla and Vitamin E, it is a unique blend of nutrients in a bottle. It prevents dandruff, controls hairfall and promotes regrowth. It gives your hair a natural shine and keeps it smooth with the goodness of Omega 6 fatty acids.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => onion-and-castor-hair-oil-for-hairfall-control-hair-regrowth-and-dandruff-control-100ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8851] => Array
(
[product_id] => 8851
[product] => Shampoo With Argan Oil, Olive Oil For Hair Strengthening & Restoration - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT014
[hsn_code] => 3304
[status] => A
[list_price] => 872.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 828.400000
[short_description] => It nourishes the scalp thoroughly, Prevents breakage
[full_description] => <p>Teal and Terra Argan Oil Shampoo deeply cleanses your hair and scalp without harsh chemicals. Argan oil is the perfect tonic to restore shine and volume to your hair. It is also enriched with olive oil, which nourishes the scalp thoroughly, prevents breakage, and protects hair from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => shampoo-with-argan-oil-olive-oil-for-hair-strengthening-and-restoration-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8853] => Array
(
[product_id] => 8853
[product] => Luxury Hydrating Body Oil After Bath With Argan & Rose Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTOY005
[hsn_code] => 3304
[status] => A
[list_price] => 1450.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1378.000000
[short_description] => Nourishes skin and gives skin a soft glow
[full_description] => <p>Teal and Terra Luxury Hydrating Body Oil After Bath makes your skin soft and supple with the goodness of Argan and Rose Oil. Enriched with a host of other natural ingredients, the body oil works best applied after you shower and lightly dab your skin dry. The silky and light formulation of the oil nourishes your skin and gives your skin a soft glow. It has a mild, sophisticated fragrance, giving you a fresh feeling all day.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => luxury-hydrating-body-oil-after-bath-with-argan-and-rose-oil-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[9685] => Array
(
[product_id] => 9685
[product] => Argan Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MS034
[hsn_code] => 3304
[status] => A
[list_price] => 810.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 607.500000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Argan Oil is a multi use cold pressed oil. It can be used for both skin and hair. This oil is a rich source of Vitamin E, antioxidants and is a great source for linoleic and oleic fatty acids which promotes skin, hair, and nail health.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => argan-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9687] => Array
(
[product_id] => 9687
[product] => Sweet Almond Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MSA032
[hsn_code] => 3304
[status] => A
[list_price] => 685.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 513.750000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Sweet Almond Oil is a multi use cold pressed oil. The oil is rich in vitamins A, B, D and E and also contains potassium, magnesium, zinc and calcium. It is also rich in unsaturated fatty acids. It is great for keeping the skin moisturised, protecting it from UV radiation as well as for hair growth. Sweet Almond oil is a great to treat brittle nails too.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => sweet-almond-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9852] => Array
(
[product_id] => 9852
[product] => Cedarwood / Petitgrain Body Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => BO101
[hsn_code] => 3304
[status] => A
[list_price] => 690.00
[amount] => 4
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649929382
[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] => 483.000000
[short_description] => <p>Deeply moisturizes the skin, Treats body pigmentation</p>
[full_description] => <p>SKÖG Cedarwood/ Petitgrain Body Oil is perfect for daily use. This lightweight formulation absorbs easily into the skin giving it an instant long-lasting moisturization as well as maintaining the oil level. This body oil is a combination of various high-quality oils which help to revitalize the skin and treat pigmentation if any. The anti-inflammatory and antimicrobial properties treat any body acne, and skin inflammation, especially in sensitive skin, and prevent any skin infections on a daily basis.<br /> <br /> <br /> This product is unisex.</p>
<p></p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => cedarwood-petitgrain-body-oil-100
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9909] => Array
(
[product_id] => 9909
[product] => Exfoliating Scrub AHA 5% and Licorice Scrub - 100gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI1091
[hsn_code] => 3304
[status] => A
[list_price] => 449.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650280762
[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] => 426.550000
[short_description] => Improves appearance, Prevent acne
[full_description] => <p>AHA - Alpha Hydroxy Acid (Glycolic Acid, from sugar cane) present in this formula, comes with various benefits for your skin. This formula has primarily been made toexfoliate. But it also helps promote collagen and blood flow. Actively corrects discolouration from scars and age spots. Improves appearance of surface lines and wrinkles. Prevent acne breakouts, and scars. Visibly brightens your complexion and as a bonus, increases product absorption.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => exfoliating-scrub-scrub-queen-100gm
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => AULI
[ratting_count] => 1
)
[10165] => Array
(
[product_id] => 10165
[product] => Honey Oats Milk Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => HS013
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For glowing & irritation-free skin
[full_description] => <p>Made with Goat Milk, Mango Butter and Honey, this soap has anti inflammatory and anti microbial properties. Honey acts as a natural humectant locking the moisture in. The oats help exfoliate the skin. <br />Mango butter provides extra nourishment to the skin and keeps skin irritation at bay</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => honey-oats-milk-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10166] => Array
(
[product_id] => 10166
[product] => Vitamin E & Rosehip Seed Oil Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => RS014
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 6
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For hydrated & sun-protected skin
[full_description] => <p>Made with the exotic Rosehip Seed Oil and Carrot Seed Oil, this soap helps retaining moisture and also reduces pigmentation owing to the carrot seed oil. Vitamin E oil helps lighten and protect the skin from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => vitamin-e-and-rosehip-seed-oil-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10175] => Array
(
[product_id] => 10175
[product] => Ulfat Gift Box
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => UGB
[hsn_code] => 3304
[status] => A
[list_price] => 3100.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 2945.000000
[short_description] => A complete kit for perfect mental & skin health
[full_description] => <p>Presented in a Green Tofa Box, Sukoon celebrates its most sold fragrance. <br />This set is a must-have for devotees of good fragrance along side good ingredients. The Ulfat box contains four of Sukoons best selling products - Hand Wash, Hand & Body Lotions, Handmade Soap and Scented Candle. You cannot bear to leave this untouched. </p>
<p>All our products are Paraben free, SLS free, Cruelty free, Plant based, Alcohol free and contains no dye.</p>
[category_ids] => Array
(
[0] => 2772
[1] => 438
)
[position] => 0
[seo_name] => ulfat-gift-box
[seo_path] => 438
[main_category] => 438
[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] => Sukoon
)
[10507] => Array
(
[product_id] => 10507
[product] => Hyaluronic Acid Hydrating Facewash- 0.5% Amino Acids + 0.1% Hyaluronic Acid - 100ml
[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] => SKU050
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 5
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651141223
[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] => 272.090000
[short_description] => Gently washes away impurities leaving skin nourished & hydrated
[full_description] => <p>A hydration-boosting cleanser blend of amino acids and hyaluronic acid that plumps skin with moisture while thoroughly cleansing the face and balancing the pH of the skin. This one-of-a-kind cleanser is suitable for all skin types and will be universally loved because of its gentle cleansing action. Panthenol and Glycerin help to soothe and further nourish the skin.</p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw1.jpg?1673508715639" alt="hydrating%20fw1.jpg?1673508715639" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw2.jpg?1673508724911" alt="hydrating%20fw2.jpg?1673508724911" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw3.jpg?1673508737211" alt="hydrating%20fw3.jpg?1673508737211" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw5.jpg?1673508748653" alt="hydrating%20fw5.jpg?1673508748653" /><br /></p>
<p><br /></p>
<p>Products will be shipped with in a week.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => hyaluronic-acid-hydrating-facewash-0.5-amino-acids-0.1-hyaluronic-acid-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => Deconstruct Skincare
[ratting_count] => 1
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[items_per_page] => 12
[sl] => en
[dispatch] => categories.view
[category_id] => 2772
[page] => 5
[save_view_results] => product_id
[sort_by] => bestsellers
[sort_order] => desc
[cid] => 2772
[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
before end of oxn
Array
(
[8848] => Array
(
[product_id] => 8848
[product] => Monoi Beard Oil - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTO004
[hsn_code] => 3304
[status] => A
[list_price] => 1149.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1091.550000
[short_description] => Treats rough skin and makes it smooth
[full_description] => <p>Teal & Terra's Monoi Beard Oil is a high-grade formulation of Tiaré flowers infused with coconut oil. It is a blend of Monoi oil, Flaxseed oil, Vitamin E, and Grapeseed oil. A nourishing and moisturizing face oil that treats rough skin and makes it smooth. Making beard growth easy and effortless. Teal & Terra's Beard oil aids in strong and healthy beard growth. It treats beard itch, making the skin soft. Made from coconut Monoi Oil, Flaxseed oil, Grapeseed oil, and Vitamin E, It is chemical-free, lightweight, and non-greasy. It prevents beard hair from becoming brittle and rough. Tames flyaways and gives the beard a neat look.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => monoi-beard-oil-30ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8850] => Array
(
[product_id] => 8850
[product] => Onion & Castor Hair Oil For Hairfall Control, Hair Regrowth & Dandruff Control - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT015
[hsn_code] => 3304
[status] => A
[list_price] => 950.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 902.500000
[short_description] => It prevents dandruff, Controls hairfall & promotes regrowth
[full_description] => <p>Teal and Terra Onion and Castor Hair Oil comes in two variants - 100 ml and 200 ml. Enriched with onion, castor, organ and jojoba oil, along with Bhringraj, Amla and Vitamin E, it is a unique blend of nutrients in a bottle. It prevents dandruff, controls hairfall and promotes regrowth. It gives your hair a natural shine and keeps it smooth with the goodness of Omega 6 fatty acids.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => onion-and-castor-hair-oil-for-hairfall-control-hair-regrowth-and-dandruff-control-100ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8851] => Array
(
[product_id] => 8851
[product] => Shampoo With Argan Oil, Olive Oil For Hair Strengthening & Restoration - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT014
[hsn_code] => 3304
[status] => A
[list_price] => 872.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 828.400000
[short_description] => It nourishes the scalp thoroughly, Prevents breakage
[full_description] => <p>Teal and Terra Argan Oil Shampoo deeply cleanses your hair and scalp without harsh chemicals. Argan oil is the perfect tonic to restore shine and volume to your hair. It is also enriched with olive oil, which nourishes the scalp thoroughly, prevents breakage, and protects hair from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => shampoo-with-argan-oil-olive-oil-for-hair-strengthening-and-restoration-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8853] => Array
(
[product_id] => 8853
[product] => Luxury Hydrating Body Oil After Bath With Argan & Rose Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTOY005
[hsn_code] => 3304
[status] => A
[list_price] => 1450.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1378.000000
[short_description] => Nourishes skin and gives skin a soft glow
[full_description] => <p>Teal and Terra Luxury Hydrating Body Oil After Bath makes your skin soft and supple with the goodness of Argan and Rose Oil. Enriched with a host of other natural ingredients, the body oil works best applied after you shower and lightly dab your skin dry. The silky and light formulation of the oil nourishes your skin and gives your skin a soft glow. It has a mild, sophisticated fragrance, giving you a fresh feeling all day.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => luxury-hydrating-body-oil-after-bath-with-argan-and-rose-oil-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[9685] => Array
(
[product_id] => 9685
[product] => Argan Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MS034
[hsn_code] => 3304
[status] => A
[list_price] => 810.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 607.500000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Argan Oil is a multi use cold pressed oil. It can be used for both skin and hair. This oil is a rich source of Vitamin E, antioxidants and is a great source for linoleic and oleic fatty acids which promotes skin, hair, and nail health.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => argan-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9687] => Array
(
[product_id] => 9687
[product] => Sweet Almond Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MSA032
[hsn_code] => 3304
[status] => A
[list_price] => 685.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 513.750000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Sweet Almond Oil is a multi use cold pressed oil. The oil is rich in vitamins A, B, D and E and also contains potassium, magnesium, zinc and calcium. It is also rich in unsaturated fatty acids. It is great for keeping the skin moisturised, protecting it from UV radiation as well as for hair growth. Sweet Almond oil is a great to treat brittle nails too.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => sweet-almond-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9852] => Array
(
[product_id] => 9852
[product] => Cedarwood / Petitgrain Body Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => BO101
[hsn_code] => 3304
[status] => A
[list_price] => 690.00
[amount] => 4
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649929382
[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] => 483.000000
[short_description] => <p>Deeply moisturizes the skin, Treats body pigmentation</p>
[full_description] => <p>SKÖG Cedarwood/ Petitgrain Body Oil is perfect for daily use. This lightweight formulation absorbs easily into the skin giving it an instant long-lasting moisturization as well as maintaining the oil level. This body oil is a combination of various high-quality oils which help to revitalize the skin and treat pigmentation if any. The anti-inflammatory and antimicrobial properties treat any body acne, and skin inflammation, especially in sensitive skin, and prevent any skin infections on a daily basis.<br /> <br /> <br /> This product is unisex.</p>
<p></p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => cedarwood-petitgrain-body-oil-100
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9909] => Array
(
[product_id] => 9909
[product] => Exfoliating Scrub AHA 5% and Licorice Scrub - 100gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI1091
[hsn_code] => 3304
[status] => A
[list_price] => 449.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650280762
[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] => 426.550000
[short_description] => Improves appearance, Prevent acne
[full_description] => <p>AHA - Alpha Hydroxy Acid (Glycolic Acid, from sugar cane) present in this formula, comes with various benefits for your skin. This formula has primarily been made toexfoliate. But it also helps promote collagen and blood flow. Actively corrects discolouration from scars and age spots. Improves appearance of surface lines and wrinkles. Prevent acne breakouts, and scars. Visibly brightens your complexion and as a bonus, increases product absorption.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => exfoliating-scrub-scrub-queen-100gm
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => AULI
[ratting_count] => 1
)
[10165] => Array
(
[product_id] => 10165
[product] => Honey Oats Milk Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => HS013
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For glowing & irritation-free skin
[full_description] => <p>Made with Goat Milk, Mango Butter and Honey, this soap has anti inflammatory and anti microbial properties. Honey acts as a natural humectant locking the moisture in. The oats help exfoliate the skin. <br />Mango butter provides extra nourishment to the skin and keeps skin irritation at bay</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => honey-oats-milk-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10166] => Array
(
[product_id] => 10166
[product] => Vitamin E & Rosehip Seed Oil Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => RS014
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 6
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For hydrated & sun-protected skin
[full_description] => <p>Made with the exotic Rosehip Seed Oil and Carrot Seed Oil, this soap helps retaining moisture and also reduces pigmentation owing to the carrot seed oil. Vitamin E oil helps lighten and protect the skin from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => vitamin-e-and-rosehip-seed-oil-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10175] => Array
(
[product_id] => 10175
[product] => Ulfat Gift Box
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => UGB
[hsn_code] => 3304
[status] => A
[list_price] => 3100.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 2945.000000
[short_description] => A complete kit for perfect mental & skin health
[full_description] => <p>Presented in a Green Tofa Box, Sukoon celebrates its most sold fragrance. <br />This set is a must-have for devotees of good fragrance along side good ingredients. The Ulfat box contains four of Sukoons best selling products - Hand Wash, Hand & Body Lotions, Handmade Soap and Scented Candle. You cannot bear to leave this untouched. </p>
<p>All our products are Paraben free, SLS free, Cruelty free, Plant based, Alcohol free and contains no dye.</p>
[category_ids] => Array
(
[0] => 2772
[1] => 438
)
[position] => 0
[seo_name] => ulfat-gift-box
[seo_path] => 438
[main_category] => 438
[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] => Sukoon
)
[10507] => Array
(
[product_id] => 10507
[product] => Hyaluronic Acid Hydrating Facewash- 0.5% Amino Acids + 0.1% Hyaluronic Acid - 100ml
[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] => SKU050
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 5
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651141223
[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] => 272.090000
[short_description] => Gently washes away impurities leaving skin nourished & hydrated
[full_description] => <p>A hydration-boosting cleanser blend of amino acids and hyaluronic acid that plumps skin with moisture while thoroughly cleansing the face and balancing the pH of the skin. This one-of-a-kind cleanser is suitable for all skin types and will be universally loved because of its gentle cleansing action. Panthenol and Glycerin help to soothe and further nourish the skin.</p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw1.jpg?1673508715639" alt="hydrating%20fw1.jpg?1673508715639" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw2.jpg?1673508724911" alt="hydrating%20fw2.jpg?1673508724911" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw3.jpg?1673508737211" alt="hydrating%20fw3.jpg?1673508737211" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw5.jpg?1673508748653" alt="hydrating%20fw5.jpg?1673508748653" /><br /></p>
<p><br /></p>
<p>Products will be shipped with in a week.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => hyaluronic-acid-hydrating-facewash-0.5-amino-acids-0.1-hyaluronic-acid-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => Deconstruct Skincare
[ratting_count] => 1
)
)
Array
(
[8848] => Array
(
[product_id] => 8848
[product] => Monoi Beard Oil - 30ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTO004
[hsn_code] => 3304
[status] => A
[list_price] => 1149.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1091.550000
[short_description] => Treats rough skin and makes it smooth
[full_description] => <p>Teal & Terra's Monoi Beard Oil is a high-grade formulation of Tiaré flowers infused with coconut oil. It is a blend of Monoi oil, Flaxseed oil, Vitamin E, and Grapeseed oil. A nourishing and moisturizing face oil that treats rough skin and makes it smooth. Making beard growth easy and effortless. Teal & Terra's Beard oil aids in strong and healthy beard growth. It treats beard itch, making the skin soft. Made from coconut Monoi Oil, Flaxseed oil, Grapeseed oil, and Vitamin E, It is chemical-free, lightweight, and non-greasy. It prevents beard hair from becoming brittle and rough. Tames flyaways and gives the beard a neat look.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => monoi-beard-oil-30ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8850] => Array
(
[product_id] => 8850
[product] => Onion & Castor Hair Oil For Hairfall Control, Hair Regrowth & Dandruff Control - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT015
[hsn_code] => 3304
[status] => A
[list_price] => 950.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 902.500000
[short_description] => It prevents dandruff, Controls hairfall & promotes regrowth
[full_description] => <p>Teal and Terra Onion and Castor Hair Oil comes in two variants - 100 ml and 200 ml. Enriched with onion, castor, organ and jojoba oil, along with Bhringraj, Amla and Vitamin E, it is a unique blend of nutrients in a bottle. It prevents dandruff, controls hairfall and promotes regrowth. It gives your hair a natural shine and keeps it smooth with the goodness of Omega 6 fatty acids.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => onion-and-castor-hair-oil-for-hairfall-control-hair-regrowth-and-dandruff-control-100ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8851] => Array
(
[product_id] => 8851
[product] => Shampoo With Argan Oil, Olive Oil For Hair Strengthening & Restoration - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TAT014
[hsn_code] => 3304
[status] => A
[list_price] => 872.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 828.400000
[short_description] => It nourishes the scalp thoroughly, Prevents breakage
[full_description] => <p>Teal and Terra Argan Oil Shampoo deeply cleanses your hair and scalp without harsh chemicals. Argan oil is the perfect tonic to restore shine and volume to your hair. It is also enriched with olive oil, which nourishes the scalp thoroughly, prevents breakage, and protects hair from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => shampoo-with-argan-oil-olive-oil-for-hair-strengthening-and-restoration-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[8853] => Array
(
[product_id] => 8853
[product] => Luxury Hydrating Body Oil After Bath With Argan & Rose Oil - 200ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 216
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => TTOY005
[hsn_code] => 3304
[status] => A
[list_price] => 1450.00
[amount] => 99
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1648455342
[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] => 1378.000000
[short_description] => Nourishes skin and gives skin a soft glow
[full_description] => <p>Teal and Terra Luxury Hydrating Body Oil After Bath makes your skin soft and supple with the goodness of Argan and Rose Oil. Enriched with a host of other natural ingredients, the body oil works best applied after you shower and lightly dab your skin dry. The silky and light formulation of the oil nourishes your skin and gives your skin a soft glow. It has a mild, sophisticated fragrance, giving you a fresh feeling all day.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => luxury-hydrating-body-oil-after-bath-with-argan-and-rose-oil-200ml
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Teal and Terra
)
[9685] => Array
(
[product_id] => 9685
[product] => Argan Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MS034
[hsn_code] => 3304
[status] => A
[list_price] => 810.00
[amount] => 0
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 607.500000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Argan Oil is a multi use cold pressed oil. It can be used for both skin and hair. This oil is a rich source of Vitamin E, antioxidants and is a great source for linoleic and oleic fatty acids which promotes skin, hair, and nail health.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => argan-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9687] => Array
(
[product_id] => 9687
[product] => Sweet Almond Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => MSA032
[hsn_code] => 3304
[status] => A
[list_price] => 685.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649742733
[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] => 513.750000
[short_description] => For brilliant skin/hair health
[full_description] => <p>SKÖG Sweet Almond Oil is a multi use cold pressed oil. The oil is rich in vitamins A, B, D and E and also contains potassium, magnesium, zinc and calcium. It is also rich in unsaturated fatty acids. It is great for keeping the skin moisturised, protecting it from UV radiation as well as for hair growth. Sweet Almond oil is a great to treat brittle nails too.<br /><br /> This oil is pure and is suitable for men, women, and children. It can also be used by expecting or nursing mothers.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => sweet-almond-oil-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9852] => Array
(
[product_id] => 9852
[product] => Cedarwood / Petitgrain Body Oil - 100ml
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 172
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => BO101
[hsn_code] => 3304
[status] => A
[list_price] => 690.00
[amount] => 4
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1649929382
[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] => 483.000000
[short_description] => <p>Deeply moisturizes the skin, Treats body pigmentation</p>
[full_description] => <p>SKÖG Cedarwood/ Petitgrain Body Oil is perfect for daily use. This lightweight formulation absorbs easily into the skin giving it an instant long-lasting moisturization as well as maintaining the oil level. This body oil is a combination of various high-quality oils which help to revitalize the skin and treat pigmentation if any. The anti-inflammatory and antimicrobial properties treat any body acne, and skin inflammation, especially in sensitive skin, and prevent any skin infections on a daily basis.<br /> <br /> <br /> This product is unisex.</p>
<p></p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => cedarwood-petitgrain-body-oil-100
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => SKOG
[ratting_count] => 1
)
[9909] => Array
(
[product_id] => 9909
[product] => Exfoliating Scrub AHA 5% and Licorice Scrub - 100gm
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 16
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => AULI1091
[hsn_code] => 3304
[status] => A
[list_price] => 449.00
[amount] => 100
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650280762
[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] => 426.550000
[short_description] => Improves appearance, Prevent acne
[full_description] => <p>AHA - Alpha Hydroxy Acid (Glycolic Acid, from sugar cane) present in this formula, comes with various benefits for your skin. This formula has primarily been made toexfoliate. But it also helps promote collagen and blood flow. Actively corrects discolouration from scars and age spots. Improves appearance of surface lines and wrinkles. Prevent acne breakouts, and scars. Visibly brightens your complexion and as a bonus, increases product absorption.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => exfoliating-scrub-scrub-queen-100gm
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => AULI
[ratting_count] => 1
)
[10165] => Array
(
[product_id] => 10165
[product] => Honey Oats Milk Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => HS013
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 9
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For glowing & irritation-free skin
[full_description] => <p>Made with Goat Milk, Mango Butter and Honey, this soap has anti inflammatory and anti microbial properties. Honey acts as a natural humectant locking the moisture in. The oats help exfoliate the skin. <br />Mango butter provides extra nourishment to the skin and keeps skin irritation at bay</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => honey-oats-milk-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10166] => Array
(
[product_id] => 10166
[product] => Vitamin E & Rosehip Seed Oil Soap
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => RS014
[hsn_code] => 3304
[status] => A
[list_price] => 395.00
[amount] => 6
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 375.250000
[short_description] => For hydrated & sun-protected skin
[full_description] => <p>Made with the exotic Rosehip Seed Oil and Carrot Seed Oil, this soap helps retaining moisture and also reduces pigmentation owing to the carrot seed oil. Vitamin E oil helps lighten and protect the skin from sun damage.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => vitamin-e-and-rosehip-seed-oil-soap
[seo_path] => 2768/2771/2772
[main_category] => 2772
[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] => Sukoon
)
[10175] => Array
(
[product_id] => 10175
[product] => Ulfat Gift Box
[company_name] => Roadskye Tradecom Pvt. Ltd.
[supplier_id] => 190
[product_type] => P
[parent_product_id] => 0
[master_product_offers_count] => 0
[master_product_id] => 0
[company_id] => 13
[product_code] => UGB
[hsn_code] => 3304
[status] => A
[list_price] => 3100.00
[amount] => 8
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1650609646
[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] => 2945.000000
[short_description] => A complete kit for perfect mental & skin health
[full_description] => <p>Presented in a Green Tofa Box, Sukoon celebrates its most sold fragrance. <br />This set is a must-have for devotees of good fragrance along side good ingredients. The Ulfat box contains four of Sukoons best selling products - Hand Wash, Hand & Body Lotions, Handmade Soap and Scented Candle. You cannot bear to leave this untouched. </p>
<p>All our products are Paraben free, SLS free, Cruelty free, Plant based, Alcohol free and contains no dye.</p>
[category_ids] => Array
(
[0] => 2772
[1] => 438
)
[position] => 0
[seo_name] => ulfat-gift-box
[seo_path] => 438
[main_category] => 438
[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] => Sukoon
)
[10507] => Array
(
[product_id] => 10507
[product] => Hyaluronic Acid Hydrating Facewash- 0.5% Amino Acids + 0.1% Hyaluronic Acid - 100ml
[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] => SKU050
[hsn_code] => 3304
[status] => A
[list_price] => 299.00
[amount] => 5
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1651141223
[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] => 272.090000
[short_description] => Gently washes away impurities leaving skin nourished & hydrated
[full_description] => <p>A hydration-boosting cleanser blend of amino acids and hyaluronic acid that plumps skin with moisture while thoroughly cleansing the face and balancing the pH of the skin. This one-of-a-kind cleanser is suitable for all skin types and will be universally loved because of its gentle cleansing action. Panthenol and Glycerin help to soothe and further nourish the skin.</p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw1.jpg?1673508715639" alt="hydrating%20fw1.jpg?1673508715639" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw2.jpg?1673508724911" alt="hydrating%20fw2.jpg?1673508724911" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw3.jpg?1673508737211" alt="hydrating%20fw3.jpg?1673508737211" /><br /></p>
<p><br /></p>
<p><br /></p>
<p><img src="https://cdn.kindlife.in/images/Deconstruct/Facewash/Hyaluronic%20Acid%20Hydrating%20Facewash/hydrating%20fw5.jpg?1673508748653" alt="hydrating%20fw5.jpg?1673508748653" /><br /></p>
<p><br /></p>
<p>Products will be shipped with in a week.</p>
[category_ids] => Array
(
[0] => 2772
)
[position] => 0
[seo_name] => hyaluronic-acid-hydrating-facewash-0.5-amino-acids-0.1-hyaluronic-acid-100ml
[seo_path] => 2768/2771/2772
[average_rating] => 5.00
[reviews_count] => 1
[main_category] => 2772
[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] => Deconstruct Skincare
[ratting_count] => 1
)
)
end of fxn
Array
(
[show_master_products_only] =>
[area] => C
[for_required_product] => 8848
[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 = 8848 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] => 8850
[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 = 8850 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] => 8851
[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 = 8851 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] => 8853
[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 = 8853 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] => 9685
[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 = 9685 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] => 9687
[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 = 9687 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] => 9852
[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 = 9852 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] => 9909
[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 = 9909 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] => 10165
[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 = 10165 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] => 10166
[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 = 10166 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] => 10175
[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 = 10175 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] => 10507
[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 = 10507 GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC
before end of oxn
Array ( )
Array ( )
end of fxn
Cannot create references to/from string offsets
app/Tygh/Registry.php, line: 221
| File: | app/Tygh/Registry.php |
| Line: | 89 |
| Function: | _varByKey |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 111 |
| Function: | set |
| File: | app/addons/seo/Tygh/SeoCache.php |
| Line: | 49 |
| Function: | setStatic |
| File: | app/addons/seo/func.php |
| Line: | 1329 |
| Function: | set |
| File: | app/addons/seo/func.php |
| Line: | 1563 |
| Function: | fn_seo_get_name |
| File: | app/functions/fn.control.php |
| Line: | 123 |
| Function: | fn_seo_url_post |
| File: | app/functions/fn.common.php |
| Line: | 3921 |
| Function: | fn_set_hook |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 496 |
| Function: | fn_url |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 517 |
| Function: | getConfigurationUrl |
| File: | app/Tygh/BlockManager/Container.php |
| Line: | 120 |
| Function: | addBlockManagerProperties |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 127 |
| Function: | getListByArea |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 50 |
| Function: | __construct |
| File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
| Line: | 191 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_689464c1dbc0b1_26812820 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 81 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 636 |
| Function: | fetch |
| File: | index.php |
| Line: | 39 |
| Function: | fn_dispatch |