How do I get my products to sort properly in the BuyNow module. I want to sort first on the category sort order and then by the product sort order. It seems the products are sorted in the reverse order in which I entered them (LIFO).
Can you confirm that you have the following line in the stored procedure "Smith_ListproductByFilter"
SET @SearchSQL = @SearchSQL + ' AND P.LogicallyDeleted !=''1'' AND Archived != 1 order by P.SortOrder '
After uninstalling the Smith Cart modules and reinstalling from scratch, the sorting problem has been corrected. I am beginning to suspect, however, that I don't have the latest-greatest version of the PA. See post re: Affiliate Tracking.
Glad to hear the sorting issue is fixed. I just updated snowcovered with the latest cart pa file it should fix your error your reported in your other post with the affiliate tracking module.
The version on Snowcovered.com is a trial version. See my post in this forum re: version 02.44.12.
The latest version 2.44.12 requires a license key for your domain, please email sales@smithcart.com with your domain name and your receipt and we will generate a license key for you to copy to your portal