Views: 2,110
New Zenner
I find that the price sorting somtimes is not work!
I have a category when I click the price sorting on the product list header, the price is not sorted in order.
Sensei
It might help if you supplied a URL where we can see this in action...
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
OK!
Please check this URL
http://www.jadewish.com/index.php?main_page=index&cPath=1_9_16 (not working)
http://www.jadewish.com/index.php?main_page=index&cPath=1_9_15&page=1&sort=4a (not working)
http://www.jadewish.com/index.php?main_page=index&cPath=83&page=1&sort=4d (working)
Thank you very much!
(This is a live website, please don't place order if you are just testing it. Thank you!)
Oba-san
How did you load your products?
Usually, if you import your products they are missing 2 key fields ... the master_categories_id and the products_price_sorter
Do you use Linked Products?
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
New Zenner
The products were imported from oscommerce database a year ago. A a few days ago, I upgrade it to zen 1.3.0.2
Yes! I have linked a few products in the categories "Gemstone" and "925 Silver"
The category "Fashion" works properly and without linked products.
Where to look for master_categories_id and products_price_sorter!?
Thank you!
Ajeh:
How did you load your products?
Usually, if you import your products they are missing 2 key fields ... the master_categories_id and the products_price_sorter
Do you use Linked Products?
Sensei
If you do a database-backup FIRST, then you can tell Zen Cart to do a reset on the products-price-sorter and the master-categories-id in the Tools->Store Manager screen.
DO A DATABASE BACKUP FIRST !!!!
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
Hello
I have reset all the required indexes. It works!
But why need to do this?
Thank you!
DrByte:
If you do a database-backup FIRST, then you can tell Zen Cart to do a reset on the products-price-sorter and the master-categories-id in the Tools->Store Manager screen.
DO A DATABASE BACKUP FIRST !!!!
Sensei
xingxing:
But why need to do this?
because you imported your products from a different system and didn't reset them:
Ajeh:Usually, if you import your products they are missing 2 key fields ... the master_categories_id and the products_price_sorter
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
New Zenner
But I have already run zencart more than one year. I remember that there is no problem before 1.2.7.
Thank you!
Oba-san
Your data could of come in the first time in the proper order ...
You may have set the master_categories_id and forgotten ...
Your pricing may not have been effected in a way that the master_categories_id was an issue ...
There are a lot of reasons ...
The master_categories_id is used to build the products_price_sorter for display purposes as the calculation on bottom line price is extensive ...
When you edit products, this is remade ...
When you add attributes, this is remade ...
There are a number of ways the products_price_sorter is re-calculated that even on imported data the field could of been updated ...
Bottom line is, if the master_categories_id is missing, there is a good chance that the products_price_sorter is missing ...
If the products_price_sorter is missing, then on displays the products cannot be properly sorted by price except by "coincidence" ... :smile:
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Tell staff why this post should be reviewed.
