Do we tie many Orgs with Product or many Products to Org?
This is not so much about the data layout as much about the work flow.
If we tie many Orgs to Product then admins need to go in choose a Product and choose from a list all the Orgs that sell/have it. Or is it easier for them to many Products to ONE Org?
Either way I need to make a form that creates a menu system where they can choose or check many and tie it to ONE product.
So when users query the site for Strawberries the query uses and does not need to search two places for all the results that may overlap with out any check point.
For example if farmer john joins the site and adds strawberries to his farm how is the search engine support to know he is realted to the same Organization that CitySeed entered and therefore only show the strawberries ONCE?
So it is a concern that even though I create a page that allows CitySeed to enter Many to One that when members start to join the site they will not be able to clearly add products. IE there is no relation between them and the existing Org they represent AND there is no relation between them and existing products.
Right now using that MASQ there is a far greater chance to more easily relate the producer to his merchandise once he signs up.

The database part that becomes a concern is this.
City seed enters data into two places
One CiviCRM has Organizations
Two drupal has users who are tied to organizations
This makes it possible to more easily query the database and get results.

Otherwise we need a way for CitySeed admins to enter products and locations in a way that ties the two together.

How can producers ever edit this themselves?
How do we have them add products and search both databases?

I think in the log run the flow will go like this
As noted in previous emails Interns enter drupal user and masq as that user.
Make the Org
Add Products in bulk
Add Location in bulk
Use a temp email
Later with that Producer Requests a membership they will have a chance to request being attached to an existing Organization or make a new one.
Then a script will process their membership and if request attachment to an existing org City Seed will verify and add as drupal user attached to this Org via the RelationShip feature of CitySeed.
Looking at the Test-Many Products to One shows how easy it is to
add numerous GLOBAL products to ONE Organization
as long as they are connected to a drupal user.
-----------------------------------------------