Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

asp online catalog

Status
Not open for further replies.

stpmtp

MIS
Jan 6, 2006
67
US
Hello, I am not a programmer, I need some advice if anybody knows where can I get a script for an online catalog. I understand asp, javascript, html and some perl. but like I said I am not a programmer. this would be for a friend. If this is the wrong place to post this I apologize. Thank you
 
Thank you Chris, I looked at those, but I don't really need the shopping cart, I am more interested in the catalog like part. and although those are close they are not close enough. Do you sell your script? or could I take a look a the website that you implemented the script on?
 
Do you just want to be able to type in a name of a product and then it display say price, title, description and picture? Maybe also search for all products in a particular category?

If so this should be quite straightforward.
 
What I really need is to have the categories and sub categories on the left, and to show the pics on the right. When you click on a pic to give you the description of the product I don't need prices. Also an advanced search would be nice kind of like a product configurator does that make sence?
 
stpmtp,

Does it have to be ASP ?
A simple, yet fully functional solution is osCommerce - a free PHP app.

If it does have to be ASP then,
If you are trying to add this functionality to an existing site, then you are likely to have more trouble integrating an external script / component than you are just writing it yourself.

Here's a nice intro tutorial that you should be able to take some pieces of:
Here's a working example with source code:

And another:

Google has tons and tons of links to free catalogues for ASP - all of them that I can see need a lot of work to integrate into an existing site and look half decent.

I would recommend you write your own, basing your design / code on the examples above - that way you'll learn something, and have a tailored solution for your needs - which will probably be ten times better than the free ones.

A smile is worth a thousand kind words. So smile, it's easy! :)
 
What I really need is to have the categories and sub categories on the left, and to show the pics on the right. When you click on a pic to give you the description of the product I don't need prices. Also an advanced search would be nice kind of like a product configurator does that make sence?

Don't know if this site I developed might be the kind of layout that might give you some ideas about what can be done...
Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
Access Database Sample, Web Database Sample, ASP Design Tips
 
Breaking down the project into several smaller sections will make the whole thing more manageable.

First up get a basic database together. You might have three tables. One for your list of products, one for your list of categories and one for your list of subcategories.

PRODUCTS
--------

ProductID (Autonumber)
Title (Text)
Description (Memo)
Category (Number)
Subcategory (Number)

CATEGORY
--------

CategoryID (Autonumber)
Category (Text)

SUBCATEGORY
-----------

SubCategoryID (Autonumber)
SubCategory (Text)

Once you've got the database set up and some data in it you need to look at producing a basic list. Once you've done that you can add formatting, paging, searching and various other functionality.

There's a good site called with a load of examples for producing a basic list. Start with something very simple then build up from there.

Essentially the process runs as follows:

1. Establish a connection to the database.
2. Execute a SQL query and store the results in a recordset.
3. Loop through the recordset and display the data.
4. Close the connection to the database.

You should be able to do that in about 10 lines of code so don't bother cutting and pasting a 30-40 line example and try and make sense of it.

If you are not too familiar with SQL then there's a good site at
Good Luck!
 
Thank you so very much everyone for helping out.

I found this website
click on the live demo

and that is basically what I need I gave them a call but they want crazy money for it we are talking about 5grand plus $450 for monthly hosting. That stinks.

I will definetly will take a look at the websites that you guys have posted
Than you Damber, emozley, Bullschmidt
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top