Questions

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?

I'm a developer of over 20 years experience and I've been building relational databases the whole time with varying degrees of normalization. I like it best when the problem is given to me as you stated above.

From your statement, it seems like you are trying to design the database. Instead, you hired a developer, and that is what they do. Have him or her design the database. Give them all the information you have and answer all their questions in a timely manner and you'll get what you need.

I'm not sure of your area of expertise or the relationship with and faith you have in your developer, but I would provide him the information from your question above. From that he/she should fire back a bunch of questions to you such as:
1. does every product require every choice?
2. Can a product have multiple options for a given choice?
3. Are the options for choices different dependent on the product?
4. Is there a higher level to consider of product categories?
... I think you get the idea.
Using this dialog can help you both think of concepts or situations you both have missed and provide you with a more robust solution.

I'd be happy to get on a call with you to discuss this further but it sounds like you have everything you need except maybe confidence in your developer(s). Best of luck.


Answered 8 years ago

Unlock Startups Unlimited

Access 20,000+ Startup Experts, 650+ masterclass videos, 1,000+ in-depth guides, and all the software tools you need to launch and grow quickly.

Already a member? Sign in

Copyright © 2024 Startups.com LLC. All rights reserved.