[ic] shipping voo-doo challenge question (a solution!)

Mark Stosberg mark@summersault.com
Thu, 15 Mar 2001 12:29:04 -0500


cfm@maine.com wrote:
>
> > " Use a flat rate shipping price based on quantity with price breaks at
> > 1 and 10, but exclude any items in the quantity count that have a true
> > value in the 'download' column in the products table".
>
> Maybe I'm missing something:
> 
> shipping.asc
> uspsp   USPS Priority   shipping_charge 0.01    9      5.99
> uspsp   USPS Priority   shipping_charge 9.01    99999  10.99
> 
> CustomShipping  quantity

Christopher,

   Thanks so much. I was able to get this working with your help. I
added a new column to my products.txt file and set the value to "1" for
every item except the shipping-free items. I created a schipping.asc
entry like this:

##############
0	No shipping	weight	0	99999999	e No shipping mode selected.		
ssp	Soft Skull	shipping_charge	1	9	30
ssp	Soft Skull	shipping_charge	10	99999	10
ssp	Soft Skull	quantity	0	0	e	Nothing to Ship.
####################

I wasn't exactly sure how the min and max values were functioning, but
I'm guessing they work like this: For all the items in the order, the
values in the "shipping charge" column are totalled. If that value is in
between the min and max, the resulting shipping price is given. 

  -mark

personal website             }      Summersault Website Development
http://mark.stosberg.com/    {      http://www.summersault.com/