Alright guys, I need some help to make sure this is the best way to do this. We have a client selling furniture. Let's say we have the following example data set:
- sofa
- love seat
Then we have 3 fabrics
- red
- blue
- Gold
The sofa is $100 in any color, but gold. Gold is +$10
The love seat is $90 in any color, but gold. Gold is +$5
How should we setup our products?
Right now we are doing this:
Sofa - a Configurable with below simples: Sofa BLUE Sofa RED Sofa Gold (+10 on the associated tab.)
Love Seat - a Configurable with below simples: Love Seat BLUE Love Seat RED Love Seat Gold (+5 on the associated tab.)
What is happening is I fear we will eventually run into some scalability issues. Because while I gave 2 products and 3 fabric examples here - the real test case is slightly over 1,000 products and 100 fabrics.
Is this the best way considering that fabrics have varying prices based on which configurable they are attached to? If it's also important to know, we are using magento swatching as well to show the fabric swatch as a tile next to the add to cart button.
Thanks