Array ( [show_master_products_only] => [area] => C [items_per_page] => 12 [sl] => en [dispatch] => categories.view [category_id] => 2209 [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 ( [2] => Array ( [operator] => in [condition] => products [value] => 1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 24 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (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 (1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 12
before end of oxn
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN5 [hsn_code] => 2106 [status] => A [list_price] => 350.00 [amount] => 293 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648624583 [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] => 315.000000 [short_description] => Grandma's Kadha -Ayurvedic Kadha Natural Immunity Booster [full_description] => <p>Wellbeing Nutrition grandmas kadha is a concentrated, hot water soluble herbal preparation of 13 carfuly selected organic ayurvedic tested medicinal herbs used over centuries.Rooted in the trusted science of Ayurveda, Kadha (Herbal Detox Tea) is considered to be one of the oldest and most potent forms of medicine for various ailments. Kadha is a combination of an Ayurvedic Herbal Tea consisting of Tulsi Tea, Turmeric Tea, Ginger Tea, Ayurvedic Tea and Immunity Tea which will boost your immunity and help in fighting seasonal infections.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => grandmas-kadha-ayurvedic-tea-15-tabs [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WNSHILO [hsn_code] => 3304 [status] => A [list_price] => 1199.00 [amount] => 1 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705576983 [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] => 1079.100000 [short_description] => Pure & Original Himalayan Shilajit Resin 20g for Strength, Stamina & Performance | Shilajit Resin for Men & Women with 75% Fulvic Acid & 85 Trace Minerals | Lab Tested [full_description] => <p>Known as the 'destroyer of weakness,' Shilajit is a natural and classical Ayurvedic remedy. Sourced from 18,000 feet of the Annapurna Range of the Himalayas, our pure Shilajit resin is India's 1st clinically researched Shilajit. It is crafted from carefully selected golden brown rocks harvested from the pristine heights of the Annapurna range in the Himalayas, soaring 18,000 feet above sea level. The Annapurna range is a little gem located in the middle of the Himalayas. It's pristine & untouched with the least cultivation - making our Shilajit purer! <br />Its unparalleled potency can be attributed to its unspoiled geological origins and rich chemical composition. Enriched with essential minerals, fulvic acid, humic acid, and more, it stands as a 100% pure Himalayan Shilajit resin, a dependable source of vitality for both men and women. Experience the power of our Pure Himalayan Shilajit, guaranteed to provide you with a potent 75% Fulvic Acid concentration & 85 trace minerals. This essential component is renowned for boosting your energy, Increasing endurance, and elevating your vitality to new heights. </p> <p>Our natural Shilajit resin is a treasured extract for those seeking increased stamina and ageless well-being in its unadulterated form. Meticulously fashioned through the natural decomposition of plants and microbes over centuries, it encapsulates the timeless wisdom of nature. Regular consumption builds stamina, improves performance, and boosts vigor in as less as 6-8 weeks. </p> <p>The best part? It has a delightful blend of saffron, cinnamon, and cardamom, expertly combined to enchant your senses with their captivating aromas and make every sip an utterly enjoyable experience. Embark on a journey to discover the liquid Shilajit, a genuine Himalayan treasure, and unlock the full potential of YOU.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => pure-and-original-himalayan-shilajit-resin-20g [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [31617] => Array ( [product_id] => 31617 [product] => Unroasted Arabica Green Coffee Bean Powder - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 582 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NVINGP01 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 8 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1687456414 [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] => 474.050000 [short_description] => Reduces hunger pangs & helps control weight [full_description] => <p>Natural raw green coffee bean extract powder is the purest form of green coffee which incorporates abundant of advantages that can help combat obesity by reducing the fat accumulated in the body. The key ingredient – ‘Green coffee’, in pure green coffee bean extract helps the consumer to attain a perfect shape; moreover, it reduces hunger pangs thereby controlling you to stuff yourself from junks or unnecessary eating. This product is infused with all the natural goodness of chlorogenic acid which acts as an effective weight management supplement.</p> [category_ids] => Array ( [0] => 1180 [1] => 2680 ) [seo_name] => unroasted-arabica-green-coffee-bean-powder-100gm [seo_path] => 2669/2670/2680 [main_category] => 2680 [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] => Nirvasa ) [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH6 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 40 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Aromatic Vanilla pods infused in single-estate Arabica [full_description] => <p>Aromatic Vanilla flavours, well-rounded coffee taste, and a rich creamy texture that only pure Vanilla can provide. Made by infusing pure, Grade A Vanilla Bean in AA+ Grade, single-estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-french-vanilla-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [14346] => Array ( [product_id] => 14346 [product] => Gift Set - Set of 1 Scented Candle, 1 Tea and 1 Cookie Tin [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 190 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => GFT6 [hsn_code] => 3304 [status] => A [list_price] => 2300.00 [amount] => 9 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1658298733 [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] => 2185.000000 [short_description] => [full_description] => <p>Unwind and indulge with our handpicked gift for a cosy night in from organic infusion to cookies and artisan candles. The box comes with Sükoons tea tin, cookie tin and candle. Includes: <br />120 Grams cookies<br />50 Grams loose tea<br />200 Grams scented candle</p> [category_ids] => Array ( [0] => 438 [1] => 2644 ) [seo_name] => gift-set-set-of-1-scented-candle-1-tea-and-1-cookie-tin [seo_path] => 458/2643/2644 [main_category] => 2644 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 5 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Sukoon ) [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Vanalaya07 [hsn_code] => 3304 [status] => A [list_price] => 399.00 [amount] => 0 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1626837296 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => activity [buy_now_url] => [is_stock_split_by_warehouses] => N [master_product_status] => A [youtube_link] => [show_youtube_video] => Y [replace_main_image] => [position_youtube] => [restrict_cod] => N [price] => 379.050000 [short_description] => Expiry Date: 01-06-2025 [full_description] => <p>It has a sweet aromatic flavor with nutty notes of roasted hazelnut. The rich nutty flavor combined with a light hazelnut aroma creates moments to savor with every single-serving cup.</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => turkish-hazelnut-instant-coffee-50gm [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Vanalaya ) [4944] => Array ( [product_id] => 4944 [product] => Organic Japanese Ceremonial Matcha Green Tea - 20 Effervescent Tablets [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN30 [hsn_code] => 2106 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639072424 [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] => 449.100000 [short_description] => Provides a healthy, tasty boost. [full_description] => <p>Wellbeing Nutrition best Japanese Ceremonial Matcha Green Tea and Matcha iced tea. Organic Matcha Green Tea is the most powerful and potent antioxidant while also being natureÕs healthiest energy drink. Sourced in small batches from Uji, Japan, only the best, organically grown Tencha Green Tea Leaves are stone-ground to preserve maximum potency, antioxidant benefits and purity. Our Matcha tea effervescent has 137x more antioxidants and 10x more power than regular green tea and is a powerful immunity booster, helps with fat burn, Boosts metabolism, Focus & Energy and Radiant Skin. Our Matcha Green tea is the best natural skin glow tonic. Comes in a smooth and delicious Matcha Green Apple Mint flavour,</p><br />Products will be shipped with in a week. [category_ids] => Array ( [0] => 2644 ) [seo_name] => organic-japanese-ceremonial-matcha-green-tea-20-effervescent-tablets [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [5086] => Array ( [product_id] => 5086 [product] => Roasted Coffee: Original Custom Roast - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH1 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 48 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Balanced taste, body [full_description] => <p>CohomaÕs signature roast that delivers a balanced cup with a bold, rich taste and a dark chocolate-biscuity finish. Made from 100% AA-AAA Grade, single estate Arabica, shade-grown at 5000 ft. above sea-level. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer. Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option below to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => roasted-coffee-original-custom-roast-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5087] => Array ( [product_id] => 5087 [product] => Original Bold - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH2 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Flavourful cup & lingering aftertaste! [full_description] => <p>A bold, flavourful coffee that delivers a strong punch of coffee in each sip and a lingering aftertaste. Notes of dark chocolate, nut, and hints of caramel. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-bold-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5088] => Array ( [product_id] => 5088 [product] => Original Intense - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH3 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Full-bodied. Low Acidity [full_description] => <p>An intense coffee drinking experience that will engulf your senses, our Original: Intense is a dark roast that brews a heavy bodied cup with low acidity. This fresh roasted coffee has distinct notes of bakerÕs chocolate with nutty and spiced undertones that stay on your palate. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-intense-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5089] => Array ( [product_id] => 5089 [product] => Original Mellow - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH4 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Easy-to-sip. Bright & Fruity. [full_description] => <p>An easy-going brew that you can enjoy at leisure. Made from sun-dried, 100% A+ Grade Arabica coffee. Savour each sip with notes of lime, citrus, and vanilla bean. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-mellow-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5090] => Array ( [product_id] => 5090 [product] => Natural Cinnamon Hazelnut - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH5 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Sri-Lankan Cinnamon, Hazelnut infused in AA+ Grade Arabica. [full_description] => <p>A strong punch of Cinnamon, rounded coffee taste that fills the palate, and a mild hazelnut finish. Our Cinnamon Hazelnut is made by infusing pure Sri-Lankan Cinnamon and hints of hazelnut in medium-dark roasted beans. Made with fresh roasted 100% AA-AAA Grade, single estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-cinnamon-hazelnut-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) )
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN5 [hsn_code] => 2106 [status] => A [list_price] => 350.00 [amount] => 293 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648624583 [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] => 315.000000 [short_description] => Grandma's Kadha -Ayurvedic Kadha Natural Immunity Booster [full_description] => <p>Wellbeing Nutrition grandmas kadha is a concentrated, hot water soluble herbal preparation of 13 carfuly selected organic ayurvedic tested medicinal herbs used over centuries.Rooted in the trusted science of Ayurveda, Kadha (Herbal Detox Tea) is considered to be one of the oldest and most potent forms of medicine for various ailments. Kadha is a combination of an Ayurvedic Herbal Tea consisting of Tulsi Tea, Turmeric Tea, Ginger Tea, Ayurvedic Tea and Immunity Tea which will boost your immunity and help in fighting seasonal infections.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => grandmas-kadha-ayurvedic-tea-15-tabs [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WNSHILO [hsn_code] => 3304 [status] => A [list_price] => 1199.00 [amount] => 1 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705576983 [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] => 1079.100000 [short_description] => Pure & Original Himalayan Shilajit Resin 20g for Strength, Stamina & Performance | Shilajit Resin for Men & Women with 75% Fulvic Acid & 85 Trace Minerals | Lab Tested [full_description] => <p>Known as the 'destroyer of weakness,' Shilajit is a natural and classical Ayurvedic remedy. Sourced from 18,000 feet of the Annapurna Range of the Himalayas, our pure Shilajit resin is India's 1st clinically researched Shilajit. It is crafted from carefully selected golden brown rocks harvested from the pristine heights of the Annapurna range in the Himalayas, soaring 18,000 feet above sea level. The Annapurna range is a little gem located in the middle of the Himalayas. It's pristine & untouched with the least cultivation - making our Shilajit purer! <br />Its unparalleled potency can be attributed to its unspoiled geological origins and rich chemical composition. Enriched with essential minerals, fulvic acid, humic acid, and more, it stands as a 100% pure Himalayan Shilajit resin, a dependable source of vitality for both men and women. Experience the power of our Pure Himalayan Shilajit, guaranteed to provide you with a potent 75% Fulvic Acid concentration & 85 trace minerals. This essential component is renowned for boosting your energy, Increasing endurance, and elevating your vitality to new heights. </p> <p>Our natural Shilajit resin is a treasured extract for those seeking increased stamina and ageless well-being in its unadulterated form. Meticulously fashioned through the natural decomposition of plants and microbes over centuries, it encapsulates the timeless wisdom of nature. Regular consumption builds stamina, improves performance, and boosts vigor in as less as 6-8 weeks. </p> <p>The best part? It has a delightful blend of saffron, cinnamon, and cardamom, expertly combined to enchant your senses with their captivating aromas and make every sip an utterly enjoyable experience. Embark on a journey to discover the liquid Shilajit, a genuine Himalayan treasure, and unlock the full potential of YOU.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => pure-and-original-himalayan-shilajit-resin-20g [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [31617] => Array ( [product_id] => 31617 [product] => Unroasted Arabica Green Coffee Bean Powder - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 582 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NVINGP01 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 8 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1687456414 [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] => 474.050000 [short_description] => Reduces hunger pangs & helps control weight [full_description] => <p>Natural raw green coffee bean extract powder is the purest form of green coffee which incorporates abundant of advantages that can help combat obesity by reducing the fat accumulated in the body. The key ingredient – ‘Green coffee’, in pure green coffee bean extract helps the consumer to attain a perfect shape; moreover, it reduces hunger pangs thereby controlling you to stuff yourself from junks or unnecessary eating. This product is infused with all the natural goodness of chlorogenic acid which acts as an effective weight management supplement.</p> [category_ids] => Array ( [0] => 1180 [1] => 2680 ) [seo_name] => unroasted-arabica-green-coffee-bean-powder-100gm [seo_path] => 2669/2670/2680 [main_category] => 2680 [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] => Nirvasa ) [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH6 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 40 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Aromatic Vanilla pods infused in single-estate Arabica [full_description] => <p>Aromatic Vanilla flavours, well-rounded coffee taste, and a rich creamy texture that only pure Vanilla can provide. Made by infusing pure, Grade A Vanilla Bean in AA+ Grade, single-estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-french-vanilla-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [14346] => Array ( [product_id] => 14346 [product] => Gift Set - Set of 1 Scented Candle, 1 Tea and 1 Cookie Tin [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 190 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => GFT6 [hsn_code] => 3304 [status] => A [list_price] => 2300.00 [amount] => 9 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1658298733 [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] => 2185.000000 [short_description] => [full_description] => <p>Unwind and indulge with our handpicked gift for a cosy night in from organic infusion to cookies and artisan candles. The box comes with Sükoons tea tin, cookie tin and candle. Includes: <br />120 Grams cookies<br />50 Grams loose tea<br />200 Grams scented candle</p> [category_ids] => Array ( [0] => 438 [1] => 2644 ) [seo_name] => gift-set-set-of-1-scented-candle-1-tea-and-1-cookie-tin [seo_path] => 458/2643/2644 [main_category] => 2644 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 5 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Sukoon ) [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Vanalaya07 [hsn_code] => 3304 [status] => A [list_price] => 399.00 [amount] => 0 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1626837296 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => activity [buy_now_url] => [is_stock_split_by_warehouses] => N [master_product_status] => A [youtube_link] => [show_youtube_video] => Y [replace_main_image] => [position_youtube] => [restrict_cod] => N [price] => 379.050000 [short_description] => Expiry Date: 01-06-2025 [full_description] => <p>It has a sweet aromatic flavor with nutty notes of roasted hazelnut. The rich nutty flavor combined with a light hazelnut aroma creates moments to savor with every single-serving cup.</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => turkish-hazelnut-instant-coffee-50gm [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Vanalaya ) [4944] => Array ( [product_id] => 4944 [product] => Organic Japanese Ceremonial Matcha Green Tea - 20 Effervescent Tablets [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN30 [hsn_code] => 2106 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639072424 [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] => 449.100000 [short_description] => Provides a healthy, tasty boost. [full_description] => <p>Wellbeing Nutrition best Japanese Ceremonial Matcha Green Tea and Matcha iced tea. Organic Matcha Green Tea is the most powerful and potent antioxidant while also being natureÕs healthiest energy drink. Sourced in small batches from Uji, Japan, only the best, organically grown Tencha Green Tea Leaves are stone-ground to preserve maximum potency, antioxidant benefits and purity. Our Matcha tea effervescent has 137x more antioxidants and 10x more power than regular green tea and is a powerful immunity booster, helps with fat burn, Boosts metabolism, Focus & Energy and Radiant Skin. Our Matcha Green tea is the best natural skin glow tonic. Comes in a smooth and delicious Matcha Green Apple Mint flavour,</p><br />Products will be shipped with in a week. [category_ids] => Array ( [0] => 2644 ) [seo_name] => organic-japanese-ceremonial-matcha-green-tea-20-effervescent-tablets [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [5086] => Array ( [product_id] => 5086 [product] => Roasted Coffee: Original Custom Roast - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH1 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 48 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Balanced taste, body [full_description] => <p>CohomaÕs signature roast that delivers a balanced cup with a bold, rich taste and a dark chocolate-biscuity finish. Made from 100% AA-AAA Grade, single estate Arabica, shade-grown at 5000 ft. above sea-level. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer. Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option below to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => roasted-coffee-original-custom-roast-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5087] => Array ( [product_id] => 5087 [product] => Original Bold - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH2 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Flavourful cup & lingering aftertaste! [full_description] => <p>A bold, flavourful coffee that delivers a strong punch of coffee in each sip and a lingering aftertaste. Notes of dark chocolate, nut, and hints of caramel. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-bold-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5088] => Array ( [product_id] => 5088 [product] => Original Intense - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH3 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Full-bodied. Low Acidity [full_description] => <p>An intense coffee drinking experience that will engulf your senses, our Original: Intense is a dark roast that brews a heavy bodied cup with low acidity. This fresh roasted coffee has distinct notes of bakerÕs chocolate with nutty and spiced undertones that stay on your palate. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-intense-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5089] => Array ( [product_id] => 5089 [product] => Original Mellow - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH4 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Easy-to-sip. Bright & Fruity. [full_description] => <p>An easy-going brew that you can enjoy at leisure. Made from sun-dried, 100% A+ Grade Arabica coffee. Savour each sip with notes of lime, citrus, and vanilla bean. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-mellow-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5090] => Array ( [product_id] => 5090 [product] => Natural Cinnamon Hazelnut - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH5 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Sri-Lankan Cinnamon, Hazelnut infused in AA+ Grade Arabica. [full_description] => <p>A strong punch of Cinnamon, rounded coffee taste that fills the palate, and a mild hazelnut finish. Our Cinnamon Hazelnut is made by infusing pure Sri-Lankan Cinnamon and hints of hazelnut in medium-dark roasted beans. Made with fresh roasted 100% AA-AAA Grade, single estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-cinnamon-hazelnut-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [custom_extend] => Array ( [0] => product_name [1] => categories ) [group_child_variations] => [include_child_variations] => 1 [skip_rating] => 1 [load_products_extra_data] => [sort_by] => null [variation_group_id] => Array ( [386] => 386 ) [get_amount] => 1 [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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_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' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (386) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array ( [9102] => Array ( [product_id] => 9102 [amount] => 293 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [variation_group_id] => 386 [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] => Wellbeing Nutrition ) )
Array ( [9102] => Array ( [product_id] => 9102 [amount] => 293 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [variation_group_id] => 386 [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] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 9102 [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 (9102)) 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] => 9102 [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 (9102)) 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 ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 9102 [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 (9102)) 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 ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 9102 [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 (9102)) 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 ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [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] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 35797 [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 (35797)) 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] => 35797 [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 (35797)) 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 ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
Array ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 35797 [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 (35797)) 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 ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
Array ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 35797 [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 (35797)) 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 ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
Array ( [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Wellbeing Nutrition ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 5091 [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 (5091)) 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] => 5091 [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 (5091)) 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 ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
Array ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 5091 [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 (5091)) 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 ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
Array ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 5091 [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 (5091)) 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 ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
Array ( [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [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] => Cohoma Coffee ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 3302 [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 (3302)) 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] => 3302 [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 (3302)) 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 ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
Array ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 3302 [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 (3302)) 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 ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
Array ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [pid] => 3302 [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 (3302)) 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 ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
Array ( [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Vanalaya ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [items_per_page] => 12 [sl] => en [dispatch] => categories.view [category_id] => 2209 [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 ( [2] => Array ( [operator] => in [condition] => products [value] => 1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759 ) ) ) )
Array ( [area] => C [use_caching] => 1 [extend] => Array ( [0] => product_name [1] => prices [2] => categories ) [custom_extend] => Array ( ) [pname] => [pshort] => [pfull] => [pkeywords] => [feature] => Array ( ) [type] => simple [page] => 1 [action] => [filter_variants] => Array ( ) [features_hash] => [limit] => 0 [bid] => 0 [match] => [tracking] => Array ( ) [get_frontend_urls] => [items_per_page] => 24 [apply_disabled_filters] => [load_products_extra_data] => 1 [storefront] => [company_ids] => [product_id] => )
Advanced and feature filters
before hook
after hook
C
1
before 2nd hook
after 2nd hook
SELECT products.product_id, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, products.product_type, products.parent_product_id, products.master_product_offers_count, products.master_product_id, products.company_id FROM ?:products as products LEFT JOIN ?:product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN ?:product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN ?:companies AS companies ON companies.company_id = products.company_id INNER JOIN ?:products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN ?:categories ON ?:categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) LEFT JOIN ?:supplier_links ON ?:supplier_links.object_id = products.product_id AND ?:supplier_links.object_type = 'P' LEFT JOIN ?:master_products_storefront_offers_count AS master_products_storefront_offers_count ON master_products_storefront_offers_count.product_id = products.product_id AND master_products_storefront_offers_count.storefront_id = 1 LEFT JOIN ?:product_sales ON ?:product_sales.product_id = products.product_id AND ?:product_sales.category_id = products_categories.category_id WHERE 1 AND (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 (1505,2202,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2223,2224,2225,2227,2228,2230,2231,2232,2233,2234,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2263,2264,2265,2266,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2307,2308,2309,2310,2311,2312,2313,2314,2315,2316,2434,2435,2436,2510,2511,2512,2515,2516,3195,3306,3307,3308,3309,3312,3314,3315,4195,4196,4197,4199,4202,4203,4204,4205,4213,4944,5679,5680,5682,5683,6491,7306,7310,8685,9102,9103,9104,9105,10155,12133,12135,12136,12137,12139,12140,12141,12142,12143,12147,12148,12149,12150,12639,12640,12641,12642,12691,12692,12840,12842,12844,12845,13558,13576,14166,14346,14707,14708,14709,14710,14711,14712,14713,14714,14715,14716,14717,14718,14719,14720,14721,14722,14723,14724,14725,14726,14727,14728,16056,16072,16770,16771,16857,16858,16861,16863,16864,16866,16867,16868,16869,16872,16875,16876,16877,16878,16879,16880,16881,16882,17763,17765,17766,17769,17809,17812,17813,17819,17821,18580,18581,19829,19830,19831,21565,21566,21568,21569,21685,21686,21688,21689,27487,27488,27489,27490,27493,29500,29818,29821,29823,29824,29828,33211,33213,33214,33215,33216,33831,33832,33837,34313,34571,34574,34581,34592,35798,2437,2438,2439,2506,2507,2508,2509,2513,2514,2517,2518,2519,2541,3047,3048,3049,3193,3194,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3310,3311,3313,3479,3480,3481,3495,3496,3513,3526,3845,4094,4095,4096,4217,4218,4759,4774,5681,5690,7307,7308,7309,7810,7811,7927,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8684,8686,8892,8893,8894,9190,10156,10157,12134,12138,12144,12145,12146,12841,12843,12846,12847,12848,13557,13559,13560,13561,14163,14164,14165,14662,14663,14664,14665,14666,14667,14668,14669,14670,14671,14672,14673,14674,14675,14676,14677,14678,14679,14680,14681,14682,14683,16059,16862,16865,16870,16871,17768,17770,17810,17811,17814,17815,17816,17817,17818,17820,18825,19249,21094,21567,21687,26803,27491,27492,27494,29819,29820,29822,29825,29826,29827,29829,33212,33824,33825,33826,33827,33828,33829,33830,33833,33834,33835,33836,33838,34020,34021,34312,34314,34567,34568,34569,34570,34572,34573,34575,34576,34577,34578,34579,34580,34582,34583,34584,34585,34586,34587,34588,34589,34590,34591,34593,34594,34595,34596,34597,34598,34599,34600,34604,34605,34606,34607,34608,35797,3299,3300,3301,3302,3303,3304,3305,4214,4765,5086,5087,5088,5089,5090,5091,5092,5093,5094,5095,5096,5097,5098,5099,5100,5101,5102,5103,5104,5839,5840,5841,5842,5843,5844,5845,5846,5847,5848,5849,5850,5851,5852,5853,5854,5855,5856,5857,5858,5859,5860,5861,5862,5863,5864,5865,5866,5867,5868,5869,5870,5871,5872,7416,7417,7418,7928,7929,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8687,8688,8689,8690,8691,11899,11900,11901,14398,16057,16380,16381,16382,16383,16384,16385,16386,16387,16388,16389,16390,16391,16392,16393,16394,16395,16396,16397,16398,16399,16400,16401,16402,16403,16404,16405,16406,16407,16408,16409,16410,16411,16412,16772,16773,16859,16860,16873,16874,17767,17822,18103,24697,24698,24699,25192,25193,25610,26806,31617,32908,32909,32910,32911,32912,32913,32914,32915,32916,32917,32918,32919,35285,35286,35287,35288,35289,35290,35773,17747,17748,17749,17750,17751,17752,17753,17754,17755,17756,17757,17758,17759)) GROUP BY products.product_id ORDER BY ?:product_sales.amount desc, products.product_id ASC LIMIT 0, 12
before end of oxn
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN5 [hsn_code] => 2106 [status] => A [list_price] => 350.00 [amount] => 293 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648624583 [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] => 315.000000 [short_description] => Grandma's Kadha -Ayurvedic Kadha Natural Immunity Booster [full_description] => <p>Wellbeing Nutrition grandmas kadha is a concentrated, hot water soluble herbal preparation of 13 carfuly selected organic ayurvedic tested medicinal herbs used over centuries.Rooted in the trusted science of Ayurveda, Kadha (Herbal Detox Tea) is considered to be one of the oldest and most potent forms of medicine for various ailments. Kadha is a combination of an Ayurvedic Herbal Tea consisting of Tulsi Tea, Turmeric Tea, Ginger Tea, Ayurvedic Tea and Immunity Tea which will boost your immunity and help in fighting seasonal infections.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => grandmas-kadha-ayurvedic-tea-15-tabs [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WNSHILO [hsn_code] => 3304 [status] => A [list_price] => 1199.00 [amount] => 1 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705576983 [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] => 1079.100000 [short_description] => Pure & Original Himalayan Shilajit Resin 20g for Strength, Stamina & Performance | Shilajit Resin for Men & Women with 75% Fulvic Acid & 85 Trace Minerals | Lab Tested [full_description] => <p>Known as the 'destroyer of weakness,' Shilajit is a natural and classical Ayurvedic remedy. Sourced from 18,000 feet of the Annapurna Range of the Himalayas, our pure Shilajit resin is India's 1st clinically researched Shilajit. It is crafted from carefully selected golden brown rocks harvested from the pristine heights of the Annapurna range in the Himalayas, soaring 18,000 feet above sea level. The Annapurna range is a little gem located in the middle of the Himalayas. It's pristine & untouched with the least cultivation - making our Shilajit purer! <br />Its unparalleled potency can be attributed to its unspoiled geological origins and rich chemical composition. Enriched with essential minerals, fulvic acid, humic acid, and more, it stands as a 100% pure Himalayan Shilajit resin, a dependable source of vitality for both men and women. Experience the power of our Pure Himalayan Shilajit, guaranteed to provide you with a potent 75% Fulvic Acid concentration & 85 trace minerals. This essential component is renowned for boosting your energy, Increasing endurance, and elevating your vitality to new heights. </p> <p>Our natural Shilajit resin is a treasured extract for those seeking increased stamina and ageless well-being in its unadulterated form. Meticulously fashioned through the natural decomposition of plants and microbes over centuries, it encapsulates the timeless wisdom of nature. Regular consumption builds stamina, improves performance, and boosts vigor in as less as 6-8 weeks. </p> <p>The best part? It has a delightful blend of saffron, cinnamon, and cardamom, expertly combined to enchant your senses with their captivating aromas and make every sip an utterly enjoyable experience. Embark on a journey to discover the liquid Shilajit, a genuine Himalayan treasure, and unlock the full potential of YOU.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => pure-and-original-himalayan-shilajit-resin-20g [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [31617] => Array ( [product_id] => 31617 [product] => Unroasted Arabica Green Coffee Bean Powder - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 582 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NVINGP01 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 8 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1687456414 [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] => 474.050000 [short_description] => Reduces hunger pangs & helps control weight [full_description] => <p>Natural raw green coffee bean extract powder is the purest form of green coffee which incorporates abundant of advantages that can help combat obesity by reducing the fat accumulated in the body. The key ingredient – ‘Green coffee’, in pure green coffee bean extract helps the consumer to attain a perfect shape; moreover, it reduces hunger pangs thereby controlling you to stuff yourself from junks or unnecessary eating. This product is infused with all the natural goodness of chlorogenic acid which acts as an effective weight management supplement.</p> [category_ids] => Array ( [0] => 1180 [1] => 2680 ) [seo_name] => unroasted-arabica-green-coffee-bean-powder-100gm [seo_path] => 2669/2670/2680 [main_category] => 2680 [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] => Nirvasa ) [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH6 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 40 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Aromatic Vanilla pods infused in single-estate Arabica [full_description] => <p>Aromatic Vanilla flavours, well-rounded coffee taste, and a rich creamy texture that only pure Vanilla can provide. Made by infusing pure, Grade A Vanilla Bean in AA+ Grade, single-estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-french-vanilla-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [14346] => Array ( [product_id] => 14346 [product] => Gift Set - Set of 1 Scented Candle, 1 Tea and 1 Cookie Tin [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 190 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => GFT6 [hsn_code] => 3304 [status] => A [list_price] => 2300.00 [amount] => 9 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1658298733 [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] => 2185.000000 [short_description] => [full_description] => <p>Unwind and indulge with our handpicked gift for a cosy night in from organic infusion to cookies and artisan candles. The box comes with Sükoons tea tin, cookie tin and candle. Includes: <br />120 Grams cookies<br />50 Grams loose tea<br />200 Grams scented candle</p> [category_ids] => Array ( [0] => 438 [1] => 2644 ) [seo_name] => gift-set-set-of-1-scented-candle-1-tea-and-1-cookie-tin [seo_path] => 458/2643/2644 [main_category] => 2644 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 5 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Sukoon ) [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Vanalaya07 [hsn_code] => 3304 [status] => A [list_price] => 399.00 [amount] => 0 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1626837296 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => activity [buy_now_url] => [is_stock_split_by_warehouses] => N [master_product_status] => A [youtube_link] => [show_youtube_video] => Y [replace_main_image] => [position_youtube] => [restrict_cod] => N [price] => 379.050000 [short_description] => Expiry Date: 01-06-2025 [full_description] => <p>It has a sweet aromatic flavor with nutty notes of roasted hazelnut. The rich nutty flavor combined with a light hazelnut aroma creates moments to savor with every single-serving cup.</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => turkish-hazelnut-instant-coffee-50gm [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Vanalaya ) [4944] => Array ( [product_id] => 4944 [product] => Organic Japanese Ceremonial Matcha Green Tea - 20 Effervescent Tablets [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN30 [hsn_code] => 2106 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639072424 [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] => 449.100000 [short_description] => Provides a healthy, tasty boost. [full_description] => <p>Wellbeing Nutrition best Japanese Ceremonial Matcha Green Tea and Matcha iced tea. Organic Matcha Green Tea is the most powerful and potent antioxidant while also being natureÕs healthiest energy drink. Sourced in small batches from Uji, Japan, only the best, organically grown Tencha Green Tea Leaves are stone-ground to preserve maximum potency, antioxidant benefits and purity. Our Matcha tea effervescent has 137x more antioxidants and 10x more power than regular green tea and is a powerful immunity booster, helps with fat burn, Boosts metabolism, Focus & Energy and Radiant Skin. Our Matcha Green tea is the best natural skin glow tonic. Comes in a smooth and delicious Matcha Green Apple Mint flavour,</p><br />Products will be shipped with in a week. [category_ids] => Array ( [0] => 2644 ) [seo_name] => organic-japanese-ceremonial-matcha-green-tea-20-effervescent-tablets [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [5086] => Array ( [product_id] => 5086 [product] => Roasted Coffee: Original Custom Roast - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH1 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 48 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Balanced taste, body [full_description] => <p>CohomaÕs signature roast that delivers a balanced cup with a bold, rich taste and a dark chocolate-biscuity finish. Made from 100% AA-AAA Grade, single estate Arabica, shade-grown at 5000 ft. above sea-level. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer. Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option below to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => roasted-coffee-original-custom-roast-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5087] => Array ( [product_id] => 5087 [product] => Original Bold - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH2 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Flavourful cup & lingering aftertaste! [full_description] => <p>A bold, flavourful coffee that delivers a strong punch of coffee in each sip and a lingering aftertaste. Notes of dark chocolate, nut, and hints of caramel. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-bold-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5088] => Array ( [product_id] => 5088 [product] => Original Intense - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH3 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Full-bodied. Low Acidity [full_description] => <p>An intense coffee drinking experience that will engulf your senses, our Original: Intense is a dark roast that brews a heavy bodied cup with low acidity. This fresh roasted coffee has distinct notes of bakerÕs chocolate with nutty and spiced undertones that stay on your palate. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-intense-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5089] => Array ( [product_id] => 5089 [product] => Original Mellow - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH4 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Easy-to-sip. Bright & Fruity. [full_description] => <p>An easy-going brew that you can enjoy at leisure. Made from sun-dried, 100% A+ Grade Arabica coffee. Savour each sip with notes of lime, citrus, and vanilla bean. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-mellow-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5090] => Array ( [product_id] => 5090 [product] => Natural Cinnamon Hazelnut - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH5 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Sri-Lankan Cinnamon, Hazelnut infused in AA+ Grade Arabica. [full_description] => <p>A strong punch of Cinnamon, rounded coffee taste that fills the palate, and a mild hazelnut finish. Our Cinnamon Hazelnut is made by infusing pure Sri-Lankan Cinnamon and hints of hazelnut in medium-dark roasted beans. Made with fresh roasted 100% AA-AAA Grade, single estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-cinnamon-hazelnut-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) )
Array ( [9102] => Array ( [product_id] => 9102 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN5 [hsn_code] => 2106 [status] => A [list_price] => 350.00 [amount] => 293 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1648624583 [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] => 315.000000 [short_description] => Grandma's Kadha -Ayurvedic Kadha Natural Immunity Booster [full_description] => <p>Wellbeing Nutrition grandmas kadha is a concentrated, hot water soluble herbal preparation of 13 carfuly selected organic ayurvedic tested medicinal herbs used over centuries.Rooted in the trusted science of Ayurveda, Kadha (Herbal Detox Tea) is considered to be one of the oldest and most potent forms of medicine for various ailments. Kadha is a combination of an Ayurvedic Herbal Tea consisting of Tulsi Tea, Turmeric Tea, Ginger Tea, Ayurvedic Tea and Immunity Tea which will boost your immunity and help in fighting seasonal infections.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => grandmas-kadha-ayurvedic-tea-15-tabs [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [35797] => Array ( [product_id] => 35797 [product] => Pure & Original Himalayan Shilajit Resin 20g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WNSHILO [hsn_code] => 3304 [status] => A [list_price] => 1199.00 [amount] => 1 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1705576983 [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] => 1079.100000 [short_description] => Pure & Original Himalayan Shilajit Resin 20g for Strength, Stamina & Performance | Shilajit Resin for Men & Women with 75% Fulvic Acid & 85 Trace Minerals | Lab Tested [full_description] => <p>Known as the 'destroyer of weakness,' Shilajit is a natural and classical Ayurvedic remedy. Sourced from 18,000 feet of the Annapurna Range of the Himalayas, our pure Shilajit resin is India's 1st clinically researched Shilajit. It is crafted from carefully selected golden brown rocks harvested from the pristine heights of the Annapurna range in the Himalayas, soaring 18,000 feet above sea level. The Annapurna range is a little gem located in the middle of the Himalayas. It's pristine & untouched with the least cultivation - making our Shilajit purer! <br />Its unparalleled potency can be attributed to its unspoiled geological origins and rich chemical composition. Enriched with essential minerals, fulvic acid, humic acid, and more, it stands as a 100% pure Himalayan Shilajit resin, a dependable source of vitality for both men and women. Experience the power of our Pure Himalayan Shilajit, guaranteed to provide you with a potent 75% Fulvic Acid concentration & 85 trace minerals. This essential component is renowned for boosting your energy, Increasing endurance, and elevating your vitality to new heights. </p> <p>Our natural Shilajit resin is a treasured extract for those seeking increased stamina and ageless well-being in its unadulterated form. Meticulously fashioned through the natural decomposition of plants and microbes over centuries, it encapsulates the timeless wisdom of nature. Regular consumption builds stamina, improves performance, and boosts vigor in as less as 6-8 weeks. </p> <p>The best part? It has a delightful blend of saffron, cinnamon, and cardamom, expertly combined to enchant your senses with their captivating aromas and make every sip an utterly enjoyable experience. Embark on a journey to discover the liquid Shilajit, a genuine Himalayan treasure, and unlock the full potential of YOU.</p> [category_ids] => Array ( [0] => 620 [1] => 2644 ) [seo_name] => pure-and-original-himalayan-shilajit-resin-20g [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [31617] => Array ( [product_id] => 31617 [product] => Unroasted Arabica Green Coffee Bean Powder - 100gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 582 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => NVINGP01 [hsn_code] => 3304 [status] => A [list_price] => 499.00 [amount] => 8 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1687456414 [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] => 474.050000 [short_description] => Reduces hunger pangs & helps control weight [full_description] => <p>Natural raw green coffee bean extract powder is the purest form of green coffee which incorporates abundant of advantages that can help combat obesity by reducing the fat accumulated in the body. The key ingredient – ‘Green coffee’, in pure green coffee bean extract helps the consumer to attain a perfect shape; moreover, it reduces hunger pangs thereby controlling you to stuff yourself from junks or unnecessary eating. This product is infused with all the natural goodness of chlorogenic acid which acts as an effective weight management supplement.</p> [category_ids] => Array ( [0] => 1180 [1] => 2680 ) [seo_name] => unroasted-arabica-green-coffee-bean-powder-100gm [seo_path] => 2669/2670/2680 [main_category] => 2680 [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] => Nirvasa ) [5091] => Array ( [product_id] => 5091 [product] => Natural French Vanilla - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH6 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 40 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Aromatic Vanilla pods infused in single-estate Arabica [full_description] => <p>Aromatic Vanilla flavours, well-rounded coffee taste, and a rich creamy texture that only pure Vanilla can provide. Made by infusing pure, Grade A Vanilla Bean in AA+ Grade, single-estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-french-vanilla-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [14346] => Array ( [product_id] => 14346 [product] => Gift Set - Set of 1 Scented Candle, 1 Tea and 1 Cookie Tin [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 190 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => GFT6 [hsn_code] => 3304 [status] => A [list_price] => 2300.00 [amount] => 9 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1658298733 [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] => 2185.000000 [short_description] => [full_description] => <p>Unwind and indulge with our handpicked gift for a cosy night in from organic infusion to cookies and artisan candles. The box comes with Sükoons tea tin, cookie tin and candle. Includes: <br />120 Grams cookies<br />50 Grams loose tea<br />200 Grams scented candle</p> [category_ids] => Array ( [0] => 438 [1] => 2644 ) [seo_name] => gift-set-set-of-1-scented-candle-1-tea-and-1-cookie-tin [seo_path] => 458/2643/2644 [main_category] => 2644 [options_type_raw] => P [exceptions_type_raw] => F [tracking_raw] => B [zero_price_action_raw] => R [min_qty_raw] => 0 [max_qty_raw] => 5 [qty_step_raw] => 0 [list_qty_count_raw] => 0 [details_layout_raw] => default [video_as_images] => Array ( ) [videos] => Array ( ) [brand_name] => Sukoon ) [3302] => Array ( [product_id] => 3302 [product] => Turkish Hazelnut Instant Coffee - 50gm [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 698 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => Vanalaya07 [hsn_code] => 3304 [status] => A [list_price] => 399.00 [amount] => 0 [weight] => 50.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1626837296 [updated_timestamp] => 1750246019 [usergroup_ids] => 0 [is_edp] => N [edp_shipping] => N [unlimited_download] => N [tracking] => B [free_shipping] => N [zero_price_action] => R [is_pbp] => N [is_op] => N [is_oper] => N [is_returnable] => Y [return_period] => 10 [avail_since] => 0 [out_of_stock_actions] => N [localization] => [min_qty] => 0 [max_qty] => 5 [qty_step] => 0 [list_qty_count] => 0 [tax_ids] => 13 [age_verification] => N [age_limit] => 0 [options_type] => P [exceptions_type] => F [details_layout] => default [shipping_params] => a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} [facebook_obj_type] => activity [buy_now_url] => [is_stock_split_by_warehouses] => N [master_product_status] => A [youtube_link] => [show_youtube_video] => Y [replace_main_image] => [position_youtube] => [restrict_cod] => N [price] => 379.050000 [short_description] => Expiry Date: 01-06-2025 [full_description] => <p>It has a sweet aromatic flavor with nutty notes of roasted hazelnut. The rich nutty flavor combined with a light hazelnut aroma creates moments to savor with every single-serving cup.</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => turkish-hazelnut-instant-coffee-50gm [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Vanalaya ) [4944] => Array ( [product_id] => 4944 [product] => Organic Japanese Ceremonial Matcha Green Tea - 20 Effervescent Tablets [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => WBN30 [hsn_code] => 2106 [status] => A [list_price] => 499.00 [amount] => 0 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639072424 [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] => 449.100000 [short_description] => Provides a healthy, tasty boost. [full_description] => <p>Wellbeing Nutrition best Japanese Ceremonial Matcha Green Tea and Matcha iced tea. Organic Matcha Green Tea is the most powerful and potent antioxidant while also being natureÕs healthiest energy drink. Sourced in small batches from Uji, Japan, only the best, organically grown Tencha Green Tea Leaves are stone-ground to preserve maximum potency, antioxidant benefits and purity. Our Matcha tea effervescent has 137x more antioxidants and 10x more power than regular green tea and is a powerful immunity booster, helps with fat burn, Boosts metabolism, Focus & Energy and Radiant Skin. Our Matcha Green tea is the best natural skin glow tonic. Comes in a smooth and delicious Matcha Green Apple Mint flavour,</p><br />Products will be shipped with in a week. [category_ids] => Array ( [0] => 2644 ) [seo_name] => organic-japanese-ceremonial-matcha-green-tea-20-effervescent-tablets [seo_path] => 458/2643/2644 [main_category] => 2644 [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] => Wellbeing Nutrition ) [5086] => Array ( [product_id] => 5086 [product] => Roasted Coffee: Original Custom Roast - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH1 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 48 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Balanced taste, body [full_description] => <p>CohomaÕs signature roast that delivers a balanced cup with a bold, rich taste and a dark chocolate-biscuity finish. Made from 100% AA-AAA Grade, single estate Arabica, shade-grown at 5000 ft. above sea-level. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer. Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option below to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => roasted-coffee-original-custom-roast-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5087] => Array ( [product_id] => 5087 [product] => Original Bold - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH2 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Flavourful cup & lingering aftertaste! [full_description] => <p>A bold, flavourful coffee that delivers a strong punch of coffee in each sip and a lingering aftertaste. Notes of dark chocolate, nut, and hints of caramel. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-bold-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5088] => Array ( [product_id] => 5088 [product] => Original Intense - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH3 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 49 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted AA+ Grade Arabica. Full-bodied. Low Acidity [full_description] => <p>An intense coffee drinking experience that will engulf your senses, our Original: Intense is a dark roast that brews a heavy bodied cup with low acidity. This fresh roasted coffee has distinct notes of bakerÕs chocolate with nutty and spiced undertones that stay on your palate. Made with 100% AA-AAA Grade, single estate Arabica. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-intense-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5089] => Array ( [product_id] => 5089 [product] => Original Mellow - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH4 [hsn_code] => 3304 [status] => A [list_price] => 685.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 650.750000 [short_description] => Fresh-roasted single-estate Arabica. Easy-to-sip. Bright & Fruity. [full_description] => <p>An easy-going brew that you can enjoy at leisure. Made from sun-dried, 100% A+ Grade Arabica coffee. Savour each sip with notes of lime, citrus, and vanilla bean. Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Fresh Roasted and available as whole beans or ground for your choice of equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => original-mellow-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) [5090] => Array ( [product_id] => 5090 [product] => Natural Cinnamon Hazelnut - Roasted Coffee - 250g [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 29 [product_type] => P [parent_product_id] => 0 [master_product_offers_count] => 0 [master_product_id] => 0 [company_id] => 13 [product_code] => COH5 [hsn_code] => 3304 [status] => A [list_price] => 795.00 [amount] => 50 [weight] => 0.000 [length] => 0 [width] => 0 [height] => 0 [shipping_freight] => 0.00 [low_avail_limit] => 0 [timestamp] => 1639220205 [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] => 755.250000 [short_description] => Sri-Lankan Cinnamon, Hazelnut infused in AA+ Grade Arabica. [full_description] => <p>A strong punch of Cinnamon, rounded coffee taste that fills the palate, and a mild hazelnut finish. Our Cinnamon Hazelnut is made by infusing pure Sri-Lankan Cinnamon and hints of hazelnut in medium-dark roasted beans. Made with fresh roasted 100% AA-AAA Grade, single estate Arabica. Natural flavour infused - no artificial syrups, powders, or sweeteners! Ships in our reusable, Cohoma Canisters with Fresh Lock valve to keep your coffee fresh for longer! Available in multiple grind sizes for your choice of brewing equipment (E.g., Aeropress, French Press, Pour Over, Espresso Machine, etc.). DonÕt have any brewing equipment? Select the Free PureBrew Filterª option above to add our proprietary, reusable filter that brews a fresh cup in seconds!</p> [category_ids] => Array ( [0] => 2662 ) [seo_name] => natural-cinnamon-hazelnut-roasted-coffee-250g [seo_path] => 458/2643/2662 [main_category] => 2662 [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] => Cohoma Coffee ) )
end of fxn
Array ( [show_master_products_only] => [area] => C [for_required_product] => 9102 [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 = 9102 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] => 35797 [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 = 35797 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] => 31617 [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 = 31617 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] => 5091 [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 = 5091 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] => 14346 [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 = 14346 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] => 3302 [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 = 3302 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] => 4944 [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 = 4944 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] => 5086 [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 = 5086 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] => 5087 [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 = 5087 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] => 5088 [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 = 5088 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] => 5089 [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 = 5089 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] => 5090 [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 = 5090 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 [custom_extend] => Array ( [0] => product_name [1] => categories ) [group_child_variations] => [include_child_variations] => 1 [skip_rating] => 1 [load_products_extra_data] => [sort_by] => null [variation_group_id] => Array ( [386] => 386 ) [get_amount] => 1 [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, products.amount, descr1.product as product, companies.company as company_name, ?:supplier_links.supplier_id, variation_group_products.group_id AS variation_group_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' INNER JOIN ?:product_variation_group_products AS variation_group_products ON variation_group_products.product_id = products.product_id 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 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 variation_group_products.group_id IN (386) AND products.master_product_status IN ('A') AND products.master_product_id = 0 AND (products.company_id > 0 OR master_products_storefront_offers_count.count > 0) GROUP BY products.product_id ORDER BY NULL asc
before end of oxn
Array ( [9102] => Array ( [product_id] => 9102 [amount] => 293 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [variation_group_id] => 386 [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] => Wellbeing Nutrition ) )
Array ( [9102] => Array ( [product_id] => 9102 [amount] => 293 [product] => Grandma's Kadha - Ayurvedic Tea- 15 Tabs [company_name] => Roadskye Tradecom Pvt. Ltd. [supplier_id] => 96 [variation_group_id] => 386 [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] => Wellbeing Nutrition ) )
end of fxn
Cannot create references to/from string offsets
app/Tygh/Registry.php, line: 221
File: | app/Tygh/Registry.php |
Line: | 89 |
Function: | _varByKey |
File: | app/addons/seo/Tygh/SeoCache.php |
Line: | 111 |
Function: | set |
File: | app/addons/seo/Tygh/SeoCache.php |
Line: | 49 |
Function: | setStatic |
File: | app/addons/seo/func.php |
Line: | 1329 |
Function: | set |
File: | app/addons/seo/func.php |
Line: | 1563 |
Function: | fn_seo_get_name |
File: | app/functions/fn.control.php |
Line: | 123 |
Function: | fn_seo_url_post |
File: | app/functions/fn.common.php |
Line: | 3921 |
Function: | fn_set_hook |
File: | app/Tygh/BlockManager/Container.php |
Line: | 496 |
Function: | fn_url |
File: | app/Tygh/BlockManager/Container.php |
Line: | 517 |
Function: | getConfigurationUrl |
File: | app/Tygh/BlockManager/Container.php |
Line: | 120 |
Function: | addBlockManagerProperties |
File: | app/Tygh/BlockManager/RenderManager.php |
Line: | 127 |
Function: | getListByArea |
File: | app/functions/smarty_plugins/function.render_location.php |
Line: | 50 |
Function: | __construct |
File: | var/cache/templates/new_2bk/ab6984b0313df114201bb87fa8c1e79b04bca983.tygh.index.tpl.php |
Line: | 191 |
Function: | smarty_function_render_location |
File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
Line: | 188 |
Function: | content_689464c1dbc0b1_26812820 |
File: | app/Tygh/SmartyEngine/Core.php |
Line: | 81 |
Function: | fetch |
File: | app/functions/fn.control.php |
Line: | 636 |
Function: | fetch |
File: | index.php |
Line: | 39 |
Function: | fn_dispatch |