In Magento 1.9 , please consider this problem.
One Jersey with different colors and sizes is manifested as a Configurable in my System. (For example, with Colors: REd,Blue,Green and Sizes : AS,AM,AL,AXL)
So JERSEY-RED-AM is a Simple product in the System that can be chosen from the configurable in the website.
But for me, JERSEY-RED-AM is supplied by different sources. And they have different pricing . So I catalog them internally as different SKUS. JERSEY-RED-AM : SKU1 - $10.50 JERSEY-RED-AM : SKU2 - $12.00 JERSEY-RED-AM : SKU3 - $13.00
I'd like to sell the SKU1 first as part of the configurable, then when that runs out of stock, automatically add the SKU2 to the configurable .
Is this even possible? How can I use Magento to solve this problem? is it possible to do this without custom coding? Any pre-existing extensions? If custom code, any ideas on how to approach this?