Custom Discounts..?

[elogicmedia]

My Client needs a feature within oscommerce that automatically connects to another database, finds out if they are a website subscriber, if they are they get a discount on certain products and this needs to happen automatically.

 

I have all of this working and I am now working on the order confirmation page where I need to modify the totals at the bottom of the page.

 

The best way for me to explain is to show you so I have done a screenshot

 

 

 

You will notice the the products price has been edited and is now showing the discounted price ($19.95 - 5% = $18.95)

 

However in the subtotal and total it is still displaying the original price ($19.95)

 

Where in the code can I edit this so it reflects the new discounts?

 

Thankyou!

[kbakba]

The contribution Separate Pricing Per Customer would work for you.

[elogicmedia]

Thanks Kbakba but I'm not sure it is what I am after.

 

Anyway I have been looking into it more and it seems that the sub total and total etc are stored within the orders_total table but where are the coming from before the order is complete, i.e. on the checkout_confirmation.php page...?

 

Thankyou