I'm trying to figure out the best way to output data and effectively create relationships between a product and it's availability based on the enduser's location.
I'm building a site for consumers of local seasonal vegetables and produce. Basically what would happen is that a user comes to the site and chooses a State via drop down menu, based on their choice, it then populates another form field for cities in that state where local seasonal vegetables and produce are available, the user picks a city and a list of available items gets generated. Then you can click on the item [for this case I'll use broccoli], and it gives you information about that item such as nutritional value, growing season, climate, etc.
Sounds pretty simple, I know. But here's where I'm struggling in figuring out how to create relationships and filter data. For example, on the backend I have listing channel for vegetables that lists all the vegetables available in, say - California, Oregon and Washington for that season. Local organic broccoli is currently available in Seattle WA, Portland OR and Sacramento CA. I need to have broccoli associated with each state, then subsequent city that it's available in. Currently, I have Tagger tags on broccoli for all 6 of those locations, but after further thought, I'm not sure this is a good way to do this because ultimately I'd like to have the farmers markets the broccoli is available in to be dynamically listed on the broccoli page based on the users choices from the drop-downs from the previous page location as well.
I'm not necessarily a newb with EE, but I've not done anything like this before and I'm not sure if there are existing add-ons that would help me do what I'm trying to do, or if I've just got to figure out a way to tie these things together and generate the proper output. I'm a frontend developer trying to figure out how to create relationships with data - not really in my wheelhouse...
If anyone has suggestions, thoughts, advice in how I can properly and effectively create these relationships to output them correctly and have subsidiary data associated with a location [such as markets] tied to the process…it would be immensely appreciated!
Thanks for taking a look at my problem!