Question
I am gathering pricing data for an e-commerce site that is dependent on the previous selection. For example:
Product selected (29 choices ) > type of coating (6 choices) > size (12 choices) > sides printed (3 choices- 4:0, 4:1, 4:4) > quantity (15 choices) > PRICE. Then, shipping (6 choices).
I know it seems pretty straightforward, but because it's a tedious job gathering all of the information, I don't want to find out there's a better way to do it or a better format when I hand the spreadsheet over to my developer. What do I need to be mindful of when gathering dependent data that will be dumped into a database and fuel an e-commerce site?
Answer
Hello,
My name is Erik and i'm a Senior Database Architect with more than 15 years of experience and I also have 10 years of experience managing programmers.
The best way to ensure data relations between your objects (Product selected, type of coating, etc) is the following: you should explain to the developer that you want a 100% dynamic parent/child associations between objects without any limits on associations between objects.
If you need more details and/or want to schedule a call, we can go over your business requirements and I can help you build the technical specs for your programmer. I am also available to develop the data structure that you need.
Regards,
Erik Hanley
