Is it possible to install 2 catalogs/stores on a domain, and have the following occur?:
1. 1st store reads from basic database as it is installed
2. 2nd store reads from 1st store database for all tables EXCEPT price field
In short the stores would have identical products but would allow 2 different pricing oprions for store owner.
If possible, what/where would I edit to just point price field of 2nd store to different table?
This would be for a USA store and Canada store...
dual pricing does not work for what we need for the client.