Support » Plugin: WooCommerce » Adding a special product attribute to the [products] shortcode.

  • Resolved tbonge

    (@tbonge)


    I want to have a products page that shows the customer the items they buy the most. We are a wholesaler and most customers reorder the same items and frequently ask for a list of their best sellers. This sales data does not come from woocommerce orders because most orders are placed ‘offline’ over the phone or in or showroom.

    My idea is to load a transient with an array of skus (from a webservice on our Sql Server database) when they log in. This part I know how to do.

    What I need help with is how to get the [products] shortcode to use that transient sku array. How would I add a new attribute filter to the short code so that instead of…

    [products best_selling="true"]

    I could have…

    [products customers_best_selling="true"]

    That would use a query like

    $query_args = array(
       'posts_per_page' => $number,
       'no_found_rows'  => 1,
       'post_status'    => 'publish',
       'post_type'      => 'product',
       'post__in'       => $customers_best_selling,
       'orderby'        => 'post__in',
       );   

    Is it also important that the orderby be ‘post__in’ so that they see their bestsellers fist, instead of the default sort options of post_date/bestselling/price etc.

    Also if you think there is a better way to approach this, please let me know.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Dat Hoang

    (@htdat)

    Hi,

    I’ve tried testing this snippet, I hope that helps.

    In fact, you need two parts:

    1. Support your own attribute for the [products] shortcode.
    2. Modify the query to use your $query_args.

    // https://developer.wordpress.org/reference/hooks/shortcode_atts_shortcode/
    // Add the code to support your own attribute
    add_filter('shortcode_atts_products', 'htdat_shortcode_atts_products', 10, 4);
    function htdat_shortcode_atts_products( $out, $pairs, $atts, $shortcode ){
      if ( isset ($atts[ 'customers_best_selling' ]) && $atts [ 'customers_best_selling' ] ) {
    	$out[ 'customers_best_selling' ] = true; 
      } else {
    	$out[ 'customers_best_selling' ] = false; 	
      }
      return $out;
    }
    
    // Modify the query args 
    // See another example https://docs.woocommerce.com/document/woocommerce-shortcodes/#section-11
    add_filter( 'woocommerce_shortcode_products_query', 'htdat_woocommerce_shortcode_products_query', 10, 2 );
    function htdat_woocommerce_shortcode_products_query( $query_args, $attributes ) {
    
      if ( $attributes[ 'customers_best_selling' ] ) {
          // write your own $query_args here 
          // Example: $query_args[ 'post__in' ] = array (1027, 959);
        }
      return $query_args;
    }
    • This reply was modified 1 year, 10 months ago by Dat Hoang.

    Hi Dat Hoang

    I have done the same code for my custom argument on product shortcode but it’s not working for me.

    My shortcode is [products columns=”3″  paginate=”true” limit=”12″ exclude_featured=”true” ]

    // Add argument
    add_filter(‘shortcode_atts_products’, ‘custom_shortcode_atts_products’, 10, 4);
    function custom_shortcode_atts_products( $out, $pairs, $atts, $shortcode ){
    if ( isset ($atts[ ‘exclude_featured’ ]) && $atts [ ‘exclude_featured’ ] ) {
    $out[ ‘exclude_featured’ ] = true;
    } else {
    $out[ ‘exclude_featured’ ] = false;
    }
    return $atts;
    }

    // modify query
    add_filter( ‘woocommerce_shortcode_products_query’, ‘custom_argument_shortcode_product’ );

    function custom_argument_shortcode_product( $args , $attributes, $type)

    if ($attributes[ ‘exclude_featured’ ]){
    $query_args[‘tax_query’][] = array(
    ‘taxonomy’ => ‘product_visibility’,
    ‘terms’ => ‘featured’,
    ‘field’ => ‘name’,
    ‘operator’ => ‘NOT IN’,
    ‘include_children’ => false,
    );
    // $custom_args = array_merge($args,$query_args);
    //return $custom_args;
    }
    return $query_args;
    }

    I am getting no product listing on this shortcode page.

    can you please help me how can I resolve this issue.

    Thanks

    • This reply was modified 1 year, 6 months ago by divya275.
    • This reply was modified 1 year, 6 months ago by divya275.
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Adding a special product attribute to the [products] shortcode.’ is closed to new replies.