[ic] Shipping - flat rate

Michael Stearne interchange-users@interchange.redhat.com
Thu Feb 14 13:45:00 2002


Dan Busarow wrote:
> 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.
> 

So instead of using quantity I should just replace that with 
freight_unit?  Is that the only change I need to make?

Thanks again,
Michael


> Dan
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users
> 
> 
>