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.
lines 18-22:
replace with:
Code: Select all
if (isset($this->request->get['sort'])) {
$sort = $this->request->get['sort'];
} else {
$sort = 'p.sort_order';
}Code: Select all
if (isset($this->request->get['sort'])) {
$sort = $this->request->get['sort'];
} else {
$sort = 'p.price';
}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.
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.
try look for $product_option_value_query in catalog/model/catalog/product.php
change the
ORDER BY ov.sort_order
to
ORDER BY pov.price
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");
ORDER BY ov.sort_order
to
ORDER BY pov.price
Best Regards/Allen Chen
Greeting, if you consider want to buy commercial extension, i've developed it. Please follow link in my signature.
OPENCART MODULE :
Opencart Compare Link Link your compared product to forum/email
Frontend Link From Admin Dashboard Get link to product , category, manufacturer, information from admin backend.
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
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.
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.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.
OPENCART MODULE :
Opencart Compare Link Link your compared product to forum/email
Frontend Link From Admin Dashboard Get link to product , category, manufacturer, information from admin backend.
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
I think it was just a cache issue. If you change what I suggested before then clear system/cache/ folder, it should work.
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.
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.
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
Works on opencart 1.5.4.1
OPENCART MODULE :
Opencart Compare Link Link your compared product to forum/email
Frontend Link From Admin Dashboard Get link to product , category, manufacturer, information from admin backend.
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
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.
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.
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 :-)
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 :-)
Who is online
Users browsing this forum: No registered users and 329 guests
