[ic] shipping question

Ed LaFrance interchange-users@interchange.redhat.com
Fri Nov 16 12:07:01 2001


At 06:33 PM 11/15/2001 -0600, you wrote:

>hello list -
>
>
>i'm lost.. :(
>
>
>I'm trying to figure out how to calculate shipping based on an SKU number.
>i've looked at the shipping.asc file but it just got more confused.
>
>we use a specific SKU scheme, kinda like this:
>
>10XXXXX - shipping is $25
>20XXXXX - shipping is $20
>90XXXXX - shipping is $5
>
>
>is there an easy way to do this?

Well, fairly easy. Add a column called 'flat_ship' to your products table, 
and populate it with the shipping charge for each item.  Then modify 
shipping.asc, adding your new mode.  It should look something like this (-> 
= TAB):

peritem -> Standard shipping -> flat_ship -> 0 -> 99999 -> f @@TOTAL@@

sorry, I just don't use the shipping interface in the UI, so I honestly 
can't tell you how to create it that way, but I am sure it is quite easy.

Finally, add the new shipping mode to the appropriate records in your 
country table, and Apply Changes.

- Ed L.



===============================================================
New Media E.M.S.               Software Solutions for Business
463 Main St., Suite D          eCommerce | Consulting | Hosting
Placerville, CA  95667         edl@newmediaems.com
(530) 622-9421                 http://www.newmediaems.com
(866) 519-4680 Toll-Free       (530) 622-9426 Fax
===============================================================