User Defined Categories
WhiteOakBooks BookSite Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



User Defined Categories Expand / Collapse
Author
Message
Posted 3/4/2008 2:52:50 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Administrators
Last Login: 6/24/2015 11:16:46 AM
Posts: 630, Visits: 2,623

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:

·        SKU

·        ISBN/ASIN

·        Date Added/Edited

·        Keywords (the keywords field contains isbn, title, author)

·        Price

·        Category

 

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:

 

Wildcard character

Description

Example

%

Any string of zero or more characters.

WHERE title LIKE '%computer%' finds all book titles with the word 'computer' anywhere in the book title.

_ (underscore)

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%

and also

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.

 

Andy

 

 

 

Post #106
Posted 3/4/2008 7:31:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: WOB User
Last Login: 5/27/2009 10:58:46 AM
Posts: 17, Visits: 120
Thanks Andy, this appears to be exactly what I have been looking for.

I am on ver 1.65, so I need to be upgraded. I will be trying this out over the next couple of days...

Post #108
Posted 3/4/2008 11:17:15 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Administrators
Last Login: 6/24/2015 11:16:46 AM
Posts: 630, Visits: 2,623
DemiDiscount (3/4/2008)
Thanks Andy, this appears to be exactly what I have been looking for.

I am on ver 1.65, so I need to be upgraded. I will be trying this out over the next couple of days...

Give it a shot.  It doesn't have all the searching options I know you want but it should make what you are trying to do easier.

Andy

Post #109
Posted 8/8/2010 3:53:53 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: WOB User
Last Login: 7/18/2017 12:45:02 PM
Posts: 118, Visits: 200
This Wizard is way cool. I created a bargain books category for dreck I'd like off my shelves.

A few comments/suggestions.

1. I setup the Wizard to sort by Date, but it seems to sort by title no matter what.
This is the code generated by the Wizard:
[** UserCategory - Filter: Price LT 4.00;Number: 0; HowPickedate; Style: 2Col; Columns: 1; **]

2. It might be nice to have some additional sort options, by price would be handy for Bargain Basement. By author might be handy for genres.


...stenz at 4Shadows Books

www.4ShadowsBooks.com
Post #807
Posted 8/10/2010 3:07:20 PM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Administrators
Last Login: 6/24/2015 11:16:46 AM
Posts: 630, Visits: 2,623
I hope to rewrite the entire 'picking' of inventory for this wizard and for featured items.

It's a big project so it'll be a while before I get to it.

Post #818
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: AndyLL, WOTAdmin

Permissions Expand / Collapse

All times are GMT -6:00, Time now is 6:48am

Powered By InstantForum.NET v4.1.4 © 2018
Execution: 0.156. 7 queries. Compression Disabled.