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

[John Beima]

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


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