price sorting on product listing sometimes not work

**xingxing** · 31 Aug 2006, 12:28 AM

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.

**DrByte** · 31 Aug 2006, 05:41 AM

It might help if you supplied a URL where we can see this in action...

**xingxing** · 1 Sep 2006, 10:27 AM

OK!
Please check this URL
http://www.jadewish.com/index.php?ma...x&cPath=1_9_16 (not working)
http://www.jadewish.com/index.php?ma...page=1&sort=4a (not working)

http://www.jadewish.com/index.php?ma...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!)

**Ajeh** · 2 Sep 2006, 01:33 AM

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?

**xingxing** · 2 Sep 2006, 06:27 AM

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!

Originally Posted by 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?

**DrByte** · 2 Sep 2006, 06:37 AM

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 !!!!

**xingxing** · 2 Sep 2006, 06:49 AM

Hello

I have reset all the required indexes. It works!
But why need to do this?
Thank you!

Originally Posted by 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 !!!!

**DrByte** · 2 Sep 2006, 06:56 AM

Originally Posted by xingxing

But why need to do this?

because you imported your products from a different system and didn't reset them:

Originally Posted by Ajeh

Usually, if you import your products they are missing 2 key fields ... the master_categories_id and the products_price_sorter

**xingxing** · 2 Sep 2006, 06:58 AM

But I have already run zencart more than one year. I remember that there is no problem before 1.2.7.
Thank you!

**Ajeh** · 2 Sep 2006, 03:34 PM

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" ...