SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member Zanicar's Avatar
    Join Date
    Aug 2006
    Location
    Pretoria, South Africa
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Best approaches for top seller lists

    We are currently developing two sites for the same client, one is an online store, the other just a catalogue. For the store they want a top sellers list (top 10 in various categories) and for the catalogue a top 50.

    For the store we will simply make use of sales data from their Point-of-sales system via csv import and calculate the top 10 for each category via a straight forward SQL Select query. However, we are a bit divided on handling the catalogue as there is no sales data available. One suggestion is to simply create an xml file that defines the top 50 items by id, on the other hand we have proponents that favour using the database instead...

    Thus I would like to know the comments and opinions of other developers in industry. What solutions do you use and why? What are the potential pitfalls and what issues may arise at a later time, say when upgrades or modifications need to be made?
    Technology Management
    Cloud Computing Systems
    Rich Internet Applications
    http://noctranet.com

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,247
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Zanicar View Post
    One suggestion is to simply create an xml file that defines the top 50 items by id
    huh? top 50 based on what?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member Zanicar's Avatar
    Join Date
    Aug 2006
    Location
    Pretoria, South Africa
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Manually defined by the client. They want fine grained control over the list seeing as some items are effectively the same, e.g. the hard cover and soft cover version of the same book.

    We decided on going the xml route as this will offer our client the best flexibility.
    Technology Management
    Cloud Computing Systems
    Rich Internet Applications
    http://noctranet.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •