Post by Eggweezer » Sun Feb 10, 2013 5:30 am

I found a fix in a thread, but must have been for an earlier version, as it had no effect.
I have so many different product options and they are conflicting with each other.

I would like my "Product Options" to always display by price (lowest to highest). .
I am using version 1.5.3.1.

Is there a way that I can edit the catalog/controller/product/category.php file to accomplish this?
Thank you in advance.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by Renato Frota » Sun Feb 10, 2013 3:58 pm

lines 18-22:

Code: Select all

		if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'p.sort_order';
		}
replace with:

Code: Select all

		if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'p.price';
		}

New member

Posts

Joined
Wed Aug 31, 2011 1:21 pm

Post by Eggweezer » Mon Feb 11, 2013 5:04 am

Thanks Renato, but I did try that yesterday, and it makes no difference. I left it with your change(so you can see).
My page is at.... http://briskeee.org/index.php?route=pro ... oduct_id=7

The prices are still not in order.

It wouldn't have anything to do with the fact that I am using a template(I purchased) would it?
Any other ideas would be greatly appreciated! Sincerely.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by bigal » Mon Feb 11, 2013 5:29 am

try look for $product_option_value_query in catalog/model/catalog/product.php

Code: Select all

$product_option_value_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '" . (int)$product_id . "' AND pov.product_option_id = '" . (int)$product_option['product_option_id'] . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "' ORDER BY ov.sort_order");
change the
ORDER BY ov.sort_order
to
ORDER BY pov.price

Best Regards/Allen Chen


Active Member

Posts

Joined
Wed Sep 21, 2011 9:02 am

Post by Eggweezer » Mon Feb 11, 2013 5:57 am

Unfortunately that did not make a difference bigal.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by rempong » Mon Feb 11, 2013 7:43 am

Greeting, if you consider want to buy commercial extension, i've developed it. Please follow link in my signature.

OPENCART MODULE :
Opencart Compare Link VQMOD, Link your compared product to forum/email

Copy and DIRECTLY Edit Product, the easy way.

Custom Product Sort, Full control to product sorting options

Already Sold Product Module, shows total product sold

Opencart Shortcode (Wordpress Clone)


Active Member

Posts

Joined
Fri Sep 14, 2012 2:38 pm
Location - Indonesia

Post by bigal » Mon Feb 11, 2013 7:51 am

It worked on my default install on v.1.5.4.1

Best Regards/Allen Chen


Active Member

Posts

Joined
Wed Sep 21, 2011 9:02 am

Post by Eggweezer » Mon Feb 11, 2013 10:44 am

I purchased "Custom Product Sort". I'm using 1.5.3.1.
I selected it in user/user groups /top administrator (both access amd modify permissions).
I then installed it under Extensions/Modules/Product Sort and selected Both "Default" and "Sort Order" to LOW to HIGH.
Still not sorting in order by price (You can see it here.... )
http://briskeee.org/index.php?route=pro ... oduct_id=7

Did I miss something? Thank you.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by rempong » Fri Feb 15, 2013 9:39 pm

Eggweezer wrote:I purchased "Custom Product Sort". I'm using 1.5.3.1.
I selected it in user/user groups /top administrator (both access amd modify permissions).
I then installed it under Extensions/Modules/Product Sort and selected Both "Default" and "Sort Order" to LOW to HIGH.
Still not sorting in order by price (You can see it here.... )
http://briskeee.org/index.php?route=pro ... oduct_id=7

Did I miss something? Thank you.
Please check your email. Thank you.

OPENCART MODULE :
Opencart Compare Link VQMOD, Link your compared product to forum/email

Copy and DIRECTLY Edit Product, the easy way.

Custom Product Sort, Full control to product sorting options

Already Sold Product Module, shows total product sold

Opencart Shortcode (Wordpress Clone)


Active Member

Posts

Joined
Fri Sep 14, 2012 2:38 pm
Location - Indonesia

Post by Renato Frota » Mon Feb 18, 2013 2:25 pm

I think it was just a cache issue. If you change what I suggested before then clear system/cache/ folder, it should work.

New member

Posts

Joined
Wed Aug 31, 2011 1:21 pm

Post by Eggweezer » Mon Feb 18, 2013 6:55 pm

Thank you very much Renato. I appreciate you taking the time to helping me out. I have been out of commision all weekend, but will try it this evening and let you know how it works out. Thanks again.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by Eggweezer » Fri Feb 22, 2013 11:09 am

I still do not have "Custom Product Sort" working, and I apologize for being a nuisence. (I have been away for the last week.)

It does not appear to be a cache issue with my browser, as I just cleared my browser cache and have the same issue.
I'm now using vers 1.5.4

1) I uploaded the folders to my root.
1) I then selected it in user/user groups /top administrator (both access and modify permissions).
2) I then installed it under Extensions/Modules/Product Sort and selected Both "Default" and "Sort Order" to LOW to HIGH.
3) Still not sorting in order by price (You can see it here.... )
http://test26.cnjwebsolutions.com/index ... oduct_id=7

I really would appreciate help. Sincerely.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by rempong » Fri Feb 22, 2013 11:52 am

ooo, i see. We have miscommunication here. My module modif PRODUCT SORTING on category page and manufacturer page. And what you want is sorting by price on PRODUCT DETAIL page. My module can't do that. But i've attached VQMOD file to do what you want.

Works on opencart 1.5.4.1

Attachments


OPENCART MODULE :
Opencart Compare Link VQMOD, Link your compared product to forum/email

Copy and DIRECTLY Edit Product, the easy way.

Custom Product Sort, Full control to product sorting options

Already Sold Product Module, shows total product sold

Opencart Shortcode (Wordpress Clone)


Active Member

Posts

Joined
Fri Sep 14, 2012 2:38 pm
Location - Indonesia

Post by Eggweezer » Fri Feb 22, 2013 7:11 pm

Thanks Rempong. I appreciate that.
I guess though, I am not exactly sure what I would do with this xml file? (like where do I put it?).

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by Eggweezer » Sun Feb 24, 2013 12:23 am

I believe I figured out how to install it (saved file & uploaded using VQmod).
Now....the VQmod scripts box shows that it is enabled, BUT........ when I go to a product page, the products are still NOT in order by price.

Am I missing something? Thank you in advance.

Active Member

Posts

Joined
Tue Jun 05, 2012 1:33 am

Post by jadenronnie » Thu Jun 23, 2016 5:50 pm

Hi Eggweezer i was having the same problem but Thank God it's solved now!
Go to admin panel of OC, then Catalog and then Go to Product. Now edit any product. there would be some tabs for general,data, links..... Go to DATA tab.. in the end there will be option... Sort Order.. place order no you want to appear in category,, like 1 then for second product type 2 similarly to all products, one you are finished just refresh you store page :-)

Newbie

Posts

Joined
Mon Jun 20, 2016 8:41 pm
Who is online

Users browsing this forum: muazuicom22 and 72 guests