Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Anyone have an idea on how to do this?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts
Posted - 30 April 2001 :  17:15:39  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
I am working on a shopping cart application for one of my business and would like to have it where each customer has a set price for a product. So with that in mind what would be the best way to do this?

Make a column in the users table for each product? (could be a ton of extra tables)

Have one extra column with the data seprated by a | or a ,?

Please give your input on what you think would be the best idea on this.

Brad

RaiderUK
Average Member

United Kingdom
577 Posts
Posted - 30 April 2001 :  18:55:08  Show Profile  Send RaiderUK a Yahoo! Message
could you not have a starting price for the product and the price then goes on a percentage discount held to the customer?
Go to Top of Page

PJamieson
Starting Member

United Kingdom
11 Posts
Posted - 01 May 2001 :  04:17:43  Show Profile  Visit PJamieson's Homepage
The advice from RaiderUK is probably the best although you will still have to store percentage discounts somewhere. An easy alternative is to provide a link table between the customer and product table which contains the CustomerID, ProductID, and Percentage Discount or Product Price for that customer. It should be pretty easy to implement alhtough it could be a huge table (with performance problems so some sort of indexing\optimistation should be considered), but it would work.
Go to Top of Page

RaiderUK
Average Member

United Kingdom
577 Posts
Posted - 01 May 2001 :  04:26:11  Show Profile  Send RaiderUK a Yahoo! Message
how i did it was to when a cutomer was entered was to enter a discount for them which was held in the customer table.
Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts
Posted - 01 May 2001 :  08:31:52  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
yea i was thinking that a discount would have to be the way. but the only thing that i see is a problem is that some stuff they would need to get more of a discount then other products.

maybe in the products table their is the price it costs me to make the product, and the retail price then in the customers table there is a % number that is taken in account for the difference in price so just for a quick example....


product 1
     my price - 4.99
     retail price - 5.49
     75% off price - 5.12
     50% off price - 5.24
     25% off price - 5.37

product 2
     my price - 4.99
     retail price - 9.49
     75% off price - 6.12
     50% off price - 7.24
     25% off price - 8.37


what about that idea?

Brad
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07