KLOVE | Extra 5% off on all Kbeauty orders above ₹999
SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+
SUNKISS5 | Extra 5% off on orders ₹999+
Array ( [show_master_products_only] => [area] => C [features_hash] => 28-20891 [items_per_page] => 12 [sl] => en [dispatch] => categories.view [category_id] => 2421 [page] => 4 [save_view_results] => product_id [sort_by] => bestsellers [sort_order] => desc [extend] => Array ( [0] => categories [1] => description [2] => description [3] => full_description ) [subcats] => Y [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006 ) ) ) )
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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 (var_val_73.variant_id IN (20891)) 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) AND (1 AND products.product_id IN (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 36, 12
before end of oxn
Array ( [8110] => Array ( [product_id] => 8110 [product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES25 [hsn_code] => 3304 [status] => A [list_price] => 930.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 781.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>For Barbeque Almonds, our Nutty Kitchen Chefs dry roast big chunks of California almonds with a blend of exotic barbeque spices. The result is a flavourful, playful and delightful combination of joy and all smiles. They undergo a special dry roasting process in the Nutty Kitchen with a blend of our special exotic barbeque spices, a hint of paprika and zero oil. Packed in their whole, barbequed, skin-on avatars, they have a crunchy texture with undernotes of barbequed goodness. Barbeque Almonds are a powerhouse of nutrition those chunks arent just big in size; they are big on health too. Each handful serving portion packs 6.2 g of protein, 12 g of good fat, and a good amount of magnesium, calcium, iron and Vitamin E.</p> [category_ids] => Array ( [0] => 1238 [1] => 2641 ) [seo_name] => barbeque-almonds-bbq-healthy-party-snack-dry-roasted-non-fried-zero-oil-crunchy-tasty-200g-pack-of-2 [seo_path] => 458/2640/2641 [average_rating] => 5.00 [reviews_count] => 1 [main_category] => 2641 [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] => Nutty Gritties [ratting_count] => 1 ) [8118] => Array ( [product_id] => 8118 [product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES33 [hsn_code] => 3304 [status] => A [list_price] => 830.00 [amount] => 196 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 697.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>ORIGIN- Premium Mixed Berries coming all the way from the USA. APPEARANCE- mixed blend of dried strawberries, black currants, blueberries and cranberries. TEXTURE- smooth and easily chewable. HOW TO USE- Our nutritionists recommend on having a handful of Mixed Berries. You can have it kill your sweet tooth cravings or even use it as a dressing on your salad bowl.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => mix-berries-dried-cranberries-blueberries-strawberries-black-currants-healthy-snack-for-kids-and-adults-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8121] => Array ( [product_id] => 8121 [product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES36 [hsn_code] => 3304 [status] => A [list_price] => 540.00 [amount] => 183 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 448.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Nutty Gritties Super Seeds Mix is a combination of Roasted Seeds - Flaxseeds(10%), Chia seeds(10%), Sesame seeds(10%), Sunflower seeds (25%), Watermelon seeds(25%) and Pumpkin seeds (20%). Our Super Seeds Mix is a delectable mix of Pumpkin Seeds, Chia Seeds, Sesame Seeds, Sunflower Seeds, Watermelon Seeds, Flax Seeds, all roasted at a minimal temperature to give you just the right amount of crunch! Snack on them at any time or add them to salads, yogurts, ice creams to get an added boost of nutrition and fibre. Nutty Gritties is working since 2009 for Premium Nuts and Dry Fruits and we are into this trade since 1887"</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => super-seeds-mix-roasted-flax-chia-sesame-sunflower-watermelon-pumpkin-seeds-mixed-seeds-200g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.50 [reviews_count] => 2 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 2 ) [8123] => Array ( [product_id] => 8123 [product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES38 [hsn_code] => 3304 [status] => A [list_price] => 700.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 588.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => moms-superfood-mix-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8125] => Array ( [product_id] => 8125 [product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES40 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 190 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 655.700000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => premium-dates-omani-500g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 5 ) [8139] => Array ( [product_id] => 8139 [product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES54 [hsn_code] => 3304 [status] => A [list_price] => 450.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 378.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => sports-mix-roasted-almonds-cashews-pistachios-dried-blueberries-cranberries-and-raisins-pack-of-6-x-30g-each-180g [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8147] => Array ( [product_id] => 8147 [product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES62 [hsn_code] => 3304 [status] => A [list_price] => 800.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 672.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => mixed-dry-fruits-and-seeds-combo-400g-moms-superfood-mix-sports-mix-200g-each [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8639] => Array ( [product_id] => 8639 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33007 [hsn_code] => 3304 [status] => A [list_price] => 395.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 327.850000 [short_description] => <p>Rich in dietary fiber & wonderful for both adults & kids</p> [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-200-g [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8640] => Array ( [product_id] => 8640 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33008 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 655.700000 [short_description] => Energy-boosting snack for adults & kids [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-400-g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG301 [hsn_code] => 3304 [status] => A [list_price] => 3200.00 [amount] => 129 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1654706987 [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] => 2592.000000 [short_description] => <p>For daily nutrition</p> [full_description] => <p>This product is highly rich in energy, protein and dietary fibre. Grab a handful to fulfill your daily essential nutritional requirements.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => california-almonds-for-essential-nutritional-requirements-2-kg [seo_path] => 458/2646/2648 [average_rating] => 4.87 [reviews_count] => 23 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 23 ) [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Fabeato_All Nuts [hsn_code] => 3304 [status] => A [list_price] => 1750.00 [amount] => 10000 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1688363880 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => [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] => 1175.000000 [short_description] => Rich in protein & fibre [full_description] => <p>Almonds are popularly considered “brain food.” Healthy levels of vitamin E (found in almonds) have been shown to maintain the health and alertness of the Brain.Cashews also contain a variety of vitamins, minerals, and health-protective beneficial plant compounds. Good for an active lifestyle perfect for daily routine<br />The premium California pistachios are delicately salted and oven-roasted for the best crispy texture, making them absolutely delectable for your taste buds<br />The walnuts are a good source of vegan omega-3 fat, which help reduce heart disease risk. Rich source of energy as it has got all the minerals, nutrients, antioxidants & vitamin.<br />Premium seedless Afghani Black Raisins that are famous for their sweetness as a ready to go snack. Imported from Afghanistan, these raisins are plump, luscious and flavoursome. You are going to relish each and every bite of it.<br />Nuts and dry fruits are considered to be amongst one of the healthy snacking options. Use it as a festive gift hamper or everyday snacking delight.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => dry-fruits-and-nuts-combo-pack-of-5-200gm-each [seo_path] => 458/2646/2648 [average_rating] => 4.00 [reviews_count] => 1 [main_category] => 2648 [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] => Fabeato [ratting_count] => 1 ) )
Array ( [8110] => Array ( [product_id] => 8110 [product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES25 [hsn_code] => 3304 [status] => A [list_price] => 930.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 781.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>For Barbeque Almonds, our Nutty Kitchen Chefs dry roast big chunks of California almonds with a blend of exotic barbeque spices. The result is a flavourful, playful and delightful combination of joy and all smiles. They undergo a special dry roasting process in the Nutty Kitchen with a blend of our special exotic barbeque spices, a hint of paprika and zero oil. Packed in their whole, barbequed, skin-on avatars, they have a crunchy texture with undernotes of barbequed goodness. Barbeque Almonds are a powerhouse of nutrition those chunks arent just big in size; they are big on health too. Each handful serving portion packs 6.2 g of protein, 12 g of good fat, and a good amount of magnesium, calcium, iron and Vitamin E.</p> [category_ids] => Array ( [0] => 1238 [1] => 2641 ) [seo_name] => barbeque-almonds-bbq-healthy-party-snack-dry-roasted-non-fried-zero-oil-crunchy-tasty-200g-pack-of-2 [seo_path] => 458/2640/2641 [average_rating] => 5.00 [reviews_count] => 1 [main_category] => 2641 [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] => Nutty Gritties [ratting_count] => 1 ) [8118] => Array ( [product_id] => 8118 [product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES33 [hsn_code] => 3304 [status] => A [list_price] => 830.00 [amount] => 196 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 697.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>ORIGIN- Premium Mixed Berries coming all the way from the USA. APPEARANCE- mixed blend of dried strawberries, black currants, blueberries and cranberries. TEXTURE- smooth and easily chewable. HOW TO USE- Our nutritionists recommend on having a handful of Mixed Berries. You can have it kill your sweet tooth cravings or even use it as a dressing on your salad bowl.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => mix-berries-dried-cranberries-blueberries-strawberries-black-currants-healthy-snack-for-kids-and-adults-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8121] => Array ( [product_id] => 8121 [product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES36 [hsn_code] => 3304 [status] => A [list_price] => 540.00 [amount] => 183 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 448.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Nutty Gritties Super Seeds Mix is a combination of Roasted Seeds - Flaxseeds(10%), Chia seeds(10%), Sesame seeds(10%), Sunflower seeds (25%), Watermelon seeds(25%) and Pumpkin seeds (20%). Our Super Seeds Mix is a delectable mix of Pumpkin Seeds, Chia Seeds, Sesame Seeds, Sunflower Seeds, Watermelon Seeds, Flax Seeds, all roasted at a minimal temperature to give you just the right amount of crunch! Snack on them at any time or add them to salads, yogurts, ice creams to get an added boost of nutrition and fibre. Nutty Gritties is working since 2009 for Premium Nuts and Dry Fruits and we are into this trade since 1887"</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => super-seeds-mix-roasted-flax-chia-sesame-sunflower-watermelon-pumpkin-seeds-mixed-seeds-200g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.50 [reviews_count] => 2 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 2 ) [8123] => Array ( [product_id] => 8123 [product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES38 [hsn_code] => 3304 [status] => A [list_price] => 700.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 588.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => moms-superfood-mix-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8125] => Array ( [product_id] => 8125 [product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES40 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 190 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 655.700000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => premium-dates-omani-500g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 5 ) [8139] => Array ( [product_id] => 8139 [product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES54 [hsn_code] => 3304 [status] => A [list_price] => 450.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 378.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => sports-mix-roasted-almonds-cashews-pistachios-dried-blueberries-cranberries-and-raisins-pack-of-6-x-30g-each-180g [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8147] => Array ( [product_id] => 8147 [product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES62 [hsn_code] => 3304 [status] => A [list_price] => 800.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 672.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => mixed-dry-fruits-and-seeds-combo-400g-moms-superfood-mix-sports-mix-200g-each [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8639] => Array ( [product_id] => 8639 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33007 [hsn_code] => 3304 [status] => A [list_price] => 395.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 327.850000 [short_description] => <p>Rich in dietary fiber & wonderful for both adults & kids</p> [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-200-g [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8640] => Array ( [product_id] => 8640 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33008 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 655.700000 [short_description] => Energy-boosting snack for adults & kids [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-400-g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG301 [hsn_code] => 3304 [status] => A [list_price] => 3200.00 [amount] => 129 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1654706987 [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] => 2592.000000 [short_description] => <p>For daily nutrition</p> [full_description] => <p>This product is highly rich in energy, protein and dietary fibre. Grab a handful to fulfill your daily essential nutritional requirements.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => california-almonds-for-essential-nutritional-requirements-2-kg [seo_path] => 458/2646/2648 [average_rating] => 4.87 [reviews_count] => 23 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 23 ) [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Fabeato_All Nuts [hsn_code] => 3304 [status] => A [list_price] => 1750.00 [amount] => 10000 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1688363880 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => [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] => 1175.000000 [short_description] => Rich in protein & fibre [full_description] => <p>Almonds are popularly considered “brain food.” Healthy levels of vitamin E (found in almonds) have been shown to maintain the health and alertness of the Brain.Cashews also contain a variety of vitamins, minerals, and health-protective beneficial plant compounds. Good for an active lifestyle perfect for daily routine<br />The premium California pistachios are delicately salted and oven-roasted for the best crispy texture, making them absolutely delectable for your taste buds<br />The walnuts are a good source of vegan omega-3 fat, which help reduce heart disease risk. Rich source of energy as it has got all the minerals, nutrients, antioxidants & vitamin.<br />Premium seedless Afghani Black Raisins that are famous for their sweetness as a ready to go snack. Imported from Afghanistan, these raisins are plump, luscious and flavoursome. You are going to relish each and every bite of it.<br />Nuts and dry fruits are considered to be amongst one of the healthy snacking options. Use it as a festive gift hamper or everyday snacking delight.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => dry-fruits-and-nuts-combo-pack-of-5-200gm-each [seo_path] => 458/2646/2648 [average_rating] => 4.00 [reviews_count] => 1 [main_category] => 2648 [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] => Fabeato [ratting_count] => 1 ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 12049 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12049)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 12049 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [condition_element] => 62 [operator] => nin [condition] => feature [value] => 49321,40971,38308 [value_name] => ) ) ) [include_child_variations] => 1 )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12049)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 12049 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => categories [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12049)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 12049 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => categories [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (12049)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
Array ( [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Nutty Gritties ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 31750 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (31750)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products.product_id IN (3556,3976,14830,15216,23660,28537,32931,35638,35639,36366,37916,39004,39636,58631,63910,63916,63922,65282)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( )
Array ( )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 31750 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [condition_element] => 62 [operator] => nin [condition] => feature [value] => 49321,40971,38308 [value_name] => ) ) ) [include_child_variations] => 1 )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id LEFT JOIN ?:product_features_values AS pfv_62 ON pfv_62.product_id = products.product_id AND pfv_62.feature_id = 62 WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (31750)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND pfv_62.variant_id NOT IN (49321,40971,38308)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 31750 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => categories [value] => 274,275,276,277,278,281,282,284,285,287,288,290,296,432,508,579,620,621,745,1011,1096,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1214,1215,1216,1217,1218,1238,1270,1364,1632,1648,1703,1704,1977,2040,2116,2117,2118,2141,2191,2242,2250,2251,2322,2366,2421,2437,2439,2440,2444,2445,2456,2457,2458,2465,2468,2469,2472,2474,2476,2477,2481,2483,2485,2486,2489,2492,2497,2498,458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (31750)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 1648, 274, 275, 276, 277, 278, 281, 282, 284, 285, 287, 288, 290, 296, 432, 2662, 508, 579, 1632, 620, 621, 745, 1011, 1096, 1218, 1153, 1154, 1155, 1156, 1157, 1158, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1214, 1215, 1216, 1217, 1238, 1270, 1364, 1704, 1703, 1977, 2040, 2116, 2117, 2118, 2141, 2191, 2242, 2661, 2250, 2251, 2488, 2421, 2322, 2366, 2656, 2437, 2438, 2439, 2440, 2645, 2659, 2444, 2445, 2663, 2658, 2654, 2453, 2643, 2644, 2456, 2457, 2458, 2653, 2651, 2652, 2463, 2465, 2640, 2468, 2469, 2649, 2650, 2472, 2473, 2474, 2646, 2476, 2477, 2648, 2684, 2481, 2660, 2642, 2483, 2485, 2486, 2489, 2647, 2641, 2492, 2494, 2655, 2497, 2498, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 31750 [limit] => 1 [total] => 1 [custom_extend] => Array ( [0] => product_name [1] => categories ) [load_products_extra_data] => [force_virtual] => 1 [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => categories [value] => 458,1186,2438,2453,2463,2473,2488,2494,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 1 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
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 ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND ((1 AND products.product_id IN (31750)) AND (companies.status IN ('A') OR products.company_id = 0) AND products.company_id IN (13, 0)) AND products.master_product_status IN ('A') AND (1 AND products_categories.category_id IN (458, 2662, 1186, 2661, 2488, 2656, 2438, 2645, 2659, 2663, 2658, 2654, 2453, 2643, 2644, 2653, 2651, 2652, 2463, 2640, 2649, 2650, 2473, 2646, 2648, 2684, 2660, 2642, 2647, 2641, 2494, 2655, 2657, 2664, 2666, 2665, 2667, 2668, 2669, 2670, 2671, 2672, 2673, 2674, 2675, 2676, 2677, 2678, 2679, 2680, 2681, 2682, 2683)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 1
before end of oxn
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
Array ( [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Fabeato ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [features_hash] => 28-20891 [items_per_page] => 12 [sl] => en [dispatch] => categories.view [category_id] => 2421 [page] => 4 [save_view_results] => product_id [sort_by] => bestsellers [sort_order] => desc [extend] => Array ( [0] => categories [1] => description [2] => description [3] => full_description ) [subcats] => Y [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006 ) ) ) )
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_features_values as var_val_73 ON var_val_73.product_id = products.product_id AND var_val_73.lang_code = 'en' AND var_val_73.feature_id = 73 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 (var_val_73.variant_id IN (20891)) 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) AND (1 AND products.product_id IN (6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 36, 12
before end of oxn
Array ( [8110] => Array ( [product_id] => 8110 [product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES25 [hsn_code] => 3304 [status] => A [list_price] => 930.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 781.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>For Barbeque Almonds, our Nutty Kitchen Chefs dry roast big chunks of California almonds with a blend of exotic barbeque spices. The result is a flavourful, playful and delightful combination of joy and all smiles. They undergo a special dry roasting process in the Nutty Kitchen with a blend of our special exotic barbeque spices, a hint of paprika and zero oil. Packed in their whole, barbequed, skin-on avatars, they have a crunchy texture with undernotes of barbequed goodness. Barbeque Almonds are a powerhouse of nutrition those chunks arent just big in size; they are big on health too. Each handful serving portion packs 6.2 g of protein, 12 g of good fat, and a good amount of magnesium, calcium, iron and Vitamin E.</p> [category_ids] => Array ( [0] => 1238 [1] => 2641 ) [seo_name] => barbeque-almonds-bbq-healthy-party-snack-dry-roasted-non-fried-zero-oil-crunchy-tasty-200g-pack-of-2 [seo_path] => 458/2640/2641 [average_rating] => 5.00 [reviews_count] => 1 [main_category] => 2641 [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] => Nutty Gritties [ratting_count] => 1 ) [8118] => Array ( [product_id] => 8118 [product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES33 [hsn_code] => 3304 [status] => A [list_price] => 830.00 [amount] => 196 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 697.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>ORIGIN- Premium Mixed Berries coming all the way from the USA. APPEARANCE- mixed blend of dried strawberries, black currants, blueberries and cranberries. TEXTURE- smooth and easily chewable. HOW TO USE- Our nutritionists recommend on having a handful of Mixed Berries. You can have it kill your sweet tooth cravings or even use it as a dressing on your salad bowl.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => mix-berries-dried-cranberries-blueberries-strawberries-black-currants-healthy-snack-for-kids-and-adults-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8121] => Array ( [product_id] => 8121 [product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES36 [hsn_code] => 3304 [status] => A [list_price] => 540.00 [amount] => 183 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 448.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Nutty Gritties Super Seeds Mix is a combination of Roasted Seeds - Flaxseeds(10%), Chia seeds(10%), Sesame seeds(10%), Sunflower seeds (25%), Watermelon seeds(25%) and Pumpkin seeds (20%). Our Super Seeds Mix is a delectable mix of Pumpkin Seeds, Chia Seeds, Sesame Seeds, Sunflower Seeds, Watermelon Seeds, Flax Seeds, all roasted at a minimal temperature to give you just the right amount of crunch! Snack on them at any time or add them to salads, yogurts, ice creams to get an added boost of nutrition and fibre. Nutty Gritties is working since 2009 for Premium Nuts and Dry Fruits and we are into this trade since 1887"</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => super-seeds-mix-roasted-flax-chia-sesame-sunflower-watermelon-pumpkin-seeds-mixed-seeds-200g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.50 [reviews_count] => 2 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 2 ) [8123] => Array ( [product_id] => 8123 [product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES38 [hsn_code] => 3304 [status] => A [list_price] => 700.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 588.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => moms-superfood-mix-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8125] => Array ( [product_id] => 8125 [product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES40 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 190 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 655.700000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => premium-dates-omani-500g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 5 ) [8139] => Array ( [product_id] => 8139 [product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES54 [hsn_code] => 3304 [status] => A [list_price] => 450.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 378.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => sports-mix-roasted-almonds-cashews-pistachios-dried-blueberries-cranberries-and-raisins-pack-of-6-x-30g-each-180g [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8147] => Array ( [product_id] => 8147 [product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES62 [hsn_code] => 3304 [status] => A [list_price] => 800.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 672.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => mixed-dry-fruits-and-seeds-combo-400g-moms-superfood-mix-sports-mix-200g-each [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8639] => Array ( [product_id] => 8639 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33007 [hsn_code] => 3304 [status] => A [list_price] => 395.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 327.850000 [short_description] => <p>Rich in dietary fiber & wonderful for both adults & kids</p> [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-200-g [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8640] => Array ( [product_id] => 8640 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33008 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 655.700000 [short_description] => Energy-boosting snack for adults & kids [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-400-g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG301 [hsn_code] => 3304 [status] => A [list_price] => 3200.00 [amount] => 129 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1654706987 [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] => 2592.000000 [short_description] => <p>For daily nutrition</p> [full_description] => <p>This product is highly rich in energy, protein and dietary fibre. Grab a handful to fulfill your daily essential nutritional requirements.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => california-almonds-for-essential-nutritional-requirements-2-kg [seo_path] => 458/2646/2648 [average_rating] => 4.87 [reviews_count] => 23 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 23 ) [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Fabeato_All Nuts [hsn_code] => 3304 [status] => A [list_price] => 1750.00 [amount] => 10000 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1688363880 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => [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] => 1175.000000 [short_description] => Rich in protein & fibre [full_description] => <p>Almonds are popularly considered “brain food.” Healthy levels of vitamin E (found in almonds) have been shown to maintain the health and alertness of the Brain.Cashews also contain a variety of vitamins, minerals, and health-protective beneficial plant compounds. Good for an active lifestyle perfect for daily routine<br />The premium California pistachios are delicately salted and oven-roasted for the best crispy texture, making them absolutely delectable for your taste buds<br />The walnuts are a good source of vegan omega-3 fat, which help reduce heart disease risk. Rich source of energy as it has got all the minerals, nutrients, antioxidants & vitamin.<br />Premium seedless Afghani Black Raisins that are famous for their sweetness as a ready to go snack. Imported from Afghanistan, these raisins are plump, luscious and flavoursome. You are going to relish each and every bite of it.<br />Nuts and dry fruits are considered to be amongst one of the healthy snacking options. Use it as a festive gift hamper or everyday snacking delight.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => dry-fruits-and-nuts-combo-pack-of-5-200gm-each [seo_path] => 458/2646/2648 [average_rating] => 4.00 [reviews_count] => 1 [main_category] => 2648 [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] => Fabeato [ratting_count] => 1 ) )
Array ( [8110] => Array ( [product_id] => 8110 [product] => Barbeque Almonds, Dry Roasted Non Fried and Zero Oil - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES25 [hsn_code] => 3304 [status] => A [list_price] => 930.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 781.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>For Barbeque Almonds, our Nutty Kitchen Chefs dry roast big chunks of California almonds with a blend of exotic barbeque spices. The result is a flavourful, playful and delightful combination of joy and all smiles. They undergo a special dry roasting process in the Nutty Kitchen with a blend of our special exotic barbeque spices, a hint of paprika and zero oil. Packed in their whole, barbequed, skin-on avatars, they have a crunchy texture with undernotes of barbequed goodness. Barbeque Almonds are a powerhouse of nutrition those chunks arent just big in size; they are big on health too. Each handful serving portion packs 6.2 g of protein, 12 g of good fat, and a good amount of magnesium, calcium, iron and Vitamin E.</p> [category_ids] => Array ( [0] => 1238 [1] => 2641 ) [seo_name] => barbeque-almonds-bbq-healthy-party-snack-dry-roasted-non-fried-zero-oil-crunchy-tasty-200g-pack-of-2 [seo_path] => 458/2640/2641 [average_rating] => 5.00 [reviews_count] => 1 [main_category] => 2641 [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] => Nutty Gritties [ratting_count] => 1 ) [8118] => Array ( [product_id] => 8118 [product] => Mix Berries - Dried Cranberries, Blueberries, Strawberries, Black Currants - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES33 [hsn_code] => 3304 [status] => A [list_price] => 830.00 [amount] => 196 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 697.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>ORIGIN- Premium Mixed Berries coming all the way from the USA. APPEARANCE- mixed blend of dried strawberries, black currants, blueberries and cranberries. TEXTURE- smooth and easily chewable. HOW TO USE- Our nutritionists recommend on having a handful of Mixed Berries. You can have it kill your sweet tooth cravings or even use it as a dressing on your salad bowl.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => mix-berries-dried-cranberries-blueberries-strawberries-black-currants-healthy-snack-for-kids-and-adults-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8121] => Array ( [product_id] => 8121 [product] => Super Seeds Mix - Roasted - Flax, Chia, Sesame, Sunflower, Watermelon, Pumpkin Seeds - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES36 [hsn_code] => 3304 [status] => A [list_price] => 540.00 [amount] => 183 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 448.200000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Nutty Gritties Super Seeds Mix is a combination of Roasted Seeds - Flaxseeds(10%), Chia seeds(10%), Sesame seeds(10%), Sunflower seeds (25%), Watermelon seeds(25%) and Pumpkin seeds (20%). Our Super Seeds Mix is a delectable mix of Pumpkin Seeds, Chia Seeds, Sesame Seeds, Sunflower Seeds, Watermelon Seeds, Flax Seeds, all roasted at a minimal temperature to give you just the right amount of crunch! Snack on them at any time or add them to salads, yogurts, ice creams to get an added boost of nutrition and fibre. Nutty Gritties is working since 2009 for Premium Nuts and Dry Fruits and we are into this trade since 1887"</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => super-seeds-mix-roasted-flax-chia-sesame-sunflower-watermelon-pumpkin-seeds-mixed-seeds-200g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.50 [reviews_count] => 2 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 2 ) [8123] => Array ( [product_id] => 8123 [product] => Mom's Superfood Mix, Roasted Seeds, Berries and Nuts Mix - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES38 [hsn_code] => 3304 [status] => A [list_price] => 700.00 [amount] => 200 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 588.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => moms-superfood-mix-200g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8125] => Array ( [product_id] => 8125 [product] => Omani Dates, Khajoor - 1kg (2 Pack of 500g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES40 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 190 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 655.700000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, Crunchy and Sweetrich in Protein, with almost 20 g of protein in 100 g, which helps in building muscle and strength.<br />Rich in Healthy Fats or Monounsaturated Fats - help in regulating blood sugar and heart health.<br />Rich in Vitamin E, which builds the body's immune system and helps to fight viral infections.<br />Traditionally eaten in the morning after being soaked overnight, along with other nuts like walnuts. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => premium-dates-omani-500g-pack-of-2 [seo_path] => 458/2646/2648 [average_rating] => 4.80 [reviews_count] => 5 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 5 ) [8139] => Array ( [product_id] => 8139 [product] => Sports Mix, Roasted Almonds, Cashews, Pistachios, Dried Blueberries, Cranberries and Raisins - 180g (6 Pack of 30g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES54 [hsn_code] => 3304 [status] => A [list_price] => 450.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 378.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => sports-mix-roasted-almonds-cashews-pistachios-dried-blueberries-cranberries-and-raisins-pack-of-6-x-30g-each-180g [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8147] => Array ( [product_id] => 8147 [product] => Mixed Dry Fruits, Mom's Superfood Mix + Sports Mix Combo - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NUTTYGRITTIES62 [hsn_code] => 3304 [status] => A [list_price] => 800.00 [amount] => 198 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1646742743 [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] => 672.000000 [short_description] => Full of antioxidants & boost energy. [full_description] => <p>"Taste- Fresh, crunchy with a mix of a nutty and sweet texture.High in dietary fiber- approx 11g in 100g. Improves your digestive health by preventing constipation.<br />Energy-boosting snack, These are a powerhouse of omega-3, omega-6 fatty acids, and anti-oxidants that increase energy levels.<br />Rich source of protein (19g in 100g ): Plant-based protein which provides essential amino acids that helps with metabolism, helps eliminate toxins and supports heart health.<br />A great snack to have before or after a workout, a yoga session or even playing sports like cricket, basketball, etc. Healthy Natural Nuts, Rich in vitamins, Immunity builder, Full of vitamins"</p> [category_ids] => Array ( [0] => 2647 ) [seo_name] => mixed-dry-fruits-and-seeds-combo-400g-moms-superfood-mix-sports-mix-200g-each [seo_path] => 458/2646/2647 [main_category] => 2647 [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] => Nutty Gritties ) [8639] => Array ( [product_id] => 8639 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 200g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33007 [hsn_code] => 3304 [status] => A [list_price] => 395.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 327.850000 [short_description] => <p>Rich in dietary fiber & wonderful for both adults & kids</p> [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-200-g [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [8640] => Array ( [product_id] => 8640 [product] => 4PM Nut Mix, Dry-Roasted with Himalayan Pink Salt - 400g (2 Pack of 200g each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG33008 [hsn_code] => 3304 [status] => A [list_price] => 790.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648107933 [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] => 655.700000 [short_description] => Energy-boosting snack for adults & kids [full_description] => <p>Our unique roasting process is done without using a single drop of oil which keeps the nuts fresh, tasty and crunchy! A rich source of protein for both kids and adults. Protein is important for the growth of bones, muscles and it boosts metabolism. Rich source of magnesium, good fats, and fiber. Lowers your cholesterol levels.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => 4pm-nut-trail-mix-salted-roasted-with-himalayan-pink-salt-400-g-pack-of-2 [seo_path] => 458/2646/2648 [main_category] => 2648 [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] => Nutty Gritties ) [12049] => Array ( [product_id] => 12049 [product] => California Almonds for essential nutritional requirements - Pack of 2 - 1 kg each [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 61 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NG301 [hsn_code] => 3304 [status] => A [list_price] => 3200.00 [amount] => 129 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1654706987 [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] => 2592.000000 [short_description] => <p>For daily nutrition</p> [full_description] => <p>This product is highly rich in energy, protein and dietary fibre. Grab a handful to fulfill your daily essential nutritional requirements.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => california-almonds-for-essential-nutritional-requirements-2-kg [seo_path] => 458/2646/2648 [average_rating] => 4.87 [reviews_count] => 23 [main_category] => 2648 [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] => Nutty Gritties [ratting_count] => 23 ) [31750] => Array ( [product_id] => 31750 [product] => Dry Fruits & Nuts Combo - Pack of 5 (200gm each) [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 571 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Fabeato_All Nuts [hsn_code] => 3304 [status] => A [list_price] => 1750.00 [amount] => 10000 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1688363880 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => [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] => 1175.000000 [short_description] => Rich in protein & fibre [full_description] => <p>Almonds are popularly considered “brain food.” Healthy levels of vitamin E (found in almonds) have been shown to maintain the health and alertness of the Brain.Cashews also contain a variety of vitamins, minerals, and health-protective beneficial plant compounds. Good for an active lifestyle perfect for daily routine<br />The premium California pistachios are delicately salted and oven-roasted for the best crispy texture, making them absolutely delectable for your taste buds<br />The walnuts are a good source of vegan omega-3 fat, which help reduce heart disease risk. Rich source of energy as it has got all the minerals, nutrients, antioxidants & vitamin.<br />Premium seedless Afghani Black Raisins that are famous for their sweetness as a ready to go snack. Imported from Afghanistan, these raisins are plump, luscious and flavoursome. You are going to relish each and every bite of it.<br />Nuts and dry fruits are considered to be amongst one of the healthy snacking options. Use it as a festive gift hamper or everyday snacking delight.</p> [category_ids] => Array ( [0] => 2648 ) [seo_name] => dry-fruits-and-nuts-combo-pack-of-5-200gm-each [seo_path] => 458/2646/2648 [average_rating] => 4.00 [reviews_count] => 1 [main_category] => 2648 [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] => Fabeato [ratting_count] => 1 ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 8110 [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 = 8110 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] => 8118 [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 = 8118 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] => 8121 [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 = 8121 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] => 8123 [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 = 8123 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] => 8125 [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 = 8125 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] => 8139 [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 = 8139 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] => 8147 [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 = 8147 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] => 8639 [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 = 8639 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] => 8640 [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 = 8640 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] => 12049 [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 = 12049 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] => 31750 [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 = 31750 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 [check_location] => 1 [process_empty_items] => 1 [dispatch] => categories.view [category_id] => 2421 [features_hash] => 28-20891 [block_data] => Array ( [grid_id] => 2219 [block_id] => 59 [content] => Array ( [items] => Array ( [filling] => manually [item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36 ) ) [object_id] => 0 [object_type] => [object_ids] => 1741 [snapping_id] => 3364 [wrapper] => blocks/wrappers/sidebox_important.tpl [user_class] => prod-filters [order] => 1 [status] => A [type] => product_filters [properties] => Array ( [template] => blocks/product_filters/for_category/original.tpl ) [company_id] => 0 [storefront_id] => 1 [lang_code] => en [name] => Filters [items_array] => Array ( [0] => 1741 ) [items_count] => 1 [availability] => Array ( [app] => 1 [phone] => 1 [tablet] => 1 [desktop] => 1 ) ) [storefront_id] => 1 [filter_item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36 [split_filters] => 1 [variant_filter] => [get_conditions] => 1 [custom_extend] => Array ( [0] => categories ) [subcats] => Y [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006 ) ) ) )
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
Array ( [show_master_products_only] => [area] => C [check_location] => 1 [process_empty_items] => 1 [dispatch] => categories.view [category_id] => 2421 [features_hash] => [block_data] => Array ( [grid_id] => 2219 [block_id] => 59 [content] => Array ( [items] => Array ( [filling] => manually [item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36 ) ) [object_id] => 0 [object_type] => [object_ids] => 1741 [snapping_id] => 3364 [wrapper] => blocks/wrappers/sidebox_important.tpl [user_class] => prod-filters [order] => 1 [status] => A [type] => product_filters [properties] => Array ( [template] => blocks/product_filters/for_category/original.tpl ) [company_id] => 0 [storefront_id] => 1 [lang_code] => en [name] => Filters [items_array] => Array ( [0] => 1741 ) [items_count] => 1 [availability] => Array ( [app] => 1 [phone] => 1 [tablet] => 1 [desktop] => 1 ) ) [storefront_id] => 1 [filter_item_ids] => 19,18,16,17,25,26,30,31,32,33,28,21,34,35,36 [split_filters] => 1 [variant_filter] => [get_conditions] => 1 [custom_extend] => Array ( [0] => categories ) [subcats] => Y [runtime_company_id] => 0 [vr_company_id] => 0 [is_virtual] => Y [virtual_conditions] => Array ( [set] => all [set_value] => 1 [conditions] => Array ( [1] => Array ( [operator] => in [condition] => products [value] => 6720,6726,6731,6744,16291,16304,18186,26020,26023,26214,31192,31750,35142,35143,35144,35145,35146,35147,35781,35782,37151,38147,38148,38149,38150,38151,38152,38153,38154,38155,38156,2334,2335,2336,2337,2338,2341,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2354,2355,2356,2358,2359,2360,2361,2362,2363,2425,2446,2447,2448,2449,2535,2536,2538,3462,3463,3474,3485,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4758,4768,4966,6853,6854,6855,6856,6857,7807,7808,8086,8087,8088,8089,8090,8091,8092,8093,8094,8095,8096,8097,8098,8099,8100,8101,8102,8103,8104,8105,8106,8107,8108,8109,8110,8111,8112,8113,8114,8115,8116,8117,8118,8119,8120,8121,8122,8123,8124,8125,8126,8127,8128,8129,8130,8131,8132,8133,8134,8135,8136,8137,8138,8139,8140,8141,8142,8143,8144,8145,8146,8147,8148,8149,8150,8151,8152,8153,8154,8155,8156,8157,8158,8639,8640,9242,9243,9244,9245,9246,9247,9248,12049,15140,15141,15142,15143,15144,15145,15146,15147,15148,15149,15150,15151,15152,15153,15154,15155,15156,15157,15158,15159,15160,15161,15162,15163,15480,18835,18836,18837,18838,18839,18840,18841,18842,18843,18844,18845,18846,18847,18848,23387,23388,23389,36447,36554,36555,36556,36557,36558,36559,36560,36561,36562,36563,36564,36565,36566,36567,36568,36569,36570,36571,38985,39006 ) ) ) )
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
KLOVE | Extra 5% off on all Kbeauty orders above ₹999
SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+
SUNKISS5 | Extra 5% off on orders ₹999+