price compare web site

[bejoy]

price compare web site
Hi, please help!!!!!!!!!!!

I am developing a web site for price comparison, but i am little bit confusion.

How can we identify a products wich contains more than one store.

ex. suppose the book "The No. 1 Ladies Detective Agency " is included in more than one store but how can we identify that.Is there any ID for products,

Categories are: books,computers,cloths,cars,mobiles etc..

Please help me ............

thanks...................

[teiz77]

price compare web site
Hi, please help!!!!!!!!!!!

I am developing a web site for price comparison, but i am little bit confusion.

How can we identify a products wich contains more than one store.

ex. suppose the book "The No. 1 Ladies Detective Agency " is included in more than one store but how can we identify that.Is there any ID for products,

Categories are: books,computers,cloths,cars,mobiles etc..

Please help me ............

thanks...................

You should work with a database. This database should contain multiple tables. Here is a simple example:

table: products
Structure: stores product id, product name, category id

table: categories
Structure: store category id, category name

table: stores
Structure: stores store id, store name

table: availability
Structure: stores availability id, product id, store id

With this structure you can link the multiple tables.
For example, the category id in the table products corresponds with the category id in the table categories.
And the table availability stores the links between the products and the stores. You can insert a row in this table for each product-store link.

[bejoy]

Thanks for you replay,

Actualy I want to develop a site like http://shopping.com, http://www.epinions.com/

As per your opinion products should be added by Site Super Admin itself right..,But I think in the above sites products added by dealers itself (By CSV or through dealer admin section ) OR do u think the products are adding by super admin and dealers can only put there on pictures and prices and other related informations.

Thank you once again for your replay and waiting for your kind replay.

Help me asap.

[teiz77]

Thanks for you replay,

Actualy I want to develop a site like http://shopping.com, http://www.epinions.com/

As per your opinion products should be added by Site Super Admin itself right..,But I think in the above sites products added by dealers itself (By CSV or through dealer admin section ) OR do u think the products are adding by super admin and dealers can only put there on pictures and prices and other related informations.

Thank you once again for your replay and waiting for your kind replay.

Help me asap.

don't underestimate the impact of having other users administer parts of your website. Your system needs to be more secure. I think you should enter the products. This because you to compare prices to the same products. What if a store makes a typo? Then you have different products in your database, products that are actually the same. Just for your consideration.

[bejoy]

Thanks For your replay,

I will Create an account on any price comparison site to study the functionalities in detail. And also i am always welcomes your valuable ideas and opinions.
ok
thx