[ic] Shipping - flat rate

Dan Busarow interchange-users@interchange.redhat.com
Thu Feb 14 13:27:01 2002


On Feb 14, Michael Stearne wrote:
> Dan Busarow wrote:
> > On Feb 14, Michael Stearne wrote:
> > 
> >>I tried this:
> >>
> >>FLATD   Flat rate       quantity        0       0       e Nothing to 
> >>ship!              {'PriceDivide' => "1",}
> >>FLATD   Flat rate       quantity        1       4       6 
> >>{'PriceDivide' => "1",}
> >>FLATD   Flat rate       quantity        5       9999999 f f (@@TOTAL@@ * 
> >>6)     {'PriceDivide' => "1",}
> >>
> >>But if I put 20 items in a basket I get $120 for shipping.  It seems 
> >>like the formula part is never being used.
> >>
> > 
> > You have them backwards.  The rule for 20 pieces says to 
> > multiply 20 * 6 so 120 is correct.  The 5-99999 rule should have
> > the flat 30 value and the the rule for 1-4 should have the
> > formula
> 
> My fault.  So now it looks like:
> 
> FLATD   Flat rate       quantity        0       0       e Nothing to 
> ship!              {'PriceDivide' => "1",}
> FLATD   Flat rate       quantity        1       4       f (@@TOTAL@@ * 
> 6)       {'PriceDivide' => "1",}
> FLATD   Flat rate       quantity        5       9999999 30 
> {'PriceDivide' => "1",}
> 
> Still no luck though.  Quantity is getting multiplied by 6 all the time.

Try using a new database column as I suggested.  quantity is kind
of a magic field here.

Dan