Home Up Search Contact Us Shipping Care of Your Pen Wood Samples

 

Home
Up

 

This is not to be a web page. It is my initial thoughts on what should be included in the database form.

Pen Gallery Database

 Item #           Style

Artist    Type    Finish

Price             Wood / Material

Sold          Inlay           Elite             Gallery

Description

Picture (example  ../images/pgrk68.jpg)

Thumbnail (example ../images/pgrk68_small.jpg)

Date Added

 

Notes

  1. I would like to be able to add new items that are found in the above drop down menus. (Artist, Style, Type, Finish, Wood / Material)
  2. I would like the search results page to have the ability to be populated based on most of these fields.
  3. The search page should have four price ranges to choose from. (< $25, $25 - $50, $50 - $75, > $75) Maybe we should consider the ability to modify these ranges in the future.
  4. I want a page that will list the pens by Date Added field. (Newest pens first) This may be best as an option on the search page. I will describe my ideas on the search page later. (gallery.asp)
  5. The Pen Gallery pages (currently pgpage_1(2,3).htm) will be populated from the pens with Gallery values of Page 1(2,3). I am interested in the sort order of this page such that it is fair to each artist. They will all have one pen on each of the three pages. Can we make the sort order random?
  6. The Elite Collection page should be populated by pens with the Elite checkbox checked.
  7. The Artist pages will have all of their pens listed after their biographical information. See jlambert.htm for an example. The SOLD sign should appear if the Sold checkbox is checked. Clicking on the thumbnail or More Information and Ordering link should take the visitor to the applicable pen page. See pgjl02.htm for an example of a sold pen. The SOLD sign should show up if Sold is checked in the database. See pgjl03.htm for an example of a pen that is not sold. Can the shopping cart buttons appear only if the pen is not sold?
  8. On the pen page, the Information data comes from the Description field in the database.

Links of interest:

bulletPen Gallery Home http://www.woodpens.com/gallery.htm
bulletGallery Page 1 http://www.woodpens.com/pgpage_1.htm
bulletGallery Page 2 http://www.woodpens.com/pgpage_2.htm
bulletGallery Page 3 http://www.woodpens.com/pgpage_3.htm
bulletElite Collection http://www.woodpens.com/elite.htm
bulletArtist Page http://www.woodpens.com/jlambert.htm
bulletSold Pen Page http://www.woodpens.com/pgjl02.htm
bulletUn-Sold Pen Page http://www.woodpens.com/pgjl03.htm

 

 
Please allow 1 to 2 weeks additional shipping time if you select laser engraving.
Send mail to jim@woodpens.com with questions or comments about Woodpens.com or this web site.
Copyright © 2005 Woodpens.com