[Typo3-shop] Feature: Linking shop to external db

[Ådne Hovda]

Hi

One of our clients has a Navision system with all their products in an 
MSSQL-db.

How can it be possible to fetch prices, in-stock status and other data 
from another database and integrate this into the product-listing?

Would the better solution be to be able to replace the price-field or 
maybe _any_ field from the tt_products table with a sql-query? (now, 
that would be nice...)

Since I'm not much of a programmer I think I might do a hardcoded 
version for this project. The best would naturally be to make a generic 
solution, if this of course is of any interest to other people than 
myself. After all, this scenario could be regarded a "special case".

What do you think?

Regards
Ådne