Support Forum - Topic: Sorting Catalog Product Order By Price

Support Forum - Topic: Sorting Catalog Product Order By Price http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price Support Forum - Topic: Sorting Catalog Product Order By Price en-US Sun, 19 May 2013 06:36:12 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://www.kriesi.at/support/search.php Kriesi on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-105973 Wed, 17 Apr 2013 16:46:05 +0000 Kriesi 105973@http://www.kriesi.at/support/ I have found an issue in the theme that made pricing behave a little strange. might be that this was the problem you are encountering but I am not sure yet. I will upload the patch in the next few days, so once you got your hands on it elt me know if it fixed your problem ;) Devin on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-102279 Wed, 20 Mar 2013 15:32:10 +0000 Devin 102279@http://www.kriesi.at/support/ Hey SixStar281, I'm fairly sure this is an issue that needs to be fixed within WooCommerce. I know the code snippet I posted came from the lead developer for the plugin for the very same question. When Kriesi is able to take a look maybe he will have a better solution. I'll take a look through the reported bugs as well to see if this has been posted to them yet. Regards, Devin SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-102074 Tue, 19 Mar 2013 15:09:06 +0000 SixStar281 102074@http://www.kriesi.at/support/ Waited for WC2 and installed, also installed the updates for the theme that came out since I created the site, still no luck.. would you like ftp credentials? and wordpress? Please tell me where to mail them to. Dude on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-97370 Tue, 19 Feb 2013 06:17:53 +0000 Dude 97370@http://www.kriesi.at/support/ Hi! Marked this thread for Kriesi. Tbh I think it's a Woocommerce bug and we'll probably need to wait for WC2.0 but maybe he can provide a solution. Best regards, Peter SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-97266 Mon, 18 Feb 2013 16:05:56 +0000 SixStar281 97266@http://www.kriesi.at/support/ It seems like that one didn't work either ;/ <a href="https://dreamroomshouston.com/beta/?product_cat=accent-chairs" rel="nofollow">https://dreamroomshouston.com/beta/?product_cat=accent-chairs</a> Nick on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96386 Tue, 12 Feb 2013 16:20:40 +0000 Nick 96386@http://www.kriesi.at/support/ Hi, In Dude's code above, please try replacing <pre><code>else { $meta_key = ''; }</code></pre> with <pre><code>else { $orderBy = 'meta_value_num'; $meta_key = '_price'; }</code></pre> and also try changing in the same block above <pre><code>'orderby' => $orderBY,</code></pre> to <pre><code>'orderby' => $orderBy,</code></pre> Thanks, Nick SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96384 Tue, 12 Feb 2013 16:16:32 +0000 SixStar281 96384@http://www.kriesi.at/support/ Tried it with all the plug-ins disabled. :( they still not ordered by price. If i click on "order by price" on the front end, it will order them by price.. But it wont do it as a default.. Dude on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96294 Tue, 12 Feb 2013 06:50:37 +0000 Dude 96294@http://www.kriesi.at/support/ It seems like you're using the template builder on the front page. In this case try to change the default sorting (WooCommerce > Settings > Catalog) and if this doesn't solve the problem open up wp-content\themes\replete\includes\helper-template-dynamic.php and replace: <pre><code>if(!isset($shop_slider)) $shop_slider = "no"; $page_nr = $shop_slider != "yes" ? get_query_var( 'paged' ) : 1;</code></pre> with: <pre><code>if(!isset($shop_slider)) $shop_slider = "no"; $page_nr = $shop_slider != "yes" ? get_query_var( 'paged' ) : 1; if($orderBY == 'price'){ $orderBy = 'meta_value_num'; $meta_key = '_price'; } else { $meta_key = ''; } $avia_config['new_query'] = array( 'post_type' => 'product', 'post_status' => 'publish', 'ignore_sticky_posts' => 1, "paged" => $page_nr, 'posts_per_page' => $shop_item_count, 'orderby' => $orderBY, 'order' => $order, 'meta_key' => $meta_key, 'meta_query' => array( array( 'key' => '_visibility', 'value' => array('catalog', 'visible'), 'compare' => 'IN' ) ) );</code></pre> I'd also try to deactivate all third party plugins except woocommerce - maybe one causes the issue. SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96187 Mon, 11 Feb 2013 15:23:44 +0000 SixStar281 96187@http://www.kriesi.at/support/ Thanks Devin, Tried it and It didn't work, like i said title, or date filter will work but not price. :/ Devin on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96146 Mon, 11 Feb 2013 12:05:31 +0000 Devin 96146@http://www.kriesi.at/support/ Hi SixStar281, Try to add the following to the bottom of your functions.php: <pre><code>/** * This code should be added to functions.php of your theme **/ add_filter('woocommerce_default_catalog_orderby', 'my_custom_default_catalog_orderby'); function my_custom_default_catalog_orderby() { return 'price'; // Can also use title and date }</code></pre> Regards, Devin Ismael on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96107 Mon, 11 Feb 2013 05:58:26 +0000 Ismael 96107@http://www.kriesi.at/support/ Hi SixStar281, I am still finding a solution for this. Let me tag the rest of the support as they might already have a solution for this issue. Regards, Ismael SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96103 Mon, 11 Feb 2013 05:26:03 +0000 SixStar281 96103@http://www.kriesi.at/support/ I tried installing from scratch, lates theme, latest woocommerce.. Before the theme it worked, but after theme, it stop working.. but this is only for "price" I noticed that alphabetical order works.. "price order does work in a weird way" it arranges the items in price groups. not "ascending or descending" example: 1item for $10 then 3items for $30 followed by 2 items for $15 next to 1item for $20 So it does have a grouping function working, but not in the right way. Please help me! SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96093 Mon, 11 Feb 2013 03:06:45 +0000 SixStar281 96093@http://www.kriesi.at/support/ Never mind, this is not solved.. that didn't help.. SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96086 Sun, 10 Feb 2013 22:26:48 +0000 SixStar281 96086@http://www.kriesi.at/support/ After hours. and hours.. and a few more hours.. I found the solution.. i feel a little dumb about it.. on the config.php line 931 <pre><code>$po_key = !empty($avia_config['woocommerce']['product_order']) ? $avia_config['woocommerce']['product_order'] : 'default'; $ps_key = !empty($avia_config['woocommerce']['product_sort']) ? $avia_config['woocommerce']['product_sort'] : 'asc'; $pc_key = !empty($avia_config['woocommerce']['product_count']) ? $avia_config['woocommerce']['product_count'] : $per_page;</code></pre> change to <pre><code>$po_key = !empty($avia_config['woocommerce']['product_order']) ? $avia_config['woocommerce']['product_order'] : 'price'; $ps_key = !empty($avia_config['woocommerce']['product_sort']) ? $avia_config['woocommerce']['product_sort'] : 'asc'; $pc_key = !empty($avia_config['woocommerce']['product_count']) ? $avia_config['woocommerce']['product_count'] : $per_page;</code></pre> SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96061 Sun, 10 Feb 2013 16:22:51 +0000 SixStar281 96061@http://www.kriesi.at/support/ Thank you Ismael, The only thing is that i have over 600 products ordering manually is not an option.Is there a way to automatically sort them by price? Ismael on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96025 Sun, 10 Feb 2013 06:56:03 +0000 Ismael 96025@http://www.kriesi.at/support/ Hi SixStar281, Try to check this thread: <a href="http://www.kriesi.at/support/topic/what-determines-order-of-displayed-products" rel="nofollow">http://www.kriesi.at/support/topic/what-determines-order-of-displayed-products</a> Regards, Ismael SixStar281 on "Sorting Catalog Product Order By Price" http://www.kriesi.at/support/topic/sorting-catalog-product-order-by-price#post-96015 Sun, 10 Feb 2013 04:44:35 +0000 SixStar281 96015@http://www.kriesi.at/support/ Is there a way to change the default sorting to Price? I have already change in the woocommercer settings under the catalog tab, but this dont work, I have search and research for days and I tried this filter, <pre><code>add_filter('woocommerce_get_catalog_ordering_args', 'am_woocommerce_catalog_orderby'); function am_woocommerce_catalog_orderby( $args ) { $args['meta_key'] = '_price'; $args['orderby'] = 'meta_value_num'; $args['order'] = 'desc'; return $args; }</code></pre> but it didn't work. website <a href="https://dreamroomshouston.com/beta" rel="nofollow">https://dreamroomshouston.com/beta</a>