I've looked and looked. appears to be no answer yet for dual pricing the way I need it.

The client site I am doing is a car parts site. he wants canadian pricing and USA pricing. he wants dollar amts, not percentage difference/exchange rates etc.

Anyway what I am thinking of doing is...

create a 2nd install of the software for the canadian store but edit the includes/config.php to point to the original store software as he's already added product to it.
then on the canadian install, edit the software so that the price field points to the 2nd store database price field only

in other words:
USA store - all files/database stays in tact
CANADA store - uses USA store descriptions and images...all but price and by editing files it can use the 2nd install price field only.

is this possible, and/or clear?

if so. what files would I have to edit to have the 2nd install point to a different price field than the USA install.

I'm confusing myself.
thanks.
~Rick