Support

Account

Home Forums General Issues Trying to ORDER foreach loop by ACF field Reply To: Trying to ORDER foreach loop by ACF field

  • Hi,
    I have some issue regarding sorting using ACF field
    In Woocommerce product I have added one ACF group named product_shipping_and_installment and inside this group one field named product_type in this field user will add “AC” Or “CO”.
    Below is the code:

    
    $args = array(
        'post_type'      => 'product',
        'posts_per_page' => -1,
        'post_status' => "publish",
        'product_cat'    => $cat->name,
        'meta_query'	=> array(
            'relation'		=> 'AND',
            array(
                'key'		=> 'product_shipping_and_installment_product_type',
                'value'		=> array('AC', 'CO'),
                'compare'	=> 'IN'
            ),
        ),
            
    );
    $loop = new WP_Query($args);
    

    Above screenshot code will provide me all the list of product based on field named product_type but not sorting wise. I would like to show “AC” value product list first and then need to show “CO” product list currently is showing me “CO” product list first and then “AC” product list.
    Any help is greatly appreciate.
    Thanks 🙂