I am quite new to Sitefinity, so forgive me if this is an obvious question.
At a basic level I am trying to use the ecommerce module to drive a global product catalogue. In my case the products are pharmaceuticals with lots of custom fields.
What isn't so basic is that I am wanting to integrate the product entry into other databases that are driven through our enterprise supply chain .
There are databases within our company that tell me which products have regulatory approval in each country, and in what strength.
What I want to do is dynamically adjust the master data shown within the product editor in Sitefinity so that each country can choose from a customized list of products they want to sell, and in what strength. (Just because we have regulatory approval to sell a drug in a given market doesn't necessarily mean that we want to ... so each country chooses which drugs they want to sell)
To ensure that data is consistent, I want to use the data from our regulatory approval database to drive the available selections within the new product creation in Sitefinity. For example,
Lets say a particular country wanted to add Ibuprofen to their product catalogue. They would go into the backend of Sitefinity's ecommerce section and start creating a new product of type "Drug". The editor for this drug type would first determine what country the user is from (through their account) and then query our regulatory database and see what drugs are available to sell in that market. These approved drugs would then appear in a drop-down list inside the editor. If they selected Ibuprofen, the editor would then re-query the regulatory database to populate other fields within the editor such as "Strength", so that only approved strengths are available for the user to select.
I know this is going to require some backend coding because I don't think sitefinty offers this kind of data-driven dynamic editing out of the box.
I am just wondering if anyone has attempted something like this before, and whether they can point me in the direction of some good resources to help guild me.
Is it even worth trying to customize Sitefinity's ecommerce site to try and make it work this way, or should I just write a completely custom widget?
Many thanks for any advice you may have.