Минимальная и максимальная цены вариаций

Добрый день.
Нужно вывести в списке товаров для каждого товара минимальную и максимальную цены вариаций. Например: Цена: от 99 до 311 рублей.
{$product|fn_print_r} выводит только цену вариации по умолчанию равную 1139 грн. Максимальная цена вариации 1765 грн.

Код массива

Array
(
[product_id] => 828
[product] => Полотенцесушитель Марио Змейка 30
[popularity] => 1155
[sales_amount] => 1
[amount_now] => 1
[product_code] => 1.1.3000.05.P
[product_type] => C
[status] => A
[company_id] => 1
[list_price] => 1139
[amount] => 10
[weight] => 0.000
[length] => 0
[width] => 0
[height] => 0
[shipping_freight] => 0.00
[low_avail_limit] => 0
[timestamp] => 1502916379
[updated_timestamp] => 1535362164
[usergroup_ids] => 0
[is_edp] => N
[edp_shipping] => N
[unlimited_download] => N
[tracking] => D
[free_shipping] => Y
[zero_price_action] => R
[is_pbp] => N
[is_op] => N
[is_oper] => N
[is_returnable] => Y
[return_period] => 10
[avail_since] => 0
[out_of_stock_actions] => N
[localization] =>
[min_qty] => 0
[max_qty] => 0
[qty_step] => 0
[list_qty_count] => 0
[tax_ids] =>
[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;}
[my_opt_price] => 0.00
[my_opt_price_modif] => 0.000
[my_opt_price_modif_type] => A
[my_opt_price_cur] => UAH
[external_id] =>
[parent] => N
[facebook_obj_type] =>
[parent_product_id] => 0
[variation_code] =>
[variation_options] => [616]
[package] => N
[price_rule] => S
[package_form] => N
[cp_pp_number_of_columns] => 0
[is_default_variation] => N
[price] => 1139
[short_description] =>
[full_description] =>
[meta_keywords] =>
[meta_description] =>
[search_words] =>
[promo_text] =>
[category_ids] => Array
(
[0] => 254
[1] => 281
[2] => 288
[3] => 278
)

[position] => 0
[seo_name] => polotencesushitel-mario-zmeyka-30
[seo_path] => 254/278
[average_rating] => 
[discussion_type] => B
[discussion_thread_id] => 833
[main_category] => 278
[discussion_amount_posts] => 0
[selected_options] => Array
    (
        [616] => 5144
    )

[product_options] => Array
    (
        [616] => Array
            (
                [option_id] => 616
                [product_id] => 828
                [company_id] => 1
                [option_type] => R
                [inventory] => Y
                [regexp] => 
                [required] => N
                [multiupload] => N
                [allowed_extensions] => 
                [max_file_size] => 0
                [missing_variants_handling] => M
                [status] => A
                [position] => 0
                [value] => 5144
                [external_id] => 
                [option_name] => Размер (ВхШ), мм
                [option_text] => 
                [description] => 
                [inner_hint] => 
                [incorrect_message] => 
                [comment] => 
                [variants] => Array
                    (
                        [5144] => Array
                            (
                                [variant_id] => 5144
                                [option_id] => 616
                                [position] => 0
                                [modifier] => 0.000
                                [modifier_type] => A
                                [weight_modifier] => 0.000
                                [weight_modifier_type] => A
                                [variant_name] => 530х400/500
                                [image_pair] => Array
                                    (
                                    )

                            )

                        [5159] => Array
                            (
                                [variant_id] => 5159
                                [option_id] => 616
                                [position] => 1
                                [modifier] => 0.000
                                [modifier_type] => A
                                [weight_modifier] => 0.000
                                [weight_modifier_type] => A
                                [variant_name] => 530х500/500
                                [image_pair] => Array
                                    (
                                    )

                            )

                        [5160] => Array
                            (
                                [variant_id] => 5160
                                [option_id] => 616
                                [position] => 2
                                [modifier] => 0.000
                                [modifier_type] => A
                                [weight_modifier] => 0.000
                                [weight_modifier_type] => A
                                [variant_name] => 530х600/500
                                [image_pair] => Array
                                    (
                                    )

                            )

                        [5161] => Array
                            (
                                [variant_id] => 5161
                                [option_id] => 616
                                [position] => 3
                                [modifier] => 0.000
                                [modifier_type] => A
                                [weight_modifier] => 0.000
                                [weight_modifier_type] => A
                                [variant_name] => 530х700/500
                                [image_pair] => Array
                                    (
                                    )

                            )

                    )

            )

    )

[has_options] => 1
[selected_variation_code] => 828_5144
[variation_product_id] => 829
[options_update] => 4
[main_pair] => Array
    (
        [pair_id] => 4485
        [image_id] => 0
        [detailed_id] => 4507
        [position] => 0
        [detailed] => Array
            (
                [object_id] => 828
                [object_type] => product
                [type] => M
                [image_path] => https://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-25-kolco-500x500-1_w3bd-fz.jpg
                [alt] => Полотенцесушитель Марио Змейка 30
                [image_x] => 990
                [image_y] => 1326
                [http_image_path] => http://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-25-kolco-500x500-1_w3bd-fz.jpg
                [https_image_path] => https://cascadia.com.ua/images/detailed/4/zmeyka-25-kolco-500x500-1_w3bd-fz.jpg
                [absolute_path] => /home/d/denn67/ypi/public_html/images/watermarked/1/detailed/4/zmeyka-25-kolco-500x500-1_w3bd-fz.jpg
                [relative_path] => detailed/4/zmeyka-25-kolco-500x500-1_w3bd-fz.jpg
            )

    )

[image_pairs] => Array
    (
        [4486] => Array
            (
                [pair_id] => 4486
                [image_id] => 0
                [detailed_id] => 4508
                [position] => 0
                [detailed] => Array
                    (
                        [object_id] => 828
                        [object_type] => product
                        [type] => A
                        [image_path] => https://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x400-2.jpg
                        [alt] => Полотенцесушитель Марио Змейка 30
                        [image_x] => 1200
                        [image_y] => 1011
                        [http_image_path] => http://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x400-2.jpg
                        [https_image_path] => https://cascadia.com.ua/images/detailed/4/zmeyka-30-kolco-500x400-2.jpg
                        [absolute_path] => /home/d/denn67/ypi/public_html/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x400-2.jpg
                        [relative_path] => detailed/4/zmeyka-30-kolco-500x400-2.jpg
                    )

            )

        [4487] => Array
            (
                [pair_id] => 4487
                [image_id] => 0
                [detailed_id] => 4509
                [position] => 0
                [detailed] => Array
                    (
                        [object_id] => 828
                        [object_type] => product
                        [type] => A
                        [image_path] => https://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x500-2.jpg
                        [alt] => Полотенцесушитель Марио Змейка 30
                        [image_x] => 1200
                        [image_y] => 1011
                        [http_image_path] => http://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x500-2.jpg
                        [https_image_path] => https://cascadia.com.ua/images/detailed/4/zmeyka-30-kolco-500x500-2.jpg
                        [absolute_path] => /home/d/denn67/ypi/public_html/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x500-2.jpg
                        [relative_path] => detailed/4/zmeyka-30-kolco-500x500-2.jpg
                    )

            )

        [4488] => Array
            (
                [pair_id] => 4488
                [image_id] => 0
                [detailed_id] => 4510
                [position] => 0
                [detailed] => Array
                    (
                        [object_id] => 828
                        [object_type] => product
                        [type] => A
                        [image_path] => https://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x600-2.jpg
                        [alt] => Полотенцесушитель Марио Змейка 30
                        [image_x] => 1200
                        [image_y] => 1011
                        [http_image_path] => http://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x600-2.jpg
                        [https_image_path] => https://cascadia.com.ua/images/detailed/4/zmeyka-30-kolco-500x600-2.jpg
                        [absolute_path] => /home/d/denn67/ypi/public_html/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x600-2.jpg
                        [relative_path] => detailed/4/zmeyka-30-kolco-500x600-2.jpg
                    )

            )

        [4489] => Array
            (
                [pair_id] => 4489
                [image_id] => 0
                [detailed_id] => 4511
                [position] => 0
                [detailed] => Array
                    (
                        [object_id] => 828
                        [object_type] => product
                        [type] => A
                        [image_path] => https://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x700-2.jpg
                        [alt] => Полотенцесушитель Марио Змейка 30
                        [image_x] => 1200
                        [image_y] => 1011
                        [http_image_path] => http://cascadia.com.ua/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x700-2.jpg
                        [https_image_path] => https://cascadia.com.ua/images/detailed/4/zmeyka-30-kolco-500x700-2.jpg
                        [absolute_path] => /home/d/denn67/ypi/public_html/images/watermarked/1/detailed/4/zmeyka-30-kolco-500x700-2.jpg
                        [relative_path] => detailed/4/zmeyka-30-kolco-500x700-2.jpg
                    )

            )

    )

[base_price] => 1139.000000
[inventory_amount] => 10
[base_modifier] => 1139
[original_price] => 1139
[modifiers_price] => 0
[options_combination] => 616_5144
[discounts] => Array
    (
        [A] => 0
        [P] => 0
    )

[qty_content] => Array
    (
    )

[detailed_params] => Array
    (
        [get_icon] => 1
        [get_detailed] => 1
        [get_additional] => 1
        [get_options] => 1
        [get_discounts] => 1
        [get_features] => 
        [get_extra] => 
        [get_taxed_prices] => 1
        [get_for_one_product] => 
        [detailed_params] => 1
        [features_display_on] => C
    )

[power_labels] => Array
    (
        [0] => Array
            (
                [label_id] => 4
                [company_id] => 1
                [status] => A
                [prioritet] => 1
                [position_name] => bot_right
                [type] => T
                [position_type] => E
                [user_class] => 
                [border_radius] => 5
                [padding_label_top_bot] => 1
                [padding_label_right_left] => 3
                [font_size] => 10
                [font_weight] => normal
                [label_color] => #38761d
                [label_color_text] => #ffffff
                [label_margin_top] => 0
                [label_margin_right] => 0
                [label_margin_bottom] => 0
                [label_margin_left] => 0
                [to_date] => 0
                [from_date] => 0
                [del_status] => F
                [stop_other_labels] => 0
                [image_size] => 32
                [image_limit_for_txt] => 90
                [ext_type] => N
                [ext_field] => 0.0
                [hide_label] => N
                [feat_id] => 0
                [var_id] => 0
                [allow_vend] => Y
                [fa_icon] => N
                [no_bckgr] => N
                [label_name] => Бесплатная доставка
                [label_text] => Бесплатная доставка
                [lang_code] => ru
                [new_days] => 0
                [most_pop] => 0
                [sales_amount_for_label] => 0
                [rating_for_top] => 0.00
                [days_coom_soon] => 0
                [label_image_id] => 28
                [param_1] => badge_right badge_bot
                [labels_position_stats] => Array
                    (
                        [param_1] => badge_right badge_bot
                    )

                [main_pair] => Array
                    (
                        [pair_id] => 5005
                        [image_id] => 5027
                        [detailed_id] => 0
                        [position] => 0
                        [icon] => Array
                            (
                                [image_path] => https://cascadia.com.ua/images/badge/5/free-delivery__1_.png
                                [alt] => Бесплатная доставка
                                [image_x] => 32
                                [image_y] => 32
                                [http_image_path] => http://cascadia.com.ua/images/badge/5/free-delivery__1_.png
                                [https_image_path] => https://cascadia.com.ua/images/badge/5/free-delivery__1_.png
                                [absolute_path] => /home/d/denn67/ypi/public_html/images/badge/5/free-delivery__1_.png
                                [relative_path] => badge/5/free-delivery__1_.png
                            )

                    )

            )

    )

[for_discount] => D

)

Как сделать?

Да, по умолчанию эта информация не выводится. Нужно делать доп запросы к БД - найти все вариции товара по parent_product_id в cscart_products и c в таблице cscart_product_prices (с несколькими витринами еще в cscart_ult_product_prices) смотреть их цены

1 лайк