1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 30955
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 ?: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 ?:product_required_products.product_id = 30955 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 30955
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [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
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (30955)) 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
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 30955
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [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
    )
    
    
  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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (30955)) 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
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 30955
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [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
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (30955)) 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
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [pid] => 30955
        [limit] => 1
        [total] => 1
        [custom_extend] => Array
            (
                [0] => product_name
                [1] => categories
            )
    
        [load_products_extra_data] => 
        [force_virtual] => 1
        [runtime_company_id] => 13
        [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
                            )
    
                    )
    
            )
    
    )
    
    
  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] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 (30955)) 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
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    
Bath and Body :: Bath :: Soaps :: Natural Oudh Herbal Soap Bar - 125 gm - Well-Being made easy | Clean Beauty, Healthy Snacks, Wellness brands

Extra 5% off on all Kbeauty orders above ₹999

KLOVE

Copied

KLOVE | Extra 5% off on all Kbeauty orders above ₹999

SUMVIBE10 | Extra 10% off on orders on orders ₹1,999+

SUNKISS5 | Extra 5% off on orders ₹999+

  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
VITMINVEDA: Natural Oudh Herbal Soap Bar - 125 gm
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    
  1. Array
    (
        [show_master_products_only] => 
        [area] => A
        [extend] => Array
            (
                [0] => product_name
            )
    
        [pid] => Array
            (
                [0] => 30955
            )
    
        [group_child_variations] => 
        [skip_rating] => 1
        [sort_by] => null
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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'  WHERE 1  AND companies.status IN ('A') 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)  AND  ((1  AND  products.product_id IN (30955)) AND companies.status IN ('A') AND products.company_id IN (13, 0) AND prices.usergroup_id IN (0)) GROUP BY products.product_id   ORDER BY NULL asc 
    
  1. before end of oxn
    
  2. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  1. Array
    (
        [30955] => Array
            (
                [product_id] => 30955
                [product] => Natural Oudh Herbal Soap Bar - 125 gm
                [company_name] => Roadskye Tradecom Pvt. Ltd.
                [supplier_id] => 562
                [product_type] => P
                [parent_product_id] => 0
                [master_product_offers_count] => 0
                [master_product_id] => 0
                [company_id] => 13
                [product_code] => VMV-SOAP-OUDH
                [hsn_code] => 3304
                [status] => A
                [list_price] => 255.00
                [amount] => 103
                [weight] => 0.000
                [length] => 0
                [width] => 0
                [height] => 0
                [shipping_freight] => 0.00
                [low_avail_limit] => 0
                [timestamp] => 1684946130
                [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] => 204.000000
                [category_ids] => Array
                    (
                        [0] => 2783
                    )
    
                [seo_name] => natural-oudh-herbal-soap-bar-125-gm
                [seo_path] => 2768/2774/2783
                [main_category] => 2783
                [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] => VITMINVEDA
            )
    
    )
    
    
  2. end of fxn
    

Natural Oudh Herbal Soap Bar - 125 gm

Gentle, natural & moisturizing soap bar

Compare

Share

204
255
Save: ₹51 (20%)
i

Price details

  • Maximum retail price incl. of all taxes
    255
  • Total Discount 51
Special Price
204
6
kinders earned

Delivery

Your box of happiness will be shipped in 2-4 business days.
Cash on delivery available on orders above ₹499
100% recyclable packaging
10 Days Return Policy
Available offers
  • Use SUMVIBE10 & Get Flat 10% off on orders above Rs. 1999.
  • Use SUNKISS5 & Get Flat 5% off on orders above Rs. 999.
Details
Features
How to use
Related to watch
Reviews
kindcode

Details

Oudh soap is made with oudh (also known as agarwood), which is a resinous wood that is highly valued for its unique and complex scent. Oudh soap is known for its luxurious and exotic fragrance, as well as its skin-nourishing properties. Oudh soap is often made with natural ingredients that are gentle and nourishing to the skin. It can help moisturise, soothe, and protect the skin. Use it for its skin-nourishing properties, its antioxidant benefits, or its relaxing and grounding aromatherapy benefits, this soap is a great choice for those seeking a truly indulgent and pampering bathing experience.








Read More

Features

Brand:
VITMINVEDA
Key Ingredients:
  • Coconut oil
  • Goat Milk
  • Oudh
Ingredients:
  • Glycerin Soap Base, Goat Milk, Coconut Oil, Almond Oil, Aloe Vera Gel, Fragrance , Colour
For Concerns:
  • Body Odor
  • Dry Skin
kindcode
:
  • Cruelty Free
  • Eco Conscious
  • Toxin Free

Additional Information

Net Content:
Single Unit(s)
Net Weight:
125gm
Expiry or Best Before Date:
Mar-28
Expiry or Best Before Month:
24 Months

Dimensions

Breadth:
8cm
Height:
25cm
Length:
25cm
  1. Array
    (
        [show_master_products_only] => 
        [area] => C
        [for_required_product] => 30955
        [include_child_variations] => 1
        [group_child_variations] => 
        [runtime_company_id] => 13
    )
    
    
  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] => 0
        [apply_disabled_filters] => 
        [load_products_extra_data] => 1
        [storefront] => 
        [company_ids] => 
        [product_id] => 
    )
    
    
  1. Advanced and feature filters
    
  1. before hook
    
  1. after hook
    
  2. C
    
  1. 1
    
  1. before 2nd hook
    
  1. after 2nd hook
    
  1. 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 ?: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 ?:product_required_products.product_id = 30955 GROUP BY products.product_id   ORDER BY ?:product_sales.amount desc, products.product_id ASC 
    
  1. before end of oxn
    
  2. Array
    (
    )
    
    
  1. Array
    (
    )
    
    
  2. end of fxn
    

How to use

Work the soap into a nice lather and apply it to your body and face with your hands. Gently massage it into your skin with a circular motion for about 30 seconds. Make sure you don’t scrub so hard that you irritate the skin.

Related to watch

Reviews

No reviews found

kindcode

  • Cruelty Free

    “Cruelty-Free” is a PETA provided certification to brands which do not conduct product tests on animals prior to sales. Considering the vulnerability of animals and their lack of ability to give consent doesn’t make it ethical to test products meant for human use on them. Hence products that are natural or plant based could be cruelty free only if they have not been tested on animals.

  • Eco Conscious

    Eco-conscious products are safe for the environment and do no harm to it when they are produced, used or disposed of. They produce no pollution and can be reused or recycled.

  • Toxin Free

    Toxin free products indicate that the ingredients used in it do not exist in amounts that are known or proven to be harmful and affect the consumer negatively. It does not always mean that there are no chemicals in it.

VITMINVEDA

Ayurvedic wellness supplements blending ancient herbs and modern science for daily vitality

Shop the Brand

kiki.AI

Hi, I am kiki.AI, unlock your gateway to global beauty and health with AI-powered insights.

Compare with similar items

Similar Products

Recently viewed

Server

Request

Config

SQL

Cache queries

Logging

Templates

Blocks