I would like to sort front end products in a category based on the custom attribute (say promote). I give value for promote attribute for every product in the website like 1,2,3,4,5..100,101..1000 etc. Here the requirement is, products need to be sorted based on the integer value irrespective of the category it exists. For example: If the promote attribute value is 1 then it should be the first product where ever category it exists. In other way highest promote attribute value should be top of every category. Please guide me in this.
Create an attribute of type "text field". Let's name it "Promote" as you suggest
Be sure that you have "Used in Product Listing" and "Used for Sorting in Product Listing" set to "Yes"
System / Configuration / Catalog / Catalog / Frontendyou’ll see “Product Listing Sort by” drop down menu. Select your attribute
In any/every category, in the "Display Settings" tab, be sure that the field "Default Product Listing Sort By" has either your attribute selected or the checkbox "Use Config Settings" checked
Reindex and refresh Cache