Different price per customer not per customer group

[nikpony]

Hello people,
i have a very important request from one of my customers.
We use VM 2 in Joomla 2.5 and he needs to have the ability to set different price per customer.
In other words, i.e. if we have a product A and his standard price is 10 euro, he wants customer with VAT number 0123456789 when login the site to see this product with price 7 euros and customer with VAT number 445512348 to see this product with price 8 euros.

Is it possible to be developed from someone or is an extension available?
If somebody can do it let send me a message and we will discuss about the price etc.

I hope that someone will reply here or in PM and sends me costs and time of developing.

Thank you! I am waiting...

[GJC Web Design]

afaik there is no limit on the number of shopper groups - why not just add each indvidual to their unique shopper group and handle it that way?

[nikpony]

Hello and thanks for your reply!
I can't do it because the amount of discount is not fixed. A customer may has discount of 30 % for product A and 15 % for product B. So if i had to create different customer groups i should create 100 different groups per customers. Our customers are approximately 300 so i would have to create 30000 different customer groups!

[GJC Web Design]

So what is the schema requirements?
Every user has their own set of prices for every product?

[nikpony]

Exactly my friend...a little bit chaotic but this is the request!

[GJC Web Design]

anything is do-able - but I assume you realise what a large job this  - and the amount of data and admin needed..

construct a component to admin this

basically interupt the whole core pricing of VM
find the required price from 30000 records
display
make sure this price is the one submitted to cart with any global taxes and discounts, coupons etc
ensure in checkout this price is used and manipulated by taxes, global discounts, shipping added etc
ensure that this price is passed to any payment gateways and that the validation of the payment is checked against this price
ensure this price is used in all invoicing, emails and admin

makes 30000 shopper groups look a doddle

[nikpony]

Yes my friend i have already think about all of these parameters and i have a mini headache!
So, if finally i will decide to create 30000 shopper groups (first of all VM has the specifications to support this number of groups?) how can i do it with a batch method???

[GJC Web Design]

standard imports to '#__virtuemart_product_prices, '#__virtuemart_shoppergroups & #__virtuemart_vmuser_shoppergroups by what ever means you deem the best

What ever way you do it you have to make 30000 entries some how