[ic] Multiple vendors posible solution.

Duane Hinkley duane at downhomewebdesign.com
Fri Feb 25 07:49:22 EST 2005

daniel castro wrote:

> Hi list,
> I was thinking for a way to have multiple suppliers, have a functional 
> single store front, and each supplier be able to upload products 
> without seeing the other suppliers products.
> Using any relational database you can have one table per supplier then 
> define a view for the products, that way it is invisible for IC the 
> supplier table, IC only is able to see the products table (view), then 
> define rules for update, and insert, in a way that depending in the 
> primary key (sku) the product is placed in the apropiate supplier table.
> Define users in the admin, that can access only one supplier table, 
> that way each supplier can upload their products, and manage them 
> without knowing there are other suppliers.
> Any commments, drawbacks?
> Daniel Castro.
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

Here's an approach that may work.  Add a column to the products table to 
store the username of the person that added the products.  Then modify 
the pages to add, view and edit the products, to only show the products 
where the username field matchs the username of the person logged in.

That way each person will only see what they added. 



Duane Hinkley
Down Home Web Design, Inc.
(208) 424-0572 Fax(208) 587-0738

duane at downhomewebdesign.com

More information about the interchange-users mailing list