[ic] One table, multiple vendors, product codes not unique

[interchange-users@lists.akopia.com]

On Tue, Jun 12, 2001 at 11:19:43AM -0600, John Beima wrote:
> Actually what we did was add the vender key to the product code to generate a
> unique sku... So it would be vender1-product1 for instance... Then you just use
> all the regular basket routines, except for one... When they are in each store,
> you put the items from that store in a cart named with the vender id... Hence
> the carts names will be vender1, vender2, and so on... When you hit the basket
> page, all products are grouped togeither in one big basket. Then when you hit
> the checkout page you, that page then lets them select which cart they wish to
> pay out seperately...
> 
> John Beima

Yes, we used to do it that way.  The issues we ran into were sometimes
using one code, other times using the other and having to account
for that.  Keeping the same code and just qualifying everything
by id makes it "flatter" and easier to maintain.

> 
> 
> Quoting cfm@maine.com:
> 
> > 
> > Re: One table, multiple vendors, product codes not unique
> > 
> > We've got a mall scenario with multiple vendors in same
> > tables and therefore we commonly have more than one
> > instance of an sku, say '1000'.
> > 
> > The unique key is not (sku) but instead it is (sku,id), 
> > where id is the vendor number and guaranteed
> > to be there.  We are using a custom price routine for 
> > now but would like to get rid of that for mainstream.
> > 
> > We assign our own unique keys and sku's but the mall 
> > vendors need to be able to link in with their own like:
> >   vlink.cgi/1234?merchant=my_store
> > And JOINs need to reference their codes.
> > 
> > Can newer versions (>4.03) stock mv/ic handle that?
> > 
> > I'm tempted to modify Table/DBI.pm to always include the
> > id key in queries or maybe to use Watch Points.  Can 
> > anyone share any thoughts on this?
> > 
> > cfm
> > 
> > -- 
> > 
> > Christopher F. Miller, Publisher                            
> > cfm@maine.com
> > MaineStreet Communications, Inc         208 Portland Road, Gray, ME 
> > 04039
> > 1.207.657.5078                                      
> > http://www.maine.com/
> > Content management, electronic commerce, internet integration, Debian
> > linux
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@lists.akopia.com
> > http://lists.akopia.com/mailman/listinfo/interchange-users
> > 
> 
> 
> 
> John Beima
> jbeima@palb.com, support@alocalagent.com, and support@alocalchurch.com
> 
> P.A.L.B. Systems - Phone: (780)451-1086 - Fax: (780)447-4760
> 11639-122 Street, Edmonton, Alberta, Canada, T5M 0B6
> 
> Affordable Web Pages - Phone: (888)932-9990 - Fax: (256)351-7297
> 2713B Spring Place SW, Decatur, Alabama, United States, 35603
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users

-- 

Christopher F. Miller, Publisher                             cfm@maine.com
MaineStreet Communications, Inc         208 Portland Road, Gray, ME  04039
1.207.657.5078                                       http://www.maine.com/
Content management, electronic commerce, internet integration, Debian linux