I'm glad you gave me comment on that so let me give you some details. I need to synch nopCommerce database (some tables of course) with a DB2 database which is IBM machine.
The problem doesn't end here. Tax and Shipping part will be processed on that end too. Phases I'm see are:
1) Importing customer information (from DB2) in nopCommerce so existing user can login so than they surf and add items to cart.
2) Since tax and shipping calculation will be processed on the main database so I will pass row orders from nopCommerce onto IBM machine. The problem is that online customers will NOT see final pricing till it get synchronized later (with delay).
Now, for those who know nopCommerce DB, what time line can I consider? (ball park) Also, which tables should I consider to make these changes?
I think that you better replicate the DB2 tax and shipping calculation info into NopCommerce DB(proper tax&shippong tables), so nopcommerce then can do the calculation and show result to the online users.