[ic] Multiple shipping tables based on affiliate

Dave Barr interchange-users@interchange.redhat.com
Tue Oct 9 11:59:03 2001


At 11:32 -0400 9/10/01, Mike Heins wrote:
>Quoting Mike Heins (mheins@redhat.com):
>>  Quoting Dave Barr (barrd@cricinfo.com):
>>  > (IC 4.6.5, Debian 2.2-17, MySQL 3.22, Perl 5.005-03)
>>  >
>>  > Hi People,
>>  >
>>  > I have a question regarding the feasibility of having different
>>  > shipping tables based on affiliates using the mv_pc=foo_shop1,
>>  > mv_pc=bar_shop2. I have created a site that has one database but many
>>  > different faces depending on the affiliate, up till now there was a
>>  > central fulfillment house but that has now changed and I need to
>>  > create different shipping tables for each affiliate.
>>  >
>>  > I should point out that I *do not* wish to have separate shops at
>>  > this time, this is part of a long term strategy that in the future
>>  > will allow the sharing of shops contents betwixt several shops using
>>  > a switch in the affiliates db so that they can be independent or part
>>  > of a mall.
>>  >
>>  > Order routing was easy enough to implement, but the shipping has got
>>  > me stumped, if any one has any suggestions / pointers that would help
>>  > kick start me off in the right direction I would be very very
>>  > grateful.
>>
>>  It's pretty easy, I think, and even documented.
>>
>>  You can do at the top of your checkout:
>>
>>      [if session source]
>>	[if type=file term="affiliate_shipping/[data session source].asc"]
>>	<--
>>	    Reading shipping from affiliate_shipping/[data session source].asc:
>>	    [shipping file="affiliate_shipping/[data session source].asc"]
>>	-->
>>	[/if]
>>      [/if]
>
>Oh, I should add that you need to do this once in every place where you
>want the special file to be read.
>
>What might be easier is to define a separate set of shipping modes
>for each affiliate and do that tranlation instead.

Ah, yes... of course - thanks Mike for the tip, I knew it would be 
easy(ish) but glad that you endorse this course -- I had come up with 
a couple of wacky schemes and glad I didn't waste weeks trying to 
implement them. Sorry I missed the mention in the dox, I thought I 
had thoroughly read them all -- obviously not :)
Cheers again
Dave
-- 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dave Barr        eCommerce Technical Manager      CricInfo Ltd
www.cricinfo.com   dave.barr@cricinfo.com    Tel: 01249 700748
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~