Just built a new zc site and imported close to 1200 products. The problem is the system simply sucks at sorting (or I don't understand it.) It's putting products by title, but instead of 9, 10, 11, it does 9, 90, 91..... It's a pain.

There is no way I want to go through and tell the system how to sort by actual sort order in the products. I haven't been able to accurately add sort stuff either in the back end or with the admin.

Can someone tell me how to get this to work? The client actually wants the products in a particular order, so I'd like to sort by:

Name
Category 1
Subcategory, etc.

???

Thanks!

KD