Shipping

Customers are a funny lot. If you sell them something, they seem to expect that they can have their item(s) delivered somewhere. What a bother, eh?

But fear not! Dynamicweb Ecommerce supports integrating with several popular delivery services, such as Post Danmark, GLS or FedEX, by setting up one or more shipping methods.

Setting up shipping in Dynamicweb Ecommerce consists of:

  • Creating a new shipping method
  • Selecting and configuring a shipping provider
  • Configuring the matching delivery service

In this article, you can read about creating and configuring a new shipping method in Dynamicweb on a general level.

Additionally, each shipping provider provided by Dynamicweb comes with a dedicated how-to outlining the setup process for that particular provider.

To create a new shipping method:

  • Go to Settings > Ecommerce > Orders > Shipping
  • Click New shipping in the toolbar (Figure 2.1)
Figure 2.1 Creating a shipping method

This opens the shipping method window (Figure 2.2).

Figure 2.2 The shipping method window

From here, you can:

  • Name the shipping method – and optionally provide it with a description and an icon
  • Select one or more countries that the shipping method should be available for
  • Set a default fee if the provider does not return a value, and perhaps an order amount which will result in no shipping fee being charged
  • Finally, select a shipping provider

When selecting a shipping provider, you can choose between selecting the default provider – Fee Rules – which allows you to define shipping fee rules and handle them on the Dynamicweb side of things, or an external shipping provider.

To calculate fees based on the delivery country instead of the billing country, see the settings in advanced configuration.

Some shipping providers – e.g. FedEx – return a shipping fee based on shipping fee parameters, such as service type, weight and size.

Some, however, don’t.

And for those we have the Fee Rules matrix (Figure 4.1), with which, you can assign shipping fees to orders based on various criteria, e.g. weight, volume, and so forth.

Alternatively, if you prefer to handle shipping on your own – or if you use an external delivery service not supported by Dynamicweb – you can use the Fee Rules matrix on its own with no shipping provider.

Figure 4.1 The Fee Rules Matrix

To configure the fee rules matrix:

  • Activate it by selecting Use custom fee rulesor deactivate it by selecting Use fee rules from provider
  • Set it to use either the lowest or the highest applicable fee
  • Decide if both weight and volume must apply for a rule to trigger, or if either weight or volume is enough
  • Create fee rules appropriate to your scenario
  • Show/Hide categories by right-clicking the category bar

To create a fee rule, click the Click here to add a new row text to open the rule-window (Figure 4.2).

Figure 4.2 Creating a fee rule

From here, you must:

  • Name the rule and activate/deactivate it (as appropriate)
  • Specify a timespan during which the rule is valid (can be triggered)
  • Specify a fee – and a fee type (amount or percentage), as well as any weight and volume limits – e.g. 5% for orders below 10”x10”x10” under 10lb

You can also create rules limited to triggering for:

  • Certain users, user groups or a particular customer number
  • Certain shops, products or product groups
  • Orders above a certain total price, or in a particular order context, country/region, currency or zip code

You need only create only the rules relevant for your shipping setup – so in reality, you won’t need to use all the options in the rules window but only those relevant for your setup.

In addition to the Fee Rules shipping provider, Dynamicweb provides a number of shipping providers integrating with external delivery services, such as GLS and FedEx.

Name

Database

These are the database tables associated with Shipping and related features in Dynamicweb:

EcomShippings

Contains setup and localization data (ShippingLanguageId) for shipping methods as defined in Settings -> Ecom -> Orders -> Shipping.

Field name Data type Length
ShippingId nvarchar 50
ShippingLanguageId nvarchar 50
ShippingName nvarchar 255
ShippingDescription nvarchar Max
ShippingPriceOverMaxWeight float 8
ShippingFreeFeeAmount float 8
ShippingServiceSystemName nvarchar Max
ShippingServiceParameters nvarchar Max
ShippingSorting int 4
ShippingAutoId int 4
ShippingFeeSelection nvarchar 10
ShippingIcon nvarchar 255
ShippingLimitsUseLogic int 4
ShippingFeeRulesSource int 4

EcomFees

Contains matrix setup details for Settings -> Ecom -> Orders -> Payment and Settings -> Ecom -> Orders -> Shipping linked via FeeMethodId.

Field name Data type Length
FeeId nvarchar 50
FeeMethod nvarchar 50
FeeMethodId nvarchar 50
FeeValue float 8
FeeType smallint 2
FeeWeightLimit float 8
FeeVolume float 8
FeeCountryId nvarchar 50
FeeRegionCode nvarchar 3
FeeOrderPrice float 8
FeeAutoId int 4
FeeName nvarchar 255
FeeActive bit 1
FeeValidFrom datetime 8
FeeValidTo datetime 8
FeeAccessUserId int 4
FeeAccessUserGroupId int 4
FeeAccessUserCustomerNumber nvarchar 255
FeeShopId nvarchar 255
FeeProductsAndGroups nvarchar Max
FeeOrderContextId nvarchar 50
FeeCurrencyCode nvarchar 3
FeeZip nvarchar Max

EcomCustomersSettings

Links a user (AccessUserId) with preferred currency, payment method and shipping method (CurrencyCode, PaymentMethodId, ShippingMethodId).

Field name Data type Length
SettingId int 4
AccessUserId int 4
PaymentMethodId nvarchar 50
ShippingMethodId nvarchar 50
CurrencyCode nvarchar 3