Addresses

A user account comes with a set of standard address fields – and in some cases this is enough – but additional addresses can be created for a user when necessary.

This can happen in several ways:

  • From frontend via an instance of the Extranet app in Manage addresses mode
  • From the backend using the built-in Addresses view on a user account
  • As a part of an integration setup where user accounts and addresses are imported from an external system to the AccessUserAddresses table

In frontend you can then make the various addresses available for selection in the shopping cart during checkout.

To add additional addresses to a user account from backend:

  1. Open the user account details
  2. Click the Addresses button to switch to the address list (Figure 1.1)
Figure 1.1 The addresses view
  1. Click Add address in the toolbar to open the Edit address view (Figure 1.2)
Figure 1.2 Address fields

As you can see, you have access to a number of standard address fields – they work in exactly the same manner as the corresponding standard user field does.

You also have the option of adding custom address fields.

Custom address fields are used to hold information for which there is no standard field – pretty simple, actually. This can be necessary when working with address data from a region with a different standard address format than the one natively employed by Dynamicweb.

Custom address fields are created by navigating to Settings > Control Panel > Users and clicking Edit custom address fields (Figure 2.1)

This opens the custom address fields view (Figure 2.2) from where you can add new custom fields and specify a name, a system name, and a field type.

Figure 2.2 Custom address fields

Addresses are stored in the AccessUserAddress-table - this does not contain the address stored in the user standard fields.

AccessUserAddress

For users with multiple defined addresses extra addresses are defined here and linked via AccessUserId.

Field name Data type Length
AccessUserAddressId int 4
AccessUserAddressUserId int 4
AccessUserAddressType bit 1
AccessUserAddressCallName nvarchar 255
AccessUserAddressCompany nvarchar 255
AccessUserAddressName nvarchar 255
AccessUserAddressAddress nvarchar 255
AccessUserAddressAddress2 nvarchar 255
AccessUserAddressZip nvarchar 255
AccessUserAddressCity nvarchar 255
AccessUserAddressCountry nvarchar 255
AccessUserAddressPhone nvarchar 255
AccessUserAddressCell nvarchar 255
AccessUserAddressFax nvarchar 255
AccessUserAddressEmail nvarchar 255
AccessUserAddressCustomerNumber nvarchar 255
AccessUserAddressUId nvarchar 50
AccessUserAddressState nvarchar 255
AccessUserAddressIsDefault bit 1
AccessUserAddressExported datetime 8
AccessUserAddressPhoneBusiness nvarchar 255
AccessUserAddressDefaultAddressCustomFields bit 1
AccessUserAddressCountryCode nvarchar 2