Mike:
Well, for $150 you can purchase CFWebstore from Mary Jo.
You get the new version 3.0 and full source CF
The Products table has a "Price" column.
So you could hack this to make a "Prices" table.
Then *all* you have to do is add a join to all
the existing queries (that need it) to get the right
price for the right client.
You could even download the free demo. You might
ask Mary Jo, [EMAIL PROTECTED] , if the demo will
enable you to see the queries you need to modify.
(I believe some of the demo is encrypted.)
best, paul
At 08:26 PM 8/4/00 +1000, you wrote:
>I have a prospective client who sells about 150 commodity products and
>wants to bring this on line and allow his mostly regular customers to
>place their daily orders order over the web and I'm scoping out the size
>of the job for me so I can price it.
>
>No problem so far.
>
>But his prices vary from customer to customer, based on the relative
>negotiation skills of the buyer and his sales people, and his supply prices
>of the moment. And there's no uniform discount for the customers (e.g.
>customer x gets 12.5% discount). So each customer needs to have a price
>set for each product.
>
>Is there a package shopping cart that will handle this wide flexibility in
>pricing? Or am I going to have to write my own?
>
>Cheers,
>Mike Kear
>AFP Web Development
>Windsor, NSW, Australia
>Mike Kear
>[EMAIL PROTECTED]
>www.afp.zip.com.au
>Windsor, NSW, Australia
>
>AFP Web Development
>AFP Electronic Forms
>AFP Models
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
