<%@ Language=VBScript %> <% '************************************************************************* ' DO NOT MODIFY THIS SCRIPT IF YOU WANT UPDATES TO WORK! ' Function : Shipping Method Maintenance ' Product : CandyPress Store Administration ' Version : 2.5 ' Modified : February 2004 ' Copyright: Copyright (C) 2004 CandyPress.Com ' See "license.txt" for this product for details regarding ' licensing, usage, disclaimers, distribution and general ' copyright requirements. If you don't have a copy of this ' file, you may request one at webmaster@candypress.com '************************************************************************* Option explicit Response.Buffer = true const adminLevel = 1 %> <% 'Database dim mySQL, cn, rs, rs2 'ShipMethod dim idShipMethod dim shipDesc dim status '************************************************************************* 'Open Database Connection call openDB() 'Store Configuration if loadConfig() = false then response.redirect "sysMsg.asp?errMsg=" & server.URLEncode("Could not load Store Configuration settings.") end if 'Set Row Colors dim rowColor, col1, col2 col1 = "#DDDDDD" col2 = "#EEEEEE" %>

Shipping - Store Method Maintenance

<% 'Page Tabs call shipTabs("CM") if len(trim(Request.QueryString("msg"))) > 0 then %> <%=Request.QueryString("msg")%>

<% end if %>
Add Shipping Method

<% rowColor = col1 %> <% rowColor = col2 'Retrieve all Shipping Methods mySQL="SELECT * " _ & "FROM ShipMethod " _ & "ORDER BY shipDesc" set rs = openRSexecute(mySQL) do while not rs.eof %> <% rs.movenext 'Switch Row Color if rowColor = col2 then rowColor = col1 else rowColor = col2 end if loop %> <% call closeRS(rs) %>
 
ID Description Status  
<%=rs("idShipMethod")%> <%=rs("shipDesc")%>  <%=rs("status")%>  [ ">edit ] ">
Delete Selected Shipping Methods?

Help and Instructions :
Overview - Store Shipping Methods are used to group together a common set of Store Shipping Rates. Store Methods and Rates are defined by you, and will therefore be stored and retrieved directly from your database. For example, you can create a Store Shipping Method called 'FedEx Ground', and then create your own unique set of Store Shipping Rates for the 'FedEx Ground' Shipping Method.

A Shipping Method will also be applied to one or more Shipping Zones (Zones are set up using the 'Locations Maintenance' function). Each Shipping Method/Zone combination will have it's own unique set of Shipping Rates.

Example :
  • FedEx Ground
    • USA & Canada (Zone 1)
      • Shipping Rates based on total Order Amount
        • $000.00 to $100.00 -> add $10.00 to order
        • $100.01 to $200.00 -> add $15.00 to order
        • $200.01 to $500.00 -> add $20.00 to order
        • etc.
      • Shipping Rates based on Order Weight (Pounds, Kilograms, etc.)
        • 00 to 10 -> add $12.50 to order
        • 11 to 20 -> add $14.50 to order
        • 21 to 30 -> add $17.00 to order
        • etc.
    • Europe (Zone 2)
      • Shipping Rates based on Order Weight (Pounds, Kilograms, etc.)
        • 00 to 10 -> add 10.00% to order
        • 11 to 20 -> add 12.50% to order
        • 21 to 30 -> add 15.00% to order
        • etc.
<% call closedb() %>