User Category Wizard
The featured items functionality is pretty flexible but does have some limitations. It is designed to display items in a single area… such as on the home page or in the right column.
Therefore the number of items is limited to 10 because any more on a single page will affect performance.
There have been several requests for the website owner to be able to define a specific criteria to select items out of the database and to display them on the website like the product category pages… meaning there will be Prev/Next links at the bottom to scroll through the results if there are more then 10.
This is basically defining your own categories other then by subject.
Two independent pieces of functionality were
1) User Pages Menus – When you create a new user page you now have the ability to show the link to that page on the top, bottom, side menus and underneath the Add To Cart Button.
The website can now allow display the User Page link at the top or the bottom of the category list.
2) Category Wizard – There is now a wizard to create the code needed to define your own category.
The Wizard name ‘Create User Category Pages’ under the Website Tools heading in your Website Control Panel.
The items you can define search criteria on are:
· Date Added/Edited
· Keywords (the keywords field contains isbn, title, author)
Any of these items can be combined.
The power of this wizard is the ability to use the ‘Like’ keyword to define wildcards.
Here are the Like wildcard options:
Any string of zero or more characters.
WHERE title LIKE '%computer%' finds all book titles with the word 'computer' anywhere in the book title.
Any single character.
WHERE au_fname LIKE '_ean' finds all four-letter first names that end with ean (Dean, Sean, and so on).
Any single character within the specified range ([a-f]) or set ([abcdef]).
WHERE au_lname LIKE '[C-P]arsen' finds author last names ending with arsen and beginning with any single character between C and P, for example Carsen, Larsen, Karsen, and so on.
Any single character not within the specified range ([^a-f]) or set ([^abcdef]).
WHERE au_lname LIKE 'de[^l]%' all author last names beginning with de and where the following letter is not l.
Here are some examples:
Author search – Keywords Like %Janet Daily% (matches all “Janet Daily” in the keywords field
SKU search – SKU Like 20___ ( matches all skus from 20000-20999 in my inventory)
Category search – Category Like Books:Childrens Books% ( matches all subcategories of Childrens books)
Hardbacks – Kewords Like %[Hardback]% (Amazon puts [hardback] in many but not all titles if it is a hardback)
You of course can mix and match different searches.
For example if you want a clearance category on Video Games only.
Category search – Category Like Video Games%
Price LessThen 1.00
We understand that is might be challenging to setup these criteria yourself. If you get unexpected results then post the generated code in the forums and I’ll help debug it.
I’d prefer you do it this way so others can see common problems with solutions.
To use this functionality you must be on version 1.70. (visible at the bottom of the page)
Let me know if you need to be upgraded.