[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] Any thoughts on how to implement this...
If each client has his own products, I don't know.
If the products are standards and the price personnalized, I propose this
solution that I'm using.
Define in your products database standard prices, and make another db with
discounts. The key must identify an item for a client and could be for ex.
"custommer_itemcode". The discount can be in any format recognized by
minivend. When listing the products, foreach article, make a query who find
the discount apropriate for this client and print that on screen. The
discount modify the price and your work is done. I made like that and it works
Nathan
At 14:06 1/12/99 -0500, you wrote:
>****** message to minivend-users from Dan Mostert <dan@delhitel.com>
******
>
>Hello All,
> First off, thanks to those who replied to my SQL quandaries. I've
>got that working now, and it's way cool. (Turned out to be a
>permissions problem all along.)
> We've got a client who wants a catalog for his wholesale type
>business, and he only wants to sell to his current "real life"
>customers, not to just anyone who happens upon the store. He also has a
>different pricing structure for every single customer. This is not a
>standard Price Adjust type arrangement, as he doesn't form prices by any
>specific percentage/quantity purchased. Therefore, every customer needs
>to have their own products database. This means we are looking at
>300-400 customers with nearly 5000 product prices for each of them.
>(Hence, my reason for wanting to get SQL running). Of course, customer
>"A" should never see customer "B"'s prices, which I'm guessing can be
>accomplished with log ins for everyone.
>
> So, anyone ever had to do anything like this? I'm open to
>suggestions...
>
> Thanks,
> Dan
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to
Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
