|
|
|
Be alerted to what's new for StoreFront Advanced
Tools
and Services
|
|
|
|
|
|
Streamlined Checkout™ Knowledge Base
Geo
Constraints
Overview
One of the more powerful features of
Streamlined Checkout™ and Streamlined
Shipper™ is the ability to apply geographic, or location
constraints to any standard or custom
shipping method. For example, some
merchants use UPS for domestic shipping but
prefer to use USPS for international
shipping because of shipping and custom
fees. Application of geo constraints
can limit UPS to domestic ship to addresses
and USPS International rates to
international ship to addresses. In
another example, a merchant might wish to
exclude FedEx 2nd Day Air to Alaska or
Hawaii. Geo constraints can be
configured at the state, country and zip
code levels.
USPS International Rates
For merchants who have enabled USPS
International Shipping through StoreFront™
Merchant Tools under the Carrier-based
shipping mode, all of these international
rate options will show during checkout in
the default StoreFront™ cart.
Merchants who have installed Streamlined
Checkout™ can implement our advanced
configuration option known as Alter Extended
Carrier Results to:
■
Hide USPS international shipping
rates that are not desired or supported
■
Modify the way these rates are displayed on
the shipping page
■
Adjust returned rates up or down by dollar
or percentage amounts
■
Additionally, Streamlined Checkout™
Geo constraints can be applied.
See the Streamlined Checkout
User Guide for
details on how to configure these advanced
options.
GEO Contraint Configuration
Geo constraints can be defined for Streamlined
Checkout™ custom
shipping methods as well as StoreFront™ standard Product, Value or Carrier based
shipping methods. To activate this feature,
complete the following steps:
a) Add the PENDX_LocationConstraints table
to your StoreFront™ database as follows:
i) MS Access:
(1) Open your database in Microsoft Access.
and click on .Tables. in the left navigation
bar.
(2) Right click in the white space of the
Microsoft Access. window and select .Import.
from
the
pop-up menu.
(3) Browse to the location of the unzipped
Streamlined Checkout. files and select the
CustomShip.mdb database.
(4) Select the PENDX_LocationConstraints
table and click the OK button. The
PENDX_LocationConstraints table has now been
added to your database.
ii) MS SQL Server
(1) Connect to your database with SQL Server
Enterprise manger or the SQL query tool of
your
choice.
(2) Execute the SQL script contained in the
PENDX_LocationConstraints.sql file, which
was
unzipped with Streamlined Checkout™ files.
The PENDX_LocationConstraints table has
now
been added to your database.
b) From within Streamlined Checkout™ Admin
page, add new records as necessary to
the
PENDX_LocationConstraints table as follows:
(note: the
PENDX_LocationConstraints table
is pre-populated with the data necessary to
constrain the standard StoreFront™ Product
and Value based shipping methods to
the
continental US. This is most often used for
constraining free shipping and backup
shipping methods.)
i) ShipMethodID
(1) This is the record key for the shipping
method to which the constraint
applies.
(a) PENDX Custom Shipping Methods:
(i) ShipMethodID must correspond to a value
in the keyID field of the
custom Shipping
table.
(b) StoreFront™ Product or Value based
shipping:
(i) ShipMethodID must be one of the
following values:
1. ValueBased = Value based shipping
2. ProdBased = Product based shipping
(c) StoreFront™ Carrier-based shipping:
(i) ShipMethodID must correspond to a value
in the MethodID field of
the carrier methods
table.
ii) Abbreviation
(1) This value represents the constrained
value, which should correspond to
the
Constraint Type as follows:
(a) 5 digit postal code
(b) State abbreviation (must correspond to a
state abbreviation within
the SelectState
table of the
StoreFront™ database).
(c) Country abbreviation (must correspond to
a country abbreviation
within the SelectCountry table of the StoreFront™
database).
iii) Country
(1) This value represents the country to
which the constraint is applied. Use a
valid
StoreFront™
country abbreviation.
(a) Note: If the constraint type of the ship
method is set to Country (3),
this value is
redundant
because it is already specified in the
Abbreviation field. However, it still must
be specified.
Was this KB article helpful?
Let us know at
support@streamlinedcheckout.com
return
to knowledge base
Digital Beach
Digital
Beach provides advanced Ecommerce and
Internet Marketing services to a wide range
of companies from small merchants to medium
and large corporate clients.
Digital Beach has been delivering Streamlined Checkout™
with the StoreFront™ cart as part of an overall
eCommerce solution to online merchants since
both products appeared on the market some three
years ago. Nearly two years ago, we
decided we liked
the product so much, we bought
the company.
More about Digital
Beach
|
|
|
|
|
|
|
